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

Query Metrics

6 Database Queries
6 Different statements
13.69 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 3.78 ms
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 = 4934
Parameters:
[]
2 1.71 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"
]
3 3.47 ms
SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_
Parameters:
[]
4 1.51 ms
SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC
Parameters:
[]
5 1.76 ms
SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC
Parameters:
[]
6 1.46 ms
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:
[]

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\Composition 6
App\Entity\Competition 6
App\Entity\Nomination 6
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.
App\Entity\Media No errors.
App\Entity\Gallery No errors.
App\Entity\Photo No errors.