Symfony Profiler

Query Metrics

27 Database Queries

7 Different statements

19.17 ms Query time

0 Invalid entities

77 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.61 ms
(60.58%)

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_d66e5f6227ffe7162b37be9c50614d08->doDisplay (line 56)
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\ArticleController->renderArticleList (line 173)
21	App\Controller\ArticleController->index (line 31)
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.89 ms
(9.88%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM article_tag t0 ORDER BY t0.name ASC, t0.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  article_tag t0
ORDER BY
  t0.name ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2 FROM article_tag t0 ORDER BY t0.name ASC, 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\ArticleTagRepository->findAllOrderedByName (line 25)
5	App\Controller\ArticleController->renderArticleList (line 104)
6	App\Controller\ArticleController->index (line 31)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

1.88 ms
(9.83%)

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_.article_tag_ids = ? OR p0_.article_tag_ids LIKE ? OR p0_.article_tag_ids LIKE ? OR p0_.article_tag_ids LIKE ?)) ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 20

Parameters:

[
  1
  "artikel"
  "all"
  "[6]"
  "[6,%"
  "%,6,%"
  "%,6]"
]

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_.article_tag_ids = ?
      OR p0_.article_tag_ids LIKE ?
      OR p0_.article_tag_ids LIKE ?
      OR p0_.article_tag_ids LIKE ?
    )
  )
ORDER BY
  p0_.creation_time DESC,
  p0_.edit_time DESC,
  p0_.id DESC
LIMIT
  20

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_.article_tag_ids = '[6]' OR p0_.article_tag_ids LIKE '[6,%' OR p0_.article_tag_ids LIKE '%,6,%' OR p0_.article_tag_ids LIKE '%,6]')) ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 20;

#	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->findVisibleArticlesPaginated (line 62)
7	App\Controller\ArticleController->renderArticleList (line 157)
8	App\Controller\ArticleController->index (line 31)
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)

1.77 ms
(9.23%)

SELECT DISTINCT p0_.author AS author_0 FROM pages p0_ WHERE p0_.article = ? AND p0_.path <> ? AND p0_.visibility IN (?) AND p0_.author IS NOT NULL AND TRIM(p0_.author) <> ? ORDER BY p0_.author ASC

Parameters:

[
  1
  "artikel"
  "all"
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.author AS author_0
FROM
  pages p0_
WHERE
  p0_.article = ?
  AND p0_.path <> ?
  AND p0_.visibility IN (?)
  AND p0_.author IS NOT NULL
  AND TRIM(p0_.author) <> ?
ORDER BY
  p0_.author ASC

SELECT DISTINCT p0_.author AS author_0 FROM pages p0_ WHERE p0_.article = 1 AND p0_.path <> 'artikel' AND p0_.visibility IN ('all') AND p0_.author IS NOT NULL AND TRIM(p0_.author) <> '' ORDER BY p0_.author 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->getArrayResult (line 700)
6	App\Repository\PageRepository->findVisibleArticleAuthors (line 155)
7	App\Controller\ArticleController->renderArticleList (line 105)
8	App\Controller\ArticleController->index (line 31)
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.77 ms
(4.02%)

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_d66e5f6227ffe7162b37be9c50614d08->doDisplay (line 56)
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\ArticleController->renderArticleList (line 173)
22	App\Controller\ArticleController->index (line 31)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.65 ms
(3.37%)

SELECT COUNT(p0_.id) AS sclr_0 FROM pages p0_ WHERE p0_.article = ? AND p0_.path <> ? AND p0_.visibility IN (?) AND ((p0_.article_tag_ids = ? OR p0_.article_tag_ids LIKE ? OR p0_.article_tag_ids LIKE ? OR p0_.article_tag_ids LIKE ?))

Parameters:

[
  1
  "artikel"
  "all"
  "[6]"
  "[6,%"
  "%,6,%"
  "%,6]"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  pages p0_
WHERE
  p0_.article = ?
  AND p0_.path <> ?
  AND p0_.visibility IN (?)
  AND (
    (
      p0_.article_tag_ids = ?
      OR p0_.article_tag_ids LIKE ?
      OR p0_.article_tag_ids LIKE ?
      OR p0_.article_tag_ids LIKE ?
    )
  )

SELECT COUNT(p0_.id) AS sclr_0 FROM pages p0_ WHERE p0_.article = 1 AND p0_.path <> 'artikel' AND p0_.visibility IN ('all') AND ((p0_.article_tag_ids = '[6]' OR p0_.article_tag_ids LIKE '[6,%' OR p0_.article_tag_ids LIKE '%,6,%' OR p0_.article_tag_ids LIKE '%,6]'));

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\PageRepository->findVisibleArticlesPaginated (line 49)
8	App\Controller\ArticleController->renderArticleList (line 157)
9	App\Controller\ArticleController->index (line 31)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.59 ms
(3.10%)

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_d66e5f6227ffe7162b37be9c50614d08->doDisplay (line 56)
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\ArticleController->renderArticleList (line 173)
22	App\Controller\ArticleController->index (line 31)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Page	35
App\Entity\Menu	23
App\Entity\SpecialPage	17
App\Entity\ArticleTag	2

Entities Mapping

Class	Mapping errors
App\Entity\ArticleTag	No 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/nachrichten?tag%5B0%5D=6

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping