Symfony Profiler

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_1,
  b0_.titre_actualite AS titre_actualite_2,
  b0_.description_actualite AS description_actualite_3,
  b0_.id_localisation AS id_localisation_4,
  b0_.type_actualite AS type_actualite_5,
  b0_.provenance_flux_actualite AS provenance_flux_actualite_6,
  b0_.id_societe_prestataire AS id_societe_prestataire_7,
  b0_.id_service_principal AS id_service_principal_8,
  b0_.a_la_une_du_jour AS a_la_une_du_jour_9,
  b0_.id_operation AS id_operation_10,
  b0_.photo_actualite AS photo_actualite_11
FROM
  fusacq_dbo.buzz_actualites b0_
  LEFT JOIN fusacq_dbo.buzz_operations b1_ ON (
    b1_.id_operation = b0_.id_operation
  )
WHERE
  b0_.a_la_une_du_jour = ?
  AND b0_.mode_actualite = ?
  AND b0_.mode_actualite <> ?
  AND b0_.date_mise_en_ligne <= ?
  AND (
    b0_.visibilite_flux LIKE ?
    OR b0_.visibilite_flux LIKE ?
  )
  AND b0_.date_mise_en_ligne LIKE ?
  AND (
    (
      (
        b1_.id_localisation IS NOT NULL
        OR b1_.id_localisation_2 IS NOT NULL
      )
      AND (
        b1_.id_localisation IS NULL
        OR b1_.id_localisation NOT LIKE ?
      )
      AND (
        b1_.id_localisation_2 IS NULL
        OR b1_.id_localisation_2 NOT LIKE ?
      )
    )
    OR (
      b1_.id_localisation IS NULL
      AND b1_.id_localisation_2 IS NULL
      AND (
        b0_.id_localisation IS NULL
        OR b0_.id_localisation NOT LIKE ?
      )
    )
  )
  AND (
    (
      b1_.id_localisation IS NULL
      OR b1_.id_localisation NOT LIKE ?
    )
    AND (
      b1_.id_localisation_2 IS NULL
      OR b1_.id_localisation_2 NOT LIKE ?
    )
    AND (
      b0_.id_localisation IS NULL
      OR b0_.id_localisation NOT LIKE ?
    )
  )
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  5

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_mise_en_ligne AS date_mise_en_ligne_1, b0_.titre_actualite AS titre_actualite_2, b0_.description_actualite AS description_actualite_3, b0_.id_localisation AS id_localisation_4, b0_.type_actualite AS type_actualite_5, b0_.provenance_flux_actualite AS provenance_flux_actualite_6, b0_.id_societe_prestataire AS id_societe_prestataire_7, b0_.id_service_principal AS id_service_principal_8, b0_.a_la_une_du_jour AS a_la_une_du_jour_9, b0_.id_operation AS id_operation_10, b0_.photo_actualite AS photo_actualite_11 FROM fusacq_dbo.buzz_actualites b0_ LEFT JOIN fusacq_dbo.buzz_operations b1_ ON (b1_.id_operation = b0_.id_operation) WHERE b0_.a_la_une_du_jour = 'oui' AND b0_.mode_actualite = 'publique' AND b0_.mode_actualite <> 'supprime' AND b0_.date_mise_en_ligne <= '20260419213109' AND (b0_.visibilite_flux LIKE '%international%' OR b0_.visibilite_flux LIKE '%collaborative%') AND b0_.date_mise_en_ligne LIKE '20260419%' AND (((b1_.id_localisation IS NOT NULL OR b1_.id_localisation_2 IS NOT NULL) AND (b1_.id_localisation IS NULL OR b1_.id_localisation NOT LIKE '41%') AND (b1_.id_localisation_2 IS NULL OR b1_.id_localisation_2 NOT LIKE '41%')) OR (b1_.id_localisation IS NULL AND b1_.id_localisation_2 IS NULL AND (b0_.id_localisation IS NULL OR b0_.id_localisation NOT LIKE '41%'))) AND ((b1_.id_localisation IS NULL OR b1_.id_localisation NOT LIKE '33%') AND (b1_.id_localisation_2 IS NULL OR b1_.id_localisation_2 NOT LIKE '33%') AND (b0_.id_localisation IS NULL OR b0_.id_localisation NOT LIKE '33%')) ORDER BY b0_.date_mise_en_ligne DESC LIMIT 5;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_1,
  b0_.titre_actualite AS titre_actualite_2,
  b0_.description_actualite AS description_actualite_3,
  b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4,
  b0_.vignette AS vignette_5,
  b0_.vignette_small AS vignette_small_6,
  b0_.id_localisation AS id_localisation_7,
  b0_.type_actualite AS type_actualite_8,
  b0_.provenance_flux_actualite AS provenance_flux_actualite_9,
  b0_.visibilite_flux AS visibilite_flux_10,
  b0_.a_la_une AS a_la_une_11,
  b0_.a_la_une_du_jour AS a_la_une_du_jour_12
FROM
  fusacq_dbo.buzz_actualites b0_
  LEFT JOIN fusacq_dbo.buzz_operations b1_ ON (
    b1_.id_operation = b0_.id_operation
  )
WHERE
  b0_.date_mise_en_ligne IS NOT NULL
  AND b0_.mode_actualite = ?
  AND b0_.mode_actualite <> ?
  AND b0_.date_mise_en_ligne <= ?
  AND (
    b0_.visibilite_flux LIKE ?
    OR b0_.provenance_flux_actualite = ?
  )
  AND (
    (
      (
        b1_.id_localisation IS NOT NULL
        OR b1_.id_localisation_2 IS NOT NULL
      )
      AND (
        b1_.id_localisation IS NULL
        OR b1_.id_localisation NOT LIKE ?
      )
      AND (
        b1_.id_localisation_2 IS NULL
        OR b1_.id_localisation_2 NOT LIKE ?
      )
    )
    OR (
      b1_.id_localisation IS NULL
      AND b1_.id_localisation_2 IS NULL
      AND (
        b0_.id_localisation IS NULL
        OR b0_.id_localisation NOT LIKE ?
      )
    )
  )
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  60

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_mise_en_ligne AS date_mise_en_ligne_1, b0_.titre_actualite AS titre_actualite_2, b0_.description_actualite AS description_actualite_3, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4, b0_.vignette AS vignette_5, b0_.vignette_small AS vignette_small_6, b0_.id_localisation AS id_localisation_7, b0_.type_actualite AS type_actualite_8, b0_.provenance_flux_actualite AS provenance_flux_actualite_9, b0_.visibilite_flux AS visibilite_flux_10, b0_.a_la_une AS a_la_une_11, b0_.a_la_une_du_jour AS a_la_une_du_jour_12 FROM fusacq_dbo.buzz_actualites b0_ LEFT JOIN fusacq_dbo.buzz_operations b1_ ON (b1_.id_operation = b0_.id_operation) WHERE b0_.date_mise_en_ligne IS NOT NULL AND b0_.mode_actualite = 'publique' AND b0_.mode_actualite <> 'supprime' AND b0_.date_mise_en_ligne <= '20260419213109' AND (b0_.visibilite_flux LIKE '%international%' OR b0_.provenance_flux_actualite = 'international') AND (((b1_.id_localisation IS NOT NULL OR b1_.id_localisation_2 IS NOT NULL) AND (b1_.id_localisation IS NULL OR b1_.id_localisation NOT LIKE '41%') AND (b1_.id_localisation_2 IS NULL OR b1_.id_localisation_2 NOT LIKE '41%')) OR (b1_.id_localisation IS NULL AND b1_.id_localisation_2 IS NULL AND (b0_.id_localisation IS NULL OR b0_.id_localisation NOT LIKE '41%'))) ORDER BY b0_.date_mise_en_ligne DESC LIMIT 60;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258717;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258715;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258703;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258699;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258680;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258665;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258660;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258637;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258628;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258610;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258606;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258602;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258589;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.photo_actualite AS photo_actualite_1
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_operation = ?
  AND b0_.id_actualite <> ?
  AND b0_.mode_actualite = ?
  AND b0_.photo_actualite IS NOT NULL
  AND b0_.photo_actualite <> ''
  AND b0_.photo_actualite <> 'NULL'
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  1

