Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

16.55 ms Query time

0 Invalid entities

173 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.06 ms
(48.69%)

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.92 ms
(35.77%)

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.31 ms
(7.90%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.description AS description_3, m0_.image AS image_4, m0_.hp AS hp_5, m0_.attack_score AS attack_score_6, m0_.defense_score AS defense_score_7, m0_.initiative AS initiative_8, m0_.nb_actions AS nb_actions_9, m0_.bo AS bo_10, m0_.ca AS ca_11, m0_.damage_dice AS damage_dice_12, m0_.willpower AS willpower_13, m0_.fear_score AS fear_score_14, m0_.magic_points AS magic_points_15, m0_.category AS category_16, m0_.size AS size_17, m0_.speed AS speed_18, m0_.specializations AS specializations_19, m0_.skills AS skills_20, m0_.power AS power_21, m0_.created_at AS created_at_22, m0_.updated_at AS updated_at_23 FROM monster m0_ ORDER BY m0_.power ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.slug AS slug_2,
  m0_.description AS description_3,
  m0_.image AS image_4,
  m0_.hp AS hp_5,
  m0_.attack_score AS attack_score_6,
  m0_.defense_score AS defense_score_7,
  m0_.initiative AS initiative_8,
  m0_.nb_actions AS nb_actions_9,
  m0_.bo AS bo_10,
  m0_.ca AS ca_11,
  m0_.damage_dice AS damage_dice_12,
  m0_.willpower AS willpower_13,
  m0_.fear_score AS fear_score_14,
  m0_.magic_points AS magic_points_15,
  m0_.category AS category_16,
  m0_.size AS size_17,
  m0_.speed AS speed_18,
  m0_.specializations AS specializations_19,
  m0_.skills AS skills_20,
  m0_.power AS power_21,
  m0_.created_at AS created_at_22,
  m0_.updated_at AS updated_at_23
FROM
  monster m0_
ORDER BY
  m0_.power ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.description AS description_3, m0_.image AS image_4, m0_.hp AS hp_5, m0_.attack_score AS attack_score_6, m0_.defense_score AS defense_score_7, m0_.initiative AS initiative_8, m0_.nb_actions AS nb_actions_9, m0_.bo AS bo_10, m0_.ca AS ca_11, m0_.damage_dice AS damage_dice_12, m0_.willpower AS willpower_13, m0_.fear_score AS fear_score_14, m0_.magic_points AS magic_points_15, m0_.category AS category_16, m0_.size AS size_17, m0_.speed AS speed_18, m0_.specializations AS specializations_19, m0_.skills AS skills_20, m0_.power AS power_21, m0_.created_at AS created_at_22, m0_.updated_at AS updated_at_23 FROM monster m0_ ORDER BY m0_.power 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\MonsterRepository->findAllOrdered (line 27)
7	App\Controller\PageController->show (line 71)
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)

1.26 ms
(7.64%)

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:

[
  "bestiaire"
]

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 = 'bestiaire';

#	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
App\Entity\Monster	23

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Monster	No errors.

Symfony Profiler

GET http://babylon.terium.org/page/bestiaire

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping