Symfony Profiler

Query Metrics

25 Database Queries

5 Different statements

12.73 ms Query time

0 Invalid entities

60 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.66 ms
(67.99%)

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_e4460668f2b2d5c59867455b23c40e1f->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\HomepageController->show (line 20)
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)

1.83 ms
(14.37%)

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_e4460668f2b2d5c59867455b23c40e1f->doDisplay (line 54)
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\HomepageController->show (line 20)
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.22 ms
(9.60%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.qrcode AS qrcode_4 FROM socialMedia t0 ORDER BY t0.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.qrcode AS qrcode_4
FROM
  socialMedia t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.qrcode AS qrcode_4 FROM socialMedia t0 ORDER BY t0.id ASC;

#	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	App\Repository\SocialMediaRepository->findForHomepage (line 24)
5	App\Controller\HomepageController->show (line 21)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.52 ms
(4.08%)

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_e4460668f2b2d5c59867455b23c40e1f->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\HomepageController->show (line 20)
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.50 ms
(3.97%)

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_e4460668f2b2d5c59867455b23c40e1f->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\HomepageController->show (line 20)
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
App\Entity\SocialMedia	2

Entities Mapping

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

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping