Query Metrics
87
Database Queries
7
Different statements
24.69 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.38 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
Parameters:
[
"02151"
]
|
||||||||||||||||||||||||||||||||
| 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 = ?
Parameters:
[
7007
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.56 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:
[ 7007 "fire_hydrant" ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.31 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:
[ 7007 "charging_station" ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.29 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:
[ 7007 "toilets" ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.29 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:
[ 7007 "bus_stop" ]
|
||||||||||||||||||||||||||||||||
| 7 | 0.28 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:
[ 7007 "defibrillator" ]
|
||||||||||||||||||||||||||||||||
| 8 | 0.28 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:
[ 7007 "camera" ]
|
||||||||||||||||||||||||||||||||
| 9 | 0.28 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:
[ 7007 "recycling" ]
|
||||||||||||||||||||||||||||||||
| 10 | 0.28 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:
[ 7007 "substation" ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.28 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:
[ 7007 "laboratory" ]
|
||||||||||||||||||||||||||||||||
| 12 | 0.27 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:
[ 7007 "school" ]
|
||||||||||||||||||||||||||||||||
| 13 | 0.28 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:
[ 7007 "police" ]
|
||||||||||||||||||||||||||||||||
| 14 | 0.28 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:
[ 7007 "healthcare" ]
|
||||||||||||||||||||||||||||||||
| 15 | 0.28 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:
[ 7007 "bicycle_parking" ]
|
||||||||||||||||||||||||||||||||
| 16 | 0.28 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:
[ 7007 "advertising_board" ]
|
||||||||||||||||||||||||||||||||
| 17 | 0.44 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:
[ 7007 "building" ]
|
||||||||||||||||||||||||||||||||
| 18 | 0.29 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:
[ 7007 "rnb" ]
|
||||||||||||||||||||||||||||||||
| 19 | 0.28 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:
[ 7007 "email" ]
|
||||||||||||||||||||||||||||||||
| 20 | 0.28 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:
[ 7007 "bench" ]
|
||||||||||||||||||||||||||||||||
| 21 | 0.28 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:
[ 7007 "waste_basket" ]
|
||||||||||||||||||||||||||||||||
| 22 | 0.28 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:
[ 7007 "street_lamp" ]
|
||||||||||||||||||||||||||||||||
| 23 | 0.28 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:
[ 7007 "drinking_water" ]
|
||||||||||||||||||||||||||||||||
| 24 | 0.28 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:
[ 7007 "tree" ]
|
||||||||||||||||||||||||||||||||
| 25 | 0.28 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:
[ 7007 "power_pole" ]
|
||||||||||||||||||||||||||||||||
| 26 | 0.28 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:
[ 7007 "manhole" ]
|
||||||||||||||||||||||||||||||||
| 27 | 0.28 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:
[ 7007 "little_free_library" ]
|
||||||||||||||||||||||||||||||||
| 28 | 0.27 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:
[ 7007 "playground" ]
|
||||||||||||||||||||||||||||||||
| 29 | 0.28 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:
[ 7007 "restaurant" ]
|
||||||||||||||||||||||||||||||||
| 30 | 0.11 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 31 | 0.26 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "fire_hydrant_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 32 | 0.20 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "fire_hydrant_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 33 | 0.19 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "charging_station_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 34 | 0.18 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "charging_station_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 35 | 0.18 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "toilets_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 36 | 0.18 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "toilets_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 37 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bus_stop_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 38 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bus_stop_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 39 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "defibrillator_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 40 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "defibrillator_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 41 | 0.18 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "camera_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 42 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "camera_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 43 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "recycling_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 44 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "recycling_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 45 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "substation_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 46 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "substation_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 47 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "laboratory_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 48 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "laboratory_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 49 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "school_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 50 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "school_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 51 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "police_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 52 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "police_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 53 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "healthcare_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 54 | 0.20 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "healthcare_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 55 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bicycle_parking_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 56 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bicycle_parking_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 57 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "advertising_board_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 58 | 0.18 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "advertising_board_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 59 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "building_count" 158.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 60 | 0.18 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "building_completion" 100.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 61 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "rnb_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 62 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "rnb_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 63 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "email_count" 1.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 64 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "email_completion" 100.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 65 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bench_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 66 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bench_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 67 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "waste_basket_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 68 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "waste_basket_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 69 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "street_lamp_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 70 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "street_lamp_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 71 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "drinking_water_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 72 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "drinking_water_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 73 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "tree_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 74 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "tree_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 75 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "power_pole_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 76 | 0.18 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "power_pole_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 77 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "manhole_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 78 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "manhole_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 79 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "little_free_library_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 80 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "little_free_library_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 81 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "playground_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 82 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "playground_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 83 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "restaurant_count" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 84 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "restaurant_completion" 0.0 "2026-02-02 07:53:53" 7007 ]
|
||||||||||||||||||||||||||||||||
| 85 | 1.40 ms |
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"way","id":187182145,"user":"meihou","timestamp":"2012-10-23T12:22:00Z","changeset":13604794},{"type":"way","id":187182146,"user":"meihou","timestamp":"2012-10-23T12:22:01Z","changeset":13604794},{"type":"way","id":187182147,"user":"meihou","timestamp":"2012-10-23T12:22:01Z","changeset":13604794},{"type":"way","id":187182148,"user":"meihou","timestamp":"2012-10-23T12:22:01Z","changeset":13604794},{"type":"way","id":187182149,"user":"meihou","timestamp":"2012-10-23T12:22:01Z","changeset":13604794},{"type":"way","id":187182150,"user":"Aroche","timestamp":"2014-10-11T09:37:51Z","changeset":25999815},{"type":"way","id":187182151,"user":"meihou","timestamp":"2012-10-23T12:22:01Z","changeset":13604794},{"type":"way","id":187182152,"user":"meihou","timestamp":"2012-10-23T12:22:02Z","changeset":13604794},{"type":"way","id":187182153,"user":"meihou","timestamp":"2012-10-23T12:22:02Z","changeset":13604794},{"type":"way","id":187182154,"user":"meihou","timestamp":"2012-10-23T12:22:02Z","changeset":13604794},{"type":"way","id":187182155,"user":"meihou","timestamp":"2012-10-23T12:22:02Z","changeset":13604794},{"type":"way","id":187182156,"user":"meihou","timestamp":"2012-10-23T12:22:02Z","changeset":13604794},{"type":"way","id":187182157,"user":"meihou","timestamp":"2012-10-23T12:22:02Z","changeset":13604794},{"type":"way","id":187182158,"user":"meihou","timestamp":"2012-10-23T12:22:02Z","changeset":13604794},{"type":"way","id":187182159,"user":"meihou","timestamp":"2012-10-23T12:22:03Z","changeset":13604794},{"type":"way","id":187182160,"user":"meihou","timestamp":"2012-10-23T12:22:03Z","changeset":13604794},{"type":"way","id":187182161,"user":"AmiFritz","timestamp":"2020-12-10T12:46:38Z","changeset":95615601},{"type":"way","id":187182162,"user":"Ayack","timestamp":"2017-09-13T11:23:10Z","changeset":52003109},{"type":"way","id":187182163,"user":"meihou","timestamp":"2012-10-23T12:22:04Z","changeset":13604794},{"type":"way","id":187182164,"user":"meihou","timestamp":"2012-10-23T12:22:04Z","changeset":13604794},{"type":"way","id":187182165,"user":"meihou","timestamp":"2012-10-23T12:22:04Z","changeset":13604794},{"type":"way","id":187182166,"user":"meihou","timestamp":"2012-10-23T12:22:04Z","changeset":13604794},{"type":"way","id":187182167,"user":"meihou","timestamp":"2012-10-23T12:22:04Z","changeset":13604794},{"type":"way","id":187182168,"user":"meihou","timestamp":"2012-10-23T12:22:04Z","changeset":13604794},{"type":"way","id":187182169,"user":"meihou","timestamp":"2012-10-23T12:22:04Z","changeset":13604794},{"type":"way","id":187182170,"user":"meihou","timestamp":"2012-10-23T12:22:04Z","changeset":13604794},{"type":"way","id":187182171,"user":"meihou","timestamp":"2012-10-23T12:22:05Z","changeset":13604794},{"type":"way","id":187182172,"user":"meihou","timestamp":"2012-10-23T12:22:05Z","changeset":13604794},{"type":"way","id":187182173,"user":"meihou","timestamp":"2012-10-23T12:22:05Z","changeset":13604794},{"type":"way","id":187182174,"user":"meihou","timestamp":"2012-10-23T12:22:05Z","changeset":13604794},{"type":"way","id":187182175,"user":"meihou","timestamp":"2012-10-23T12:22:05Z","changeset":13604794},{"type":"way","id":187182176,"user":"meihou","timestamp":"2012-10-23T12:22:05Z","changeset":13604794},{"type":"way","id":187182177,"user":"meihou","timestamp":"2012-10-23T12:22:06Z","changeset":13604794},{"type":"way","id":187182178,"user":"meihou","timestamp":"2012-10-23T12:22:06Z","changeset":13604794},{"type":"way","id":187182179,"user":"meihou","timestamp":"2012-10-23T12:22:06Z","changeset":13604794},{"type":"way","id":187182180,"user":"meihou","timestamp":"2012-10-23T12:22:06Z","changeset":13604794},{"type":"way","id":187182181,"user":"meihou","timestamp":"2012-10-23T12:22:06Z","changeset":13604794},{"type":"way","id":187182182,"user":"meihou","timestamp":"2012-10-23T12:22:06Z","changeset":13604794},{"type":"way","id":187182183,"user":"meihou","timestamp":"2012-10-23T12:22:06Z","changeset":13604794},{"type":"way","id":187182184,"user":"meihou","timestamp":"2012-10-23T12:22:06Z","changeset":13604794},{"type":"way","id":187182185,"user":"AmiFritz","timestamp":"2020-12-10T12:46:38Z","changeset":95615601},{"type":"way","id":187182186,"user":"meihou","timestamp":"2012-10-23T12:22:07Z","changeset":13604794},{"type":"way","id":187182187,"user":"meihou","timestamp":"2012-10-23T12:22:07Z","changeset":13604794},{"type":"way","id":187182188,"user":"meihou","timestamp":"2012-10-23T12:22:07Z","changeset":13604794},{"type":"way","id":187182189,"user":"meihou","timestamp":"2012-10-23T12:22:07Z","changeset":13604794},{"type":"way","id":187182190,"user":"meihou","timestamp":"2012-10-23T12:22:07Z","changeset":13604794},{"type":"way","id":187182191,"user":"meihou","timestamp":"2012-10-23T12:22:07Z","changeset":13604794},{"type":"way","id":187182192,"user":"meihou","timestamp":"2012-10-23T12:22:07Z","changeset":13604794},{"type":"way","id":187182193,"user":"meihou","timestamp":"2012-10-23T12:22:08Z","changeset":13604794},{"type":"way","id":187182194,"user":"meihou","timestamp":"2012-10-23T12:46:58Z","changeset":13605068},{"type":"way","id":187182195,"user":"meihou","timestamp":"2012-10-23T12:22:08Z","changeset":13604794},{"type":"way","id":187182196,"user":"meihou","timestamp":"2012-10-23T12:22:08Z","changeset":13604794},{"type":"way","id":187182197,"user":"meihou","timestamp":"2012-10-23T12:22:08Z","changeset":13604794},{"type":"way","id":187182198,"user":"meihou","timestamp":"2012-10-23T12:22:08Z","changeset":13604794},{"type":"way","id":187182199,"user":"meihou","timestamp":"2012-10-23T12:22:08Z","changeset":13604794},{"type":"way","id":187182200,"user":"meihou","timestamp":"2012-10-23T12:22:08Z","changeset":13604794},{"type":"way","id":187182201,"user":"meihou","timestamp":"2012-10-23T12:22:08Z","changeset":13604794},{"type":"way","id":187182202,"user":"meihou","timestamp":"2012-10-23T12:22:09Z","changeset":13604794},{"type":"way","id":187182204,"user":"meihou","timestamp":"2012-10-23T12:22:09Z","changeset":13604794},{"type":"way","id":187182205,"user":"meihou","timestamp":"2012-10-23T12:22:09Z","changeset":13604794},{"type":"way","id":187182206,"user":"meihou","timestamp":"2012-10-23T12:22:09Z","changeset":13604794},{"type":"way","id":187182207,"user":"meihou","timestamp":"2012-10-23T12:22:09Z","changeset":13604794},{"type":"way","id":187182208,"user":"meihou","timestamp":"2012-10-23T12:22:09Z","changeset":13604794},{"type":"way","id":187182209,"user":"meihou","timestamp":"2012-10-23T12:22:10Z","changeset":13604794},{"type":"way","id":187182210,"user":"meihou","timestamp":"2012-10-23T12:22:10Z","changeset":13604794},{"type":"way","id":187182211,"user":"meihou","timestamp":"2012-10-23T12:22:10Z","changeset":13604794},{"type":"way","id":187182212,"user":"meihou","timestamp":"2012-10-23T12:22:10Z","changeset":13604794},{"type":"way","id":187182213,"user":"meihou","timestamp":"2012-10-23T12:22:10Z","changeset":13604794},{"type":"way","id":187182214,"user":"meihou","timestamp":"2012-10-23T12:22:10Z","changeset":13604794},{"type":"way","id":187182215,"user":"meihou","timestamp":"2012-10-23T12:22:10Z","changeset":13604794},{"type":"way","id":187182216,"user":"meihou","timestamp":"2012-10-23T12:22:11Z","changeset":13604794},{"type":"way","id":187182217,"user":"meihou","timestamp":"2012-10-23T12:22:11Z","changeset":13604794},{"type":"way","id":187182218,"user":"meihou","timestamp":"2012-10-23T12:22:11Z","changeset":13604794},{"type":"way","id":187182220,"user":"meihou","timestamp":"2012-10-23T12:22:11Z","changeset":13604794},{"type":"way","id":187182221,"user":"nlehuby","timestamp":"2025-05-08T17:24:48Z","changeset":165995122},{"type":"way","id":187182222,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":187182223,"user":"meihou","timestamp":"2012-10-23T12:22:11Z","changeset":13604794},{"type":"way","id":187182226,"user":"meihou","timestamp":"2012-10-23T12:22:12Z","changeset":13604794},{"type":"way","id":187182227,"user":"meihou","timestamp":"2012-10-23T12:22:12Z","changeset":13604794},{"type":"way","id":187182228,"user":"meihou","timestamp":"2012-10-23T12:22:12Z","changeset":13604794},{"type":"way","id":187182230,"user":"meihou","timestamp":"2012-10-23T12:22:12Z","changeset":13604794},{"type":"way","id":187182231,"user":"meihou","timestamp":"2012-10-23T12:22:12Z","changeset":13604794},{"type":"way","id":187182232,"user":"meihou","timestamp":"2012-10-23T12:22:13Z","changeset":13604794},{"type":"way","id":187182233,"user":"meihou","timestamp":"2012-10-23T12:22:13Z","changeset":13604794},{"type":"way","id":187182234,"user":"meihou","timestamp":"2012-10-23T12:22:13Z","changeset":13604794},{"type":"way","id":187182235,"user":"meihou","timestamp":"2012-10-23T12:22:13Z","changeset":13604794},{"type":"way","id":187182236,"user":"meihou","timestamp":"2012-10-23T12:22:13Z","changeset":13604794},{"type":"way","id":187182237,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":187182238,"user":"meihou","timestamp":"2012-10-23T12:22:14Z","changeset":13604794},{"type":"way","id":187182239,"user":"meihou","timestamp":"2012-10-23T12:22:14Z","changeset":13604794},{"type":"way","id":187182240,"user":"meihou","timestamp":"2012-10-23T12:22:14Z","changeset":13604794},{"type":"way","id":187182241,"user":"meihou","timestamp":"2012-10-23T12:22:15Z","changeset":13604794},{"type":"way","id":187182242,"user":"meihou","timestamp":"2012-10-23T12:22:15Z","changeset":13604794},{"type":"way","id":187182243,"user":"meihou","timestamp":"2012-10-23T12:22:15Z","changeset":13604794},{"type":"way","id":187182244,"user":"meihou","timestamp":"2012-10-23T12:22:15Z","changeset":13604794},{"type":"way","id":187182245,"user":"meihou","timestamp":"2012-10-23T12:22:15Z","changeset":13604794},{"type":"way","id":187182246,"user":"meihou","timestamp":"2012-10-23T12:22:15Z","changeset":13604794},{"type":"way","id":187182247,"user":"ThomasDu","timestamp":"2022-06-09T11:07:13Z","changeset":122158201},{"type":"way","id":187182248,"user":"meihou","timestamp":"2012-10-23T12:22:16Z","changeset":13604794},{"type":"way","id":187182249,"user":"meihou","timestamp":"2012-10-23T12:22:16Z","changeset":13604794},{"type":"way","id":187182250,"user":"meihou","timestamp":"2012-10-23T12:22:16Z","changeset":13604794},{"type":"way","id":187182251,"user":"meihou","timestamp":"2012-10-23T12:22:16Z","changeset":13604794},{"type":"way","id":187182252,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":187182253,"user":"meihou","timestamp":"2012-10-23T12:22:16Z","changeset":13604794},{"type":"way","id":187182254,"user":"meihou","timestamp":"2012-10-23T12:22:16Z","changeset":13604794},{"type":"way","id":187182255,"user":"meihou","timestamp":"2012-10-23T12:22:17Z","changeset":13604794},{"type":"way","id":187182256,"user":"meihou","timestamp":"2012-10-23T12:22:17Z","changeset":13604794},{"type":"way","id":187182257,"user":"meihou","timestamp":"2012-10-23T12:22:17Z","changeset":13604794},{"type":"way","id":187182258,"user":"meihou","timestamp":"2012-10-23T12:22:17Z","changeset":13604794},{"type":"way","id":187182259,"user":"meihou","timestamp":"2012-10-23T12:22:17Z","changeset":13604794},{"type":"way","id":187182260,"user":"meihou","timestamp":"2012-10-23T12:22:17Z","changeset":13604794},{"type":"way","id":187182261,"user":"meihou","timestamp":"2012-10-23T12:22:17Z","changeset":13604794},{"type":"way","id":187182262,"user":"meihou","timestamp":"2012-10-23T12:22:18Z","changeset":13604794},{"type":"way","id":187182263,"user":"meihou","timestamp":"2012-10-23T12:22:18Z","changeset":13604794},{"type":"way","id":187182264,"user":"meihou","timestamp":"2012-10-23T12:22:18Z","changeset":13604794},{"type":"way","id":187182265,"user":"meihou","timestamp":"2012-10-23T12:22:18Z","changeset":13604794},{"type":"way","id":187182266,"user":"meihou","timestamp":"2012-10-23T12:22:18Z","changeset":13604794},{"type":"way","id":187182268,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":187182269,"user":"meihou","timestamp":"2012-10-23T12:22:19Z","changeset":13604794},{"type":"way","id":187182270,"user":"meihou","timestamp":"2012-10-23T12:22:19Z","changeset":13604794},{"type":"way","id":187182271,"user":"meihou","timestamp":"2012-10-23T12:22:19Z","changeset":13604794},{"type":"way","id":187182272,"user":"meihou","timestamp":"2012-10-23T12:22:19Z","changeset":13604794},{"type":"way","id":187182273,"user":"meihou","timestamp":"2012-10-23T12:22:19Z","changeset":13604794},{"type":"way","id":187182274,"user":"meihou","timestamp":"2012-10-23T12:22:19Z","changeset":13604794},{"type":"way","id":187182275,"user":"meihou","timestamp":"2012-10-23T12:22:20Z","changeset":13604794},{"type":"way","id":187182276,"user":"meihou","timestamp":"2012-10-23T12:22:20Z","changeset":13604794},{"type":"way","id":187182277,"user":"meihou","timestamp":"2012-10-23T12:22:20Z","changeset":13604794},{"type":"way","id":187182278,"user":"meihou","timestamp":"2012-10-23T12:22:20Z","changeset":13604794},{"type":"way","id":187182279,"user":"meihou","timestamp":"2012-10-23T12:22:20Z","changeset":13604794},{"type":"way","id":187182280,"user":"meihou","timestamp":"2012-10-23T12:22:20Z","changeset":13604794},{"type":"way","id":187182281,"user":"meihou","timestamp":"2012-10-23T12:22:20Z","changeset":13604794},{"type":"way","id":187182282,"user":"meihou","timestamp":"2012-10-23T12:22:21Z","changeset":13604794},{"type":"way","id":187182283,"user":"meihou","timestamp":"2012-10-23T12:22:21Z","changeset":13604794},{"type":"way","id":187182284,"user":"meihou","timestamp":"2012-10-23T12:22:21Z","changeset":13604794},{"type":"way","id":187182285,"user":"meihou","timestamp":"2012-10-23T12:22:21Z","changeset":13604794},{"type":"way","id":187182286,"user":"meihou","timestamp":"2012-10-23T12:22:21Z","changeset":13604794},{"type":"way","id":187182287,"user":"meihou","timestamp":"2012-10-23T12:22:22Z","changeset":13604794},{"type":"way","id":187182288,"user":"meihou","timestamp":"2012-10-23T12:22:22Z","changeset":13604794},{"type":"way","id":187182289,"user":"meihou","timestamp":"2012-10-23T12:22:22Z","changeset":13604794},{"type":"way","id":187182290,"user":"meihou","timestamp":"2012-10-23T12:22:22Z","changeset":13604794},{"type":"way","id":187182291,"user":"meihou","timestamp":"2012-10-23T12:22:22Z","changeset":13604794},{"type":"way","id":187182293,"user":"meihou","timestamp":"2012-10-23T12:22:22Z","changeset":13604794},{"type":"way","id":187182294,"user":"meihou","timestamp":"2012-10-23T12:22:23Z","changeset":13604794},{"type":"way","id":187182295,"user":"meihou","timestamp":"2012-10-23T12:22:23Z","changeset":13604794},{"type":"way","id":187182296,"user":"meihou","timestamp":"2012-10-23T12:22:23Z","changeset":13604794},{"type":"way","id":187182297,"user":"meihou","timestamp":"2012-10-23T12:22:23Z","changeset":13604794},{"type":"way","id":187182298,"user":"meihou","timestamp":"2012-10-23T12:22:23Z","changeset":13604794},{"type":"way","id":677637889,"user":"crln1","timestamp":"2019-03-18T12:27:33Z","changeset":68256673},{"type":"way","id":677637890,"user":"crln1","timestamp":"2019-03-18T12:27:33Z","changeset":68256673},{"type":"way","id":677637891,"user":"crln1","timestamp":"2019-03-18T12:27:33Z","changeset":68256673},{"type":"way","id":1429578612,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":1429578613,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":1429578614,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":1429578615,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":1429578616,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":1429578617,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":1429578618,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673},{"type":"way","id":1429578619,"user":"Vermandois","timestamp":"2025-09-13T20:28:14Z","changeset":171892673}]" 159183 ]
|
||||||||||||||||||||||||||||||||
| 86 | 0.18 ms |
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"way","id":187182221,"user":"nlehuby","timestamp":"2025-05-08T17:24:48Z","changeset":165995122}]" 159185 ]
|
||||||||||||||||||||||||||||||||
| 87 | 4.98 ms |
"COMMIT"
Parameters:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Stats | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\StatsHistory | No errors. |
| App\Entity\CityFollowUp | No errors. |
| App\Entity\ZonePlaces | No errors. |