Symfony Profiler

Query Metrics

28 Database Queries

7 Different statements

27.43 ms Query time

0 Invalid entities

62 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.16 ms
(77.13%)

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:

[
  "artikel/nmz-2017-12"
]

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 = 'artikel/nmz-2017-12' 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.59 ms
(5.79%)

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)

1.53 ms
(5.59%)

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 (?) AND ((p0_.creation_time < ? OR (p0_.creation_time = ? AND p0_.id < ?))) ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 1

Parameters:

[
  1
  "artikel"
  "all"
  "2017-12-01 00:00:00"
  "2017-12-01 00:00:00"
  121
]

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 (?)
  AND (
    (
      p0_.creation_time < ?
      OR (
        p0_.creation_time = ?
        AND p0_.id < ?
      )
    )
  )
ORDER BY
  p0_.creation_time DESC,
  p0_.edit_time DESC,
  p0_.id DESC
LIMIT
  1

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') AND ((p0_.creation_time < '2017-12-01 00:00:00' OR (p0_.creation_time = '2017-12-01 00:00:00' AND p0_.id < 121))) ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\PageRepository->findPreviousVisibleArticle (line 106)
7	App\Controller\PagesController->show (line 41)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.33 ms
(4.84%)

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)

0.84 ms
(3.05%)

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 (?) AND ((p0_.creation_time > ? OR (p0_.creation_time = ? AND p0_.id > ?))) ORDER BY p0_.creation_time ASC, p0_.id ASC LIMIT 1

Parameters:

[
  1
  "artikel"
  "all"
  "2017-12-01 00:00:00"
  "2017-12-01 00:00:00"
  121
]

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 (?)
  AND (
    (
      p0_.creation_time > ?
      OR (
        p0_.creation_time = ?
        AND p0_.id > ?
      )
    )
  )
ORDER BY
  p0_.creation_time ASC,
  p0_.id ASC
LIMIT
  1

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') AND ((p0_.creation_time > '2017-12-01 00:00:00' OR (p0_.creation_time = '2017-12-01 00:00:00' AND p0_.id > 121))) ORDER BY p0_.creation_time ASC, p0_.id ASC LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\PageRepository->findNextVisibleArticle (line 133)
7	App\Controller\PagesController->show (line 42)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.51 ms
(1.86%)

SELECT a0_.id AS id_0, a0_.name AS name_1 FROM article_tag a0_ WHERE a0_.id IN (?) ORDER BY a0_.name ASC, a0_.id ASC

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1
FROM
  article_tag a0_
WHERE
  a0_.id IN (?)
ORDER BY
  a0_.name ASC,
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.name AS name_1 FROM article_tag a0_ WHERE a0_.id IN (6) ORDER BY a0_.name ASC, a0_.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\ArticleTagRepository->findByIdsOrderedByName (line 49)
7	App\Controller\PagesController->resolveArticleTags (line 69)
8	App\Controller\PagesController->show (line 44)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.48 ms
(1.74%)

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)

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	21
App\Entity\SpecialPage	17
App\Entity\ArticleTag	1

Entities Mapping

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

Symfony Profiler

GET https://www.fw-demoserver-1.de/artikel/nmz-2017-12

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping