Query Metrics
45
Database Queries
7
Different statements
2547.55 ms
Query time
0
Invalid entities
28
Managed entities
Grouped Statements
| 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. |