Redirect 302 redirect from GET @app_public_edit (ab9fab)

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

Query Metrics

45 Database Queries
7 Different statements
2547.55 ms Query time
0 Invalid entities
28 Managed entities

Grouped Statements

Show all queries

Time Count Info
1240.28 ms
(48.69%)
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:
[
  9158
  "fire_hydrant"
]
1158.81 ms
(45.49%)
1
"COMMIT"
Parameters:
[]
146.44 ms
(5.75%)
13
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"node","id":4548329642,"user":"n1c0_74","timestamp":"2024-07-30T10:46:08Z","changeset":154599794,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4548332685,"user":"gregory derobert","timestamp":"2016-12-10T18:53:14Z","changeset":44309486,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4548333683,"user":"gregory derobert","timestamp":"2016-12-10T18:54:13Z","changeset":44309486,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4548335493,"user":"gregory derobert","timestamp":"2016-12-10T18:58:09Z","changeset":44309486,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4548348307,"user":"gregory derobert","timestamp":"2016-12-10T19:00:19Z","changeset":44309486,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4548349145,"user":"n1c0_74","timestamp":"2024-07-30T10:45:14Z","changeset":154599768,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4548354200,"user":"gregory derobert","timestamp":"2016-12-10T19:03:38Z","changeset":44309486,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4548355180,"user":"gregory derobert","timestamp":"2016-12-12T17:17:01Z","changeset":44351783,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4548358488,"user":"gregory derobert","timestamp":"2016-12-10T19:07:45Z","changeset":44309486,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4551174620,"user":"gregory derobert","timestamp":"2016-12-12T17:18:39Z","changeset":44351783,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4551174834,"user":"gregory derobert","timestamp":"2016-12-12T17:19:37Z","changeset":44351783,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4551175696,"user":"gregory derobert","timestamp":"2016-12-12T17:22:05Z","changeset":44351783,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567167994,"user":"gregory derobert","timestamp":"2016-12-22T16:57:38Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567168851,"user":"gregory derobert","timestamp":"2016-12-22T16:59:00Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567169643,"user":"gregory derobert","timestamp":"2016-12-22T17:00:19Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567172327,"user":"gregory derobert","timestamp":"2016-12-22T17:01:12Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567172357,"user":"gregory derobert","timestamp":"2016-12-22T17:02:18Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567173658,"user":"gregory derobert","timestamp":"2016-12-22T17:09:05Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567174458,"user":"gregory derobert","timestamp":"2016-12-22T17:05:16Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567175455,"user":"gregory derobert","timestamp":"2016-12-22T17:06:17Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567177989,"user":"gregory derobert","timestamp":"2016-12-22T17:08:21Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567179103,"user":"gregory derobert","timestamp":"2016-12-22T19:40:53Z","changeset":44599273,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567184205,"user":"gregory derobert","timestamp":"2016-12-22T17:16:38Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567189400,"user":"gregory derobert","timestamp":"2016-12-22T17:22:03Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567191328,"user":"gregory derobert","timestamp":"2016-12-22T17:23:17Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567192691,"user":"gregory derobert","timestamp":"2016-12-22T17:24:18Z","changeset":44595523,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567195533,"user":"Rainbowfly","timestamp":"2025-12-26T07:35:29Z","changeset":176423514,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567203970,"user":"Rainbowfly","timestamp":"2025-12-26T07:35:28Z","changeset":176423515,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":4567207196,"user":"Rainbowfly","timestamp":"2025-12-26T07:35:25Z","changeset":176423514,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":13247633607,"user":"bicente01","timestamp":"2025-10-21T11:12:09Z","changeset":173576638,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":13247633612,"user":"bicente01","timestamp":"2025-12-07T15:27:13Z","changeset":175628502,"noticed_deleted_date":"2026-02-04 12:26:08"},{"type":"node","id":13408209668,"user":"Rainbowfly","timestamp":"2025-12-26T07:35:23Z","changeset":176423515,"noticed_deleted_date":"2026-02-04 12:26:08"}]"
  "[]"
  209974
]
1.30 ms
(0.05%)
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:
[
  9158
]
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:
[
  "01010"
]
0.27 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:
[
  9158
]
0.14 ms
(0.01%)
1
"START TRANSACTION"
Parameters:
[]

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.