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 villes v2_ ON f0_.ville_id = v2_.id
  INNER JOIN thematiques t3_ ON t1_.thematique_id = t3_.id
WHERE
  f0_.id IN (
    SELECT
      MAX(f4_.id) AS sclr_1
    FROM
      formations f4_
    GROUP BY
      f4_.theme_id
  )

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN villes v2_ ON f0_.ville_id = v2_.id INNER JOIN thematiques t3_ ON t1_.thematique_id = t3_.id WHERE f0_.id IN (SELECT MAX(f4_.id) AS sclr_1 FROM formations f4_ GROUP BY f4_.theme_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 villes v2_ ON f0_.ville_id = v2_.id
  INNER JOIN thematiques t3_ ON t1_.thematique_id = t3_.id
WHERE
  f0_.id IN (
    SELECT
      MAX(f4_.id) AS sclr_2
    FROM
      formations f4_
    GROUP BY
      f4_.theme_id
  )
ORDER BY
  f0_.created_at DESC
LIMIT
  12

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 villes v2_ ON f0_.ville_id = v2_.id INNER JOIN thematiques t3_ ON t1_.thematique_id = t3_.id WHERE f0_.id IN (SELECT MAX(f4_.id) AS sclr_2 FROM formations f4_ GROUP BY f4_.theme_id) ORDER BY f0_.created_at DESC LIMIT 12;

SELECT
  f0_.id AS id_0,
  f0_.dates_session AS dates_session_1,
  f0_.prix AS prix_2,
  f0_.devise AS devise_3,
  t1_.nom AS nom_4,
  t2_.nom AS nom_5,
  v3_.nom AS nom_6,
  v3_.pays AS pays_7,
  f0_.created_at AS created_at_8,
  t1_.slug AS slug_9
FROM
  formations f0_
  INNER JOIN themes t1_ ON f0_.theme_id = t1_.id
  INNER JOIN villes v3_ ON f0_.ville_id = v3_.id
  INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id
WHERE
  f0_.id IN (
    SELECT
      MAX(f4_.id) AS sclr_10
    FROM
      formations f4_
    GROUP BY
      f4_.theme_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_.prix AS prix_2, f0_.devise AS devise_3, t1_.nom AS nom_4, t2_.nom AS nom_5, v3_.nom AS nom_6, v3_.pays AS pays_7, f0_.created_at AS created_at_8, t1_.slug AS slug_9 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN villes v3_ ON f0_.ville_id = v3_.id INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id WHERE f0_.id IN (SELECT MAX(f4_.id) AS sclr_10 FROM formations f4_ GROUP BY f4_.theme_id) AND f0_.id IN (35, 50, 30, 40, 45, 5, 15, 25, 10, 20) 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;