Symfony Profiler

Query Metrics

59 Database Queries

8 Different statements

26.16 ms Query time

0 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.58 ms
(36.62%)

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:

[
  9187
  "fire_hydrant"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 9187 AND z0_.theme = 'fire_hydrant';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\ZonePlacesRepository->findOneByStatsAndTheme (line 31)
7	App\Service\FollowUpService->updateZonePlacesForTheme (line 641)
8	App\Service\FollowUpService->refreshAllZonePlaces (line 747)
9	App\Controller\PublicController->zonePlacesHistory (line 1786)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

6.15 ms
(23.50%)

UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?

Parameters:

[
  "[{"type":"node","id":1400316279,"user":"Everteal","timestamp":"2025-10-18T21:48:41Z","changeset":173468831,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":1946243133,"user":"Alexandre148025","timestamp":"2025-01-17T08:39:11Z","changeset":161445901,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":3585876793,"user":"fgouget","timestamp":"2021-11-15T22:02:50Z","changeset":113826706,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":3585876794,"user":"Uinen86","timestamp":"2020-03-26T01:42:39Z","changeset":82633850,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":4886558794,"user":"Lisapple","timestamp":"2024-10-25T19:02:51Z","changeset":158351298,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":4887155124,"user":"Lisapple","timestamp":"2024-10-25T19:21:04Z","changeset":158351919,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":5729578123,"user":"jcnl44","timestamp":"2025-11-15T16:04:06Z","changeset":174693619,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":6383580367,"user":"Alexandre148025","timestamp":"2024-11-18T10:48:19Z","changeset":159277621,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7160288690,"user":"Alexandre148025","timestamp":"2024-11-14T18:24:04Z","changeset":159136883,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7190762983,"user":"map-dynartio","timestamp":"2025-04-27T21:00:18Z","changeset":165523694,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7389839661,"user":"jcnl44","timestamp":"2025-11-15T16:04:06Z","changeset":174693619,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7406321458,"user":"Lisapple","timestamp":"2024-10-28T18:33:42Z","changeset":158468661,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7406331230,"user":"map-dynartio","timestamp":"2025-04-27T11:03:13Z","changeset":165500257,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7407510676,"user":"Lisapple","timestamp":"2024-10-30T13:24:39Z","changeset":158541487,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7408598899,"user":"Lisapple","timestamp":"2024-10-25T19:06:39Z","changeset":158351476,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7659250344,"user":"chabe01","timestamp":"2022-08-18T20:49:00Z","changeset":125080620,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7660768257,"user":"Alexandre148025","timestamp":"2024-11-16T10:17:31Z","changeset":159201487,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":7855400021,"user":"MatthieuGD","timestamp":"2020-08-28T21:39:27Z","changeset":90100965,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":8137057732,"user":"j-l-j","timestamp":"2020-11-18T11:03:42Z","changeset":94355288,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":8152348771,"user":"Alexandre148025","timestamp":"2024-11-15T13:44:52Z","changeset":159171343,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":8152370980,"user":"j-l-j","timestamp":"2020-11-22T22:37:48Z","changeset":94600970,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":8152390392,"user":"Alexandre148025","timestamp":"2024-07-20T14:14:33Z","changeset":154181433,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":8734770717,"user":"Alexandre148025","timestamp":"2024-11-05T13:10:05Z","changeset":158778496,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":8734783917,"user":"Diablo l'incroyable","timestamp":"2021-05-15T19:29:44Z","changeset":104746488,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":8734793117,"user":"Diablo l'incroyable","timestamp":"2021-05-15T19:34:54Z","changeset":104746488,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":8734822217,"user":"Alexandre148025","timestamp":"2024-11-16T10:17:37Z","changeset":159201487,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":9186929312,"user":"Lisapple","timestamp":"2024-10-30T13:32:26Z","changeset":158541774,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":9187076020,"user":"Mickael S","timestamp":"2021-10-20T11:44:39Z","changeset":112740517,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":9187076021,"user":"Mickael S","timestamp":"2021-10-20T11:44:39Z","changeset":112740517,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":9187076022,"user":"Mickael S","timestamp":"2021-10-20T11:44:39Z","changeset":112740517,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12031082669,"user":"Tr1pop","timestamp":"2024-07-03T11:45:51Z","changeset":153498306,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12066075373,"user":"Lisapple","timestamp":"2024-10-26T15:42:05Z","changeset":158382108,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12069468016,"user":"Alexandre148025","timestamp":"2024-07-23T08:13:15Z","changeset":154294377,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12069468194,"user":"Lisapple","timestamp":"2024-10-30T13:24:59Z","changeset":158541487,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12069768102,"user":"Alexandre148025","timestamp":"2024-07-23T11:58:58Z","changeset":154303827,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12071113255,"user":"Everteal","timestamp":"2025-10-18T21:48:41Z","changeset":173468831,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12073226797,"user":"Alexandre148025","timestamp":"2024-07-25T09:51:21Z","changeset":154384977,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12073429079,"user":"Alexandre148025","timestamp":"2024-07-25T12:15:29Z","changeset":154391371,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12075167791,"user":"Alexandre148025","timestamp":"2024-07-26T12:06:56Z","changeset":154439391,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12271416452,"user":"Everteal","timestamp":"2025-10-18T21:48:41Z","changeset":173468831,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12271631863,"user":"Alexandre148025","timestamp":"2024-11-14T13:49:47Z","changeset":159131216,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12272056175,"user":"pyrog","timestamp":"2025-06-26T17:26:57Z","changeset":168150655,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12272056176,"user":"map-dynartio","timestamp":"2025-04-27T17:50:00Z","changeset":165517137,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12272056177,"user":"NW-osm","timestamp":"2024-10-20T22:46:07Z","changeset":158148121,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12339089124,"user":"Alexandre148025","timestamp":"2024-11-14T10:12:44Z","changeset":159123346,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":12339089152,"user":"Alexandre148025","timestamp":"2024-11-14T10:12:44Z","changeset":159123346,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"node","id":13081273601,"user":"krair","timestamp":"2025-08-19T06:39:42Z","changeset":170651334,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":35734022,"user":"Lisapple","timestamp":"2024-10-25T19:07:02Z","changeset":158351476,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":39383181,"user":"benoitdd","timestamp":"2023-04-27T17:00:49Z","changeset":135436507,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":44050233,"user":"Alexandre148025","timestamp":"2024-11-15T10:03:24Z","changeset":159162938,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":44170554,"user":"Lisapple","timestamp":"2024-10-26T15:40:22Z","changeset":158382060,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64558097,"user":"gendy54","timestamp":"2019-01-26T20:07:38Z","changeset":66663283,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64558736,"user":"map-dynartio","timestamp":"2026-02-03T16:50:01Z","changeset":178059593,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64561720,"user":"Rom1","timestamp":"2021-12-09T07:55:28Z","changeset":114730807,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64564632,"user":"Alexandre148025","timestamp":"2024-07-20T14:50:25Z","changeset":154183019,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64566568,"user":"Lisapple","timestamp":"2024-10-26T15:41:42Z","changeset":158382108,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64569189,"user":"Alexandre148025","timestamp":"2024-07-22T14:39:42Z","changeset":154266699,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64569516,"user":"NW-osm","timestamp":"2022-10-29T10:09:04Z","changeset":128204419,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64574292,"user":"Lisapple","timestamp":"2024-10-26T15:47:43Z","changeset":158382351,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":64584669,"user":"chabe01","timestamp":"2022-08-18T20:49:02Z","changeset":125080620,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":200756353,"user":"Lisapple","timestamp":"2024-10-28T18:34:14Z","changeset":158468661,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":1087324130,"user":"Lisapple","timestamp":"2024-10-30T13:24:34Z","changeset":158541487,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":1302710338,"user":"Alexandre148025","timestamp":"2024-07-20T14:50:25Z","changeset":154183019,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":1303426625,"user":"Alexandre148025","timestamp":"2024-07-24T08:33:11Z","changeset":154338336,"noticed_deleted_date":"2026-02-04 08:45:33"},{"type":"way","id":1333747907,"user":"Lisapple","timestamp":"2025-08-18T18:11:43Z","changeset":170634246,"noticed_deleted_date":"2026-02-04 08:45:33"}]"
  "[]"
  208309
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  zone_places
SET
  disappeared_list = ?,
  current_list = ?
