Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.session AS session_1,
  c0_.prix AS prix_2,
  c0_.slug AS slug_3,
  c0_.devise AS devise_4,
  v1_.nom AS nom_5,
  v1_.pays AS pays_6,
  c0_.createdat AS createdat_7,
  c0_.type AS type_8,
  c0_.theme AS theme_9
FROM
  certificats c0_
  INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id)
WHERE
  c0_.createdat = (
    SELECT
      MAX(c2_.createdat) AS sclr_10
    FROM
      certificats c2_
    WHERE
      c2_.theme = c0_.theme
  )
ORDER BY
  c0_.createdat DESC

SELECT c0_.id AS id_0, c0_.session AS session_1, c0_.prix AS prix_2, c0_.slug AS slug_3, c0_.devise AS devise_4, v1_.nom AS nom_5, v1_.pays AS pays_6, c0_.createdat AS createdat_7, c0_.type AS type_8, c0_.theme AS theme_9 FROM certificats c0_ INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id) WHERE c0_.createdat = (SELECT MAX(c2_.createdat) AS sclr_10 FROM certificats c2_ WHERE c2_.theme = c0_.theme) ORDER BY c0_.createdat DESC;

SELECT
  t0.id AS id_1,
  t0.theme AS theme_2,
  t0.slug AS slug_3,
  t0.session AS session_4,
  t0.type AS type_5,
  t0.prix AS prix_6,
  t0.devise AS devise_7,
  t0.adminsid AS adminsid_8,
  t0.createdat AS createdat_9,
  t0.updatedat AS updatedat_10,
  t0.ville_id AS ville_id_11
FROM
  certificats t0

SELECT t0.id AS id_1, t0.theme AS theme_2, t0.slug AS slug_3, t0.session AS session_4, t0.type AS type_5, t0.prix AS prix_6, t0.devise AS devise_7, t0.adminsid AS adminsid_8, t0.createdat AS createdat_9, t0.updatedat AS updatedat_10, t0.ville_id AS ville_id_11 FROM certificats t0;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  certificats c0_
  INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id)
WHERE
  c0_.createdat = (
    SELECT
      MAX(c2_.createdat) AS sclr_1
    FROM
      certificats c2_
    WHERE
      c2_.theme = c0_.theme
  )

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM certificats c0_ INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id) WHERE c0_.createdat = (SELECT MAX(c2_.createdat) AS sclr_1 FROM certificats c2_ WHERE c2_.theme = c0_.theme);

SELECT
  c0_.id AS id_0,
  c0_.session AS session_1,
  c0_.prix AS prix_2,
  c0_.slug AS slug_3,
  c0_.devise AS devise_4,
  v1_.nom AS nom_5,
  v1_.pays AS pays_6,
  c0_.createdat AS createdat_7,
  c0_.type AS type_8,
  c0_.theme AS theme_9
FROM
  certificats c0_
  INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id)
WHERE
  c0_.createdat = (
    SELECT
      MAX(c2_.createdat) AS sclr_10
    FROM
      certificats c2_
    WHERE
      c2_.theme = c0_.theme
  )
  AND c0_.id IN (?, ?)
ORDER BY
  c0_.createdat DESC

SELECT c0_.id AS id_0, c0_.session AS session_1, c0_.prix AS prix_2, c0_.slug AS slug_3, c0_.devise AS devise_4, v1_.nom AS nom_5, v1_.pays AS pays_6, c0_.createdat AS createdat_7, c0_.type AS type_8, c0_.theme AS theme_9 FROM certificats c0_ INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id) WHERE c0_.createdat = (SELECT MAX(c2_.createdat) AS sclr_10 FROM certificats c2_ WHERE c2_.theme = c0_.theme) AND c0_.id IN (12, 6) ORDER BY c0_.createdat DESC;

SELECT
  t0.id AS id_1,
  t0.theme AS theme_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.ville AS ville_5,
  t0.devise AS devise_6,
  t0.datedebut AS datedebut_7,
  t0.datefin AS datefin_8,
  t0.prix AS prix_9,
  t0.texte AS texte_10,
  t0.adminsid AS adminsid_11,
  t0.createdat AS createdat_12,
  t0.updatedat AS updatedat_13
FROM
  managements t0
ORDER BY
  t0.id DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.theme AS theme_2, t0.slug AS slug_3, t0.image AS image_4, t0.ville AS ville_5, t0.devise AS devise_6, t0.datedebut AS datedebut_7, t0.datefin AS datefin_8, t0.prix AS prix_9, t0.texte AS texte_10, t0.adminsid AS adminsid_11, t0.createdat AS createdat_12, t0.updatedat AS updatedat_13 FROM managements t0 ORDER BY t0.id DESC LIMIT 5;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.createdat AS createdat_1
FROM
  certificats c0_
  INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id)
WHERE
  c0_.createdat = (
    SELECT
      MAX(c2_.createdat) AS sclr_2
    FROM
      certificats c2_
    WHERE
      c2_.theme = c0_.theme
  )
ORDER BY
  c0_.createdat DESC
LIMIT
  12

SELECT DISTINCT c0_.id AS id_0, c0_.createdat AS createdat_1 FROM certificats c0_ INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id) WHERE c0_.createdat = (SELECT MAX(c2_.createdat) AS sclr_2 FROM certificats c2_ WHERE c2_.theme = c0_.theme) ORDER BY c0_.createdat DESC LIMIT 12;

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;