1 |
30.26 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 = '12063';
|
2 |
0.46 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 = '12063' LIMIT 1;
|
3 |
0.16 ms |
"START TRANSACTION"
"START TRANSACTION";
|
4 |
0.30 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
690
]
UPDATE stats SET completion_percent = 0, places_count = 0, avec_horaires = 0, avec_adresse = 0, avec_site = 0, avec_accessibilite = 0 WHERE id = 690;
|
5 |
0.62 ms |
"COMMIT"
|
6 |
0.54 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 = 690;
|
7 |
0.17 ms |
"START TRANSACTION"
"START TRANSACTION";
|
8 |
0.29 ms |
UPDATE stats SET completion_percent = ?, places_count = ?, avec_horaires = ?, avec_adresse = ?, avec_site = ?, avec_accessibilite = ? WHERE id = ?
Parameters: [
30
33
15
12
8
14
690
]
UPDATE stats SET completion_percent = 30, places_count = 33, avec_horaires = 15, avec_adresse = 12, avec_site = 8, avec_accessibilite = 14 WHERE id = 690;
|
9 |
0.22 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"3011149840"
580215
]
UPDATE place SET osm_id = '3011149840' WHERE id = 580215;
|
10 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"3191447623"
580216
]
UPDATE place SET osm_id = '3191447623' WHERE id = 580216;
|
11 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"3675076425"
580217
]
UPDATE place SET osm_id = '3675076425' WHERE id = 580217;
|
12 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"5843924110"
580218
]
UPDATE place SET osm_id = '5843924110' WHERE id = 580218;
|
13 |
0.20 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"7353446310"
580219
]
UPDATE place SET osm_id = '7353446310' WHERE id = 580219;
|
14 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"7353478998"
580220
]
UPDATE place SET osm_id = '7353478998' WHERE id = 580220;
|
15 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"8309014812"
580221
]
UPDATE place SET osm_id = '8309014812' WHERE id = 580221;
|
16 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"9709478085"
580222
]
UPDATE place SET osm_id = '9709478085' WHERE id = 580222;
|
17 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"9709478086"
580223
]
UPDATE place SET osm_id = '9709478086' WHERE id = 580223;
|
18 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"11133028005"
580224
]
UPDATE place SET osm_id = '11133028005' WHERE id = 580224;
|
19 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12103965278"
580225
]
UPDATE place SET osm_id = '12103965278' WHERE id = 580225;
|
20 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12145935235"
580226
]
UPDATE place SET osm_id = '12145935235' WHERE id = 580226;
|
21 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12176562856"
580227
]
UPDATE place SET osm_id = '12176562856' WHERE id = 580227;
|
22 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12176588410"
580228
]
UPDATE place SET osm_id = '12176588410' WHERE id = 580228;
|
23 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12243895489"
580229
]
UPDATE place SET osm_id = '12243895489' WHERE id = 580229;
|
24 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12504809259"
580230
]
UPDATE place SET osm_id = '12504809259' WHERE id = 580230;
|
25 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12504809260"
580231
]
UPDATE place SET osm_id = '12504809260' WHERE id = 580231;
|
26 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12826444809"
580232
]
UPDATE place SET osm_id = '12826444809' WHERE id = 580232;
|
27 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12826444810"
580233
]
UPDATE place SET osm_id = '12826444810' WHERE id = 580233;
|
28 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12842396828"
580234
]
UPDATE place SET osm_id = '12842396828' WHERE id = 580234;
|
29 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12864930770"
580235
]
UPDATE place SET osm_id = '12864930770' WHERE id = 580235;
|
30 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12864930771"
580236
]
UPDATE place SET osm_id = '12864930771' WHERE id = 580236;
|
31 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12864930772"
580237
]
UPDATE place SET osm_id = '12864930772' WHERE id = 580237;
|
32 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"12864930773"
580238
]
UPDATE place SET osm_id = '12864930773' WHERE id = 580238;
|
33 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79906926"
580239
]
UPDATE place SET osm_id = '79906926' WHERE id = 580239;
|
34 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79907441"
580240
]
UPDATE place SET osm_id = '79907441' WHERE id = 580240;
|
35 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79907581"
580241
]
UPDATE place SET osm_id = '79907581' WHERE id = 580241;
|
36 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"79908096"
580242
]
UPDATE place SET osm_id = '79908096' WHERE id = 580242;
|
37 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"159892784"
580243
]
UPDATE place SET osm_id = '159892784' WHERE id = 580243;
|
38 |
0.17 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"430964176"
580244
]
UPDATE place SET osm_id = '430964176' WHERE id = 580244;
|
39 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"618261615"
580245
]
UPDATE place SET osm_id = '618261615' WHERE id = 580245;
|
40 |
0.18 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"664607509"
580246
]
UPDATE place SET osm_id = '664607509' WHERE id = 580246;
|
41 |
0.19 ms |
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: [
"726032433"
580247
]
UPDATE place SET osm_id = '726032433' WHERE id = 580247;
|
42 |
0.50 ms |
"COMMIT"
|