Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1703.34 ms Query time

0 Invalid entities

2587 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1089.32 ms
(63.95%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.cover_image AS cover_image_3, p0_.description AS description_4, p0_.pronoun AS pronoun_5, p0_.name AS name_6, p0_.number AS number_7, p0_.address AS address_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.oldserial AS oldserial_11, p0_.oldurl AS oldurl_12, p0_.opening AS opening_13, p0_.links AS links_14, p0_.map_url AS map_url_15, p0_.street_url AS street_url_16, p0_.email AS email_17, p0_.phone AS phone_18, p0_.ip AS ip_19, p0_.transport AS transport_20, p0_.data_link AS data_link_21, p0_.opinion AS opinion_22, p0_.summary AS summary_23, p0_.wifi AS wifi_24, p0_.last_service AS last_service_25, p0_.parking AS parking_26, p0_.multi_titles AS multi_titles_27, p0_.latitude AS latitude_28, p0_.longitude AS longitude_29, p0_.city_id AS city_id_30, p0_.district_id AS district_id_31 FROM place p0_ LEFT JOIN event e1_ ON p0_.id = e1_.place_id WHERE e1_.is_published = 1 AND e1_.is_validated = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.cover_image AS cover_image_3,
  p0_.description AS description_4,
  p0_.pronoun AS pronoun_5,
  p0_.name AS name_6,
  p0_.number AS number_7,
  p0_.address AS address_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.oldserial AS oldserial_11,
  p0_.oldurl AS oldurl_12,
  p0_.opening AS opening_13,
  p0_.links AS links_14,
  p0_.map_url AS map_url_15,
  p0_.street_url AS street_url_16,
  p0_.email AS email_17,
  p0_.phone AS phone_18,
  p0_.ip AS ip_19,
  p0_.transport AS transport_20,
  p0_.data_link AS data_link_21,
  p0_.opinion AS opinion_22,
  p0_.summary AS summary_23,
  p0_.wifi AS wifi_24,
  p0_.last_service AS last_service_25,
  p0_.parking AS parking_26,
  p0_.multi_titles AS multi_titles_27,
  p0_.latitude AS latitude_28,
  p0_.longitude AS longitude_29,
  p0_.city_id AS city_id_30,
  p0_.district_id AS district_id_31
FROM
  place p0_
  LEFT JOIN event e1_ ON p0_.id = e1_.place_id
WHERE
  e1_.is_published = 1
  AND e1_.is_validated = 1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.cover_image AS cover_image_3, p0_.description AS description_4, p0_.pronoun AS pronoun_5, p0_.name AS name_6, p0_.number AS number_7, p0_.address AS address_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.oldserial AS oldserial_11, p0_.oldurl AS oldurl_12, p0_.opening AS opening_13, p0_.links AS links_14, p0_.map_url AS map_url_15, p0_.street_url AS street_url_16, p0_.email AS email_17, p0_.phone AS phone_18, p0_.ip AS ip_19, p0_.transport AS transport_20, p0_.data_link AS data_link_21, p0_.opinion AS opinion_22, p0_.summary AS summary_23, p0_.wifi AS wifi_24, p0_.last_service AS last_service_25, p0_.parking AS parking_26, p0_.multi_titles AS multi_titles_27, p0_.latitude AS latitude_28, p0_.longitude AS longitude_29, p0_.city_id AS city_id_30, p0_.district_id AS district_id_31 FROM place p0_ LEFT JOIN event e1_ ON p0_.id = e1_.place_id WHERE e1_.is_published = 1 AND e1_.is_validated = 1;

#	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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 59)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->doLoadChoicesForValues (line 105)
10	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
11	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 36)
12	Symfony\Component\Form\ChoiceList\Factory\Cache\ChoiceLoader->loadChoicesForValues (line 38)
13	Symfony\Component\Form\ChoiceList\Loader\LazyChoiceLoader->loadChoicesForValues (line 49)
14	Symfony\Component\Form\ChoiceList\Loader\LazyChoiceLoader->loadValuesForChoices (line 81)
15	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 32)
16	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 980)
17	Symfony\Component\Form\Form->normToView (line 295)
18	Symfony\Component\Form\Form->setData (line 50)
19	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 317)
20	Symfony\Component\Form\Form->setData (line 406)
21	Symfony\Component\Form\Form->initialize (line 171)
22	Symfony\Component\Form\FormBuilder->getForm (line 26)
23	Symfony\Component\Form\FormFactory->create (line 351)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 156)
25	App\Controller\EventController->new (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)

601.03 ms
(35.29%)

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-24"
]

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-24' 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_064afbf896ca44dca884d19135fe436d->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 175)
25	App\Controller\EventController->new (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)

8.61 ms
(0.51%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "m"
]

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.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.main_borough_id AS main_borough_id_8
FROM
  subdomain t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = 'm' 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 62)
5	App\Service\SubdomainService->getEntityOfSubdomain (line 70)
6	App\Service\SubdomainService->getNameOfWebsite (line 29)
7	App\Twig\SubdomainExtension->getNameOfWebsite (line 67)
8	__TwigTemplate_88a455655c5c995b251057eec7499b39->doDisplay (line 402)
9	Twig\Template->yield (line 201)
10	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->block_navbar (line 446)
11	Twig\Template->yieldBlock (line 98)
12	__TwigTemplate_6064000614a9bd43d52c362364c3cc0c->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_064afbf896ca44dca884d19135fe436d->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 175)
23	App\Controller\EventController->new (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

4.37 ms
(0.26%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.color AS color_3, r0_.single AS single_4, r0_.plural AS plural_5 FROM rubric r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.slug AS slug_2,
  r0_.color AS color_3,
  r0_.single AS single_4,
  r0_.plural AS plural_5
FROM
  rubric r0_

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.color AS color_3, r0_.single AS single_4, r0_.plural AS plural_5 FROM rubric r0_;

#	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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 451)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 175)
24	App\Controller\EventController->new (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\Place	2222
App\Entity\City	305
App\Entity\District	33
App\Entity\Rubric	9
App\Entity\Subdomain	9
App\Entity\Borough	9

Entities Mapping

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

Symfony Profiler

GET https://m.curieux.app/agenda/annoncer-un-evenement

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping