Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

7.94 ms Query time

0 Invalid entities

21 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.99 ms
(37.65%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.h1 AS h1_4, t0.description AS description_5, t0.content AS content_6, t0.seo_text AS seo_text_7, t0.subheader AS subheader_8, t0.priority AS priority_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.dtype, t0.image_name AS image_name_12, t0.image_alt AS image_alt_13, t0.sort_description AS sort_description_14, t0.is_public AS is_public_15, t0.faq AS faq_16, t0.faq_visible AS faq_visible_17, t0.title_faq AS title_faq_18, t0.advantages AS advantages_19, t0.advantages_visible AS advantages_visible_20, t0.advantages_title AS advantages_title_21, t0.features AS features_22, t0.features_visible AS features_visible_23, t0.header_entry AS header_entry_24, t0.subheader_entry AS subheader_entry_25, t0.header_block AS header_block_26, t0.subheader_block AS subheader_block_27, t0.image_name AS image_name_28, t0.image_alt AS image_alt_29, t0.sort_description AS sort_description_30, t0.is_public AS is_public_31, t0.meta AS meta_32, t0.needs AS needs_33, t0.needs_visible AS needs_visible_34 FROM page t0 WHERE t0.path = ? AND t0.dtype IN ('news', 'customPage', 'blog', 'feature') LIMIT 1

Parameters:

[
  "/"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.title AS title_3,
  t0.h1 AS h1_4,
  t0.description AS description_5,
  t0.content AS content_6,
  t0.seo_text AS seo_text_7,
  t0.subheader AS subheader_8,
  t0.priority AS priority_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.dtype,
  t0.image_name AS image_name_12,
  t0.image_alt AS image_alt_13,
  t0.sort_description AS sort_description_14,
  t0.is_public AS is_public_15,
  t0.faq AS faq_16,
  t0.faq_visible AS faq_visible_17,
  t0.title_faq AS title_faq_18,
  t0.advantages AS advantages_19,
  t0.advantages_visible AS advantages_visible_20,
  t0.advantages_title AS advantages_title_21,
  t0.features AS features_22,
  t0.features_visible AS features_visible_23,
  t0.header_entry AS header_entry_24,
  t0.subheader_entry AS subheader_entry_25,
  t0.header_block AS header_block_26,
  t0.subheader_block AS subheader_block_27,
  t0.image_name AS image_name_28,
  t0.image_alt AS image_alt_29,
  t0.sort_description AS sort_description_30,
  t0.is_public AS is_public_31,
  t0.meta AS meta_32,
  t0.needs AS needs_33,
  t0.needs_visible AS needs_visible_34
FROM
  page t0
WHERE
  t0.path = ?
  AND t0.dtype IN (
    'news', 'customPage', 'blog', 'feature'
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.h1 AS h1_4, t0.description AS description_5, t0.content AS content_6, t0.seo_text AS seo_text_7, t0.subheader AS subheader_8, t0.priority AS priority_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.dtype, t0.image_name AS image_name_12, t0.image_alt AS image_alt_13, t0.sort_description AS sort_description_14, t0.is_public AS is_public_15, t0.faq AS faq_16, t0.faq_visible AS faq_visible_17, t0.title_faq AS title_faq_18, t0.advantages AS advantages_19, t0.advantages_visible AS advantages_visible_20, t0.advantages_title AS advantages_title_21, t0.features AS features_22, t0.features_visible AS features_visible_23, t0.header_entry AS header_entry_24, t0.subheader_entry AS subheader_entry_25, t0.header_block AS header_block_26, t0.subheader_block AS subheader_block_27, t0.image_name AS image_name_28, t0.image_alt AS image_alt_29, t0.sort_description AS sort_description_30, t0.is_public AS is_public_31, t0.meta AS meta_32, t0.needs AS needs_33, t0.needs_visible AS needs_visible_34 FROM page t0 WHERE t0.path = '/' AND t0.dtype IN ('news', 'customPage', 'blog', 'feature') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 28)
5	App\Service\PageManager->getPageFromRequest (line 19)
6	App\Controller\HomeController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 7)

1.79 ms
(22.53%)

SELECT p0_.id AS id_0, p0_.path AS path_1, p0_.title AS title_2, p0_.h1 AS h1_3, p0_.description AS description_4, p0_.content AS content_5, p0_.seo_text AS seo_text_6, p0_.subheader AS subheader_7, p0_.priority AS priority_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.image_name AS image_name_11, p0_.image_alt AS image_alt_12, p0_.sort_description AS sort_description_13, p0_.is_public AS is_public_14, p0_.faq AS faq_15, p0_.faq_visible AS faq_visible_16, p0_.title_faq AS title_faq_17, p0_.advantages AS advantages_18, p0_.advantages_visible AS advantages_visible_19, p0_.advantages_title AS advantages_title_20, p0_.features AS features_21, p0_.features_visible AS features_visible_22, p0_.header_entry AS header_entry_23, p0_.subheader_entry AS subheader_entry_24, p0_.header_block AS header_block_25, p0_.subheader_block AS subheader_block_26, p0_.image_name AS image_name_27, p0_.image_alt AS image_alt_28, p0_.sort_description AS sort_description_29, p0_.is_public AS is_public_30, p0_.meta AS meta_31, p0_.needs AS needs_32, p0_.needs_visible AS needs_visible_33, p0_.dtype AS dtype_34 FROM page p0_ WHERE (p0_.dtype IN ('feature')) AND p0_.dtype IN ('news', 'customPage', 'blog', 'feature') ORDER BY p0_.priority ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.path AS path_1,
  p0_.title AS title_2,
  p0_.h1 AS h1_3,
  p0_.description AS description_4,
  p0_.content AS content_5,
  p0_.seo_text AS seo_text_6,
  p0_.subheader AS subheader_7,
  p0_.priority AS priority_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.image_name AS image_name_11,
  p0_.image_alt AS image_alt_12,
  p0_.sort_description AS sort_description_13,
  p0_.is_public AS is_public_14,
  p0_.faq AS faq_15,
  p0_.faq_visible AS faq_visible_16,
  p0_.title_faq AS title_faq_17,
  p0_.advantages AS advantages_18,
  p0_.advantages_visible AS advantages_visible_19,
  p0_.advantages_title AS advantages_title_20,
  p0_.features AS features_21,
  p0_.features_visible AS features_visible_22,
  p0_.header_entry AS header_entry_23,
  p0_.subheader_entry AS subheader_entry_24,
  p0_.header_block AS header_block_25,
  p0_.subheader_block AS subheader_block_26,
  p0_.image_name AS image_name_27,
  p0_.image_alt AS image_alt_28,
  p0_.sort_description AS sort_description_29,
  p0_.is_public AS is_public_30,
  p0_.meta AS meta_31,
  p0_.needs AS needs_32,
  p0_.needs_visible AS needs_visible_33,
  p0_.dtype AS dtype_34
FROM
  page p0_
WHERE
  (
    p0_.dtype IN ('feature')
  )
  AND p0_.dtype IN (
    'news', 'customPage', 'blog', 'feature'
  )
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.path AS path_1, p0_.title AS title_2, p0_.h1 AS h1_3, p0_.description AS description_4, p0_.content AS content_5, p0_.seo_text AS seo_text_6, p0_.subheader AS subheader_7, p0_.priority AS priority_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.image_name AS image_name_11, p0_.image_alt AS image_alt_12, p0_.sort_description AS sort_description_13, p0_.is_public AS is_public_14, p0_.faq AS faq_15, p0_.faq_visible AS faq_visible_16, p0_.title_faq AS title_faq_17, p0_.advantages AS advantages_18, p0_.advantages_visible AS advantages_visible_19, p0_.advantages_title AS advantages_title_20, p0_.features AS features_21, p0_.features_visible AS features_visible_22, p0_.header_entry AS header_entry_23, p0_.subheader_entry AS subheader_entry_24, p0_.header_block AS header_block_25, p0_.subheader_block AS subheader_block_26, p0_.image_name AS image_name_27, p0_.image_alt AS image_alt_28, p0_.sort_description AS sort_description_29, p0_.is_public AS is_public_30, p0_.meta AS meta_31, p0_.needs AS needs_32, p0_.needs_visible AS needs_visible_33, p0_.dtype AS dtype_34 FROM page p0_ WHERE (p0_.dtype IN ('feature')) AND p0_.dtype IN ('news', 'customPage', 'blog', 'feature') ORDER BY p0_.priority ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 31)
7	App\Repository\PageRepository->findAllFeatures (line 20)
8	App\Twig\FeatureExtension->getGlobals (line 359)
9	Twig\ExtensionSet->getGlobals (line 900)
10	Twig\Environment->getGlobals (line 398)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
19	App\Controller\HomeController->index (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 7)

0.93 ms
(11.72%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.h1 AS h1_4, t0.description AS description_5, t0.content AS content_6, t0.seo_text AS seo_text_7, t0.subheader AS subheader_8, t0.priority AS priority_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.image_name AS image_name_12, t0.image_alt AS image_alt_13, t0.sort_description AS sort_description_14, t0.is_public AS is_public_15, t0.dtype FROM page t0 WHERE t0.is_public = ? AND t0.dtype IN ('news') ORDER BY t0.created_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.title AS title_3,
  t0.h1 AS h1_4,
  t0.description AS description_5,
  t0.content AS content_6,
  t0.seo_text AS seo_text_7,
  t0.subheader AS subheader_8,
  t0.priority AS priority_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.image_name AS image_name_12,
  t0.image_alt AS image_alt_13,
  t0.sort_description AS sort_description_14,
  t0.is_public AS is_public_15,
  t0.dtype
FROM
  page t0
WHERE
  t0.is_public = ?
  AND t0.dtype IN ('news')
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.h1 AS h1_4, t0.description AS description_5, t0.content AS content_6, t0.seo_text AS seo_text_7, t0.subheader AS subheader_8, t0.priority AS priority_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.image_name AS image_name_12, t0.image_alt AS image_alt_13, t0.sort_description AS sort_description_14, t0.is_public AS is_public_15, t0.dtype FROM page t0 WHERE t0.is_public = 1 AND t0.dtype IN ('news') ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 21)
5	App\Controller\HomeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 7)

0.79 ms
(9.90%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.subheader AS subheader_4, t0.images_names AS images_names_5 FROM gallery t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "features"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.title AS title_3,
  t0.subheader AS subheader_4,
  t0.images_names AS images_names_5
FROM
  gallery t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.subheader AS subheader_4, t0.images_names AS images_names_5 FROM gallery t0 WHERE t0.slug = 'features' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 31)
5	App\Twig\GalleryExtension->renderGalleryBySlug (line 111)
6	__TwigTemplate_d48a341f50f86a2ab11358f83bacf10d->block_body (line 446)
7	Twig\Template->yieldBlock (line 147)
8	__TwigTemplate_2023d87aeb11b6c508711036168448c8->doDisplay (line 402)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_d48a341f50f86a2ab11358f83bacf10d->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
19	App\Controller\HomeController->index (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 7)

0.75 ms
(9.42%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.price AS price_4, t0.ordering AS ordering_5 FROM tariff t0 ORDER BY t0.ordering ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.number AS number_3,
  t0.price AS price_4,
  t0.ordering AS ordering_5
FROM
  tariff t0
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.price AS price_4, t0.ordering AS ordering_5 FROM tariff t0 ORDER BY t0.ordering ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 35)
5	App\Twig\TariffExtension->getTariffTable (line 115)
6	__TwigTemplate_d48a341f50f86a2ab11358f83bacf10d->block_body (line 446)
7	Twig\Template->yieldBlock (line 147)
8	__TwigTemplate_2023d87aeb11b6c508711036168448c8->doDisplay (line 402)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_d48a341f50f86a2ab11358f83bacf10d->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
19	App\Controller\HomeController->index (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 7)

0.70 ms
(8.78%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.ordering AS ordering_5, t0.published AS published_6 FROM roadmap t0 WHERE t0.published = ? ORDER BY t0.ordering ASC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.ordering AS ordering_5,
  t0.published AS published_6
FROM
  roadmap t0
WHERE
  t0.published = ?
ORDER BY
  t0.ordering ASC
LIMIT
  3

SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.ordering AS ordering_5, t0.published AS published_6 FROM roadmap t0 WHERE t0.published = 1 ORDER BY t0.ordering ASC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 35)
5	App\Twig\RoadmapExtension->getRoadmapBlock (line 130)
6	__TwigTemplate_d48a341f50f86a2ab11358f83bacf10d->block_body (line 446)
7	Twig\Template->yieldBlock (line 147)
8	__TwigTemplate_2023d87aeb11b6c508711036168448c8->doDisplay (line 402)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_d48a341f50f86a2ab11358f83bacf10d->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
19	App\Controller\HomeController->index (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 7)

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	9
App\Entity\Tariff	8
App\Entity\Roadmap	3
App\Entity\Gallery	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\News	No errors.
App\Entity\CustomPage	No errors.
App\Entity\Blog	No errors.
App\Entity\Feature	No errors.
App\Entity\Gallery	No errors.
App\Entity\Tariff	No errors.
App\Entity\Roadmap	No errors.

Symfony Profiler

GET https://content.overseer.ekostina.brotherhood.software/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CFeedbackController%2…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping