Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.94 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.95 ms

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_.path = ? AND p0_.status = 1 AND p0_.type = ? AND (p0_.web_id = ? OR p0_.web_id LIKE ?)

Parameters:

[
  "media/videa/november-je-mesiac-muzskeho-zdravia/"
  5
  "%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_.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_.path = ?
  AND p0_.status = 1
  AND p0_.type = ?
  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_.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_.path = 'media/videa/november-je-mesiac-muzskeho-zdravia/' AND p0_.status = 1 AND p0_.type = 5 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\MediaRepository->findOneByPathAndType (line 78)
7	App\Controller\MediaController->videoDetail (line 116)
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

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:

[
  33
]

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 = 33;

#	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\MediaRepository->findOneByPathAndType (line 78)
12	App\Controller\MediaController->videoDetail (line 116)
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)

0.85 ms

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_375946efb7daf44679b8358cb4a8335d->doDisplay (line 59)
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->videoDetail (line 124)
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)

2.67 ms

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_375946efb7daf44679b8358cb4a8335d->doDisplay (line 59)
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->videoDetail (line 124)
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)

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	1
App\Entity\MediaContent	1

Entities Mapping

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

Symfony Profiler

GET https://vazektomia.tomas-levcik.sk/media/videa/november-je-mesiac-muzskeho-zdravia/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping