Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

9.05 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.99 ms
(44.04%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM page p0_ WHERE (p0_.is_public = ?) AND p0_.dtype IN ('blog')

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  page p0_
WHERE
  (p0_.is_public = ?)
  AND p0_.dtype IN ('blog')

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM page p0_ WHERE (p0_.is_public = 1) AND p0_.dtype IN ('blog');

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 20)
15	Container5gTAoia\PaginatorProxyBa079e5->paginate (line 42)
16	App\Controller\BlogController->handle (line 23)
17	App\Controller\BlogController->firstPage (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 7)

1.86 ms
(20.56%)

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_.dtype AS dtype_15 FROM page p0_ WHERE (p0_.is_public = ? AND p0_.id IN (?, ?)) AND p0_.dtype IN ('blog') ORDER BY p0_.created_at DESC

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_.dtype AS dtype_15
FROM
  page p0_
WHERE
  (
    p0_.is_public = ?
    AND p0_.id IN (?, ?)
  )
  AND p0_.dtype IN ('blog')
ORDER BY
  p0_.created_at DESC

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_.dtype AS dtype_15 FROM page p0_ WHERE (p0_.is_public = 1 AND p0_.id IN (15, 16)) AND p0_.dtype IN ('blog') ORDER BY p0_.created_at DESC;

#	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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 20)
15	Container5gTAoia\PaginatorProxyBa079e5->paginate (line 42)
16	App\Controller\BlogController->handle (line 23)
17	App\Controller\BlogController->firstPage (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 7)

1.60 ms
(17.62%)

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 51)
19	App\Controller\BlogController->handle (line 23)
20	App\Controller\BlogController->firstPage (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 7)

0.82 ms
(9.05%)

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM page p0_ WHERE (p0_.is_public = ?) AND p0_.dtype IN ('blog') ORDER BY p0_.created_at DESC LIMIT 12

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at AS created_at_1
FROM
  page p0_
WHERE
  (p0_.is_public = ?)
  AND p0_.dtype IN ('blog')
ORDER BY
  p0_.created_at DESC
LIMIT
  12

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM page p0_ WHERE (p0_.is_public = 1) AND p0_.dtype IN ('blog') ORDER BY p0_.created_at DESC LIMIT 12;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 20)
15	Container5gTAoia\PaginatorProxyBa079e5->paginate (line 42)
16	App\Controller\BlogController->handle (line 23)
17	App\Controller\BlogController->firstPage (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 7)

0.79 ms
(8.73%)

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:

[
  "/blog"
]

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 = '/blog' 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 39)
5	App\Service\PageManager->getPageByPath (line 52)
6	App\Controller\BlogController->handle (line 23)
7	App\Controller\BlogController->firstPage (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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	7

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Blog	No errors.
App\Entity\News	No errors.
App\Entity\CustomPage	No errors.
App\Entity\Feature	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