Query Metrics
59
Database Queries
7
Different statements
29.96 ms
Query time
0
Invalid entities
28
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.36 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:
[
"02144"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.46 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:
[ 8745 "fire_hydrant" ]
|
||||||||||||||||||||||||||||||||
| 3 | 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:
[ 8745 "charging_station" ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.24 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "toilets" ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.23 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "bus_stop" ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.23 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "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:
[ 8745 "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:
[ 8745 "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:
[ 8745 "substation" ]
|
||||||||||||||||||||||||||||||||
| 10 | 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:
[ 8745 "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:
[ 8745 "school" ]
|
||||||||||||||||||||||||||||||||
| 12 | 0.22 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "police" ]
|
||||||||||||||||||||||||||||||||
| 13 | 0.22 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "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:
[ 8745 "bicycle_parking" ]
|
||||||||||||||||||||||||||||||||
| 15 | 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:
[ 8745 "advertising_board" ]
|
||||||||||||||||||||||||||||||||
| 16 | 0.22 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "building" ]
|
||||||||||||||||||||||||||||||||
| 17 | 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:
[ 8745 "rnb" ]
|
||||||||||||||||||||||||||||||||
| 18 | 0.19 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "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:
[ 8745 "bench" ]
|
||||||||||||||||||||||||||||||||
| 20 | 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:
[ 8745 "waste_basket" ]
|
||||||||||||||||||||||||||||||||
| 21 | 0.22 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "street_lamp" ]
|
||||||||||||||||||||||||||||||||
| 22 | 0.22 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "drinking_water" ]
|
||||||||||||||||||||||||||||||||
| 23 | 0.23 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "tree" ]
|
||||||||||||||||||||||||||||||||
| 24 | 0.23 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "power_pole" ]
|
||||||||||||||||||||||||||||||||
| 25 | 0.20 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "manhole" ]
|
||||||||||||||||||||||||||||||||
| 26 | 0.22 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "little_free_library" ]
|
||||||||||||||||||||||||||||||||
| 27 | 0.23 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "playground" ]
|
||||||||||||||||||||||||||||||||
| 28 | 0.22 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8745 "restaurant" ]
|
||||||||||||||||||||||||||||||||
| 29 | 0.12 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 30 | 0.22 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "fire_hydrant" 8745 ]
|
||||||||||||||||||||||||||||||||
| 31 | 0.20 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "charging_station" 8745 ]
|
||||||||||||||||||||||||||||||||
| 32 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "toilets" 8745 ]
|
||||||||||||||||||||||||||||||||
| 33 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bus_stop" 8745 ]
|
||||||||||||||||||||||||||||||||
| 34 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "defibrillator" 8745 ]
|
||||||||||||||||||||||||||||||||
| 35 | 0.14 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "camera" 8745 ]
|
||||||||||||||||||||||||||||||||
| 36 | 0.14 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "recycling" 8745 ]
|
||||||||||||||||||||||||||||||||
| 37 | 0.11 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "substation" 8745 ]
|
||||||||||||||||||||||||||||||||
| 38 | 0.11 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "laboratory" 8745 ]
|
||||||||||||||||||||||||||||||||
| 39 | 0.11 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "school" 8745 ]
|
||||||||||||||||||||||||||||||||
| 40 | 0.12 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "police" 8745 ]
|
||||||||||||||||||||||||||||||||
| 41 | 0.11 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "healthcare" 8745 ]
|
||||||||||||||||||||||||||||||||
| 42 | 0.11 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bicycle_parking" 8745 ]
|
||||||||||||||||||||||||||||||||
| 43 | 0.11 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "advertising_board" 8745 ]
|
||||||||||||||||||||||||||||||||
| 44 | 0.90 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"way","id":397672396,"user":"Pichasso","timestamp":"2016-02-13T18:03:15Z","changeset":37191718},{"type":"way","id":397672397,"user":"Pichasso","timestamp":"2016-02-13T18:03:15Z","changeset":37191718},{"type":"way","id":397672398,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672399,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672400,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672401,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672402,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672403,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672404,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672405,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672406,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672407,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672408,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672409,"user":"Pichasso","timestamp":"2016-02-13T18:03:16Z","changeset":37191718},{"type":"way","id":397672410,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672411,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672412,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672413,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672414,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672415,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672416,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672417,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672418,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672419,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672420,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672421,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672422,"user":"Pichasso","timestamp":"2016-02-13T18:03:17Z","changeset":37191718},{"type":"way","id":397672423,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672424,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672425,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672426,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672427,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672428,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672429,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672430,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672431,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672432,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672433,"user":"Pichasso","timestamp":"2016-02-13T18:03:18Z","changeset":37191718},{"type":"way","id":397672565,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672567,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672568,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672571,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672572,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672573,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672574,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672575,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672576,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672577,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672578,"user":"Pichasso","timestamp":"2016-02-13T18:04:51Z","changeset":37191718},{"type":"way","id":397672968,"user":"Pichasso","timestamp":"2016-02-13T18:07:15Z","changeset":37191718},{"type":"way","id":397672969,"user":"Pichasso","timestamp":"2016-02-13T18:07:15Z","changeset":37191718},{"type":"way","id":397672970,"user":"Pichasso","timestamp":"2016-02-13T18:07:15Z","changeset":37191718},{"type":"way","id":397672971,"user":"Pichasso","timestamp":"2016-02-13T18:07:15Z","changeset":37191718},{"type":"way","id":397672972,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672973,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672974,"user":"Ayack","timestamp":"2017-09-14T12:35:34Z","changeset":52036037},{"type":"way","id":397672975,"user":"AmiFritz","timestamp":"2020-12-09T12:30:34Z","changeset":95551720},{"type":"way","id":397672976,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672977,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672978,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672979,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672980,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672981,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672982,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672983,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672984,"user":"Pichasso","timestamp":"2016-02-13T18:07:16Z","changeset":37191718},{"type":"way","id":397672985,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672986,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672987,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672988,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672989,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672990,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672991,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672992,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672993,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672994,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672995,"user":"Pichasso","timestamp":"2016-02-13T18:07:17Z","changeset":37191718},{"type":"way","id":397672996,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397672997,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397672998,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397672999,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673000,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673001,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673002,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673003,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673004,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673005,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673006,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673007,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673008,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673009,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673010,"user":"Pichasso","timestamp":"2016-02-13T18:07:18Z","changeset":37191718},{"type":"way","id":397673013,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673014,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673015,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673016,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673017,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673018,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673019,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673020,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673021,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673022,"user":"Pichasso","timestamp":"2016-02-13T18:07:19Z","changeset":37191718},{"type":"way","id":397673024,"user":"Pichasso","timestamp":"2016-02-13T18:07:20Z","changeset":37191718},{"type":"way","id":397673025,"user":"nlehuby","timestamp":"2025-05-08T17:22:28Z","changeset":165995038},{"type":"way","id":397673026,"user":"Pichasso","timestamp":"2016-02-13T18:07:20Z","changeset":37191718},{"type":"way","id":397673027,"user":"Pichasso","timestamp":"2016-02-13T18:07:20Z","changeset":37191718},{"type":"way","id":397673028,"user":"Pichasso","timestamp":"2016-02-13T18:07:20Z","changeset":37191718},{"type":"way","id":397673029,"user":"Pichasso","timestamp":"2016-02-13T18:07:20Z","changeset":37191718},{"type":"way","id":397673030,"user":"Pichasso","timestamp":"2016-02-13T18:07:20Z","changeset":37191718},{"type":"way","id":397673031,"user":"Pichasso","timestamp":"2016-02-13T18:07:20Z","changeset":37191718},{"type":"way","id":397673032,"user":"Pichasso","timestamp":"2016-02-13T18:07:20Z","changeset":37191718},{"type":"way","id":397673181,"user":"Pichasso","timestamp":"2016-02-13T18:08:36Z","changeset":37191718},{"type":"way","id":397673359,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673360,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673361,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673363,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673364,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673365,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673366,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673367,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673368,"user":"Pichasso","timestamp":"2016-02-13T18:10:52Z","changeset":37191718},{"type":"way","id":397673369,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673370,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673371,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673372,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673373,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673374,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673375,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673376,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673377,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673378,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673379,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673380,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673381,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673382,"user":"Pichasso","timestamp":"2016-02-13T18:10:53Z","changeset":37191718},{"type":"way","id":397673383,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673384,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673385,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673386,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673387,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673388,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673389,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673390,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673391,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673392,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673393,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673394,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673395,"user":"Pichasso","timestamp":"2016-02-13T18:10:54Z","changeset":37191718},{"type":"way","id":397673396,"user":"Pichasso","timestamp":"2016-02-13T18:10:55Z","changeset":37191718},{"type":"way","id":397673397,"user":"Pichasso","timestamp":"2016-02-13T18:10:55Z","changeset":37191718},{"type":"way","id":397673398,"user":"Pichasso","timestamp":"2016-02-13T18:10:55Z","changeset":37191718},{"type":"way","id":397673399,"user":"Pichasso","timestamp":"2016-02-13T18:10:55Z","changeset":37191718},{"type":"way","id":397673401,"user":"Pichasso","timestamp":"2016-02-13T18:10:55Z","changeset":37191718},{"type":"way","id":397674139,"user":"Pichasso","timestamp":"2016-02-13T18:16:16Z","changeset":37191718},{"type":"way","id":397674140,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674141,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674142,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674143,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674144,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674145,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674146,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674148,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674150,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674151,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674152,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674153,"user":"Pichasso","timestamp":"2016-02-13T18:16:17Z","changeset":37191718},{"type":"way","id":397674154,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674155,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674156,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674157,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674159,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674161,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674162,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674163,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674164,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674165,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674166,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674167,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674168,"user":"Eebie","timestamp":"2025-06-30T09:44:08Z","changeset":168300929},{"type":"way","id":397674169,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674170,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674171,"user":"Pichasso","timestamp":"2016-02-13T18:16:18Z","changeset":37191718},{"type":"way","id":397674172,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718},{"type":"way","id":397674173,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718},{"type":"way","id":397674174,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718},{"type":"way","id":397674175,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718},{"type":"way","id":397674176,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718},{"type":"way","id":397674177,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718},{"type":"way","id":397674178,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718},{"type":"way","id":397674179,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718},{"type":"way","id":397674180,"user":"Pichasso","timestamp":"2016-02-13T18:16:19Z","changeset":37191718}]" "building" 8745 ]
|
||||||||||||||||||||||||||||||||
| 45 | 0.12 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "rnb" 8745 ]
|
||||||||||||||||||||||||||||||||
| 46 | 0.12 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"way","id":397673025,"user":"nlehuby","timestamp":"2025-05-08T17:22:28Z","changeset":165995038}]" "email" 8745 ]
|
||||||||||||||||||||||||||||||||
| 47 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bench" 8745 ]
|
||||||||||||||||||||||||||||||||
| 48 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "waste_basket" 8745 ]
|
||||||||||||||||||||||||||||||||
| 49 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "street_lamp" 8745 ]
|
||||||||||||||||||||||||||||||||
| 50 | 0.19 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "drinking_water" 8745 ]
|
||||||||||||||||||||||||||||||||
| 51 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "tree" 8745 ]
|
||||||||||||||||||||||||||||||||
| 52 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"node","id":13285475876,"user":"michel60","timestamp":"2025-11-06T16:28:08Z","changeset":174296946},{"type":"node","id":13285475877,"user":"michel60","timestamp":"2025-11-06T16:28:08Z","changeset":174296946},{"type":"node","id":13285475878,"user":"michel60","timestamp":"2025-11-06T16:28:08Z","changeset":174296946},{"type":"node","id":13296349994,"user":"michel60","timestamp":"2025-11-11T10:22:24Z","changeset":174503148}]" "power_pole" 8745 ]
|
||||||||||||||||||||||||||||||||
| 53 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "manhole" 8745 ]
|
||||||||||||||||||||||||||||||||
| 54 | 0.14 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "little_free_library" 8745 ]
|
||||||||||||||||||||||||||||||||
| 55 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "playground" 8745 ]
|
||||||||||||||||||||||||||||||||
| 56 | 0.11 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "restaurant" 8745 ]
|
||||||||||||||||||||||||||||||||
| 57 | 18.25 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 58 | 0.37 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:
[
8745
]
|
||||||||||||||||||||||||||||||||
| 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:
[
8745
]
|
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. |