SELECT b0_.id_actualite AS id_actualite_0, b0_.photo_actualite AS photo_actualite_1 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_operation = 43360 AND b0_.id_actualite <> 258589 AND b0_.mode_actualite = 'publique' AND b0_.photo_actualite IS NOT NULL AND b0_.photo_actualite <> '' AND b0_.photo_actualite <> 'NULL' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1;

SELECT
  s0_.image_filename AS image_filename_0
FROM
  fusacq_dbo.buzz_operations b1_
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b1_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_operation = ?
  AND s0_.image_filename IS NOT NULL
  AND s0_.image_filename <> ''
LIMIT
  1

SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_operations b1_ LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b1_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_operation = 43360 AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258576;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.photo_actualite AS photo_actualite_1
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_operation = ?
  AND b0_.id_actualite <> ?
  AND b0_.mode_actualite = ?
  AND b0_.photo_actualite IS NOT NULL
  AND b0_.photo_actualite <> ''
  AND b0_.photo_actualite <> 'NULL'
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  1

SELECT b0_.id_actualite AS id_actualite_0, b0_.photo_actualite AS photo_actualite_1 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_operation = 43351 AND b0_.id_actualite <> 258576 AND b0_.mode_actualite = 'publique' AND b0_.photo_actualite IS NOT NULL AND b0_.photo_actualite <> '' AND b0_.photo_actualite <> 'NULL' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1;

SELECT
  s0_.image_filename AS image_filename_0
FROM
  fusacq_dbo.buzz_operations b1_
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b1_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_operation = ?
  AND s0_.image_filename IS NOT NULL
  AND s0_.image_filename <> ''
LIMIT
  1

SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_operations b1_ LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b1_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_operation = 43351 AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258572;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258571;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.photo_actualite AS photo_actualite_1
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_operation = ?
  AND b0_.id_actualite <> ?
  AND b0_.mode_actualite = ?
  AND b0_.photo_actualite IS NOT NULL
  AND b0_.photo_actualite <> ''
  AND b0_.photo_actualite <> 'NULL'
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  1

SELECT b0_.id_actualite AS id_actualite_0, b0_.photo_actualite AS photo_actualite_1 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_operation = 43347 AND b0_.id_actualite <> 258571 AND b0_.mode_actualite = 'publique' AND b0_.photo_actualite IS NOT NULL AND b0_.photo_actualite <> '' AND b0_.photo_actualite <> 'NULL' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1;

SELECT
  s0_.image_filename AS image_filename_0
FROM
  fusacq_dbo.buzz_operations b1_
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b1_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_operation = ?
  AND s0_.image_filename IS NOT NULL
  AND s0_.image_filename <> ''
LIMIT
  1

SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_operations b1_ LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b1_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_operation = 43347 AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258548;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258552;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258525;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258523;

SELECT
  b0_.photo_actualite AS photo_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?

SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258507;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_1,
  b0_.titre_actualite AS titre_actualite_2
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.date_mise_en_ligne IS NOT NULL
  AND b0_.mode_actualite = ?
  AND b0_.mode_actualite <> ?
  AND b0_.type_actualite = ?
  AND b0_.id_localisation LIKE ?
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  3

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_mise_en_ligne AS date_mise_en_ligne_1, b0_.titre_actualite AS titre_actualite_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.date_mise_en_ligne IS NOT NULL AND b0_.mode_actualite = 'publique' AND b0_.mode_actualite <> 'supprime' AND b0_.type_actualite = 'juridique_et_fiscale' AND b0_.id_localisation LIKE '41%' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 3;

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 <= '20260419213109'
                AND id_localisation LIKE CONCAT('33', '%')
        ) t
        WHERE rn <= 2
        ORDER BY date_mise_en_ligne DESC, id_actualite DESC
    ;