WHERE
  id = ?

UPDATE zone_places SET disappeared_list = '[{\"type\":\"node\",\"id\":1400316279,\"user\":\"Everteal\",\"timestamp\":\"2025-10-18T21:48:41Z\",\"changeset\":173468831,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":1946243133,\"user\":\"Alexandre148025\",\"timestamp\":\"2025-01-17T08:39:11Z\",\"changeset\":161445901,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":3585876793,\"user\":\"fgouget\",\"timestamp\":\"2021-11-15T22:02:50Z\",\"changeset\":113826706,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":3585876794,\"user\":\"Uinen86\",\"timestamp\":\"2020-03-26T01:42:39Z\",\"changeset\":82633850,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":4886558794,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-25T19:02:51Z\",\"changeset\":158351298,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":4887155124,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-25T19:21:04Z\",\"changeset\":158351919,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":5729578123,\"user\":\"jcnl44\",\"timestamp\":\"2025-11-15T16:04:06Z\",\"changeset\":174693619,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":6383580367,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-18T10:48:19Z\",\"changeset\":159277621,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7160288690,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-14T18:24:04Z\",\"changeset\":159136883,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7190762983,\"user\":\"map-dynartio\",\"timestamp\":\"2025-04-27T21:00:18Z\",\"changeset\":165523694,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7389839661,\"user\":\"jcnl44\",\"timestamp\":\"2025-11-15T16:04:06Z\",\"changeset\":174693619,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7406321458,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-28T18:33:42Z\",\"changeset\":158468661,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7406331230,\"user\":\"map-dynartio\",\"timestamp\":\"2025-04-27T11:03:13Z\",\"changeset\":165500257,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7407510676,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-30T13:24:39Z\",\"changeset\":158541487,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7408598899,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-25T19:06:39Z\",\"changeset\":158351476,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7659250344,\"user\":\"chabe01\",\"timestamp\":\"2022-08-18T20:49:00Z\",\"changeset\":125080620,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7660768257,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-16T10:17:31Z\",\"changeset\":159201487,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":7855400021,\"user\":\"MatthieuGD\",\"timestamp\":\"2020-08-28T21:39:27Z\",\"changeset\":90100965,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":8137057732,\"user\":\"j-l-j\",\"timestamp\":\"2020-11-18T11:03:42Z\",\"changeset\":94355288,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":8152348771,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-15T13:44:52Z\",\"changeset\":159171343,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":8152370980,\"user\":\"j-l-j\",\"timestamp\":\"2020-11-22T22:37:48Z\",\"changeset\":94600970,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":8152390392,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-20T14:14:33Z\",\"changeset\":154181433,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":8734770717,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-05T13:10:05Z\",\"changeset\":158778496,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":8734783917,\"user\":\"Diablo l\'incroyable\",\"timestamp\":\"2021-05-15T19:29:44Z\",\"changeset\":104746488,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":8734793117,\"user\":\"Diablo l\'incroyable\",\"timestamp\":\"2021-05-15T19:34:54Z\",\"changeset\":104746488,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":8734822217,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-16T10:17:37Z\",\"changeset\":159201487,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":9186929312,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-30T13:32:26Z\",\"changeset\":158541774,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":9187076020,\"user\":\"Mickael S\",\"timestamp\":\"2021-10-20T11:44:39Z\",\"changeset\":112740517,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":9187076021,\"user\":\"Mickael S\",\"timestamp\":\"2021-10-20T11:44:39Z\",\"changeset\":112740517,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":9187076022,\"user\":\"Mickael S\",\"timestamp\":\"2021-10-20T11:44:39Z\",\"changeset\":112740517,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12031082669,\"user\":\"Tr1pop\",\"timestamp\":\"2024-07-03T11:45:51Z\",\"changeset\":153498306,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12066075373,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-26T15:42:05Z\",\"changeset\":158382108,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12069468016,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-23T08:13:15Z\",\"changeset\":154294377,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12069468194,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-30T13:24:59Z\",\"changeset\":158541487,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12069768102,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-23T11:58:58Z\",\"changeset\":154303827,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12071113255,\"user\":\"Everteal\",\"timestamp\":\"2025-10-18T21:48:41Z\",\"changeset\":173468831,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12073226797,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-25T09:51:21Z\",\"changeset\":154384977,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12073429079,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-25T12:15:29Z\",\"changeset\":154391371,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12075167791,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-26T12:06:56Z\",\"changeset\":154439391,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12271416452,\"user\":\"Everteal\",\"timestamp\":\"2025-10-18T21:48:41Z\",\"changeset\":173468831,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12271631863,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-14T13:49:47Z\",\"changeset\":159131216,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12272056175,\"user\":\"pyrog\",\"timestamp\":\"2025-06-26T17:26:57Z\",\"changeset\":168150655,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12272056176,\"user\":\"map-dynartio\",\"timestamp\":\"2025-04-27T17:50:00Z\",\"changeset\":165517137,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12272056177,\"user\":\"NW-osm\",\"timestamp\":\"2024-10-20T22:46:07Z\",\"changeset\":158148121,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12339089124,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-14T10:12:44Z\",\"changeset\":159123346,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":12339089152,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-14T10:12:44Z\",\"changeset\":159123346,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"node\",\"id\":13081273601,\"user\":\"krair\",\"timestamp\":\"2025-08-19T06:39:42Z\",\"changeset\":170651334,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":35734022,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-25T19:07:02Z\",\"changeset\":158351476,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":39383181,\"user\":\"benoitdd\",\"timestamp\":\"2023-04-27T17:00:49Z\",\"changeset\":135436507,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":44050233,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-11-15T10:03:24Z\",\"changeset\":159162938,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":44170554,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-26T15:40:22Z\",\"changeset\":158382060,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64558097,\"user\":\"gendy54\",\"timestamp\":\"2019-01-26T20:07:38Z\",\"changeset\":66663283,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64558736,\"user\":\"map-dynartio\",\"timestamp\":\"2026-02-03T16:50:01Z\",\"changeset\":178059593,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64561720,\"user\":\"Rom1\",\"timestamp\":\"2021-12-09T07:55:28Z\",\"changeset\":114730807,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64564632,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-20T14:50:25Z\",\"changeset\":154183019,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64566568,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-26T15:41:42Z\",\"changeset\":158382108,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64569189,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-22T14:39:42Z\",\"changeset\":154266699,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64569516,\"user\":\"NW-osm\",\"timestamp\":\"2022-10-29T10:09:04Z\",\"changeset\":128204419,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64574292,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-26T15:47:43Z\",\"changeset\":158382351,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":64584669,\"user\":\"chabe01\",\"timestamp\":\"2022-08-18T20:49:02Z\",\"changeset\":125080620,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":200756353,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-28T18:34:14Z\",\"changeset\":158468661,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":1087324130,\"user\":\"Lisapple\",\"timestamp\":\"2024-10-30T13:24:34Z\",\"changeset\":158541487,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":1302710338,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-20T14:50:25Z\",\"changeset\":154183019,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":1303426625,\"user\":\"Alexandre148025\",\"timestamp\":\"2024-07-24T08:33:11Z\",\"changeset\":154338336,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"},{\"type\":\"way\",\"id\":1333747907,\"user\":\"Lisapple\",\"timestamp\":\"2025-08-18T18:11:43Z\",\"changeset\":170634246,\"noticed_deleted_date\":\"2026-02-04 08:45:33\"}]', current_list = '[]' WHERE id = 208309;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1139)
4	Doctrine\ORM\UnitOfWork->commit (line 407)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\FollowUpService->refreshAllZonePlaces (line 756)
7	App\Controller\PublicController->zonePlacesHistory (line 1786)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

5.72 ms
(21.88%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 432)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\FollowUpService->refreshAllZonePlaces (line 756)
4	App\Controller\PublicController->zonePlacesHistory (line 1786)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

3.54 ms
(13.54%)

INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "[]"
  "[]"
  "fire_hydrant"
  9187
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO zone_places (
  disappeared_list, current_list, theme,
  stats_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES ('[]', '[]', 'fire_hydrant', 9187);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\FollowUpService->refreshAllZonePlaces (line 756)
7	App\Controller\PublicController->zonePlacesHistory (line 1786)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.44 ms
(1.67%)

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:

[
  9187
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 9187;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\PublicController->zonePlacesHistory (line 1821)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.35 ms
(1.33%)

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:

[
  "16015"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '16015' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\PublicController->zonePlacesHistory (line 1763)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.22 ms
(0.86%)

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:

[
  9187
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 9187;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\PublicController->zonePlacesHistory (line 1936)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.15 ms
(0.59%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\FollowUpService->refreshAllZonePlaces (line 756)
4	App\Controller\PublicController->zonePlacesHistory (line 1786)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping