Symfony Profiler

Query Metrics

122 Database Queries

11 Different statements

46.70 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.07 ms
(38.70%)

"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\ActionLogger->log (line 33)
4	App\Controller\AdminController->labourer (line 1587)
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)

10.24 ms
(21.93%)

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:

[
  8085
  "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 = 8085 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->generateCityFollowUps (line 96)
9	App\Controller\AdminController->labourer (line 1683)
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)

7.44 ms
(15.92%)

INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "fire_hydrant_count"
  0.0
  "2026-02-03 23:52:16"
  8085
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO city_follow_up (name, measure, date, stats_id)
VALUES
  (?, ?, ?, ?)

INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES ('fire_hydrant_count', 0, '2026-02-03 23:52:16', 8085);

#	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->generateCityFollowUps (line 183)
7	App\Controller\AdminController->labourer (line 1683)
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.50 ms
(11.77%)

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

Parameters:

[
  "[{"type":"node","id":1418161857,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-07T21:38:23Z","changeset":10326061,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335312,"user":"jgd16","timestamp":"2011-09-11T17:18:30Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335320,"user":"jgd16","timestamp":"2011-09-11T17:18:30Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335330,"user":"jgd16","timestamp":"2011-09-11T17:18:30Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335337,"user":"jgd16","timestamp":"2011-09-11T17:18:30Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335338,"user":"jgd16","timestamp":"2011-09-11T17:18:31Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335344,"user":"jgd16","timestamp":"2011-09-11T17:18:31Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335349,"user":"\u00cbdz\u00ebronK","timestamp":"2011-12-31T15:41:20Z","changeset":10255945,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335360,"user":"\u00cbdz\u00ebronK","timestamp":"2011-12-31T15:41:21Z","changeset":10255945,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335361,"user":"\u00cbdz\u00ebronK","timestamp":"2011-12-31T15:41:21Z","changeset":10255945,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335369,"user":"jgd16","timestamp":"2011-09-12T06:58:28Z","changeset":9277528,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335375,"user":"jgd16","timestamp":"2011-09-11T17:18:32Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335382,"user":"jgd16","timestamp":"2011-09-11T17:18:32Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335385,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-15T10:57:50Z","changeset":10396420,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335388,"user":"jgd16","timestamp":"2011-09-11T17:18:32Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430335396,"user":"jgd16","timestamp":"2011-09-11T17:18:32Z","changeset":9272857,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430341026,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T18:03:40Z","changeset":10334549,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430341040,"user":"jgd16","timestamp":"2011-09-11T17:22:08Z","changeset":9272901,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430346395,"user":"Vertruc","timestamp":"2023-02-25T10:17:18Z","changeset":132999055,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1430717741,"user":"jgd16","timestamp":"2011-09-12T06:58:26Z","changeset":9277528,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152057,"user":"jgd16","timestamp":"2011-09-12T18:10:56Z","changeset":9282516,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152059,"user":"jgd16","timestamp":"2011-09-22T18:01:16Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152065,"user":"jgd16","timestamp":"2011-09-12T18:10:56Z","changeset":9282516,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152066,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T14:41:37Z","changeset":10332159,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152067,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T14:41:37Z","changeset":10332159,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152070,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T14:41:38Z","changeset":10332159,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152073,"user":"Rodrigue NOC","timestamp":"2024-02-24T15:27:46Z","changeset":147859917,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152074,"user":"MacDony","timestamp":"2024-12-26T10:22:11Z","changeset":160630576,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152076,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-14T13:07:21Z","changeset":10387328,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152078,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T12:10:15Z","changeset":10330526,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152083,"user":"jgd16","timestamp":"2011-09-22T18:01:17Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152088,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T12:10:15Z","changeset":10330526,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152090,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-14T13:07:21Z","changeset":10387328,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152092,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T18:03:41Z","changeset":10334549,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152101,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-14T13:07:22Z","changeset":10387328,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152105,"user":"jgd16","timestamp":"2011-09-12T18:10:58Z","changeset":9282516,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152106,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T12:10:16Z","changeset":10330526,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152119,"user":"Cayenne17","timestamp":"2022-06-03T11:55:35Z","changeset":121891292,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152124,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T12:10:16Z","changeset":10330526,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152131,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T12:10:16Z","changeset":10330526,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152134,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T12:10:16Z","changeset":10330526,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431152137,"user":"jgd16","timestamp":"2011-09-12T18:10:59Z","changeset":9282516,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165160,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T12:10:16Z","changeset":10330526,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165163,"user":"\u00cbdz\u00ebronK","timestamp":"2019-01-06T11:55:51Z","changeset":66067932,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165173,"user":"jgd16","timestamp":"2011-09-12T18:24:28Z","changeset":9282655,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165181,"user":"jgd16","timestamp":"2011-09-12T18:24:28Z","changeset":9282655,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165182,"user":"jgd16","timestamp":"2011-09-12T18:24:29Z","changeset":9282655,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165183,"user":"jgd16","timestamp":"2011-09-12T18:24:29Z","changeset":9282655,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165184,"user":"jgd16","timestamp":"2011-09-12T18:24:29Z","changeset":9282655,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165185,"user":"jgd16","timestamp":"2011-09-12T18:24:29Z","changeset":9282655,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165188,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-02T18:53:59Z","changeset":10274390,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165190,"user":"\u00cbdz\u00ebronK","timestamp":"2012-02-18T15:33:04Z","changeset":10721253,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1431165191,"user":"\u00cbdz\u00ebronK","timestamp":"2022-03-03T15:13:57Z","changeset":118059600,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409205,"user":"\u00cbdz\u00ebronK","timestamp":"2011-12-27T19:21:13Z","changeset":10218896,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409206,"user":"jgd16","timestamp":"2011-09-20T15:47:58Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409208,"user":"jgd16","timestamp":"2011-09-20T15:47:58Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409209,"user":"jgd16","timestamp":"2011-09-20T15:47:58Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409210,"user":"jgd16","timestamp":"2011-09-20T15:47:58Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409211,"user":"jgd16","timestamp":"2011-09-20T15:47:58Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409212,"user":"jgd16","timestamp":"2011-09-20T15:47:59Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409213,"user":"jgd16","timestamp":"2011-09-20T15:47:59Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409214,"user":"\u00cbdz\u00ebronK","timestamp":"2018-12-31T01:33:22Z","changeset":65901952,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409217,"user":"jgd16","timestamp":"2011-09-20T15:47:59Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409218,"user":"jgd16","timestamp":"2011-09-20T15:47:59Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409219,"user":"jgd16","timestamp":"2011-09-20T15:47:59Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409229,"user":"jgd16","timestamp":"2011-09-20T15:48:00Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409233,"user":"jgd16","timestamp":"2011-09-20T15:48:00Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409238,"user":"R\u00e9gis Vrignaud","timestamp":"2019-10-25T07:29:45Z","changeset":76189810,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409239,"user":"\u00cbdz\u00ebronK","timestamp":"2011-12-27T19:21:14Z","changeset":10218896,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409240,"user":"jgd16","timestamp":"2011-09-20T15:48:00Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409241,"user":"jgd16","timestamp":"2011-09-20T15:48:00Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409254,"user":"jgd16","timestamp":"2011-09-20T15:48:01Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409266,"user":"jgd16","timestamp":"2011-09-20T15:48:02Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409271,"user":"\u00cbdz\u00ebronK","timestamp":"2020-03-12T09:33:29Z","changeset":82104384,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409272,"user":"jgd16","timestamp":"2011-09-20T15:48:02Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409273,"user":"jgd16","timestamp":"2011-09-20T15:48:02Z","changeset":9352546,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1438409274,"user":"\u00cbdz\u00ebronK","timestamp":"2018-12-16T18:00:58Z","changeset":65528074,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569183,"user":"jgd16","timestamp":"2011-09-22T18:01:10Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569186,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-08T18:03:41Z","changeset":10334549,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569190,"user":"\u00cbdz\u00ebronK","timestamp":"2011-12-27T19:21:14Z","changeset":10218896,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569193,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-14T23:06:12Z","changeset":10393535,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569195,"user":"jgd16","timestamp":"2011-09-22T18:01:10Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569197,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-14T23:06:13Z","changeset":10393535,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569199,"user":"jgd16","timestamp":"2011-09-22T18:01:10Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569202,"user":"\u00cbdz\u00ebronK","timestamp":"2011-12-27T19:21:14Z","changeset":10218896,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569206,"user":"\u00cbdz\u00ebronK","timestamp":"2012-01-14T23:06:13Z","changeset":10393535,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569210,"user":"jgd16","timestamp":"2011-09-22T18:01:11Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569214,"user":"jgd16","timestamp":"2011-09-22T18:01:11Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569224,"user":"jgd16","timestamp":"2011-09-22T18:01:11Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569225,"user":"jgd16","timestamp":"2011-09-22T18:01:11Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1440569246,"user":"jgd16","timestamp":"2011-09-22T18:01:11Z","changeset":9370859,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1582691480,"user":"Juju23__","timestamp":"2022-01-03T11:37:58Z","changeset":115706909,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1831979355,"user":"Xapitoun","timestamp":"2012-07-20T12:11:19Z","changeset":12375225,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1831979359,"user":"\u00cbdz\u00ebronK","timestamp":"2019-09-27T13:26:40Z","changeset":75010056,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":1831979361,"user":"Xapitoun","timestamp":"2012-07-20T12:11:19Z","changeset":12375225,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":5178962280,"user":"Pokomams","timestamp":"2022-07-20T10:15:13Z","changeset":123843913,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":6914795282,"user":"R\u00e9gis Vrignaud","timestamp":"2019-10-25T07:29:45Z","changeset":76189810,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":6914811715,"user":"R\u00e9gis Vrignaud","timestamp":"2019-10-25T07:29:13Z","changeset":76189770,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":8938296919,"user":"Guillaume017","timestamp":"2021-07-21T09:21:43Z","changeset":108355990,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":9947521489,"user":"Yod4z","timestamp":"2022-08-11T14:04:29Z","changeset":124778246,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":9947658716,"user":"Yod4z","timestamp":"2022-08-11T15:49:35Z","changeset":124782262,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":9947659750,"user":"Yod4z","timestamp":"2022-08-11T15:08:45Z","changeset":124780715,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":9947735430,"user":"Yod4z","timestamp":"2022-08-11T15:49:35Z","changeset":124782262,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":9949041842,"user":"Yod4z","timestamp":"2022-08-12T10:00:56Z","changeset":124811003,"noticed_deleted_date":"2026-02-03 23:52:16"},{"type":"node","id":9949041845,"user":"Yod4z","timestamp":"2022-08-12T10:00:56Z","changeset":124811003,"noticed_deleted_date":"2026-02-03 23:52:16"}]"
  "[]"
  196473
]

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\":1418161857,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-07T21:38:23Z\",\"changeset\":10326061,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335312,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:30Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335320,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:30Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335330,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:30Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335337,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:30Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335338,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:31Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335344,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:31Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335349,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2011-12-31T15:41:20Z\",\"changeset\":10255945,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335360,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2011-12-31T15:41:21Z\",\"changeset\":10255945,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335361,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2011-12-31T15:41:21Z\",\"changeset\":10255945,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335369,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T06:58:28Z\",\"changeset\":9277528,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335375,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:32Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335382,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:32Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335385,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-15T10:57:50Z\",\"changeset\":10396420,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335388,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:32Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430335396,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:18:32Z\",\"changeset\":9272857,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430341026,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T18:03:40Z\",\"changeset\":10334549,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430341040,\"user\":\"jgd16\",\"timestamp\":\"2011-09-11T17:22:08Z\",\"changeset\":9272901,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430346395,\"user\":\"Vertruc\",\"timestamp\":\"2023-02-25T10:17:18Z\",\"changeset\":132999055,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1430717741,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T06:58:26Z\",\"changeset\":9277528,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152057,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:10:56Z\",\"changeset\":9282516,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152059,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:16Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152065,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:10:56Z\",\"changeset\":9282516,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152066,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T14:41:37Z\",\"changeset\":10332159,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152067,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T14:41:37Z\",\"changeset\":10332159,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152070,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T14:41:38Z\",\"changeset\":10332159,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152073,\"user\":\"Rodrigue NOC\",\"timestamp\":\"2024-02-24T15:27:46Z\",\"changeset\":147859917,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152074,\"user\":\"MacDony\",\"timestamp\":\"2024-12-26T10:22:11Z\",\"changeset\":160630576,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152076,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-14T13:07:21Z\",\"changeset\":10387328,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152078,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T12:10:15Z\",\"changeset\":10330526,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152083,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:17Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152088,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T12:10:15Z\",\"changeset\":10330526,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152090,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-14T13:07:21Z\",\"changeset\":10387328,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152092,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T18:03:41Z\",\"changeset\":10334549,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152101,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-14T13:07:22Z\",\"changeset\":10387328,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152105,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:10:58Z\",\"changeset\":9282516,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152106,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T12:10:16Z\",\"changeset\":10330526,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152119,\"user\":\"Cayenne17\",\"timestamp\":\"2022-06-03T11:55:35Z\",\"changeset\":121891292,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152124,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T12:10:16Z\",\"changeset\":10330526,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152131,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T12:10:16Z\",\"changeset\":10330526,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152134,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T12:10:16Z\",\"changeset\":10330526,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431152137,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:10:59Z\",\"changeset\":9282516,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165160,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T12:10:16Z\",\"changeset\":10330526,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165163,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2019-01-06T11:55:51Z\",\"changeset\":66067932,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165173,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:24:28Z\",\"changeset\":9282655,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165181,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:24:28Z\",\"changeset\":9282655,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165182,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:24:29Z\",\"changeset\":9282655,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165183,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:24:29Z\",\"changeset\":9282655,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165184,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:24:29Z\",\"changeset\":9282655,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165185,\"user\":\"jgd16\",\"timestamp\":\"2011-09-12T18:24:29Z\",\"changeset\":9282655,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165188,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-02T18:53:59Z\",\"changeset\":10274390,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165190,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-02-18T15:33:04Z\",\"changeset\":10721253,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1431165191,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2022-03-03T15:13:57Z\",\"changeset\":118059600,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409205,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2011-12-27T19:21:13Z\",\"changeset\":10218896,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409206,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:58Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409208,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:58Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409209,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:58Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409210,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:58Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409211,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:58Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409212,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:59Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409213,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:59Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409214,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2018-12-31T01:33:22Z\",\"changeset\":65901952,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409217,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:59Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409218,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:59Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409219,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:47:59Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409229,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:48:00Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409233,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:48:00Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409238,\"user\":\"R\\u00e9gis Vrignaud\",\"timestamp\":\"2019-10-25T07:29:45Z\",\"changeset\":76189810,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409239,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2011-12-27T19:21:14Z\",\"changeset\":10218896,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409240,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:48:00Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409241,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:48:00Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409254,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:48:01Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409266,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:48:02Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409271,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2020-03-12T09:33:29Z\",\"changeset\":82104384,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409272,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:48:02Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409273,\"user\":\"jgd16\",\"timestamp\":\"2011-09-20T15:48:02Z\",\"changeset\":9352546,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1438409274,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2018-12-16T18:00:58Z\",\"changeset\":65528074,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569183,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:10Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569186,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-08T18:03:41Z\",\"changeset\":10334549,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569190,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2011-12-27T19:21:14Z\",\"changeset\":10218896,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569193,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-14T23:06:12Z\",\"changeset\":10393535,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569195,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:10Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569197,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-14T23:06:13Z\",\"changeset\":10393535,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569199,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:10Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569202,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2011-12-27T19:21:14Z\",\"changeset\":10218896,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569206,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2012-01-14T23:06:13Z\",\"changeset\":10393535,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569210,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:11Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569214,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:11Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569224,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:11Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569225,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:11Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1440569246,\"user\":\"jgd16\",\"timestamp\":\"2011-09-22T18:01:11Z\",\"changeset\":9370859,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1582691480,\"user\":\"Juju23__\",\"timestamp\":\"2022-01-03T11:37:58Z\",\"changeset\":115706909,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1831979355,\"user\":\"Xapitoun\",\"timestamp\":\"2012-07-20T12:11:19Z\",\"changeset\":12375225,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1831979359,\"user\":\"\\u00cbdz\\u00ebronK\",\"timestamp\":\"2019-09-27T13:26:40Z\",\"changeset\":75010056,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":1831979361,\"user\":\"Xapitoun\",\"timestamp\":\"2012-07-20T12:11:19Z\",\"changeset\":12375225,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":5178962280,\"user\":\"Pokomams\",\"timestamp\":\"2022-07-20T10:15:13Z\",\"changeset\":123843913,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":6914795282,\"user\":\"R\\u00e9gis Vrignaud\",\"timestamp\":\"2019-10-25T07:29:45Z\",\"changeset\":76189810,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":6914811715,\"user\":\"R\\u00e9gis Vrignaud\",\"timestamp\":\"2019-10-25T07:29:13Z\",\"changeset\":76189770,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":8938296919,\"user\":\"Guillaume017\",\"timestamp\":\"2021-07-21T09:21:43Z\",\"changeset\":108355990,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":9947521489,\"user\":\"Yod4z\",\"timestamp\":\"2022-08-11T14:04:29Z\",\"changeset\":124778246,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":9947658716,\"user\":\"Yod4z\",\"timestamp\":\"2022-08-11T15:49:35Z\",\"changeset\":124782262,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":9947659750,\"user\":\"Yod4z\",\"timestamp\":\"2022-08-11T15:08:45Z\",\"changeset\":124780715,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":9947735430,\"user\":\"Yod4z\",\"timestamp\":\"2022-08-11T15:49:35Z\",\"changeset\":124782262,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":9949041842,\"user\":\"Yod4z\",\"timestamp\":\"2022-08-12T10:00:56Z\",\"changeset\":124811003,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"},{\"type\":\"node\",\"id\":9949041845,\"user\":\"Yod4z\",\"timestamp\":\"2022-08-12T10:00:56Z\",\"changeset\":124811003,\"noticed_deleted_date\":\"2026-02-03 23:52:16\"}]', current_list = '[]' WHERE id = 196473;

#	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->generateCityFollowUps (line 183)
7	App\Controller\AdminController->labourer (line 1683)
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)

2.85 ms
(6.11%)

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

Parameters:

[
  "[]"
  "[]"
  "charging_station"
  8085
]

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 ('[]', '[]', 'charging_station', 8085);

#	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->generateCityFollowUps (line 183)
7	App\Controller\AdminController->labourer (line 1683)
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.70 ms
(1.50%)

UPDATE stats SET completion_percent = ?, lat = ?, lon = ?, date_labourage_requested = ? WHERE id = ?

Parameters:

[
  0
  "46.6458"
  "-0.235"
  "2026-02-03 23:52:16"
  8085
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  stats
SET
  completion_percent = ?,
  lat = ?,
  lon = ?,
  date_labourage_requested = ?
WHERE
  id = ?

UPDATE stats SET completion_percent = 0, lat = '46.6458', lon = '-0.235', date_labourage_requested = '2026-02-03 23:52:16' WHERE id = 8085;

#	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\Controller\AdminController->labourer (line 1659)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.57 ms
(1.23%)

"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\ActionLogger->log (line 33)
4	App\Controller\AdminController->labourer (line 1587)
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.45 ms
(0.96%)

SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = ?

Parameters:

[
  8085
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid_for_url AS uuid_for_url_2,
  t0.osm_kind AS osm_kind_3,
  t0.email AS email_4,
  t0.opted_out AS opted_out_5,
  t0.dead AS dead_6,
  t0.note AS note_7,
  t0.modified_date AS modified_date_8,
  t0.zip_code AS zip_code_9,
  t0.asked_humains_support AS asked_humains_support_10,
  t0.last_contact_attempt_date AS last_contact_attempt_date_11,
  t0.osm_id AS osm_id_12,
  t0.name AS name_13,
  t0.has_opening_hours AS has_opening_hours_14,
  t0.has_address AS has_address_15,
  t0.has_website AS has_website_16,
  t0.has_wheelchair AS has_wheelchair_17,
  t0.has_note AS has_note_18,
  t0.main_tag AS main_tag_19,
  t0.note_content AS note_content_20,
  t0.displayed_date AS displayed_date_21,
  t0.lat AS lat_22,
  t0.lon AS lon_23,
  t0.street AS street_24,
  t0.housenumber AS housenumber_25,
  t0.siret AS siret_26,
  t0.habitants AS habitants_27,
  t0.osm_data_date AS osm_data_date_28,
  t0.osm_version AS osm_version_29,
  t0.osm_user AS osm_user_30,
  t0.osm_uid AS osm_uid_31,
  t0.osm_changeset AS osm_changeset_32,
  t0.email_content AS email_content_33,
  t0.place_count AS place_count_34,
  t0.stats_id AS stats_id_35
FROM
  place t0
WHERE
  t0.stats_id = ?

SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = 8085;

#	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->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Stats->computeCompletionPercent (line 221)
9	App\Controller\AdminController->labourer (line 1656)
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)

0.37 ms
(0.78%)

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:

[
  "79202"
]

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 = '79202' 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\AdminController->labourer (line 1595)
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.28 ms
(0.59%)

UPDATE stats SET date_labourage_done = ? WHERE id = ?

Parameters:

[
  "2026-02-03 23:52:16"
  8085
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  stats
SET
  date_labourage_done = ?
WHERE
  id = ?

UPDATE stats SET date_labourage_done = '2026-02-03 23:52:16' WHERE id = 8085;

#	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\Controller\AdminController->labourer (line 1674)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.24 ms
(0.50%)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "labourer"
  "{"insee_code":"79202"}"
  "2026-02-03 23:52:16"
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO action_log (
  type, data, created_at, from_url, who
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES ('labourer', '{\"insee_code\":\"79202\"}', '2026-02-03 23:52:16', NULL, NULL);

#	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\ActionLogger->log (line 33)
7	App\Controller\AdminController->labourer (line 1587)
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)

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

Entities Mapping

Class	Mapping errors
App\Entity\ActionLog	No 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/admin/labourer/79202?deleteMissing=1&disableFollowUpCleanup=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping