Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

15.98 ms Query time

0 Invalid entities

150 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.97 ms
(49.86%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.icon AS icon_4, p0_.position AS position_5, p0_.published AS published_6, p0_.is_bestiaire AS is_bestiaire_7, p0_.is_personnage AS is_personnage_8, p0_.featured_image AS featured_image_9, p0_.featured_image_align AS featured_image_align_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p1_.id AS id_13, p1_.title AS title_14, p1_.slug AS slug_15, p1_.content AS content_16, p1_.icon AS icon_17, p1_.position AS position_18, p1_.published AS published_19, p1_.is_bestiaire AS is_bestiaire_20, p1_.is_personnage AS is_personnage_21, p1_.featured_image AS featured_image_22, p1_.featured_image_align AS featured_image_align_23, p1_.created_at AS created_at_24, p1_.updated_at AS updated_at_25, p0_.parent_id AS parent_id_26, p1_.parent_id AS parent_id_27 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL ORDER BY p0_.position ASC, p1_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.content AS content_3,
  p0_.icon AS icon_4,
  p0_.position AS position_5,
  p0_.published AS published_6,
  p0_.is_bestiaire AS is_bestiaire_7,
  p0_.is_personnage AS is_personnage_8,
  p0_.featured_image AS featured_image_9,
  p0_.featured_image_align AS featured_image_align_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  p1_.id AS id_13,
  p1_.title AS title_14,
  p1_.slug AS slug_15,
  p1_.content AS content_16,
  p1_.icon AS icon_17,
  p1_.position AS position_18,
  p1_.published AS published_19,
  p1_.is_bestiaire AS is_bestiaire_20,
  p1_.is_personnage AS is_personnage_21,
  p1_.featured_image AS featured_image_22,
  p1_.featured_image_align AS featured_image_align_23,
  p1_.created_at AS created_at_24,
  p1_.updated_at AS updated_at_25,
  p0_.parent_id AS parent_id_26,
  p1_.parent_id AS parent_id_27
FROM
  page p0_
  LEFT JOIN page p1_ ON p0_.id = p1_.parent_id
WHERE
  p0_.parent_id IS NULL
ORDER BY
  p0_.position ASC,
  p1_.position ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.icon AS icon_4, p0_.position AS position_5, p0_.published AS published_6, p0_.is_bestiaire AS is_bestiaire_7, p0_.is_personnage AS is_personnage_8, p0_.featured_image AS featured_image_9, p0_.featured_image_align AS featured_image_align_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p1_.id AS id_13, p1_.title AS title_14, p1_.slug AS slug_15, p1_.content AS content_16, p1_.icon AS icon_17, p1_.position AS position_18, p1_.published AS published_19, p1_.is_bestiaire AS is_bestiaire_20, p1_.is_personnage AS is_personnage_21, p1_.featured_image AS featured_image_22, p1_.featured_image_align AS featured_image_align_23, p1_.created_at AS created_at_24, p1_.updated_at AS updated_at_25, p0_.parent_id AS parent_id_26, p1_.parent_id AS parent_id_27 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL ORDER BY p0_.position ASC, p1_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PageRepository->findRootPagesWithChildren (line 52)
7	App\Controller\PageController->show (line 53)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

5.88 ms
(36.80%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.icon AS icon_4, p0_.position AS position_5, p0_.published AS published_6, p0_.is_bestiaire AS is_bestiaire_7, p0_.is_personnage AS is_personnage_8, p0_.featured_image AS featured_image_9, p0_.featured_image_align AS featured_image_align_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.parent_id AS parent_id_13 FROM page p0_ WHERE p0_.published = ? ORDER BY p0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.content AS content_3,
  p0_.icon AS icon_4,
  p0_.position AS position_5,
  p0_.published AS published_6,
  p0_.is_bestiaire AS is_bestiaire_7,
  p0_.is_personnage AS is_personnage_8,
  p0_.featured_image AS featured_image_9,
  p0_.featured_image_align AS featured_image_align_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  p0_.parent_id AS parent_id_13
FROM
  page p0_
WHERE
  p0_.published = ?
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.icon AS icon_4, p0_.position AS position_5, p0_.published AS published_6, p0_.is_bestiaire AS is_bestiaire_7, p0_.is_personnage AS is_personnage_8, p0_.featured_image AS featured_image_9, p0_.featured_image_align AS featured_image_align_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.parent_id AS parent_id_13 FROM page p0_ WHERE p0_.published = 1 ORDER BY p0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PageRepository->findFlatTree (line 120)
7	App\Repository\PageRepository->findPrevAndNextInFlatTree (line 152)
8	App\Controller\PageController->show (line 54)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

1.07 ms
(6.69%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.icon AS icon_5, t0.position AS position_6, t0.published AS published_7, t0.is_bestiaire AS is_bestiaire_8, t0.is_personnage AS is_personnage_9, t0.featured_image AS featured_image_10, t0.featured_image_align AS featured_image_align_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM page t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC

Parameters:

[
  79
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.icon AS icon_5,
  t0.position AS position_6,
  t0.published AS published_7,
  t0.is_bestiaire AS is_bestiaire_8,
  t0.is_personnage AS is_personnage_9,
  t0.featured_image AS featured_image_10,
  t0.featured_image_align AS featured_image_align_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.parent_id AS parent_id_14
FROM
  page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.icon AS icon_5, t0.position AS position_6, t0.published AS published_7, t0.is_bestiaire AS is_bestiaire_8, t0.is_personnage AS is_personnage_9, t0.featured_image AS featured_image_10, t0.featured_image_align AS featured_image_align_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM page t0 WHERE t0.parent_id = 79 ORDER BY t0.position ASC;

#	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 2746)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1281)
9	__TwigTemplate_29d25f9aa8ec08bdc8af53a803995914::block_body (line 374)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_3bb4c6a9971408db9d50f7629daaff38->doDisplay (line 910)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_29d25f9aa8ec08bdc8af53a803995914->doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\PageController->show (line 134)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

1.06 ms
(6.66%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.icon AS icon_4, p0_.position AS position_5, p0_.published AS published_6, p0_.is_bestiaire AS is_bestiaire_7, p0_.is_personnage AS is_personnage_8, p0_.featured_image AS featured_image_9, p0_.featured_image_align AS featured_image_align_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.parent_id AS parent_id_13 FROM page p0_ WHERE p0_.slug = ?

Parameters:

[
  "magie-vitale"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.content AS content_3,
  p0_.icon AS icon_4,
  p0_.position AS position_5,
  p0_.published AS published_6,
  p0_.is_bestiaire AS is_bestiaire_7,
  p0_.is_personnage AS is_personnage_8,
  p0_.featured_image AS featured_image_9,
  p0_.featured_image_align AS featured_image_align_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  p0_.parent_id AS parent_id_13
FROM
  page p0_
WHERE
  p0_.slug = ?

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.icon AS icon_4, p0_.position AS position_5, p0_.published AS published_6, p0_.is_bestiaire AS is_bestiaire_7, p0_.is_personnage AS is_personnage_8, p0_.featured_image AS featured_image_9, p0_.featured_image_align AS featured_image_align_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.parent_id AS parent_id_13 FROM page p0_ WHERE p0_.slug = 'magie-vitale';

#	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	App\Repository\PageRepository->findBySlug (line 61)
7	App\Controller\PageController->show (line 47)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Page	150

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.

Symfony Profiler

GET http://babylon.terium.org/page/magie-vitale

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping