Symfony Profiler

Query Metrics

14 Database Queries

6 Different statements

4.12 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.76 ms
(42.71%)

SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.caption AS caption_8, t0.json_payload AS json_payload_9, t0.race_id AS race_id_10, t0.parent_id AS parent_id_11 FROM dnd_race_entry_block t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[
  8663
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.block_type AS block_type_2,
  t0.source_field AS source_field_3,
  t0.path AS path_4,
  t0.sort_order AS sort_order_5,
  t0.title AS title_6,
  t0.text_content AS text_content_7,
  t0.caption AS caption_8,
  t0.json_payload AS json_payload_9,
  t0.race_id AS race_id_10,
  t0.parent_id AS parent_id_11
FROM
  dnd_race_entry_block t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.caption AS caption_8, t0.json_payload AS json_payload_9, t0.race_id AS race_id_10, t0.parent_id AS parent_id_11 FROM dnd_race_entry_block t0 WHERE t0.parent_id = 8663 ORDER BY t0.sort_order ASC, t0.id 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 2729)
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 1278)
9	__TwigTemplate_b28ea0e4e12f7cc3e0c3d1458b05bfaa::doDisplay (line 117)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b61a00fa980dc443f38adde0fb53cf26->block_body (line 110)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_4136223d673f867ac097f6b82913dfcb->doDisplay (line 172)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_b61a00fa980dc443f38adde0fb53cf26->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Compendium\CompendiumController->show (line 120)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.55 ms
(13.31%)

SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_race d0_ WHERE LOWER(d0_.name) < LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1

Parameters:

[
  "Goliath; Fire Giant Ancestry"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(d0_.id) AS sclr_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  dnd_race d0_
WHERE
  LOWER(d0_.name) < LOWER(?)
GROUP BY
  d0_.name,
  d0_.slug
ORDER BY
  d0_.name DESC
LIMIT
  1

SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_race d0_ WHERE LOWER(d0_.name) < LOWER('Goliath; Fire Giant Ancestry') GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1;

#	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\Service\Compendium\CompendiumSearchService->adjacentEntry (line 263)
7	App\Controller\Compendium\CompendiumController->show (line 125)
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 35)
12	require_once (line 32)
13	require_once (line 5)

0.54 ms
(13.15%)

SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.lineage AS lineage_7, d0_.darkvision AS darkvision_8, d0_.sound_clip_path AS sound_clip_path_9, d0_.height_weight_summary AS height_weight_summary_10, d0_.srd AS srd_11, d0_.basic_rules AS basic_rules_12, d0_.srd52 AS srd52_13, d0_.basic_rules_2024 AS basic_rules_2024_14, d0_.has_fluff AS has_fluff_15, d0_.has_fluff_images AS has_fluff_images_16 FROM dnd_race d0_ WHERE d0_.slug = ? ORDER BY d0_.source ASC, d0_.page ASC

Parameters:

[
  "goliath-fire-giant-ancestry"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.source_key AS source_key_1,
  d0_.name AS name_2,
  d0_.slug AS slug_3,
  d0_.source AS source_4,
  d0_.page AS page_5,
  d0_.edition AS edition_6,
  d0_.lineage AS lineage_7,
  d0_.darkvision AS darkvision_8,
  d0_.sound_clip_path AS sound_clip_path_9,
  d0_.height_weight_summary AS height_weight_summary_10,
  d0_.srd AS srd_11,
  d0_.basic_rules AS basic_rules_12,
  d0_.srd52 AS srd52_13,
  d0_.basic_rules_2024 AS basic_rules_2024_14,
  d0_.has_fluff AS has_fluff_15,
  d0_.has_fluff_images AS has_fluff_images_16
FROM
  dnd_race d0_
WHERE
  d0_.slug = ?
ORDER BY
  d0_.source ASC,
  d0_.page ASC

SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.lineage AS lineage_7, d0_.darkvision AS darkvision_8, d0_.sound_clip_path AS sound_clip_path_9, d0_.height_weight_summary AS height_weight_summary_10, d0_.srd AS srd_11, d0_.basic_rules AS basic_rules_12, d0_.srd52 AS srd52_13, d0_.basic_rules_2024 AS basic_rules_2024_14, d0_.has_fluff AS has_fluff_15, d0_.has_fluff_images AS has_fluff_images_16 FROM dnd_race d0_ WHERE d0_.slug = 'goliath-fire-giant-ancestry' ORDER BY d0_.source ASC, d0_.page 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\Service\Compendium\CompendiumSearchService->findVersions (line 205)
7	App\Controller\Compendium\CompendiumController->show (line 124)
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 35)
12	require_once (line 32)
13	require_once (line 5)

0.51 ms
(12.36%)

SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.lineage AS lineage_7, d0_.darkvision AS darkvision_8, d0_.sound_clip_path AS sound_clip_path_9, d0_.height_weight_summary AS height_weight_summary_10, d0_.srd AS srd_11, d0_.basic_rules AS basic_rules_12, d0_.srd52 AS srd52_13, d0_.basic_rules_2024 AS basic_rules_2024_14, d0_.has_fluff AS has_fluff_15, d0_.has_fluff_images AS has_fluff_images_16 FROM dnd_race d0_ WHERE d0_.slug = ? ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1

Parameters:

[
  "goliath-fire-giant-ancestry"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.source_key AS source_key_1,
  d0_.name AS name_2,
  d0_.slug AS slug_3,
  d0_.source AS source_4,
  d0_.page AS page_5,
  d0_.edition AS edition_6,
  d0_.lineage AS lineage_7,
  d0_.darkvision AS darkvision_8,
  d0_.sound_clip_path AS sound_clip_path_9,
  d0_.height_weight_summary AS height_weight_summary_10,
  d0_.srd AS srd_11,
  d0_.basic_rules AS basic_rules_12,
  d0_.srd52 AS srd52_13,
  d0_.basic_rules_2024 AS basic_rules_2024_14,
  d0_.has_fluff AS has_fluff_15,
  d0_.has_fluff_images AS has_fluff_images_16
FROM
  dnd_race d0_
WHERE
  d0_.slug = ?
ORDER BY
  CASE WHEN d0_.edition = 'one' THEN
    0
  ELSE
    1
  END ASC,
  d0_.source ASC,
  d0_.id ASC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.lineage AS lineage_7, d0_.darkvision AS darkvision_8, d0_.sound_clip_path AS sound_clip_path_9, d0_.height_weight_summary AS height_weight_summary_10, d0_.srd AS srd_11, d0_.basic_rules AS basic_rules_12, d0_.srd52 AS srd52_13, d0_.basic_rules_2024 AS basic_rules_2024_14, d0_.has_fluff AS has_fluff_15, d0_.has_fluff_images AS has_fluff_images_16 FROM dnd_race d0_ WHERE d0_.slug = 'goliath-fire-giant-ancestry' ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1;

#	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\Service\Compendium\CompendiumSearchService->findEntry (line 182)
7	App\Controller\Compendium\CompendiumController->show (line 108)
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 35)
12	require_once (line 32)
13	require_once (line 5)

0.44 ms
(10.62%)

SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_race d0_ WHERE LOWER(d0_.name) > LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1

Parameters:

[
  "Goliath; Fire Giant Ancestry"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(d0_.id) AS sclr_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  dnd_race d0_
WHERE
  LOWER(d0_.name) > LOWER(?)
GROUP BY
  d0_.name,
  d0_.slug
ORDER BY
  d0_.name ASC
LIMIT
  1

SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_race d0_ WHERE LOWER(d0_.name) > LOWER('Goliath; Fire Giant Ancestry') GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1;

#	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\Service\Compendium\CompendiumSearchService->adjacentEntry (line 263)
7	App\Controller\Compendium\CompendiumController->show (line 126)
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 35)
12	require_once (line 32)
13	require_once (line 5)

0.32 ms
(7.84%)

SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.caption AS caption_8, t0.json_payload AS json_payload_9, t0.race_id AS race_id_10, t0.parent_id AS parent_id_11 FROM dnd_race_entry_block t0 WHERE t0.race_id = ? ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[
  195
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.block_type AS block_type_2,
  t0.source_field AS source_field_3,
  t0.path AS path_4,
  t0.sort_order AS sort_order_5,
  t0.title AS title_6,
  t0.text_content AS text_content_7,
  t0.caption AS caption_8,
  t0.json_payload AS json_payload_9,
  t0.race_id AS race_id_10,
  t0.parent_id AS parent_id_11
FROM
  dnd_race_entry_block t0
WHERE
  t0.race_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.caption AS caption_8, t0.json_payload AS json_payload_9, t0.race_id AS race_id_10, t0.parent_id AS parent_id_11 FROM dnd_race_entry_block t0 WHERE t0.race_id = 195 ORDER BY t0.sort_order ASC, t0.id 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 2729)
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 1278)
9	__TwigTemplate_b28ea0e4e12f7cc3e0c3d1458b05bfaa::doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b61a00fa980dc443f38adde0fb53cf26->block_body (line 110)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_4136223d673f867ac097f6b82913dfcb->doDisplay (line 172)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_b61a00fa980dc443f38adde0fb53cf26->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Compendium\CompendiumController->show (line 120)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	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\DndRaceEntryBlock	9
App\Entity\DndRace	1

Entities Mapping

Class	Mapping errors
App\Entity\DndRace	No errors.
App\Entity\DndRaceSize	No errors.
App\Entity\DndRaceSpeed	No errors.
App\Entity\DndRaceAbilityBonus	No errors.
App\Entity\DndRaceTraitTag	No errors.
App\Entity\DndRaceResistance	No errors.
App\Entity\DndRaceConditionImmunity	No errors.
App\Entity\DndRaceProficiency	No errors.
App\Entity\DndRaceAdditionalSpell	No errors.
App\Entity\DndRaceEntryBlock	No errors.
App\Entity\DndRaceSense	No errors.

Symfony Profiler

GET https://www.arrowscauldron.com/compendium/races/goliath-fire-giant-ancestry

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping