Query Metrics
55
Database Queries
7
Different statements
258.41 ms
Query time
0
Invalid entities
28
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.21 ms (83.67%) |
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" ]
|
||||||||||||||||||||||||||||||||
|
31.01 ms (12.00%) |
23 |
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"node","id":2565279896,"user":"Jean-Pierre Rondeau","timestamp":"2013-12-04T20:10:54Z","changeset":19278113,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":5215824822,"user":"poletech","timestamp":"2017-11-07T08:55:25Z","changeset":53575735,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":6655024783,"user":"TheFighter137","timestamp":"2025-07-17T07:32:43Z","changeset":169046620,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7042072655,"user":"TheFighter137","timestamp":"2024-08-31T16:57:25Z","changeset":156024334,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7042072656,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7042072657,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7042072658,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7042072659,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7042072660,"user":"pennywise38","timestamp":"2019-12-08T17:12:18Z","changeset":78114141,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333209396,"user":"pennywise38","timestamp":"2020-03-26T21:26:35Z","changeset":82683075,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333209397,"user":"pennywise38","timestamp":"2020-03-26T21:26:35Z","changeset":82683075,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333209398,"user":"pennywise38","timestamp":"2020-03-26T21:26:35Z","changeset":82683075,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333209399,"user":"pennywise38","timestamp":"2020-03-26T21:26:35Z","changeset":82683075,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333209400,"user":"balkhmogaehild","timestamp":"2023-02-21T08:42:52Z","changeset":132824166,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333209401,"user":"TheFighter137","timestamp":"2025-04-14T19:19:43Z","changeset":164954478,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333209402,"user":"TheFighter137","timestamp":"2024-08-31T16:52:24Z","changeset":156024334,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333309579,"user":"pennywise38","timestamp":"2020-03-26T21:49:10Z","changeset":82683641,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333309580,"user":"pennywise38","timestamp":"2020-03-26T21:49:10Z","changeset":82683641,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7333309581,"user":"pennywise38","timestamp":"2020-03-26T21:49:10Z","changeset":82683641,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7335157414,"user":"TheFighter137","timestamp":"2024-10-28T18:47:18Z","changeset":158469206,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7335157415,"user":"TheFighter137","timestamp":"2024-10-30T22:07:45Z","changeset":158561045,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7335157416,"user":"pennywise38","timestamp":"2020-03-27T14:40:12Z","changeset":82719945,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7345690327,"user":"balkhmogaehild","timestamp":"2023-02-21T08:51:50Z","changeset":132824166,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":7345690328,"user":"pennywise38","timestamp":"2020-03-30T08:33:42Z","changeset":82812024,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":12297708392,"user":"TheFighter137","timestamp":"2024-10-30T14:35:40Z","changeset":158544662,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":12297725702,"user":"TheFighter137","timestamp":"2024-10-30T14:33:59Z","changeset":158544662,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":12297725703,"user":"TheFighter137","timestamp":"2024-10-30T14:35:54Z","changeset":158544662,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":12297725707,"user":"TheFighter137","timestamp":"2024-10-30T14:33:57Z","changeset":158544662,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":12356599694,"user":"TheFighter137","timestamp":"2025-07-24T06:04:08Z","changeset":169377764,"noticed_deleted_date":"2026-02-04 20:29:27"},{"type":"node","id":12556035359,"user":"TheFighter137","timestamp":"2025-02-04T09:01:01Z","changeset":162115975,"noticed_deleted_date":"2026-02-04 20:29:27"}]" "[]" 216909 ]
|
||||||||||||||||||||||||||||||||
|
6.37 ms (2.47%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
3.99 ms (1.55%) |
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
]
|
||||||||||||||||||||||||||||||||
|
0.34 ms (0.13%) |
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
]
|
||||||||||||||||||||||||||||||||
|
0.34 ms (0.13%) |
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"
]
|
||||||||||||||||||||||||||||||||
|
0.14 ms (0.05%) |
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. |