Symfony Profiler

Query Metrics

15 Database Queries

6 Different statements

18.66 ms Query time

0 Invalid entities

44 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.34 ms
(55.41%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.icon AS icon_5, t0.position AS position_6, t0.block AS block_7, t0.content_en AS content_en_8, t0.title_en AS title_en_9, t0.active AS active_10, t0.parent_id AS parent_id_11, t0.medium_id AS medium_id_12, t0.cover_id AS cover_id_13, t0.background_id AS background_id_14 FROM page t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC

Parameters:

[
  4
]

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.content AS content_4,
  t0.icon AS icon_5,
  t0.position AS position_6,
  t0.block AS block_7,
  t0.content_en AS content_en_8,
  t0.title_en AS title_en_9,
  t0.active AS active_10,
  t0.parent_id AS parent_id_11,
  t0.medium_id AS medium_id_12,
  t0.cover_id AS cover_id_13,
  t0.background_id AS background_id_14
FROM
  page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.icon AS icon_5, t0.position AS position_6, t0.block AS block_7, t0.content_en AS content_en_8, t0.title_en AS title_en_9, t0.active AS active_10, t0.parent_id AS parent_id_11, t0.medium_id AS medium_id_12, t0.cover_id AS cover_id_13, t0.background_id AS background_id_14 FROM page t0 WHERE t0.parent_id = 4 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
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	IteratorIterator->__construct (line 1970)
8	Twig\Extension\CoreExtension->filter (line 1970)
9	__TwigTemplate_6f2bbc066d56c46d665e3a7395641eb2::doDisplay (line 172)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_97d440bf1d103296b4e9ca26d1ad7781->block_navbar (line 238)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_97d440bf1d103296b4e9ca26d1ad7781->doDisplay (line 101)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_3a7e7e5054a6fca000fb1e8e39f9d48c->doDisplay (line 54)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
29	App\Controller\HomeController->index (line 25)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 185)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

2.85 ms
(15.27%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.icon AS icon_5, t0.position AS position_6, t0.block AS block_7, t0.content_en AS content_en_8, t0.title_en AS title_en_9, t0.active AS active_10, t0.parent_id AS parent_id_11, t0.medium_id AS medium_id_12, t0.cover_id AS cover_id_13, t0.background_id AS background_id_14 FROM page t0 WHERE t0.parent_id IS NULL AND t0.active = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

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.content AS content_4,
  t0.icon AS icon_5,
  t0.position AS position_6,
  t0.block AS block_7,
  t0.content_en AS content_en_8,
  t0.title_en AS title_en_9,
  t0.active AS active_10,
  t0.parent_id AS parent_id_11,
  t0.medium_id AS medium_id_12,
  t0.cover_id AS cover_id_13,
  t0.background_id AS background_id_14
FROM
  page t0
WHERE
  t0.parent_id IS NULL
  AND t0.active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.icon AS icon_5, t0.position AS position_6, t0.block AS block_7, t0.content_en AS content_en_8, t0.title_en AS title_en_9, t0.active AS active_10, t0.parent_id AS parent_id_11, t0.medium_id AS medium_id_12, t0.cover_id AS cover_id_13, t0.background_id AS background_id_14 FROM page t0 WHERE t0.parent_id IS NULL AND t0.active = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\HomeController->index (line 20)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 185)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

2.17 ms
(11.65%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.location AS location_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.city AS city_6, t0.start_inscription AS start_inscription_7, t0.end_inscription AS end_inscription_8, t0.stand_price AS stand_price_9, t0.cocktail_price AS cocktail_price_10, t0.cocktail_capacity AS cocktail_capacity_11, t0.current AS current_12, t0.start_badge_request AS start_badge_request_13, t0.end_badge_request AS end_badge_request_14, t0.end_edition_date_exhibitor AS end_edition_date_exhibitor_15, t0.has_garden_party AS has_garden_party_16, t0.floor_plan_id AS floor_plan_id_17, t0.technical_file_en_id AS technical_file_en_id_18, t0.technical_file_id AS technical_file_id_19, t0.badge_background_id AS badge_background_id_20, t0.badge_id AS badge_id_21 FROM exhibition t0 WHERE t0.current = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.location AS location_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.city AS city_6,
  t0.start_inscription AS start_inscription_7,
  t0.end_inscription AS end_inscription_8,
  t0.stand_price AS stand_price_9,
  t0.cocktail_price AS cocktail_price_10,
  t0.cocktail_capacity AS cocktail_capacity_11,
  t0.current AS current_12,
  t0.start_badge_request AS start_badge_request_13,
  t0.end_badge_request AS end_badge_request_14,
  t0.end_edition_date_exhibitor AS end_edition_date_exhibitor_15,
  t0.has_garden_party AS has_garden_party_16,
  t0.floor_plan_id AS floor_plan_id_17,
  t0.technical_file_en_id AS technical_file_en_id_18,
  t0.technical_file_id AS technical_file_id_19,
  t0.badge_background_id AS badge_background_id_20,
  t0.badge_id AS badge_id_21
FROM
  exhibition t0
WHERE
  t0.current = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.number AS number_2, t0.location AS location_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.city AS city_6, t0.start_inscription AS start_inscription_7, t0.end_inscription AS end_inscription_8, t0.stand_price AS stand_price_9, t0.cocktail_price AS cocktail_price_10, t0.cocktail_capacity AS cocktail_capacity_11, t0.current AS current_12, t0.start_badge_request AS start_badge_request_13, t0.end_badge_request AS end_badge_request_14, t0.end_edition_date_exhibitor AS end_edition_date_exhibitor_15, t0.has_garden_party AS has_garden_party_16, t0.floor_plan_id AS floor_plan_id_17, t0.technical_file_en_id AS technical_file_en_id_18, t0.technical_file_id AS technical_file_id_19, t0.badge_background_id AS badge_background_id_20, t0.badge_id AS badge_id_21 FROM exhibition t0 WHERE t0.current = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\HomeController->index (line 22)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 185)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.28 ms
