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

Response
200 OK
IP
216.73.216.10
Profiled on
Token
372f9a

Query Metrics

59 Database Queries
8 Different statements
2538.70 ms Query time
0 Invalid entities
28 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1852.81 ms
(72.98%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
412.37 ms
(16.24%) 		26 
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "[]"
  "[]"
  "fire_hydrant"
  9137
]
View formatted query    View runnable query    Explain query    View query backtrace
267.27 ms
(10.53%) 		1 
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters: 
[
  "[{"type":"node","id":4239861426,"user":"fgouget","timestamp":"2017-06-12T22:20:32Z","changeset":49483676,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":4323312029,"user":"fgouget","timestamp":"2017-06-12T22:20:32Z","changeset":49483676,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":4327624105,"user":"fgouget","timestamp":"2017-06-12T22:20:31Z","changeset":49483676,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":4327624112,"user":"mast918264","timestamp":"2025-06-06T04:32:01Z","changeset":167248928,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":11020872225,"user":"fgouget","timestamp":"2023-07-02T19:57:59Z","changeset":138037169,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":11020872226,"user":"fgouget","timestamp":"2023-07-02T19:57:59Z","changeset":138037169,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":11038102364,"user":"fgouget","timestamp":"2023-07-10T20:54:24Z","changeset":138353649,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":11038102365,"user":"fgouget","timestamp":"2023-07-10T20:54:24Z","changeset":138353649,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":11038102366,"user":"fgouget","timestamp":"2023-07-10T20:54:24Z","changeset":138353649,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"node","id":12766636152,"user":"fgouget","timestamp":"2025-04-18T18:36:25Z","changeset":165126316,"noticed_deleted_date":"2026-02-04 09:14:52"},{"type":"way","id":1188734437,"user":"Olyon","timestamp":"2024-04-14T03:32:29Z","changeset":149975203,"noticed_deleted_date":"2026-02-04 09:14:52"}]"
  "[]"
  210783
]
View formatted query    View runnable query    Explain query    View query backtrace
5.28 ms
(0.21%) 		27 
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: 
[
  9137
  "fire_hydrant"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.01%) 		1 
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: 
[
  9137
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.01%) 		1 
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: 
[
  "16106"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.01%) 		1 
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: 
[
  9137
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.00%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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.