Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

1128.18 ms Query time

0 Invalid entities

24 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

857.39 ms
(76.00%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.price AS price_4, t0.precision_price AS precision_price_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.time_start AS time_start_8, t0.time_end AS time_end_9, t0.precision_date AS precision_date_10, t0.choice_of_days AS choice_of_days_11, t0.description AS description_12, t0.cover_image AS cover_image_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.place_temporary AS place_temporary_16, t0.is_validated AS is_validated_17, t0.is_canceled AS is_canceled_18, t0.is_published AS is_published_19, t0.is_spam AS is_spam_20, t0.is_mistake AS is_mistake_21, t0.is_duplicated AS is_duplicated_22, t0.is_full AS is_full_23, t0.is_postponed AS is_postponed_24, t0.links AS links_25, t0.city_id AS city_id_26, t0.place_id AS place_id_27, t0.rubric_id AS rubric_id_28, t0.organizer_id AS organizer_id_29, t0.festival_id AS festival_id_30 FROM event t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "une-comete-et-des-parques-par-la-cie-e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.price AS price_4,
  t0.precision_price AS precision_price_5,
  t0.date_start AS date_start_6,
  t0.date_end AS date_end_7,
  t0.time_start AS time_start_8,
  t0.time_end AS time_end_9,
  t0.precision_date AS precision_date_10,
  t0.choice_of_days AS choice_of_days_11,
  t0.description AS description_12,
  t0.cover_image AS cover_image_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.place_temporary AS place_temporary_16,
  t0.is_validated AS is_validated_17,
  t0.is_canceled AS is_canceled_18,
  t0.is_published AS is_published_19,
  t0.is_spam AS is_spam_20,
  t0.is_mistake AS is_mistake_21,
  t0.is_duplicated AS is_duplicated_22,
  t0.is_full AS is_full_23,
  t0.is_postponed AS is_postponed_24,
  t0.links AS links_25,
  t0.city_id AS city_id_26,
  t0.place_id AS place_id_27,
  t0.rubric_id AS rubric_id_28,
  t0.organizer_id AS organizer_id_29,
  t0.festival_id AS festival_id_30
FROM
  event t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.price AS price_4, t0.precision_price AS precision_price_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.time_start AS time_start_8, t0.time_end AS time_end_9, t0.precision_date AS precision_date_10, t0.choice_of_days AS choice_of_days_11, t0.description AS description_12, t0.cover_image AS cover_image_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.place_temporary AS place_temporary_16, t0.is_validated AS is_validated_17, t0.is_canceled AS is_canceled_18, t0.is_published AS is_published_19, t0.is_spam AS is_spam_20, t0.is_mistake AS is_mistake_21, t0.is_duplicated AS is_duplicated_22, t0.is_full AS is_full_23, t0.is_postponed AS is_postponed_24, t0.links AS links_25, t0.city_id AS city_id_26, t0.place_id AS place_id_27, t0.rubric_id AS rubric_id_28, t0.organizer_id AS organizer_id_29, t0.festival_id AS festival_id_30 FROM event t0 WHERE t0.slug = 'une-comete-et-des-parques-par-la-cie-e' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 79)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

234.19 ms
(20.76%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.slogan AS slogan_3, s0_.color AS color_4, s0_.resident AS resident_5, s0_.network AS network_6, s0_.main_borough_id AS main_borough_id_7 FROM subdomain s0_ INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id INNER JOIN borough b1_ ON b1_.id = s2_.borough_id INNER JOIN city c3_ ON b1_.id = c3_.borough_id INNER JOIN event e4_ ON c3_.id = e4_.city_id WHERE e4_.date_end >= ? GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC

Parameters:

[
  "2025-10-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.slogan AS slogan_3,
  s0_.color AS color_4,
  s0_.resident AS resident_5,
  s0_.network AS network_6,
  s0_.main_borough_id AS main_borough_id_7
FROM
  subdomain s0_
  INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id
  INNER JOIN borough b1_ ON b1_.id = s2_.borough_id
  INNER JOIN city c3_ ON b1_.id = c3_.borough_id
  INNER JOIN event e4_ ON c3_.id = e4_.city_id
WHERE
  e4_.date_end >= ?
GROUP BY
  s0_.id
HAVING
  COUNT(e4_.id) > 0
ORDER BY
  COUNT(e4_.id) DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.slogan AS slogan_3, s0_.color AS color_4, s0_.resident AS resident_5, s0_.network AS network_6, s0_.main_borough_id AS main_borough_id_7 FROM subdomain s0_ INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id INNER JOIN borough b1_ ON b1_.id = s2_.borough_id INNER JOIN city c3_ ON b1_.id = c3_.borough_id INNER JOIN event e4_ ON c3_.id = e4_.city_id WHERE e4_.date_end >= '2025-10-26' GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 38)
7	App\Repository\SubdomainRepository->findSubdomains (line 80)
8	App\Service\SubdomainService->getListOfSubdomains (line 34)
9	App\Twig\SubdomainExtension->getListOfSubdomains (line 79)
10	__TwigTemplate_88a455655c5c995b251057eec7499b39->doDisplay (line 402)
11	Twig\Template->yield (line 201)
12	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->block_navbar (line 446)
13	Twig\Template->yieldBlock (line 98)
14	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->doDisplay (line 402)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
25	App\Controller\EventController->show (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

16.85 ms
(1.49%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.cover_image AS cover_image_4, t0.description AS description_5, t0.pronoun AS pronoun_6, t0.name AS name_7, t0.number AS number_8, t0.address AS address_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.oldserial AS oldserial_12, t0.oldurl AS oldurl_13, t0.opening AS opening_14, t0.links AS links_15, t0.map_url AS map_url_16, t0.street_url AS street_url_17, t0.email AS email_18, t0.phone AS phone_19, t0.ip AS ip_20, t0.transport AS transport_21, t0.data_link AS data_link_22, t0.opinion AS opinion_23, t0.summary AS summary_24, t0.wifi AS wifi_25, t0.last_service AS last_service_26, t0.parking AS parking_27, t0.multi_titles AS multi_titles_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.city_id AS city_id_31, t0.district_id AS district_id_32 FROM place t0 WHERE t0.id = ?

Parameters:

[
  1371
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.cover_image AS cover_image_4,
  t0.description AS description_5,
  t0.pronoun AS pronoun_6,
  t0.name AS name_7,
  t0.number AS number_8,
  t0.address AS address_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.oldserial AS oldserial_12,
  t0.oldurl AS oldurl_13,
  t0.opening AS opening_14,
  t0.links AS links_15,
  t0.map_url AS map_url_16,
  t0.street_url AS street_url_17,
  t0.email AS email_18,
  t0.phone AS phone_19,
  t0.ip AS ip_20,
  t0.transport AS transport_21,
  t0.data_link AS data_link_22,
  t0.opinion AS opinion_23,
  t0.summary AS summary_24,
  t0.wifi AS wifi_25,
  t0.last_service AS last_service_26,
  t0.parking AS parking_27,
  t0.multi_titles AS multi_titles_28,
  t0.latitude AS latitude_29,
  t0.longitude AS longitude_30,
  t0.city_id AS city_id_31,
  t0.district_id AS district_id_32
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.cover_image AS cover_image_4, t0.description AS description_5, t0.pronoun AS pronoun_6, t0.name AS name_7, t0.number AS number_8, t0.address AS address_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.oldserial AS oldserial_12, t0.oldurl AS oldurl_13, t0.opening AS opening_14, t0.links AS links_15, t0.map_url AS map_url_16, t0.street_url AS street_url_17, t0.email AS email_18, t0.phone AS phone_19, t0.ip AS ip_20, t0.transport AS transport_21, t0.data_link AS data_link_22, t0.opinion AS opinion_23, t0.summary AS summary_24, t0.wifi AS wifi_25, t0.last_service AS last_service_26, t0.parking AS parking_27, t0.multi_titles AS multi_titles_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.city_id AS city_id_31, t0.district_id AS district_id_32 FROM place t0 WHERE t0.id = 1371;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\Place::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Place->__get (line 192)
8	App\Entity\Place->getSlug (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 147)
10	__TwigTemplate_2a4299f4875363d05f6bff37b74ff194->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 62)
17	__TwigTemplate_f6296e57380e150bc47b160e95f235aa->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 77)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 101)
24	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->block_body (line 446)
25	Twig\Template->yieldBlock (line 103)
26	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->doDisplay (line 402)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 459)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
37	App\Controller\EventController->show (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

16.83 ms
(1.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN event_category ON t0.id = event_category.category_id WHERE event_category.event_id = ?

Parameters:

[
  134009
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  category t0
  INNER JOIN event_category ON t0.id = event_category.category_id
WHERE
  event_category.event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN event_category ON t0.id = event_category.category_id WHERE event_category.event_id = 134009;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 103)
8	__TwigTemplate_2a4299f4875363d05f6bff37b74ff194->doDisplay (line 402)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 62)
15	__TwigTemplate_f6296e57380e150bc47b160e95f235aa->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 77)
19	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
20	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
21	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 101)
22	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->block_body (line 446)
23	Twig\Template->yieldBlock (line 103)
24	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->doDisplay (line 402)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 333)
31	Twig\Environment->render (line 459)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
35	App\Controller\EventController->show (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

0.82 ms
(0.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.single AS single_5, t0.plural AS plural_6 FROM rubric t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.single AS single_5,
  t0.plural AS plural_6
FROM
  rubric t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.single AS single_5, t0.plural AS plural_6 FROM rubric t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\Rubric::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Rubric->__get (line 96)
8	App\Entity\Rubric->getColor (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 93)
10	__TwigTemplate_2a4299f4875363d05f6bff37b74ff194->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 62)
17	__TwigTemplate_f6296e57380e150bc47b160e95f235aa->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 77)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 101)
24	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->block_body (line 446)
25	Twig\Template->yieldBlock (line 103)
26	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->doDisplay (line 402)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 459)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
37	App\Controller\EventController->show (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.75 ms
(0.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.coat_of_arms AS coat_of_arms_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.borough_id AS borough_id_8 FROM city t0 WHERE t0.id = ?

Parameters:

[
  3992
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.coat_of_arms AS coat_of_arms_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.borough_id AS borough_id_8
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.coat_of_arms AS coat_of_arms_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.borough_id AS borough_id_8 FROM city t0 WHERE t0.id = 3992;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\City::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\City->__get (line 91)
8	App\Entity\City->getSlug (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 154)
10	__TwigTemplate_2a4299f4875363d05f6bff37b74ff194->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 62)
17	__TwigTemplate_f6296e57380e150bc47b160e95f235aa->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 77)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 101)
24	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->block_body (line 446)
25	Twig\Template->yieldBlock (line 103)
26	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->doDisplay (line 402)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 459)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
37	App\Controller\EventController->show (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.69 ms
(0.06%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.caption AS caption_3, t0.videostore_id AS videostore_id_4, t0.event_id AS event_id_5 FROM video t0 WHERE t0.event_id = ?

Parameters:

[
  134009
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.caption AS caption_3,
  t0.videostore_id AS videostore_id_4,
  t0.event_id AS event_id_5
FROM
  video t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.caption AS caption_3, t0.videostore_id AS videostore_id_4, t0.event_id AS event_id_5 FROM video t0 WHERE t0.event_id = 134009;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 90)
8	__TwigTemplate_f6296e57380e150bc47b160e95f235aa->doDisplay (line 402)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 101)
15	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->block_body (line 446)
16	Twig\Template->yieldBlock (line 103)
17	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->doDisplay (line 402)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
28	App\Controller\EventController->show (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.67 ms
(0.06%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.price AS price_3, t0.information AS information_4, t0.event_id AS event_id_5, t0.ticketing_id AS ticketing_id_6 FROM ticket t0 WHERE t0.event_id = ?

Parameters:

[
  134009
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.price AS price_3,
  t0.information AS information_4,
  t0.event_id AS event_id_5,
  t0.ticketing_id AS ticketing_id_6
FROM
  ticket t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.price AS price_3, t0.information AS information_4, t0.event_id AS event_id_5, t0.ticketing_id AS ticketing_id_6 FROM ticket t0 WHERE t0.event_id = 134009;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1272)
9	Twig\Extension\CoreExtension::length (line 215)
10	__TwigTemplate_2a4299f4875363d05f6bff37b74ff194->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 62)
17	__TwigTemplate_f6296e57380e150bc47b160e95f235aa->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 77)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 101)
24	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->block_body (line 446)
25	Twig\Template->yieldBlock (line 103)
26	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->doDisplay (line 402)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_b5e51fc3410122f4edc7cd39e6a371f6->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 459)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
37	App\Controller\EventController->show (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	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\Subdomain	9
App\Entity\Borough	9
App\Entity\Event	1
App\Entity\Place	1
App\Entity\Rubric	1
App\Entity\Festival	1
App\Entity\City	1
App\Entity\District	1

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\City	No errors.
App\Entity\Place	No errors.
App\Entity\Rubric	No errors.
App\Entity\Organizer	No errors.
App\Entity\Festival	No errors.
App\Entity\Category	No errors.
App\Entity\Ticket	No errors.
App\Entity\Video	No errors.
App\Entity\Prices	No errors.
App\Entity\Artist	No errors.
App\Entity\Subdomain	No errors.
App\Entity\Borough	No errors.
App\Entity\District	No errors.
App\Entity\Ticketing	No errors.
App\Entity\Videostore	No errors.

Symfony Profiler

GET https://www.curieux.app/agenda/evenement/une-comete-et-des-parques-par-la-cie-e

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping