Symfony Profiler

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

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 = '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 = '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 = '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 = '24' 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 = '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 = '2' 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.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.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 = '5' 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 = '32' 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 = '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 = '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
  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