1 |
37.33 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 = '79034';
|
2 |
0.37 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 = '79034' LIMIT 1;
|
3 |
0.12 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
562
]
UPDATE stats SET completion_percent = 0, places_count = 0, avec_horaires = 0, avec_adresse = 0, avec_site = 0, avec_accessibilite = 0 WHERE id = 562;
|
5 |
0.50 ms |
"COMMIT"
|
6 |
0.49 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 = 562;
|
7 |
0.13 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: [
21
53
27
4
20
4
562
]
UPDATE stats SET completion_percent = 21, places_count = 53, avec_horaires = 27, avec_adresse = 4, avec_site = 20, avec_accessibilite = 4 WHERE id = 562;
|
9 |
0.20 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1052465001"
492518
]
UPDATE place SET osm_id = '1052465001' WHERE id = 492518;
|
10 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964860"
492519
]
UPDATE place SET osm_id = '1356964860' WHERE id = 492519;
|
11 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964861"
492520
]
UPDATE place SET osm_id = '1356964861' WHERE id = 492520;
|
12 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964864"
492521
]
UPDATE place SET osm_id = '1356964864' WHERE id = 492521;
|
13 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964865"
492522
]
UPDATE place SET osm_id = '1356964865' WHERE id = 492522;
|
14 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964866"
492523
]
UPDATE place SET osm_id = '1356964866' WHERE id = 492523;
|
15 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964867"
492524
]
UPDATE place SET osm_id = '1356964867' WHERE id = 492524;
|
16 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964868"
492525
]
UPDATE place SET osm_id = '1356964868' WHERE id = 492525;
|
17 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964869"
492526
]
UPDATE place SET osm_id = '1356964869' WHERE id = 492526;
|
18 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964870"
492527
]
UPDATE place SET osm_id = '1356964870' WHERE id = 492527;
|
19 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964871"
492528
]
UPDATE place SET osm_id = '1356964871' WHERE id = 492528;
|
20 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964872"
492529
]
UPDATE place SET osm_id = '1356964872' WHERE id = 492529;
|
21 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964873"
492530
]
UPDATE place SET osm_id = '1356964873' WHERE id = 492530;
|
22 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964874"
492531
]
UPDATE place SET osm_id = '1356964874' WHERE id = 492531;
|
23 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964875"
492532
]
UPDATE place SET osm_id = '1356964875' WHERE id = 492532;
|
24 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964876"
492533
]
UPDATE place SET osm_id = '1356964876' WHERE id = 492533;
|
25 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964877"
492534
]
UPDATE place SET osm_id = '1356964877' WHERE id = 492534;
|
26 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964878"
492535
]
UPDATE place SET osm_id = '1356964878' WHERE id = 492535;
|
27 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1356964975"
492536
]
UPDATE place SET osm_id = '1356964975' WHERE id = 492536;
|
28 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1953045723"
492537
]
UPDATE place SET osm_id = '1953045723' WHERE id = 492537;
|
29 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1953048976"
492538
]
UPDATE place SET osm_id = '1953048976' WHERE id = 492538;
|
30 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"2154963747"
492539
]
UPDATE place SET osm_id = '2154963747' WHERE id = 492539;
|
31 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"2162423203"
492540
]
UPDATE place SET osm_id = '2162423203' WHERE id = 492540;
|
32 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"2431040525"
492541
]
UPDATE place SET osm_id = '2431040525' WHERE id = 492541;
|
33 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"2431040526"
492542
]
UPDATE place SET osm_id = '2431040526' WHERE id = 492542;
|
34 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4286664068"
492543
]
UPDATE place SET osm_id = '4286664068' WHERE id = 492543;
|
35 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"4841383058"
492544
]
UPDATE place SET osm_id = '4841383058' WHERE id = 492544;
|
36 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"5782834681"
492545
]
UPDATE place SET osm_id = '5782834681' WHERE id = 492545;
|
37 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"8329787785"
492546
]
UPDATE place SET osm_id = '8329787785' WHERE id = 492546;
|
38 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"9501437000"
492547
]
UPDATE place SET osm_id = '9501437000' WHERE id = 492547;
|
39 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"9553998717"
492548
]
UPDATE place SET osm_id = '9553998717' WHERE id = 492548;
|
40 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"9767943625"
492549
]
UPDATE place SET osm_id = '9767943625' WHERE id = 492549;
|
41 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"9787341556"
492550
]
UPDATE place SET osm_id = '9787341556' WHERE id = 492550;
|
42 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"9787341610"
492551
]
UPDATE place SET osm_id = '9787341610' WHERE id = 492551;
|
43 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"10792962105"
492552
]
UPDATE place SET osm_id = '10792962105' WHERE id = 492552;
|
44 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"11821515131"
492553
]
UPDATE place SET osm_id = '11821515131' WHERE id = 492553;
|
45 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"11976389080"
492554
]
UPDATE place SET osm_id = '11976389080' WHERE id = 492554;
|
46 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12510980296"
492555
]
UPDATE place SET osm_id = '12510980296' WHERE id = 492555;
|
47 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12768132440"
492556
]
UPDATE place SET osm_id = '12768132440' WHERE id = 492556;
|
48 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12768132441"
492557
]
UPDATE place SET osm_id = '12768132441' WHERE id = 492557;
|
49 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12768145752"
492558
]
UPDATE place SET osm_id = '12768145752' WHERE id = 492558;
|
50 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"74203930"
492559
]
UPDATE place SET osm_id = '74203930' WHERE id = 492559;
|
51 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"74204424"
492560
]
UPDATE place SET osm_id = '74204424' WHERE id = 492560;
|
52 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"74204595"
492561
]
UPDATE place SET osm_id = '74204595' WHERE id = 492561;
|
53 |
0.21 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"74205003"
492562
]
UPDATE place SET osm_id = '74205003' WHERE id = 492562;
|
54 |
0.22 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"74205403"
492563
]
UPDATE place SET osm_id = '74205403' WHERE id = 492563;
|
55 |
0.16 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"74205756"
492564
]
UPDATE place SET osm_id = '74205756' WHERE id = 492564;
|
56 |
0.15 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"74207136"
492565
]
UPDATE place SET osm_id = '74207136' WHERE id = 492565;
|
57 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"185773942"
492566
]
UPDATE place SET osm_id = '185773942' WHERE id = 492566;
|
58 |
0.14 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"185773963"
492567
]
UPDATE place SET osm_id = '185773963' WHERE id = 492567;
|
59 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"234993128"
492568
]
UPDATE place SET osm_id = '234993128' WHERE id = 492568;
|
60 |
0.14 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"513668956"
492569
]
UPDATE place SET osm_id = '513668956' WHERE id = 492569;
|
61 |
0.16 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"1228911194"
492570
]
UPDATE place SET osm_id = '1228911194' WHERE id = 492570;
|
62 |
0.54 ms |
"COMMIT"
|