Redirect 302 redirect from GET @app_public_edit (3ae807)

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

Response
200 OK
IP
216.73.216.172
Profiled on
Token
a803bf

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
18.66 ms
(50.89%) 		23 
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "[]"
  "[{"type":"node","id":12300322970,"user":"TheFighter137","timestamp":"2025-07-24T11:04:18Z","changeset":169391920},{"type":"node","id":12809537020,"user":"TheFighter137","timestamp":"2025-05-04T13:32:56Z","changeset":165800438}]"
  "charging_station"
  9417
]
View formatted query    View runnable query    Explain query    View query backtrace
7.29 ms
(19.87%) 		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: 
[
  9417
  "fire_hydrant"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.93 ms
(13.45%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.21 ms
(8.76%) 		4 
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters: 
[
  "[{"type":"node","id":2565279896,"user":"Jean-Pierre Rondeau","timestamp":"2013-12-04T20:10:54Z","changeset":19278113},{"type":"node","id":5215824822,"user":"poletech","timestamp":"2017-11-07T08:55:25Z","changeset":53575735},{"type":"node","id":6655024783,"user":"TheFighter137","timestamp":"2025-07-17T07:32:43Z","changeset":169046620},{"type":"node","id":7042072655,"user":"TheFighter137","timestamp":"2024-08-31T16:57:25Z","changeset":156024334},{"type":"node","id":7042072656,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141},{"type":"node","id":7042072657,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141},{"type":"node","id":7042072658,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141},{"type":"node","id":7042072659,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141},{"type":"node","id":7042072660,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141},{"type":"node","id":7333209396,"user":"pennywise38","timestamp":"2020-03-26T21:26:35Z","changeset":82683075},{"type":"node","id":7333209397,"user":"pennywise38","timestamp":"2020-03-26T21:26:35Z","changeset":82683075},{"type":"node","id":7333209398,"user":"pennywise38","timestamp":"2020-03-26T21:26:35Z","changeset":82683075},{"type":"node","id":7333209399,"user":"pennywise38","timestamp":"2020-03-26T21:26:35Z","changeset":82683075},{"type":"node","id":7333209400,"user":"balkhmogaehild","timestamp":"2023-02-21T08:42:52Z","changeset":132824166},{"type":"node","id":7333209401,"user":"TheFighter137","timestamp":"2025-04-14T19:19:43Z","changeset":164954478},{"type":"node","id":7333209402,"user":"TheFighter137","timestamp":"2024-08-31T16:52:24Z","changeset":156024334},{"type":"node","id":7333309579,"user":"pennywise38","timestamp":"2020-03-26T21:49:10Z","changeset":82683641},{"type":"node","id":7333309580,"user":"pennywise38","timestamp":"2020-03-26T21:49:10Z","changeset":82683641},{"type":"node","id":7333309581,"user":"pennywise38","timestamp":"2020-03-26T21:49:10Z","changeset":82683641},{"type":"node","id":7335157414,"user":"TheFighter137","timestamp":"2024-10-28T18:47:18Z","changeset":158469206},{"type":"node","id":7335157415,"user":"TheFighter137","timestamp":"2024-10-30T22:07:45Z","changeset":158561045},{"type":"node","id":7335157416,"user":"pennywise38","timestamp":"2020-03-27T14:40:12Z","changeset":82719945},{"type":"node","id":7345690327,"user":"balkhmogaehild","timestamp":"2023-02-21T08:51:50Z","changeset":132824166},{"type":"node","id":7345690328,"user":"pennywise38","timestamp":"2020-03-30T08:33:42Z","changeset":82812024},{"type":"node","id":12297708392,"user":"TheFighter137","timestamp":"2024-10-30T14:35:40Z","changeset":158544662},{"type":"node","id":12297725702,"user":"TheFighter137","timestamp":"2024-10-30T14:33:59Z","changeset":158544662},{"type":"node","id":12297725703,"user":"TheFighter137","timestamp":"2024-10-30T14:35:54Z","changeset":158544662},{"type":"node","id":12297725707,"user":"TheFighter137","timestamp":"2024-10-30T14:33:57Z","changeset":158544662},{"type":"node","id":12356599694,"user":"TheFighter137","timestamp":"2025-07-24T06:04:08Z","changeset":169377764},{"type":"node","id":12556035359,"user":"TheFighter137","timestamp":"2025-02-04T09:01:01Z","changeset":162115975}]"
  216909
]
View formatted query    View runnable query    Explain query    View query backtrace
1.80 ms
(4.90%) 		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: 
[
  9417
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.94%) 		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: 
[
  "76655"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.78%) 		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: 
[
  9417
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.40%) 		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.