Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

15.40 ms Query time

0 Invalid entities

42 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.81 ms
(31.24%)

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:

[
  "announcement"
]

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 = 'announcement' 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\HomePageController->index (line 30)
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.67 ms
(17.31%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.url AS url_2, c0_.imageName AS imageName_3, c0_.description AS description_4, c0_.updated_at AS updated_at_5, c0_.approved AS approved_6, c0_.uploaded AS uploaded_7, c0_.votes1 AS votes1_8, c0_.votes2 AS votes2_9, c0_.band_id AS band_id_10 FROM composition c0_ WHERE c0_.approved = 1 ORDER BY c0_.uploaded DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.url AS url_2,
  c0_.imageName AS imageName_3,
  c0_.description AS description_4,
  c0_.updated_at AS updated_at_5,
  c0_.approved AS approved_6,
  c0_.uploaded AS uploaded_7,
  c0_.votes1 AS votes1_8,
  c0_.votes2 AS votes2_9,
  c0_.band_id AS band_id_10
FROM
  composition c0_
WHERE
  c0_.approved = 1
ORDER BY
  c0_.uploaded DESC
LIMIT
  3

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.url AS url_2, c0_.imageName AS imageName_3, c0_.description AS description_4, c0_.updated_at AS updated_at_5, c0_.approved AS approved_6, c0_.uploaded AS uploaded_7, c0_.votes1 AS votes1_8, c0_.votes2 AS votes2_9, c0_.band_id AS band_id_10 FROM composition c0_ WHERE c0_.approved = 1 ORDER BY c0_.uploaded DESC LIMIT 3;

#	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\HomePageController->index (line 42)
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)

1.86 ms
(12.07%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.imageName AS imageName_2, p0_.updated_at AS updated_at_3, p0_.caption AS caption_4, p0_.published AS published_5, p0_.date AS date_6, p0_.slideshow AS slideshow_7, p0_.gallery_id AS gallery_id_8 FROM photo p0_ WHERE p0_.slideshow = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.imageName AS imageName_2,
  p0_.updated_at AS updated_at_3,
  p0_.caption AS caption_4,
  p0_.published AS published_5,
  p0_.date AS date_6,
  p0_.slideshow AS slideshow_7,
  p0_.gallery_id AS gallery_id_8
FROM
  photo p0_
WHERE
  p0_.slideshow = 1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.imageName AS imageName_2, p0_.updated_at AS updated_at_3, p0_.caption AS caption_4, p0_.published AS published_5, p0_.date AS date_6, p0_.slideshow AS slideshow_7, p0_.gallery_id AS gallery_id_8 FROM photo p0_ WHERE p0_.slideshow = 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\HomePageController->index (line 33)
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)

1.78 ms
(11.53%)

SELECT c0_.id AS id_0, c0_.year AS year_1, c0_.imageName AS imageName_2, n1_.title AS title_3, n1_.id AS id_4 FROM competition c0_ LEFT JOIN nomination n1_ ON c0_.nomination_id = n1_.id WHERE c0_.year = ?

Parameters:

[
  2026
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.year AS year_1,
  c0_.imageName AS imageName_2,
  n1_.title AS title_3,
  n1_.id AS id_4
FROM
  competition c0_
  LEFT JOIN nomination n1_ ON c0_.nomination_id = n1_.id
WHERE
  c0_.year = ?

SELECT c0_.id AS id_0, c0_.year AS year_1, c0_.imageName AS imageName_2, n1_.title AS title_3, n1_.id AS id_4 FROM competition c0_ LEFT JOIN nomination n1_ ON c0_.nomination_id = n1_.id WHERE c0_.year = 2026;

#	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\HomePageController->index (line 36)
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)

1.56 ms
(10.14%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.imageName AS imageName_3, t0.updated_at AS updated_at_4, t0.url AS url_5, t0.description AS description_6, t0.summary AS summary_7, t0.email AS email_8, t0.password AS password_9 FROM band t0 WHERE t0.id = ?

Parameters:

[
  5990
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.imageName AS imageName_3,
  t0.updated_at AS updated_at_4,
  t0.url AS url_5,
  t0.description AS description_6,
  t0.summary AS summary_7,
  t0.email AS email_8,
  t0.password AS password_9
FROM
  band t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.imageName AS imageName_3, t0.updated_at AS updated_at_4, t0.url AS url_5, t0.description AS description_6, t0.summary AS summary_7, t0.email AS email_8, t0.password AS password_9 FROM band t0 WHERE t0.id = 5990;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Band::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Band->__get (line 184)
7	App\Entity\Band->getName (line 52)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_d77e9b7256ccea66128a88fcf1fabba8::doDisplay (line 82)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_66c5970e12de7f7432b336944e7e632a->block_content (line 83)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->block_body (line 113)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_23fea9f78ed90ce3d4a2a0626485c327->doDisplay (line 89)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->doDisplay (line 60)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_66c5970e12de7f7432b336944e7e632a->doDisplay (line 56)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
28	App\Controller\HomePageController->index (line 49)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 197)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 7)

1.47 ms
(9.56%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.imageName AS imageName_3, t0.updated_at AS updated_at_4, t0.caption AS caption_5, t0.published AS published_6, t0.date AS date_7, t0.slideshow AS slideshow_8, t0.gallery_id AS gallery_id_9 FROM photo t0 WHERE t0.gallery_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.imageName AS imageName_3,
  t0.updated_at AS updated_at_4,
  t0.caption AS caption_5,
  t0.published AS published_6,
  t0.date AS date_7,
  t0.slideshow AS slideshow_8,
  t0.gallery_id AS gallery_id_9
FROM
  photo t0
WHERE
  t0.gallery_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.imageName AS imageName_3, t0.updated_at AS updated_at_4, t0.caption AS caption_5, t0.published AS published_6, t0.date AS date_7, t0.slideshow AS slideshow_8, t0.gallery_id AS gallery_id_9 FROM photo t0 WHERE t0.gallery_id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_e7cc36c09120493ec2a9a85a9b713381->doDisplay (line 64)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_66c5970e12de7f7432b336944e7e632a->block_content (line 109)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->block_body (line 113)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_23fea9f78ed90ce3d4a2a0626485c327->doDisplay (line 89)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_0f39effcdfb454f9775d98c5467104c3->doDisplay (line 60)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_66c5970e12de7f7432b336944e7e632a->doDisplay (line 56)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
27	App\Controller\HomePageController->index (line 49)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 197)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 7)

1.25 ms
(8.14%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.date AS date_3, t0.description AS description_4, t0.summary AS summary_5, t0.published AS published_6 FROM gallery t0 ORDER BY t0.date DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.date AS date_3,
  t0.description AS description_4,
  t0.summary AS summary_5,
  t0.published AS published_6
FROM
  gallery t0
ORDER BY
  t0.date DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.date AS date_3, t0.description AS description_4, t0.summary AS summary_5, t0.published AS published_6 FROM gallery t0 ORDER BY t0.date DESC 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\Controller\HomePageController->index (line 37)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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\Photo	34
App\Entity\Variable	3
App\Entity\Composition	3
App\Entity\Gallery	1
App\Entity\Band	1

Entities Mapping

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

Symfony Profiler

GET https://caucasusmusic.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping