GET https://www.caucasusmusic.com/band/5810

Query Metrics

6 Database Queries
6 Different statements
8.71 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 2.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.imageName AS imageName_3, t0.updated_at AS updated_at_4, t0.url AS url_5, t0.description AS description_6, t0.summary AS summary_7, t0.email AS email_8, t0.password AS password_9 FROM band t0 WHERE t0.id = ?
Parameters:
[
  5810
]
2 1.38 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.27 ms
SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_
Parameters:
[]
4 1.58 ms
SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC
Parameters:
[]
5 1.24 ms
SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC
Parameters:
[]
6 1.18 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\Band 1
App\Entity\Variable 1

Entities Mapping

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