Symfony Profiler

SELECT
  COUNT(bnq.id_newsletter) AS nb
FROM
  buzz_newsletters_quotidiennes bnq
WHERE
  (bnq.date_envoi <= ?)
  AND (bnq.date_envoi >= ?)
  AND (bnq.mode >= 'envoyee')
  AND (bnq.id_pays = ?)

SELECT COUNT(bnq.id_newsletter) AS nb FROM buzz_newsletters_quotidiennes bnq WHERE (bnq.date_envoi <= '20260419') AND (bnq.date_envoi >= '20260219') AND (bnq.mode >= 'envoyee') AND (bnq.id_pays = '41');

SELECT
  bnq.id_newsletter,
  bnq.titre,
  bnq.date_envoi
FROM
  buzz_newsletters_quotidiennes bnq
WHERE
  (bnq.date_envoi <= ?)
  AND (bnq.date_envoi >= ?)
  AND (bnq.mode >= 'envoyee')
  AND (bnq.id_pays = ?)
ORDER BY
  bnq.date_envoi DESC
LIMIT
  25

SELECT bnq.id_newsletter, bnq.titre, bnq.date_envoi FROM buzz_newsletters_quotidiennes bnq WHERE (bnq.date_envoi <= '20260419') AND (bnq.date_envoi >= '20260219') AND (bnq.mode >= 'envoyee') AND (bnq.id_pays = '41') ORDER BY bnq.date_envoi DESC LIMIT 25;

SELECT
  id_actualite,
  jour,
  mois,
  type_actualite,
  titre_actualite,
  date_mise_en_ligne
FROM
  (
    SELECT
      id_actualite,
      SUBSTRING(date_mise_en_ligne, 7, 2) AS jour,
      SUBSTRING(date_mise_en_ligne, 5, 2) AS mois,
      type_actualite,
      titre_actualite,
      date_mise_en_ligne,
      ROW_NUMBER() OVER (
        PARTITION BY
          type_actualite
        ORDER BY
          date_mise_en_ligne DESC
      ) AS rn
    FROM
      buzz_actualites
    WHERE
      provenance_flux_actualite = 'blog'
      AND mode_actualite = 'publique'
      AND date_mise_en_ligne <= :now
      AND id_localisation LIKE CONCAT(:idPays, '%')
  ) t
WHERE
  rn <= 2
ORDER BY
  date_mise_en_ligne DESC,
  id_actualite DESC

SELECT id_actualite, jour, mois, type_actualite, titre_actualite, date_mise_en_ligne
        FROM (
            SELECT
                id_actualite,
                SUBSTRING(date_mise_en_ligne, 7, 2) AS jour,
                SUBSTRING(date_mise_en_ligne, 5, 2) AS mois,
                type_actualite,
                titre_actualite,
                date_mise_en_ligne,
                ROW_NUMBER() OVER (PARTITION BY type_actualite ORDER BY date_mise_en_ligne DESC) AS rn
            FROM buzz_actualites
            WHERE
                provenance_flux_actualite = 'blog'
                AND mode_actualite = 'publique'
                AND date_mise_en_ligne <= '20260419211043'
                AND id_localisation LIKE CONCAT('33', '%')
        ) t
        WHERE rn <= 2
        ORDER BY date_mise_en_ligne DESC, id_actualite DESC
    ;