1
0.33 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 , t0 . population AS population_11 , t0 . siren AS siren_12 , t0 . code_epci AS code_epci_13 , t0 . codes_postaux AS codes_postaux_14 , t0 . date_created AS date_created_15 , t0 . date_modified AS date_modified_16 , t0 . avec_siret AS avec_siret_17 , t0 . avec_name AS avec_name_18 , t0 . osm_data_date_min AS osm_data_date_min_19 , t0 . osm_data_date_avg AS osm_data_date_avg_20 , t0 . osm_data_date_max AS osm_data_date_max_21 , t0 . budget_annuel AS budget_annuel_22 , t0 . lat AS lat_23 , t0 . lon AS lon_24 , t0 . date_labourage_requested AS date_labourage_requested_25 , t0 . date_labourage_done AS date_labourage_done_26 , t0 . kind AS kind_27 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 , t0 . population AS population_11 , t0 . siren AS siren_12 , t0 . code_epci AS code_epci_13 , t0 . codes_postaux AS codes_postaux_14 , t0 . date_created AS date_created_15 , t0 . date_modified AS date_modified_16 , t0 . avec_siret AS avec_siret_17 , t0 . avec_name AS avec_name_18 , t0 . osm_data_date_min AS osm_data_date_min_19 , t0 . osm_data_date_avg AS osm_data_date_avg_20 , t0 . osm_data_date_max AS osm_data_date_max_21 , t0 . budget_annuel AS budget_annuel_22 , t0 . lat AS lat_23 , t0 . lon AS lon_24 , t0 . date_labourage_requested AS date_labourage_requested_25 , t0 . date_labourage_done AS date_labourage_done_26 , t0 . kind AS kind_27 FROM stats t0 WHERE t0 . zone = '87070' LIMIT 1 ; Copy
2
0.25 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . measure AS measure_3 , t0 . date AS date_4 , t0 . stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0 . stats_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . measure AS measure_3 , t0 . date AS date_4 , t0 . stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0 . stats_id = 5593 ; Copy
3
0.32 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"fire_hydrant "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'fire_hydrant' ; Copy
4
0.18 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"charging_station "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'charging_station' ; Copy
5
0.17 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"toilets "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'toilets' ; Copy
6
0.24 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"bus_stop "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'bus_stop' ; Copy
7
0.23 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"defibrillator "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'defibrillator' ; Copy
8
0.22 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"camera "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'camera' ; Copy
9
0.23 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"recycling "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'recycling' ; Copy
10
0.23 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"substation "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'substation' ; Copy
11
0.22 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"laboratory "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'laboratory' ; Copy
12
0.19 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"school "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'school' ; Copy
13
0.19 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"police "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'police' ; Copy
14
0.18 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"healthcare "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'healthcare' ; Copy
15
0.17 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"bicycle_parking "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'bicycle_parking' ; Copy
16
0.19 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"advertising_board "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'advertising_board' ; Copy
17
0.21 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"building "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'building' ; Copy
18
0.19 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"rnb "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'rnb' ; Copy
19
0.20 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"email "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'email' ; Copy
20
0.19 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"bench "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'bench' ; Copy
21
0.19 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"waste_basket "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'waste_basket' ; Copy
22
0.18 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"street_lamp "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'street_lamp' ; Copy
23
0.20 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"drinking_water "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'drinking_water' ; Copy
24
0.20 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"tree "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'tree' ; Copy
25
0.20 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"power_pole "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'power_pole' ; Copy
26
0.20 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"manhole "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'manhole' ; Copy
27
0.20 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"little_free_library "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'little_free_library' ; Copy
28
0.19 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"playground "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'playground' ; Copy
29
0.18 ms
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = ? AND z0_ . theme = ?
Parameters :
[
5593
"restaurant "
]
SELECT z0_ . id AS id_0 , z0_ . disappeared_list AS disappeared_list_1 , z0_ . current_list AS current_list_2 , z0_ . theme AS theme_3 , z0_ . stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_ . stats_id = 5593 AND z0_ . theme = 'restaurant' ; Copy
30
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
31
0.22 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"fire_hydrant "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'fire_hydrant' , 5593 ); Copy
32
0.18 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"fire_hydrant_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('fire_hydrant_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
33
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"fire_hydrant_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('fire_hydrant_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
34
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"charging_station "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'charging_station' , 5593 ); Copy
35
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"charging_station_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('charging_station_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
36
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"charging_station_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('charging_station_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
37
0.18 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"toilets "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'toilets' , 5593 ); Copy
38
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"toilets_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('toilets_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
39
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"toilets_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('toilets_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
40
0.14 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"bus_stop "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'bus_stop' , 5593 ); Copy
41
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"bus_stop_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('bus_stop_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
42
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"bus_stop_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('bus_stop_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
43
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"defibrillator "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'defibrillator' , 5593 ); Copy
44
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"defibrillator_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('defibrillator_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
45
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"defibrillator_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('defibrillator_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
46
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"camera "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'camera' , 5593 ); Copy
47
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"camera_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('camera_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
48
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"camera_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('camera_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
49
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"recycling "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'recycling' , 5593 ); Copy
50
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"recycling_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('recycling_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
51
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"recycling_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('recycling_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
52
0.14 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"substation "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'substation' , 5593 ); Copy
53
0.18 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"substation_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('substation_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
54
0.21 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"substation_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('substation_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
55
0.22 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"laboratory "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'laboratory' , 5593 ); Copy
56
0.19 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"laboratory_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('laboratory_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
57
0.21 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"laboratory_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('laboratory_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
58
0.16 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"school "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'school' , 5593 ); Copy
59
0.16 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"school_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('school_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
60
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"school_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('school_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
61
0.16 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"police "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'police' , 5593 ); Copy
62
0.16 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"police_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('police_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
63
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"police_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('police_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
64
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"healthcare "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'healthcare' , 5593 ); Copy
65
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"healthcare_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('healthcare_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
66
0.17 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"healthcare_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('healthcare_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
67
0.16 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"bicycle_parking "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'bicycle_parking' , 5593 ); Copy
68
0.18 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"bicycle_parking_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('bicycle_parking_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
69
0.17 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"bicycle_parking_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('bicycle_parking_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
70
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"advertising_board "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'advertising_board' , 5593 ); Copy
71
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"advertising_board_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('advertising_board_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
72
0.17 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"advertising_board_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('advertising_board_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
73
0.17 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"building "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'building' , 5593 ); Copy
74
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"building_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('building_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
75
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"building_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('building_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
76
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"rnb "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'rnb' , 5593 ); Copy
77
0.16 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"rnb_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('rnb_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
78
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"rnb_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('rnb_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
79
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"email_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('email_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
80
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"email_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('email_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
81
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"bench "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'bench' , 5593 ); Copy
82
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"bench_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('bench_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
83
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"bench_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('bench_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
84
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"waste_basket "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'waste_basket' , 5593 ); Copy
85
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"waste_basket_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('waste_basket_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
86
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"waste_basket_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('waste_basket_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
87
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"street_lamp "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'street_lamp' , 5593 ); Copy
88
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"street_lamp_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('street_lamp_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
89
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"street_lamp_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('street_lamp_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
90
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"drinking_water "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'drinking_water' , 5593 ); Copy
91
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"drinking_water_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('drinking_water_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
92
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"drinking_water_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('drinking_water_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
93
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"tree "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'tree' , 5593 ); Copy
94
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"tree_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('tree_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
95
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"tree_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('tree_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
96
0.14 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"power_pole "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'power_pole' , 5593 ); Copy
97
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"power_pole_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('power_pole_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
98
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"power_pole_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('power_pole_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
99
0.16 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"manhole "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'manhole' , 5593 ); Copy
100
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"manhole_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('manhole_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
101
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"manhole_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('manhole_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
102
0.14 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"little_free_library "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'little_free_library' , 5593 ); Copy
103
0.14 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"little_free_library_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('little_free_library_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
104
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"little_free_library_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('little_free_library_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
105
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"playground "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'playground' , 5593 ); Copy
106
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"playground_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('playground_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
107
0.15 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"playground_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('playground_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
108
0.15 ms
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"[] "
"[] "
"restaurant "
5593
]
INSERT INTO zone_places (disappeared_list , current_list , theme , stats_id ) VALUES ('[]' , '[]' , 'restaurant' , 5593 ); Copy
109
0.16 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"restaurant_count "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('restaurant_count' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
110
0.17 ms
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES (? , ? , ? , ? )
Parameters :
[
"restaurant_completion "
0.0
"2026-01-30 15:45:00 "
5593
]
INSERT INTO city_follow_up (name , measure , date , stats_id ) VALUES ('restaurant_completion' , 0 , '2026-01-30 15:45:00' , 5593 ); Copy
111
0.26 ms
UPDATE zone_places SET disappeared_list = ? , current_list = ? WHERE id = ?
Parameters :
[
"[{"type":"node","id":11212299727,"user":"nlehuby","timestamp":"2025-09-01T17:50:57Z","changeset":171327713,"noticed_deleted_date":"2026-01-30 15:45:00"},{"type":"way","id":1410579985,"user":"Lisapple","timestamp":"2025-07-10T15:08:35Z","changeset":168748422,"noticed_deleted_date":"2026-01-30 15:45:00"}] "
"[] "
126501
]
UPDATE zone_places SET disappeared_list = '[{\"type\":\"node\",\"id\":11212299727,\"user\":\"nlehuby\",\"timestamp\":\"2025-09-01T17:50:57Z\",\"changeset\":171327713,\"noticed_deleted_date\":\"2026-01-30 15:45:00\"},{\"type\":\"way\",\"id\":1410579985,\"user\":\"Lisapple\",\"timestamp\":\"2025-07-10T15:08:35Z\",\"changeset\":168748422,\"noticed_deleted_date\":\"2026-01-30 15:45:00\"}]' , current_list = '[]' WHERE id = 126501 ; Copy
112
3.22 ms
"COMMIT"
113
0.37 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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . stats_id = 5593 ; Copy
114
0.26 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 , t0 . population AS population_11 , t0 . siren AS siren_12 , t0 . code_epci AS code_epci_13 , t0 . codes_postaux AS codes_postaux_14 , t0 . date_created AS date_created_15 , t0 . date_modified AS date_modified_16 , t0 . avec_siret AS avec_siret_17 , t0 . avec_name AS avec_name_18 , t0 . osm_data_date_min AS osm_data_date_min_19 , t0 . osm_data_date_avg AS osm_data_date_avg_20 , t0 . osm_data_date_max AS osm_data_date_max_21 , t0 . budget_annuel AS budget_annuel_22 , t0 . lat AS lat_23 , t0 . lon AS lon_24 , t0 . date_labourage_requested AS date_labourage_requested_25 , t0 . date_labourage_done AS date_labourage_done_26 , t0 . kind AS kind_27 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 , t0 . population AS population_11 , t0 . siren AS siren_12 , t0 . code_epci AS code_epci_13 , t0 . codes_postaux AS codes_postaux_14 , t0 . date_created AS date_created_15 , t0 . date_modified AS date_modified_16 , t0 . avec_siret AS avec_siret_17 , t0 . avec_name AS avec_name_18 , t0 . osm_data_date_min AS osm_data_date_min_19 , t0 . osm_data_date_avg AS osm_data_date_avg_20 , t0 . osm_data_date_max AS osm_data_date_max_21 , t0 . budget_annuel AS budget_annuel_22 , t0 . lat AS lat_23 , t0 . lon AS lon_24 , t0 . date_labourage_requested AS date_labourage_requested_25 , t0 . date_labourage_done AS date_labourage_done_26 , t0 . kind AS kind_27 FROM stats t0 WHERE t0 . zone = '87070' LIMIT 1 ; Copy
115
0.59 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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . osm_id = ? AND t0 . osm_kind = ? AND t0 . stats_id = ? LIMIT 1
Parameters :
[
1835746091
"node "
5593
]
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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . osm_id = 1835746091 AND t0 . osm_kind = 'node' AND t0 . stats_id = 5593 LIMIT 1 ; Copy
116
0.34 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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . stats_id = 5593 ; Copy
117
0.39 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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . osm_id = ? AND t0 . osm_kind = ? AND t0 . stats_id = ? LIMIT 1
Parameters :
[
10582432240
"node "
5593
]
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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . osm_id = 10582432240 AND t0 . osm_kind = 'node' AND t0 . stats_id = 5593 LIMIT 1 ; Copy
118
0.35 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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . osm_id = ? AND t0 . osm_kind = ? AND t0 . stats_id = ? LIMIT 1
Parameters :
[
11212299727
"node "
5593
]
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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . osm_id = 11212299727 AND t0 . osm_kind = 'node' AND t0 . stats_id = 5593 LIMIT 1 ; Copy
119
0.34 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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . osm_id = ? AND t0 . osm_kind = ? AND t0 . stats_id = ? LIMIT 1
Parameters :
[
285072518
"way "
5593
]
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 . habitants AS habitants_27 , t0 . osm_data_date AS osm_data_date_28 , t0 . osm_version AS osm_version_29 , t0 . osm_user AS osm_user_30 , t0 . osm_uid AS osm_uid_31 , t0 . osm_changeset AS osm_changeset_32 , t0 . email_content AS email_content_33 , t0 . place_count AS place_count_34 , t0 . stats_id AS stats_id_35 FROM place t0 WHERE t0 . osm_id = 285072518 AND t0 . osm_kind = 'way' AND t0 . stats_id = 5593 LIMIT 1 ; Copy
120
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
121
0.43 ms
INSERT INTO place (uuid_for_url , osm_kind , email , opted_out , dead , note , modified_date , zip_code , asked_humains_support , last_contact_attempt_date , osm_id , name , has_opening_hours , has_address , has_website , has_wheelchair , has_note , main_tag , note_content , displayed_date , lat , lon , street , housenumber , siret , habitants , osm_data_date , osm_version , osm_user , osm_uid , osm_changeset , email_content , place_count , stats_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"155b22e7-3605-4af3-b511-340a7a748c39 "
"node "
null
0
0
"Dépôt de pain, Relais postal,Produits locaux "
"2026-01-30 15:45:03 "
87400
0
null
"1835746091 "
"Les Genêts "
1
0
0
1
1
"shop=convenience "
"Dépôt de pain, Relais postal,Produits locaux "
null
45.78526
1.4684327
"Le Bourg "
null
"82118882800015 "
null
"2025-11-19 09:08:51 "
16
"cquest "
158826
174849190
null
0
5593
]
INSERT INTO place (
uuid_for_url , osm_kind , email , opted_out ,
dead , note , modified_date , zip_code ,
asked_humains_support , last_contact_attempt_date ,
osm_id , name , has_opening_hours ,
has_address , has_website , has_wheelchair ,
has_note , main_tag , note_content ,
displayed_date , lat , lon , street ,
housenumber , siret , habitants , osm_data_date ,
osm_version , osm_user , osm_uid , osm_changeset ,
email_content , place_count , stats_id
)
VALUES
(
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ?
)Copy
INSERT INTO place (uuid_for_url , osm_kind , email , opted_out , dead , note , modified_date , zip_code , asked_humains_support , last_contact_attempt_date , osm_id , name , has_opening_hours , has_address , has_website , has_wheelchair , has_note , main_tag , note_content , displayed_date , lat , lon , street , housenumber , siret , habitants , osm_data_date , osm_version , osm_user , osm_uid , osm_changeset , email_content , place_count , stats_id ) VALUES ('155b22e7-3605-4af3-b511-340a7a748c39' , 'node' , NULL , 0 , 0 , 'Dépôt de pain, Relais postal,Produits locaux' , '2026-01-30 15:45:03' , 87400 , 0 , NULL , '1835746091' , 'Les Genêts' , 1 , 0 , 0 , 1 , 1 , 'shop=convenience' , 'Dépôt de pain, Relais postal,Produits locaux' , NULL , 45.78526 , 1.4684327 , 'Le Bourg' , NULL , '82118882800015' , NULL , '2025-11-19 09:08:51' , 16 , 'cquest' , 158826 , 174849190 , NULL , 0 , 5593 ); Copy
122
0.41 ms
INSERT INTO place (uuid_for_url , osm_kind , email , opted_out , dead , note , modified_date , zip_code , asked_humains_support , last_contact_attempt_date , osm_id , name , has_opening_hours , has_address , has_website , has_wheelchair , has_note , main_tag , note_content , displayed_date , lat , lon , street , housenumber , siret , habitants , osm_data_date , osm_version , osm_user , osm_uid , osm_changeset , email_content , place_count , stats_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"44f5d2bf-5bec-410c-b3eb-464fdcc31127 "
"node "
null
0
0
""
"2026-01-30 15:45:03 "
87070
0
null
"10582432240 "
"Les Pierres Initiatiques de Saint Nicolas "
0
0
1
0
0
"tourism=museum "
null
null
45.8114961
1.4403973
null
null
null
null
"2023-11-11 12:44:47 "
2
"bazgal "
332493
143898288
null
0
5593
]
INSERT INTO place (
uuid_for_url , osm_kind , email , opted_out ,
dead , note , modified_date , zip_code ,
asked_humains_support , last_contact_attempt_date ,
osm_id , name , has_opening_hours ,
has_address , has_website , has_wheelchair ,
has_note , main_tag , note_content ,
displayed_date , lat , lon , street ,
housenumber , siret , habitants , osm_data_date ,
osm_version , osm_user , osm_uid , osm_changeset ,
email_content , place_count , stats_id
)
VALUES
(
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ?
)Copy
INSERT INTO place (uuid_for_url , osm_kind , email , opted_out , dead , note , modified_date , zip_code , asked_humains_support , last_contact_attempt_date , osm_id , name , has_opening_hours , has_address , has_website , has_wheelchair , has_note , main_tag , note_content , displayed_date , lat , lon , street , housenumber , siret , habitants , osm_data_date , osm_version , osm_user , osm_uid , osm_changeset , email_content , place_count , stats_id ) VALUES ('44f5d2bf-5bec-410c-b3eb-464fdcc31127' , 'node' , NULL , 0 , 0 , '' , '2026-01-30 15:45:03' , 87070 , 0 , NULL , '10582432240' , 'Les Pierres Initiatiques de Saint Nicolas' , 0 , 0 , 1 , 0 , 0 , 'tourism=museum' , NULL , NULL , 45.8114961 , 1.4403973 , NULL , NULL , NULL , NULL , '2023-11-11 12:44:47' , 2 , 'bazgal' , 332493 , 143898288 , NULL , 0 , 5593 ); Copy
123
0.36 ms
INSERT INTO place (uuid_for_url , osm_kind , email , opted_out , dead , note , modified_date , zip_code , asked_humains_support , last_contact_attempt_date , osm_id , name , has_opening_hours , has_address , has_website , has_wheelchair , has_note , main_tag , note_content , displayed_date , lat , lon , street , housenumber , siret , habitants , osm_data_date , osm_version , osm_user , osm_uid , osm_changeset , email_content , place_count , stats_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"4b44aabe-2f2d-46fb-9cb3-836773cd0b67 "
"node "
"contact@lageneytouse.fr "
0
0
""
"2026-01-30 15:45:03 "
87070
0
null
"11212299727 "
"Mairie de La Geneytouse "
1
0
1
1
0
"amenity=townhall "
null
null
45.7876467
1.4701179
null
null
"21870700800015 "
null
"2025-09-01 17:50:57 "
2
"nlehuby "
1424448
171327713
null
0
5593
]
INSERT INTO place (
uuid_for_url , osm_kind , email , opted_out ,
dead , note , modified_date , zip_code ,
asked_humains_support , last_contact_attempt_date ,
osm_id , name , has_opening_hours ,
has_address , has_website , has_wheelchair ,
has_note , main_tag , note_content ,
displayed_date , lat , lon , street ,
housenumber , siret , habitants , osm_data_date ,
osm_version , osm_user , osm_uid , osm_changeset ,
email_content , place_count , stats_id
)
VALUES
(
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ?
)Copy
INSERT INTO place (uuid_for_url , osm_kind , email , opted_out , dead , note , modified_date , zip_code , asked_humains_support , last_contact_attempt_date , osm_id , name , has_opening_hours , has_address , has_website , has_wheelchair , has_note , main_tag , note_content , displayed_date , lat , lon , street , housenumber , siret , habitants , osm_data_date , osm_version , osm_user , osm_uid , osm_changeset , email_content , place_count , stats_id ) VALUES ('4b44aabe-2f2d-46fb-9cb3-836773cd0b67' , 'node' , 'contact@lageneytouse.fr' , 0 , 0 , '' , '2026-01-30 15:45:03' , 87070 , 0 , NULL , '11212299727' , 'Mairie de La Geneytouse' , 1 , 0 , 1 , 1 , 0 , 'amenity=townhall' , NULL , NULL , 45.7876467 , 1.4701179 , NULL , NULL , '21870700800015' , NULL , '2025-09-01 17:50:57' , 2 , 'nlehuby' , 1424448 , 171327713 , NULL , 0 , 5593 ); Copy
124
0.35 ms
INSERT INTO place (uuid_for_url , osm_kind , email , opted_out , dead , note , modified_date , zip_code , asked_humains_support , last_contact_attempt_date , osm_id , name , has_opening_hours , has_address , has_website , has_wheelchair , has_note , main_tag , note_content , displayed_date , lat , lon , street , housenumber , siret , habitants , osm_data_date , osm_version , osm_user , osm_uid , osm_changeset , email_content , place_count , stats_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"e517073f-d2d3-479e-be5e-cf115acc6132 "
"way "
null
0
0
""
"2026-01-30 15:45:03 "
87070
0
null
"285072518 "
null
0
0
0
0
0
"amenity=library "
null
null
0.0
0.0
null
null
null
null
"2014-06-01 07:25:13 "
2
"botdidier2020 "
870861
22667811
null
0
5593
]
INSERT INTO place (
uuid_for_url , osm_kind , email , opted_out ,
dead , note , modified_date , zip_code ,
asked_humains_support , last_contact_attempt_date ,
osm_id , name , has_opening_hours ,
has_address , has_website , has_wheelchair ,
has_note , main_tag , note_content ,
displayed_date , lat , lon , street ,
housenumber , siret , habitants , osm_data_date ,
osm_version , osm_user , osm_uid , osm_changeset ,
email_content , place_count , stats_id
)
VALUES
(
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ?
)Copy
INSERT INTO place (uuid_for_url , osm_kind , email , opted_out , dead , note , modified_date , zip_code , asked_humains_support , last_contact_attempt_date , osm_id , name , has_opening_hours , has_address , has_website , has_wheelchair , has_note , main_tag , note_content , displayed_date , lat , lon , street , housenumber , siret , habitants , osm_data_date , osm_version , osm_user , osm_uid , osm_changeset , email_content , place_count , stats_id ) VALUES ('e517073f-d2d3-479e-be5e-cf115acc6132' , 'way' , NULL , 0 , 0 , '' , '2026-01-30 15:45:03' , 87070 , 0 , NULL , '285072518' , NULL , 0 , 0 , 0 , 0 , 0 , 'amenity=library' , NULL , NULL , 0 , 0 , NULL , NULL , NULL , NULL , '2014-06-01 07:25:13' , 2 , 'botdidier2020' , 870861 , 22667811 , NULL , 0 , 5593 ); Copy
125
0.86 ms
UPDATE stats SET places_count = ? WHERE id = ?
UPDATE stats SET places_count = 4 WHERE id = 5593 ; Copy
126
4.43 ms
"COMMIT"
127
0.20 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
128
0.31 ms
INSERT INTO action_log (type , data , created_at , from_url , who ) VALUES (? , ? , ? , ? , ? )
Parameters :
[
"stats_de_ville "
"{"insee_code":"87070","nom":"87070"} "
"2026-01-30 15:45:03 "
null
null
]
INSERT INTO action_log (type , data , created_at , from_url , who ) VALUES ('stats_de_ville' , '{\"insee_code\":\"87070\",\"nom\":\"87070\"}' , '2026-01-30 15:45:03' , NULL , NULL ); Copy
129
3.27 ms
"COMMIT"
130
0.41 ms
SELECT s0_ . id AS id_0 , s0_ . places_count AS places_count_1 , s0_ . emails_count AS emails_count_2 , s0_ . completion_percent AS completion_percent_3 , s0_ . emails_sent AS emails_sent_4 , s0_ . date AS date_5 , s0_ . names_count AS names_count_6 , s0_ . opening_hours_count AS opening_hours_count_7 , s0_ . website_count AS website_count_8 , s0_ . address_count AS address_count_9 , s0_ . siret_count AS siret_count_10 , s0_ . stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_ . stats_id = ? ORDER BY s0_ . id DESC LIMIT 100
SELECT s0_ . id AS id_0 , s0_ . places_count AS places_count_1 , s0_ . emails_count AS emails_count_2 , s0_ . completion_percent AS completion_percent_3 , s0_ . emails_sent AS emails_sent_4 , s0_ . date AS date_5 , s0_ . names_count AS names_count_6 , s0_ . opening_hours_count AS opening_hours_count_7 , s0_ . website_count AS website_count_8 , s0_ . address_count AS address_count_9 , s0_ . siret_count AS siret_count_10 , s0_ . stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_ . stats_id = 5593 ORDER BY s0_ . id DESC LIMIT 100 ; Copy
131
0.52 ms
SELECT p0_ . osm_user AS osm_user_0 , COUNT (p0_ . id ) AS sclr_1 , AVG ((CASE WHEN p0_ . has_opening_hours = 1 THEN 1 ELSE 0 END ) + (CASE WHEN p0_ . has_address = 1 THEN 1 ELSE 0 END ) + (CASE WHEN p0_ . has_website = 1 THEN 1 ELSE 0 END ) + (CASE WHEN p0_ . has_wheelchair = 1 THEN 1 ELSE 0 END ) + (CASE WHEN p0_ . has_note = 1 THEN 1 ELSE 0 END )) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_ . osm_user IS NOT NULL AND p0_ . osm_user < > '' AND p0_ . stats_id = ? GROUP BY p0_ . osm_user ORDER BY sclr_1 DESC LIMIT 100
SELECT p0_ . osm_user AS osm_user_0 , COUNT (p0_ . id ) AS sclr_1 , AVG ((CASE WHEN p0_ . has_opening_hours = 1 THEN 1 ELSE 0 END ) + (CASE WHEN p0_ . has_address = 1 THEN 1 ELSE 0 END ) + (CASE WHEN p0_ . has_website = 1 THEN 1 ELSE 0 END ) + (CASE WHEN p0_ . has_wheelchair = 1 THEN 1 ELSE 0 END ) + (CASE WHEN p0_ . has_note = 1 THEN 1 ELSE 0 END )) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_ . osm_user IS NOT NULL AND p0_ . osm_user < > '' AND p0_ . stats_id = 5593 GROUP BY p0_ . osm_user ORDER BY sclr_1 DESC LIMIT 100 ; Copy
132
0.38 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . measure AS measure_3 , t0 . date AS date_4 , t0 . stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0 . stats_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . measure AS measure_3 , t0 . date AS date_4 , t0 . stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0 . stats_id = 5593 ; Copy
133
0.34 ms
SELECT t0 . id AS id_1 , t0 . disappeared_list AS disappeared_list_2 , t0 . current_list AS current_list_3 , t0 . theme AS theme_4 , t0 . stats_id AS stats_id_5 FROM zone_places t0 WHERE t0 . stats_id = ?
SELECT t0 . id AS id_1 , t0 . disappeared_list AS disappeared_list_2 , t0 . current_list AS current_list_3 , t0 . theme AS theme_4 , t0 . stats_id AS stats_id_5 FROM zone_places t0 WHERE t0 . stats_id = 5593 ; Copy