Symfony Profiler

Query Metrics

11 Database Queries

8 Different statements

3.49 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.81 ms
(23.05%)

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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 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.lead_image AS lead_image_15,
  t0.lead AS lead_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.parent_id AS parent_id_19,
  t0.template_id AS template_id_20
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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.parent_id = 4 ORDER BY t0.position DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3304)
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 128)
8	__TwigTemplate_4dacd3495170ac8e41ecc91d4cad158b->doDisplay (line 360)
9	Twig\Template->yield (line 335)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 307)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 233)
16	App\Controller\PageController->_menu (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
20	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
21	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
22	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
23	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 556)
24	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_pageheader (line 430)
25	Twig\Template->yieldBlock (line 395)
26	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_main (line 430)
27	Twig\Template->yieldBlock (line 141)
28	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->doDisplay (line 360)
29	Twig\Template->yield (line 50)
30	__TwigTemplate_0b37ab79532949e5ed6220cf6a391b4a->doDisplay (line 360)
31	Twig\Template->yield (line 335)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 307)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 153)
38	App\Controller\PageController->page (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 86)
42	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
44	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
46	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
47	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
48	Symfony\Component\HttpKernel\Kernel->handle (line 35)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
50	require_once (line 5)

0.54 ms
(15.42%)

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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.parent_id = ? 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.lead_image AS lead_image_15,
  t0.lead AS lead_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.parent_id AS parent_id_19,
  t0.template_id AS template_id_20
FROM
  PAGE t0
WHERE
  t0.parent_id = ?
  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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.parent_id = 21 AND t0.enabled = 1 ORDER BY t0.position DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	App\Controller\PageController->page (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
9	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
10	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
11	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.49 ms
(14.05%)

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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "pomiary-elektryczne-w-praktyce"
]

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.lead_image AS lead_image_15,
  t0.lead AS lead_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.parent_id AS parent_id_19,
  t0.template_id AS template_id_20
FROM
  PAGE t0
WHERE
  t0.url = ?
LIMIT
  1

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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.url = 'pomiary-elektryczne-w-praktyce' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 238)
4	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->findOneBy (line 93)
5	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
6	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
7	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
8	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.44 ms
(12.71%)

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 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 25)
5	App\Service\SettingsService->get (line 1629)
6	Twig\Extension\CoreExtension::getAttribute (line 300)
7	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_main (line 430)
8	Twig\Template->yieldBlock (line 141)
9	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->doDisplay (line 360)
10	Twig\Template->yield (line 50)
11	__TwigTemplate_0b37ab79532949e5ed6220cf6a391b4a->doDisplay (line 360)
12	Twig\Template->yield (line 335)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 307)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 153)
19	App\Controller\PageController->page (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
25	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.32 ms
(9.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.filename AS filename_4, t0.code AS code_5 FROM template t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.filename AS filename_4,
  t0.code AS code_5
FROM
  template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.filename AS filename_4, t0.code AS code_5 FROM template t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\Template->__get (line 91)
7	App\Entity\Template->getFilename (line 112)
8	App\Controller\PageController->page (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
14	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.31 ms
(8.93%)

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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 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.lead_image AS lead_image_15,
  t0.lead AS lead_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.parent_id AS parent_id_19,
  t0.template_id AS template_id_20
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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 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 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 229)
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 556)
12	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_pageheader (line 430)
13	Twig\Template->yieldBlock (line 395)
14	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_main (line 430)
15	Twig\Template->yieldBlock (line 141)
16	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->doDisplay (line 360)
17	Twig\Template->yield (line 50)
18	__TwigTemplate_0b37ab79532949e5ed6220cf6a391b4a->doDisplay (line 360)
19	Twig\Template->yield (line 335)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 307)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 153)
26	App\Controller\PageController->page (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
32	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.31 ms
(8.82%)

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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.in_footer_menu = ? AND t0.enabled = ? ORDER BY t0.position DESC LIMIT 15

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.lead_image AS lead_image_15,
  t0.lead AS lead_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.parent_id AS parent_id_19,
  t0.template_id AS template_id_20
FROM
  PAGE t0
WHERE
  t0.in_footer_menu = ?
  AND t0.enabled = ?
ORDER BY
  t0.position DESC
LIMIT
  15

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.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.in_footer_menu = 1 AND t0.enabled = 1 ORDER BY t0.position DESC LIMIT 15;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 239)
4	App\Controller\PageController->_footerMenu (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 700)
12	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_footer (line 430)
13	Twig\Template->yieldBlock (line 410)
14	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_main (line 430)
15	Twig\Template->yieldBlock (line 141)
16	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->doDisplay (line 360)
17	Twig\Template->yield (line 50)
18	__TwigTemplate_0b37ab79532949e5ed6220cf6a391b4a->doDisplay (line 360)
19	Twig\Template->yield (line 335)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 307)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 153)
26	App\Controller\PageController->page (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
32	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.27 ms
(7.87%)

SELECT t0.id AS id_1, t0.document AS document_2, t0.info AS info_3, t0.created AS created_4, t0.updated AS updated_5, t0.page_id AS page_id_6, t0.tile_id AS tile_id_7, t0.application_id AS application_id_8 FROM attachment 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.document AS document_2,
  t0.info AS info_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.page_id AS page_id_6,
  t0.tile_id AS tile_id_7,
  t0.application_id AS application_id_8
FROM
  attachment t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.document AS document_2, t0.info AS info_3, t0.created AS created_4, t0.updated AS updated_5, t0.page_id AS page_id_6, t0.tile_id AS tile_id_7, t0.application_id AS application_id_8 FROM attachment t0 WHERE t0.page_id = 21;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3304)
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 328)
8	__TwigTemplate_0b37ab79532949e5ed6220cf6a391b4a->block_content (line 430)
9	Twig\Template->yieldBlock (line 405)
10	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_main (line 430)
11	Twig\Template->yieldBlock (line 141)
12	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_0b37ab79532949e5ed6220cf6a391b4a->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 153)
22	App\Controller\PageController->page (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
28	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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.

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Template	No errors.
App\Entity\Attachment	No errors.
App\Entity\Settings	No errors.
App\Entity\Tile	No errors.
App\Entity\Application	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.
App\Entity\Payment	No errors.
App\Entity\Event	No errors.
App\Entity\EventMember	No errors.
App\Entity\EventMemberHistory	No errors.
App\Entity\MessageLog	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Newsletter	No errors.
App\Entity\Slide	No errors.
App\Entity\Partner	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping