Symfony Profiler

Query Metrics

59 Database Queries

8 Different statements

16.71 ms Query time

0 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.00 ms
(35.92%)

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:

[
  9099
  "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 = 9099 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)

4.19 ms
(25.04%)

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

Parameters:

[
  "[]"
  "[{"type":"node","id":3058481863,"user":"vincent_95","timestamp":"2014-09-04T04:47:14Z","changeset":25218724},{"type":"node","id":3058481864,"user":"vincent_95","timestamp":"2017-12-15T12:14:00Z","changeset":54651757}]"
  "fire_hydrant"
  9099
]

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 ('[]', '[{\"type\":\"node\",\"id\":3058481863,\"user\":\"vincent_95\",\"timestamp\":\"2014-09-04T04:47:14Z\",\"changeset\":25218724},{\"type\":\"node\",\"id\":3058481864,\"user\":\"vincent_95\",\"timestamp\":\"2017-12-15T12:14:00Z\",\"changeset\":54651757}]', 'fire_hydrant', 9099);

#	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)

3.46 ms
(20.71%)

"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)

1.98 ms
(11.86%)

UPDATE zone_places SET current_list = ? WHERE id = ?

Parameters:

[
  "[{"type":"way","id":295277648,"user":"botdidier2020","timestamp":"2014-08-03T07:57:38Z","changeset":24510179},{"type":"way","id":295277649,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:43Z","changeset":24468422},{"type":"way","id":295277650,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277651,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277652,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277653,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277654,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277655,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277656,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277657,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277658,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277659,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277660,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277661,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:44Z","changeset":24468422},{"type":"way","id":295277662,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277663,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277664,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277665,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277666,"user":"Olyon","timestamp":"2024-01-11T19:13:46Z","changeset":146155500},{"type":"way","id":295277667,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277668,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277669,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277670,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277671,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277673,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277674,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:45Z","changeset":24468422},{"type":"way","id":295277675,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277677,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277679,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277681,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277682,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277683,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277684,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277685,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277686,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277687,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277688,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277689,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277690,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277691,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277692,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277693,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:46Z","changeset":24468422},{"type":"way","id":295277694,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277695,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277696,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277698,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277699,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277700,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277701,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277702,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277703,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277704,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277705,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277706,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:47Z","changeset":24468422},{"type":"way","id":295277709,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277710,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277711,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277712,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277714,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277715,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277716,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277717,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277718,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277719,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277720,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277721,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277722,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277723,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277724,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:48Z","changeset":24468422},{"type":"way","id":295277725,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277726,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277727,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277728,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277729,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277730,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277732,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277733,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277734,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277735,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277736,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277737,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277738,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277739,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277740,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277741,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:49Z","changeset":24468422},{"type":"way","id":295277742,"user":"vincent_95","timestamp":"2017-12-15T12:14:00Z","changeset":54651757},{"type":"way","id":295277743,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277744,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277745,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277746,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277747,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277748,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277749,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277750,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277751,"user":"botdidier2020","timestamp":"2014-08-03T07:57:38Z","changeset":24510179},{"type":"way","id":295277752,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277753,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277754,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":295277755,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277756,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277757,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277758,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277759,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:50Z","changeset":24468422},{"type":"way","id":295277760,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277762,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277763,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277764,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277765,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277766,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277767,"user":"botdidier2020","timestamp":"2014-08-03T07:57:38Z","changeset":24510179},{"type":"way","id":295277768,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277769,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277770,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277771,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277772,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:51Z","changeset":24468422},{"type":"way","id":295277773,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277775,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277776,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277777,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277778,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277779,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277780,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277781,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277782,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277783,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277784,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277785,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277786,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:52Z","changeset":24468422},{"type":"way","id":295277787,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277788,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277789,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277790,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277791,"user":"nlehuby","timestamp":"2025-05-08T17:21:11Z","changeset":165994979},{"type":"way","id":295277792,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277793,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277794,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277795,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277796,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277797,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277798,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277799,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:53Z","changeset":24468422},{"type":"way","id":295277800,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277801,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277803,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277804,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277805,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277806,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277807,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277808,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277809,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277810,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277811,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277812,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277813,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277814,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277815,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:54Z","changeset":24468422},{"type":"way","id":295277816,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277817,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277818,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277819,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277820,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277821,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277823,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277824,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277825,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277826,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277827,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:55Z","changeset":24468422},{"type":"way","id":295277828,"user":"botdidier2020","timestamp":"2014-08-03T07:57:38Z","changeset":24510179},{"type":"way","id":295277829,"user":"GeorgeKaplan","timestamp":"2014-07-31T18:44:56Z","changeset":24468422},{"type":"way","id":317795598,"user":"JBacc1","timestamp":"2014-12-18T13:32:18Z","changeset":27550551},{"type":"way","id":1153718587,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718588,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718590,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718592,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718593,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564},{"type":"way","id":1153718594,"user":"Eric V","timestamp":"2023-03-12T10:57:47Z","changeset":133581564}]"
  212145
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  zone_places
SET
  current_list = ?
WHERE
  id = ?

UPDATE zone_places SET current_list = '[{\"type\":\"way\",\"id\":295277648,\"user\":\"botdidier2020\",\"timestamp\":\"2014-08-03T07:57:38Z\",\"changeset\":24510179},{\"type\":\"way\",\"id\":295277649,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:43Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277650,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277651,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277652,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277653,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277654,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277655,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277656,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277657,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277658,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277659,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277660,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277661,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:44Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277662,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277663,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277664,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277665,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277666,\"user\":\"Olyon\",\"timestamp\":\"2024-01-11T19:13:46Z\",\"changeset\":146155500},{\"type\":\"way\",\"id\":295277667,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277668,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277669,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277670,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277671,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277673,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277674,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:45Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277675,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277677,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277679,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277681,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277682,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277683,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277684,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277685,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277686,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277687,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277688,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277689,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277690,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277691,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277692,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277693,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:46Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277694,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277695,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277696,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277698,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277699,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277700,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277701,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277702,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277703,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277704,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277705,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277706,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:47Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277709,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277710,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277711,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277712,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277714,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277715,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277716,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277717,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277718,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277719,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277720,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277721,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277722,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277723,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277724,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:48Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277725,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277726,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277727,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277728,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277729,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277730,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277732,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277733,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277734,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277735,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277736,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277737,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277738,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277739,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277740,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277741,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:49Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277742,\"user\":\"vincent_95\",\"timestamp\":\"2017-12-15T12:14:00Z\",\"changeset\":54651757},{\"type\":\"way\",\"id\":295277743,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277744,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277745,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277746,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277747,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277748,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277749,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277750,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277751,\"user\":\"botdidier2020\",\"timestamp\":\"2014-08-03T07:57:38Z\",\"changeset\":24510179},{\"type\":\"way\",\"id\":295277752,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277753,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277754,\"user\":\"Eric V\",\"timestamp\":\"2023-03-12T10:57:47Z\",\"changeset\":133581564},{\"type\":\"way\",\"id\":295277755,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277756,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277757,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277758,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277759,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:50Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277760,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277762,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277763,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277764,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277765,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277766,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277767,\"user\":\"botdidier2020\",\"timestamp\":\"2014-08-03T07:57:38Z\",\"changeset\":24510179},{\"type\":\"way\",\"id\":295277768,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277769,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277770,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277771,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277772,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:51Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277773,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277775,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277776,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277777,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277778,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277779,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277780,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277781,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277782,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277783,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277784,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277785,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277786,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:52Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277787,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277788,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277789,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277790,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277791,\"user\":\"nlehuby\",\"timestamp\":\"2025-05-08T17:21:11Z\",\"changeset\":165994979},{\"type\":\"way\",\"id\":295277792,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277793,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277794,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277795,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277796,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277797,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277798,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277799,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:53Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277800,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277801,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277803,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277804,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277805,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277806,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277807,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277808,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277809,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277810,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277811,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277812,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277813,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277814,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277815,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:54Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277816,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277817,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277818,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277819,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277820,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277821,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277823,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277824,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277825,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277826,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277827,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:55Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":295277828,\"user\":\"botdidier2020\",\"timestamp\":\"2014-08-03T07:57:38Z\",\"changeset\":24510179},{\"type\":\"way\",\"id\":295277829,\"user\":\"GeorgeKaplan\",\"timestamp\":\"2014-07-31T18:44:56Z\",\"changeset\":24468422},{\"type\":\"way\",\"id\":317795598,\"user\":\"JBacc1\",\"timestamp\":\"2014-12-18T13:32:18Z\",\"changeset\":27550551},{\"type\":\"way\",\"id\":1153718587,\"user\":\"Eric V\",\"timestamp\":\"2023-03-12T10:57:47Z\",\"changeset\":133581564},{\"type\":\"way\",\"id\":1153718588,\"user\":\"Eric V\",\"timestamp\":\"2023-03-12T10:57:47Z\",\"changeset\":133581564},{\"type\":\"way\",\"id\":1153718590,\"user\":\"Eric V\",\"timestamp\":\"2023-03-12T10:57:47Z\",\"changeset\":133581564},{\"type\":\"way\",\"id\":1153718592,\"user\":\"Eric V\",\"timestamp\":\"2023-03-12T10:57:47Z\",\"changeset\":133581564},{\"type\":\"way\",\"id\":1153718593,\"user\":\"Eric V\",\"timestamp\":\"2023-03-12T10:57:47Z\",\"changeset\":133581564},{\"type\":\"way\",\"id\":1153718594,\"user\":\"Eric V\",\"timestamp\":\"2023-03-12T10:57:47Z\",\"changeset\":133581564}]' WHERE id = 212145;

#	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)

0.44 ms
(2.62%)

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:

[
  9099
]

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

#	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.38 ms
(2.27%)

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:

[
  "02023"
]

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 = '02023' 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.18 ms
(1.07%)

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:

[
  9099
]

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

#	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.09 ms
(0.51%)

"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/02023/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