Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.ala_une = 1
ORDER BY
  a0_.id DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.ala_une = 1 ORDER BY a0_.id DESC LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.ala_une = 1
  AND a0_.id <> ?
ORDER BY
  a0_.created_at DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.ala_une = 1 AND a0_.id <> 5 ORDER BY a0_.created_at DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
  AND a0_.id <> ?
ORDER BY
  a0_.created_at DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Sport' AND a0_.id <> 5 ORDER BY a0_.created_at DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.titre = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.titre = 'CAN féminine 2026 : Les Lionnes Indomptables championnes d’Afrique' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3
FROM
  thematique t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = 'Urbanisme' LIMIT 1;

SELECT
  id
FROM
  (
    SELECT
      a.id,
      a.created_at,
      ROW_NUMBER() OVER (
        PARTITION BY
          a.sous_thematique_id
        ORDER BY
          a.created_at DESC
      ) AS rn
    FROM
      actualite a
      INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
    WHERE
      st.thematique_id = ?
  ) ranked
WHERE
  rn <= ?
ORDER BY
  created_at DESC
LIMIT
  ?

SELECT id FROM (
            SELECT a.id, a.created_at,
                   ROW_NUMBER() OVER (
                       PARTITION BY a.sous_thematique_id
                       ORDER BY a.created_at DESC
                   ) AS rn
            FROM actualite a
            INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
            WHERE st.thematique_id = 1
        ) ranked
        WHERE rn <= 2
        ORDER BY created_at DESC
        LIMIT 6
    ;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (17, 16, 15, 14, 9, 8) ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3
FROM
  thematique t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = 'Aménagement du territoire' LIMIT 1;

SELECT
  id
FROM
  (
    SELECT
      a.id,
      a.created_at,
      ROW_NUMBER() OVER (
        PARTITION BY
          a.sous_thematique_id
        ORDER BY
          a.created_at DESC
      ) AS rn
    FROM
      actualite a
      INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
    WHERE
      st.thematique_id = ?
  ) ranked
WHERE
  rn <= ?
ORDER BY
  created_at DESC
LIMIT
  ?

SELECT id FROM (
            SELECT a.id, a.created_at,
                   ROW_NUMBER() OVER (
                       PARTITION BY a.sous_thematique_id
                       ORDER BY a.created_at DESC
                   ) AS rn
            FROM actualite a
            INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
            WHERE st.thematique_id = 2
        ) ranked
        WHERE rn <= 2
        ORDER BY created_at DESC
        LIMIT 6
    ;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (20, 19, 18) ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3
FROM
  thematique t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = 'Environnement' LIMIT 1;

SELECT
  id
FROM
  (
    SELECT
      a.id,
      a.created_at,
      ROW_NUMBER() OVER (
        PARTITION BY
          a.sous_thematique_id
        ORDER BY
          a.created_at DESC
      ) AS rn
    FROM
      actualite a
      INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
    WHERE
      st.thematique_id = ?
  ) ranked
WHERE
  rn <= ?
ORDER BY
  created_at DESC
LIMIT
  ?

SELECT id FROM (
            SELECT a.id, a.created_at,
                   ROW_NUMBER() OVER (
                       PARTITION BY a.sous_thematique_id
                       ORDER BY a.created_at DESC
                   ) AS rn
            FROM actualite a
            INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
            WHERE st.thematique_id = 3
        ) ranked
        WHERE rn <= 2
        ORDER BY created_at DESC
        LIMIT 6
    ;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (13, 12, 11, 10) ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 13;