Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.id_ffn AS id_ffn_5, t0.filename AS filename_6, t0.type_distribution AS type_distribution_7, t0.short_name AS short_name_8, t0.city_id AS city_id_9, t0.competition_type_id AS competition_type_id_10, t0.competition_discipline_id AS competition_discipline_id_11, t0.pool_size_id AS pool_size_id_12 FROM competition t0 WHERE t0.id = ? LIMIT 1

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.id_ffn AS id_ffn_5,
  t0.filename AS filename_6,
  t0.type_distribution AS type_distribution_7,
  t0.short_name AS short_name_8,
  t0.city_id AS city_id_9,
  t0.competition_type_id AS competition_type_id_10,
  t0.competition_discipline_id AS competition_discipline_id_11,
  t0.pool_size_id AS pool_size_id_12
FROM
  competition t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.id_ffn AS id_ffn_5, t0.filename AS filename_6, t0.type_distribution AS type_distribution_7, t0.short_name AS short_name_8, t0.city_id AS city_id_9, t0.competition_type_id AS competition_type_id_10, t0.competition_discipline_id AS competition_discipline_id_11, t0.pool_size_id AS pool_size_id_12 FROM competition t0 WHERE t0.id = 1 LIMIT 1;

SELECT p0_.id AS id_0, p0_.size AS size_1, p0_.metric AS metric_2 FROM pool_size p0_ ORDER BY p0_.size ASC

[]

SELECT
  p0_.id AS id_0,
  p0_.size AS size_1,
  p0_.metric AS metric_2
FROM
  pool_size p0_
ORDER BY
  p0_.size ASC

SELECT p0_.id AS id_0, p0_.size AS size_1, p0_.metric AS metric_2 FROM pool_size p0_ ORDER BY p0_.size ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_ffn AS name_ffn_2, c0_.country_id AS country_id_3 FROM city c0_ ORDER BY c0_.name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.name_ffn AS name_ffn_2,
  c0_.country_id AS country_id_3
FROM
  city c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_ffn AS name_ffn_2, c0_.country_id AS country_id_3 FROM city c0_ ORDER BY c0_.name ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.id_ffn AS id_ffn_2 FROM competition_type c0_ ORDER BY c0_.name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.id_ffn AS id_ffn_2
FROM
  competition_type c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.id_ffn AS id_ffn_2 FROM competition_type c0_ ORDER BY c0_.name ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.id_ffn AS id_ffn_2 FROM competition_discipline c0_ ORDER BY c0_.name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.id_ffn AS id_ffn_2
FROM
  competition_discipline c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.id_ffn AS id_ffn_2 FROM competition_discipline c0_ ORDER BY c0_.name ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, COUNT(c2_.id) AS sclr_4 FROM competition c2_ INNER JOIN competition_type c0_ ON c2_.competition_type_id = c0_.id INNER JOIN competition_discipline c1_ ON c2_.competition_discipline_id = c1_.id GROUP BY c0_.id, c0_.name, c1_.id, c1_.name ORDER BY c1_.id ASC, c0_.id ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c1_.id AS id_2,
  c1_.name AS name_3,
  COUNT(c2_.id) AS sclr_4
FROM
  competition c2_
  INNER JOIN competition_type c0_ ON c2_.competition_type_id = c0_.id
  INNER JOIN competition_discipline c1_ ON c2_.competition_discipline_id = c1_.id
GROUP BY
  c0_.id,
  c0_.name,
  c1_.id,
  c1_.name
ORDER BY
  c1_.id ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, COUNT(c2_.id) AS sclr_4 FROM competition c2_ INNER JOIN competition_type c0_ ON c2_.competition_type_id = c0_.id INNER JOIN competition_discipline c1_ ON c2_.competition_discipline_id = c1_.id GROUP BY c0_.id, c0_.name, c1_.id, c1_.name ORDER BY c1_.id ASC, c0_.id ASC;