Query Metrics

6 Database Queries
6 Different statements
14.24 ms Query time
0 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 6.87 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 = 6900
Parameters:
[]
2 1.57 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 1.40 ms
SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_
Parameters:
[]
4 1.40 ms
SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC
Parameters:
[]
5 1.27 ms
SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC
Parameters:
[]
6 1.74 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 5
App\Entity\Nomination 5
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.