Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

1.75 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.96 ms
(54.72%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.image2 AS image2_13, t0.keywords AS keywords_14, t0.meta_title AS meta_title_15, t0.meta_desc AS meta_desc_16, t0.lead_image AS lead_image_17, t0.lead AS lead_18, t0.created AS created_19, t0.updated AS updated_20, t0.parent_id AS parent_id_21, t0.template_id AS template_id_22 FROM page t0 WHERE t0.parent_id = ? ORDER BY t0.position DESC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enabled AS enabled_4,
  t0.in_menu AS in_menu_5,
  t0.in_footer_menu AS in_footer_menu_6,
  t0.menu_name AS menu_name_7,
  t0.position AS position_8,
  t0.redirect AS redirect_9,
  t0.title AS title_10,
  t0.content AS content_11,
  t0.image AS image_12,
  t0.image2 AS image2_13,
  t0.keywords AS keywords_14,
  t0.meta_title AS meta_title_15,
  t0.meta_desc AS meta_desc_16,
  t0.lead_image AS lead_image_17,
  t0.lead AS lead_18,
  t0.created AS created_19,
  t0.updated AS updated_20,
  t0.parent_id AS parent_id_21,
  t0.template_id AS template_id_22
FROM
  page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.image2 AS image2_13, t0.keywords AS keywords_14, t0.meta_title AS meta_title_15, t0.meta_desc AS meta_desc_16, t0.lead_image AS lead_image_17, t0.lead AS lead_18, t0.created AS created_19, t0.updated AS updated_20, t0.parent_id AS parent_id_21, t0.template_id AS template_id_22 FROM page t0 WHERE t0.parent_id = 4 ORDER BY t0.position DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 132)
8	__TwigTemplate_6223144274897bbe50b3540fcc9dfbe2->doDisplay (line 388)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 245)
17	App\Controller\PageController->_menu (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
21	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
22	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
23	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
24	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 604)
25	__TwigTemplate_91aa281ff6bca36d8c78e7d60fdaea99->block_pageheader (line 432)
26	Twig\Template->yieldBlock (line 438)
27	__TwigTemplate_91aa281ff6bca36d8c78e7d60fdaea99->block_main (line 432)
28	Twig\Template->yieldBlock (line 150)
29	__TwigTemplate_91aa281ff6bca36d8c78e7d60fdaea99->doDisplay (line 388)
30	Twig\Template->yield (line 56)
31	__TwigTemplate_67a9aa68b4d2dd6798be84ed7966bec6->doDisplay (line 388)
32	Twig\Template->yield (line 344)
33	Twig\Template->display (line 359)
34	Twig\Template->render (line 51)
35	Twig\TemplateWrapper->render (line 334)
36	Twig\Environment->render (line 448)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 93)
40	App\Controller\ApplicationController->newpdf (line 181)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
43	Symfony\Component\HttpKernel\Kernel->handle (line 86)
44	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
46	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
47	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
48	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
49	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
50	Symfony\Component\HttpKernel\Kernel->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	require_once (line 5)

0.45 ms
(25.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM settings 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.value AS value_3,
  t0.description AS description_4
FROM
  settings t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM settings t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 25)
5	App\Service\SettingsService->get (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 343)
7	__TwigTemplate_91aa281ff6bca36d8c78e7d60fdaea99->block_main (line 432)
8	Twig\Template->yieldBlock (line 150)
9	__TwigTemplate_91aa281ff6bca36d8c78e7d60fdaea99->doDisplay (line 388)
10	Twig\Template->yield (line 56)
11	__TwigTemplate_67a9aa68b4d2dd6798be84ed7966bec6->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 93)
20	App\Controller\ApplicationController->newpdf (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
26	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.34 ms
(19.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.image2 AS image2_13, t0.keywords AS keywords_14, t0.meta_title AS meta_title_15, t0.meta_desc AS meta_desc_16, t0.lead_image AS lead_image_17, t0.lead AS lead_18, t0.created AS created_19, t0.updated AS updated_20, t0.parent_id AS parent_id_21, t0.template_id AS template_id_22 FROM page t0 WHERE t0.in_menu = ? AND t0.parent_id IS NULL AND t0.enabled = ? ORDER BY t0.position DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enabled AS enabled_4,
  t0.in_menu AS in_menu_5,
  t0.in_footer_menu AS in_footer_menu_6,
  t0.menu_name AS menu_name_7,
  t0.position AS position_8,
  t0.redirect AS redirect_9,
  t0.title AS title_10,
  t0.content AS content_11,
  t0.image AS image_12,
  t0.image2 AS image2_13,
  t0.keywords AS keywords_14,
  t0.meta_title AS meta_title_15,
  t0.meta_desc AS meta_desc_16,
  t0.lead_image AS lead_image_17,
  t0.lead AS lead_18,
  t0.created AS created_19,
  t0.updated AS updated_20,
  t0.parent_id AS parent_id_21,
  t0.template_id AS template_id_22
FROM
  page t0
WHERE
  t0.in_menu = ?
  AND t0.parent_id IS NULL
  AND t0.enabled = ?
ORDER BY
  t0.position DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.image2 AS image2_13, t0.keywords AS keywords_14, t0.meta_title AS meta_title_15, t0.meta_desc AS meta_desc_16, t0.lead_image AS lead_image_17, t0.lead AS lead_18, t0.created AS created_19, t0.updated AS updated_20, t0.parent_id AS parent_id_21, t0.template_id AS template_id_22 FROM page t0 WHERE t0.in_menu = 1 AND t0.parent_id IS NULL AND t0.enabled = 1 ORDER BY t0.position DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 241)
4	App\Controller\PageController->_menu (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 604)
12	__TwigTemplate_91aa281ff6bca36d8c78e7d60fdaea99->block_pageheader (line 432)
13	Twig\Template->yieldBlock (line 438)
14	__TwigTemplate_91aa281ff6bca36d8c78e7d60fdaea99->block_main (line 432)
15	Twig\Template->yieldBlock (line 150)
16	__TwigTemplate_91aa281ff6bca36d8c78e7d60fdaea99->doDisplay (line 388)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_67a9aa68b4d2dd6798be84ed7966bec6->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 93)
27	App\Controller\ApplicationController->newpdf (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 86)
31	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
33	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	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.

Entities Mapping

Class	Mapping errors
App\Entity\Application	No errors.
App\Entity\Settings	No errors.
App\Entity\Page	No errors.
App\Entity\Template	No errors.
App\Entity\Attachment	No errors.

Symfony Profiler

GET https://sep.dev.biolabs.pl/_fragment?_path=_format%3Dhtml%26_locale%3Dpl%26_controller%3DApp%255CController%255CPageController%253A%253A_menu

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping