Symfony Profiler

Query Metrics

13 Database Queries

8 Different statements

6.54 ms Query time

0 Invalid entities

13 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.71 ms
(26.12%)

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.name AS name_3, t0.short_text AS short_text_4, t0.content AS content_5, t0.url AS url_6, t0.title_image AS title_image_7, t0.media_id AS media_id_8 FROM media_content t0 WHERE t0.media_id = ?

Parameters:

[
  102
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.name AS name_3,
  t0.short_text AS short_text_4,
  t0.content AS content_5,
  t0.url AS url_6,
  t0.title_image AS title_image_7,
  t0.media_id AS media_id_8
FROM
  media_content t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.name AS name_3, t0.short_text AS short_text_4, t0.content AS content_5, t0.url AS url_6, t0.title_image AS title_image_7, t0.media_id AS media_id_8 FROM media_content t0 WHERE t0.media_id = 102;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
12	__TwigTemplate_f3a3608e6ec1488dc67c6b8738ded23a->block_body (line 206)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_d43bc71d4695f7fa53b606dc7d56ec4e->doDisplay (line 225)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_f3a3608e6ec1488dc67c6b8738ded23a->doDisplay (line 58)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\MediaController->mediaList (line 40)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

1.31 ms
(20.03%)

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.path = ? AND p0_.status = 1 AND (p0_.web_id = ? OR p0_.web_id LIKE ?)

Parameters:

[
  "media/"
  "%2%"
  "%2%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS parent_id_1,
  p0_.web_id AS web_id_2,
  p0_.lang AS lang_3,
  p0_.url AS url_4,
  p0_.path AS path_5,
  p0_.canonical_url AS canonical_url_6,
  p0_.title AS title_7,
  p0_.meta_description AS meta_description_8,
  p0_.nodes AS nodes_9,
  p0_.level AS level_10,
  p0_.type AS type_11,
  p0_.position AS position_12,
  p0_.has_subpage AS has_subpage_13,
  p0_.has_sidebar AS has_sidebar_14,
  p0_.og_title AS og_title_15,
  p0_.og_description AS og_description_16,
  p0_.og_site_name AS og_site_name_17,
  p0_.og_url AS og_url_18,
  p0_.og_img AS og_img_19,
  p0_.tw_title AS tw_title_20,
  p0_.tw_description AS tw_description_21,
  p0_.tw_image AS tw_image_22,
  p0_.tw_card AS tw_card_23,
  p0_.tw_alt_image AS tw_alt_image_24,
  p0_.status AS status_25,
  p0_.created_at AS created_at_26,
  p0_.updated_at AS updated_at_27,
  p0_.created_by AS created_by_28
FROM
  pages p0_
WHERE
  p0_.path = ?
  AND p0_.status = 1
  AND (
    p0_.web_id = ?
    OR p0_.web_id LIKE ?
  )

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.path = 'media/' AND p0_.status = 1 AND (p0_.web_id = '%2%' OR p0_.web_id LIKE '%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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\PagesRepository->findOneByPath (line 50)
7	App\Controller\MediaController->mediaList (line 30)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.73 ms
(11.21%)

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.lang = ? AND p0_.level = 1 AND p0_.status = 1 AND (p0_.web_id = ? OR p0_.web_id LIKE ?) ORDER BY p0_.position ASC

Parameters:

[
  "sk"
  "%2%"
  "%2%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS parent_id_1,
  p0_.web_id AS web_id_2,
  p0_.lang AS lang_3,
  p0_.url AS url_4,
  p0_.path AS path_5,
  p0_.canonical_url AS canonical_url_6,
  p0_.title AS title_7,
  p0_.meta_description AS meta_description_8,
  p0_.nodes AS nodes_9,
  p0_.level AS level_10,
  p0_.type AS type_11,
  p0_.position AS position_12,
  p0_.has_subpage AS has_subpage_13,
  p0_.has_sidebar AS has_sidebar_14,
  p0_.og_title AS og_title_15,
  p0_.og_description AS og_description_16,
  p0_.og_site_name AS og_site_name_17,
  p0_.og_url AS og_url_18,
  p0_.og_img AS og_img_19,
  p0_.tw_title AS tw_title_20,
  p0_.tw_description AS tw_description_21,
  p0_.tw_image AS tw_image_22,
  p0_.tw_card AS tw_card_23,
  p0_.tw_alt_image AS tw_alt_image_24,
  p0_.status AS status_25,
  p0_.created_at AS created_at_26,
  p0_.updated_at AS updated_at_27,
  p0_.created_by AS created_by_28
FROM
  pages p0_
WHERE
  p0_.lang = ?
  AND p0_.level = 1
  AND p0_.status = 1
  AND (
    p0_.web_id = ?
    OR p0_.web_id LIKE ?
  )
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.lang = 'sk' AND p0_.level = 1 AND p0_.status = 1 AND (p0_.web_id = '%2%' OR p0_.web_id LIKE '%2%') ORDER BY p0_.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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Repository\PagesRepository->findTopMenuByLocale (line 66)
7	App\Menu\MenuBuilder->getTopMenu (line 15)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_d43bc71d4695f7fa53b606dc7d56ec4e->block_menu (line 543)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_d43bc71d4695f7fa53b606dc7d56ec4e->doDisplay (line 209)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_f3a3608e6ec1488dc67c6b8738ded23a->doDisplay (line 58)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\MediaController->mediaList (line 40)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.66 ms
(10.10%)

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.lang = ? AND p0_.level >= 2 AND p0_.status = 1 AND (p0_.web_id = ? OR p0_.web_id LIKE ?) ORDER BY p0_.position ASC

Parameters:

[
  "sk"
  "%2%"
  "%2%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS parent_id_1,
  p0_.web_id AS web_id_2,
  p0_.lang AS lang_3,
  p0_.url AS url_4,
  p0_.path AS path_5,
  p0_.canonical_url AS canonical_url_6,
  p0_.title AS title_7,
  p0_.meta_description AS meta_description_8,
  p0_.nodes AS nodes_9,
  p0_.level AS level_10,
  p0_.type AS type_11,
  p0_.position AS position_12,
  p0_.has_subpage AS has_subpage_13,
  p0_.has_sidebar AS has_sidebar_14,
  p0_.og_title AS og_title_15,
  p0_.og_description AS og_description_16,
  p0_.og_site_name AS og_site_name_17,
  p0_.og_url AS og_url_18,
  p0_.og_img AS og_img_19,
  p0_.tw_title AS tw_title_20,
  p0_.tw_description AS tw_description_21,
  p0_.tw_image AS tw_image_22,
  p0_.tw_card AS tw_card_23,
  p0_.tw_alt_image AS tw_alt_image_24,
  p0_.status AS status_25,
  p0_.created_at AS created_at_26,
  p0_.updated_at AS updated_at_27,
  p0_.created_by AS created_by_28
FROM
  pages p0_
WHERE
  p0_.lang = ?
  AND p0_.level >= 2
  AND p0_.status = 1
  AND (
    p0_.web_id = ?
    OR p0_.web_id LIKE ?
  )
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.lang = 'sk' AND p0_.level >= 2 AND p0_.status = 1 AND (p0_.web_id = '%2%' OR p0_.web_id LIKE '%2%') ORDER BY p0_.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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Repository\PagesRepository->findSubMenuByLocale (line 81)
7	App\Menu\MenuBuilder->getTopMenu (line 16)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_d43bc71d4695f7fa53b606dc7d56ec4e->block_menu (line 543)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_d43bc71d4695f7fa53b606dc7d56ec4e->doDisplay (line 209)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_f3a3608e6ec1488dc67c6b8738ded23a->doDisplay (line 58)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\MediaController->mediaList (line 40)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.61 ms
(9.33%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_25 FROM (SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1) dctrn_result_inner ORDER BY created_at_25 DESC) dctrn_result LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_25
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.parent_id AS parent_id_1,
          p0_.web_id AS web_id_2,
          p0_.lang AS lang_3,
          p0_.url AS url_4,
          p0_.path AS path_5,
          p0_.canonical_url AS canonical_url_6,
          p0_.title AS title_7,
          p0_.meta_description AS meta_description_8,
          p0_.nodes AS nodes_9,
          p0_.level AS level_10,
          p0_.type AS type_11,
          p0_.position AS position_12,
          p0_.has_subpage AS has_subpage_13,
          p0_.og_title AS og_title_14,
          p0_.og_description AS og_description_15,
          p0_.og_site_name AS og_site_name_16,
          p0_.og_url AS og_url_17,
          p0_.og_img AS og_img_18,
          p0_.tw_title AS tw_title_19,
          p0_.tw_description AS tw_description_20,
          p0_.tw_image AS tw_image_21,
          p0_.tw_card AS tw_card_22,
          p0_.tw_alt_image AS tw_alt_image_23,
          p0_.status AS status_24,
          p0_.created_at AS created_at_25,
          p0_.updated_at AS updated_at_26,
          p0_.created_by AS created_by_27
        FROM
          pages p0_
        WHERE
          p0_.type IN (5, 6)
          AND p0_.status = 1
      ) dctrn_result_inner
    ORDER BY
      created_at_25 DESC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_25 FROM (SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1) dctrn_result_inner ORDER BY created_at_25 DESC) dctrn_result LIMIT 6;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	__TwigTemplate_f3a3608e6ec1488dc67c6b8738ded23a->block_body (line 206)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_d43bc71d4695f7fa53b606dc7d56ec4e->doDisplay (line 225)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_f3a3608e6ec1488dc67c6b8738ded23a->doDisplay (line 58)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\MediaController->mediaList (line 40)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.59 ms
(9.09%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1 ORDER BY p0_.created_at DESC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.parent_id AS parent_id_1,
          p0_.web_id AS web_id_2,
          p0_.lang AS lang_3,
          p0_.url AS url_4,
          p0_.path AS path_5,
          p0_.canonical_url AS canonical_url_6,
          p0_.title AS title_7,
          p0_.meta_description AS meta_description_8,
          p0_.nodes AS nodes_9,
          p0_.level AS level_10,
          p0_.type AS type_11,
          p0_.position AS position_12,
          p0_.has_subpage AS has_subpage_13,
          p0_.og_title AS og_title_14,
          p0_.og_description AS og_description_15,
          p0_.og_site_name AS og_site_name_16,
          p0_.og_url AS og_url_17,
          p0_.og_img AS og_img_18,
          p0_.tw_title AS tw_title_19,
          p0_.tw_description AS tw_description_20,
          p0_.tw_image AS tw_image_21,
          p0_.tw_card AS tw_card_22,
          p0_.tw_alt_image AS tw_alt_image_23,
          p0_.status AS status_24,
          p0_.created_at AS created_at_25,
          p0_.updated_at AS updated_at_26,
          p0_.created_by AS created_by_27
        FROM
          pages p0_
        WHERE
          p0_.type IN (5, 6)
          AND p0_.status = 1
        ORDER BY
          p0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1 ORDER BY p0_.created_at DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Controller\MediaController->mediaList (line 38)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.47 ms
(7.25%)

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY p0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS parent_id_1,
  p0_.web_id AS web_id_2,
  p0_.lang AS lang_3,
  p0_.url AS url_4,
  p0_.path AS path_5,
  p0_.canonical_url AS canonical_url_6,
  p0_.title AS title_7,
  p0_.meta_description AS meta_description_8,
  p0_.nodes AS nodes_9,
  p0_.level AS level_10,
  p0_.type AS type_11,
  p0_.position AS position_12,
  p0_.has_subpage AS has_subpage_13,
  p0_.og_title AS og_title_14,
  p0_.og_description AS og_description_15,
  p0_.og_site_name AS og_site_name_16,
  p0_.og_url AS og_url_17,
  p0_.og_img AS og_img_18,
  p0_.tw_title AS tw_title_19,
  p0_.tw_description AS tw_description_20,
  p0_.tw_image AS tw_image_21,
  p0_.tw_card AS tw_card_22,
  p0_.tw_alt_image AS tw_alt_image_23,
  p0_.status AS status_24,
  p0_.created_at AS created_at_25,
  p0_.updated_at AS updated_at_26,
  p0_.created_by AS created_by_27
FROM
  pages p0_
WHERE
  p0_.type IN (5, 6)
  AND p0_.status = 1
  AND p0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1 AND p0_.id IN (102, 101, 87, 49, 50, 51) ORDER BY p0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	__TwigTemplate_f3a3608e6ec1488dc67c6b8738ded23a->block_body (line 206)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_d43bc71d4695f7fa53b606dc7d56ec4e->doDisplay (line 225)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_f3a3608e6ec1488dc67c6b8738ded23a->doDisplay (line 58)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\MediaController->mediaList (line 40)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.45 ms
(6.88%)

SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.content AS content_3, t0.has_gallery AS has_gallery_4, t0.page_id AS page_id_5 FROM pages_content t0 WHERE t0.page_id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.page_id AS page_id_2,
  t0.content AS content_3,
  t0.has_gallery AS has_gallery_4,
  t0.page_id AS page_id_5
FROM
  pages_content t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.content AS content_3, t0.has_gallery AS has_gallery_4, t0.page_id AS page_id_5 FROM pages_content t0 WHERE t0.page_id = 21;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\PagesRepository->findOneByPath (line 50)
12	App\Controller\MediaController->mediaList (line 30)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	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\Media	6
App\Entity\MediaContent	6
App\Entity\Pages	1

Entities Mapping

Class	Mapping errors
App\Entity\Pages	No errors.
App\Entity\PagesContent	No errors.
App\Entity\Media	No errors.
App\Entity\MediaContent	No errors.

Symfony Profiler

GET https://vazektomia.tomas-levcik.sk/media/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping