1 |
31.81 ms |
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.stats_id AS stats_id_27 FROM place t0 WHERE t0.zip_code = ?
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.stats_id AS stats_id_27 FROM place t0 WHERE t0.zip_code = '12084';
|
2 |
0.29 ms |
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10 FROM stats t0 WHERE t0.zone = ? LIMIT 1
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10 FROM stats t0 WHERE t0.zone = '12084' LIMIT 1;
|
3 |
0.15 ms |
"START TRANSACTION"
"START TRANSACTION";
|
4 |
0.25 ms |
UPDATE stats SET completion_percent = ?, places_count = ?, avec_horaires = ?, avec_adresse = ?, avec_site = ?, avec_accessibilite = ? WHERE id = ?
Parameters: [
0
0
0
0
0
0
599
]
UPDATE stats SET completion_percent = 0, places_count = 0, avec_horaires = 0, avec_adresse = 0, avec_site = 0, avec_accessibilite = 0 WHERE id = 599;
|
5 |
0.64 ms |
"COMMIT"
|
6 |
0.44 ms |
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.stats_id AS stats_id_27 FROM place t0 WHERE t0.stats_id = ?
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.stats_id AS stats_id_27 FROM place t0 WHERE t0.stats_id = 599;
|
7 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
8 |
0.23 ms |
UPDATE stats SET completion_percent = ?, places_count = ?, avec_horaires = ?, avec_adresse = ?, avec_site = ?, avec_accessibilite = ? WHERE id = ?
Parameters: [
25
33
16
10
9
7
599
]
UPDATE stats SET completion_percent = 25, places_count = 33, avec_horaires = 16, avec_adresse = 10, avec_site = 9, avec_accessibilite = 7 WHERE id = 599;
|
9 |
0.20 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1697467152"
517760
]
UPDATE place SET osm_id = '1697467152' WHERE id = 517760;
|
10 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"2211363274"
517761
]
UPDATE place SET osm_id = '2211363274' WHERE id = 517761;
|
11 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"3693550801"
517762
]
UPDATE place SET osm_id = '3693550801' WHERE id = 517762;
|
12 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4482453781"
517763
]
UPDATE place SET osm_id = '4482453781' WHERE id = 517763;
|
13 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4490969185"
517764
]
UPDATE place SET osm_id = '4490969185' WHERE id = 517764;
|
14 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4864473914"
517765
]
UPDATE place SET osm_id = '4864473914' WHERE id = 517765;
|
15 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4864474226"
517766
]
UPDATE place SET osm_id = '4864474226' WHERE id = 517766;
|
16 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4864474250"
517767
]
UPDATE place SET osm_id = '4864474250' WHERE id = 517767;
|
17 |
0.20 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4864474260"
517768
]
UPDATE place SET osm_id = '4864474260' WHERE id = 517768;
|
18 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4864474261"
517769
]
UPDATE place SET osm_id = '4864474261' WHERE id = 517769;
|
19 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4864474282"
517770
]
UPDATE place SET osm_id = '4864474282' WHERE id = 517770;
|
20 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"7089761343"
517771
]
UPDATE place SET osm_id = '7089761343' WHERE id = 517771;
|
21 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12025596673"
517772
]
UPDATE place SET osm_id = '12025596673' WHERE id = 517772;
|
22 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12025634203"
517773
]
UPDATE place SET osm_id = '12025634203' WHERE id = 517773;
|
23 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12083511044"
517774
]
UPDATE place SET osm_id = '12083511044' WHERE id = 517774;
|
24 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12106054501"
517775
]
UPDATE place SET osm_id = '12106054501' WHERE id = 517775;
|
25 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12390085879"
517776
]
UPDATE place SET osm_id = '12390085879' WHERE id = 517776;
|
26 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12841608327"
517777
]
UPDATE place SET osm_id = '12841608327' WHERE id = 517777;
|
27 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12861475415"
517778
]
UPDATE place SET osm_id = '12861475415' WHERE id = 517778;
|
28 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79895598"
517779
]
UPDATE place SET osm_id = '79895598' WHERE id = 517779;
|
29 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79896057"
517780
]
UPDATE place SET osm_id = '79896057' WHERE id = 517780;
|
30 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79896193"
517781
]
UPDATE place SET osm_id = '79896193' WHERE id = 517781;
|
31 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79896233"
517782
]
UPDATE place SET osm_id = '79896233' WHERE id = 517782;
|
32 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79896497"
517783
]
UPDATE place SET osm_id = '79896497' WHERE id = 517783;
|
33 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79896774"
517784
]
UPDATE place SET osm_id = '79896774' WHERE id = 517784;
|
34 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79896864"
517785
]
UPDATE place SET osm_id = '79896864' WHERE id = 517785;
|
35 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79896923"
517786
]
UPDATE place SET osm_id = '79896923' WHERE id = 517786;
|
36 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"262219817"
517787
]
UPDATE place SET osm_id = '262219817' WHERE id = 517787;
|
37 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"759047397"
517788
]
UPDATE place SET osm_id = '759047397' WHERE id = 517788;
|
38 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"759047398"
517789
]
UPDATE place SET osm_id = '759047398' WHERE id = 517789;
|
39 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"759047399"
517790
]
UPDATE place SET osm_id = '759047399' WHERE id = 517790;
|
40 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"759049462"
517791
]
UPDATE place SET osm_id = '759049462' WHERE id = 517791;
|
41 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"759049463"
517792
]
UPDATE place SET osm_id = '759049463' WHERE id = 517792;
|
42 |
0.49 ms |
"COMMIT"
|