GET https://www.caucasusmusic.com/comp/7037

Query Metrics

2 Database Queries
2 Different statements
4.58 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 3.35 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 = 7037
Parameters:
[]
2 1.24 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"
]

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 6
App\Entity\Nomination 6
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.