Symfony Profiler

Query Metrics

23 Database Queries

3 Different statements

17.97 ms Query time

0 Invalid entities

55 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.46 ms
(74.90%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3, t0.html_content AS html_content_4, t0.article_description AS article_description_5, t0.article_preview_slideshow_html AS article_preview_slideshow_html_6, t0.article_tag_ids AS article_tag_ids_7, t0.article AS article_8, t0.hide_current_information AS hide_current_information_9, t0.visibility AS visibility_10, t0.author AS author_11, t0.article_section AS article_section_12, t0.creation_time AS creation_time_13, t0.edit_time AS edit_time_14 FROM pages t0 WHERE t0.path = ? LIMIT 1

Parameters:

[
  "landesverband"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.path AS path_3,
  t0.html_content AS html_content_4,
  t0.article_description AS article_description_5,
  t0.article_preview_slideshow_html AS article_preview_slideshow_html_6,
  t0.article_tag_ids AS article_tag_ids_7,
  t0.article AS article_8,
  t0.hide_current_information AS hide_current_information_9,
  t0.visibility AS visibility_10,
  t0.author AS author_11,
  t0.article_section AS article_section_12,
  t0.creation_time AS creation_time_13,
  t0.edit_time AS edit_time_14
FROM
  pages t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3, t0.html_content AS html_content_4, t0.article_description AS article_description_5, t0.article_preview_slideshow_html AS article_preview_slideshow_html_6, t0.article_tag_ids AS article_tag_ids_7, t0.article AS article_8, t0.hide_current_information AS hide_current_information_9, t0.visibility AS visibility_10, t0.author AS author_11, t0.article_section AS article_section_12, t0.creation_time AS creation_time_13, t0.edit_time AS edit_time_14 FROM pages t0 WHERE t0.path = 'landesverband' 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\Twig\MenuExtension->canViewPath (line 84)
5	App\Twig\MenuExtension->filterAccessibleItems (line 57)
6	App\Twig\MenuExtension->getMainMenuTree (line 35)
7	__TwigTemplate_7a0b95824f2c8e68b6ebe8b62db58bbb->doDisplay (line 48)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_244bab0b71725819227e05112d85d82b->doDisplay (line 104)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_ca16d9beb9434001bbe8d70b963f4fea->doDisplay (line 54)
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 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\SecurityController->login (line 19)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

3.87 ms
(21.55%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.target_path AS target_path_2, m0_.sort_order AS sort_order_3, m1_.id AS id_4, m1_.name AS name_5, m1_.target_path AS target_path_6, m1_.sort_order AS sort_order_7, m0_.parent_id AS parent_id_8, m1_.parent_id AS parent_id_9 FROM Menu m0_ LEFT JOIN Menu m1_ ON m0_.parent_id = m1_.id ORDER BY m0_.sort_order ASC, m0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.target_path AS target_path_2,
  m0_.sort_order AS sort_order_3,
  m1_.id AS id_4,
  m1_.name AS name_5,
  m1_.target_path AS target_path_6,
  m1_.sort_order AS sort_order_7,
  m0_.parent_id AS parent_id_8,
  m1_.parent_id AS parent_id_9
FROM
  Menu m0_
  LEFT JOIN Menu m1_ ON m0_.parent_id = m1_.id
ORDER BY
  m0_.sort_order ASC,
  m0_.id ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.target_path AS target_path_2, m0_.sort_order AS sort_order_3, m1_.id AS id_4, m1_.name AS name_5, m1_.target_path AS target_path_6, m1_.sort_order AS sort_order_7, m0_.parent_id AS parent_id_8, m1_.parent_id AS parent_id_9 FROM Menu m0_ LEFT JOIN Menu m1_ ON m0_.parent_id = m1_.id ORDER BY m0_.sort_order ASC, m0_.id 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->getResult (line 688)
6	App\Repository\MenuRepository->findMenuTree (line 32)
7	App\Twig\MenuExtension->getMainMenuTree (line 36)
8	__TwigTemplate_7a0b95824f2c8e68b6ebe8b62db58bbb->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_244bab0b71725819227e05112d85d82b->doDisplay (line 104)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_ca16d9beb9434001bbe8d70b963f4fea->doDisplay (line 54)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
21	App\Controller\SecurityController->login (line 19)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.64 ms
(3.54%)

SELECT t0.id AS id_1, t0.slot_key AS slot_key_2, t0.label AS label_3, t0.html_content AS html_content_4, t0.author AS author_5, t0.creation_time AS creation_time_6, t0.edit_time AS edit_time_7 FROM specialPages t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slot_key AS slot_key_2,
  t0.label AS label_3,
  t0.html_content AS html_content_4,
  t0.author AS author_5,
  t0.creation_time AS creation_time_6,
  t0.edit_time AS edit_time_7
FROM
  specialPages t0

SELECT t0.id AS id_1, t0.slot_key AS slot_key_2, t0.label AS label_3, t0.html_content AS html_content_4, t0.author AS author_5, t0.creation_time AS creation_time_6, t0.edit_time AS edit_time_7 FROM specialPages t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Repository\SpecialPageRepository->getContentMap (line 26)
6	App\Twig\SpecialPageExtension->getContentMap (line 83)
7	App\Twig\SpecialPageExtension->getSpecialPageContent (line 46)
8	__TwigTemplate_7a0b95824f2c8e68b6ebe8b62db58bbb->doDisplay (line 52)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_244bab0b71725819227e05112d85d82b->doDisplay (line 104)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_ca16d9beb9434001bbe8d70b963f4fea->doDisplay (line 54)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
21	App\Controller\SecurityController->login (line 19)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	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\Menu	23
App\Entity\SpecialPage	17
App\Entity\Page	15

Entities Mapping

Class	Mapping errors
App\Entity\Menu	No errors.
App\Entity\Page	No errors.
App\Entity\SpecialPage	No errors.

Symfony Profiler

GET https://fw-demoserver-1.de/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping