Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

174.71 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

83.36 ms
(47.71%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.date AS date_2, m0_.url AS url_3, m0_.name AS name_4, m0_.media_type AS media_type_5, m0_.year AS year_6, m0_.published AS published_7 FROM media m0_ WHERE m0_.year = 2022 AND m0_.media_type = 'TV' ORDER BY m0_.date DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.date AS date_2,
  m0_.url AS url_3,
  m0_.name AS name_4,
  m0_.media_type AS media_type_5,
  m0_.year AS year_6,
  m0_.published AS published_7
FROM
  media m0_
WHERE
  m0_.year = 2022
  AND m0_.media_type = 'TV'
ORDER BY
  m0_.date DESC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.date AS date_2, m0_.url AS url_3, m0_.name AS name_4, m0_.media_type AS media_type_5, m0_.year AS year_6, m0_.published AS published_7 FROM media m0_ WHERE m0_.year = 2022 AND m0_.media_type = 'TV' ORDER BY m0_.date DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\InMediaController->media (line 31)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 7)

80.87 ms
(46.29%)

SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.year AS year_0
FROM
  media m0_
ORDER BY
  m0_.year DESC

SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 701)
6	App\Controller\HeaderController->renderHeader (line 38)
7	App\Controller\HeaderController->App\Controller\{closure} (line 19)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 48)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 104)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 111)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 53)
15	App\Controller\HeaderController->headerAction (line 20)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
23	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->block_body (line 108)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_23fea9f78ed90ce3d4a2a0626485c327->doDisplay (line 89)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->doDisplay (line 60)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_858a5ec62cae4bd9ef55d5d63a66e2c9->doDisplay (line 53)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
38	App\Controller\InMediaController->media (line 38)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 197)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 29)
44	require_once (line 7)

3.47 ms
(1.99%)

SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.title AS title_0,
  n0_.id AS id_1
FROM
  nomination n0_

SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 701)
6	App\Controller\HeaderController->renderHeader (line 32)
7	App\Controller\HeaderController->App\Controller\{closure} (line 19)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 48)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 104)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 111)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 53)
15	App\Controller\HeaderController->headerAction (line 20)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
23	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->block_body (line 108)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_23fea9f78ed90ce3d4a2a0626485c327->doDisplay (line 89)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->doDisplay (line 60)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_858a5ec62cae4bd9ef55d5d63a66e2c9->doDisplay (line 53)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
38	App\Controller\InMediaController->media (line 38)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 197)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 29)
44	require_once (line 7)

2.86 ms
(1.64%)

SELECT t0.id AS id_1, t0.vType AS vType_2, t0.name AS name_3, t0.value AS value_4 FROM variable t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "siteTitle"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.vType AS vType_2,
  t0.name AS name_3,
  t0.value AS value_4
FROM
  variable t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.vType AS vType_2, t0.name AS name_3, t0.value AS value_4 FROM variable t0 WHERE t0.name = 'siteTitle' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\VariableRepository->getVariable (line 22)
5	App\Controller\InMediaController->media (line 29)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 7)

2.19 ms
(1.25%)

SELECT DISTINCT g0_.id AS id_0, g0_.title AS title_1 FROM gallery g0_ WHERE g0_.published = 1 ORDER BY g0_.title DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.title AS title_1
FROM
  gallery g0_
WHERE
  g0_.published = 1
ORDER BY
  g0_.title DESC

SELECT DISTINCT g0_.id AS id_0, g0_.title AS title_1 FROM gallery g0_ WHERE g0_.published = 1 ORDER BY g0_.title DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 701)
6	App\Controller\HeaderController->renderHeader (line 41)
7	App\Controller\HeaderController->App\Controller\{closure} (line 19)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 48)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 104)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 111)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 53)
15	App\Controller\HeaderController->headerAction (line 20)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
23	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->block_body (line 108)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_23fea9f78ed90ce3d4a2a0626485c327->doDisplay (line 89)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->doDisplay (line 60)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_858a5ec62cae4bd9ef55d5d63a66e2c9->doDisplay (line 53)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
38	App\Controller\InMediaController->media (line 38)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 197)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 29)
44	require_once (line 7)

1.96 ms
(1.12%)

SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c0_.year AS year_0
FROM
  competition c0_
ORDER BY
  c0_.year DESC

SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 701)
6	App\Controller\HeaderController->renderHeader (line 35)
7	App\Controller\HeaderController->App\Controller\{closure} (line 19)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 48)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 104)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 111)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 53)
15	App\Controller\HeaderController->headerAction (line 20)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
23	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->block_body (line 108)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_23fea9f78ed90ce3d4a2a0626485c327->doDisplay (line 89)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->doDisplay (line 60)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_858a5ec62cae4bd9ef55d5d63a66e2c9->doDisplay (line 53)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
38	App\Controller\InMediaController->media (line 38)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 197)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 29)
44	require_once (line 7)

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\Media	4
App\Entity\Variable	1

Entities Mapping

Class	Mapping errors
App\Entity\Variable	No errors.
App\Entity\Media	No errors.
App\Entity\Nomination	No errors.
App\Entity\Competition	No errors.
App\Entity\Gallery	No errors.
App\Entity\Composition	No errors.
App\Entity\Member	No errors.
App\Entity\Photo	No errors.

Symfony Profiler

GET https://caucasusmusic.com/in_media/2022

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping