Symfony Profiler

Query Metrics

13 Database Queries

6 Different statements

12.84 ms Query time

1 Invalid entities

157 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.79 ms
(60.69%)

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_id AS original_id_2,
  t0.short_description AS short_description_3,
  t0.introduction AS introduction_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.language AS language_9,
  t0.original_language AS original_language_10,
  t0.position AS position_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.status AS status_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.modified_by_id AS modified_by_id_19
FROM
  frg_guidelines t0
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (8, 10, 11, 12, 13, 16, 17, 18, 19, 20, 21, 108, 110, 115, 120, 68, 73, 79);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2670)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2646)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 946)
7	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2670)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2646)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
11	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
12	Doctrine\ORM\AbstractQuery->execute (line 891)
13	Doctrine\ORM\AbstractQuery->getResult (line 689)
14	App\Repository\FrgGuidelinesRepository->guidelinesSubmenu (line 122)
15	App\Menu\Builder\MainMenuBuilder->addDynamicGuidelineItem (line 102)
16	App\Menu\Builder\MainMenuBuilder->buildMenu (line 54)
17	App\Menu\Builder\MainMenuBuilder->createMainMenu (line 40)
18	Knp\Menu\Provider\LazyProvider->get (line 41)
19	Knp\Menu\Provider\ChainProvider->get (line 29)
20	Knp\Menu\Twig\Helper->get (line 43)
21	Knp\Menu\Twig\Helper->castMenu (line 138)
22	Knp\Menu\Twig\Helper->render (line 71)
23	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
24	__TwigTemplate_9b3aa8b35ea797fab2695f8bc67a4037->doDisplay (line 116)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_4f55c57acefdb7fc1ac8f58435db675f->doDisplay (line 53)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
35	App\Controller\GuidelinesController->show (line 51)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 182)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 29)
41	require_once (line 5)

