Symfony Profiler

Query Metrics

24 Database Queries

20 Different statements

1470.98 ms Query time

0 Invalid entities

5042 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1219.97 ms
(82.94%)

"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->followupThemeGraph (line 1978)
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)

154.31 ms
(10.49%)

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

Parameters:

[
  "12100"
]

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

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.zip_code = '12100';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\AdminController->followupThemeGraph (line 1904)
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)

17.63 ms
(1.20%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id = ? AND c0_.name IN (?, ?) ORDER BY c0_.date ASC, c0_.id ASC

Parameters:

[
  26516
  "travaux_count"
  "travaux_completion"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.measure AS measure_2,
  c0_.date AS date_3,
  c0_.stats_id AS stats_id_4
FROM
  city_follow_up c0_
  INNER JOIN stats s1_ ON c0_.stats_id = s1_.id
WHERE
  s1_.id = ?
  AND c0_.name IN (?, ?)
ORDER BY
  c0_.date ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id = 26516 AND c0_.name IN ('travaux_count', 'travaux_completion') ORDER BY c0_.date ASC, c0_.id ASC;

#	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->getResult (line 688)
6	App\Controller\AdminController->followupThemeGraph (line 1796)
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)

16.57 ms
(1.13%)

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:

[
  26516
]

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

#	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\Service\FollowUpService->getLatestFollowUpMetricsByTheme (line 2790)
8	App\Controller\AdminController->followupThemeGraph (line 2105)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.27 ms
(0.09%)

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:

[
  26516
]

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

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

0.58 ms
(0.04%)

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 = ? ORDER BY z0_.id ASC LIMIT 1

Parameters:

[
  26516
  "travaux"
]

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 = ?
ORDER BY
  z0_.id ASC
LIMIT
  1

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 = 26516 AND z0_.theme = 'travaux' ORDER BY z0_.id ASC LIMIT 1;

#	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 33)
7	App\Controller\AdminController->followupThemeGraph (line 2186)
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.40 ms
(0.03%)

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.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0 WHERE t0.zone = ? LIMIT 1

Parameters:

[
  "12100"
]

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.avec_email AS avec_email_19,
  t0.osm_data_date_min AS osm_data_date_min_20,
  t0.osm_data_date_avg AS osm_data_date_avg_21,
  t0.osm_data_date_max AS osm_data_date_max_22,
  t0.budget_annuel AS budget_annuel_23,
  t0.lat AS lat_24,
  t0.lon AS lon_25,
  t0.date_labourage_requested AS date_labourage_requested_26,
  t0.date_labourage_done AS date_labourage_done_27,
  t0.kind AS kind_28
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.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0 WHERE t0.zone = '12100' 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->followupThemeGraph (line 1753)
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.38 ms
(0.03%)

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

Parameters:

[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"travaux","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-07-15 08:22:43"
  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 ('[DEBUG][followupThemeGraph]', '{\"theme\":\"travaux\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-15 08:22:43', 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->followupThemeGraph (line 1978)
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.22 ms
(0.02%)

"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->followupThemeGraph (line 1978)
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)

osm connection

Time▼

Count

Info

38.54 ms
(2.62%)

SELECT osm_type, osm_id::text AS osm_id,
       ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
       tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,
       ST_AsGeoJSON(ST_Force2D(geom), 6, 0) AS geom_geojson,
       CASE WHEN GeometryType(geom) IN ('POLYGON', 'MULTIPOLYGON')
            THEN ST_Area(geom::geography)
            ELSE NULL END AS area_m2
FROM osm_object_meta m
WHERE geom IS NOT NULL
  AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))
  AND osm_type IN ('way', 'relation')
  AND (tags->'landuse') = 'construction'

Parameters:

[
  "MULTIPOLYGON(((2.291094 44.562036,2.291488 44.562409,2.292117 44.563039,2.292554 44.563495,2.292091 44.56369,2.291396 44.564077,2.290938 44.564238,2.290149 44.564774,2.289785 44.565,2.289484 44.56512,2.289043 44.565331,2.288798 44.565479,2.288497 44.565619,2.288311 44.565662,2.28787 44.565713,2.287252 44.565715,2.286976 44.565685,2.286696 44.565617,2.285909 44.565323,2.285475 44.565146,2.285384 44.565959,2.285509 44.566139,2.286263 44.567308,2.286578 44.567893,2.286996 44.568506,2.287273 44.568776,2.28739 44.568856,2.287645 44.569342,2.288337 44.570196,2.288902 44.57105,2.289028 44.571455,2.289278 44.57195,2.289279 44.57213,2.290183 44.573746,2.29028 44.57382,2.29033 44.574014,2.290064 44.57414,2.289071 44.574816,2.288685 44.575025,2.28851 44.575332,2.288291 44.57565,2.287797 44.576161,2.287573 44.576367,2.287646 44.576841,2.288331 44.577391,2.288519 44.577435,2.289022 44.577301,2.289274 44.577302,2.289273 44.578156,2.289335 44.578965,2.289901 44.5791,2.289857 44.579937,2.290405 44.580088,2.290815 44.58009,2.291027 44.580026,2.291246 44.579915,2.291838 44.579532,2.292292 44.579285,2.292779 44.579071,2.293942 44.578519,2.294345 44.578177,2.294542 44.57794,2.294765 44.577741,2.295153 44.577223,2.295339 44.577097,2.295591 44.576968,2.295884 44.576852,2.296174 44.576776,2.296531 44.576718,2.297481 44.576664,2.297901 44.576682,2.298024 44.57671,2.298246 44.576867,2.298453 44.576758,2.298924 44.576748,2.299818 44.57676,2.300101 44.576725,2.300567 44.576607,2.300832 44.576591,2.301029 44.576619,2.3012 44.57669,2.301721 44.577,2.301872 44.57702,2.302373 44.576763,2.302586 44.576754,2.302812 44.576791,2.303543 44.57697,2.304056 44.577008,2.304391 44.577111,2.304858 44.577333,2.305074 44.5774,2.305906 44.577549,2.306251 44.577649,2.306834 44.577997,2.307049 44.578027,2.307761 44.578037,2.308151 44.578069,2.308691 44.578149,2.308985 44.57813,2.309652 44.577846,2.309845 44.57782,2.310059 44.577834,2.310192 44.577881,2.310593 44.578163,2.310831 44.578275,2.311281 44.578396,2.311622 44.57843,2.312216 44.578453,2.312454 44.578489,2.312839 44.578707,2.313196 44.578759,2.313394 44.578935,2.313618 44.578956,2.314074 44.579148,2.314305 44.579164,2.314649 44.579091,2.314853 44.579118,2.315035 44.579061,2.315278 44.578981,2.315713 44.578954,2.31625 44.579082,2.316423 44.579067,2.316723 44.578884,2.31707 44.57891,2.317196 44.578894,2.317344 44.578781,2.317473 44.578779,2.317846 44.578689,2.318145 44.578516,2.318312 44.578463,2.318738 44.578125,2.319064 44.577989,2.31924 44.577868,2.319405 44.577673,2.31942 44.577565,2.319543 44.577336,2.319849 44.577116,2.320197 44.576961,2.320264 44.57683,2.320312 44.576559,2.320506 44.576216,2.320794 44.575841,2.321088 44.575705,2.321167 44.575577,2.321172 44.575364,2.321324 44.575045,2.321673 44.574931,2.322 44.57459,2.322224 44.574228,2.322536 44.574073,2.322735 44.573948,2.323113 44.573777,2.32329 44.573748,2.323778 44.573727,2.324249 44.573752,2.324686 44.573859,2.325032 44.573842,2.32541 44.573717,2.32564 44.573603,2.325935 44.573419,2.326354 44.573305,2.326582 44.573223,2.326844 44.57291,2.327134 44.572925,2.327423 44.572844,2.327589 44.572712,2.327873 44.572624,2.328361 44.572707,2.328737 44.572659,2.329046 44.572663,2.329298 44.572714,2.329717 44.572862,2.330268 44.572961,2.331167 44.572942,2.331593 44.572924,2.331987 44.572973,2.332321 44.572981,2.332639 44.573022,2.332998 44.573238,2.3332 44.573305,2.33378 44.57334,2.33432 44.573507,2.334632 44.573711,2.334888 44.574059,2.335485 44.574344,2.335939 44.5744,2.336409 44.574379,2.336725 44.574273,2.337096 44.574061,2.337359 44.573877,2.33765 44.573725,2.33794 44.573618,2.33828 44.573532,2.33865 44.573492,2.339041 44.573349,2.33939 44.573179,2.340328 44.572588,2.340568 44.572385,2.340713 44.572158,2.340892 44.571796,2.34125 44.570922,2.341371 44.570464,2.341747 44.569397,2.341842 44.569244,2.341816 44.568798,2.342032 44.568287,2.34219 44.568015,2.342725 44.567635,2.342951 44.567247,2.343473 44.567217,2.343873 44.567275,2.344293 44.567453,2.344629 44.567691,2.345115 44.568166,2.345414 44.568295,2.34626 44.568624,2.346637 44.568804,2.347464 44.568987,2.347487 44.569223,2.34767 44.569355,2.348232 44.569587,2.348727 44.569818,2.349361 44.569683,2.349547 44.569692,2.349993 44.569554,2.349423 44.568931,2.349254 44.568716,2.349139 44.568504,2.348948 44.567957,2.348904 44.567661,2.348926 44.56735,2.348997 44.567043,2.34909 44.566759,2.349161 44.566246,2.349241 44.565922,2.349362 44.56558,2.349422 44.565222,2.349524 44.565039,2.349809 44.564648,2.349853 44.564474,2.349876 44.564153,2.349937 44.56388,2.350002 44.563774,2.350266 44.563501,2.350371 44.563313,2.350388 44.563135,2.350321 44.562881,2.350219 44.562765,2.349925 44.56255,2.349806 44.562398,2.349908 44.562179,2.350108 44.561912,2.350136 44.561742,2.350071 44.561387,2.349988 44.561193,2.349744 44.560792,2.349703 44.560679,2.349704 44.560376,2.349867 44.56012,2.350456 44.559594,2.350581 44.559354,2.350573 44.559221,2.350461 44.55895,2.350161 44.558469,2.349962 44.558094,2.349539 44.557168,2.349351 44.556582,2.349794 44.556604,2.350385 44.556469,2.350613 44.556497,2.350879 44.556578,2.351316 44.556635,2.351487 44.556632,2.351718 44.556565,2.351948 44.556621,2.352191 44.556529,2.352392 44.556306,2.352562 44.556212,2.352852 44.556143,2.352955 44.556185,2.353479 44.556113,2.353693 44.556165,2.354348 44.556031,2.355063 44.555931,2.355539 44.55592,2.356183 44.555828,2.356657 44.555843,2.356956 44.555833,2.357516 44.555304,2.357829 44.554855,2.358476 44.554409,2.358803 44.554547,2.359959 44.554874,2.360561 44.555146,2.360923 44.555357,2.361693 44.555882,2.361902 44.556038,2.36281 44.556067,2.362874 44.556023,2.362873 44.555843,2.362936 44.555278,2.362781 44.555106,2.362504 44.554887,2.362364 44.554661,2.362162 44.554403,2.361972 44.554064,2.361779 44.553772,2.361691 44.553528,2.361394 44.553291,2.361272 44.553114,2.361336 44.552706,2.361325 44.552573,2.361218 44.552366,2.361039 44.55223,2.360661 44.552055,2.360544 44.551911,2.36053 44.55176,2.360565 44.551305,2.360531 44.55112,2.360227 44.550262,2.360195 44.549725,2.360154 44.549437,2.360039 44.548985,2.360023 44.548802,2.360057 44.548412,2.360182 44.548519,2.360457 44.548634,2.360709 44.548672,2.360979 44.548665,2.361327 44.548622,2.361814 44.548536,2.36194 44.548328,2.362161 44.548109,2.362633 44.547753,2.363073 44.547511,2.363798 44.5472,2.364216 44.546922,2.364688 44.54667,2.36507 44.546174,2.365258 44.545725,2.36551 44.545499,2.366264 44.54523,2.366641 44.545004,2.367772 44.544285,2.368279 44.543775,2.368009 44.54358,2.367702 44.543464,2.367316 44.543406,2.36703 44.543427,2.366054 44.543575,2.365852 44.543568,2.365734 44.543513,2.365433 44.543269,2.365083 44.543084,2.364173 44.542719,2.363855 44.542543,2.363338 44.542167,2.363046 44.541995,2.362554 44.541631,2.362124 44.541245,2.361898 44.541066,2.361589 44.540923,2.361239 44.540812,2.361187 44.540659,2.361363 44.540314,2.361351 44.540049,2.36128 44.539858,2.361174 44.539701,2.360964 44.539492,2.360853 44.539446,2.360779 44.539286,2.360715 44.537757,2.36059 44.537443,2.360466 44.537308,2.360436 44.537137,2.359996 44.536468,2.359549 44.535762,2.359321 44.53546,2.359164 44.535025,2.358931 44.534812,2.358695 44.534513,2.358477 44.534073,2.357959 44.533225,2.357784 44.533054,2.357489 44.532951,2.357303 44.532798,2.357228 44.532561,2.357074 44.532351,2.357373 44.531873,2.357218 44.531568,2.356932 44.531082,2.356842 44.53074,2.356712 44.530392,2.356707 44.530205,2.356558 44.529814,2.357192 44.528891,2.357551 44.528383,2.357542 44.528165,2.357598 44.527993,2.357807 44.527722,2.357731 44.527611,2.357294 44.527363,2.357152 44.527234,2.357111 44.527109,2.357107 44.526724,2.35713 44.526392,2.357194 44.526246,2.357177 44.526014,2.357442 44.525519,2.357504 44.525338,2.356248 44.525474,2.355368 44.525385,2.353325 44.525064,2.352907 44.524762,2.352592 44.524412,2.352302 44.524244,2.351496 44.523858,2.35138 44.52371,2.351153 44.52298,2.350772 44.522128,2.350406 44.521586,2.349924 44.521113,2.349641 44.520858,2.349208 44.520652,2.348711 44.52044,2.348079 44.521069,2.347452 44.520952,2.347072 44.520931,2.347018 44.52065,2.346819 44.520125,2.346305 44.519132,2.346109 44.519167,2.34577 44.519294,2.344761 44.519622,2.344439 44.51975,2.343956 44.519826,2.343586 44.519946,2.34336 44.520068,2.343081 44.520178,2.342768 44.520354,2.342584 44.520393,2.34218 44.520571,2.341624 44.520617,2.341499 44.52065,2.341261 44.520782,2.341203 44.520849,2.341279 44.521183,2.341475 44.521377,2.341345 44.521549,2.340996 44.521449,2.340259 44.52165,2.339916 44.521706,2.339498 44.521745,2.339343 44.521832,2.339389 44.522013,2.34027 44.523407,2.340458 44.524621,2.339201 44.524711,2.337169 44.524832,2.336988 44.524702,2.33593 44.52497,2.335686 44.524775,2.335267 44.524858,2.334632 44.525033,2.334473 44.52515,2.334148 44.525272,2.333932 44.525288,2.333557 44.525249,2.333172 44.525269,2.332709 44.525353,2.332735 44.525266,2.333015 44.525132,2.333238 44.524996,2.333425 44.524981,2.3337 44.524646,2.333833 44.524635,2.334096 44.52447,2.334221 44.524361,2.334565 44.524222,2.334829 44.52403,2.334964 44.523838,2.335077 44.523817,2.335423 44.52349,2.335578 44.523446,2.336063 44.523434,2.335667 44.523128,2.335312 44.523159,2.335178 44.523134,2.334777 44.522939,2.334462 44.522708,2.334152 44.522614,2.333794 44.522565,2.333527 44.522455,2.333364 44.522305,2.332953 44.521843,2.332665 44.521024,2.332538 44.520844,2.331661 44.52105,2.331302 44.5207,2.331274 44.520588,2.331013 44.52033,2.330945 44.52014,2.331037 44.519587,2.330846 44.519456,2.330294 44.519205,2.330093 44.519045,2.329947 44.518737,2.329872 44.518479,2.329865 44.518289,2.329972 44.517972,2.330928 44.517838,2.330921 44.517473,2.330865 44.517186,2.330905 44.516927,2.331054 44.516669,2.331345 44.516394,2.33199 44.515859,2.331071 44.515298,2.330915 44.515404,2.330475 44.515604,2.3302 44.5157,2.329765 44.515959,2.329217 44.516175,2.32914 44.516269,2.329123 44.516414,2.328199 44.516495,2.327681 44.516517,2.327485 44.516507,2.326737 44.516247,2.325881 44.516083,2.325401 44.515946,2.324948 44.515715,2.324507 44.515369,2.324174 44.514969,2.32385 44.514323,2.32338 44.513862,2.322019 44.513057,2.321882 44.512841,2.322409 44.512425,2.323163 44.512066,2.323163 44.511886,2.322661 44.510627,2.322535 44.510222,2.32241 44.510042,2.322159 44.510087,2.32153 44.510312,2.320776 44.510761,2.319795 44.511547,2.319712 44.511756,2.319515 44.511919,2.3193 44.512006,2.318606 44.512237,2.318253 44.512391,2.317304 44.513019,2.316862 44.513172,2.316564 44.513224,2.315962 44.513284,2.315701 44.513341,2.315451 44.513444,2.315195 44.513599,2.314939 44.513906,2.314827 44.514073,2.314744 44.514099,2.314562 44.514294,2.314322 44.514449,2.313539 44.514744,2.313369 44.514845,2.312966 44.515269,2.312618 44.515529,2.311714 44.516008,2.311479 44.516116,2.310756 44.516369,2.31049 44.516444,2.310096 44.516428,2.309217 44.516496,2.30884 44.516551,2.309174 44.516826,2.309536 44.517062,2.30972 44.517215,2.309966 44.517506,2.31015 44.517761,2.310346 44.518134,2.310394 44.518291,2.310404 44.518505,2.310327 44.518974,2.310248 44.519562,2.310262 44.519816,2.310202 44.520233,2.310196 44.520464,2.310289 44.520679,2.310421 44.520856,2.310567 44.520988,2.310582 44.521115,2.310513 44.521223,2.310515 44.52138,2.310327 44.52183,2.310264 44.522235,2.310227 44.522273,2.308963 44.522767,2.308541 44.522886,2.308118 44.522928,2.307746 44.522941,2.307077 44.523141,2.306516 44.523348,2.306068 44.523441,2.305941 44.523438,2.305738 44.523351,2.305171 44.523162,2.304613 44.523036,2.30432 44.523051,2.304065 44.523116,2.30341 44.523102,2.30297 44.523077,2.302418 44.523066,2.30225 44.523082,2.301847 44.523361,2.300869 44.523768,2.300501 44.523803,2.300256 44.523783,2.299896 44.523796,2.299352 44.523942,2.29869 44.524167,2.298306 44.524261,2.297568 44.524508,2.297409 44.524603,2.297131 44.52487,2.296959 44.524903,2.296874 44.525648,2.296817 44.526424,2.296861 44.526707,2.29701 44.527048,2.297375 44.527132,2.298632 44.527627,2.299575 44.527942,2.29985 44.528093,2.299483 44.528244,2.29889 44.528416,2.298681 44.5285,2.29874 44.528554,2.299347 44.528805,2.299771 44.528912,2.300957 44.529471,2.301207 44.530595,2.301809 44.530999,2.301808 44.531313,2.30176 44.531467,2.301553 44.531888,2.301203 44.532362,2.300961 44.533146,2.300832 44.534215,2.300797 44.53461,2.300722 44.534808,2.300484 44.53507,2.30038 44.535135,2.299917 44.535335,2.299679 44.535478,2.299449 44.535674,2.299033 44.536118,2.298492 44.536546,2.298083 44.536959,2.297632 44.537257,2.297182 44.537618,2.296469 44.538258,2.295922 44.538849,2.295584 44.539069,2.294681 44.539443,2.294061 44.539658,2.293244 44.539901,2.292688 44.540051,2.291899 44.540284,2.291756 44.540287,2.290907 44.540393,2.290277 44.540531,2.289518 44.540725,2.290253 44.541896,2.290875 44.542696,2.292196 44.543281,2.292509 44.543281,2.294095 44.542607,2.29466 44.542608,2.29573 44.542743,2.296484 44.543373,2.296483 44.543507,2.296168 44.543921,2.297178 44.544496,2.297411 44.544504,2.297613 44.54457,2.298013 44.544755,2.298213 44.544806,2.299059 44.545676,2.299096 44.546215,2.299319 44.546368,2.299411 44.546495,2.300191 44.54725,2.300442 44.547655,2.300757 44.548104,2.302263 44.550579,2.303206 44.552107,2.303708 44.552872,2.303771 44.553052,2.303834 44.553097,2.30396 44.553457,2.304274 44.554221,2.305168 44.555398,2.305151 44.555695,2.304989 44.555912,2.304946 44.556122,2.305083 44.556349,2.304586 44.556478,2.304398 44.556748,2.303391 44.557558,2.30339 44.558412,2.303516 44.558861,2.303641 44.559895,2.303572 44.560256,2.303374 44.560272,2.303237 44.560238,2.302559 44.560263,2.302284 44.560219,2.302078 44.560231,2.301854 44.560286,2.301456 44.560337,2.301116 44.560272,2.301013 44.560227,2.299026 44.559869,2.298747 44.559878,2.298251 44.559779,2.297763 44.559772,2.296941 44.559897,2.296595 44.5601,2.296234 44.560378,2.296002 44.560522,2.295797 44.560576,2.294978 44.560545,2.29417 44.560655,2.29312 44.560943,2.292552 44.561237,2.291983 44.561465,2.291721 44.5616,2.291094 44.562036)))"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  osm_type,
  osm_id :: text AS osm_id,
  ST_Y(
    ST_Centroid(geom)
  ) AS lat,
  ST_X(
    ST_Centroid(geom)
  ) AS lon,
  tags :: jsonb AS tags_json,
  version,
  osm_timestamp,
  changeset,
  osm_user,
  uid :: bigint AS uid,
  ST_AsGeoJSON(
    ST_Force2D(geom),
    6,
    0
  ) AS geom_geojson,
  CASE WHEN GeometryType(geom) IN ('POLYGON', 'MULTIPOLYGON') THEN
    ST_Area(geom :: geography)
  ELSE
    NULL
  END AS area_m2
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND osm_type IN ('way', 'relation')
  AND (tags -> 'landuse') = 'construction'

SELECT osm_type, osm_id::text AS osm_id,
       ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
       tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,
       ST_AsGeoJSON(ST_Force2D(geom), 6, 0) AS geom_geojson,
       CASE WHEN GeometryType(geom) IN ('POLYGON', 'MULTIPOLYGON')
            THEN ST_Area(geom::geography)
            ELSE NULL END AS area_m2
FROM osm_object_meta m
WHERE geom IS NOT NULL
  AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((2.291094 44.562036,2.291488 44.562409,2.292117 44.563039,2.292554 44.563495,2.292091 44.56369,2.291396 44.564077,2.290938 44.564238,2.290149 44.564774,2.289785 44.565,2.289484 44.56512,2.289043 44.565331,2.288798 44.565479,2.288497 44.565619,2.288311 44.565662,2.28787 44.565713,2.287252 44.565715,2.286976 44.565685,2.286696 44.565617,2.285909 44.565323,2.285475 44.565146,2.285384 44.565959,2.285509 44.566139,2.286263 44.567308,2.286578 44.567893,2.286996 44.568506,2.287273 44.568776,2.28739 44.568856,2.287645 44.569342,2.288337 44.570196,2.288902 44.57105,2.289028 44.571455,2.289278 44.57195,2.289279 44.57213,2.290183 44.573746,2.29028 44.57382,2.29033 44.574014,2.290064 44.57414,2.289071 44.574816,2.288685 44.575025,2.28851 44.575332,2.288291 44.57565,2.287797 44.576161,2.287573 44.576367,2.287646 44.576841,2.288331 44.577391,2.288519 44.577435,2.289022 44.577301,2.289274 44.577302,2.289273 44.578156,2.289335 44.578965,2.289901 44.5791,2.289857 44.579937,2.290405 44.580088,2.290815 44.58009,2.291027 44.580026,2.291246 44.579915,2.291838 44.579532,2.292292 44.579285,2.292779 44.579071,2.293942 44.578519,2.294345 44.578177,2.294542 44.57794,2.294765 44.577741,2.295153 44.577223,2.295339 44.577097,2.295591 44.576968,2.295884 44.576852,2.296174 44.576776,2.296531 44.576718,2.297481 44.576664,2.297901 44.576682,2.298024 44.57671,2.298246 44.576867,2.298453 44.576758,2.298924 44.576748,2.299818 44.57676,2.300101 44.576725,2.300567 44.576607,2.300832 44.576591,2.301029 44.576619,2.3012 44.57669,2.301721 44.577,2.301872 44.57702,2.302373 44.576763,2.302586 44.576754,2.302812 44.576791,2.303543 44.57697,2.304056 44.577008,2.304391 44.577111,2.304858 44.577333,2.305074 44.5774,2.305906 44.577549,2.306251 44.577649,2.306834 44.577997,2.307049 44.578027,2.307761 44.578037,2.308151 44.578069,2.308691 44.578149,2.308985 44.57813,2.309652 44.577846,2.309845 44.57782,2.310059 44.577834,2.310192 44.577881,2.310593 44.578163,2.310831 44.578275,2.311281 44.578396,2.311622 44.57843,2.312216 44.578453,2.312454 44.578489,2.312839 44.578707,2.313196 44.578759,2.313394 44.578935,2.313618 44.578956,2.314074 44.579148,2.314305 44.579164,2.314649 44.579091,2.314853 44.579118,2.315035 44.579061,2.315278 44.578981,2.315713 44.578954,2.31625 44.579082,2.316423 44.579067,2.316723 44.578884,2.31707 44.57891,2.317196 44.578894,2.317344 44.578781,2.317473 44.578779,2.317846 44.578689,2.318145 44.578516,2.318312 44.578463,2.318738 44.578125,2.319064 44.577989,2.31924 44.577868,2.319405 44.577673,2.31942 44.577565,2.319543 44.577336,2.319849 44.577116,2.320197 44.576961,2.320264 44.57683,2.320312 44.576559,2.320506 44.576216,2.320794 44.575841,2.321088 44.575705,2.321167 44.575577,2.321172 44.575364,2.321324 44.575045,2.321673 44.574931,2.322 44.57459,2.322224 44.574228,2.322536 44.574073,2.322735 44.573948,2.323113 44.573777,2.32329 44.573748,2.323778 44.573727,2.324249 44.573752,2.324686 44.573859,2.325032 44.573842,2.32541 44.573717,2.32564 44.573603,2.325935 44.573419,2.326354 44.573305,2.326582 44.573223,2.326844 44.57291,2.327134 44.572925,2.327423 44.572844,2.327589 44.572712,2.327873 44.572624,2.328361 44.572707,2.328737 44.572659,2.329046 44.572663,2.329298 44.572714,2.329717 44.572862,2.330268 44.572961,2.331167 44.572942,2.331593 44.572924,2.331987 44.572973,2.332321 44.572981,2.332639 44.573022,2.332998 44.573238,2.3332 44.573305,2.33378 44.57334,2.33432 44.573507,2.334632 44.573711,2.334888 44.574059,2.335485 44.574344,2.335939 44.5744,2.336409 44.574379,2.336725 44.574273,2.337096 44.574061,2.337359 44.573877,2.33765 44.573725,2.33794 44.573618,2.33828 44.573532,2.33865 44.573492,2.339041 44.573349,2.33939 44.573179,2.340328 44.572588,2.340568 44.572385,2.340713 44.572158,2.340892 44.571796,2.34125 44.570922,2.341371 44.570464,2.341747 44.569397,2.341842 44.569244,2.341816 44.568798,2.342032 44.568287,2.34219 44.568015,2.342725 44.567635,2.342951 44.567247,2.343473 44.567217,2.343873 44.567275,2.344293 44.567453,2.344629 44.567691,2.345115 44.568166,2.345414 44.568295,2.34626 44.568624,2.346637 44.568804,2.347464 44.568987,2.347487 44.569223,2.34767 44.569355,2.348232 44.569587,2.348727 44.569818,2.349361 44.569683,2.349547 44.569692,2.349993 44.569554,2.349423 44.568931,2.349254 44.568716,2.349139 44.568504,2.348948 44.567957,2.348904 44.567661,2.348926 44.56735,2.348997 44.567043,2.34909 44.566759,2.349161 44.566246,2.349241 44.565922,2.349362 44.56558,2.349422 44.565222,2.349524 44.565039,2.349809 44.564648,2.349853 44.564474,2.349876 44.564153,2.349937 44.56388,2.350002 44.563774,2.350266 44.563501,2.350371 44.563313,2.350388 44.563135,2.350321 44.562881,2.350219 44.562765,2.349925 44.56255,2.349806 44.562398,2.349908 44.562179,2.350108 44.561912,2.350136 44.561742,2.350071 44.561387,2.349988 44.561193,2.349744 44.560792,2.349703 44.560679,2.349704 44.560376,2.349867 44.56012,2.350456 44.559594,2.350581 44.559354,2.350573 44.559221,2.350461 44.55895,2.350161 44.558469,2.349962 44.558094,2.349539 44.557168,2.349351 44.556582,2.349794 44.556604,2.350385 44.556469,2.350613 44.556497,2.350879 44.556578,2.351316 44.556635,2.351487 44.556632,2.351718 44.556565,2.351948 44.556621,2.352191 44.556529,2.352392 44.556306,2.352562 44.556212,2.352852 44.556143,2.352955 44.556185,2.353479 44.556113,2.353693 44.556165,2.354348 44.556031,2.355063 44.555931,2.355539 44.55592,2.356183 44.555828,2.356657 44.555843,2.356956 44.555833,2.357516 44.555304,2.357829 44.554855,2.358476 44.554409,2.358803 44.554547,2.359959 44.554874,2.360561 44.555146,2.360923 44.555357,2.361693 44.555882,2.361902 44.556038,2.36281 44.556067,2.362874 44.556023,2.362873 44.555843,2.362936 44.555278,2.362781 44.555106,2.362504 44.554887,2.362364 44.554661,2.362162 44.554403,2.361972 44.554064,2.361779 44.553772,2.361691 44.553528,2.361394 44.553291,2.361272 44.553114,2.361336 44.552706,2.361325 44.552573,2.361218 44.552366,2.361039 44.55223,2.360661 44.552055,2.360544 44.551911,2.36053 44.55176,2.360565 44.551305,2.360531 44.55112,2.360227 44.550262,2.360195 44.549725,2.360154 44.549437,2.360039 44.548985,2.360023 44.548802,2.360057 44.548412,2.360182 44.548519,2.360457 44.548634,2.360709 44.548672,2.360979 44.548665,2.361327 44.548622,2.361814 44.548536,2.36194 44.548328,2.362161 44.548109,2.362633 44.547753,2.363073 44.547511,2.363798 44.5472,2.364216 44.546922,2.364688 44.54667,2.36507 44.546174,2.365258 44.545725,2.36551 44.545499,2.366264 44.54523,2.366641 44.545004,2.367772 44.544285,2.368279 44.543775,2.368009 44.54358,2.367702 44.543464,2.367316 44.543406,2.36703 44.543427,2.366054 44.543575,2.365852 44.543568,2.365734 44.543513,2.365433 44.543269,2.365083 44.543084,2.364173 44.542719,2.363855 44.542543,2.363338 44.542167,2.363046 44.541995,2.362554 44.541631,2.362124 44.541245,2.361898 44.541066,2.361589 44.540923,2.361239 44.540812,2.361187 44.540659,2.361363 44.540314,2.361351 44.540049,2.36128 44.539858,2.361174 44.539701,2.360964 44.539492,2.360853 44.539446,2.360779 44.539286,2.360715 44.537757,2.36059 44.537443,2.360466 44.537308,2.360436 44.537137,2.359996 44.536468,2.359549 44.535762,2.359321 44.53546,2.359164 44.535025,2.358931 44.534812,2.358695 44.534513,2.358477 44.534073,2.357959 44.533225,2.357784 44.533054,2.357489 44.532951,2.357303 44.532798,2.357228 44.532561,2.357074 44.532351,2.357373 44.531873,2.357218 44.531568,2.356932 44.531082,2.356842 44.53074,2.356712 44.530392,2.356707 44.530205,2.356558 44.529814,2.357192 44.528891,2.357551 44.528383,2.357542 44.528165,2.357598 44.527993,2.357807 44.527722,2.357731 44.527611,2.357294 44.527363,2.357152 44.527234,2.357111 44.527109,2.357107 44.526724,2.35713 44.526392,2.357194 44.526246,2.357177 44.526014,2.357442 44.525519,2.357504 44.525338,2.356248 44.525474,2.355368 44.525385,2.353325 44.525064,2.352907 44.524762,2.352592 44.524412,2.352302 44.524244,2.351496 44.523858,2.35138 44.52371,2.351153 44.52298,2.350772 44.522128,2.350406 44.521586,2.349924 44.521113,2.349641 44.520858,2.349208 44.520652,2.348711 44.52044,2.348079 44.521069,2.347452 44.520952,2.347072 44.520931,2.347018 44.52065,2.346819 44.520125,2.346305 44.519132,2.346109 44.519167,2.34577 44.519294,2.344761 44.519622,2.344439 44.51975,2.343956 44.519826,2.343586 44.519946,2.34336 44.520068,2.343081 44.520178,2.342768 44.520354,2.342584 44.520393,2.34218 44.520571,2.341624 44.520617,2.341499 44.52065,2.341261 44.520782,2.341203 44.520849,2.341279 44.521183,2.341475 44.521377,2.341345 44.521549,2.340996 44.521449,2.340259 44.52165,2.339916 44.521706,2.339498 44.521745,2.339343 44.521832,2.339389 44.522013,2.34027 44.523407,2.340458 44.524621,2.339201 44.524711,2.337169 44.524832,2.336988 44.524702,2.33593 44.52497,2.335686 44.524775,2.335267 44.524858,2.334632 44.525033,2.334473 44.52515,2.334148 44.525272,2.333932 44.525288,2.333557 44.525249,2.333172 44.525269,2.332709 44.525353,2.332735 44.525266,2.333015 44.525132,2.333238 44.524996,2.333425 44.524981,2.3337 44.524646,2.333833 44.524635,2.334096 44.52447,2.334221 44.524361,2.334565 44.524222,2.334829 44.52403,2.334964 44.523838,2.335077 44.523817,2.335423 44.52349,2.335578 44.523446,2.336063 44.523434,2.335667 44.523128,2.335312 44.523159,2.335178 44.523134,2.334777 44.522939,2.334462 44.522708,2.334152 44.522614,2.333794 44.522565,2.333527 44.522455,2.333364 44.522305,2.332953 44.521843,2.332665 44.521024,2.332538 44.520844,2.331661 44.52105,2.331302 44.5207,2.331274 44.520588,2.331013 44.52033,2.330945 44.52014,2.331037 44.519587,2.330846 44.519456,2.330294 44.519205,2.330093 44.519045,2.329947 44.518737,2.329872 44.518479,2.329865 44.518289,2.329972 44.517972,2.330928 44.517838,2.330921 44.517473,2.330865 44.517186,2.330905 44.516927,2.331054 44.516669,2.331345 44.516394,2.33199 44.515859,2.331071 44.515298,2.330915 44.515404,2.330475 44.515604,2.3302 44.5157,2.329765 44.515959,2.329217 44.516175,2.32914 44.516269,2.329123 44.516414,2.328199 44.516495,2.327681 44.516517,2.327485 44.516507,2.326737 44.516247,2.325881 44.516083,2.325401 44.515946,2.324948 44.515715,2.324507 44.515369,2.324174 44.514969,2.32385 44.514323,2.32338 44.513862,2.322019 44.513057,2.321882 44.512841,2.322409 44.512425,2.323163 44.512066,2.323163 44.511886,2.322661 44.510627,2.322535 44.510222,2.32241 44.510042,2.322159 44.510087,2.32153 44.510312,2.320776 44.510761,2.319795 44.511547,2.319712 44.511756,2.319515 44.511919,2.3193 44.512006,2.318606 44.512237,2.318253 44.512391,2.317304 44.513019,2.316862 44.513172,2.316564 44.513224,2.315962 44.513284,2.315701 44.513341,2.315451 44.513444,2.315195 44.513599,2.314939 44.513906,2.314827 44.514073,2.314744 44.514099,2.314562 44.514294,2.314322 44.514449,2.313539 44.514744,2.313369 44.514845,2.312966 44.515269,2.312618 44.515529,2.311714 44.516008,2.311479 44.516116,2.310756 44.516369,2.31049 44.516444,2.310096 44.516428,2.309217 44.516496,2.30884 44.516551,2.309174 44.516826,2.309536 44.517062,2.30972 44.517215,2.309966 44.517506,2.31015 44.517761,2.310346 44.518134,2.310394 44.518291,2.310404 44.518505,2.310327 44.518974,2.310248 44.519562,2.310262 44.519816,2.310202 44.520233,2.310196 44.520464,2.310289 44.520679,2.310421 44.520856,2.310567 44.520988,2.310582 44.521115,2.310513 44.521223,2.310515 44.52138,2.310327 44.52183,2.310264 44.522235,2.310227 44.522273,2.308963 44.522767,2.308541 44.522886,2.308118 44.522928,2.307746 44.522941,2.307077 44.523141,2.306516 44.523348,2.306068 44.523441,2.305941 44.523438,2.305738 44.523351,2.305171 44.523162,2.304613 44.523036,2.30432 44.523051,2.304065 44.523116,2.30341 44.523102,2.30297 44.523077,2.302418 44.523066,2.30225 44.523082,2.301847 44.523361,2.300869 44.523768,2.300501 44.523803,2.300256 44.523783,2.299896 44.523796,2.299352 44.523942,2.29869 44.524167,2.298306 44.524261,2.297568 44.524508,2.297409 44.524603,2.297131 44.52487,2.296959 44.524903,2.296874 44.525648,2.296817 44.526424,2.296861 44.526707,2.29701 44.527048,2.297375 44.527132,2.298632 44.527627,2.299575 44.527942,2.29985 44.528093,2.299483 44.528244,2.29889 44.528416,2.298681 44.5285,2.29874 44.528554,2.299347 44.528805,2.299771 44.528912,2.300957 44.529471,2.301207 44.530595,2.301809 44.530999,2.301808 44.531313,2.30176 44.531467,2.301553 44.531888,2.301203 44.532362,2.300961 44.533146,2.300832 44.534215,2.300797 44.53461,2.300722 44.534808,2.300484 44.53507,2.30038 44.535135,2.299917 44.535335,2.299679 44.535478,2.299449 44.535674,2.299033 44.536118,2.298492 44.536546,2.298083 44.536959,2.297632 44.537257,2.297182 44.537618,2.296469 44.538258,2.295922 44.538849,2.295584 44.539069,2.294681 44.539443,2.294061 44.539658,2.293244 44.539901,2.292688 44.540051,2.291899 44.540284,2.291756 44.540287,2.290907 44.540393,2.290277 44.540531,2.289518 44.540725,2.290253 44.541896,2.290875 44.542696,2.292196 44.543281,2.292509 44.543281,2.294095 44.542607,2.29466 44.542608,2.29573 44.542743,2.296484 44.543373,2.296483 44.543507,2.296168 44.543921,2.297178 44.544496,2.297411 44.544504,2.297613 44.54457,2.298013 44.544755,2.298213 44.544806,2.299059 44.545676,2.299096 44.546215,2.299319 44.546368,2.299411 44.546495,2.300191 44.54725,2.300442 44.547655,2.300757 44.548104,2.302263 44.550579,2.303206 44.552107,2.303708 44.552872,2.303771 44.553052,2.303834 44.553097,2.30396 44.553457,2.304274 44.554221,2.305168 44.555398,2.305151 44.555695,2.304989 44.555912,2.304946 44.556122,2.305083 44.556349,2.304586 44.556478,2.304398 44.556748,2.303391 44.557558,2.30339 44.558412,2.303516 44.558861,2.303641 44.559895,2.303572 44.560256,2.303374 44.560272,2.303237 44.560238,2.302559 44.560263,2.302284 44.560219,2.302078 44.560231,2.301854 44.560286,2.301456 44.560337,2.301116 44.560272,2.301013 44.560227,2.299026 44.559869,2.298747 44.559878,2.298251 44.559779,2.297763 44.559772,2.296941 44.559897,2.296595 44.5601,2.296234 44.560378,2.296002 44.560522,2.295797 44.560576,2.294978 44.560545,2.29417 44.560655,2.29312 44.560943,2.292552 44.561237,2.291983 44.561465,2.291721 44.5616,2.291094 44.562036)))', 4326))
  AND osm_type IN ('way', 'relation')
  AND (tags->'landuse') = 'construction';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2196)
3	App\Service\Motocultrice->getConstructionObjects (line 1695)
4	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
5	App\Controller\AdminController->followupThemeGraph (line 2010)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

8.43 ms
(0.57%)

SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM osm_object_meta m
WHERE osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags->'ref:INSEE') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1

Parameters:

[
  "12100"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  ST_AsText(
    ST_Multi(geom)
  ) AS wkt
FROM
  osm_object_meta m
WHERE
  osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags -> 'ref:INSEE') = ?
  AND (tags -> 'admin_level') = '8'
  AND (tags -> 'boundary') = 'administrative'
ORDER BY
  ST_Area(geom :: geography) DESC NULLS LAST
LIMIT
  1

SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM osm_object_meta m
WHERE osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags->'ref'12100'') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchBoundaryWkt (line 292)
3	App\Service\ZonePolygonResolver->fetchBoundaryWktFromMeta (line 236)
4	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():100} (line 100)
5	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
6	App\Service\ZonePolygonResolver->polygonWkt (line 62)
7	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
8	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2175)
9	App\Service\Motocultrice->getConstructionObjects (line 1695)
10	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
11	App\Controller\AdminController->followupThemeGraph (line 2010)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

3.87 ms
(0.26%)

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = 'public'
  AND table_name = 'osm_object_meta'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\OsmDatabaseService->hasOsmObjectMetaTable (line 2375)
3	App\Service\Motocultrice->canQueryPostgisZone (line 255)
4	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1874)
5	App\Controller\AdminController->followupThemeGraph (line 2010)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

2.49 ms
(0.17%)

SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'
                  AND geom IS NOT NULL
                  AND (tags->'admin_level') = '8'
                  AND (tags->'boundary') = 'administrative'
                  AND (tags->'ref:INSEE') IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  osm_object_meta
WHERE
  osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags -> 'admin_level') = '8'
  AND (tags -> 'boundary') = 'administrative'
  AND (tags -> 'ref:INSEE') IS NOT NULL

SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'
                  AND geom IS NOT NULL
                  AND (tags->'admin_level') = '8'
                  AND (tags->'boundary') = 'administrative'
                  AND (tags->'ref:INSEE') IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 500)
3	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
4	App\Service\ZonePolygonResolver->polygonWkt (line 62)
5	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
6	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2175)
7	App\Service\Motocultrice->getConstructionObjects (line 1695)
8	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
9	App\Controller\AdminController->followupThemeGraph (line 2010)
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)

2.36 ms
(0.16%)

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?

Parameters:

[
  "public"
  "osm_object_meta"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->postgresTableExists (line 563)
3	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 495)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2175)
8	App\Service\Motocultrice->getConstructionObjects (line 1695)
9	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
10	App\Controller\AdminController->followupThemeGraph (line 2010)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.23 ms
(0.08%)

INSERT INTO osm_object_meta (
    osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid
)
SELECT
    'relation',
    latest.osm_id,
    latest.geom,
    latest.tags,
    latest.version,
    to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),
    latest.changeset,
    latest.osm_user,
    latest.uid
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.osm_id,
        h.geom,
        h.tags,
        h.version,
        h.valid_from,
        h.changeset,
        h.osm_user,
        h.uid
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'boundary') = 'administrative'
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'ref:INSEE') IS NOT NULL
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) AS latest
WHERE NOT EXISTS (
    SELECT 1 FROM osm_object_meta m
    WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id
)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO osm_object_meta (
  osm_type, osm_id, geom, tags, version,
  osm_timestamp, changeset, osm_user,
  uid
)
SELECT
  'relation',
  latest.osm_id,
  latest.geom,
  latest.tags,
  latest.version,
  to_char(
    latest.valid_from AT TIME ZONE 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ),
  latest.changeset,
  latest.osm_user,
  latest.uid
FROM
  (
    SELECT
      DISTINCT ON (h.osm_id) h.osm_id,
      h.geom,
      h.tags,
      h.version,
      h.valid_from,
      h.changeset,
      h.osm_user,
      h.uid
    FROM
      osm_object_history h
    WHERE
      h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags -> 'boundary') = 'administrative'
      AND (h.tags -> 'admin_level') = '8'
      AND (h.tags -> 'ref:INSEE') IS NOT NULL
    ORDER BY
      h.osm_id,
      h.version DESC,
      h.valid_from DESC
  ) AS latest
WHERE
  NOT EXISTS (
    SELECT
      1
    FROM
      osm_object_meta m
    WHERE
      m.osm_type = 'relation'
      AND m.osm_id = latest.osm_id
  )

INSERT INTO osm_object_meta (
    osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid
)
SELECT
    'relation',
    latest.osm_id,
    latest.geom,
    latest.tags,
    latest.version,
    to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),
    latest.changeset,
    latest.osm_user,
    latest.uid
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.osm_id,
        h.geom,
        h.tags,
        h.version,
        h.valid_from,
        h.changeset,
        h.osm_user,
        h.uid
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'boundary') = 'administrative'
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'ref:INSEE') IS NOT NULL
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) AS latest
WHERE NOT EXISTS (
    SELECT 1 FROM osm_object_meta m
    WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id
);

#	File/Call
1	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 554)
2	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
3	App\Service\ZonePolygonResolver->polygonWkt (line 62)
4	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
5	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2175)
6	App\Service\Motocultrice->getConstructionObjects (line 1695)
7	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
8	App\Controller\AdminController->followupThemeGraph (line 2010)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.08 ms
(0.07%)

SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?

Parameters:

[
  "12100"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  ST_AsText(
    ST_Multi(geom)
  )
FROM
  zone_polygon
WHERE
  insee_code = ?

SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = '12100';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 422)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2175)
8	App\Service\Motocultrice->getConstructionObjects (line 1695)
9	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
10	App\Controller\AdminController->followupThemeGraph (line 2010)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.65 ms
(0.04%)

SELECT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1

SELECT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\OsmDatabaseService->isAvailable (line 2364)
3	App\Service\Motocultrice->canQueryPostgisZone (line 254)
4	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1874)
5	App\Controller\AdminController->followupThemeGraph (line 2010)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.38 ms
(0.03%)

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom);

#	File/Call
1	App\Service\ZonePolygonResolver->ensureZonePolygonTable (line 477)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 417)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2175)
8	App\Service\Motocultrice->getConstructionObjects (line 1695)
9	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
10	App\Controller\AdminController->followupThemeGraph (line 2010)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.38 ms
(0.03%)

SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.geom
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'ref:INSEE') = ?
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'boundary') = 'administrative'
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) latest
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1

Parameters:

[
  "12100"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  ST_AsText(
    ST_Multi(geom)
  ) AS wkt
FROM
  (
    SELECT
      DISTINCT ON (h.osm_id) h.geom
    FROM
      osm_object_history h
    WHERE
      h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags -> 'ref:INSEE') = ?
      AND (h.tags -> 'admin_level') = '8'
      AND (h.tags -> 'boundary') = 'administrative'
    ORDER BY
      h.osm_id,
      h.version DESC,
      h.valid_from DESC
  ) latest
ORDER BY
  ST_Area(geom :: geography) DESC NULLS LAST
LIMIT
  1

SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.geom
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'ref'12100'') = ?
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'boundary') = 'administrative'
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) latest
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchBoundaryWkt (line 292)
3	App\Service\ZonePolygonResolver->fetchBoundaryWktFromHistory (line 259)
4	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():101} (line 101)
5	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
6	App\Service\ZonePolygonResolver->polygonWkt (line 62)
7	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
8	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2175)
9	App\Service\Motocultrice->getConstructionObjects (line 1695)
10	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
11	App\Controller\AdminController->followupThemeGraph (line 2010)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.25 ms
(0.02%)

CREATE TABLE IF NOT EXISTS zone_polygon (
                    insee_code TEXT PRIMARY KEY,
                    geom geometry(MultiPolygon, 4326) NOT NULL,
                    source TEXT NOT NULL,
                    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
                )

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

CREATE TABLE IF NOT EXISTS zone_polygon (
  insee_code TEXT PRIMARY KEY,
  geom geometry(MultiPolygon, 4326) NOT NULL,
  source TEXT NOT NULL,
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
)

CREATE TABLE IF NOT EXISTS zone_polygon (
                    insee_code TEXT PRIMARY KEY,
                    geom geometry(MultiPolygon, 4326) NOT NULL,
                    source TEXT NOT NULL,
                    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
                );

#	File/Call
1	App\Service\ZonePolygonResolver->ensureZonePolygonTable (line 469)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 417)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getConstructionObjectsInZone (line 2175)
8	App\Service\Motocultrice->getConstructionObjects (line 1695)
9	App\Service\Motocultrice->getFollowupThemeObjectsForMap (line 1881)
10	App\Controller\AdminController->followupThemeGraph (line 2010)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
osm	doctrine.dbal.osm_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\CityFollowUp	5039
App\Entity\Stats	1
App\Entity\ActionLog	1
App\Entity\ZonePlaces	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.
App\Entity\SireneEntreprise	No errors.
App\Entity\ActionLog	No errors.

Symfony Profiler

GET https://osm-labo.cipherbliss.com/admin/stats/12100/followup-graph/travaux

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

osm connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping