Symfony Profiler

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

Query Metrics

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_ LEFT JOIN country c1_ ON c0_.country_id = c1_.id 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_
  LEFT JOIN country c1_ ON c0_.country_id = c1_.id
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_ LEFT JOIN country c1_ ON c0_.country_id = c1_.id 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;

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.city_id = ?

[
  4
]

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.city_id = ?

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.city_id = 4;

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.english_name AS english_name_4, t0.continent_id AS continent_id_5 FROM country t0 WHERE t0.id = ?

[
  107
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.english_name AS english_name_4,
  t0.continent_id AS continent_id_5
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.english_name AS english_name_4, t0.continent_id AS continent_id_5 FROM country t0 WHERE t0.id = 107;

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.city_id = ?

[
  3
]

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.city_id = ?

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.city_id = 3;

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.english_name AS english_name_4, t0.continent_id AS continent_id_5 FROM country t0 WHERE t0.id = ?

[
  71
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.english_name AS english_name_4,
  t0.continent_id AS continent_id_5
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.english_name AS english_name_4, t0.continent_id AS continent_id_5 FROM country t0 WHERE t0.id = 71;

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.city_id = ?

[
  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.city_id = ?

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.city_id = 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.city_id = ?

[
  5
]

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.city_id = ?

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.city_id = 5;