Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.31 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.51 ms
(58.22%)

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:

[
  "/news/podpisivaites-na-kanali"
]

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 = '/news/podpisivaites-na-kanali' 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 37)
6	App\Controller\NewsController->show (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.80 ms
(41.78%)

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 39)
19	App\Controller\NewsController->show (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	5

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.

Symfony Profiler

GET https://content.overseer.ekostina.brotherhood.software/news/podpisivaites-na-kanali

Configuration Settings

Theme

Page Width