Symfony Profiler

Query Metrics

22 Database Queries

10 Different statements

7.54 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.42 ms
(32.05%)

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.spell_id AS spell_id_10, t0.parent_id AS parent_id_11 FROM dnd_spell_entry_block t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[
  4357
]

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.spell_id AS spell_id_10,
  t0.parent_id AS parent_id_11
FROM
  dnd_spell_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.spell_id AS spell_id_10, t0.parent_id AS parent_id_11 FROM dnd_spell_entry_block t0 WHERE t0.parent_id = 4357 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_990d23025b1e6852d08f0bd097697578->block_body (line 153)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_4136223d673f867ac097f6b82913dfcb->doDisplay (line 172)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_990d23025b1e6852d08f0bd097697578->doDisplay (line 57)
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)

1.87 ms
(24.82%)

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

Parameters:

[
  "Bigby's Hand"
]

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_spell 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_spell d0_ WHERE LOWER(d0_.name) > LOWER('Bigby\'s Hand') 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.79 ms
(10.43%)

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_.level AS level_7, d0_.school AS school_8, d0_.is_ritual AS is_ritual_9, d0_.is_concentration AS is_concentration_10, d0_.range_summary AS range_summary_11, d0_.components_summary AS components_summary_12, d0_.duration_summary AS duration_summary_13, d0_.srd AS srd_14, d0_.basic_rules AS basic_rules_15, d0_.srd52 AS srd52_16, d0_.basic_rules_2024 AS basic_rules_2024_17, d0_.has_fluff AS has_fluff_18, d0_.has_fluff_images AS has_fluff_images_19 FROM dnd_spell d0_ WHERE d0_.slug = ? AND UPPER(d0_.source) = ? ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1

Parameters:

[
  "bigby-s-hand"
  "PHB"
]

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_.level AS level_7,
  d0_.school AS school_8,
  d0_.is_ritual AS is_ritual_9,
  d0_.is_concentration AS is_concentration_10,
  d0_.range_summary AS range_summary_11,
  d0_.components_summary AS components_summary_12,
  d0_.duration_summary AS duration_summary_13,
  d0_.srd AS srd_14,
  d0_.basic_rules AS basic_rules_15,
  d0_.srd52 AS srd52_16,
  d0_.basic_rules_2024 AS basic_rules_2024_17,
  d0_.has_fluff AS has_fluff_18,
  d0_.has_fluff_images AS has_fluff_images_19
FROM
  dnd_spell d0_
WHERE
  d0_.slug = ?
  AND UPPER(d0_.source) = ?
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_.level AS level_7, d0_.school AS school_8, d0_.is_ritual AS is_ritual_9, d0_.is_concentration AS is_concentration_10, d0_.range_summary AS range_summary_11, d0_.components_summary AS components_summary_12, d0_.duration_summary AS duration_summary_13, d0_.srd AS srd_14, d0_.basic_rules AS basic_rules_15, d0_.srd52 AS srd52_16, d0_.basic_rules_2024 AS basic_rules_2024_17, d0_.has_fluff AS has_fluff_18, d0_.has_fluff_images AS has_fluff_images_19 FROM dnd_spell d0_ WHERE d0_.slug = 'bigby-s-hand' AND UPPER(d0_.source) = 'PHB' 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.70 ms
(9.27%)

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

Parameters:

[
  "Bigby's Hand"
]

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_spell 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_spell d0_ WHERE LOWER(d0_.name) < LOWER('Bigby\'s Hand') 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.64 ms
(8.44%)

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_.level AS level_7, d0_.school AS school_8, d0_.is_ritual AS is_ritual_9, d0_.is_concentration AS is_concentration_10, d0_.range_summary AS range_summary_11, d0_.components_summary AS components_summary_12, d0_.duration_summary AS duration_summary_13, d0_.srd AS srd_14, d0_.basic_rules AS basic_rules_15, d0_.srd52 AS srd52_16, d0_.basic_rules_2024 AS basic_rules_2024_17, d0_.has_fluff AS has_fluff_18, d0_.has_fluff_images AS has_fluff_images_19 FROM dnd_spell d0_ WHERE d0_.slug = ? ORDER BY d0_.source ASC, d0_.page ASC

Parameters:

[
  "bigby-s-hand"
]

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_.level AS level_7,
  d0_.school AS school_8,
  d0_.is_ritual AS is_ritual_9,
  d0_.is_concentration AS is_concentration_10,
  d0_.range_summary AS range_summary_11,
  d0_.components_summary AS components_summary_12,
  d0_.duration_summary AS duration_summary_13,
  d0_.srd AS srd_14,
  d0_.basic_rules AS basic_rules_15,
  d0_.srd52 AS srd52_16,
  d0_.basic_rules_2024 AS basic_rules_2024_17,
  d0_.has_fluff AS has_fluff_18,
  d0_.has_fluff_images AS has_fluff_images_19
FROM
  dnd_spell 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_.level AS level_7, d0_.school AS school_8, d0_.is_ritual AS is_ritual_9, d0_.is_concentration AS is_concentration_10, d0_.range_summary AS range_summary_11, d0_.components_summary AS components_summary_12, d0_.duration_summary AS duration_summary_13, d0_.srd AS srd_14, d0_.basic_rules AS basic_rules_15, d0_.srd52 AS srd52_16, d0_.basic_rules_2024 AS basic_rules_2024_17, d0_.has_fluff AS has_fluff_18, d0_.has_fluff_images AS has_fluff_images_19 FROM dnd_spell d0_ WHERE d0_.slug = 'bigby-s-hand' 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.28 ms
(3.77%)

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.spell_id AS spell_id_10, t0.parent_id AS parent_id_11 FROM dnd_spell_entry_block t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[
  408
]

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.spell_id AS spell_id_10,
  t0.parent_id AS parent_id_11
FROM
  dnd_spell_entry_block t0
WHERE
  t0.spell_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.spell_id AS spell_id_10, t0.parent_id AS parent_id_11 FROM dnd_spell_entry_block t0 WHERE t0.spell_id = 408 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_990d23025b1e6852d08f0bd097697578->block_body (line 153)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_4136223d673f867ac097f6b82913dfcb->doDisplay (line 172)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_990d23025b1e6852d08f0bd097697578->doDisplay (line 57)
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.26 ms
(3.43%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.unit AS unit_3, t0.raw_text AS raw_text_4, t0.sort_order AS sort_order_5, t0.spell_id AS spell_id_6 FROM dnd_spell_casting_time t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[
  408
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.unit AS unit_3,
  t0.raw_text AS raw_text_4,
  t0.sort_order AS sort_order_5,
  t0.spell_id AS spell_id_6
FROM
  dnd_spell_casting_time t0
WHERE
  t0.spell_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.number AS number_2, t0.unit AS unit_3, t0.raw_text AS raw_text_4, t0.sort_order AS sort_order_5, t0.spell_id AS spell_id_6 FROM dnd_spell_casting_time t0 WHERE t0.spell_id = 408 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_990d23025b1e6852d08f0bd097697578::block_body (line 110)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4136223d673f867ac097f6b82913dfcb->doDisplay (line 172)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_990d23025b1e6852d08f0bd097697578->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
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\Compendium\CompendiumController->show (line 120)
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 35)
27	require_once (line 32)
28	require_once (line 5)

0.21 ms
(2.77%)

SELECT t0.id AS id_1, t0.has_verbal AS has_verbal_2, t0.has_somatic AS has_somatic_3, t0.has_material AS has_material_4, t0.material_text AS material_text_5, t0.spell_id AS spell_id_6 FROM dnd_spell_component t0 WHERE t0.spell_id = ? ORDER BY t0.id ASC

Parameters:

[
  408
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.has_verbal AS has_verbal_2,
  t0.has_somatic AS has_somatic_3,
  t0.has_material AS has_material_4,
  t0.material_text AS material_text_5,
  t0.spell_id AS spell_id_6
FROM
  dnd_spell_component t0
WHERE
  t0.spell_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.has_verbal AS has_verbal_2, t0.has_somatic AS has_somatic_3, t0.has_material AS has_material_4, t0.material_text AS material_text_5, t0.spell_id AS spell_id_6 FROM dnd_spell_component t0 WHERE t0.spell_id = 408 ORDER BY 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->getIterator (line 315)
7	__TwigTemplate_990d23025b1e6852d08f0bd097697578->block_body (line 132)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_4136223d673f867ac097f6b82913dfcb->doDisplay (line 172)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_990d23025b1e6852d08f0bd097697578->doDisplay (line 57)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Compendium\CompendiumController->show (line 120)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.21 ms
(2.76%)

SELECT t0.id AS id_1, t0.tag_group AS tag_group_2, t0.tag_value AS tag_value_3, t0.sort_order AS sort_order_4, t0.spell_id AS spell_id_5 FROM dnd_spell_tag t0 WHERE t0.spell_id = ? ORDER BY t0.tag_group ASC, t0.sort_order ASC, t0.id ASC

Parameters:

[
  408
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tag_group AS tag_group_2,
  t0.tag_value AS tag_value_3,
  t0.sort_order AS sort_order_4,
  t0.spell_id AS spell_id_5
FROM
  dnd_spell_tag t0
WHERE
  t0.spell_id = ?
ORDER BY
  t0.tag_group ASC,
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.tag_group AS tag_group_2, t0.tag_value AS tag_value_3, t0.sort_order AS sort_order_4, t0.spell_id AS spell_id_5 FROM dnd_spell_tag t0 WHERE t0.spell_id = 408 ORDER BY t0.tag_group ASC, 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_990d23025b1e6852d08f0bd097697578::block_body (line 191)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4136223d673f867ac097f6b82913dfcb->doDisplay (line 172)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_990d23025b1e6852d08f0bd097697578->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
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\Compendium\CompendiumController->show (line 120)
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 35)
27	require_once (line 32)
28	require_once (line 5)

0.17 ms
(2.26%)

SELECT t0.id AS id_1, t0.scaling_type AS scaling_type_2, t0.label AS label_3, t0.level AS level_4, t0.value_text AS value_text_5, t0.sort_order AS sort_order_6, t0.spell_id AS spell_id_7 FROM dnd_spell_scaling t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[
  408
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.scaling_type AS scaling_type_2,
  t0.label AS label_3,
  t0.level AS level_4,
  t0.value_text AS value_text_5,
  t0.sort_order AS sort_order_6,
  t0.spell_id AS spell_id_7
FROM
  dnd_spell_scaling t0
WHERE
  t0.spell_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.scaling_type AS scaling_type_2, t0.label AS label_3, t0.level AS level_4, t0.value_text AS value_text_5, t0.sort_order AS sort_order_6, t0.spell_id AS spell_id_7 FROM dnd_spell_scaling t0 WHERE t0.spell_id = 408 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_990d23025b1e6852d08f0bd097697578::block_body (line 158)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4136223d673f867ac097f6b82913dfcb->doDisplay (line 172)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_990d23025b1e6852d08f0bd097697578->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
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\Compendium\CompendiumController->show (line 120)
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 35)
27	require_once (line 32)
28	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\DndSpellEntryBlock	13
App\Entity\DndSpellTag	9
App\Entity\DndSpell	2
App\Entity\DndSpellCastingTime	1
App\Entity\DndSpellComponent	1

Entities Mapping

Class	Mapping errors
App\Entity\DndSpell	No errors.
App\Entity\DndSpellCastingTime	No errors.
App\Entity\DndSpellRange	No errors.
App\Entity\DndSpellComponent	No errors.
App\Entity\DndSpellDuration	No errors.
App\Entity\DndSpellTag	No errors.
App\Entity\DndSpellEntryBlock	No errors.
App\Entity\DndSpellScaling	No errors.

Symfony Profiler

GET https://www.arrowscauldron.com/compendium/spells/bigby-s-hand?source=PHB

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping