Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.46 ms Query time

0 Invalid entities

90 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

0.99 ms

SELECT t0.id AS id_1, t0.position AS position_2, t0.content_type AS content_type_3, t0.content_title AS content_title_4, t0.content_sub_title AS content_sub_title_5, t0.content_description AS content_description_6, t0.page_id AS page_id_7 FROM page_block t0 WHERE t0.page_id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.content_type AS content_type_3,
  t0.content_title AS content_title_4,
  t0.content_sub_title AS content_sub_title_5,
  t0.content_description AS content_description_6,
  t0.page_id AS page_id_7
FROM
  page_block t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.content_type AS content_type_3, t0.content_title AS content_title_4, t0.content_sub_title AS content_sub_title_5, t0.content_description AS content_description_6, t0.page_id AS page_id_7 FROM page_block t0 WHERE t0.page_id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 506)
4	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadOneToManyCollection (line 2706)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
7	Doctrine\ORM\PersistentCollection->initialize (line 237)
8	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 31)
9	App\Service\PageBlockManager->getPageBlock (line 212)
10	App\Controller\PageController->event (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

2.68 ms

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.shortDescription AS shortDescription_3, e0_.date AS date_4, e0_.price AS price_5, e0_.capacity AS capacity_6, e0_.image_name AS image_name_7, e0_.status AS status_8, e0_.hour AS hour_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.slug AS slug_12 FROM event e0_ WHERE e0_.date > ? ORDER BY e0_.date ASC

Parameters:

[
  "2025-12-06 04:30:53"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.description AS description_2,
  e0_.shortDescription AS shortDescription_3,
  e0_.date AS date_4,
  e0_.price AS price_5,
  e0_.capacity AS capacity_6,
  e0_.image_name AS image_name_7,
  e0_.status AS status_8,
  e0_.hour AS hour_9,
  e0_.created_at AS created_at_10,
  e0_.updated_at AS updated_at_11,
  e0_.slug AS slug_12
FROM
  event e0_
WHERE
  e0_.date > ?
ORDER BY
  e0_.date ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.shortDescription AS shortDescription_3, e0_.date AS date_4, e0_.price AS price_5, e0_.capacity AS capacity_6, e0_.image_name AS image_name_7, e0_.status AS status_8, e0_.hour AS hour_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.slug AS slug_12 FROM event e0_ WHERE e0_.date > '2025-12-06 04:30:53' ORDER BY e0_.date ASC;

#	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 28)
7	App\Repository\EventRepository->findNotPast (line 216)
8	App\Controller\PageController->event (line 183)
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)

0.79 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.target AS target_4, t0.menu_id AS menu_id_5, t0.page_id AS page_id_6 FROM menu_item t0 WHERE t0.menu_id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.target AS target_4,
  t0.menu_id AS menu_id_5,
  t0.page_id AS page_id_6
FROM
  menu_item t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.target AS target_4, t0.menu_id AS menu_id_5, t0.page_id AS page_id_6 FROM menu_item t0 WHERE t0.menu_id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 506)
4	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadOneToManyCollection (line 2706)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
7	Doctrine\ORM\PersistentCollection->initialize (line 157)
8	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 40)
9	App\Service\MenuManager->getMenuItemsByPosition (line 28)
10	App\Twig\MenuExtension->getMenu (line 48)
11	__TwigTemplate_5e727e9d30a43d20e1a121a1325dc7d4->doDisplay (line 388)
12	Twig\Template->yield (line 66)
13	__TwigTemplate_011e771c2f9850cef005b8942bc71348->doDisplay (line 388)
14	Twig\Template->yield (line 62)
15	__TwigTemplate_da51aa96b5cb76dfa5b82847df5f468e->doDisplay (line 388)
16	Twig\Template->yield (line 143)
17	__TwigTemplate_417e47180f868c41a4acb596461967bb->doDisplay (line 388)
18	Twig\Template->yield (line 58)
19	__TwigTemplate_9d87aaad1b0f9d72ca3e664e79129931->doDisplay (line 388)
20	Twig\Template->yield (line 53)
21	__TwigTemplate_f951c06d3e82e6b134b031f89dbbda26->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 218)
30	App\Controller\PageController->event (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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

90 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
app_entity_settings	80
app_entity_page	6
app_entity_menu	4

Entities Mapping

Class	Mapping errors
App\Entity\Settings	No errors.
App\Entity\Page	No errors.
App\Entity\PageBlock	No errors.
App\Entity\Event	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuItem	No errors.

Symfony Profiler

GET https://www.dev.lacaserne-juniville.fr/atelier-et-evenement-juniville

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Entities Mapping