Query Metrics
59
Database Queries
7
Different statements
18.93 ms
Query time
0
Invalid entities
28
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 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
Parameters:
[
"02107"
]
|
||||||||||||||||||||||||||||||||
| 2 | 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:
[ 8720 "fire_hydrant" ]
|
||||||||||||||||||||||||||||||||
| 3 | 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:
[ 8720 "charging_station" ]
|
||||||||||||||||||||||||||||||||
| 4 | 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:
[ 8720 "toilets" ]
|
||||||||||||||||||||||||||||||||
| 5 | 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:
[ 8720 "bus_stop" ]
|
||||||||||||||||||||||||||||||||
| 6 | 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:
[ 8720 "defibrillator" ]
|
||||||||||||||||||||||||||||||||
| 7 | 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:
[ 8720 "camera" ]
|
||||||||||||||||||||||||||||||||
| 8 | 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:
[ 8720 "recycling" ]
|
||||||||||||||||||||||||||||||||
| 9 | 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:
[ 8720 "substation" ]
|
||||||||||||||||||||||||||||||||
| 10 | 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:
[ 8720 "laboratory" ]
|
||||||||||||||||||||||||||||||||
| 11 | 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:
[ 8720 "school" ]
|
||||||||||||||||||||||||||||||||
| 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:
[ 8720 "police" ]
|
||||||||||||||||||||||||||||||||
| 13 | 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:
[ 8720 "healthcare" ]
|
||||||||||||||||||||||||||||||||
| 14 | 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:
[ 8720 "bicycle_parking" ]
|
||||||||||||||||||||||||||||||||
| 15 | 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:
[ 8720 "advertising_board" ]
|
||||||||||||||||||||||||||||||||
| 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:
[ 8720 "building" ]
|
||||||||||||||||||||||||||||||||
| 17 | 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:
[ 8720 "rnb" ]
|
||||||||||||||||||||||||||||||||
| 18 | 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:
[ 8720 "email" ]
|
||||||||||||||||||||||||||||||||
| 19 | 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:
[ 8720 "bench" ]
|
||||||||||||||||||||||||||||||||
| 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:
[ 8720 "waste_basket" ]
|
||||||||||||||||||||||||||||||||
| 21 | 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:
[ 8720 "street_lamp" ]
|
||||||||||||||||||||||||||||||||
| 22 | 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:
[ 8720 "drinking_water" ]
|
||||||||||||||||||||||||||||||||
| 23 | 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:
[ 8720 "tree" ]
|
||||||||||||||||||||||||||||||||
| 24 | 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:
[ 8720 "power_pole" ]
|
||||||||||||||||||||||||||||||||
| 25 | 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:
[ 8720 "manhole" ]
|
||||||||||||||||||||||||||||||||
| 26 | 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:
[ 8720 "little_free_library" ]
|
||||||||||||||||||||||||||||||||
| 27 | 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:
[ 8720 "playground" ]
|
||||||||||||||||||||||||||||||||
| 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:
[ 8720 "restaurant" ]
|
||||||||||||||||||||||||||||||||
| 29 | 0.10 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 30 | 0.25 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "fire_hydrant" 8720 ]
|
||||||||||||||||||||||||||||||||
| 31 | 0.18 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "charging_station" 8720 ]
|
||||||||||||||||||||||||||||||||
| 32 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "toilets" 8720 ]
|
||||||||||||||||||||||||||||||||
| 33 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bus_stop" 8720 ]
|
||||||||||||||||||||||||||||||||
| 34 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "defibrillator" 8720 ]
|
||||||||||||||||||||||||||||||||
| 35 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "camera" 8720 ]
|
||||||||||||||||||||||||||||||||
| 36 | 0.19 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"node","id":5343775523,"user":"meihou","timestamp":"2018-01-16T21:42:05Z","changeset":55506077},{"type":"node","id":5343794897,"user":"meihou","timestamp":"2018-01-16T22:01:02Z","changeset":55506481}]" "recycling" 8720 ]
|
||||||||||||||||||||||||||||||||
| 37 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "substation" 8720 ]
|
||||||||||||||||||||||||||||||||
| 38 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "laboratory" 8720 ]
|
||||||||||||||||||||||||||||||||
| 39 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "school" 8720 ]
|
||||||||||||||||||||||||||||||||
| 40 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "police" 8720 ]
|
||||||||||||||||||||||||||||||||
| 41 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "healthcare" 8720 ]
|
||||||||||||||||||||||||||||||||
| 42 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bicycle_parking" 8720 ]
|
||||||||||||||||||||||||||||||||
| 43 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "advertising_board" 8720 ]
|
||||||||||||||||||||||||||||||||
| 44 | 1.07 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"way","id":336807354,"user":"Vermandois","timestamp":"2025-04-03T18:38:09Z","changeset":164478959},{"type":"way","id":336807355,"user":"Potion_magix","timestamp":"2015-04-05T10:04:49Z","changeset":29989424},{"type":"way","id":336807356,"user":"Potion_magix","timestamp":"2015-04-05T10:04:49Z","changeset":29989424},{"type":"way","id":336807357,"user":"Olyon","timestamp":"2024-01-11T19:13:46Z","changeset":146155500},{"type":"way","id":336807358,"user":"Potion_magix","timestamp":"2015-04-05T10:04:49Z","changeset":29989424},{"type":"way","id":336807359,"user":"Potion_magix","timestamp":"2015-04-05T10:04:49Z","changeset":29989424},{"type":"way","id":336807360,"user":"Potion_magix","timestamp":"2015-04-05T10:04:49Z","changeset":29989424},{"type":"way","id":336807361,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":336807362,"user":"Potion_magix","timestamp":"2015-04-05T10:04:49Z","changeset":29989424},{"type":"way","id":336807363,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807364,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807365,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807368,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807369,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807370,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807371,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807372,"user":"meihou","timestamp":"2018-01-16T21:28:04Z","changeset":55505771},{"type":"way","id":336807373,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807374,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807375,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807376,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807377,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807378,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807379,"user":"Potion_magix","timestamp":"2015-04-05T10:04:50Z","changeset":29989424},{"type":"way","id":336807380,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807381,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807383,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807384,"user":"Vermandois","timestamp":"2025-04-03T18:38:09Z","changeset":164478959},{"type":"way","id":336807385,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807386,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807387,"user":"meihou","timestamp":"2018-01-16T21:28:04Z","changeset":55505771},{"type":"way","id":336807388,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807390,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807391,"user":"meihou","timestamp":"2018-01-16T21:28:04Z","changeset":55505771},{"type":"way","id":336807393,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":336807394,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807395,"user":"Potion_magix","timestamp":"2015-04-05T10:04:51Z","changeset":29989424},{"type":"way","id":336807396,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":336807398,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807399,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807400,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807401,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":336807402,"user":"Vermandois","timestamp":"2025-04-03T18:38:09Z","changeset":164478959},{"type":"way","id":336807403,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807404,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807406,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807407,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807408,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807410,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807411,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807412,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807413,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807414,"user":"Potion_magix","timestamp":"2015-04-05T10:04:52Z","changeset":29989424},{"type":"way","id":336807417,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807418,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807420,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807421,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807422,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807423,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807425,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807427,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807428,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807429,"user":"Potion_magix","timestamp":"2015-04-05T10:04:53Z","changeset":29989424},{"type":"way","id":336807431,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":336807432,"user":"Potion_magix","timestamp":"2015-04-05T10:04:54Z","changeset":29989424},{"type":"way","id":336807433,"user":"Potion_magix","timestamp":"2015-04-05T10:04:54Z","changeset":29989424},{"type":"way","id":336807434,"user":"Potion_magix","timestamp":"2015-04-05T10:04:54Z","changeset":29989424},{"type":"way","id":336807435,"user":"Potion_magix","timestamp":"2015-04-05T10:04:54Z","changeset":29989424},{"type":"way","id":336807436,"user":"Potion_magix","timestamp":"2015-04-05T10:04:54Z","changeset":29989424},{"type":"way","id":336807437,"user":"Potion_magix","timestamp":"2015-04-05T10:04:54Z","changeset":29989424},{"type":"way","id":336807438,"user":"Potion_magix","timestamp":"2015-04-05T10:04:54Z","changeset":29989424},{"type":"way","id":336807440,"user":"Potion_magix","timestamp":"2015-04-05T10:04:54Z","changeset":29989424},{"type":"way","id":336807441,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":336807442,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807443,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807444,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807445,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807446,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807447,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807448,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807449,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807450,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807451,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":336807452,"user":"Vermandois","timestamp":"2025-04-03T18:38:09Z","changeset":164478959},{"type":"way","id":336807453,"user":"Potion_magix","timestamp":"2015-04-05T10:04:55Z","changeset":29989424},{"type":"way","id":336807454,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807455,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807456,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807457,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":336807458,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807459,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807460,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807461,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807462,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807463,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807464,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807466,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807468,"user":"Potion_magix","timestamp":"2015-04-05T10:04:56Z","changeset":29989424},{"type":"way","id":336807469,"user":"Potion_magix","timestamp":"2015-04-05T10:04:57Z","changeset":29989424},{"type":"way","id":336807470,"user":"Potion_magix","timestamp":"2015-04-05T10:04:57Z","changeset":29989424},{"type":"way","id":336807471,"user":"Potion_magix","timestamp":"2015-04-05T10:04:57Z","changeset":29989424},{"type":"way","id":336807472,"user":"Potion_magix","timestamp":"2015-04-05T10:04:57Z","changeset":29989424},{"type":"way","id":336807473,"user":"Vermandois","timestamp":"2025-04-03T18:38:09Z","changeset":164478959},{"type":"way","id":336807475,"user":"Potion_magix","timestamp":"2015-04-05T10:04:57Z","changeset":29989424},{"type":"way","id":336807476,"user":"Potion_magix","timestamp":"2015-04-05T10:04:57Z","changeset":29989424},{"type":"way","id":408406548,"user":"Vermandois","timestamp":"2025-04-03T18:38:09Z","changeset":164478959},{"type":"way","id":545007805,"user":"nlehuby","timestamp":"2025-05-08T17:22:16Z","changeset":165995014},{"type":"way","id":1059219115,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":1059219116,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":1059219117,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":1059219120,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":1059219123,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":1059219124,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":1059219125,"user":"Num\u00e9ro_6","timestamp":"2022-05-11T09:42:01Z","changeset":120830533},{"type":"way","id":1374460113,"user":"Vermandois","timestamp":"2025-04-03T15:52:38Z","changeset":164471770},{"type":"way","id":1374495738,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":1374495746,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":1374495747,"user":"Vermandois","timestamp":"2025-04-03T18:19:44Z","changeset":164478318},{"type":"way","id":1374498930,"user":"Vermandois","timestamp":"2025-04-03T18:38:09Z","changeset":164478959},{"type":"way","id":1374498931,"user":"Vermandois","timestamp":"2025-04-03T18:38:09Z","changeset":164478959}]" "building" 8720 ]
|
||||||||||||||||||||||||||||||||
| 45 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "rnb" 8720 ]
|
||||||||||||||||||||||||||||||||
| 46 | 0.18 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"way","id":545007805,"user":"nlehuby","timestamp":"2025-05-08T17:22:16Z","changeset":165995014}]" "email" 8720 ]
|
||||||||||||||||||||||||||||||||
| 47 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bench" 8720 ]
|
||||||||||||||||||||||||||||||||
| 48 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "waste_basket" 8720 ]
|
||||||||||||||||||||||||||||||||
| 49 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "street_lamp" 8720 ]
|
||||||||||||||||||||||||||||||||
| 50 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "drinking_water" 8720 ]
|
||||||||||||||||||||||||||||||||
| 51 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "tree" 8720 ]
|
||||||||||||||||||||||||||||||||
| 52 | 0.18 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "power_pole" 8720 ]
|
||||||||||||||||||||||||||||||||
| 53 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "manhole" 8720 ]
|
||||||||||||||||||||||||||||||||
| 54 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "little_free_library" 8720 ]
|
||||||||||||||||||||||||||||||||
| 55 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "playground" 8720 ]
|
||||||||||||||||||||||||||||||||
| 56 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "restaurant" 8720 ]
|
||||||||||||||||||||||||||||||||
| 57 | 7.10 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 58 | 0.39 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 = ?
Parameters:
[
8720
]
|
||||||||||||||||||||||||||||||||
| 59 | 0.23 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:
[
8720
]
|
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 |
|---|---|
| App\Entity\ZonePlaces | 27 |
| App\Entity\Stats | 1 |
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. |