GET https://www.caucasusmusic.com/

Query Metrics

13 Database Queries
11 Different statements
35.22 ms Query time
0 Invalid entities
42 Managed entities

Queries

Group similar statements

# Time Info
1 4.65 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:
[
  "announcement"
]
2 1.20 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 4.71 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.imageName AS imageName_2, p0_.updated_at AS updated_at_3, p0_.caption AS caption_4, p0_.published AS published_5, p0_.date AS date_6, p0_.slideshow AS slideshow_7, p0_.gallery_id AS gallery_id_8 FROM photo p0_ WHERE p0_.slideshow = 1
Parameters:
[]
4 1.48 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:
[
  "currentYear"
]
5 4.53 ms
SELECT c0_.id AS id_0, c0_.year AS year_1, c0_.imageName AS imageName_2, n1_.title AS title_3, n1_.id AS id_4 FROM competition c0_ LEFT JOIN nomination n1_ ON c0_.nomination_id = n1_.id WHERE c0_.year = ?
Parameters:
[
  2026
]
6 2.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.date AS date_3, t0.description AS description_4, t0.summary AS summary_5, t0.published AS published_6 FROM gallery t0 ORDER BY t0.date DESC LIMIT 1
Parameters:
[]
7 4.38 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, c0_.band_id AS band_id_10 FROM composition c0_ WHERE c0_.approved = 1 ORDER BY c0_.uploaded DESC LIMIT 3
Parameters:
[]
8 1.23 ms
SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_
Parameters:
[]
9 1.50 ms
SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC
Parameters:
[]
10 3.26 ms
SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC
Parameters:
[]
11 1.22 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:
[]
12 3.50 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:
[
  5990
]
13 1.50 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.imageName AS imageName_3, t0.updated_at AS updated_at_4, t0.caption AS caption_5, t0.published AS published_6, t0.date AS date_7, t0.slideshow AS slideshow_8, t0.gallery_id AS gallery_id_9 FROM photo t0 WHERE t0.gallery_id = ?
Parameters:
[
  9
]

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\Photo 34
App\Entity\Variable 3
App\Entity\Composition 3
App\Entity\Gallery 1
App\Entity\Band 1

Entities Mapping

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