Symfony Profiler

Query Metrics

15 Database Queries

5 Different statements

17.38 ms Query time

0 Invalid entities

33 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.85 ms
(68.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.content AS content_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_content_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  54
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.content AS content_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  page_content_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.content AS content_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_content_translation t0 WHERE t0.translatable_id = 54;

#	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 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 120)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\PageContent->findTranslationByLocale (line 138)
10	App\Entity\PageContent->doTranslate (line 75)
11	App\Entity\PageContent->translate (line 52)
12	App\Entity\PageContent->__call (line 1882)
13	Twig\Extension\CoreExtension::getAttribute (line 68)
14	__TwigTemplate_16948de2bafb53fea60b9595a54fb9a1->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 123)
23	App\Controller\PageContentController->partialCategoryAction (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
27	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
28	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
29	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
30	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 129)
31	__TwigTemplate_f938cca6904130455966ff9d716e87e4->block_main (line 432)
32	Twig\Template->yieldBlock (line 306)
33	__TwigTemplate_694646425ea428b0526066193de59e9f->block_body (line 432)
34	Twig\Template->yieldBlock (line 90)
35	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
36	Twig\Template->yield (line 55)
37	__TwigTemplate_f938cca6904130455966ff9d716e87e4->doDisplay (line 388)
38	Twig\Template->yield (line 344)
39	Twig\Template->display (line 359)
40	Twig\Template->render (line 51)
41	Twig\TemplateWrapper->render (line 334)
42	Twig\Environment->render (line 448)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 101)
46	App\Controller\PageContentController->categoryAction (line 181)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 11)

2.81 ms
(16.15%)

SELECT t0.code AS code_1, t0.order_ihm AS order_ihm_2, t0.id AS id_3 FROM page_category t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "faq"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.order_ihm AS order_ihm_2,
  t0.id AS id_3
FROM
  page_category t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.order_ihm AS order_ihm_2, t0.id AS id_3 FROM page_category t0 WHERE t0.code = 'faq' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 99)
4	App\Controller\PageContentController->categoryAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 11)

1.02 ms
(5.88%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.order_ihm AS order_ihm_4, t0.category_id AS category_id_5 FROM page_content t0 WHERE t0.category_id = ? ORDER BY t0.order_ihm ASC, t0.id DESC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.order_ihm AS order_ihm_4,
  t0.category_id AS category_id_5
FROM
  page_content t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.order_ihm ASC,
  t0.id DESC

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.order_ihm AS order_ihm_4, t0.category_id AS category_id_5 FROM page_content t0 WHERE t0.category_id = 2 ORDER BY t0.order_ihm ASC, t0.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 154)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 121)
7	App\Controller\PageContentController->partialCategoryAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 129)
15	__TwigTemplate_f938cca6904130455966ff9d716e87e4->block_main (line 432)
16	Twig\Template->yieldBlock (line 306)
17	__TwigTemplate_694646425ea428b0526066193de59e9f->block_body (line 432)
18	Twig\Template->yieldBlock (line 90)
19	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_f938cca6904130455966ff9d716e87e4->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 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 101)
30	App\Controller\PageContentController->categoryAction (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 11)

0.91 ms
(5.21%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM page_category_translation t0 WHERE t0.translatable_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.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  page_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM page_category_translation t0 WHERE t0.translatable_id = 2;

#	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 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 120)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\PageCategory->findTranslationByLocale (line 138)
10	App\Entity\PageCategory->doTranslate (line 75)
11	App\Entity\PageCategory->translate (line 40)
12	App\Entity\PageCategory->__call (line 1882)
13	Twig\Extension\CoreExtension::getAttribute (line 102)
14	__TwigTemplate_f938cca6904130455966ff9d716e87e4->block_title (line 432)
15	Twig\Template->yieldBlock (line 67)
16	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_f938cca6904130455966ff9d716e87e4->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 101)
27	App\Controller\PageContentController->categoryAction (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 11)

0.79 ms
(4.56%)

SELECT MAX(p0_.updated) AS sclr_0 FROM page_content p0_ WHERE p0_.category_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(p0_.updated) AS sclr_0
FROM
  page_content p0_
WHERE
  p0_.category_id = ?

SELECT MAX(p0_.updated) AS sclr_0 FROM page_content p0_ WHERE p0_.category_id = 2;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 34)
8	App\Repository\PageContentRepository->getLastUpdated (line 110)
9	App\Controller\PageContentController->partialCategoryAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 129)
17	__TwigTemplate_f938cca6904130455966ff9d716e87e4->block_main (line 432)
18	Twig\Template->yieldBlock (line 306)
19	__TwigTemplate_694646425ea428b0526066193de59e9f->block_body (line 432)
20	Twig\Template->yieldBlock (line 90)
21	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_f938cca6904130455966ff9d716e87e4->doDisplay (line 388)
24	Twig\Template->yield (line 344)
25	Twig\Template->display (line 359)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 334)
28	Twig\Environment->render (line 448)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 101)
32	App\Controller\PageContentController->categoryAction (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 11)

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\PageContentTranslation	20
App\Entity\PageContent	10
App\Entity\PageCategoryTranslation	2
App\Entity\PageCategory	1

Entities Mapping

Class	Mapping errors
App\Entity\PageCategory	No errors.
App\Entity\PageCategoryTranslation	No errors.
App\Entity\PageContent	No errors.
App\Entity\PageContentTranslation	No errors.

Symfony Profiler

GET http://periscolaire.apeeel1.lu/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DApp%255CController%255CPageContentController%253A%253ApartialCatego…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping