Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

7.76 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.97 ms
(51.14%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.caster_type AS caster_type_3, t0.hit_die AS hit_die_4, t0.primary_ability AS primary_ability_5, t0.save_proficiencies AS save_proficiencies_6, t0.short_description AS short_description_7, t0.main_image AS main_image_8, t0.icon AS icon_9, t0.full_class_flavor_text AS full_class_flavor_text_10, t0.class_table AS class_table_11, t0.armor_proficiencies AS armor_proficiencies_12, t0.weapon_proficiencies AS weapon_proficiencies_13, t0.tool_proficiencies AS tool_proficiencies_14, t0.skill_proficiencies AS skill_proficiencies_15, t0.starting_equipment AS starting_equipment_16, t0.feature_description AS feature_description_17, t0.main_image_full_size AS main_image_full_size_18, t0.background_image AS background_image_19, t0.background_image_large AS background_image_large_20, t0.comment AS comment_21 FROM character_class t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.caster_type AS caster_type_3,
  t0.hit_die AS hit_die_4,
  t0.primary_ability AS primary_ability_5,
  t0.save_proficiencies AS save_proficiencies_6,
  t0.short_description AS short_description_7,
  t0.main_image AS main_image_8,
  t0.icon AS icon_9,
  t0.full_class_flavor_text AS full_class_flavor_text_10,
  t0.class_table AS class_table_11,
  t0.armor_proficiencies AS armor_proficiencies_12,
  t0.weapon_proficiencies AS weapon_proficiencies_13,
  t0.tool_proficiencies AS tool_proficiencies_14,
  t0.skill_proficiencies AS skill_proficiencies_15,
  t0.starting_equipment AS starting_equipment_16,
  t0.feature_description AS feature_description_17,
  t0.main_image_full_size AS main_image_full_size_18,
  t0.background_image AS background_image_19,
  t0.background_image_large AS background_image_large_20,
  t0.comment AS comment_21
FROM
  character_class t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.caster_type AS caster_type_3, t0.hit_die AS hit_die_4, t0.primary_ability AS primary_ability_5, t0.save_proficiencies AS save_proficiencies_6, t0.short_description AS short_description_7, t0.main_image AS main_image_8, t0.icon AS icon_9, t0.full_class_flavor_text AS full_class_flavor_text_10, t0.class_table AS class_table_11, t0.armor_proficiencies AS armor_proficiencies_12, t0.weapon_proficiencies AS weapon_proficiencies_13, t0.tool_proficiencies AS tool_proficiencies_14, t0.skill_proficiencies AS skill_proficiencies_15, t0.starting_equipment AS starting_equipment_16, t0.feature_description AS feature_description_17, t0.main_image_full_size AS main_image_full_size_18, t0.background_image AS background_image_19, t0.background_image_large AS background_image_large_20, t0.comment AS comment_21 FROM character_class t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 42)
5	App\Service\NavigationData->injectGlobalVariables (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.88 ms
(24.25%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.short_description AS short_description_3, t0.main_image AS main_image_4, t0.name AS name_5, t0.icon AS icon_6, t0.background_image AS background_image_7, t0.background_image_large AS background_image_large_8, t0.comment AS comment_9 FROM race t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.short_description AS short_description_3,
  t0.main_image AS main_image_4,
  t0.name AS name_5,
  t0.icon AS icon_6,
  t0.background_image AS background_image_7,
  t0.background_image_large AS background_image_large_8,
  t0.comment AS comment_9
FROM
  race t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.description AS description_2, t0.short_description AS short_description_3, t0.main_image AS main_image_4, t0.name AS name_5, t0.icon AS icon_6, t0.background_image AS background_image_7, t0.background_image_large AS background_image_large_8, t0.comment AS comment_9 FROM race t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 41)
5	App\Service\NavigationData->injectGlobalVariables (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.97 ms
(12.47%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.short_description AS short_description_3, t0.name AS name_4, t0.icon AS icon_5 FROM background t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.short_description AS short_description_3,
  t0.name AS name_4,
  t0.icon AS icon_5
FROM
  background t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.description AS description_2, t0.short_description AS short_description_3, t0.name AS name_4, t0.icon AS icon_5 FROM background t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 44)
5	App\Service\NavigationData->injectGlobalVariables (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.94 ms
(12.14%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.positives AS positives_3, t0.negatives AS negatives_4, t0.description AS description_5, t0.comment AS comment_6 FROM legacy t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.positives AS positives_3,
  t0.negatives AS negatives_4,
  t0.description AS description_5,
  t0.comment AS comment_6
FROM
  legacy t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.positives AS positives_3, t0.negatives AS negatives_4, t0.description AS description_5, t0.comment AS comment_6 FROM legacy t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 45)
5	App\Service\NavigationData->injectGlobalVariables (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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.

Entities Mapping

Class	Mapping errors
App\Entity\Race	No errors.
App\Entity\Subrace	No errors.
App\Entity\CharacterClass	No errors.
App\Entity\Spell	No errors.
App\Entity\CharacterSubclass	No errors.
App\Entity\Background	No errors.
App\Entity\SecondaryBackground	No errors.
App\Entity\Legacy	The mappings App\Entity\Legacy#subLegacy and App\Entity\SubLegacy#legacy are inconsistent with each other.
App\Entity\SubLegacy	The association App\Entity\SubLegacy#legacy refers to the inverse side field App\Entity\Legacy#SubLegacy which does not exist.

Symfony Profiler

GET https://palanthira.cz/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping