Symfony Profiler

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
  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 = '32' 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 = ?

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 = 1;

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.metric AS metric_3
FROM
  pool_size t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.size AS size_2, t0.metric AS metric_3 FROM pool_size t0 WHERE t0.id = '2' 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 = ?
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 = '51' 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 = ?

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

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

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.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 = '12' 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 = ?

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 = 2;

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 = '17' 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 = ?
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 = '2' 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 = ?
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 = '20' 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 = ?

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

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 = '21' 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 = ?
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 = '22' 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 = ?
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 = '18' 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 = ?
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 = '6' 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 = ?
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 = '24' 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 = ?
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 = '25' 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 = ?
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 = '3' 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 = ?
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 = '4' 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 = ?
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 = '13' 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 = ?
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 = '14' 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 = ?
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 = '5' LIMIT 1;

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