Symfony Profiler

SELECT
  c.*
FROM
  club c
  JOIN (
    SELECT
      c.*
    FROM
      club c
      JOIN club_lesson cles ON c.id = cles.club_id
    WHERE
      cles.club_location_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
    GROUP BY
      c.id
  ) cs ON c.id = cs.id

SELECT c.* FROM club c JOIN (SELECT c.*        FROM club c          JOIN club_lesson cles ON c.id = cles.club_id         WHERE cles.club_location_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 15, 16, 17, 18, 19, 21, 23, 24, 25, 26, 28, 27, 29, 30, 31, 32, 33, 35, 34)         GROUP BY c.id) cs ON c.id = cs.id;

SELECT
  cl.*
FROM
  club_location cl
  JOIN club_lesson cles ON (cles.club_location_id = cl.id)
  JOIN club c ON (c.id = cles.club_id)
WHERE
  c.active

SELECT cl.* FROM club_location cl  JOIN club_lesson cles ON (cles.club_location_id = cl.id)  JOIN club c ON (c.id = cles.club_id) WHERE  c.active;

SELECT
  les.club_id AS club_id,
  loc.*
FROM
  club_lesson les
  JOIN club_location loc ON les.club_location_id = loc.id
WHERE
  les.club_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  1,
  2

SELECT les.club_id AS club_id, loc.* FROM club_lesson les  JOIN club_location loc ON les.club_location_id = loc.id WHERE les.club_id IN (1, 2, 3, 4, 6, 9, 10, 13, 14, 15, 17, 18, 19, 21, 23, 24, 29, 30, 31, 32, 39, 40, 41) GROUP BY 1, 2;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.discipline AS discipline_3,
  t0.category AS category_4,
  t0.comment AS comment_5,
  t0.price_child_1 AS price_child_1_6,
  t0.price_child_2 AS price_child_2_7,
  t0.price_child_3 AS price_child_3_8,
  t0.price_adult AS price_adult_9,
  t0.club_id AS club_id_10
FROM
  club_price t0
WHERE
  t0.club_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.discipline AS discipline_3, t0.category AS category_4, t0.comment AS comment_5, t0.price_child_1 AS price_child_1_6, t0.price_child_2 AS price_child_2_7, t0.price_child_3 AS price_child_3_8, t0.price_adult AS price_adult_9, t0.club_id AS club_id_10 FROM club_price t0 WHERE t0.club_id IN (1, 2, 3, 4, 6, 9, 10, 13, 14, 15, 17, 18, 19, 21, 23, 24, 29, 30, 31, 32, 39, 40, 41);

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.value AS value_4,
  t0.club_id AS club_id_5
FROM
  club_property t0
WHERE
  t0.club_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.value AS value_4, t0.club_id AS club_id_5 FROM club_property t0 WHERE t0.club_id IN (1, 2, 3, 4, 6, 9, 10, 13, 14, 15, 17, 18, 19, 21, 23, 24, 29, 30, 31, 32, 39, 40, 41);