Symfony Profiler

Query Metrics

23 Database Queries

23 Different statements

11.36 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.67 ms
(23.52%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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)

1.75 ms
(15.39%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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)

1.04 ms
(9.13%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.65 ms
(5.71%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.48 ms
(4.21%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_deity 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.44 ms
(3.89%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_reward 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.42 ms
(3.68%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_optional_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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.38 ms
(3.31%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_recipe 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.32 ms
(2.81%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.32 ms
(2.80%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_bastion_facility 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.29 ms
(2.57%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.26 ms
(2.28%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.25 ms
(2.23%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_monster_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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.06%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.03%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_object 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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
(1.99%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_cult 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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
(1.93%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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
(1.90%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_trap 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.21 ms
(1.83%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_psionic 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.20 ms
(1.76%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.20 ms
(1.72%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.19 ms
(1.65%)

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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.18 ms
(1.61%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(DISTINCT d0_.slug) AS sclr_0 FROM dnd_skill 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 351)
8	App\Service\Compendium\CompendiumSearchService->familiesWithCounts (line 19)
9	App\Controller\Compendium\CompendiumController->index (line 30)
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.
App\Entity\DndSkill	No errors.
App\Entity\DndObject	No errors.
App\Entity\DndReward	No errors.
App\Entity\DndTrap	No errors.
App\Entity\DndRecipe	No errors.
App\Entity\DndPsionic	No errors.
App\Entity\DndOptionalFeature	No errors.
App\Entity\DndMonsterFeature	No errors.
App\Entity\DndDeity	No errors.
App\Entity\DndCult	No errors.
App\Entity\DndBastionFacility	No errors.

Symfony Profiler

GET https://arrowscauldron.com/cauldron

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping