Symfony Profiler

Query Metrics

55 Database Queries

14 Different statements

23.77 ms Query time

0 Invalid entities

62 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

8.76 ms
(36.85%)

SELECT p0_.id AS id_0, p0_.class_id AS class_id_1, p0_.class_name AS class_name_2, p0_.published AS published_3, p0_.publish_date_time AS publish_date_time_4, p0_.published_at AS published_at_5, p0_.created_at AS created_at_6, p0_.created_by AS created_by_7, p0_.created_from AS created_from_8, p0_.updated_at AS updated_at_9, p0_.updated_by AS updated_by_10, p0_.updated_from AS updated_from_11, p0_.deleted_by AS deleted_by_12, p0_.deleted_from AS deleted_from_13, p0_.deleted_at AS deleted_at_14 FROM publish_schedule p0_ WHERE (p0_.class_name = ? AND p0_.class_id = ? AND p0_.published = 0 AND p0_.publish_date_time >= CURRENT_TIMESTAMP) AND (p0_.deleted_at IS NULL)

Parameters:

[
  "App\Entity\Page"
  5728
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.class_id AS class_id_1,
  p0_.class_name AS class_name_2,
  p0_.published AS published_3,
  p0_.publish_date_time AS publish_date_time_4,
  p0_.published_at AS published_at_5,
  p0_.created_at AS created_at_6,
  p0_.created_by AS created_by_7,
  p0_.created_from AS created_from_8,
  p0_.updated_at AS updated_at_9,
  p0_.updated_by AS updated_by_10,
  p0_.updated_from AS updated_from_11,
  p0_.deleted_by AS deleted_by_12,
  p0_.deleted_from AS deleted_from_13,
  p0_.deleted_at AS deleted_at_14
FROM
  publish_schedule p0_
WHERE
  (
    p0_.class_name = ?
    AND p0_.class_id = ?
    AND p0_.published = 0
    AND p0_.publish_date_time >= CURRENT_TIMESTAMP
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.id AS id_0, p0_.class_id AS class_id_1, p0_.class_name AS class_name_2, p0_.published AS published_3, p0_.publish_date_time AS publish_date_time_4, p0_.published_at AS published_at_5, p0_.created_at AS created_at_6, p0_.created_by AS created_by_7, p0_.created_from AS created_from_8, p0_.updated_at AS updated_at_9, p0_.updated_by AS updated_by_10, p0_.updated_from AS updated_from_11, p0_.deleted_by AS deleted_by_12, p0_.deleted_from AS deleted_from_13, p0_.deleted_at AS deleted_at_14 FROM publish_schedule p0_ WHERE (p0_.class_name = 'App\\Entity\\Page' AND p0_.class_id = 5728 AND p0_.published = 0 AND p0_.publish_date_time >= CURRENT_TIMESTAMP) AND (p0_.deleted_at IS NULL);

#	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->getOneOrNullResult (line 738)
6	App\Repository\PublishScheduleRepository->findForEntity (line 42)
7	App\EventListener\Entity\PublishScheduleListener->postLoad (line 29)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3203)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
15	Doctrine\ORM\AbstractQuery->execute (line 891)
16	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
17	App\Repository\PageRepository->getBasePage (line 40)
18	App\Service\Manager\PageManager->getPageFromSlug (line 124)
19	App\Controller\FrontendController->index (line 226)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

4.71 ms
(19.81%)

SELECT t0.id AS id_1, t0.template AS template_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.access_level AS access_level_7, t0.enabled AS enabled_8, t0.name AS name_9, t0.slug AS slug_10, t0.in_sitemap AS in_sitemap_11, t0.in_menu AS in_menu_12, t0.published_template AS published_template_13, t0.published_data AS published_data_14, t0.published AS published_15, t0.published_at AS published_at_16, t0.data AS data_17, t0.created_at AS created_at_18, t0.created_by AS created_by_19, t0.created_from AS created_from_20, t0.updated_at AS updated_at_21, t0.updated_by AS updated_by_22, t0.updated_from AS updated_from_23, t0.deleted_by AS deleted_by_24, t0.deleted_from AS deleted_from_25, t0.deleted_at AS deleted_at_26, t0.parent_id AS parent_id_27, t0.canonical_page_id AS canonical_page_id_28 FROM page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  "4746"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.template AS template_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.keywords AS keywords_5,
  t0.position AS position_6,
  t0.access_level AS access_level_7,
  t0.enabled AS enabled_8,
  t0.name AS name_9,
  t0.slug AS slug_10,
  t0.in_sitemap AS in_sitemap_11,
  t0.in_menu AS in_menu_12,
  t0.published_template AS published_template_13,
  t0.published_data AS published_data_14,
  t0.published AS published_15,
  t0.published_at AS published_at_16,
  t0.data AS data_17,
  t0.created_at AS created_at_18,
  t0.created_by AS created_by_19,
  t0.created_from AS created_from_20,
  t0.updated_at AS updated_at_21,
  t0.updated_by AS updated_by_22,
  t0.updated_from AS updated_from_23,
  t0.deleted_by AS deleted_by_24,
  t0.deleted_from AS deleted_from_25,
  t0.deleted_at AS deleted_at_26,
  t0.parent_id AS parent_id_27,
  t0.canonical_page_id AS canonical_page_id_28
FROM
  page t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.template AS template_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.access_level AS access_level_7, t0.enabled AS enabled_8, t0.name AS name_9, t0.slug AS slug_10, t0.in_sitemap AS in_sitemap_11, t0.in_menu AS in_menu_12, t0.published_template AS published_template_13, t0.published_data AS published_data_14, t0.published AS published_15, t0.published_at AS published_at_16, t0.data AS data_17, t0.created_at AS created_at_18, t0.created_by AS created_by_19, t0.created_from AS created_from_20, t0.updated_at AS updated_at_21, t0.updated_by AS updated_by_22, t0.updated_from AS updated_from_23, t0.deleted_by AS deleted_by_24, t0.deleted_from AS deleted_from_25, t0.deleted_at AS deleted_at_26, t0.parent_id AS parent_id_27, t0.canonical_page_id AS canonical_page_id_28 FROM page t0 WHERE t0.id = '4746' AND ((t0.deleted_at IS NULL));

#	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\Service\Manager\AbstractManager->get (line 82)
7	App\Twig\Components\Render\ButtonRender->resolveInternalUrl (line 63)
8	App\Twig\Components\Render\ButtonRender->getHref (line 39)
9	App\Twig\Components\Render\ButtonRender->render (line 30)
10	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 90)
11	iterator_to_array (line 50)
12	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
13	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
17	__TwigTemplate_e5c117e37cb613d5ccbb2b63a61a54e1->doDisplay (line 51)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
24	__TwigTemplate_0d079a0609d8a56cce6e56f53824139e->doDisplay (line 87)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->doDisplay (line 160)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_987582c0cb028068551f42a23858d227->doDisplay (line 55)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	App\Service\Manager\PageManager->viewPublished (line 24)
34	App\Controller\FrontendController->loadPage (line 285)
35	App\Controller\FrontendController->index (line 231)
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.53 ms
(10.65%)

SELECT t0.id AS id_1, t0.class_name AS class_name_2, t0.class_id AS class_id_3, t0.name AS name_4, t0.template AS template_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.published_template AS published_template_8, t0.published_data AS published_data_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.data AS data_12, t0.created_at AS created_at_13, t0.created_by AS created_by_14, t0.created_from AS created_from_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.updated_from AS updated_from_18, t0.deleted_by AS deleted_by_19, t0.deleted_from AS deleted_from_20, t0.deleted_at AS deleted_at_21, t0.global_id AS global_id_22, t0.parent_id AS parent_id_23 FROM data_block t0 WHERE t0.class_name = ? AND t0.class_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC

Parameters:

[
  "App\Entity\Page"
  5728
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.class_name AS class_name_2,
  t0.class_id AS class_id_3,
  t0.name AS name_4,
  t0.template AS template_5,
  t0.enabled AS enabled_6,
  t0.position AS position_7,
  t0.published_template AS published_template_8,
  t0.published_data AS published_data_9,
  t0.published AS published_10,
  t0.published_at AS published_at_11,
  t0.data AS data_12,
  t0.created_at AS created_at_13,
  t0.created_by AS created_by_14,
  t0.created_from AS created_from_15,
  t0.updated_at AS updated_at_16,
  t0.updated_by AS updated_by_17,
  t0.updated_from AS updated_from_18,
  t0.deleted_by AS deleted_by_19,
  t0.deleted_from AS deleted_from_20,
  t0.deleted_at AS deleted_at_21,
  t0.global_id AS global_id_22,
  t0.parent_id AS parent_id_23
FROM
  data_block t0
WHERE
  t0.class_name = ?
  AND t0.class_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.class_name AS class_name_2, t0.class_id AS class_id_3, t0.name AS name_4, t0.template AS template_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.published_template AS published_template_8, t0.published_data AS published_data_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.data AS data_12, t0.created_at AS created_at_13, t0.created_by AS created_by_14, t0.created_from AS created_from_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.updated_from AS updated_from_18, t0.deleted_by AS deleted_by_19, t0.deleted_from AS deleted_from_20, t0.deleted_at AS deleted_at_21, t0.global_id AS global_id_22, t0.parent_id AS parent_id_23 FROM data_block t0 WHERE t0.class_name = 'App\\Entity\\Page' AND t0.class_id = 5728 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\Manager\DataBlockManager->getBlocks (line 65)
5	App\Twig\Components\Render\DatablockRender->datablocks (line 49)
6	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 90)
7	iterator_to_array (line 50)
8	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
9	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
10	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
12	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
13	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->block_body (line 305)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->doDisplay (line 165)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_987582c0cb028068551f42a23858d227->doDisplay (line 55)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	App\Service\Manager\PageManager->viewPublished (line 24)
23	App\Controller\FrontendController->loadPage (line 285)
24	App\Controller\FrontendController->index (line 231)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.61 ms
(6.76%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.data AS data_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.created_from AS created_from_9, t0.updated_at AS updated_at_10, t0.updated_by AS updated_by_11, t0.updated_from AS updated_from_12, t0.deleted_by AS deleted_by_13, t0.deleted_from AS deleted_from_14, t0.deleted_at AS deleted_at_15, t0.menu_id AS menu_id_16, t0.parent_id AS parent_id_17 FROM menu_item t0 WHERE t0.parent_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC

Parameters:

[
  3352
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.enabled AS enabled_4,
  t0.position AS position_5,
  t0.data AS data_6,
  t0.created_at AS created_at_7,
  t0.created_by AS created_by_8,
  t0.created_from AS created_from_9,
  t0.updated_at AS updated_at_10,
  t0.updated_by AS updated_by_11,
  t0.updated_from AS updated_from_12,
  t0.deleted_by AS deleted_by_13,
  t0.deleted_from AS deleted_from_14,
  t0.deleted_at AS deleted_at_15,
  t0.menu_id AS menu_id_16,
  t0.parent_id AS parent_id_17
FROM
  menu_item t0
WHERE
  t0.parent_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.data AS data_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.created_from AS created_from_9, t0.updated_at AS updated_at_10, t0.updated_by AS updated_by_11, t0.updated_from AS updated_from_12, t0.deleted_by AS deleted_by_13, t0.deleted_from AS deleted_from_14, t0.deleted_at AS deleted_at_15, t0.menu_id AS menu_id_16, t0.parent_id AS parent_id_17 FROM menu_item t0 WHERE t0.parent_id = 3352 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

#	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->filter (line 237)
7	App\Entity\MenuItem->hasMenuItems (line 154)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_0d079a0609d8a56cce6e56f53824139e::doDisplay (line 67)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->doDisplay (line 160)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_987582c0cb028068551f42a23858d227->doDisplay (line 55)
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	App\Service\Manager\PageManager->viewPublished (line 24)
19	App\Controller\FrontendController->loadPage (line 285)
20	App\Controller\FrontendController->index (line 231)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

1.21 ms
(5.10%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.type AS type_2, m0_.enabled AS enabled_3, m0_.position AS position_4, m0_.data AS data_5, m0_.created_at AS created_at_6, m0_.created_by AS created_by_7, m0_.created_from AS created_from_8, m0_.updated_at AS updated_at_9, m0_.updated_by AS updated_by_10, m0_.updated_from AS updated_from_11, m0_.deleted_by AS deleted_by_12, m0_.deleted_from AS deleted_from_13, m0_.deleted_at AS deleted_at_14, m0_.menu_id AS menu_id_15, m0_.parent_id AS parent_id_16 FROM menu_item m0_ WHERE (m0_.parent_id IS NULL AND m0_.enabled = ? AND m0_.menu_id = ?) AND (m0_.deleted_at IS NULL) ORDER BY m0_.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.type AS type_2,
  m0_.enabled AS enabled_3,
  m0_.position AS position_4,
  m0_.data AS data_5,
  m0_.created_at AS created_at_6,
  m0_.created_by AS created_by_7,
  m0_.created_from AS created_from_8,
  m0_.updated_at AS updated_at_9,
  m0_.updated_by AS updated_by_10,
  m0_.updated_from AS updated_from_11,
  m0_.deleted_by AS deleted_by_12,
  m0_.deleted_from AS deleted_from_13,
  m0_.deleted_at AS deleted_at_14,
  m0_.menu_id AS menu_id_15,
  m0_.parent_id AS parent_id_16
FROM
  menu_item m0_
WHERE
  (
    m0_.parent_id IS NULL
    AND m0_.enabled = ?
    AND m0_.menu_id = ?
  )
  AND (m0_.deleted_at IS NULL)
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.type AS type_2, m0_.enabled AS enabled_3, m0_.position AS position_4, m0_.data AS data_5, m0_.created_at AS created_at_6, m0_.created_by AS created_by_7, m0_.created_from AS created_from_8, m0_.updated_at AS updated_at_9, m0_.updated_by AS updated_by_10, m0_.updated_from AS updated_from_11, m0_.deleted_by AS deleted_by_12, m0_.deleted_from AS deleted_from_13, m0_.deleted_at AS deleted_at_14, m0_.menu_id AS menu_id_15, m0_.parent_id AS parent_id_16 FROM menu_item m0_ WHERE (m0_.parent_id IS NULL AND m0_.enabled = 1 AND m0_.menu_id = 76) AND (m0_.deleted_at IS NULL) ORDER BY m0_.position 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\MenuItemRepository->getTopLevelEnabledItems (line 40)
7	App\Service\Manager\MenuManager->getMenu (line 47)
8	App\Controller\FrontendController->loadPage (line 274)
9	App\Controller\FrontendController->index (line 231)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.85 ms
(3.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.css_classes AS css_classes_3, t0.max_depth AS max_depth_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.created_from AS created_from_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.updated_from AS updated_from_11, t0.deleted_by AS deleted_by_12, t0.deleted_from AS deleted_from_13, t0.deleted_at AS deleted_at_14 FROM menu t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  76
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.css_classes AS css_classes_3,
  t0.max_depth AS max_depth_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.created_by AS created_by_7,
  t0.created_from AS created_from_8,
  t0.updated_at AS updated_at_9,
  t0.updated_by AS updated_by_10,
  t0.updated_from AS updated_from_11,
  t0.deleted_by AS deleted_by_12,
  t0.deleted_from AS deleted_from_13,
  t0.deleted_at AS deleted_at_14
FROM
  menu t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.css_classes AS css_classes_3, t0.max_depth AS max_depth_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.created_from AS created_from_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.updated_from AS updated_from_11, t0.deleted_by AS deleted_by_12, t0.deleted_from AS deleted_from_13, t0.deleted_at AS deleted_at_14 FROM menu t0 WHERE t0.id = 76 AND ((t0.deleted_at IS NULL));

#	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\Service\Manager\MenuManager->getMenu (line 44)
7	App\Controller\FrontendController->loadPage (line 274)
8	App\Controller\FrontendController->index (line 231)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.77 ms
(3.22%)

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.source_url AS source_url_2, r0_.redirect_url AS redirect_url_3, r0_.enabled AS enabled_4, r0_.used_count AS used_count_5, r0_.last_used AS last_used_6, r0_.created_at AS created_at_7, r0_.created_by AS created_by_8, r0_.created_from AS created_from_9, r0_.updated_at AS updated_at_10, r0_.updated_by AS updated_by_11, r0_.updated_from AS updated_from_12, r0_.deleted_by AS deleted_by_13, r0_.deleted_from AS deleted_from_14, r0_.deleted_at AS deleted_at_15, r0_.redirect_page_id AS redirect_page_id_16 FROM redirect r0_ WHERE (r0_.source_url = ? AND r0_.enabled = ?) AND (r0_.deleted_at IS NULL) ORDER BY r0_.updated_at DESC LIMIT 1

Parameters:

[
  "/faqs"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.source_url AS source_url_2,
  r0_.redirect_url AS redirect_url_3,
  r0_.enabled AS enabled_4,
  r0_.used_count AS used_count_5,
  r0_.last_used AS last_used_6,
  r0_.created_at AS created_at_7,
  r0_.created_by AS created_by_8,
  r0_.created_from AS created_from_9,
  r0_.updated_at AS updated_at_10,
  r0_.updated_by AS updated_by_11,
  r0_.updated_from AS updated_from_12,
  r0_.deleted_by AS deleted_by_13,
  r0_.deleted_from AS deleted_from_14,
  r0_.deleted_at AS deleted_at_15,
  r0_.redirect_page_id AS redirect_page_id_16
FROM
  redirect r0_
WHERE
  (
    r0_.source_url = ?
    AND r0_.enabled = ?
  )
  AND (r0_.deleted_at IS NULL)
ORDER BY
  r0_.updated_at DESC
LIMIT
  1

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.source_url AS source_url_2, r0_.redirect_url AS redirect_url_3, r0_.enabled AS enabled_4, r0_.used_count AS used_count_5, r0_.last_used AS last_used_6, r0_.created_at AS created_at_7, r0_.created_by AS created_by_8, r0_.created_from AS created_from_9, r0_.updated_at AS updated_at_10, r0_.updated_by AS updated_by_11, r0_.updated_from AS updated_from_12, r0_.deleted_by AS deleted_by_13, r0_.deleted_from AS deleted_from_14, r0_.deleted_at AS deleted_at_15, r0_.redirect_page_id AS redirect_page_id_16 FROM redirect r0_ WHERE (r0_.source_url = '/faqs' AND r0_.enabled = 1) AND (r0_.deleted_at IS NULL) ORDER BY r0_.updated_at DESC LIMIT 1;

#	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->getOneOrNullResult (line 738)
6	App\Repository\RedirectRepository->findBySlug (line 32)
7	App\Service\Manager\RedirectManager->getBySlug (line 75)
8	App\Controller\FrontendController->checkRedirect (line 255)
9	App\Controller\FrontendController->index (line 215)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.68 ms
(2.86%)

SELECT t0.id AS id_1, t0.image_size AS image_size_2, t0.device AS device_3, t0.created_at AS created_at_4, t0.created_by AS created_by_5, t0.created_from AS created_from_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.updated_from AS updated_from_9, t0.deleted_by AS deleted_by_10, t0.deleted_from AS deleted_from_11, t0.deleted_at AS deleted_at_12, t0.mime_type AS mime_type_13, t0.width AS width_14, t0.height AS height_15, t0.size AS size_16, t0.alt_text AS alt_text_17, t0.title AS title_18, t0.description AS description_19, t0.path AS path_20, t0.name AS name_21, t0.extension AS extension_22, t0.image_cropped_id AS image_cropped_id_23 FROM image_cropped_size t0 WHERE t0.image_cropped_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  5760
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_size AS image_size_2,
  t0.device AS device_3,
  t0.created_at AS created_at_4,
  t0.created_by AS created_by_5,
  t0.created_from AS created_from_6,
  t0.updated_at AS updated_at_7,
  t0.updated_by AS updated_by_8,
  t0.updated_from AS updated_from_9,
  t0.deleted_by AS deleted_by_10,
  t0.deleted_from AS deleted_from_11,
  t0.deleted_at AS deleted_at_12,
  t0.mime_type AS mime_type_13,
  t0.width AS width_14,
  t0.height AS height_15,
  t0.size AS size_16,
  t0.alt_text AS alt_text_17,
  t0.title AS title_18,
  t0.description AS description_19,
  t0.path AS path_20,
  t0.name AS name_21,
  t0.extension AS extension_22,
  t0.image_cropped_id AS image_cropped_id_23
FROM
  image_cropped_size t0
WHERE
  t0.image_cropped_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.image_size AS image_size_2, t0.device AS device_3, t0.created_at AS created_at_4, t0.created_by AS created_by_5, t0.created_from AS created_from_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.updated_from AS updated_from_9, t0.deleted_by AS deleted_by_10, t0.deleted_from AS deleted_from_11, t0.deleted_at AS deleted_at_12, t0.mime_type AS mime_type_13, t0.width AS width_14, t0.height AS height_15, t0.size AS size_16, t0.alt_text AS alt_text_17, t0.title AS title_18, t0.description AS description_19, t0.path AS path_20, t0.name AS name_21, t0.extension AS extension_22, t0.image_cropped_id AS image_cropped_id_23 FROM image_cropped_size t0 WHERE t0.image_cropped_id = 5760 AND ((t0.deleted_at IS NULL));

#	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->get (line 118)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->offsetGet (line 425)
9	App\Twig\AppExtension->getCroppedImage (line 185)
10	__TwigTemplate_b4b14b0c0d70bd44461ccd0a98e55e01->doDisplay (line 51)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
17	__TwigTemplate_3d9402ee3fcaa75a28ca8291ebcee72e->doDisplay (line 147)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_630298a495a8b75d9c88a9946d95243c->doDisplay (line 56)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
24	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
25	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
26	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->block_body (line 305)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->doDisplay (line 165)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_987582c0cb028068551f42a23858d227->doDisplay (line 55)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	App\Service\Manager\PageManager->viewPublished (line 24)
36	App\Controller\FrontendController->loadPage (line 285)
37	App\Controller\FrontendController->index (line 231)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 182)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 29)
43	require_once (line 5)

0.60 ms
(2.52%)

SELECT p0_.id AS id_0, p0_.template AS template_1, p0_.title AS title_2, p0_.description AS description_3, p0_.keywords AS keywords_4, p0_.position AS position_5, p0_.access_level AS access_level_6, p0_.enabled AS enabled_7, p0_.name AS name_8, p0_.slug AS slug_9, p0_.in_sitemap AS in_sitemap_10, p0_.in_menu AS in_menu_11, p0_.published_template AS published_template_12, p0_.published_data AS published_data_13, p0_.published AS published_14, p0_.published_at AS published_at_15, p0_.data AS data_16, p0_.created_at AS created_at_17, p0_.created_by AS created_by_18, p0_.created_from AS created_from_19, p0_.updated_at AS updated_at_20, p0_.updated_by AS updated_by_21, p0_.updated_from AS updated_from_22, p0_.deleted_by AS deleted_by_23, p0_.deleted_from AS deleted_from_24, p0_.deleted_at AS deleted_at_25, p0_.parent_id AS parent_id_26, p0_.canonical_page_id AS canonical_page_id_27 FROM page p0_ WHERE (p0_.slug = ? AND p0_.parent_id IS NULL AND p0_.enabled = ?) AND (p0_.deleted_at IS NULL)

Parameters:

[
  "faqs"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.template AS template_1,
  p0_.title AS title_2,
  p0_.description AS description_3,
  p0_.keywords AS keywords_4,
  p0_.position AS position_5,
  p0_.access_level AS access_level_6,
  p0_.enabled AS enabled_7,
  p0_.name AS name_8,
  p0_.slug AS slug_9,
  p0_.in_sitemap AS in_sitemap_10,
  p0_.in_menu AS in_menu_11,
  p0_.published_template AS published_template_12,
  p0_.published_data AS published_data_13,
  p0_.published AS published_14,
  p0_.published_at AS published_at_15,
  p0_.data AS data_16,
  p0_.created_at AS created_at_17,
  p0_.created_by AS created_by_18,
  p0_.created_from AS created_from_19,
  p0_.updated_at AS updated_at_20,
  p0_.updated_by AS updated_by_21,
  p0_.updated_from AS updated_from_22,
  p0_.deleted_by AS deleted_by_23,
  p0_.deleted_from AS deleted_from_24,
  p0_.deleted_at AS deleted_at_25,
  p0_.parent_id AS parent_id_26,
  p0_.canonical_page_id AS canonical_page_id_27
FROM
  page p0_
WHERE
  (
    p0_.slug = ?
    AND p0_.parent_id IS NULL
    AND p0_.enabled = ?
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.id AS id_0, p0_.template AS template_1, p0_.title AS title_2, p0_.description AS description_3, p0_.keywords AS keywords_4, p0_.position AS position_5, p0_.access_level AS access_level_6, p0_.enabled AS enabled_7, p0_.name AS name_8, p0_.slug AS slug_9, p0_.in_sitemap AS in_sitemap_10, p0_.in_menu AS in_menu_11, p0_.published_template AS published_template_12, p0_.published_data AS published_data_13, p0_.published AS published_14, p0_.published_at AS published_at_15, p0_.data AS data_16, p0_.created_at AS created_at_17, p0_.created_by AS created_by_18, p0_.created_from AS created_from_19, p0_.updated_at AS updated_at_20, p0_.updated_by AS updated_by_21, p0_.updated_from AS updated_from_22, p0_.deleted_by AS deleted_by_23, p0_.deleted_from AS deleted_from_24, p0_.deleted_at AS deleted_at_25, p0_.parent_id AS parent_id_26, p0_.canonical_page_id AS canonical_page_id_27 FROM page p0_ WHERE (p0_.slug = 'faqs' AND p0_.parent_id IS NULL AND p0_.enabled = 1) AND (p0_.deleted_at IS NULL);

#	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->getOneOrNullResult (line 738)
6	App\Repository\PageRepository->getBasePage (line 40)
7	App\Service\Manager\PageManager->getPageFromSlug (line 124)
8	App\Controller\FrontendController->index (line 226)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.54 ms
(2.26%)

SELECT t0.id AS id_1, t0.image_size_group AS image_size_group_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.created_from AS created_from_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.updated_from AS updated_from_8, t0.deleted_by AS deleted_by_9, t0.deleted_from AS deleted_from_10, t0.deleted_at AS deleted_at_11, t0.image_original_id AS image_original_id_12 FROM image_cropped t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  5760
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_size_group AS image_size_group_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.created_from AS created_from_5,
  t0.updated_at AS updated_at_6,
  t0.updated_by AS updated_by_7,
  t0.updated_from AS updated_from_8,
  t0.deleted_by AS deleted_by_9,
  t0.deleted_from AS deleted_from_10,
  t0.deleted_at AS deleted_at_11,
  t0.image_original_id AS image_original_id_12
FROM
  image_cropped t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.image_size_group AS image_size_group_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.created_from AS created_from_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.updated_from AS updated_from_8, t0.deleted_by AS deleted_by_9, t0.deleted_from AS deleted_from_10, t0.deleted_at AS deleted_at_11, t0.image_original_id AS image_original_id_12 FROM image_cropped t0 WHERE t0.id = 5760 AND ((t0.deleted_at IS NULL));

#	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\Service\Manager\AbstractManager->get (line 82)
7	App\Twig\AppExtension->getCroppedImage (line 173)
8	__TwigTemplate_b4b14b0c0d70bd44461ccd0a98e55e01->doDisplay (line 51)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
15	__TwigTemplate_3d9402ee3fcaa75a28ca8291ebcee72e->doDisplay (line 147)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_630298a495a8b75d9c88a9946d95243c->doDisplay (line 56)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
24	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->block_body (line 305)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->doDisplay (line 165)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_987582c0cb028068551f42a23858d227->doDisplay (line 55)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	App\Service\Manager\PageManager->viewPublished (line 24)
34	App\Controller\FrontendController->loadPage (line 285)
35	App\Controller\FrontendController->index (line 231)
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)

0.52 ms
(2.20%)

SELECT t0.id AS id_1, t0.class_name AS class_name_2, t0.class_id AS class_id_3, t0.name AS name_4, t0.template AS template_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.published_template AS published_template_8, t0.published_data AS published_data_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.data AS data_12, t0.created_at AS created_at_13, t0.created_by AS created_by_14, t0.created_from AS created_from_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.updated_from AS updated_from_18, t0.deleted_by AS deleted_by_19, t0.deleted_from AS deleted_from_20, t0.deleted_at AS deleted_at_21, t0.global_id AS global_id_22, t0.parent_id AS parent_id_23 FROM data_block t0 WHERE t0.parent_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC

Parameters:

[
  5733
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.class_name AS class_name_2,
  t0.class_id AS class_id_3,
  t0.name AS name_4,
  t0.template AS template_5,
  t0.enabled AS enabled_6,
  t0.position AS position_7,
  t0.published_template AS published_template_8,
  t0.published_data AS published_data_9,
  t0.published AS published_10,
  t0.published_at AS published_at_11,
  t0.data AS data_12,
  t0.created_at AS created_at_13,
  t0.created_by AS created_by_14,
  t0.created_from AS created_from_15,
  t0.updated_at AS updated_at_16,
  t0.updated_by AS updated_by_17,
  t0.updated_from AS updated_from_18,
  t0.deleted_by AS deleted_by_19,
  t0.deleted_from AS deleted_from_20,
  t0.deleted_at AS deleted_at_21,
  t0.global_id AS global_id_22,
  t0.parent_id AS parent_id_23
FROM
  data_block t0
WHERE
  t0.parent_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.class_name AS class_name_2, t0.class_id AS class_id_3, t0.name AS name_4, t0.template AS template_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.published_template AS published_template_8, t0.published_data AS published_data_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.data AS data_12, t0.created_at AS created_at_13, t0.created_by AS created_by_14, t0.created_from AS created_from_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.updated_from AS updated_from_18, t0.deleted_by AS deleted_by_19, t0.deleted_from AS deleted_from_20, t0.deleted_at AS deleted_at_21, t0.global_id AS global_id_22, t0.parent_id AS parent_id_23 FROM data_block t0 WHERE t0.parent_id = 5733 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

#	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->getIterator (line 313)
7	__TwigTemplate_eb655a2c5d1d05f760bb9ac95458c7d8->doDisplay (line 85)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_630298a495a8b75d9c88a9946d95243c->doDisplay (line 56)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->block_body (line 305)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->doDisplay (line 165)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_987582c0cb028068551f42a23858d227->doDisplay (line 55)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	App\Service\Manager\PageManager->viewPublished (line 24)
26	App\Controller\FrontendController->loadPage (line 285)
27	App\Controller\FrontendController->index (line 231)
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.36 ms
(1.52%)

SELECT t0.id AS id_1, t0.category AS category_2, t0.name AS name_3, t0.description AS description_4, t0.src AS src_5, t0.fields AS fields_6, t0.enabled AS enabled_7, t0.image_path AS image_path_8, t0.child AS child_9, t0.allowed_page_templates AS allowed_page_templates_10, t0.allowed_children AS allowed_children_11, t0.created_at AS created_at_12, t0.created_by AS created_by_13, t0.created_from AS created_from_14, t0.updated_at AS updated_at_15, t0.updated_by AS updated_by_16, t0.updated_from AS updated_from_17, t0.deleted_by AS deleted_by_18, t0.deleted_from AS deleted_from_19, t0.deleted_at AS deleted_at_20 FROM data_block_template t0 WHERE ((t0.deleted_at IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.src AS src_5,
  t0.fields AS fields_6,
  t0.enabled AS enabled_7,
  t0.image_path AS image_path_8,
  t0.child AS child_9,
  t0.allowed_page_templates AS allowed_page_templates_10,
  t0.allowed_children AS allowed_children_11,
  t0.created_at AS created_at_12,
  t0.created_by AS created_by_13,
  t0.created_from AS created_from_14,
  t0.updated_at AS updated_at_15,
  t0.updated_by AS updated_by_16,
  t0.updated_from AS updated_from_17,
  t0.deleted_by AS deleted_by_18,
  t0.deleted_from AS deleted_from_19,
  t0.deleted_at AS deleted_at_20
FROM
  data_block_template t0
WHERE
  (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.category AS category_2, t0.name AS name_3, t0.description AS description_4, t0.src AS src_5, t0.fields AS fields_6, t0.enabled AS enabled_7, t0.image_path AS image_path_8, t0.child AS child_9, t0.allowed_page_templates AS allowed_page_templates_10, t0.allowed_children AS allowed_children_11, t0.created_at AS created_at_12, t0.created_by AS created_by_13, t0.created_from AS created_from_14, t0.updated_at AS updated_at_15, t0.updated_by AS updated_by_16, t0.updated_from AS updated_from_17, t0.deleted_by AS deleted_by_18, t0.deleted_from AS deleted_from_19, t0.deleted_at AS deleted_at_20 FROM data_block_template t0 WHERE ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\Manager\DataBlockTemplateManager->getAll (line 22)
6	App\Registry\DataBlockTemplateRegistry->loadDatabaseItems (line 51)
7	App\Registry\AbstractItemRegistry->loadItems (line 64)
8	App\Registry\AbstractItemRegistry->getItem (line 29)
9	App\Twig\Components\Render\DatablockRender->src (line 56)
10	Twig\Extension\CoreExtension->getAttribute (line 1909)
11	__TwigTemplate_630298a495a8b75d9c88a9946d95243c::doDisplay (line 53)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
18	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->block_body (line 305)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_efb08d4b4a846023bdc61dfa936c97e9->doDisplay (line 165)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_987582c0cb028068551f42a23858d227->doDisplay (line 55)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	App\Service\Manager\PageManager->viewPublished (line 24)
28	App\Controller\FrontendController->loadPage (line 285)
29	App\Controller\FrontendController->index (line 231)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.36 ms
(1.51%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.src AS src_3, t0.fields AS fields_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.created_from AS created_from_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.updated_from AS updated_from_11, t0.deleted_by AS deleted_by_12, t0.deleted_from AS deleted_from_13, t0.deleted_at AS deleted_at_14 FROM page_template t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.src AS src_3,
  t0.fields AS fields_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.created_by AS created_by_7,
  t0.created_from AS created_from_8,
  t0.updated_at AS updated_at_9,
  t0.updated_by AS updated_by_10,
  t0.updated_from AS updated_from_11,
  t0.deleted_by AS deleted_by_12,
  t0.deleted_from AS deleted_from_13,
  t0.deleted_at AS deleted_at_14
FROM
  page_template t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.src AS src_3, t0.fields AS fields_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.created_from AS created_from_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.updated_from AS updated_from_11, t0.deleted_by AS deleted_by_12, t0.deleted_from AS deleted_from_13, t0.deleted_at AS deleted_at_14 FROM page_template t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\Manager\PageTemplateManager->getAll (line 20)
6	App\Registry\PageTemplateRegistry->loadDatabaseItems (line 51)
7	App\Registry\AbstractItemRegistry->loadItems (line 64)
8	App\Registry\AbstractItemRegistry->getItem (line 29)
9	App\Controller\FrontendController->loadPage (line 267)
10	App\Controller\FrontendController->index (line 231)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.28 ms
(1.19%)

SELECT t0.id AS id_1, t0.data AS data_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.created_from AS created_from_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.updated_from AS updated_from_8, t0.deleted_by AS deleted_by_9, t0.deleted_from AS deleted_from_10, t0.deleted_at AS deleted_at_11 FROM site_settings t0 WHERE ((t0.deleted_at IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.created_from AS created_from_5,
  t0.updated_at AS updated_at_6,
  t0.updated_by AS updated_by_7,
  t0.updated_from AS updated_from_8,
  t0.deleted_by AS deleted_by_9,
  t0.deleted_from AS deleted_from_10,
  t0.deleted_at AS deleted_at_11
FROM
  site_settings t0
WHERE
  (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.data AS data_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.created_from AS created_from_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.updated_from AS updated_from_8, t0.deleted_by AS deleted_by_9, t0.deleted_from AS deleted_from_10, t0.deleted_at AS deleted_at_11 FROM site_settings t0 WHERE ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\Manager\SiteSettingsManager->getSettings (line 32)
6	App\Controller\FrontendController->loadPage (line 273)
7	App\Controller\FrontendController->index (line 231)
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)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
external	doctrine.dbal.external_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
external	doctrine.orm.external_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\MenuItem	25
App\Entity\Page	13
App\Entity\DataBlock	11
App\Entity\Menu	3
App\Entity\DataBlockTemplate	3
App\Entity\ImageCroppedSize	3
App\Entity\PageTemplate	1
App\Entity\SiteSettings	1
App\Entity\ImageCropped	1
App\Entity\ImageOriginal	1

external entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Upload	No errors.
App\Entity\ImageOriginal	No errors.
App\Entity\ImageCropped	No errors.
App\Entity\ImageCategory	No errors.
App\Entity\ImageTemplate	No errors.
App\Entity\Redirect	No errors.
App\Entity\SiteSettings	No errors.
App\Entity\PageTemplate	No errors.
App\Entity\Page	No errors.
App\Entity\News	No errors.
App\Entity\Event	No errors.
App\Entity\Menu	No errors.
App\Entity\Document	No errors.
App\Entity\FormSubmission	No errors.
App\Entity\SiteSearch	No errors.
App\Entity\DataBlock	No errors.
App\Entity\PublishSchedule	No errors.
App\Entity\MenuItem	No errors.
App\Entity\DataBlockTemplate	No errors.
App\Entity\DataBlockCategory	No errors.
App\Entity\DataBlockGlobal	No errors.
App\Entity\ImageCroppedSize	No errors.

external entity manager

No loaded entities.

Symfony Profiler

GET https://cms2025.apknowhow.co.uk/faqs

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

external entity manager

Entities Mapping

default entity manager

external entity manager