Query Metrics
88
Database Queries
6
Different statements
837.83 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.31 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:
[
"02206"
]
|
||||||||||||||||||||||||||||||||
| 2 | 11.90 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:
[ 5595 "fire_hydrant" ]
|
||||||||||||||||||||||||||||||||
| 3 | 0.41 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:
[ 5595 "charging_station" ]
|
||||||||||||||||||||||||||||||||
| 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:
[ 5595 "toilets" ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.34 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:
[ 5595 "bus_stop" ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.30 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:
[ 5595 "defibrillator" ]
|
||||||||||||||||||||||||||||||||
| 7 | 0.33 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:
[ 5595 "camera" ]
|
||||||||||||||||||||||||||||||||
| 8 | 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:
[ 5595 "recycling" ]
|
||||||||||||||||||||||||||||||||
| 9 | 0.34 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:
[ 5595 "substation" ]
|
||||||||||||||||||||||||||||||||
| 10 | 0.30 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:
[ 5595 "laboratory" ]
|
||||||||||||||||||||||||||||||||
| 11 | 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:
[ 5595 "school" ]
|
||||||||||||||||||||||||||||||||
| 12 | 0.26 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:
[ 5595 "police" ]
|
||||||||||||||||||||||||||||||||
| 13 | 0.25 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:
[ 5595 "healthcare" ]
|
||||||||||||||||||||||||||||||||
| 14 | 0.25 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:
[ 5595 "bicycle_parking" ]
|
||||||||||||||||||||||||||||||||
| 15 | 0.26 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:
[ 5595 "advertising_board" ]
|
||||||||||||||||||||||||||||||||
| 16 | 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:
[ 5595 "building" ]
|
||||||||||||||||||||||||||||||||
| 17 | 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:
[ 5595 "rnb" ]
|
||||||||||||||||||||||||||||||||
| 18 | 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:
[ 5595 "email" ]
|
||||||||||||||||||||||||||||||||
| 19 | 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:
[ 5595 "bench" ]
|
||||||||||||||||||||||||||||||||
| 20 | 0.26 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:
[ 5595 "waste_basket" ]
|
||||||||||||||||||||||||||||||||
| 21 | 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:
[ 5595 "street_lamp" ]
|
||||||||||||||||||||||||||||||||
| 22 | 0.26 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:
[ 5595 "drinking_water" ]
|
||||||||||||||||||||||||||||||||
| 23 | 0.30 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:
[ 5595 "tree" ]
|
||||||||||||||||||||||||||||||||
| 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:
[ 5595 "power_pole" ]
|
||||||||||||||||||||||||||||||||
| 25 | 0.25 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:
[ 5595 "manhole" ]
|
||||||||||||||||||||||||||||||||
| 26 | 0.26 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:
[ 5595 "little_free_library" ]
|
||||||||||||||||||||||||||||||||
| 27 | 0.26 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:
[ 5595 "playground" ]
|
||||||||||||||||||||||||||||||||
| 28 | 0.25 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:
[ 5595 "restaurant" ]
|
||||||||||||||||||||||||||||||||
| 29 | 0.14 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 30 | 0.60 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "fire_hydrant_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 31 | 0.21 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "fire_hydrant_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 32 | 0.20 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "charging_station_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 33 | 0.13 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "charging_station_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 34 | 0.15 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "toilets_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 35 | 0.15 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "toilets_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 36 | 0.15 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bus_stop_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 37 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bus_stop_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 38 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "defibrillator_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 39 | 0.13 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "defibrillator_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 40 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "camera_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 41 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "camera_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 42 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "recycling_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 43 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "recycling_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 44 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "substation_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 45 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "substation_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 46 | 0.13 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "laboratory_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 47 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "laboratory_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 48 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "school_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 49 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "school_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 50 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "police_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 51 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "police_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 52 | 0.14 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "healthcare_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 53 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "healthcare_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 54 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bicycle_parking_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 55 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bicycle_parking_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 56 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "advertising_board_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 57 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "advertising_board_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 58 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "building_count" 153.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 59 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "building_completion" 100.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 60 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "rnb_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 61 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "rnb_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 62 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "email_count" 1.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 63 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "email_completion" 100.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 64 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bench_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 65 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "bench_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 66 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "waste_basket_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 67 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "waste_basket_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 68 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "street_lamp_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 69 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "street_lamp_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 70 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "drinking_water_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 71 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "drinking_water_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 72 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "tree_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 73 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "tree_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 74 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "places_count" 1.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 75 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "places_completion" 83.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 76 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "power_pole_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 77 | 0.11 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "power_pole_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 78 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "manhole_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 79 | 0.20 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "manhole_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 80 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "little_free_library_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 81 | 0.19 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "little_free_library_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 82 | 0.17 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "playground_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 83 | 0.16 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "playground_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 84 | 0.15 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "restaurant_count" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 85 | 0.12 ms |
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "restaurant_completion" 0.0 "2026-02-01 15:30:13" 5595 ]
|
||||||||||||||||||||||||||||||||
| 86 | 0.90 ms |
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"way","id":334063265,"user":"Syl","timestamp":"2015-03-21T19:50:22Z","changeset":29642919},{"type":"way","id":334063266,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063267,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063268,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063269,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063270,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063271,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063272,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063273,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063274,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063275,"user":"Syl","timestamp":"2015-03-21T19:50:23Z","changeset":29642919},{"type":"way","id":334063276,"user":"Syl","timestamp":"2015-03-21T19:50:24Z","changeset":29642919},{"type":"way","id":334063277,"user":"Syl","timestamp":"2015-03-21T19:50:24Z","changeset":29642919},{"type":"way","id":334063278,"user":"Syl","timestamp":"2015-03-21T19:50:24Z","changeset":29642919},{"type":"way","id":334063279,"user":"Syl","timestamp":"2015-03-21T19:50:24Z","changeset":29642919},{"type":"way","id":334063280,"user":"Syl","timestamp":"2015-03-21T19:50:24Z","changeset":29642919},{"type":"way","id":334063281,"user":"Syl","timestamp":"2015-03-21T19:50:24Z","changeset":29642919},{"type":"way","id":334063282,"user":"Olyon","timestamp":"2024-01-11T19:13:46Z","changeset":146155500},{"type":"way","id":334063283,"user":"Syl","timestamp":"2015-03-21T19:50:24Z","changeset":29642919},{"type":"way","id":334063284,"user":"Syl","timestamp":"2015-03-21T19:50:25Z","changeset":29642919},{"type":"way","id":334063285,"user":"Syl","timestamp":"2015-03-21T19:50:25Z","changeset":29642919},{"type":"way","id":334063286,"user":"Syl","timestamp":"2015-03-21T19:50:25Z","changeset":29642919},{"type":"way","id":334063287,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063288,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063289,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063290,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063291,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063292,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063293,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063294,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063295,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063296,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063297,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063298,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063299,"user":"Syl","timestamp":"2015-03-21T19:50:26Z","changeset":29642919},{"type":"way","id":334063300,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063301,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063302,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063303,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063304,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063305,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063306,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063307,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063308,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063309,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063310,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063311,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063312,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063313,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063314,"user":"Syl","timestamp":"2015-03-21T19:50:27Z","changeset":29642919},{"type":"way","id":334063315,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063316,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063317,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063318,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063319,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063320,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063321,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063322,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063323,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063324,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063325,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063326,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063327,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063328,"user":"Syl","timestamp":"2015-03-21T19:50:28Z","changeset":29642919},{"type":"way","id":334063329,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063330,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063331,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063332,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063333,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063334,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063335,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063336,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063337,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063338,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063339,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063340,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063341,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063342,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063344,"user":"Syl","timestamp":"2015-03-21T19:50:29Z","changeset":29642919},{"type":"way","id":334063345,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063346,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063347,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063348,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063349,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063350,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063351,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063352,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063353,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063354,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063355,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063356,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063357,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063358,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063359,"user":"Syl","timestamp":"2015-03-21T19:50:30Z","changeset":29642919},{"type":"way","id":334063361,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063363,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063366,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063368,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063369,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063370,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063372,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063373,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063375,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063377,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063379,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063381,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063384,"user":"Syl","timestamp":"2015-03-21T19:50:31Z","changeset":29642919},{"type":"way","id":334063386,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063388,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063390,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063392,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063394,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063396,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063397,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063398,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063399,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063400,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063401,"user":"Syl","timestamp":"2015-03-21T19:50:32Z","changeset":29642919},{"type":"way","id":334063402,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063403,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063404,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063405,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063406,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063407,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063408,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063409,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063410,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063411,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063412,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063413,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063414,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063415,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063416,"user":"Syl","timestamp":"2015-03-21T19:50:33Z","changeset":29642919},{"type":"way","id":334063417,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063418,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063419,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063420,"user":"nlehuby","timestamp":"2025-05-08T17:22:54Z","changeset":165995054},{"type":"way","id":334063421,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063422,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063423,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063424,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063425,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063426,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063427,"user":"Syl","timestamp":"2015-03-21T19:50:34Z","changeset":29642919},{"type":"way","id":334063428,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919},{"type":"way","id":334063429,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919},{"type":"way","id":334063430,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919},{"type":"way","id":334063431,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919},{"type":"way","id":334063432,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919},{"type":"way","id":334063433,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919},{"type":"way","id":334063434,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919},{"type":"way","id":334063435,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919},{"type":"way","id":334063436,"user":"Syl","timestamp":"2015-03-21T19:50:35Z","changeset":29642919}]" 126543 ]
|
||||||||||||||||||||||||||||||||
| 87 | 0.13 ms |
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"way","id":334063420,"user":"nlehuby","timestamp":"2025-05-08T17:22:54Z","changeset":165995054}]" 126545 ]
|
||||||||||||||||||||||||||||||||
| 88 | 809.30 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. |