Symfony Profiler

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

Query Metrics

SELECT co.id, co.name, co.start_date, co.end_date, ci.name AS name_city, cou.name AS name_country, ps.id AS id_pool_size, ps.size, ps.metric, ct.id AS id_competition_type, ct.name AS name_competition_type, cd.id AS id_competition_discipline, cd.name AS name_competition_discipline, co.type_distribution, GROUP_CONCAT(sra.id SEPARATOR '-') AS id_races FROM competition co INNER JOIN city ci ON (co.city_id = ci.id) LEFT JOIN country cou ON (ci.country_id = cou.id) INNER JOIN pool_size ps ON (co.pool_size_id = ps.id) INNER JOIN competition_type ct ON (co.competition_type_id = ct.id) INNER JOIN competition_discipline cd ON (co.competition_discipline_id = cd.id) INNER JOIN (SELECT DISTINCT re.competition_id, ra.id FROM result re, race_gender rg, race ra WHERE re.race_gender_id = rg.id AND rg.race_id = ra.id) sra ON (sra.competition_id = co.id) WHERE co.competition_discipline_id = :idDiscipline AND co.competition_type_id = :idType GROUP BY co.id, co.name, co.start_date, co.end_date, ci.name, cou.name, ps.id, ps.size, ps.metric, ct.id, ct.name, cd.id, cd.name

[
  "idDiscipline" => 3
  "idType" => 2
]

SELECT
  co.id,
  co.name,
  co.start_date,
  co.end_date,
  ci.name AS name_city,
  cou.name AS name_country,
  ps.id AS id_pool_size,
  ps.size,
  ps.metric,
  ct.id AS id_competition_type,
  ct.name AS name_competition_type,
  cd.id AS id_competition_discipline,
  cd.name AS name_competition_discipline,
  co.type_distribution,
  GROUP_CONCAT(sra.id SEPARATOR '-') AS id_races
FROM
  competition co
  INNER JOIN city ci ON (co.city_id = ci.id)
  LEFT JOIN country cou ON (ci.country_id = cou.id)
  INNER JOIN pool_size ps ON (co.pool_size_id = ps.id)
  INNER JOIN competition_type ct ON (co.competition_type_id = ct.id)
  INNER JOIN competition_discipline cd ON (
    co.competition_discipline_id = cd.id
  )
  INNER JOIN (
    SELECT
      DISTINCT re.competition_id,
      ra.id
    FROM
      result re,
      race_gender rg,
      race ra
    WHERE
      re.race_gender_id = rg.id
      AND rg.race_id = ra.id
  ) sra ON (sra.competition_id = co.id)
WHERE
  co.competition_discipline_id = :idDiscipline
  AND co.competition_type_id = :idType
GROUP BY
  co.id,
  co.name,
  co.start_date,
  co.end_date,
  ci.name,
  cou.name,
  ps.id,
  ps.size,
  ps.metric,
  ct.id,
  ct.name,
  cd.id,
  cd.name

SELECT co.id, co.name, co.start_date, co.end_date, ci.name AS name_city, cou.name AS name_country, ps.id AS id_pool_size, ps.size, ps.metric, ct.id AS id_competition_type, ct.name AS name_competition_type, cd.id AS id_competition_discipline, cd.name AS name_competition_discipline, co.type_distribution, GROUP_CONCAT(sra.id SEPARATOR '-') AS id_races FROM competition co INNER JOIN city ci ON (co.city_id = ci.id) LEFT JOIN country cou ON (ci.country_id = cou.id) INNER JOIN pool_size ps ON (co.pool_size_id = ps.id) INNER JOIN competition_type ct ON (co.competition_type_id = ct.id) INNER JOIN competition_discipline cd ON (co.competition_discipline_id = cd.id) INNER JOIN (SELECT DISTINCT re.competition_id, ra.id FROM result re, race_gender rg, race ra WHERE re.race_gender_id = rg.id AND rg.race_id = ra.id) sra ON (sra.competition_id = co.id) WHERE co.competition_discipline_id = 3 AND co.competition_type_id = 2 GROUP BY co.id, co.name, co.start_date, co.end_date, ci.name, cou.name, ps.id, ps.size, ps.metric, ct.id, ct.name, cd.id, cd.name;

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.name_ffn AS name_ffn_4, t0.distance AS distance_5, t0.order_display AS order_display_6, t0.relay AS relay_7, t0.used AS used_8, t0.stroke_id AS stroke_id_9 FROM race t0 WHERE t0.id = ? LIMIT 1

[
  "16"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.name_ffn AS name_ffn_4,
  t0.distance AS distance_5,
  t0.order_display AS order_display_6,
  t0.relay AS relay_7,
  t0.used AS used_8,
  t0.stroke_id AS stroke_id_9
FROM
  race t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.name_ffn AS name_ffn_4, t0.distance AS distance_5, t0.order_display AS order_display_6, t0.relay AS relay_7, t0.used AS used_8, t0.stroke_id AS stroke_id_9 FROM race t0 WHERE t0.id = '16' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.order_display AS order_display_4 FROM stroke t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.order_display AS order_display_4
FROM
  stroke t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.order_display AS order_display_4 FROM stroke t0 WHERE t0.id = 3;

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;