Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

11.75 ms Query time

0 Invalid entities

112 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.30 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.hp AS hp_6, t0.attack_score AS attack_score_7, t0.defense_score AS defense_score_8, t0.initiative AS initiative_9, t0.nb_actions AS nb_actions_10, t0.bo AS bo_11, t0.ca AS ca_12, t0.damage_dice AS damage_dice_13, t0.willpower AS willpower_14, t0.fear_score AS fear_score_15, t0.magic_points AS magic_points_16, t0.category AS category_17, t0.size AS size_18, t0.speed AS speed_19, t0.specializations AS specializations_20, t0.skills AS skills_21, t0.power AS power_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24 FROM monster t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "villepoux"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.hp AS hp_6,
  t0.attack_score AS attack_score_7,
  t0.defense_score AS defense_score_8,
  t0.initiative AS initiative_9,
  t0.nb_actions AS nb_actions_10,
  t0.bo AS bo_11,
  t0.ca AS ca_12,
  t0.damage_dice AS damage_dice_13,
  t0.willpower AS willpower_14,
  t0.fear_score AS fear_score_15,
  t0.magic_points AS magic_points_16,
  t0.category AS category_17,
  t0.size AS size_18,
  t0.speed AS speed_19,
  t0.specializations AS specializations_20,
  t0.skills AS skills_21,
  t0.power AS power_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24
FROM
  monster t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.hp AS hp_6, t0.attack_score AS attack_score_7, t0.defense_score AS defense_score_8, t0.initiative AS initiative_9, t0.nb_actions AS nb_actions_10, t0.bo AS bo_11, t0.ca AS ca_12, t0.damage_dice AS damage_dice_13, t0.willpower AS willpower_14, t0.fear_score AS fear_score_15, t0.magic_points AS magic_points_16, t0.category AS category_17, t0.size AS size_18, t0.speed AS speed_19, t0.specializations AS specializations_20, t0.skills AS skills_21, t0.power AS power_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24 FROM monster t0 WHERE t0.slug = 'villepoux' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\MonsterController->show (line 29)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

1.33 ms

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\MonsterController->show (line 37)
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.16 ms

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.is_bestiaire = ? LIMIT 1

Parameters:

[
  1
]

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.is_bestiaire = ?
LIMIT
  1

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.is_bestiaire = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\MonsterController->show (line 56)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

7.96 ms

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\MonsterController->show (line 57)
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	89
App\Entity\Monster	23

Entities Mapping

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

Symfony Profiler

GET http://babylon.terium.org/monster/villepoux

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping