Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.slug AS slug_2,
  a0_.statut AS statut_3,
  a0_.adminsid AS adminsid_4,
  a0_.createdat AS createdat_5,
  a0_.updatedat AS updatedat_6,
  MIN(g1_.img_gal) AS sclr_7
FROM
  albums a0_
  INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom)
WHERE
  a0_.statut = ?
GROUP BY
  a0_.id
ORDER BY
  a0_.createdat DESC

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.statut AS statut_3, a0_.adminsid AS adminsid_4, a0_.createdat AS createdat_5, a0_.updatedat AS updatedat_6, MIN(g1_.img_gal) AS sclr_7 FROM albums a0_ INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom) WHERE a0_.statut = 'Publié' GROUP BY a0_.id ORDER BY a0_.createdat 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
  count(DISTINCT a0_.id) AS sclr_0
FROM
  albums a0_
  INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom)
WHERE
  a0_.statut = ?
GROUP BY
  a0_.id

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM albums a0_ INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom) WHERE a0_.statut = 'Publié' GROUP BY a0_.id;

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.slug AS slug_2,
  a0_.statut AS statut_3,
  a0_.adminsid AS adminsid_4,
  a0_.createdat AS createdat_5,
  a0_.updatedat AS updatedat_6,
  MIN(g1_.img_gal) AS sclr_7
FROM
  albums a0_
  INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom)
WHERE
  a0_.statut = ?
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  a0_.id
ORDER BY
  a0_.createdat DESC

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.statut AS statut_3, a0_.adminsid AS adminsid_4, a0_.createdat AS createdat_5, a0_.updatedat AS updatedat_6, MIN(g1_.img_gal) AS sclr_7 FROM albums a0_ INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom) WHERE a0_.statut = 'Publié' AND a0_.id IN (28, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 17) GROUP BY a0_.id ORDER BY a0_.createdat DESC;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.createdat AS createdat_1
FROM
  albums a0_
  INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom)
WHERE
  a0_.statut = ?
GROUP BY
  a0_.id
ORDER BY
  a0_.createdat DESC
LIMIT
  12

SELECT DISTINCT a0_.id AS id_0, a0_.createdat AS createdat_1 FROM albums a0_ INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom) WHERE a0_.statut = 'Publié' GROUP BY a0_.id ORDER BY a0_.createdat DESC LIMIT 12;