Symfony Profiler

SELECT
  count(DISTINCT f0_.id) AS sclr_0
FROM
  formations f0_
  INNER JOIN themes t1_ ON f0_.theme_id = t1_.id
  INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id
  INNER JOIN villes v3_ ON f0_.ville_id = v3_.id
WHERE
  f0_.id IN (
    SELECT
      MAX(f4_.id) AS sclr_1
    FROM
      formations f4_
      INNER JOIN themes t5_ ON f4_.theme_id = t5_.id
    GROUP BY
      t5_.id
  )

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id INNER JOIN villes v3_ ON f0_.ville_id = v3_.id WHERE f0_.id IN (SELECT MAX(f4_.id) AS sclr_1 FROM formations f4_ INNER JOIN themes t5_ ON f4_.theme_id = t5_.id GROUP BY t5_.id);

SELECT
  DISTINCT f0_.id AS id_0,
  f0_.created_at AS created_at_1
FROM
  formations f0_
  INNER JOIN themes t1_ ON f0_.theme_id = t1_.id
  INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id
  INNER JOIN villes v3_ ON f0_.ville_id = v3_.id
WHERE
  f0_.id IN (
    SELECT
      MAX(f4_.id) AS sclr_2
    FROM
      formations f4_
      INNER JOIN themes t5_ ON f4_.theme_id = t5_.id
    GROUP BY
      t5_.id
  )
ORDER BY
  f0_.created_at DESC
LIMIT
  12 OFFSET 492

SELECT DISTINCT f0_.id AS id_0, f0_.created_at AS created_at_1 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id INNER JOIN villes v3_ ON f0_.ville_id = v3_.id WHERE f0_.id IN (SELECT MAX(f4_.id) AS sclr_2 FROM formations f4_ INNER JOIN themes t5_ ON f4_.theme_id = t5_.id GROUP BY t5_.id) ORDER BY f0_.created_at DESC LIMIT 12 OFFSET 492;

SELECT
  f0_.id AS id_0,
  f0_.dates_session AS dates_session_1,
  f0_.image AS image_2,
  f0_.prix AS prix_3,
  f0_.devise AS devise_4,
  f0_.created_at AS created_at_5,
  t1_.nom AS nom_6,
  t1_.slug AS slug_7,
  t2_.nom AS nom_8,
  v3_.nom AS nom_9,
  v3_.pays AS pays_10
FROM
  formations f0_
  INNER JOIN themes t1_ ON f0_.theme_id = t1_.id
  INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id
  INNER JOIN villes v3_ ON f0_.ville_id = v3_.id
WHERE
  f0_.id IN (
    SELECT
      MAX(f4_.id) AS sclr_11
    FROM
      formations f4_
      INNER JOIN themes t5_ ON f4_.theme_id = t5_.id
    GROUP BY
      t5_.id
  )
  AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  f0_.created_at DESC

SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.image AS image_2, f0_.prix AS prix_3, f0_.devise AS devise_4, f0_.created_at AS created_at_5, t1_.nom AS nom_6, t1_.slug AS slug_7, t2_.nom AS nom_8, v3_.nom AS nom_9, v3_.pays AS pays_10 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id INNER JOIN villes v3_ ON f0_.ville_id = v3_.id WHERE f0_.id IN (SELECT MAX(f4_.id) AS sclr_11 FROM formations f4_ INNER JOIN themes t5_ ON f4_.theme_id = t5_.id GROUP BY t5_.id) AND f0_.id IN (796, 788, 782, 777, 774, 768, 763, 758, 751, 750, 745, 740) ORDER BY f0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.titremen AS titremen_2,
  t0.slug AS slug_3,
  t0.detailmen AS detailmen_4,
  t0.statutmen AS statutmen_5,
  t0.adminsid AS adminsid_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  mentions t0

SELECT t0.id AS id_1, t0.titremen AS titremen_2, t0.slug AS slug_3, t0.detailmen AS detailmen_4, t0.statutmen AS statutmen_5, t0.adminsid AS adminsid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mentions t0;

SELECT
  v0_.id AS id_0,
  v0_.nom AS nom_1,
  v0_.slug AS slug_2,
  v0_.image AS image_3,
  v0_.pays AS pays_4,
  v0_.texte AS texte_5,
  v0_.longitude AS longitude_6,
  v0_.latitude AS latitude_7,
  v0_.adminsid AS adminsid_8,
  v0_.created_at AS created_at_9
FROM
  villes v0_

SELECT v0_.id AS id_0, v0_.nom AS nom_1, v0_.slug AS slug_2, v0_.image AS image_3, v0_.pays AS pays_4, v0_.texte AS texte_5, v0_.longitude AS longitude_6, v0_.latitude AS latitude_7, v0_.adminsid AS adminsid_8, v0_.created_at AS created_at_9 FROM villes v0_;