GET https://osm-commerces.cipherbliss.com/city/02044/zone-places-history

Query Metrics

35 Database Queries
7 Different statements
13.77 ms Query time
0 Invalid entities
28 Managed entities

Queries

Group similar statements

# Time Info
1 0.29 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:
[
  "02044"
]
2 0.50 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:
[
  8765
  "fire_hydrant"
]
3 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:
[
  8765
  "charging_station"
]
4 0.31 ms
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[
  8765
  "toilets"
]
5 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:
[
  8765
  "bus_stop"
]
6 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:
[
  8765
  "defibrillator"
]
7 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:
[
  8765
  "camera"
]
8 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:
[
  8765
  "recycling"
]
9 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:
[
  8765
  "substation"
]
10 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:
[
  8765
  "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:
[
  8765
  "school"
]
12 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:
[
  8765
  "police"
]
13 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:
[
  8765
  "healthcare"
]
14 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:
[
  8765
  "bicycle_parking"
]
15 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:
[
  8765
  "advertising_board"
]
16 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:
[
  8765
  "building"
]
17 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:
[
  8765
  "rnb"
]
18 0.28 ms
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[
  8765
  "email"
]
19 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:
[
  8765
  "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:
[
  8765
  "waste_basket"
]
21 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:
[
  8765
  "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:
[
  8765
  "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:
[
  8765
  "tree"
]
24 0.28 ms
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[
  8765
  "power_pole"
]
25 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:
[
  8765
  "manhole"
]
26 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:
[
  8765
  "little_free_library"
]
27 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:
[
  8765
  "playground"
]
28 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:
[
  8765
  "restaurant"
]
29 0.12 ms
"START TRANSACTION"
Parameters:
[]
30 0.83 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"way","id":145988830,"user":"didier2020","timestamp":"2012-01-16T14:53:00Z","changeset":10408833},{"type":"way","id":145988831,"user":"didier2020","timestamp":"2012-01-16T14:53:00Z","changeset":10408833},{"type":"way","id":145988832,"user":"didier2020","timestamp":"2012-01-16T14:53:00Z","changeset":10408833},{"type":"way","id":145988833,"user":"didier2020","timestamp":"2012-01-16T14:53:01Z","changeset":10408833},{"type":"way","id":145988834,"user":"didier2020","timestamp":"2012-01-16T14:53:01Z","changeset":10408833},{"type":"way","id":145988835,"user":"Florimondable","timestamp":"2019-12-26T10:26:18Z","changeset":78875680},{"type":"way","id":145988836,"user":"didier2020","timestamp":"2012-01-16T14:53:02Z","changeset":10408833},{"type":"way","id":145988837,"user":"didier2020","timestamp":"2012-01-16T14:53:02Z","changeset":10408833},{"type":"way","id":145988839,"user":"didier2020","timestamp":"2012-01-16T14:53:02Z","changeset":10408833},{"type":"way","id":145988840,"user":"didier2020","timestamp":"2012-01-16T14:53:02Z","changeset":10408833},{"type":"way","id":145988841,"user":"didier2020","timestamp":"2012-01-16T14:53:02Z","changeset":10408833},{"type":"way","id":145988842,"user":"didier2020","timestamp":"2012-01-16T14:53:03Z","changeset":10408833},{"type":"way","id":145988843,"user":"didier2020","timestamp":"2012-01-16T14:53:03Z","changeset":10408833},{"type":"way","id":145988844,"user":"didier2020","timestamp":"2012-01-16T14:53:03Z","changeset":10408833},{"type":"way","id":145988845,"user":"didier2020","timestamp":"2012-01-16T14:53:03Z","changeset":10408833},{"type":"way","id":145988846,"user":"didier2020","timestamp":"2012-01-16T14:53:03Z","changeset":10408833},{"type":"way","id":145988847,"user":"didier2020","timestamp":"2012-01-16T14:53:04Z","changeset":10408833},{"type":"way","id":145988848,"user":"didier2020","timestamp":"2012-01-16T14:53:04Z","changeset":10408833},{"type":"way","id":145988849,"user":"didier2020","timestamp":"2012-01-16T14:53:04Z","changeset":10408833},{"type":"way","id":145988850,"user":"didier2020","timestamp":"2012-01-16T14:53:04Z","changeset":10408833},{"type":"way","id":145988851,"user":"didier2020","timestamp":"2012-01-16T14:53:04Z","changeset":10408833},{"type":"way","id":145988852,"user":"didier2020","timestamp":"2012-01-16T14:53:04Z","changeset":10408833},{"type":"way","id":145988853,"user":"didier2020","timestamp":"2012-01-16T14:53:05Z","changeset":10408833},{"type":"way","id":145988854,"user":"didier2020","timestamp":"2012-01-16T14:53:05Z","changeset":10408833},{"type":"way","id":145988855,"user":"didier2020","timestamp":"2012-01-16T14:53:05Z","changeset":10408833},{"type":"way","id":145988856,"user":"didier2020","timestamp":"2012-01-16T14:53:05Z","changeset":10408833},{"type":"way","id":145988857,"user":"didier2020","timestamp":"2012-01-16T14:53:06Z","changeset":10408833},{"type":"way","id":145988858,"user":"didier2020","timestamp":"2012-01-16T14:53:06Z","changeset":10408833},{"type":"way","id":145988859,"user":"didier2020","timestamp":"2012-01-16T14:53:06Z","changeset":10408833},{"type":"way","id":145988860,"user":"didier2020","timestamp":"2012-01-16T14:53:06Z","changeset":10408833},{"type":"way","id":145988861,"user":"didier2020","timestamp":"2012-01-16T14:53:06Z","changeset":10408833},{"type":"way","id":145988862,"user":"didier2020","timestamp":"2012-01-16T14:53:06Z","changeset":10408833},{"type":"way","id":145988863,"user":"didier2020","timestamp":"2012-01-16T14:53:07Z","changeset":10408833},{"type":"way","id":145988864,"user":"didier2020","timestamp":"2012-01-16T14:53:07Z","changeset":10408833},{"type":"way","id":145988865,"user":"didier2020","timestamp":"2012-01-16T14:53:07Z","changeset":10408833},{"type":"way","id":145988866,"user":"didier2020","timestamp":"2012-01-16T14:53:07Z","changeset":10408833},{"type":"way","id":145988867,"user":"didier2020","timestamp":"2012-01-16T14:53:08Z","changeset":10408833},{"type":"way","id":145988868,"user":"didier2020","timestamp":"2012-01-16T14:53:08Z","changeset":10408833},{"type":"way","id":145988869,"user":"didier2020","timestamp":"2012-01-16T14:53:08Z","changeset":10408833},{"type":"way","id":145988870,"user":"didier2020","timestamp":"2012-01-16T14:53:08Z","changeset":10408833},{"type":"way","id":145988871,"user":"didier2020","timestamp":"2012-01-16T14:53:08Z","changeset":10408833},{"type":"way","id":145988872,"user":"didier2020","timestamp":"2012-01-16T14:53:09Z","changeset":10408833},{"type":"way","id":145988873,"user":"didier2020","timestamp":"2012-01-16T14:53:09Z","changeset":10408833},{"type":"way","id":145988874,"user":"didier2020","timestamp":"2012-01-16T14:53:09Z","changeset":10408833},{"type":"way","id":145988875,"user":"didier2020","timestamp":"2012-01-16T14:53:09Z","changeset":10408833},{"type":"way","id":145988877,"user":"didier2020","timestamp":"2012-01-16T14:53:09Z","changeset":10408833},{"type":"way","id":145988879,"user":"didier2020","timestamp":"2012-01-16T14:53:10Z","changeset":10408833},{"type":"way","id":145988880,"user":"didier2020","timestamp":"2012-01-16T14:53:10Z","changeset":10408833},{"type":"way","id":145988882,"user":"didier2020","timestamp":"2012-01-16T14:53:10Z","changeset":10408833},{"type":"way","id":145988883,"user":"didier2020","timestamp":"2012-01-16T14:53:10Z","changeset":10408833},{"type":"way","id":145988885,"user":"didier2020","timestamp":"2012-01-16T14:53:11Z","changeset":10408833},{"type":"way","id":145988887,"user":"didier2020","timestamp":"2012-01-16T14:53:11Z","changeset":10408833},{"type":"way","id":145988888,"user":"didier2020","timestamp":"2012-01-16T14:53:11Z","changeset":10408833},{"type":"way","id":145988890,"user":"didier2020","timestamp":"2012-01-16T14:53:12Z","changeset":10408833},{"type":"way","id":145988893,"user":"didier2020","timestamp":"2012-01-16T14:53:12Z","changeset":10408833},{"type":"way","id":145988895,"user":"didier2020","timestamp":"2012-01-16T14:53:12Z","changeset":10408833},{"type":"way","id":145988901,"user":"didier2020","timestamp":"2012-01-16T14:53:13Z","changeset":10408833},{"type":"way","id":145988902,"user":"didier2020","timestamp":"2012-01-16T14:53:13Z","changeset":10408833},{"type":"way","id":145988904,"user":"didier2020","timestamp":"2012-01-16T14:53:13Z","changeset":10408833},{"type":"way","id":145988909,"user":"didier2020","timestamp":"2012-01-16T14:53:13Z","changeset":10408833},{"type":"way","id":145988912,"user":"didier2020","timestamp":"2012-01-16T14:53:13Z","changeset":10408833},{"type":"way","id":145988913,"user":"didier2020","timestamp":"2012-01-16T14:53:14Z","changeset":10408833},{"type":"way","id":145988915,"user":"didier2020","timestamp":"2012-01-16T14:53:14Z","changeset":10408833},{"type":"way","id":145988919,"user":"didier2020","timestamp":"2012-01-16T14:53:14Z","changeset":10408833},{"type":"way","id":145988921,"user":"didier2020","timestamp":"2012-01-16T14:53:14Z","changeset":10408833},{"type":"way","id":145988922,"user":"didier2020","timestamp":"2012-01-16T14:53:15Z","changeset":10408833},{"type":"way","id":145988925,"user":"nlehuby","timestamp":"2025-05-08T17:22:54Z","changeset":165995054},{"type":"way","id":145988926,"user":"didier2020","timestamp":"2012-01-16T14:53:15Z","changeset":10408833},{"type":"way","id":145988927,"user":"didier2020","timestamp":"2012-01-16T14:53:15Z","changeset":10408833},{"type":"way","id":145988932,"user":"didier2020","timestamp":"2012-01-16T14:53:16Z","changeset":10408833},{"type":"way","id":145988934,"user":"didier2020","timestamp":"2012-01-16T14:53:16Z","changeset":10408833},{"type":"way","id":145988936,"user":"didier2020","timestamp":"2012-01-16T14:53:16Z","changeset":10408833},{"type":"way","id":145988938,"user":"didier2020","timestamp":"2012-01-16T14:53:16Z","changeset":10408833},{"type":"way","id":145988940,"user":"didier2020","timestamp":"2012-01-16T14:53:16Z","changeset":10408833},{"type":"way","id":145988941,"user":"didier2020","timestamp":"2012-01-16T14:53:17Z","changeset":10408833},{"type":"way","id":145988944,"user":"didier2020","timestamp":"2012-01-16T14:53:17Z","changeset":10408833},{"type":"way","id":145988945,"user":"botdidier2020","timestamp":"2012-10-15T11:51:19Z","changeset":13504776},{"type":"way","id":145988946,"user":"didier2020","timestamp":"2012-01-16T14:53:17Z","changeset":10408833},{"type":"way","id":145988949,"user":"didier2020","timestamp":"2012-01-16T14:53:18Z","changeset":10408833},{"type":"way","id":145988951,"user":"didier2020","timestamp":"2012-01-16T14:53:18Z","changeset":10408833},{"type":"way","id":145988953,"user":"didier2020","timestamp":"2012-01-16T14:53:18Z","changeset":10408833},{"type":"way","id":145988954,"user":"didier2020","timestamp":"2012-01-16T14:53:18Z","changeset":10408833}]"
  213079
]
31 0.23 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"way","id":145988925,"user":"nlehuby","timestamp":"2025-05-08T17:22:54Z","changeset":165995054}]"
  213081
]
32 0.24 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"node","id":4801923571,"user":"Teuxe","timestamp":"2017-04-18T16:44:36Z","changeset":47911701},{"type":"node","id":4801923680,"user":"Teuxe","timestamp":"2017-04-18T16:44:37Z","changeset":47911701},{"type":"node","id":4801923719,"user":"Teuxe","timestamp":"2017-04-18T16:44:38Z","changeset":47911701},{"type":"node","id":4801923738,"user":"Teuxe","timestamp":"2017-04-18T16:44:38Z","changeset":47911701}]"
  213087
]
33 3.51 ms
"COMMIT"
Parameters:
[]
34 0.46 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:
[
  8765
]
35 0.22 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:
[
  8765
]

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.