Symfony Profiler

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

Query Metrics

SELECT s.id, s.first_name, s.last_name, s.birth_date, g.id AS id_gender, g.name AS name_gender, cou.id AS id_country, cou.name AS name_country, cl.id AS id_club, cl.name AS name_club, GROUP_CONCAT(DISTINCT sra.race_id SEPARATOR '-') AS id_races, GROUP_CONCAT(DISTINCT sra.pool_size_id SEPARATOR '-') AS id_pool_sizes, GROUP_CONCAT(CONCAT(sra.race_id,',',sra.pool_size_id,',',sra.results_stats) SEPARATOR '-') AS results_stats FROM swimmer s INNER JOIN gender g ON (s.gender_id = g.id) INNER JOIN country cou ON (s.country_id = cou.id) LEFT JOIN club cl ON (s.club_id = cl.id) INNER JOIN (SELECT cs.swimmer_id, rage.race_id, c.pool_size_id, COUNT(r.id) AS results_stats FROM competition_swimmer cs INNER JOIN competition c ON (cs.competition_id = c.id) INNER JOIN result_swimmer rs ON (rs.competition_swimmer_id = cs.id) INNER JOIN result r ON (rs.result_id = r.id) INNER JOIN race_gender rage ON (r.race_gender_id = rage.id) GROUP BY cs.swimmer_id, rage.race_id, c.pool_size_id) sra ON (sra.swimmer_id = s.id) GROUP BY s.id, s.first_name, s.last_name, s.birth_date, g.id, g.name, cou.id, cou.name, cl.id, cl.name ORDER BY s.last_name ASC;

[]

SELECT
  s.id,
  s.first_name,
  s.last_name,
  s.birth_date,
  g.id AS id_gender,
  g.name AS name_gender,
  cou.id AS id_country,
  cou.name AS name_country,
  cl.id AS id_club,
  cl.name AS name_club,
  GROUP_CONCAT(
    DISTINCT sra.race_id SEPARATOR '-'
  ) AS id_races,
  GROUP_CONCAT(
    DISTINCT sra.pool_size_id SEPARATOR '-'
  ) AS id_pool_sizes,
  GROUP_CONCAT(
    CONCAT(
      sra.race_id, ',', sra.pool_size_id,
      ',', sra.results_stats
    ) SEPARATOR '-'
  ) AS results_stats
FROM
  swimmer s
  INNER JOIN gender g ON (s.gender_id = g.id)
  INNER JOIN country cou ON (s.country_id = cou.id)
  LEFT JOIN club cl ON (s.club_id = cl.id)
  INNER JOIN (
    SELECT
      cs.swimmer_id,
      rage.race_id,
      c.pool_size_id,
      COUNT(r.id) AS results_stats
    FROM
      competition_swimmer cs
      INNER JOIN competition c ON (cs.competition_id = c.id)
      INNER JOIN result_swimmer rs ON (
        rs.competition_swimmer_id = cs.id
      )
      INNER JOIN result r ON (rs.result_id = r.id)
      INNER JOIN race_gender rage ON (r.race_gender_id = rage.id)
    GROUP BY
      cs.swimmer_id,
      rage.race_id,
      c.pool_size_id
  ) sra ON (sra.swimmer_id = s.id)
GROUP BY
  s.id,
  s.first_name,
  s.last_name,
  s.birth_date,
  g.id,
  g.name,
  cou.id,
  cou.name,
  cl.id,
  cl.name
ORDER BY
  s.last_name ASC;

SELECT s.id, s.first_name, s.last_name, s.birth_date, g.id AS id_gender, g.name AS name_gender, cou.id AS id_country, cou.name AS name_country, cl.id AS id_club, cl.name AS name_club, GROUP_CONCAT(DISTINCT sra.race_id SEPARATOR '-') AS id_races, GROUP_CONCAT(DISTINCT sra.pool_size_id SEPARATOR '-') AS id_pool_sizes, GROUP_CONCAT(CONCAT(sra.race_id,',',sra.pool_size_id,',',sra.results_stats) SEPARATOR '-') AS results_stats FROM swimmer s INNER JOIN gender g ON (s.gender_id = g.id) INNER JOIN country cou ON (s.country_id = cou.id) LEFT JOIN club cl ON (s.club_id = cl.id) INNER JOIN (SELECT cs.swimmer_id, rage.race_id, c.pool_size_id, COUNT(r.id) AS results_stats FROM competition_swimmer cs INNER JOIN competition c ON (cs.competition_id = c.id) INNER JOIN result_swimmer rs ON (rs.competition_swimmer_id = cs.id) INNER JOIN result r ON (rs.result_id = r.id) INNER JOIN race_gender rage ON (r.race_gender_id = rage.id) GROUP BY cs.swimmer_id, rage.race_id, c.pool_size_id) sra ON (sra.swimmer_id = s.id) GROUP BY s.id, s.first_name, s.last_name, s.birth_date, g.id, g.name, cou.id, cou.name, cl.id, cl.name ORDER BY s.last_name ASC;;