Symfony Profiler

Query Metrics

33 Database Queries

8 Different statements

11.84 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.95 ms
(50.23%)

SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.meta_description AS meta_description_2,
  t0.og_description AS og_description_3,
  t0.og_title AS og_title_4,
  t0.slug AS slug_5,
  t0.is_published AS is_published_6,
  t0.update_date AS update_date_7,
  t0.meta_keywords AS meta_keywords_8,
  t0.json_ld AS json_ld_9,
  t0.id AS id_10,
  t0.content AS content_11,
  t0.og_image_id AS og_image_id_12,
  t0.language_id AS language_id_13
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Page::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Page->__get (line 97)
8	App\Entity\Page->getLanguage (line 1802)
9	Twig\Extension\CoreExtension::getAttribute (line 174)
10	__TwigTemplate_b751fc3a2c853a1057a925e15c317848->doDisplay (line 393)
11	Twig\Template->yield (line 53)
12	__TwigTemplate_06ec06279a7bdf9a100c10a8546ff1ec->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 46)
21	App\Controller\PageController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

2.62 ms
(22.17%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = ? 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.label AS label_2,
  t0.title AS title_3,
  t0.is_active AS is_active_4,
  t0.position AS position_5,
  t0.page_id AS page_id_6,
  t0.parent_id AS parent_id_7,
  t0.language_id AS language_id_8
FROM
  menu t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
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 1218)
9	Twig\Extension\CoreExtension::length (line 154)
10	__TwigTemplate_b751fc3a2c853a1057a925e15c317848->doDisplay (line 393)
11	Twig\Template->yield (line 53)
12	__TwigTemplate_06ec06279a7bdf9a100c10a8546ff1ec->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 46)
21	App\Controller\PageController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.91 ms
(7.70%)

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2 FROM language l0_ WHERE l0_.code = ?

Parameters:

[
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2
FROM
  language l0_
WHERE
  l0_.code = ?

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2 FROM language l0_ WHERE l0_.code = 'fr';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 25)
7	App\Repository\LanguageRepository->findOneByCode (line 35)
8	App\Service\LanguageService->getCurrentLanguage (line 33)
9	App\Controller\PageController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.82 ms
(6.97%)

SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.title AS title_2, m0_.is_active AS is_active_3, m0_.position AS position_4, m0_.page_id AS page_id_5, m0_.parent_id AS parent_id_6, m0_.language_id AS language_id_7 FROM menu m0_ WHERE m0_.is_active = 1 AND m0_.parent_id IS NULL AND m0_.language_id = ? ORDER BY m0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.label AS label_1,
  m0_.title AS title_2,
  m0_.is_active AS is_active_3,
  m0_.position AS position_4,
  m0_.page_id AS page_id_5,
  m0_.parent_id AS parent_id_6,
  m0_.language_id AS language_id_7
FROM
  menu m0_
WHERE
  m0_.is_active = 1
  AND m0_.parent_id IS NULL
  AND m0_.language_id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.title AS title_2, m0_.is_active AS is_active_3, m0_.position AS position_4, m0_.page_id AS page_id_5, m0_.parent_id AS parent_id_6, m0_.language_id AS language_id_7 FROM menu m0_ WHERE m0_.is_active = 1 AND m0_.parent_id IS NULL AND m0_.language_id = 1 ORDER BY m0_.position 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 32)
7	App\Repository\MenuRepository->findRootMenus (line 24)
8	App\Service\MenuService->getRootMenus (line 1802)
9	Twig\Extension\CoreExtension::getAttribute (line 150)
10	__TwigTemplate_b751fc3a2c853a1057a925e15c317848->doDisplay (line 393)
11	Twig\Template->yield (line 53)
12	__TwigTemplate_06ec06279a7bdf9a100c10a8546ff1ec->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 46)
21	App\Controller\PageController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.56 ms
(4.77%)

SELECT p0_.title AS title_0, p0_.meta_description AS meta_description_1, p0_.og_description AS og_description_2, p0_.og_title AS og_title_3, p0_.slug AS slug_4, p0_.is_published AS is_published_5, p0_.update_date AS update_date_6, p0_.meta_keywords AS meta_keywords_7, p0_.json_ld AS json_ld_8, p0_.id AS id_9, p0_.content AS content_10, p0_.og_image_id AS og_image_id_11, p0_.language_id AS language_id_12 FROM page p0_ WHERE p0_.slug = ?

Parameters:

[
  "home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.title AS title_0,
  p0_.meta_description AS meta_description_1,
  p0_.og_description AS og_description_2,
  p0_.og_title AS og_title_3,
  p0_.slug AS slug_4,
  p0_.is_published AS is_published_5,
  p0_.update_date AS update_date_6,
  p0_.meta_keywords AS meta_keywords_7,
  p0_.json_ld AS json_ld_8,
  p0_.id AS id_9,
  p0_.content AS content_10,
  p0_.og_image_id AS og_image_id_11,
  p0_.language_id AS language_id_12
FROM
  page p0_
WHERE
  p0_.slug = ?

SELECT p0_.title AS title_0, p0_.meta_description AS meta_description_1, p0_.og_description AS og_description_2, p0_.og_title AS og_title_3, p0_.slug AS slug_4, p0_.is_published AS is_published_5, p0_.update_date AS update_date_6, p0_.meta_keywords AS meta_keywords_7, p0_.json_ld AS json_ld_8, p0_.id AS id_9, p0_.content AS content_10, p0_.og_image_id AS og_image_id_11, p0_.language_id AS language_id_12 FROM page p0_ WHERE p0_.slug = 'home';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 26)
7	App\Repository\PageRepository->findOneBySlug (line 39)
8	App\Controller\PageController->index (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.38 ms
(3.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3 FROM media t0 WHERE t0.id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.file AS file_3
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3 FROM media t0 WHERE t0.id = 26;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Media::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Media->__get (line 54)
8	App\Entity\Media->getFile (line 20)
9	App\Service\MediaService->getUrl (line 54)
10	App\Controller\PageController->index (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)

0.31 ms
(2.60%)

SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.page_id AS page_id_13 FROM article t0 WHERE t0.page_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.meta_description AS meta_description_2,
  t0.og_description AS og_description_3,
  t0.og_title AS og_title_4,
  t0.slug AS slug_5,
  t0.is_published AS is_published_6,
  t0.update_date AS update_date_7,
  t0.meta_keywords AS meta_keywords_8,
  t0.json_ld AS json_ld_9,
  t0.id AS id_10,
  t0.content AS content_11,
  t0.og_image_id AS og_image_id_12,
  t0.page_id AS page_id_13
FROM
  article t0
WHERE
  t0.page_id = ?

SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.page_id AS page_id_13 FROM article t0 WHERE t0.page_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 84)
8	__TwigTemplate_06ec06279a7bdf9a100c10a8546ff1ec->block_content (line 437)
9	Twig\Template->yieldBlock (line 234)
10	__TwigTemplate_b751fc3a2c853a1057a925e15c317848->doDisplay (line 393)
11	Twig\Template->yield (line 53)
12	__TwigTemplate_06ec06279a7bdf9a100c10a8546ff1ec->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 46)
21	App\Controller\PageController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.28 ms
(2.37%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM language t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM language t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Language::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Language->__get (line 49)
8	App\Entity\Language->getCode (line 1802)
9	Twig\Extension\CoreExtension::getAttribute (line 174)
10	__TwigTemplate_b751fc3a2c853a1057a925e15c317848->doDisplay (line 393)
11	Twig\Template->yield (line 53)
12	__TwigTemplate_06ec06279a7bdf9a100c10a8546ff1ec->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 46)
21	App\Controller\PageController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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.

Entities Mapping

Class	Mapping errors
App\Entity\Language	No errors.
App\Entity\AbstractSeoResource	No errors.
App\Entity\Page	No errors.
App\Entity\Menu	No errors.
App\Entity\Media	The target entity 'App\Entity\AbstractSeoResource' specified on App\Entity\Media#abstractSeoResources is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Article	No errors.

Symfony Profiler

GET https://preprod.button-hop.com/fr

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping