Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.39 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.66 ms
(68.00%)

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, b1_.id AS id_10, b1_.name AS name_11, b1_.imageName AS imageName_12, b1_.updated_at AS updated_at_13, b1_.url AS url_14, b1_.description AS description_15, b1_.summary AS summary_16, b1_.email AS email_17, b1_.password AS password_18, c2_.id AS id_19, c2_.title AS title_20, c2_.year AS year_21, c2_.start AS start_22, c2_.end AS end_23, c2_.imageName AS imageName_24, c2_.updated_at AS updated_at_25, c0_.band_id AS band_id_26, c2_.laureate AS laureate_27, c2_.nomination_id AS nomination_id_28 FROM composition c0_ LEFT JOIN band b1_ ON c0_.band_id = b1_.id LEFT JOIN comp_ref c3_ ON c0_.id = c3_.composition_id LEFT JOIN competition c2_ ON c2_.id = c3_.competition_id WHERE c0_.id = 7036

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,
  b1_.id AS id_10,
  b1_.name AS name_11,
  b1_.imageName AS imageName_12,
  b1_.updated_at AS updated_at_13,
  b1_.url AS url_14,
  b1_.description AS description_15,
  b1_.summary AS summary_16,
  b1_.email AS email_17,
  b1_.password AS password_18,
  c2_.id AS id_19,
  c2_.title AS title_20,
  c2_.year AS year_21,
  c2_.start AS start_22,
  c2_.end AS end_23,
  c2_.imageName AS imageName_24,
  c2_.updated_at AS updated_at_25,
  c0_.band_id AS band_id_26,
  c2_.laureate AS laureate_27,
  c2_.nomination_id AS nomination_id_28
FROM
  composition c0_
  LEFT JOIN band b1_ ON c0_.band_id = b1_.id
  LEFT JOIN comp_ref c3_ ON c0_.id = c3_.composition_id
  LEFT JOIN competition c2_ ON c2_.id = c3_.competition_id
WHERE
  c0_.id = 7036

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, b1_.id AS id_10, b1_.name AS name_11, b1_.imageName AS imageName_12, b1_.updated_at AS updated_at_13, b1_.url AS url_14, b1_.description AS description_15, b1_.summary AS summary_16, b1_.email AS email_17, b1_.password AS password_18, c2_.id AS id_19, c2_.title AS title_20, c2_.year AS year_21, c2_.start AS start_22, c2_.end AS end_23, c2_.imageName AS imageName_24, c2_.updated_at AS updated_at_25, c0_.band_id AS band_id_26, c2_.laureate AS laureate_27, c2_.nomination_id AS nomination_id_28 FROM composition c0_ LEFT JOIN band b1_ ON c0_.band_id = b1_.id LEFT JOIN comp_ref c3_ ON c0_.id = c3_.composition_id LEFT JOIN competition c2_ ON c2_.id = c3_.competition_id WHERE c0_.id = 7036;

#	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->getOneOrNullResult (line 738)
6	App\Controller\CompositionController->index (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)

1.72 ms
(32.00%)

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\CompositionController->index (line 50)
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)

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\Competition	2
App\Entity\Nomination	2
App\Entity\Composition	1
App\Entity\Band	1
App\Entity\Variable	1

Entities Mapping

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

Symfony Profiler

GET https://caucasusmusic.com/comp/7036

Configuration Settings

Theme

Page Width