(6.87%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.size AS size_4, t0.path AS path_5, t0.media_directory_id AS media_directory_id_6 FROM media t0 WHERE t0.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.size AS size_4,
  t0.path AS path_5,
  t0.media_directory_id AS media_directory_id_6
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.size AS size_4, t0.path AS path_5, t0.media_directory_id AS media_directory_id_6 FROM media t0 WHERE t0.id = 8;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Media::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Media->__get (line 120)
7	App\Entity\Media->getPath (line 99)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_3a7e7e5054a6fca000fb1e8e39f9d48c::block_body (line 117)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_97d440bf1d103296b4e9ca26d1ad7781->block_container (line 265)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_97d440bf1d103296b4e9ca26d1ad7781->doDisplay (line 104)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_3a7e7e5054a6fca000fb1e8e39f9d48c->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\HomeController->index (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 185)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.09 ms
(5.83%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.start_date AS start_date_2, a0_.end_date AS end_date_3, a0_.display_on_homepage AS display_on_homepage_4, a0_.display_on_other_pages AS display_on_other_pages_5, a0_.format AS format_6, a0_.link AS link_7, a0_.active AS active_8, a0_.media_id AS media_id_9 FROM advert a0_ WHERE a0_.active = ? AND (a0_.start_date <= ? OR a0_.start_date IS NULL) AND (a0_.end_date >= ? OR a0_.end_date IS NULL) AND a0_.display_on_homepage = ?

Parameters:

[
  1
  "2025-12-08 22:35:22"
  "2025-12-08 22:35:22"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.start_date AS start_date_2,
  a0_.end_date AS end_date_3,
  a0_.display_on_homepage AS display_on_homepage_4,
  a0_.display_on_other_pages AS display_on_other_pages_5,
  a0_.format AS format_6,
  a0_.link AS link_7,
  a0_.active AS active_8,
  a0_.media_id AS media_id_9
FROM
  advert a0_
WHERE
  a0_.active = ?
  AND (
    a0_.start_date <= ?
    OR a0_.start_date IS NULL
  )
  AND (
    a0_.end_date >= ?
    OR a0_.end_date IS NULL
  )
  AND a0_.display_on_homepage = ?

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.start_date AS start_date_2, a0_.end_date AS end_date_3, a0_.display_on_homepage AS display_on_homepage_4, a0_.display_on_other_pages AS display_on_other_pages_5, a0_.format AS format_6, a0_.link AS link_7, a0_.active AS active_8, a0_.media_id AS media_id_9 FROM advert a0_ WHERE a0_.active = 1 AND (a0_.start_date <= '2025-12-08 22:35:22' OR a0_.start_date IS NULL) AND (a0_.end_date >= '2025-12-08 22:35:22' OR a0_.end_date IS NULL) AND a0_.display_on_homepage = 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\AdvertRepository->getActiveAdverts (line 50)
7	App\Twig\ActiveAdvertsExtension->getActiveAdverts (line 30)
8	__TwigTemplate_3a7e7e5054a6fca000fb1e8e39f9d48c->block_body (line 258)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_97d440bf1d103296b4e9ca26d1ad7781->block_container (line 265)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_97d440bf1d103296b4e9ca26d1ad7781->doDisplay (line 104)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_3a7e7e5054a6fca000fb1e8e39f9d48c->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\HomeController->index (line 25)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 185)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.93 ms
(4.97%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.active AS active_4, t0.content_en AS content_en_5, t0.cover_id AS cover_id_6, t0.left_image_id AS left_image_id_7, t0.right_image_id AS right_image_id_8, t0.video_cover_id AS video_cover_id_9 FROM editorial t0 WHERE t0.active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.active AS active_4,
  t0.content_en AS content_en_5,
  t0.cover_id AS cover_id_6,
  t0.left_image_id AS left_image_id_7,
  t0.right_image_id AS right_image_id_8,
  t0.video_cover_id AS video_cover_id_9
FROM
  editorial t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.active AS active_4, t0.content_en AS content_en_5, t0.cover_id AS cover_id_6, t0.left_image_id AS left_image_id_7, t0.right_image_id AS right_image_id_8, t0.video_cover_id AS video_cover_id_9 FROM editorial t0 WHERE t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\HomeController->index (line 23)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 185)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Page	20
App\Entity\Media	20
App\Entity\MediaDirectory	2
App\Entity\Exhibition	1
App\Entity\Editorial	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Media	No errors.
App\Entity\Exhibition	No errors.
App\Entity\Exhibitor	No errors.
App\Entity\Visitor	No errors.
App\Entity\Accreditation	No errors.
App\Entity\Editorial	No errors.
App\Entity\MediaDirectory	No errors.
App\Entity\Advert	No errors.

Symfony Profiler

GET https://preprod.simppar.fr/fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping