GET https://osm-labo.cipherbliss.com/city/01203/zone-places-history

Response
200 OK
IP
216.73.216.172
Profiled on
Token
d825a6

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
8.20 ms
(36.43%) 		1 
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters: 
[
  "[{"type":"node","id":12348332541,"user":"HugoC01","timestamp":"2024-11-17T14:32:42Z","changeset":159245277,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348332542,"user":"HugoC01","timestamp":"2024-11-17T14:32:42Z","changeset":159245277,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348332543,"user":"HugoC01","timestamp":"2024-11-17T14:32:42Z","changeset":159245277,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348483733,"user":"HugoC01","timestamp":"2024-11-17T15:04:35Z","changeset":159246678,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348483735,"user":"HugoC01","timestamp":"2024-11-17T15:04:35Z","changeset":159246678,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348483736,"user":"HugoC01","timestamp":"2024-11-17T15:04:35Z","changeset":159246678,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348483737,"user":"HugoC01","timestamp":"2024-11-17T15:04:35Z","changeset":159246678,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348483738,"user":"HugoC01","timestamp":"2024-11-17T15:04:35Z","changeset":159246678,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348483739,"user":"HugoC01","timestamp":"2024-11-17T15:04:35Z","changeset":159246678,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348765420,"user":"HugoC01","timestamp":"2024-11-17T17:37:36Z","changeset":159252687,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348765421,"user":"HugoC01","timestamp":"2024-11-17T17:37:36Z","changeset":159252687,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348765426,"user":"HugoC01","timestamp":"2024-11-17T17:37:36Z","changeset":159252687,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12348765430,"user":"HugoC01","timestamp":"2024-11-17T17:37:36Z","changeset":159252687,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12843895790,"user":"HugoC01","timestamp":"2025-05-17T12:06:19Z","changeset":166388793,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12843895791,"user":"HugoC01","timestamp":"2025-05-17T12:06:19Z","changeset":166388793,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12843895792,"user":"HugoC01","timestamp":"2025-05-17T12:06:19Z","changeset":166388793,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12843895793,"user":"HugoC01","timestamp":"2025-05-17T12:06:19Z","changeset":166388793,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12843895794,"user":"HugoC01","timestamp":"2025-05-17T12:06:19Z","changeset":166388793,"noticed_deleted_date":"2026-02-04 18:35:26"},{"type":"node","id":12843895795,"user":"HugoC01","timestamp":"2025-05-17T12:06:19Z","changeset":166388793,"noticed_deleted_date":"2026-02-04 18:35:26"}]"
  "[]"
  214676
]
View formatted query    View runnable query    Explain query    View query backtrace
4.70 ms
(20.89%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.63 ms
(20.57%) 		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: 
[
  9357
  "fire_hydrant"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.27 ms
(14.51%) 		26 
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "[]"
  "[]"
  "fire_hydrant"
  9357
]
View formatted query    View runnable query    Explain query    View query backtrace
0.86 ms
(3.80%) 		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: 
[
  9357
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(1.70%) 		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: 
[
  9357
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(1.48%) 		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: 
[
  "01203"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.61%) 		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.