Query Metrics
59
Database Queries
8
Different statements
16.71 ms
Query time
0
Invalid entities
28
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.38 ms |
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26, t0.kind AS kind_27 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters:
[
"02023"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.99 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:
[ 9099 "fire_hydrant" ]
|
||||||||||||||||||||||||||||||||
| 3 | 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:
[ 9099 "charging_station" ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.17 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:
[ 9099 "toilets" ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.18 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:
[ 9099 "bus_stop" ]
|
||||||||||||||||||||||||||||||||
| 6 | 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:
[ 9099 "defibrillator" ]
|
||||||||||||||||||||||||||||||||
| 7 | 0.18 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:
[ 9099 "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:
[ 9099 "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:
[ 9099 "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:
[ 9099 "laboratory" ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.18 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:
[ 9099 "school" ]
|
||||||||||||||||||||||||||||||||
| 12 | 0.18 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:
[ 9099 "police" ]
|
||||||||||||||||||||||||||||||||
| 13 | 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:
[ 9099 "healthcare" ]
|
||||||||||||||||||||||||||||||||
| 14 | 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:
[ 9099 "bicycle_parking" ]
|
||||||||||||||||||||||||||||||||
| 15 | 0.18 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:
[ 9099 "advertising_board" ]
|
||||||||||||||||||||||||||||||||
| 16 | 0.35 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:
[ 9099 "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:
[ 9099 "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:
[ 9099 "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:
[ 9099 "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:
[ 9099 "waste_basket" ]
|
||||||||||||||||||||||||||||||||
| 21 | 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:
[ 9099 "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:
[ 9099 "drinking_water" ]
|
||||||||||||||||||||||||||||||||
| 23 | 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:
[ 9099 "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:
[ 9099 "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:
[ 9099 "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:
[ 9099 "little_free_library" ]
|
||||||||||||||||||||||||||||||||
| 27 | 0.18 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:
[ 9099 "playground" ]
|
||||||||||||||||||||||||||||||||
| 28 | 0.18 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:
[ 9099 "restaurant" ]
|
||||||||||||||||||||||||||||||||
| 29 | 0.09 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 30 | 0.23 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"node","id":3058481863,"user":"vincent_95","timestamp":"2014-09-04T04:47:14Z","changeset":25218724},{"type":"node","id":3058481864,"user":"vincent_95","timestamp":"2017-12-15T12:14:00Z","changeset":54651757}]" "fire_hydrant" 9099 ]
|
||||||||||||||||||||||||||||||||
| 31 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "charging_station" 9099 ]
|
||||||||||||||||||||||||||||||||
| 32 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "toilets" 9099 ]
|
||||||||||||||||||||||||||||||||
| 33 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bus_stop" 9099 ]
|
||||||||||||||||||||||||||||||||
| 34 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "defibrillator" 9099 ]
|
||||||||||||||||||||||||||||||||
| 35 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "camera" 9099 ]
|
||||||||||||||||||||||||||||||||
| 36 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "recycling" 9099 ]
|
||||||||||||||||||||||||||||||||
| 37 | 0.17 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"way","id":1153718587,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564}]" "substation" 9099 ]
|
||||||||||||||||||||||||||||||||
| 38 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "laboratory" 9099 ]
|
||||||||||||||||||||||||||||||||
| 39 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "school" 9099 ]
|
||||||||||||||||||||||||||||||||
| 40 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "police" 9099 ]
|
||||||||||||||||||||||||||||||||
| 41 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "healthcare" 9099 ]
|
||||||||||||||||||||||||||||||||
| 42 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bicycle_parking" 9099 ]
|
||||||||||||||||||||||||||||||||
| 43 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "advertising_board" 9099 ]
|
||||||||||||||||||||||||||||||||
| 44 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "rnb" 9099 ]
|
||||||||||||||||||||||||||||||||
| 45 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bench" 9099 ]
|
||||||||||||||||||||||||||||||||
| 46 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "waste_basket" 9099 ]
|
||||||||||||||||||||||||||||||||
| 47 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "street_lamp" 9099 ]
|
||||||||||||||||||||||||||||||||
| 48 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "drinking_water" 9099 ]
|
||||||||||||||||||||||||||||||||
| 49 | 0.15 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "tree" 9099 ]
|
||||||||||||||||||||||||||||||||
| 50 | 0.33 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[{"type":"node","id":10729600142,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600143,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600144,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600145,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600146,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600147,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600161,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600162,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600163,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600164,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600165,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600189,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600190,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600191,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600192,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"node","id":10729600193,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564}]" "power_pole" 9099 ]
|
||||||||||||||||||||||||||||||||
| 51 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "manhole" 9099 ]
|
||||||||||||||||||||||||||||||||
| 52 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "little_free_library" 9099 ]
|
||||||||||||||||||||||||||||||||
| 53 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "playground" 9099 ]
|
||||||||||||||||||||||||||||||||
| 54 | 0.16 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "restaurant" 9099 ]
|
||||||||||||||||||||||||||||||||
| 55 | 1.79 ms |
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"way","id":295277648,"user":"botdidier2020","timestamp":"2014-08-03T07:57:38Z","changeset":24510179},{"type":"way","id":295277649,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:43Z","changeset":24468422},{"type":"way","id":295277650,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277651,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277652,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277653,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277654,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277655,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277656,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277657,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277658,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277659,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277660,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277661,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277662,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277663,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277664,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277665,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277666,"user":"Olyon","timestamp":"2024-01-11T19:13:46Z","changeset":146155500},{"type":"way","id":295277667,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277668,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277669,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277670,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277671,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277673,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277674,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277675,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277677,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277679,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277681,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277682,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277683,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277684,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277685,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277686,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277687,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277688,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277689,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277690,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277691,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277692,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277693,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277694,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277695,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277696,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277698,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277699,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277700,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277701,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277702,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277703,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277704,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277705,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277706,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277709,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277710,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277711,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277712,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277714,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277715,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277716,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277717,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277718,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277719,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277720,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277721,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277722,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277723,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277724,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277725,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277726,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277727,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277728,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277729,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277730,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277732,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277733,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277734,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277735,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277736,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277737,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277738,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277739,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277740,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277741,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277742,"user":"vincent_95","timestamp":"2017-12-15T12:14:00Z","changeset":54651757},{"type":"way","id":295277743,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277744,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277745,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277746,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277747,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277748,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277749,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277750,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277751,"user":"botdidier2020","timestamp":"2014-08-03T07:57:38Z","changeset":24510179},{"type":"way","id":295277752,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277753,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277754,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":295277755,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277756,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277757,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277758,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277759,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277760,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277762,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277763,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277764,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277765,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277766,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277767,"user":"botdidier2020","timestamp":"2014-08-03T07:57:38Z","changeset":24510179},{"type":"way","id":295277768,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277769,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277770,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277771,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277772,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277773,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277775,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277776,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277777,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277778,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277779,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277780,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277781,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277782,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277783,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277784,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277785,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277786,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277787,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277788,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277789,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277790,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277791,"user":"nlehuby","timestamp":"2025-05-08T17:21:11Z","changeset":165994979},{"type":"way","id":295277792,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277793,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277794,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277795,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277796,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277797,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277798,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277799,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277800,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277801,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277803,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277804,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277805,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277806,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277807,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277808,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277809,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277810,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277811,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277812,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277813,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277814,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277815,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277816,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277817,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277818,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277819,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277820,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277821,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277823,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277824,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277825,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277826,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277827,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277828,"user":"botdidier2020","timestamp":"2014-08-03T07:57:38Z","changeset":24510179},{"type":"way","id":295277829,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:56Z","changeset":24468422},{"type":"way","id":317795598,"user":"JBacc1","timestamp":"2014-12-18T13:32:18Z","changeset":27550551},{"type":"way","id":1153718587,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718588,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718590,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718592,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718593,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718594,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564}]" 212145 ]
|
||||||||||||||||||||||||||||||||
| 56 | 0.19 ms |
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"way","id":295277791,"user":"nlehuby","timestamp":"2025-05-08T17:21:11Z","changeset":165994979}]" 212173 ]
|
||||||||||||||||||||||||||||||||
| 57 | 3.46 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 58 | 0.44 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:
[
9099
]
|
||||||||||||||||||||||||||||||||
| 59 | 0.18 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:
[
9099
]
|
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. |