Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.birth_date AS birth_date_4, t0.id_ffn AS id_ffn_5, t0.last_competition_date_update AS last_competition_date_update_6, t0.country_id AS country_id_7, t0.club_id AS club_id_8, t0.gender_id AS gender_id_9 FROM swimmer t0 WHERE t0.id = ? LIMIT 1

[
  460
]

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.birth_date AS birth_date_4,
  t0.id_ffn AS id_ffn_5,
  t0.last_competition_date_update AS last_competition_date_update_6,
  t0.country_id AS country_id_7,
  t0.club_id AS club_id_8,
  t0.gender_id AS gender_id_9
FROM
  swimmer t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.birth_date AS birth_date_4, t0.id_ffn AS id_ffn_5, t0.last_competition_date_update AS last_competition_date_update_6, t0.country_id AS country_id_7, t0.club_id AS club_id_8, t0.gender_id AS gender_id_9 FROM swimmer t0 WHERE t0.id = 460 LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.css_ffn AS css_ffn_4 FROM gender t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.css_ffn AS css_ffn_4
FROM
  gender t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.css_ffn AS css_ffn_4 FROM gender t0 WHERE t0.id = 1;

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 g0_.id AS id_0, g0_.name AS name_1, g0_.abbreviation AS abbreviation_2, g0_.css_ffn AS css_ffn_3 FROM gender g0_ ORDER BY g0_.name ASC

[]

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.abbreviation AS abbreviation_2,
  g0_.css_ffn AS css_ffn_3
FROM
  gender g0_
ORDER BY
  g0_.name ASC

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.abbreviation AS abbreviation_2, g0_.css_ffn AS css_ffn_3 FROM gender g0_ ORDER BY g0_.name ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.english_name AS english_name_3, c0_.continent_id AS continent_id_4 FROM country c0_ ORDER BY c0_.name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.short_name AS short_name_2,
  c0_.english_name AS english_name_3,
  c0_.continent_id AS continent_id_4
FROM
  country c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.english_name AS english_name_3, c0_.continent_id AS continent_id_4 FROM country 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;