Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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

[
  "siteTitle"
]

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

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 = 'siteTitle' LIMIT 1;

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.date AS date_2, m0_.url AS url_3, m0_.name AS name_4, m0_.media_type AS media_type_5, m0_.year AS year_6, m0_.published AS published_7 FROM media m0_ WHERE m0_.year = 2016 AND m0_.media_type = 'PARTICIPANTS' ORDER BY m0_.date ASC

[]

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.date AS date_2,
  m0_.url AS url_3,
  m0_.name AS name_4,
  m0_.media_type AS media_type_5,
  m0_.year AS year_6,
  m0_.published AS published_7
FROM
  media m0_
WHERE
  m0_.year = 2016
  AND m0_.media_type = 'PARTICIPANTS'
ORDER BY
  m0_.date ASC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.date AS date_2, m0_.url AS url_3, m0_.name AS name_4, m0_.media_type AS media_type_5, m0_.year AS year_6, m0_.published AS published_7 FROM media m0_ WHERE m0_.year = 2016 AND m0_.media_type = 'PARTICIPANTS' ORDER BY m0_.date ASC;

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.imageName AS imageName_2, c1_.title AS title_3, c1_.id AS id_4, b2_.name AS name_5 FROM competition c0_ LEFT JOIN composition c1_ ON c0_.laureate = c1_.id LEFT JOIN band b2_ ON c1_.band_id = b2_.id WHERE c0_.year = 2016

[]

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.imageName AS imageName_2,
  c1_.title AS title_3,
  c1_.id AS id_4,
  b2_.name AS name_5
FROM
  competition c0_
  LEFT JOIN composition c1_ ON c0_.laureate = c1_.id
  LEFT JOIN band b2_ ON c1_.band_id = b2_.id
WHERE
  c0_.year = 2016

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.imageName AS imageName_2, c1_.title AS title_3, c1_.id AS id_4, b2_.name AS name_5 FROM competition c0_ LEFT JOIN composition c1_ ON c0_.laureate = c1_.id LEFT JOIN band b2_ ON c1_.band_id = b2_.id WHERE c0_.year = 2016;

SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_

[]

SELECT
  n0_.title AS title_0,
  n0_.id AS id_1
FROM
  nomination n0_

SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_;

SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC

[]

SELECT
  DISTINCT c0_.year AS year_0
FROM
  competition c0_
ORDER BY
  c0_.year DESC

SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC;

SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC

[]

SELECT
  DISTINCT m0_.year AS year_0
FROM
  media m0_
ORDER BY
  m0_.year DESC

SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC;

SELECT DISTINCT g0_.id AS id_0, g0_.title AS title_1 FROM gallery g0_ WHERE g0_.published = 1 ORDER BY g0_.title DESC

[]

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.title AS title_1
FROM
  gallery g0_
WHERE
  g0_.published = 1
ORDER BY
  g0_.title DESC

SELECT DISTINCT g0_.id AS id_0, g0_.title AS title_1 FROM gallery g0_ WHERE g0_.published = 1 ORDER BY g0_.title DESC;