2.12 ms
(16.53%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?

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.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = 1;

#	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->toArray (line 157)
7	App\Menu\Builder\MainMenuBuilder->addMenuItem (line 85)
8	App\Menu\Builder\MainMenuBuilder->buildMenu (line 56)
9	App\Menu\Builder\MainMenuBuilder->createMainMenu (line 40)
10	Knp\Menu\Provider\LazyProvider->get (line 41)
11	Knp\Menu\Provider\ChainProvider->get (line 29)
12	Knp\Menu\Twig\Helper->get (line 43)
13	Knp\Menu\Twig\Helper->castMenu (line 138)
14	Knp\Menu\Twig\Helper->render (line 71)
15	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
16	__TwigTemplate_9b3aa8b35ea797fab2695f8bc67a4037->doDisplay (line 116)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_4f55c57acefdb7fc1ac8f58435db675f->doDisplay (line 53)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
27	App\Controller\GuidelinesController->show (line 51)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

0.87 ms
(6.75%)

SELECT f0_.id AS id_0, f0_.original_id AS original_id_1, f0_.short_description AS short_description_2, f0_.introduction AS introduction_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.title AS title_6, f0_.slug AS slug_7, f0_.language AS language_8, f0_.original_language AS original_language_9, f0_.position AS position_10, f0_.menu_level AS menu_level_11, f0_.menu_index AS menu_index_12, f0_.menu_active AS menu_active_13, f0_.status AS status_14, f0_.parent_id AS parent_id_15, f0_.image_id AS image_id_16, f0_.created_by_id AS created_by_id_17, f0_.modified_by_id AS modified_by_id_18 FROM frg_guidelines f0_ WHERE f0_.parent_id IS NULL AND f0_.status IN (?) ORDER BY f0_.menu_index ASC

Parameters:

[
  "PUBLISHED"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.original_id AS original_id_1,
  f0_.short_description AS short_description_2,
  f0_.introduction AS introduction_3,
  f0_.created_at AS created_at_4,
  f0_.updated_at AS updated_at_5,
  f0_.title AS title_6,
  f0_.slug AS slug_7,
  f0_.language AS language_8,
  f0_.original_language AS original_language_9,
  f0_.position AS position_10,
  f0_.menu_level AS menu_level_11,
  f0_.menu_index AS menu_index_12,
  f0_.menu_active AS menu_active_13,
  f0_.status AS status_14,
  f0_.parent_id AS parent_id_15,
  f0_.image_id AS image_id_16,
  f0_.created_by_id AS created_by_id_17,
  f0_.modified_by_id AS modified_by_id_18
FROM
  frg_guidelines f0_
WHERE
  f0_.parent_id IS NULL
  AND f0_.status IN (?)
ORDER BY
  f0_.menu_index ASC

SELECT f0_.id AS id_0, f0_.original_id AS original_id_1, f0_.short_description AS short_description_2, f0_.introduction AS introduction_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.title AS title_6, f0_.slug AS slug_7, f0_.language AS language_8, f0_.original_language AS original_language_9, f0_.position AS position_10, f0_.menu_level AS menu_level_11, f0_.menu_index AS menu_index_12, f0_.menu_active AS menu_active_13, f0_.status AS status_14, f0_.parent_id AS parent_id_15, f0_.image_id AS image_id_16, f0_.created_by_id AS created_by_id_17, f0_.modified_by_id AS modified_by_id_18 FROM frg_guidelines f0_ WHERE f0_.parent_id IS NULL AND f0_.status IN ('PUBLISHED') ORDER BY f0_.menu_index ASC;

#	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\FrgGuidelinesRepository->guidelinesSubmenu (line 122)
7	App\Menu\Builder\MainMenuBuilder->addDynamicGuidelineItem (line 102)
8	App\Menu\Builder\MainMenuBuilder->buildMenu (line 54)
9	App\Menu\Builder\MainMenuBuilder->createMainMenu (line 40)
10	Knp\Menu\Provider\LazyProvider->get (line 41)
11	Knp\Menu\Provider\ChainProvider->get (line 29)
12	Knp\Menu\Twig\Helper->get (line 43)
13	Knp\Menu\Twig\Helper->castMenu (line 138)
14	Knp\Menu\Twig\Helper->render (line 71)
15	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
16	__TwigTemplate_9b3aa8b35ea797fab2695f8bc67a4037->doDisplay (line 116)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_4f55c57acefdb7fc1ac8f58435db675f->doDisplay (line 53)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
27	App\Controller\GuidelinesController->show (line 51)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

0.84 ms
(6.54%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id IS NULL AND t0.menu_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.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.menu_active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id IS NULL AND t0.menu_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	App\Menu\Builder\MainMenuBuilder->buildMenu (line 50)
4	App\Menu\Builder\MainMenuBuilder->createMainMenu (line 40)
5	Knp\Menu\Provider\LazyProvider->get (line 41)
6	Knp\Menu\Provider\ChainProvider->get (line 29)
7	Knp\Menu\Twig\Helper->get (line 43)
8	Knp\Menu\Twig\Helper->castMenu (line 138)
9	Knp\Menu\Twig\Helper->render (line 71)
10	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
11	__TwigTemplate_9b3aa8b35ea797fab2695f8bc67a4037->doDisplay (line 116)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_4f55c57acefdb7fc1ac8f58435db675f->doDisplay (line 53)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\GuidelinesController->show (line 51)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.75 ms
(5.87%)

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_id AS original_id_2,
  t0.short_description AS short_description_3,
  t0.introduction AS introduction_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.language AS language_9,
  t0.original_language AS original_language_10,
  t0.position AS position_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.status AS status_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.modified_by_id AS modified_by_id_19
FROM
  frg_guidelines t0
WHERE
  t0.parent_id IN (?, ?, ?)

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (7, 66, 67);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2670)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2646)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
7	Doctrine\ORM\AbstractQuery->execute (line 891)
8	Doctrine\ORM\AbstractQuery->getResult (line 689)
9	App\Repository\FrgGuidelinesRepository->guidelinesSubmenu (line 122)
10	App\Menu\Builder\MainMenuBuilder->addDynamicGuidelineItem (line 102)
11	App\Menu\Builder\MainMenuBuilder->buildMenu (line 54)
12	App\Menu\Builder\MainMenuBuilder->createMainMenu (line 40)
13	Knp\Menu\Provider\LazyProvider->get (line 41)
14	Knp\Menu\Provider\ChainProvider->get (line 29)
15	Knp\Menu\Twig\Helper->get (line 43)
16	Knp\Menu\Twig\Helper->castMenu (line 138)
17	Knp\Menu\Twig\Helper->render (line 71)
18	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
19	__TwigTemplate_9b3aa8b35ea797fab2695f8bc67a4037->doDisplay (line 116)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_4f55c57acefdb7fc1ac8f58435db675f->doDisplay (line 53)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
30	App\Controller\GuidelinesController->show (line 51)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 182)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

0.46 ms
(3.62%)

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_id AS original_id_2,
  t0.short_description AS short_description_3,
  t0.introduction AS introduction_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.language AS language_9,
  t0.original_language AS original_language_10,
  t0.position AS position_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.status AS status_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.modified_by_id AS modified_by_id_19
FROM
  frg_guidelines t0
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (9, 14, 15, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 50, 51, 52, 53, 54, 55, 48, 49, 44, 45, 46, 47, 37, 38, 39, 40, 41, 42, 43, 123, 124, 35, 36, 26, 27, 28, 29, 30, 31, 32, 33, 34, 22, 23, 24, 25, 121, 122, 69, 70, 71, 72, 74, 75, 76, 77, 78, 80, 81, 82, 109, 111, 112, 113, 114, 116, 117, 118, 119);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2670)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2646)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 946)
7	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2670)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2646)
9	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 946)
12	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2670)
13	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2646)
14	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
15	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
16	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
17	Doctrine\ORM\AbstractQuery->execute (line 891)
18	Doctrine\ORM\AbstractQuery->getResult (line 689)
19	App\Repository\FrgGuidelinesRepository->guidelinesSubmenu (line 122)
20	App\Menu\Builder\MainMenuBuilder->addDynamicGuidelineItem (line 102)
21	App\Menu\Builder\MainMenuBuilder->buildMenu (line 54)
22	App\Menu\Builder\MainMenuBuilder->createMainMenu (line 40)
23	Knp\Menu\Provider\LazyProvider->get (line 41)
24	Knp\Menu\Provider\ChainProvider->get (line 29)
25	Knp\Menu\Twig\Helper->get (line 43)
26	Knp\Menu\Twig\Helper->castMenu (line 138)
27	Knp\Menu\Twig\Helper->render (line 71)
28	Knp\Menu\Twig\MenuRuntimeExtension->render (line 45)
29	__TwigTemplate_9b3aa8b35ea797fab2695f8bc67a4037->doDisplay (line 116)
30	Twig\Template->yield (line 402)
31	__TwigTemplate_4f55c57acefdb7fc1ac8f58435db675f->doDisplay (line 53)
32	Twig\Template->yield (line 402)
33	Twig\Template->display (line 358)
34	Twig\Template->render (line 373)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
40	App\Controller\GuidelinesController->show (line 51)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 182)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
45	require_once (line 29)
46	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\FrgGuidelines	93
App\Entity\FrgImage	43
App\Entity\FrgUser	12
App\Entity\FrgMenu	9

Entities Mapping

Class	Mapping errors
App\Entity\FrgMenu	No errors.
App\Entity\FrgUser	No errors.
App\Entity\FrgGuidelines	No errors.
App\Entity\FrgImage	No errors.
App\Entity\FrgResource	If association App\Entity\FrgResource#positiveImpact is many-to-many, then the inversed side App\Entity\FrgResourceTaxonomies#positiveImpactResources has to be many-to-many as well. If association App\Entity\FrgResource#negativeImpact is many-to-many, then the inversed side App\Entity\FrgResourceTaxonomies#negativeImpactResources has to be many-to-many as well.

Symfony Profiler

GET https://forestknowledge.eu/guidelines

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping