Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.67 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:
[
  5897
]
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 3.52 ms
SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_
Parameters:
[]
4 1.92 ms
SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC
Parameters:
[]
5 1.70 ms
SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC
Parameters:
[]
6 3.12 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.