Symfony Profiler

Query Metrics

37 Database Queries

21 Different statements

11.17 ms Query time

0 Invalid entities

55 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.34 ms
(12.02%)

SELECT t0.id AS id_1, t0.token AS token_2, t0.name AS name_3, t0.ext AS ext_4, t0.path AS path_5, t0.browser AS browser_6, t0.locked AS locked_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.alt AS alt_12, t0.image AS image_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.folder_id AS folder_id_18, t0.resize_parent_id AS resize_parent_id_19 FROM file t0 WHERE t0.id = ?

Parameters:

[
  "27"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.name AS name_3,
  t0.ext AS ext_4,
  t0.path AS path_5,
  t0.browser AS browser_6,
  t0.locked AS locked_7,
  t0.mime_type AS mime_type_8,
  t0.size AS size_9,
  t0.width AS width_10,
  t0.height AS height_11,
  t0.alt AS alt_12,
  t0.image AS image_13,
  t0.created_at AS created_at_14,
  t0.created_by AS created_by_15,
  t0.updated_at AS updated_at_16,
  t0.updated_by AS updated_by_17,
  t0.folder_id AS folder_id_18,
  t0.resize_parent_id AS resize_parent_id_19
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.name AS name_3, t0.ext AS ext_4, t0.path AS path_5, t0.browser AS browser_6, t0.locked AS locked_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.alt AS alt_12, t0.image AS image_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.folder_id AS folder_id_18, t0.resize_parent_id AS resize_parent_id_19 FROM file t0 WHERE t0.id = '27';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	OHMedia\SettingsBundle\Service\Settings->get (line 73)
7	OHMedia\MetaBundle\Settings\MetaSettings->getImage (line 37)
8	OHMedia\MetaBundle\Twig\MetaExtension->initSettings (line 73)
9	OHMedia\MetaBundle\Twig\MetaExtension->renderMeta (line 85)
10	OHMedia\MetaBundle\Twig\MetaExtension->getMetaEntity (line 54)
11	__TwigTemplate_e3613d7389376aa0dc6e02191e9bb539->doDisplay (line 48)
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	OHMedia\PageBundle\Twig\PageExtension->meta (line 83)
18	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->block_meta (line 182)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 66)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
31	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 197)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
37	require_once (line 5)

1.28 ms
(11.48%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.order_local AS order_local_4, t0.order_global AS order_global_5, t0.new_window AS new_window_6, t0.hidden AS hidden_7, t0.locked AS locked_8, t0.published AS published_9, t0.nesting_level AS nesting_level_10, t0.path AS path_11, t0.parent_slug AS parent_slug_12, t0.homepage AS homepage_13, t0.noindex AS noindex_14, t0.redirect_type AS redirect_type_15, t0.redirect_external AS redirect_external_16, t0.nav_text AS nav_text_17, t0.dynamic AS dynamic_18, t0.sitemap AS sitemap_19, t0.dropdown_text AS dropdown_text_20, t0.locked_user_types AS locked_user_types_21, t0.dropdown_only AS dropdown_only_22, t0.created_at AS created_at_23, t0.created_by AS created_by_24, t0.updated_at AS updated_at_25, t0.updated_by AS updated_by_26, t0.parent_id AS parent_id_27, t0.canonical_id AS canonical_id_28, t0.meta_id AS meta_id_29, t0.redirect_internal_id AS redirect_internal_id_30 FROM page t0 WHERE t0.path = ? LIMIT 1

Parameters:

[
  "news"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.order_local AS order_local_4,
  t0.order_global AS order_global_5,
  t0.new_window AS new_window_6,
  t0.hidden AS hidden_7,
  t0.locked AS locked_8,
  t0.published AS published_9,
  t0.nesting_level AS nesting_level_10,
  t0.path AS path_11,
  t0.parent_slug AS parent_slug_12,
  t0.homepage AS homepage_13,
  t0.noindex AS noindex_14,
  t0.redirect_type AS redirect_type_15,
  t0.redirect_external AS redirect_external_16,
  t0.nav_text AS nav_text_17,
  t0.dynamic AS dynamic_18,
  t0.sitemap AS sitemap_19,
  t0.dropdown_text AS dropdown_text_20,
  t0.locked_user_types AS locked_user_types_21,
  t0.dropdown_only AS dropdown_only_22,
  t0.created_at AS created_at_23,
  t0.created_by AS created_by_24,
  t0.updated_at AS updated_at_25,
  t0.updated_by AS updated_by_26,
  t0.parent_id AS parent_id_27,
  t0.canonical_id AS canonical_id_28,
  t0.meta_id AS meta_id_29,
  t0.redirect_internal_id AS redirect_internal_id_30
FROM
  page t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.order_local AS order_local_4, t0.order_global AS order_global_5, t0.new_window AS new_window_6, t0.hidden AS hidden_7, t0.locked AS locked_8, t0.published AS published_9, t0.nesting_level AS nesting_level_10, t0.path AS path_11, t0.parent_slug AS parent_slug_12, t0.homepage AS homepage_13, t0.noindex AS noindex_14, t0.redirect_type AS redirect_type_15, t0.redirect_external AS redirect_external_16, t0.nav_text AS nav_text_17, t0.dynamic AS dynamic_18, t0.sitemap AS sitemap_19, t0.dropdown_text AS dropdown_text_20, t0.locked_user_types AS locked_user_types_21, t0.dropdown_only AS dropdown_only_22, t0.created_at AS created_at_23, t0.created_by AS created_by_24, t0.updated_at AS updated_at_25, t0.updated_by AS updated_by_26, t0.parent_id AS parent_id_27, t0.canonical_id AS canonical_id_28, t0.meta_id AS meta_id_29, t0.redirect_internal_id AS redirect_internal_id_30 FROM page t0 WHERE t0.path = 'news' 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	OHMedia\PageBundle\Service\PageRenderer->setCurrentPageFromPath (line 131)
5	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 21)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.89 ms
(7.95%)

SELECT t0.id AS id_1, t0.token AS token_2, t0.name AS name_3, t0.ext AS ext_4, t0.path AS path_5, t0.browser AS browser_6, t0.locked AS locked_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.alt AS alt_12, t0.image AS image_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.folder_id AS folder_id_18, t0.resize_parent_id AS resize_parent_id_19 FROM file t0 WHERE t0.resize_parent_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.name AS name_3,
  t0.ext AS ext_4,
  t0.path AS path_5,
  t0.browser AS browser_6,
  t0.locked AS locked_7,
  t0.mime_type AS mime_type_8,
  t0.size AS size_9,
  t0.width AS width_10,
  t0.height AS height_11,
  t0.alt AS alt_12,
  t0.image AS image_13,
  t0.created_at AS created_at_14,
  t0.created_by AS created_by_15,
  t0.updated_at AS updated_at_16,
  t0.updated_by AS updated_by_17,
  t0.folder_id AS folder_id_18,
  t0.resize_parent_id AS resize_parent_id_19
FROM
  file t0
WHERE
  t0.resize_parent_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.name AS name_3, t0.ext AS ext_4, t0.path AS path_5, t0.browser AS browser_6, t0.locked AS locked_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.alt AS alt_12, t0.image AS image_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.folder_id AS folder_id_18, t0.resize_parent_id AS resize_parent_id_19 FROM file t0 WHERE t0.resize_parent_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	OHMedia\FileBundle\Entity\File->getResize (line 345)
8	OHMedia\FileBundle\Service\ImageManager->getResize (line 156)
9	OHMedia\FileBundle\Service\ImageManager->setImageTagAttributes (line 112)
10	OHMedia\FileBundle\Service\ImageManager->render (line 71)
11	OHMedia\FileBundle\Twig\ImageExtension->getImageTag (line 33)
12	__TwigTemplate_918fb76d97cbbfe08f5010076282f9fd->doDisplay (line 160)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_7adef6bc66a0bad1d489a959d2dcd10e->doDisplay (line 48)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	OHMedia\NewsBundle\Twig\NewsExtension->news (line 135)
21	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
36	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 197)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
41	require_once (line 29)
42	require_once (line 5)

0.89 ms
(7.93%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM article_tag t0 INNER JOIN article_article_tag ON t0.id = article_article_tag.article_tag_id WHERE article_article_tag.article_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.updated_at AS updated_at_5,
  t0.updated_by AS updated_by_6,
  t0.slug AS slug_7
FROM
  article_tag t0
  INNER JOIN article_article_tag ON t0.id = article_article_tag.article_tag_id
WHERE
  article_article_tag.article_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM article_tag t0 INNER JOIN article_article_tag ON t0.id = article_article_tag.article_tag_id WHERE article_article_tag.article_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_918fb76d97cbbfe08f5010076282f9fd::doDisplay (line 231)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_7adef6bc66a0bad1d489a959d2dcd10e->doDisplay (line 48)
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	OHMedia\NewsBundle\Twig\NewsExtension->news (line 135)
18	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
33	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 197)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 29)
39	require_once (line 5)

0.71 ms
(6.38%)

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0 WHERE t0.id = ?

Parameters:

[
  "oh_media_script_head_open"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0 WHERE t0.id = 'oh_media_script_head_open';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	OHMedia\SettingsBundle\Service\Settings->getEntity (line 106)
6	OHMedia\SettingsBundle\Service\Settings->get (line 66)
7	OHMedia\BackendBundle\Twig\ScriptInjectionExtension->script (line 60)
8	OHMedia\BackendBundle\Twig\ScriptInjectionExtension->scriptHeadOpen (line 40)
9	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 61)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
20	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 197)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.59 ms
(5.24%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.created_by AS created_by_3, p0_.updated_at AS updated_at_4, p0_.updated_by AS updated_by_5, p0_.text AS text_6, p0_.type AS type_7, p0_.page_revision_id AS page_revision_id_8 FROM page_content_text p0_ WHERE p0_.page_revision_id = ? AND p0_.name = ? AND p0_.type = ? AND p0_.text IS NOT NULL AND p0_.text <> '' LIMIT 1

Parameters:

[
  4
  "title"
  "text"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.created_at AS created_at_2,
  p0_.created_by AS created_by_3,
  p0_.updated_at AS updated_at_4,
  p0_.updated_by AS updated_by_5,
  p0_.text AS text_6,
  p0_.type AS type_7,
  p0_.page_revision_id AS page_revision_id_8
FROM
  page_content_text p0_
WHERE
  p0_.page_revision_id = ?
  AND p0_.name = ?
  AND p0_.type = ?
  AND p0_.text IS NOT NULL
  AND p0_.text <> ''
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.created_by AS created_by_3, p0_.updated_at AS updated_at_4, p0_.updated_by AS updated_by_5, p0_.text AS text_6, p0_.type AS type_7, p0_.page_revision_id AS page_revision_id_8 FROM page_content_text p0_ WHERE p0_.page_revision_id = 4 AND p0_.name = 'title' AND p0_.type = 'text' AND p0_.text IS NOT NULL AND p0_.text <> '' 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	OHMedia\PageBundle\Twig\PageContentExtension->getContent (line 233)
7	OHMedia\PageBundle\Twig\PageContentExtension->renderContentText (line 167)
8	__TwigTemplate_918fb76d97cbbfe08f5010076282f9fd->doDisplay (line 79)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_7adef6bc66a0bad1d489a959d2dcd10e->doDisplay (line 48)
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	OHMedia\NewsBundle\Twig\NewsExtension->news (line 135)
17	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
32	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 197)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

0.54 ms
(4.84%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10 FROM article a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= ? AND a1_.slug IN (?) ORDER BY a0_.published_at DESC) dctrn_result) dctrn_table

Parameters:

[
  "2025-12-06 06:28:02"
  "nature"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.author AS author_2,
          a0_.snippet AS snippet_3,
          a0_.content AS content_4,
          a0_.published_at AS published_at_5,
          a0_.created_at AS created_at_6,
          a0_.created_by AS created_by_7,
          a0_.updated_at AS updated_at_8,
          a0_.updated_by AS updated_by_9,
          a0_.slug AS slug_10
        FROM
          article a0_
          INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id
          INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id
        WHERE
          a0_.published_at IS NOT NULL
          AND a0_.published_at <= ?
          AND a1_.slug IN (?)
        ORDER BY
          a0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10 FROM article a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= '2025-12-06 06:28:02' AND a1_.slug IN ('nature') ORDER BY a0_.published_at DESC) dctrn_result) dctrn_table;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	OHMedia\BootstrapBundle\Component\Pagination->__construct (line 27)
8	OHMedia\BootstrapBundle\Service\Paginator->paginate (line 28)
9	OHMedia\NewsBundle\Twig\NewsExtension->news (line 133)
10	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
25	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 197)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.49 ms
(4.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.order_local AS order_local_4, t0.order_global AS order_global_5, t0.new_window AS new_window_6, t0.hidden AS hidden_7, t0.locked AS locked_8, t0.published AS published_9, t0.nesting_level AS nesting_level_10, t0.path AS path_11, t0.parent_slug AS parent_slug_12, t0.homepage AS homepage_13, t0.noindex AS noindex_14, t0.redirect_type AS redirect_type_15, t0.redirect_external AS redirect_external_16, t0.nav_text AS nav_text_17, t0.dynamic AS dynamic_18, t0.sitemap AS sitemap_19, t0.dropdown_text AS dropdown_text_20, t0.locked_user_types AS locked_user_types_21, t0.dropdown_only AS dropdown_only_22, t0.created_at AS created_at_23, t0.created_by AS created_by_24, t0.updated_at AS updated_at_25, t0.updated_by AS updated_by_26, t0.parent_id AS parent_id_27, t0.canonical_id AS canonical_id_28, t0.meta_id AS meta_id_29, t0.redirect_internal_id AS redirect_internal_id_30 FROM page t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.order_local AS order_local_4,
  t0.order_global AS order_global_5,
  t0.new_window AS new_window_6,
  t0.hidden AS hidden_7,
  t0.locked AS locked_8,
  t0.published AS published_9,
  t0.nesting_level AS nesting_level_10,
  t0.path AS path_11,
  t0.parent_slug AS parent_slug_12,
  t0.homepage AS homepage_13,
  t0.noindex AS noindex_14,
  t0.redirect_type AS redirect_type_15,
  t0.redirect_external AS redirect_external_16,
  t0.nav_text AS nav_text_17,
  t0.dynamic AS dynamic_18,
  t0.sitemap AS sitemap_19,
  t0.dropdown_text AS dropdown_text_20,
  t0.locked_user_types AS locked_user_types_21,
  t0.dropdown_only AS dropdown_only_22,
  t0.created_at AS created_at_23,
  t0.created_by AS created_by_24,
  t0.updated_at AS updated_at_25,
  t0.updated_by AS updated_by_26,
  t0.parent_id AS parent_id_27,
  t0.canonical_id AS canonical_id_28,
  t0.meta_id AS meta_id_29,
  t0.redirect_internal_id AS redirect_internal_id_30
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.order_local AS order_local_4, t0.order_global AS order_global_5, t0.new_window AS new_window_6, t0.hidden AS hidden_7, t0.locked AS locked_8, t0.published AS published_9, t0.nesting_level AS nesting_level_10, t0.path AS path_11, t0.parent_slug AS parent_slug_12, t0.homepage AS homepage_13, t0.noindex AS noindex_14, t0.redirect_type AS redirect_type_15, t0.redirect_external AS redirect_external_16, t0.nav_text AS nav_text_17, t0.dynamic AS dynamic_18, t0.sitemap AS sitemap_19, t0.dropdown_text AS dropdown_text_20, t0.locked_user_types AS locked_user_types_21, t0.dropdown_only AS dropdown_only_22, t0.created_at AS created_at_23, t0.created_by AS created_by_24, t0.updated_at AS updated_at_25, t0.updated_by AS updated_by_26, t0.parent_id AS parent_id_27, t0.canonical_id AS canonical_id_28, t0.meta_id AS meta_id_29, t0.redirect_internal_id AS redirect_internal_id_30 FROM page t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	OHMedia\PageBundle\Twig\WysiwygExtension->href (line 27)
7	__TwigTemplate_428aeca0d80814047f07c8ec4b9fbe0c->doDisplay (line 51)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	OHMedia\WysiwygBundle\Service\Wysiwyg->render (line 161)
14	OHMedia\WysiwygBundle\Twig\WysiwygExtension->wysiwyg (line 26)
15	__TwigTemplate_6ef48fa1ae5d8866a24e2253835d3db4->doDisplay (line 211)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 192)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
30	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 197)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

0.48 ms
(4.33%)

SELECT t0.id AS id_1, t0.published AS published_2, t0.template AS template_3, t0.created_at AS created_at_4, t0.created_by AS created_by_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.page_id AS page_id_8 FROM page_revision t0 WHERE t0.page_id = ? ORDER BY t0.updated_at DESC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.published AS published_2,
  t0.template AS template_3,
  t0.created_at AS created_at_4,
  t0.created_by AS created_by_5,
  t0.updated_at AS updated_at_6,
  t0.updated_by AS updated_by_7,
  t0.page_id AS page_id_8
FROM
  page_revision t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.updated_at DESC

SELECT t0.id AS id_1, t0.published AS published_2, t0.template AS template_3, t0.created_at AS created_at_4, t0.created_by AS created_by_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.page_id AS page_id_8 FROM page_revision t0 WHERE t0.page_id = 4 ORDER BY t0.updated_at DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
7	OHMedia\PageBundle\Entity\Page->getPublishedPageRevisions (line 520)
8	OHMedia\PageBundle\Entity\Page->getCurrentPageRevision (line 527)
9	OHMedia\PageBundle\Service\PageRenderer->setCurrentPage (line 115)
10	OHMedia\PageBundle\Service\PageRenderer->setCurrentPageFromPath (line 136)
11	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 21)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.47 ms
(4.20%)

SELECT p.path
            FROM `page_revision` pr
            JOIN `page` p on p.id = pr.page_id
            WHERE p.published IS NOT NULL
            AND p.published < UTC_TIMESTAMP()
            AND p.dynamic = 1
            AND (p.homepage IS NULL OR p.homepage = 0)
            AND (
                SELECT pr_sub.id
                FROM `page_revision` pr_sub
                WHERE pr_sub.page_id = p.id
                AND pr_sub.published = 1
                ORDER BY pr_sub.updated_at DESC
                LIMIT 1
            ) = pr.id
            AND pr.template = ?

Parameters:

[
  "App\Form\Page\NewsPage"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.path
FROM
  `page_revision` pr
  JOIN `page` p on p.id = pr.page_id
WHERE
  p.published IS NOT NULL
  AND p.published < UTC_TIMESTAMP()
  AND p.dynamic = 1
  AND (
    p.homepage IS NULL
    OR p.homepage = 0
  )
  AND (
    SELECT
      pr_sub.id
    FROM
      `page_revision` pr_sub
    WHERE
      pr_sub.page_id = p.id
      AND pr_sub.published = 1
    ORDER BY
      pr_sub.updated_at DESC
    LIMIT
      1
  ) = pr.id
  AND pr.template = ?

SELECT p.path
            FROM `page_revision` pr
            JOIN `page` p on p.id = pr.page_id
            WHERE p.published IS NOT NULL
            AND p.published < UTC_TIMESTAMP()
            AND p.dynamic = 1
            AND (p.homepage IS NULL OR p.homepage = 0)
            AND (
                SELECT pr_sub.id
                FROM `page_revision` pr_sub
                WHERE pr_sub.page_id = p.id
                AND pr_sub.published = 1
                ORDER BY pr_sub.updated_at DESC
                LIMIT 1
            ) = pr.id
            AND pr.template = 'App\\Form\\Page\\NewsPage';

#	File/Call
1	OHMedia\PageBundle\Service\PageRawQuery->getPathWithTemplate (line 90)
2	OHMedia\NewsBundle\Twig\RSSExtension->rssLinkTag (line 35)
3	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_head_scripts (line 111)
4	Twig\Template->yieldBlock (line 446)
5	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 76)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
16	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 197)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.46 ms
(4.08%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.order_local AS order_local_3, p0_.order_global AS order_global_4, p0_.new_window AS new_window_5, p0_.hidden AS hidden_6, p0_.locked AS locked_7, p0_.published AS published_8, p0_.nesting_level AS nesting_level_9, p0_.path AS path_10, p0_.parent_slug AS parent_slug_11, p0_.homepage AS homepage_12, p0_.noindex AS noindex_13, p0_.redirect_type AS redirect_type_14, p0_.redirect_external AS redirect_external_15, p0_.nav_text AS nav_text_16, p0_.dynamic AS dynamic_17, p0_.sitemap AS sitemap_18, p0_.dropdown_text AS dropdown_text_19, p0_.locked_user_types AS locked_user_types_20, p0_.dropdown_only AS dropdown_only_21, p0_.created_at AS created_at_22, p0_.created_by AS created_by_23, p0_.updated_at AS updated_at_24, p0_.updated_by AS updated_by_25, p0_.parent_id AS parent_id_26, p0_.canonical_id AS canonical_id_27, p0_.meta_id AS meta_id_28, p0_.redirect_internal_id AS redirect_internal_id_29 FROM page p0_ WHERE p0_.hidden = 0 AND p0_.nesting_level <= ? AND p0_.published IS NOT NULL AND p0_.published <= ? AND ((SELECT COUNT(p1_.id) AS sclr_30 FROM page_revision p1_ WHERE p1_.page_id = p0_.id AND p1_.published = 1) > 0) ORDER BY p0_.order_global ASC

Parameters:

[
  3
  "2025-12-06 06:28:02"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.order_local AS order_local_3,
  p0_.order_global AS order_global_4,
  p0_.new_window AS new_window_5,
  p0_.hidden AS hidden_6,
  p0_.locked AS locked_7,
  p0_.published AS published_8,
  p0_.nesting_level AS nesting_level_9,
  p0_.path AS path_10,
  p0_.parent_slug AS parent_slug_11,
  p0_.homepage AS homepage_12,
  p0_.noindex AS noindex_13,
  p0_.redirect_type AS redirect_type_14,
  p0_.redirect_external AS redirect_external_15,
  p0_.nav_text AS nav_text_16,
  p0_.dynamic AS dynamic_17,
  p0_.sitemap AS sitemap_18,
  p0_.dropdown_text AS dropdown_text_19,
  p0_.locked_user_types AS locked_user_types_20,
  p0_.dropdown_only AS dropdown_only_21,
  p0_.created_at AS created_at_22,
  p0_.created_by AS created_by_23,
  p0_.updated_at AS updated_at_24,
  p0_.updated_by AS updated_by_25,
  p0_.parent_id AS parent_id_26,
  p0_.canonical_id AS canonical_id_27,
  p0_.meta_id AS meta_id_28,
  p0_.redirect_internal_id AS redirect_internal_id_29
FROM
  page p0_
WHERE
  p0_.hidden = 0
  AND p0_.nesting_level <= ?
  AND p0_.published IS NOT NULL
  AND p0_.published <= ?
  AND (
    (
      SELECT
        COUNT(p1_.id) AS sclr_30
      FROM
        page_revision p1_
      WHERE
        p1_.page_id = p0_.id
        AND p1_.published = 1
    ) > 0
  )
ORDER BY
  p0_.order_global ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.order_local AS order_local_3, p0_.order_global AS order_global_4, p0_.new_window AS new_window_5, p0_.hidden AS hidden_6, p0_.locked AS locked_7, p0_.published AS published_8, p0_.nesting_level AS nesting_level_9, p0_.path AS path_10, p0_.parent_slug AS parent_slug_11, p0_.homepage AS homepage_12, p0_.noindex AS noindex_13, p0_.redirect_type AS redirect_type_14, p0_.redirect_external AS redirect_external_15, p0_.nav_text AS nav_text_16, p0_.dynamic AS dynamic_17, p0_.sitemap AS sitemap_18, p0_.dropdown_text AS dropdown_text_19, p0_.locked_user_types AS locked_user_types_20, p0_.dropdown_only AS dropdown_only_21, p0_.created_at AS created_at_22, p0_.created_by AS created_by_23, p0_.updated_at AS updated_at_24, p0_.updated_by AS updated_by_25, p0_.parent_id AS parent_id_26, p0_.canonical_id AS canonical_id_27, p0_.meta_id AS meta_id_28, p0_.redirect_internal_id AS redirect_internal_id_29 FROM page p0_ WHERE p0_.hidden = 0 AND p0_.nesting_level <= 3 AND p0_.published IS NOT NULL AND p0_.published <= '2025-12-06 06:28:02' AND ((SELECT COUNT(p1_.id) AS sclr_30 FROM page_revision p1_ WHERE p1_.page_id = p0_.id AND p1_.published = 1) > 0) ORDER BY p0_.order_global 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	OHMedia\PageBundle\Twig\PageNavExtension->getNavPages (line 91)
7	OHMedia\PageBundle\Twig\PageNavExtension->getPageNav (line 69)
8	__TwigTemplate_a2ee7ab58c91b148093324df37f3e972->doDisplay (line 53)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 180)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
23	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.43 ms
(3.81%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10, a1_.id AS id_11, a1_.name AS name_12, a1_.created_at AS created_at_13, a1_.created_by AS created_by_14, a1_.updated_at AS updated_at_15, a1_.updated_by AS updated_by_16, a1_.slug AS slug_17 FROM article a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= ? AND a1_.slug IN (?)) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 12

Parameters:

[
  "2025-12-06 06:28:02"
  "nature"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_5
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.author AS author_2,
          a0_.snippet AS snippet_3,
          a0_.content AS content_4,
          a0_.published_at AS published_at_5,
          a0_.created_at AS created_at_6,
          a0_.created_by AS created_by_7,
          a0_.updated_at AS updated_at_8,
          a0_.updated_by AS updated_by_9,
          a0_.slug AS slug_10,
          a1_.id AS id_11,
          a1_.name AS name_12,
          a1_.created_at AS created_at_13,
          a1_.created_by AS created_by_14,
          a1_.updated_at AS updated_at_15,
          a1_.updated_by AS updated_by_16,
          a1_.slug AS slug_17
        FROM
          article a0_
          INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id
          INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id
        WHERE
          a0_.published_at IS NOT NULL
          AND a0_.published_at <= ?
          AND a1_.slug IN (?)
      ) dctrn_result_inner
    ORDER BY
      published_at_5 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10, a1_.id AS id_11, a1_.name AS name_12, a1_.created_at AS created_at_13, a1_.created_by AS created_by_14, a1_.updated_at AS updated_at_15, a1_.updated_by AS updated_by_16, a1_.slug AS slug_17 FROM article a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= '2025-12-06 06:28:02' AND a1_.slug IN ('nature')) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 12;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	__TwigTemplate_918fb76d97cbbfe08f5010076282f9fd->doDisplay (line 148)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_7adef6bc66a0bad1d489a959d2dcd10e->doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	OHMedia\NewsBundle\Twig\NewsExtension->news (line 135)
16	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
31	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 197)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
37	require_once (line 5)

0.37 ms
(3.32%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10, a0_.image_id AS image_id_11 FROM article a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= ? AND a1_.slug IN (?) AND a0_.id IN (?, ?, ?, ?) ORDER BY a0_.published_at DESC

Parameters:

[
  "2025-12-06 06:28:02"
  "nature"
  1
  2
  4
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.author AS author_2,
  a0_.snippet AS snippet_3,
  a0_.content AS content_4,
  a0_.published_at AS published_at_5,
  a0_.created_at AS created_at_6,
  a0_.created_by AS created_by_7,
  a0_.updated_at AS updated_at_8,
  a0_.updated_by AS updated_by_9,
  a0_.slug AS slug_10,
  a0_.image_id AS image_id_11
FROM
  article a0_
  INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id
  INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id
WHERE
  a0_.published_at IS NOT NULL
  AND a0_.published_at <= ?
  AND a1_.slug IN (?)
  AND a0_.id IN (?, ?, ?, ?)
ORDER BY
  a0_.published_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10, a0_.image_id AS image_id_11 FROM article a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= '2025-12-06 06:28:02' AND a1_.slug IN ('nature') AND a0_.id IN (1, 2, 4, 5) ORDER BY a0_.published_at DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	__TwigTemplate_918fb76d97cbbfe08f5010076282f9fd->doDisplay (line 148)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_7adef6bc66a0bad1d489a959d2dcd10e->doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	OHMedia\NewsBundle\Twig\NewsExtension->news (line 135)
16	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
31	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 197)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
37	require_once (line 5)

0.32 ms
(2.88%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.starts_at AS starts_at_3, a0_.ends_at AS ends_at_4, a0_.dismissible AS dismissible_5, a0_.dismissible_days AS dismissible_days_6, a0_.created_at AS created_at_7, a0_.created_by AS created_by_8, a0_.updated_at AS updated_at_9, a0_.updated_by AS updated_by_10 FROM alert a0_ WHERE a0_.starts_at IS NOT NULL AND a0_.starts_at < ? AND ((a0_.ends_at IS NULL OR a0_.ends_at > ?)) ORDER BY a0_.starts_at DESC LIMIT 1

Parameters:

[
  "2025-12-06 06:28:02"
  "2025-12-06 06:28:02"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.content AS content_2,
  a0_.starts_at AS starts_at_3,
  a0_.ends_at AS ends_at_4,
  a0_.dismissible AS dismissible_5,
  a0_.dismissible_days AS dismissible_days_6,
  a0_.created_at AS created_at_7,
  a0_.created_by AS created_by_8,
  a0_.updated_at AS updated_at_9,
  a0_.updated_by AS updated_by_10
FROM
  alert a0_
WHERE
  a0_.starts_at IS NOT NULL
  AND a0_.starts_at < ?
  AND (
    (
      a0_.ends_at IS NULL
      OR a0_.ends_at > ?
    )
  )
ORDER BY
  a0_.starts_at DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.starts_at AS starts_at_3, a0_.ends_at AS ends_at_4, a0_.dismissible AS dismissible_5, a0_.dismissible_days AS dismissible_days_6, a0_.created_at AS created_at_7, a0_.created_by AS created_by_8, a0_.updated_at AS updated_at_9, a0_.updated_by AS updated_by_10 FROM alert a0_ WHERE a0_.starts_at IS NOT NULL AND a0_.starts_at < '2025-12-06 06:28:02' AND ((a0_.ends_at IS NULL OR a0_.ends_at > '2025-12-06 06:28:02')) ORDER BY a0_.starts_at 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	OHMedia\AlertBundle\Repository\AlertRepository->getActive (line 53)
7	OHMedia\AlertBundle\Twig\AlertBarExtension->alertBar (line 28)
8	__TwigTemplate_a2ee7ab58c91b148093324df37f3e972->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 180)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
23	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.30 ms
(2.73%)

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  setting t0

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	OHMedia\SettingsBundle\Service\Settings->getEntity (line 98)
5	OHMedia\SettingsBundle\Service\Settings->get (line 66)
6	OHMedia\BackendBundle\Twig\ScriptInjectionExtension->script (line 60)
7	OHMedia\BackendBundle\Twig\ScriptInjectionExtension->scriptHeadOpen (line 40)
8	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 61)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
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	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
19	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 197)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.30 ms
(2.68%)

SELECT COUNT(p0_.id) AS sclr_0 FROM page_content_image p0_ INNER JOIN file f1_ ON p0_.image_id = f1_.id WHERE p0_.page_revision_id = ? AND p0_.name = ? AND f1_.path <> '' AND f1_.path IS NOT NULL

Parameters:

[
  4
  "banner"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  page_content_image p0_
  INNER JOIN file f1_ ON p0_.image_id = f1_.id
WHERE
  p0_.page_revision_id = ?
  AND p0_.name = ?
  AND f1_.path <> ''
  AND f1_.path IS NOT NULL

SELECT COUNT(p0_.id) AS sclr_0 FROM page_content_image p0_ INNER JOIN file f1_ ON p0_.image_id = f1_.id WHERE p0_.page_revision_id = 4 AND p0_.name = 'banner' AND f1_.path <> '' AND f1_.path IS NOT NULL;

#	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	OHMedia\PageBundle\Twig\PageContentExtension->queryBuilderHasResult (line 225)
8	OHMedia\PageBundle\Twig\PageContentExtension->contentImageExists (line 78)
9	__TwigTemplate_918fb76d97cbbfe08f5010076282f9fd->doDisplay (line 51)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_7adef6bc66a0bad1d489a959d2dcd10e->doDisplay (line 48)
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	OHMedia\NewsBundle\Twig\NewsExtension->news (line 135)
18	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
33	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 197)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 29)
39	require_once (line 5)

0.29 ms
(2.56%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.created_at AS created_at_2, a0_.created_by AS created_by_3, a0_.updated_at AS updated_at_4, a0_.updated_by AS updated_by_5, a0_.slug AS slug_6 FROM article_tag a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_tag_id INNER JOIN article a1_ ON a1_.id = a2_.article_id WHERE a1_.published_at IS NOT NULL AND a1_.published_at <= ?

Parameters:

[
  "2025-12-06 06:28:02"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.created_at AS created_at_2,
  a0_.created_by AS created_by_3,
  a0_.updated_at AS updated_at_4,
  a0_.updated_by AS updated_by_5,
  a0_.slug AS slug_6
FROM
  article_tag a0_
  INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_tag_id
  INNER JOIN article a1_ ON a1_.id = a2_.article_id
WHERE
  a1_.published_at IS NOT NULL
  AND a1_.published_at <= ?

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.created_at AS created_at_2, a0_.created_by AS created_by_3, a0_.updated_at AS updated_at_4, a0_.updated_by AS updated_by_5, a0_.slug AS slug_6 FROM article_tag a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_tag_id INNER JOIN article a1_ ON a1_.id = a2_.article_id WHERE a1_.published_at IS NOT NULL AND a1_.published_at <= '2025-12-06 06:28:02';

#	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	OHMedia\NewsBundle\Twig\NewsExtension->getTagsArray (line 165)
7	OHMedia\NewsBundle\Twig\NewsExtension->news (line 138)
8	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
23	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.28 ms
(2.48%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.order_local AS order_local_3, p0_.order_global AS order_global_4, p0_.new_window AS new_window_5, p0_.hidden AS hidden_6, p0_.locked AS locked_7, p0_.published AS published_8, p0_.nesting_level AS nesting_level_9, p0_.path AS path_10, p0_.parent_slug AS parent_slug_11, p0_.homepage AS homepage_12, p0_.noindex AS noindex_13, p0_.redirect_type AS redirect_type_14, p0_.redirect_external AS redirect_external_15, p0_.nav_text AS nav_text_16, p0_.dynamic AS dynamic_17, p0_.sitemap AS sitemap_18, p0_.dropdown_text AS dropdown_text_19, p0_.locked_user_types AS locked_user_types_20, p0_.dropdown_only AS dropdown_only_21, p0_.created_at AS created_at_22, p0_.created_by AS created_by_23, p0_.updated_at AS updated_at_24, p0_.updated_by AS updated_by_25, p0_.parent_id AS parent_id_26, p0_.canonical_id AS canonical_id_27, p0_.meta_id AS meta_id_28, p0_.redirect_internal_id AS redirect_internal_id_29 FROM page p0_ WHERE p0_.homepage = 1 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.order_local AS order_local_3,
  p0_.order_global AS order_global_4,
  p0_.new_window AS new_window_5,
  p0_.hidden AS hidden_6,
  p0_.locked AS locked_7,
  p0_.published AS published_8,
  p0_.nesting_level AS nesting_level_9,
  p0_.path AS path_10,
  p0_.parent_slug AS parent_slug_11,
  p0_.homepage AS homepage_12,
  p0_.noindex AS noindex_13,
  p0_.redirect_type AS redirect_type_14,
  p0_.redirect_external AS redirect_external_15,
  p0_.nav_text AS nav_text_16,
  p0_.dynamic AS dynamic_17,
  p0_.sitemap AS sitemap_18,
  p0_.dropdown_text AS dropdown_text_19,
  p0_.locked_user_types AS locked_user_types_20,
  p0_.dropdown_only AS dropdown_only_21,
  p0_.created_at AS created_at_22,
  p0_.created_by AS created_by_23,
  p0_.updated_at AS updated_at_24,
  p0_.updated_by AS updated_by_25,
  p0_.parent_id AS parent_id_26,
  p0_.canonical_id AS canonical_id_27,
  p0_.meta_id AS meta_id_28,
  p0_.redirect_internal_id AS redirect_internal_id_29
FROM
  page p0_
WHERE
  p0_.homepage = 1
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.order_local AS order_local_3, p0_.order_global AS order_global_4, p0_.new_window AS new_window_5, p0_.hidden AS hidden_6, p0_.locked AS locked_7, p0_.published AS published_8, p0_.nesting_level AS nesting_level_9, p0_.path AS path_10, p0_.parent_slug AS parent_slug_11, p0_.homepage AS homepage_12, p0_.noindex AS noindex_13, p0_.redirect_type AS redirect_type_14, p0_.redirect_external AS redirect_external_15, p0_.nav_text AS nav_text_16, p0_.dynamic AS dynamic_17, p0_.sitemap AS sitemap_18, p0_.dropdown_text AS dropdown_text_19, p0_.locked_user_types AS locked_user_types_20, p0_.dropdown_only AS dropdown_only_21, p0_.created_at AS created_at_22, p0_.created_by AS created_by_23, p0_.updated_at AS updated_at_24, p0_.updated_by AS updated_by_25, p0_.parent_id AS parent_id_26, p0_.canonical_id AS canonical_id_27, p0_.meta_id AS meta_id_28, p0_.redirect_internal_id AS redirect_internal_id_29 FROM page p0_ WHERE p0_.homepage = 1 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	OHMedia\PageBundle\Repository\PageRepository->getHomepage (line 82)
7	OHMedia\PageBundle\Twig\PageExtension->getHomepageBreadcrumb (line 120)
8	OHMedia\PageBundle\Twig\PageExtension->getBreadcrumbs (line 113)
9	OHMedia\PageBundle\Twig\PageExtension->meta (line 62)
10	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->block_meta (line 182)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 66)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
23	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.26 ms
(2.28%)

SELECT l0_.id AS id_0, l0_.ordinal AS ordinal_1, l0_.name AS name_2, l0_.address AS address_3, l0_.city AS city_4, l0_.province AS province_5, l0_.country AS country_6, l0_.postal_code AS postal_code_7, l0_.phone AS phone_8, l0_.email AS email_9, l0_.main AS main_10, l0_.fax AS fax_11, l0_.created_at AS created_at_12, l0_.created_by AS created_by_13, l0_.updated_at AS updated_at_14, l0_.updated_by AS updated_by_15 FROM location l0_ WHERE l0_.main = 1 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.ordinal AS ordinal_1,
  l0_.name AS name_2,
  l0_.address AS address_3,
  l0_.city AS city_4,
  l0_.province AS province_5,
  l0_.country AS country_6,
  l0_.postal_code AS postal_code_7,
  l0_.phone AS phone_8,
  l0_.email AS email_9,
  l0_.main AS main_10,
  l0_.fax AS fax_11,
  l0_.created_at AS created_at_12,
  l0_.created_by AS created_by_13,
  l0_.updated_at AS updated_at_14,
  l0_.updated_by AS updated_by_15
FROM
  location l0_
WHERE
  l0_.main = 1
LIMIT
  1

SELECT l0_.id AS id_0, l0_.ordinal AS ordinal_1, l0_.name AS name_2, l0_.address AS address_3, l0_.city AS city_4, l0_.province AS province_5, l0_.country AS country_6, l0_.postal_code AS postal_code_7, l0_.phone AS phone_8, l0_.email AS email_9, l0_.main AS main_10, l0_.fax AS fax_11, l0_.created_at AS created_at_12, l0_.created_by AS created_by_13, l0_.updated_at AS updated_at_14, l0_.updated_by AS updated_by_15 FROM location l0_ WHERE l0_.main = 1 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	OHMedia\LocationBundle\Repository\LocationRepository->findPrimary (line 46)
7	OHMedia\LocationBundle\Twig\LocationExtension->locationPrimary (line 37)
8	__TwigTemplate_6ef48fa1ae5d8866a24e2253835d3db4->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 192)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
23	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.25 ms
(2.26%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.created_by AS created_by_3, p0_.updated_at AS updated_at_4, p0_.updated_by AS updated_by_5, p0_.page_revision_id AS page_revision_id_6, p0_.image_id AS image_id_7 FROM page_content_image p0_ INNER JOIN file f1_ ON p0_.image_id = f1_.id WHERE p0_.page_revision_id = ? AND p0_.name = ? AND f1_.path <> '' AND f1_.path IS NOT NULL LIMIT 1

Parameters:

[
  4
  "banner"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.created_at AS created_at_2,
  p0_.created_by AS created_by_3,
  p0_.updated_at AS updated_at_4,
  p0_.updated_by AS updated_by_5,
  p0_.page_revision_id AS page_revision_id_6,
  p0_.image_id AS image_id_7
FROM
  page_content_image p0_
  INNER JOIN file f1_ ON p0_.image_id = f1_.id
WHERE
  p0_.page_revision_id = ?
  AND p0_.name = ?
  AND f1_.path <> ''
  AND f1_.path IS NOT NULL
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.created_by AS created_by_3, p0_.updated_at AS updated_at_4, p0_.updated_by AS updated_by_5, p0_.page_revision_id AS page_revision_id_6, p0_.image_id AS image_id_7 FROM page_content_image p0_ INNER JOIN file f1_ ON p0_.image_id = f1_.id WHERE p0_.page_revision_id = 4 AND p0_.name = 'banner' AND f1_.path <> '' AND f1_.path IS NOT NULL 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	OHMedia\PageBundle\Twig\PageContentExtension->getContent (line 233)
7	OHMedia\PageBundle\Twig\PageContentExtension->renderContentImageTag (line 104)
8	__TwigTemplate_918fb76d97cbbfe08f5010076282f9fd->doDisplay (line 56)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_7adef6bc66a0bad1d489a959d2dcd10e->doDisplay (line 48)
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	OHMedia\NewsBundle\Twig\NewsExtension->news (line 135)
17	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->block_main (line 77)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->block_body (line 185)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 92)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
32	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 197)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

0.24 ms
(2.15%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.append_base_title AS append_base_title_4, t0.image_id AS image_id_5 FROM meta t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.append_base_title AS append_base_title_4,
  t0.image_id AS image_id_5
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.append_base_title AS append_base_title_4, t0.image_id AS image_id_5 FROM meta t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\OHMedia\MetaBundle\Entity\Meta::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\OHMedia\MetaBundle\Entity\Meta->__get (line 184)
7	OHMedia\MetaBundle\Entity\Meta->getTitle (line 56)
8	OHMedia\PageBundle\Twig\PageExtension->getBreadcrumbs (line 105)
9	OHMedia\PageBundle\Twig\PageExtension->meta (line 62)
10	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->block_meta (line 182)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_82cdd3494645cfad7a43b3b4a57e1f9f->doDisplay (line 66)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_23819f38c58d9c04f827a5ae2742e9c9->doDisplay (line 59)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_372b778e5cc1109acc7e0f73144fcefb->doDisplay (line 53)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	OHMedia\PageBundle\Service\PageRenderer->renderPage (line 176)
23	OHMedia\PageBundle\Controller\PageFrontendController->frontend (line 67)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	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
OHMedia\FileBundle\Entity\File	14
OHMedia\PageBundle\Entity\Page	10
OHMedia\MetaBundle\Entity\Meta	10
OHMedia\SettingsBundle\Entity\Setting	7
OHMedia\NewsBundle\Entity\ArticleTag	4
OHMedia\NewsBundle\Entity\Article	4
OHMedia\PageBundle\Entity\PageContentText	2
OHMedia\PageBundle\Entity\PageRevision	1
OHMedia\AlertBundle\Entity\Alert	1
OHMedia\PageBundle\Entity\PageContentImage	1
OHMedia\LocationBundle\Entity\Location	1

Entities Mapping

Class	Mapping errors
OHMedia\PageBundle\Entity\Page	No errors.
OHMedia\MetaBundle\Entity\Meta	No errors.
OHMedia\PageBundle\Entity\Page301	No errors.
OHMedia\PageBundle\Entity\PageRevision	No errors.
OHMedia\PageBundle\Entity\AbstractPageContent	No errors.
OHMedia\PageBundle\Entity\PageContentCheckbox	No errors.
OHMedia\PageBundle\Entity\PageContentImage	No errors.
OHMedia\PageBundle\Entity\PageContentRow	No errors.
OHMedia\PageBundle\Entity\PageContentText	No errors.
OHMedia\SettingsBundle\Entity\Setting	No errors.
OHMedia\FileBundle\Entity\File	No errors.
OHMedia\FileBundle\Entity\FileFolder	No errors.
OHMedia\AlertBundle\Entity\Alert	No errors.
OHMedia\NewsBundle\Entity\Article	No errors.
OHMedia\NewsBundle\Entity\ArticleTag	No errors.
OHMedia\LocationBundle\Entity\Location	No errors.
OHMedia\LocationBundle\Entity\LocationHours	No errors.

Symfony Profiler

GET https://mail.v6.ohcms.com/news?tags%5B0%5D=nature

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping