GET https://caucasusmusic.com/comps/1

Query Metrics

4 Database Queries
3 Different statements
7.76 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 2.58 ms
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"
]
2 1.42 ms
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:
[
  "currentYear"
]
3 1.31 ms
SELECT n0_.title AS title_0 FROM nomination n0_ WHERE n0_.id = 1
Parameters:
[]
4 2.46 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.imageName AS imageName_2, b1_.name AS name_3 FROM composition c0_ LEFT JOIN comp_ref c3_ ON c0_.id = c3_.composition_id LEFT JOIN competition c2_ ON c2_.id = c3_.competition_id LEFT JOIN nomination n4_ ON c2_.nomination_id = n4_.id LEFT JOIN band b1_ ON c0_.band_id = b1_.id WHERE c2_.year = 2026 AND n4_.id = 1
Parameters:
[]

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\Variable 2

Entities Mapping

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