Symfony Profiler

Query Metrics

25 Database Queries

4 Different statements

13.24 ms Query time

0 Invalid entities

58 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.80 ms
(66.51%)

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:

[
  "bezirksgruppen"
]

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 = 'bezirksgruppen' 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->show (line 24)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

1.92 ms
(14.50%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.path AS path_2, p0_.html_content AS html_content_3, p0_.article_description AS article_description_4, p0_.article_preview_slideshow_html AS article_preview_slideshow_html_5, p0_.article_tag_ids AS article_tag_ids_6, p0_.article AS article_7, p0_.hide_current_information AS hide_current_information_8, p0_.visibility AS visibility_9, p0_.author AS author_10, p0_.article_section AS article_section_11, p0_.creation_time AS creation_time_12, p0_.edit_time AS edit_time_13 FROM pages p0_ WHERE p0_.article = ? AND p0_.path <> ? AND p0_.visibility IN (?) ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 3

Parameters:

[
  1
  "artikel"
  "all"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.path AS path_2,
  p0_.html_content AS html_content_3,
  p0_.article_description AS article_description_4,
  p0_.article_preview_slideshow_html AS article_preview_slideshow_html_5,
  p0_.article_tag_ids AS article_tag_ids_6,
  p0_.article AS article_7,
  p0_.hide_current_information AS hide_current_information_8,
  p0_.visibility AS visibility_9,
  p0_.author AS author_10,
  p0_.article_section AS article_section_11,
  p0_.creation_time AS creation_time_12,
  p0_.edit_time AS edit_time_13
FROM
  pages p0_
WHERE
  p0_.article = ?
  AND p0_.path <> ?
  AND p0_.visibility IN (?)
ORDER BY
  p0_.creation_time DESC,
  p0_.edit_time DESC,
  p0_.id DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.path AS path_2, p0_.html_content AS html_content_3, p0_.article_description AS article_description_4, p0_.article_preview_slideshow_html AS article_preview_slideshow_html_5, p0_.article_tag_ids AS article_tag_ids_6, p0_.article AS article_7, p0_.hide_current_information AS hide_current_information_8, p0_.visibility AS visibility_9, p0_.author AS author_10, p0_.article_section AS article_section_11, p0_.creation_time AS creation_time_12, p0_.edit_time AS edit_time_13 FROM pages p0_ WHERE p0_.article = 1 AND p0_.path <> 'artikel' AND p0_.visibility IN ('all') ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 3;

#	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\PageRepository->findLatestVisibleArticles (line 87)
7	App\Twig\SpecialPageExtension->getCurrentInformationBoxData (line 63)
8	__TwigTemplate_244bab0b71725819227e05112d85d82b->doDisplay (line 121)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_76e3c2946708f25b442818fd4f904892->doDisplay (line 55)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
19	App\Controller\PagesController->show (line 47)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 191)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

1.83 ms
(13.85%)

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_76e3c2946708f25b442818fd4f904892->doDisplay (line 55)
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\PagesController->show (line 47)
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.68 ms
(5.14%)

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_76e3c2946708f25b442818fd4f904892->doDisplay (line 55)
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\PagesController->show (line 47)
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\Page	18
App\Entity\SpecialPage	17

Entities Mapping

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

Symfony Profiler

GET https://www.fw-demoserver-1.de/bezirksgruppen

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping