Symfony Profiler

Query Metrics

12 Database Queries

12 Different statements

8.07 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.88 ms
(35.66%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_monster d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_monster d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_monster d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

2.11 ms
(26.11%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_item d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_item d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_item d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.64 ms
(7.94%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_spell d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_spell d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_spell d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.37 ms
(4.55%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_class_feature d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_class_feature d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_class_feature d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.33 ms
(4.14%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_feat d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_feat d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_feat d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.30 ms
(3.71%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_race d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_race d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_race d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.28 ms
(3.47%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_background d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_background d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_background d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.27 ms
(3.38%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_language d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_language d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_language d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.23 ms
(2.80%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_class d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_class d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_class d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.23 ms
(2.79%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_condition d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_condition d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_condition d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.22 ms
(2.75%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_sense d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_sense d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_sense d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.22 ms
(2.69%)

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_action d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.slug) AS sclr_0
FROM
  dnd_action d0_

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_action d0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\Compendium\CompendiumSearchService->countDistinctEntries (line 284)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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

Entities Mapping

Class	Mapping errors
App\Entity\DndMonster	No errors.
App\Entity\DndSpell	No errors.
App\Entity\DndCondition	No errors.
App\Entity\DndAction	No errors.
App\Entity\DndItem	No errors.
App\Entity\DndRace	No errors.
App\Entity\DndClass	No errors.
App\Entity\DndClassFeature	No errors.
App\Entity\DndBackground	No errors.
App\Entity\DndFeat	No errors.
App\Entity\DndSense	No errors.
App\Entity\DndLanguage	No errors.

Symfony Profiler

GET https://arrowscauldron.com/compendium

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping