Query Metrics
34
Database Queries
7
Different statements
17.43 ms
Query time
0
Invalid entities
82
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.34 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:
[
"02075"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.47 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:
[ 8715 "fire_hydrant" ]
|
||||||||||||||||||||||||||||||||
| 3 | 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:
[ 8715 "charging_station" ]
|
||||||||||||||||||||||||||||||||
| 4 | 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:
[ 8715 "toilets" ]
|
||||||||||||||||||||||||||||||||
| 5 | 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:
[ 8715 "bus_stop" ]
|
||||||||||||||||||||||||||||||||
| 6 | 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:
[ 8715 "defibrillator" ]
|
||||||||||||||||||||||||||||||||
| 7 | 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:
[ 8715 "camera" ]
|
||||||||||||||||||||||||||||||||
| 8 | 0.28 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8715 "recycling" ]
|
||||||||||||||||||||||||||||||||
| 9 | 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:
[ 8715 "substation" ]
|
||||||||||||||||||||||||||||||||
| 10 | 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:
[ 8715 "laboratory" ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.28 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8715 "school" ]
|
||||||||||||||||||||||||||||||||
| 12 | 0.27 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8715 "police" ]
|
||||||||||||||||||||||||||||||||
| 13 | 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:
[ 8715 "healthcare" ]
|
||||||||||||||||||||||||||||||||
| 14 | 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:
[ 8715 "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:
[ 8715 "advertising_board" ]
|
||||||||||||||||||||||||||||||||
| 16 | 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:
[ 8715 "building" ]
|
||||||||||||||||||||||||||||||||
| 17 | 0.32 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8715 "rnb" ]
|
||||||||||||||||||||||||||||||||
| 18 | 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:
[ 8715 "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:
[ 8715 "bench" ]
|
||||||||||||||||||||||||||||||||
| 20 | 0.28 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8715 "waste_basket" ]
|
||||||||||||||||||||||||||||||||
| 21 | 0.28 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8715 "street_lamp" ]
|
||||||||||||||||||||||||||||||||
| 22 | 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:
[ 8715 "drinking_water" ]
|
||||||||||||||||||||||||||||||||
| 23 | 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:
[ 8715 "tree" ]
|
||||||||||||||||||||||||||||||||
| 24 | 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:
[ 8715 "power_pole" ]
|
||||||||||||||||||||||||||||||||
| 25 | 0.28 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 8715 "manhole" ]
|
||||||||||||||||||||||||||||||||
| 26 | 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:
[ 8715 "little_free_library" ]
|
||||||||||||||||||||||||||||||||
| 27 | 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:
[ 8715 "playground" ]
|
||||||||||||||||||||||||||||||||
| 28 | 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:
[ 8715 "restaurant" ]
|
||||||||||||||||||||||||||||||||
| 29 | 0.14 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 30 | 2.84 ms |
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"way","id":125531846,"user":"PierenBot","timestamp":"2011-08-27T01:49:03Z","changeset":9133941},{"type":"way","id":144871681,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:01Z","changeset":10340396},{"type":"way","id":144871682,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:02Z","changeset":10340396},{"type":"way","id":144871684,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:02Z","changeset":10340396},{"type":"way","id":144871694,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:06Z","changeset":10340396},{"type":"way","id":144871695,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:06Z","changeset":10340396},{"type":"way","id":144871698,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:08Z","changeset":10340396},{"type":"way","id":144871702,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:09Z","changeset":10340396},{"type":"way","id":144871703,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:09Z","changeset":10340396},{"type":"way","id":144871705,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:10Z","changeset":10340396},{"type":"way","id":144871706,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:10Z","changeset":10340396},{"type":"way","id":144871708,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:11Z","changeset":10340396},{"type":"way","id":144871713,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:12Z","changeset":10340396},{"type":"way","id":144871714,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:13Z","changeset":10340396},{"type":"way","id":144871715,"user":"nlehuby","timestamp":"2025-05-08T17:23:50Z","changeset":165995091},{"type":"way","id":144871716,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:13Z","changeset":10340396},{"type":"way","id":144871717,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:14Z","changeset":10340396},{"type":"way","id":144871724,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:15Z","changeset":10340396},{"type":"way","id":144871727,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:16Z","changeset":10340396},{"type":"way","id":144871731,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:16Z","changeset":10340396},{"type":"way","id":144871767,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:20Z","changeset":10340396},{"type":"way","id":144871774,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:21Z","changeset":10340396},{"type":"way","id":144871786,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:23Z","changeset":10340396},{"type":"way","id":144871790,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:23Z","changeset":10340396},{"type":"way","id":144871796,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:24Z","changeset":10340396},{"type":"way","id":144871811,"user":"botdidier2020","timestamp":"2012-10-15T10:27:25Z","changeset":13503844},{"type":"way","id":144871813,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:29Z","changeset":10340396},{"type":"way","id":144871821,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:32Z","changeset":10340396},{"type":"way","id":144871824,"user":"botdidier2020","timestamp":"2012-10-15T10:27:39Z","changeset":13503844},{"type":"way","id":144871825,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:33Z","changeset":10340396},{"type":"way","id":144871826,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:33Z","changeset":10340396},{"type":"way","id":144871828,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:34Z","changeset":10340396},{"type":"way","id":144871832,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:36Z","changeset":10340396},{"type":"way","id":144871833,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:36Z","changeset":10340396},{"type":"way","id":144871835,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:37Z","changeset":10340396},{"type":"way","id":144871837,"user":"Aroche","timestamp":"2018-07-29T20:26:43Z","changeset":61173529},{"type":"way","id":144871840,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:40Z","changeset":10340396},{"type":"way","id":144871842,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:40Z","changeset":10340396},{"type":"way","id":144871845,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:41Z","changeset":10340396},{"type":"way","id":144871849,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:42Z","changeset":10340396},{"type":"way","id":144871852,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:43Z","changeset":10340396},{"type":"way","id":144871863,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:46Z","changeset":10340396},{"type":"way","id":144871864,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:46Z","changeset":10340396},{"type":"way","id":144871872,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:48Z","changeset":10340396},{"type":"way","id":144871873,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:48Z","changeset":10340396},{"type":"way","id":144871877,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:50Z","changeset":10340396},{"type":"way","id":144871879,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:50Z","changeset":10340396},{"type":"way","id":144871888,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:53Z","changeset":10340396},{"type":"way","id":144871892,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:54Z","changeset":10340396},{"type":"way","id":144871894,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:55Z","changeset":10340396},{"type":"way","id":144871895,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:55Z","changeset":10340396},{"type":"way","id":144871899,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:56Z","changeset":10340396},{"type":"way","id":144871901,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:57Z","changeset":10340396},{"type":"way","id":144871903,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:57Z","changeset":10340396},{"type":"way","id":144871905,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:58Z","changeset":10340396},{"type":"way","id":144871906,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:58Z","changeset":10340396},{"type":"way","id":144871907,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:58Z","changeset":10340396},{"type":"way","id":144871909,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:59Z","changeset":10340396},{"type":"way","id":144871910,"user":"foxandpotatoes","timestamp":"2012-01-09T10:37:59Z","changeset":10340396},{"type":"way","id":144871912,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:00Z","changeset":10340396},{"type":"way","id":144871913,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:00Z","changeset":10340396},{"type":"way","id":144871919,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:00Z","changeset":10340396},{"type":"way","id":144871942,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:03Z","changeset":10340396},{"type":"way","id":144871951,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:03Z","changeset":10340396},{"type":"way","id":144871960,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:05Z","changeset":10340396},{"type":"way","id":144871965,"user":"botdidier2020","timestamp":"2012-10-15T10:28:36Z","changeset":13503844},{"type":"way","id":144871966,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:07Z","changeset":10340396},{"type":"way","id":144871969,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:07Z","changeset":10340396},{"type":"way","id":144871977,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:09Z","changeset":10340396},{"type":"way","id":144871980,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:10Z","changeset":10340396},{"type":"way","id":144871982,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:11Z","changeset":10340396},{"type":"way","id":144871983,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:11Z","changeset":10340396},{"type":"way","id":144871987,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:12Z","changeset":10340396},{"type":"way","id":144871992,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:13Z","changeset":10340396},{"type":"way","id":144871993,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:14Z","changeset":10340396},{"type":"way","id":144871994,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:14Z","changeset":10340396},{"type":"way","id":144871997,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:15Z","changeset":10340396},{"type":"way","id":144872001,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:16Z","changeset":10340396},{"type":"way","id":144872003,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:17Z","changeset":10340396},{"type":"way","id":144872007,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:18Z","changeset":10340396},{"type":"way","id":144872011,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:19Z","changeset":10340396},{"type":"way","id":144872014,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:20Z","changeset":10340396},{"type":"way","id":144872015,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:20Z","changeset":10340396},{"type":"way","id":144872018,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:21Z","changeset":10340396},{"type":"way","id":144872020,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:22Z","changeset":10340396},{"type":"way","id":144872022,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:22Z","changeset":10340396},{"type":"way","id":144872025,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:22Z","changeset":10340396},{"type":"way","id":144872026,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:23Z","changeset":10340396},{"type":"way","id":144872029,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:24Z","changeset":10340396},{"type":"way","id":144872032,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:25Z","changeset":10340396},{"type":"way","id":144872033,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:25Z","changeset":10340396},{"type":"way","id":144872036,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:25Z","changeset":10340396},{"type":"way","id":144872044,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:27Z","changeset":10340396},{"type":"way","id":144872048,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:28Z","changeset":10340396},{"type":"way","id":144872051,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:29Z","changeset":10340396},{"type":"way","id":144872056,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:30Z","changeset":10340396},{"type":"way","id":144872058,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:30Z","changeset":10340396},{"type":"way","id":144872066,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:32Z","changeset":10340396},{"type":"way","id":144872073,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:34Z","changeset":10340396},{"type":"way","id":144872079,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:36Z","changeset":10340396},{"type":"way","id":144872083,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:37Z","changeset":10340396},{"type":"way","id":144872086,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:37Z","changeset":10340396},{"type":"way","id":144872090,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:39Z","changeset":10340396},{"type":"way","id":144872091,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:39Z","changeset":10340396},{"type":"way","id":144872097,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:41Z","changeset":10340396},{"type":"way","id":144872099,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:42Z","changeset":10340396},{"type":"way","id":144872103,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:43Z","changeset":10340396},{"type":"way","id":144872110,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:45Z","changeset":10340396},{"type":"way","id":144872114,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:46Z","changeset":10340396},{"type":"way","id":144872120,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:48Z","changeset":10340396},{"type":"way","id":144872123,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:49Z","changeset":10340396},{"type":"way","id":144872125,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:49Z","changeset":10340396},{"type":"way","id":144872131,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:51Z","changeset":10340396},{"type":"way","id":144872132,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:51Z","changeset":10340396},{"type":"way","id":144872139,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:52Z","changeset":10340396},{"type":"way","id":144872141,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:53Z","changeset":10340396},{"type":"way","id":144872142,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:53Z","changeset":10340396},{"type":"way","id":144872150,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:55Z","changeset":10340396},{"type":"way","id":144872156,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:57Z","changeset":10340396},{"type":"way","id":144872160,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:58Z","changeset":10340396},{"type":"way","id":144872164,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:59Z","changeset":10340396},{"type":"way","id":144872165,"user":"foxandpotatoes","timestamp":"2012-01-09T10:38:59Z","changeset":10340396},{"type":"way","id":144872168,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:00Z","changeset":10340396},{"type":"way","id":144872173,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:02Z","changeset":10340396},{"type":"way","id":144872181,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:04Z","changeset":10340396},{"type":"way","id":144872183,"user":"botdidier2020","timestamp":"2012-10-15T10:28:36Z","changeset":13503844},{"type":"way","id":144872190,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:06Z","changeset":10340396},{"type":"way","id":144872193,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:06Z","changeset":10340396},{"type":"way","id":144872199,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:08Z","changeset":10340396},{"type":"way","id":144872205,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:09Z","changeset":10340396},{"type":"way","id":144872210,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:10Z","changeset":10340396},{"type":"way","id":144872222,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:12Z","changeset":10340396},{"type":"way","id":144872235,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:13Z","changeset":10340396},{"type":"way","id":144872241,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:14Z","changeset":10340396},{"type":"way","id":144872242,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:14Z","changeset":10340396},{"type":"way","id":144872258,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:16Z","changeset":10340396},{"type":"way","id":144872260,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:16Z","changeset":10340396},{"type":"way","id":144872262,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:16Z","changeset":10340396},{"type":"way","id":144872267,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:17Z","changeset":10340396},{"type":"way","id":144872269,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:18Z","changeset":10340396},{"type":"way","id":144872274,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:19Z","changeset":10340396},{"type":"way","id":144872279,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:20Z","changeset":10340396},{"type":"way","id":144872280,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:20Z","changeset":10340396},{"type":"way","id":144872285,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:22Z","changeset":10340396},{"type":"way","id":144872291,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:23Z","changeset":10340396},{"type":"way","id":144872292,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:23Z","changeset":10340396},{"type":"way","id":144872306,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:25Z","changeset":10340396},{"type":"way","id":144872309,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:25Z","changeset":10340396},{"type":"way","id":144872313,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:26Z","changeset":10340396},{"type":"way","id":144872316,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:26Z","changeset":10340396},{"type":"way","id":144872317,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:27Z","changeset":10340396},{"type":"way","id":144872322,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:28Z","changeset":10340396},{"type":"way","id":144872323,"user":"botdidier2020","timestamp":"2012-10-15T10:28:37Z","changeset":13503844},{"type":"way","id":144872329,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:30Z","changeset":10340396},{"type":"way","id":144872334,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:31Z","changeset":10340396},{"type":"way","id":144872340,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:32Z","changeset":10340396},{"type":"way","id":144872341,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:32Z","changeset":10340396},{"type":"way","id":144872350,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:34Z","changeset":10340396},{"type":"way","id":144872353,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:35Z","changeset":10340396},{"type":"way","id":144872355,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:35Z","changeset":10340396},{"type":"way","id":144872359,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:36Z","changeset":10340396},{"type":"way","id":144872362,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:37Z","changeset":10340396},{"type":"way","id":144872363,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:37Z","changeset":10340396},{"type":"way","id":144872377,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:39Z","changeset":10340396},{"type":"way","id":144872380,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:40Z","changeset":10340396},{"type":"way","id":144872382,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:41Z","changeset":10340396},{"type":"way","id":144872387,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:42Z","changeset":10340396},{"type":"way","id":144872397,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:43Z","changeset":10340396},{"type":"way","id":144872400,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:44Z","changeset":10340396},{"type":"way","id":144872419,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:48Z","changeset":10340396},{"type":"way","id":144872423,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:49Z","changeset":10340396},{"type":"way","id":144872428,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:50Z","changeset":10340396},{"type":"way","id":144872429,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:50Z","changeset":10340396},{"type":"way","id":144872435,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:51Z","changeset":10340396},{"type":"way","id":144872436,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:52Z","changeset":10340396},{"type":"way","id":144872444,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:53Z","changeset":10340396},{"type":"way","id":144872446,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:53Z","changeset":10340396},{"type":"way","id":144872450,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:55Z","changeset":10340396},{"type":"way","id":144872456,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:56Z","changeset":10340396},{"type":"way","id":144872459,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:57Z","changeset":10340396},{"type":"way","id":144872460,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:57Z","changeset":10340396},{"type":"way","id":144872466,"user":"foxandpotatoes","timestamp":"2012-01-09T10:39:59Z","changeset":10340396},{"type":"way","id":144872479,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:02Z","changeset":10340396},{"type":"way","id":144872487,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:04Z","changeset":10340396},{"type":"way","id":144872498,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:06Z","changeset":10340396},{"type":"way","id":144872513,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:10Z","changeset":10340396},{"type":"way","id":144872515,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:10Z","changeset":10340396},{"type":"way","id":144872519,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:11Z","changeset":10340396},{"type":"way","id":144872526,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:14Z","changeset":10340396},{"type":"way","id":144872530,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:14Z","changeset":10340396},{"type":"way","id":144872536,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:16Z","changeset":10340396},{"type":"way","id":144872539,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:17Z","changeset":10340396},{"type":"way","id":144872540,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:17Z","changeset":10340396},{"type":"way","id":144872543,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:18Z","changeset":10340396},{"type":"way","id":144872550,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:21Z","changeset":10340396},{"type":"way","id":144872557,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:23Z","changeset":10340396},{"type":"way","id":144872569,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:27Z","changeset":10340396},{"type":"way","id":144872577,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:30Z","changeset":10340396},{"type":"way","id":144872586,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:31Z","changeset":10340396},{"type":"way","id":144872587,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:31Z","changeset":10340396},{"type":"way","id":144872597,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:32Z","changeset":10340396},{"type":"way","id":144872619,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:37Z","changeset":10340396},{"type":"way","id":144872620,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:37Z","changeset":10340396},{"type":"way","id":144872625,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:39Z","changeset":10340396},{"type":"way","id":144872628,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:40Z","changeset":10340396},{"type":"way","id":144872637,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:41Z","changeset":10340396},{"type":"way","id":144872649,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:43Z","changeset":10340396},{"type":"way","id":144872651,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:43Z","changeset":10340396},{"type":"way","id":144872655,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:44Z","changeset":10340396},{"type":"way","id":144872667,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:47Z","changeset":10340396},{"type":"way","id":144872674,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:50Z","changeset":10340396},{"type":"way","id":144872675,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:50Z","changeset":10340396},{"type":"way","id":144872684,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:53Z","changeset":10340396},{"type":"way","id":144872705,"user":"foxandpotatoes","timestamp":"2012-01-09T10:40:58Z","changeset":10340396},{"type":"way","id":144872717,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:01Z","changeset":10340396},{"type":"way","id":144872720,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:02Z","changeset":10340396},{"type":"way","id":144872722,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:03Z","changeset":10340396},{"type":"way","id":144872727,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:05Z","changeset":10340396},{"type":"way","id":144872729,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:06Z","changeset":10340396},{"type":"way","id":144872730,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:07Z","changeset":10340396},{"type":"way","id":144872733,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:08Z","changeset":10340396},{"type":"way","id":144872735,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:09Z","changeset":10340396},{"type":"way","id":144872747,"user":"GeorgeKaplan","timestamp":"2016-07-05T13:25:07Z","changeset":40499894},{"type":"way","id":144872753,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:23Z","changeset":10340396},{"type":"way","id":144872755,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:24Z","changeset":10340396},{"type":"way","id":144872757,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:24Z","changeset":10340396},{"type":"way","id":144872758,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:25Z","changeset":10340396},{"type":"way","id":144872767,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:28Z","changeset":10340396},{"type":"way","id":144872768,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:29Z","changeset":10340396},{"type":"way","id":144872769,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:29Z","changeset":10340396},{"type":"way","id":144872775,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:32Z","changeset":10340396},{"type":"way","id":144872779,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:33Z","changeset":10340396},{"type":"way","id":144872786,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:35Z","changeset":10340396},{"type":"way","id":144872787,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:35Z","changeset":10340396},{"type":"way","id":144872790,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:37Z","changeset":10340396},{"type":"way","id":144872791,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:37Z","changeset":10340396},{"type":"way","id":144872793,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:38Z","changeset":10340396},{"type":"way","id":144872799,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:40Z","changeset":10340396},{"type":"way","id":144872800,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:41Z","changeset":10340396},{"type":"way","id":144872803,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:41Z","changeset":10340396},{"type":"way","id":144872811,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:43Z","changeset":10340396},{"type":"way","id":144872812,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:44Z","changeset":10340396},{"type":"way","id":144872820,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:47Z","changeset":10340396},{"type":"way","id":144872828,"user":"botdidier2020","timestamp":"2012-10-15T10:26:41Z","changeset":13503844},{"type":"way","id":144872835,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:53Z","changeset":10340396},{"type":"way","id":144872840,"user":"botdidier2020","timestamp":"2012-10-15T10:26:41Z","changeset":13503844},{"type":"way","id":144872845,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:56Z","changeset":10340396},{"type":"way","id":144872850,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:57Z","changeset":10340396},{"type":"way","id":144872855,"user":"foxandpotatoes","timestamp":"2012-01-09T10:41:58Z","changeset":10340396},{"type":"way","id":612074811,"user":"Aroche","timestamp":"2018-07-29T20:26:33Z","changeset":61173529}]" 210158 ]
|
||||||||||||||||||||||||||||||||
| 31 | 0.28 ms |
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"way","id":144871715,"user":"nlehuby","timestamp":"2025-05-08T17:23:50Z","changeset":165995091}]" 210160 ]
|
||||||||||||||||||||||||||||||||
| 32 | 5.17 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 33 | 0.48 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:
[
8715
]
|
||||||||||||||||||||||||||||||||
| 34 | 0.40 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:
[
8715
]
|
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\CityFollowUp | 54 |
| 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. |