Symfony Profiler

Query Metrics

26 Database Queries

13 Different statements

11.24 ms Query time

1 Invalid entities

182 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.01 ms
(17.92%)

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_1b47d879083c5e9ceeb0e6db929be6b3->doDisplay (line 54)
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\UserjourneyController->show (line 102)
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)

1.55 ms
(13.78%)

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_1b47d879083c5e9ceeb0e6db929be6b3->doDisplay (line 54)
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\UserjourneyController->show (line 102)
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)

1.00 ms
(8.88%)

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.filename AS filename_3, t0.title AS title_4, t0.description AS description_5, t0.main_image AS main_image_6, t0.target_resource AS target_resource_7, t0.has_variants AS has_variants_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.frg_resource_id AS frg_resource_id_11, t0.created_by_id AS created_by_id_12, t0.modified_by_id AS modified_by_id_13 FROM frg_image t0 WHERE t0.id = ?

Parameters:

[
  283
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.filename AS filename_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.main_image AS main_image_6,
  t0.target_resource AS target_resource_7,
  t0.has_variants AS has_variants_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.frg_resource_id AS frg_resource_id_11,
  t0.created_by_id AS created_by_id_12,
  t0.modified_by_id AS modified_by_id_13
FROM
  frg_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.filename AS filename_3, t0.title AS title_4, t0.description AS description_5, t0.main_image AS main_image_6, t0.target_resource AS target_resource_7, t0.has_variants AS has_variants_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.frg_resource_id AS frg_resource_id_11, t0.created_by_id AS created_by_id_12, t0.modified_by_id AS modified_by_id_13 FROM frg_image t0 WHERE t0.id = 283;

#	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\FrgImage::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\FrgImage->__get (line 153)
7	App\Entity\FrgImage->getFilename (line 103)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_1b47d879083c5e9ceeb0e6db929be6b3::block_body (line 131)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9b3aa8b35ea797fab2695f8bc67a4037->doDisplay (line 141)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_1b47d879083c5e9ceeb0e6db929be6b3->doDisplay (line 54)
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\UserjourneyController->show (line 102)
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.97 ms
(8.67%)

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney 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.description AS description_4,
  t0.quotation AS quotation_5,
  t0.introduction AS introduction_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.title AS title_9,
  t0.slug AS slug_10,
  t0.language AS language_11,
  t0.original_language AS original_language_12,
  t0.position AS position_13,
  t0.menu_level AS menu_level_14,
  t0.menu_index AS menu_index_15,
  t0.menu_active AS menu_active_16,
  t0.status AS status_17,
  t0.parent_id AS parent_id_18,
  t0.image_id AS image_id_19,
  t0.created_by_id AS created_by_id_20,
  t0.modified_by_id AS modified_by_id_21
FROM
  frg_userjourney 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.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney t0 WHERE t0.parent_id IN (14, 15, 17, 126);

#	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->load (line 748)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
13	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
14	Proxies\__CG__\App\Entity\FrgUserjourney::Doctrine\ORM\Proxy\{closure} (line 367)
15	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
16	Proxies\__CG__\App\Entity\FrgUserjourney->__get (line 153)
17	App\Entity\FrgUserjourney->getParent (line 106)
18	App\Controller\UserjourneyController->show (line 74)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.94 ms
(8.37%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.entity_id AS entity_id_5, t0.entity_class AS entity_class_6 FROM frg_slug_record t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "4-monitoring-reporting-and-verification"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.entity_id AS entity_id_5,
  t0.entity_class AS entity_class_6
FROM
  frg_slug_record t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.entity_id AS entity_id_5, t0.entity_class AS entity_class_6 FROM frg_slug_record t0 WHERE t0.slug = '4-monitoring-reporting-and-verification' 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\UserjourneyController->show (line 55)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.79 ms
(7.04%)

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney t0 WHERE t0.parent_id IN (?)

Parameters:

[
  16
]

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.description AS description_4,
  t0.quotation AS quotation_5,
  t0.introduction AS introduction_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.title AS title_9,
  t0.slug AS slug_10,
  t0.language AS language_11,
  t0.original_language AS original_language_12,
  t0.position AS position_13,
  t0.menu_level AS menu_level_14,
  t0.menu_index AS menu_index_15,
  t0.menu_active AS menu_active_16,
  t0.status AS status_17,
  t0.parent_id AS parent_id_18,
  t0.image_id AS image_id_19,
  t0.created_by_id AS created_by_id_20,
  t0.modified_by_id AS modified_by_id_21
FROM
  frg_userjourney 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.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney t0 WHERE t0.parent_id IN (16);

#	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->load (line 748)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
8	Doctrine\ORM\EntityManager->find (line 366)
9	Doctrine\ORM\EntityRepository->find (line 86)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
11	App\Controller\UserjourneyController->show (line 61)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.69 ms
(6.17%)

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney t0 WHERE t0.id = ?

Parameters:

[
  16
]

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.description AS description_4,
  t0.quotation AS quotation_5,
  t0.introduction AS introduction_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.title AS title_9,
  t0.slug AS slug_10,
  t0.language AS language_11,
  t0.original_language AS original_language_12,
  t0.position AS position_13,
  t0.menu_level AS menu_level_14,
  t0.menu_index AS menu_index_15,
  t0.menu_active AS menu_active_16,
  t0.status AS status_17,
  t0.parent_id AS parent_id_18,
  t0.image_id AS image_id_19,
  t0.created_by_id AS created_by_id_20,
  t0.modified_by_id AS modified_by_id_21
FROM
  frg_userjourney t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney t0 WHERE t0.id = 16;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\UserjourneyController->show (line 61)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.68 ms
(6.03%)

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.quotation AS quotation_2, f0_.created_at AS created_at_3, f0_.updated_at AS updated_at_4, f0_.image_id AS image_id_5, f0_.frg_userjourney_id AS frg_userjourney_id_6, f0_.created_by_id AS created_by_id_7, f0_.modified_by_id AS modified_by_id_8 FROM frg_testimonial f0_ WHERE f0_.frg_userjourney_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.quotation AS quotation_2,
  f0_.created_at AS created_at_3,
  f0_.updated_at AS updated_at_4,
  f0_.image_id AS image_id_5,
  f0_.frg_userjourney_id AS frg_userjourney_id_6,
  f0_.created_by_id AS created_by_id_7,
  f0_.modified_by_id AS modified_by_id_8
FROM
  frg_testimonial f0_
WHERE
  f0_.frg_userjourney_id = ?

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.quotation AS quotation_2, f0_.created_at AS created_at_3, f0_.updated_at AS updated_at_4, f0_.image_id AS image_id_5, f0_.frg_userjourney_id AS frg_userjourney_id_6, f0_.created_by_id AS created_by_id_7, f0_.modified_by_id AS modified_by_id_8 FROM frg_testimonial f0_ WHERE f0_.frg_userjourney_id = 2;

#	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\FrgTestimonialRepository->findByUserjourneyId (line 50)
7	App\Controller\UserjourneyController->show (line 97)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.63 ms
(5.64%)

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_1b47d879083c5e9ceeb0e6db929be6b3->doDisplay (line 54)
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\UserjourneyController->show (line 102)
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)

0.53 ms
(4.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_1b47d879083c5e9ceeb0e6db929be6b3->doDisplay (line 54)
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\UserjourneyController->show (line 102)
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.49 ms
(4.39%)

SELECT f0_.id AS id_0, f0_.slug AS slug_1, f0_.title AS title_2, f0_.menu_index AS menu_index_3, f0_.menu_level AS menu_level_4 FROM frg_userjourney f0_ WHERE f0_.menu_index LIKE ? AND f0_.status = ? ORDER BY f0_.menu_index ASC

Parameters:

[
  "04_%"
  "PUBLISHED"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.slug AS slug_1,
  f0_.title AS title_2,
  f0_.menu_index AS menu_index_3,
  f0_.menu_level AS menu_level_4
FROM
  frg_userjourney f0_
WHERE
  f0_.menu_index LIKE ?
  AND f0_.status = ?
ORDER BY
  f0_.menu_index ASC

SELECT f0_.id AS id_0, f0_.slug AS slug_1, f0_.title AS title_2, f0_.menu_index AS menu_index_3, f0_.menu_level AS menu_level_4 FROM frg_userjourney f0_ WHERE f0_.menu_index LIKE '04_%' AND f0_.status = '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\FrgUserjourneyRepository->getPublishedChildrenByPrefix (line 131)
7	App\Controller\UserjourneyController->show (line 93)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.47 ms
(4.20%)

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_1b47d879083c5e9ceeb0e6db929be6b3->doDisplay (line 54)
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\UserjourneyController->show (line 102)
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.47 ms
(4.17%)

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_1b47d879083c5e9ceeb0e6db929be6b3->doDisplay (line 54)
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\UserjourneyController->show (line 102)
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)

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	54
App\Entity\FrgUser	13
App\Entity\FrgUserjourney	10
App\Entity\FrgMenu	9
App\Entity\FrgTestimonial	2
App\Entity\FrgSlugRecord	1

Entities Mapping

Class	Mapping errors
App\Entity\FrgSlugRecord	No errors.
App\Entity\FrgUserjourney	No errors.
App\Entity\FrgImage	No errors.
App\Entity\FrgUser	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.
App\Entity\FrgTestimonial	No errors.
App\Entity\FrgMenu	No errors.
App\Entity\FrgGuidelines	No errors.
App\Entity\FrgPage	No errors.

Symfony Profiler

GET https://forestknowledge.eu/userjourney/4-monitoring-reporting-and-verification

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping