Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

4.03 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.04 ms
(25.92%)

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:

[
  "objednajte-sa/"
  "%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 = 'objednajte-sa/' 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\PagesController->orderform (line 100)
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)

1.01 ms
(25.12%)

SELECT t0.id AS id_1, t0.form_number AS form_number_2, t0.form_type AS form_type_3, t0.capcha AS capcha_4, t0.insurance AS insurance_5, t0.confirm AS confirm_6, t0.from_name AS from_name_7, t0.from_email AS from_email_8, t0.from_phone_number AS from_phone_number_9, t0.message AS message_10, t0.date_of_receiv AS date_of_receiv_11, t0.date_of_completion AS date_of_completion_12, t0.city AS city_13, t0.exam AS exam_14, t0.doctor AS doctor_15, t0.is_completed AS is_completed_16 FROM contact_form t0 ORDER BY t0.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.form_number AS form_number_2,
  t0.form_type AS form_type_3,
  t0.capcha AS capcha_4,
  t0.insurance AS insurance_5,
  t0.confirm AS confirm_6,
  t0.from_name AS from_name_7,
  t0.from_email AS from_email_8,
  t0.from_phone_number AS from_phone_number_9,
  t0.message AS message_10,
  t0.date_of_receiv AS date_of_receiv_11,
  t0.date_of_completion AS date_of_completion_12,
  t0.city AS city_13,
  t0.exam AS exam_14,
  t0.doctor AS doctor_15,
  t0.is_completed AS is_completed_16
FROM
  contact_form t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.form_number AS form_number_2, t0.form_type AS form_type_3, t0.capcha AS capcha_4, t0.insurance AS insurance_5, t0.confirm AS confirm_6, t0.from_name AS from_name_7, t0.from_email AS from_email_8, t0.from_phone_number AS from_phone_number_9, t0.message AS message_10, t0.date_of_receiv AS date_of_receiv_11, t0.date_of_completion AS date_of_completion_12, t0.city AS city_13, t0.exam AS exam_14, t0.doctor AS doctor_15, t0.is_completed AS is_completed_16 FROM contact_form t0 ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\PagesController->orderform (line 97)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.87 ms
(21.51%)

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_887a96e65e03d70707feab20b2193bc1->doDisplay (line 60)
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\PagesController->orderform (line 183)
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.72 ms
(17.93%)

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_887a96e65e03d70707feab20b2193bc1->doDisplay (line 60)
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\PagesController->orderform (line 183)
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.38 ms
(9.53%)

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:

[
  27
]

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

#	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\PagesController->orderform (line 100)
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\ContactForm	1
App\Entity\Pages	1

Entities Mapping

Class	Mapping errors
App\Entity\ContactForm	No errors.
App\Entity\Pages	No errors.
App\Entity\PagesContent	No errors.

Symfony Profiler

GET https://vazektomia.tomas-levcik.sk/objednajte-sa/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping