Symfony Profiler

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 = 258830;

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_.id_societe_prestataire AS id_societe_prestataire_10,
  b0_.id_service_principal AS id_service_principal_11,
  b0_.a_la_une AS a_la_une_12,
  b0_.a_la_une_du_jour AS a_la_une_du_jour_13
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_.date_mise_en_ligne BETWEEN ?
    AND ?
  )
  AND b0_.date_mise_en_ligne <= ?
  AND b0_.mode_actualite = ?
  AND b0_.mode_actualite <> ?
  AND (
    (
      b1_.id_localisation LIKE ?
      OR b1_.id_localisation = ?
      OR b1_.id_localisation_2 LIKE ?
      OR b1_.id_localisation_2 = ?
    )
    OR (
      b0_.id_localisation LIKE ?
      OR b0_.id_localisation = ?
    )
  )
  AND (
    b0_.type_actualite IS NULL
    OR b0_.type_actualite = ''
    OR LOWER(b0_.type_actualite) NOT IN (?, ?, ?, ?, ?, ?)
  )
  AND b0_.id_actualite NOT IN (?)
ORDER BY
  b0_.date_mise_en_ligne DESC

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_.id_societe_prestataire AS id_societe_prestataire_10, b0_.id_service_principal AS id_service_principal_11, b0_.a_la_une AS a_la_une_12, b0_.a_la_une_du_jour AS a_la_une_du_jour_13 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_.date_mise_en_ligne BETWEEN '20260420000000' AND '20260424235959') AND b0_.date_mise_en_ligne <= '20260425201453' AND b0_.mode_actualite = 'publique' AND b0_.mode_actualite <> 'supprime' AND ((b1_.id_localisation LIKE '32%' OR b1_.id_localisation = '32' OR b1_.id_localisation_2 LIKE '32%' OR b1_.id_localisation_2 = '32') OR (b0_.id_localisation LIKE '32%' OR b0_.id_localisation = '32')) AND (b0_.type_actualite IS NULL OR b0_.type_actualite = '' OR LOWER(b0_.type_actualite) NOT IN ('reflexion', 'evenement', 'expertise', 'nomination', 'emploi', 'autre')) AND b0_.id_actualite NOT IN ('258830') ORDER BY b0_.date_mise_en_ligne DESC;

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 = 43458 AND b0_.id_actualite <> 258789 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
  COUNT(b0_.id_actualite) AS sclr_0
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_.date_mise_en_ligne >= ?
  AND b0_.date_mise_en_ligne <= ?
  AND b0_.id_localisation LIKE ?

SELECT COUNT(b0_.id_actualite) AS sclr_0 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_.date_mise_en_ligne >= '20251001000000' AND b0_.date_mise_en_ligne <= '20251031235959' AND b0_.id_localisation LIKE '32%';

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 = 43458 AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1;

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_.a_la_une AS a_la_une_10,
  b0_.a_la_une_du_jour AS a_la_une_du_jour_11,
  b0_.id_operation AS id_operation_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_.id_actualite NOT IN (?)
  AND (
    (
      b1_.id_localisation LIKE ?
      OR b1_.id_localisation = ?
      OR b1_.id_localisation_2 LIKE ?
      OR b1_.id_localisation_2 = ?
    )
    OR (
      b0_.id_localisation LIKE ?
      OR b0_.id_localisation = ?
    )
  )
  AND (
    b0_.provenance_flux_actualite <> ?
    OR (
      b0_.provenance_flux_actualite = ?
      AND b0_.visibilite_flux LIKE ?
    )
  )
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  2

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_.a_la_une AS a_la_une_10, b0_.a_la_une_du_jour AS a_la_une_du_jour_11, b0_.id_operation AS id_operation_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 <= '20260425201453' AND b0_.id_actualite NOT IN ('258830') AND ((b1_.id_localisation LIKE '32%' OR b1_.id_localisation = '32' OR b1_.id_localisation_2 LIKE '32%' OR b1_.id_localisation_2 = '32') OR (b0_.id_localisation LIKE '32%' OR b0_.id_localisation = '32')) AND (b0_.provenance_flux_actualite <> 'blog' OR (b0_.provenance_flux_actualite = 'blog' AND b0_.visibilite_flux LIKE '%collaborative%')) ORDER BY b0_.date_mise_en_ligne DESC LIMIT 2;

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 AS a_la_une_9,
  b0_.a_la_une_du_jour AS a_la_une_du_jour_10,
  b0_.id_operation AS id_operation_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 = ?
  AND b0_.mode_actualite = ?
  AND b0_.mode_actualite <> ?
  AND b0_.date_mise_en_ligne <= ?
  AND (
    (
      b1_.id_localisation LIKE ?
      OR b1_.id_localisation = ?
      OR b1_.id_localisation_2 LIKE ?
      OR b1_.id_localisation_2 = ?
    )
    OR (
      b0_.id_localisation LIKE ?
      OR b0_.id_localisation = ?
    )
  )
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  1

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 AS a_la_une_9, b0_.a_la_une_du_jour AS a_la_une_du_jour_10, b0_.id_operation AS id_operation_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 = 'oui' AND b0_.mode_actualite = 'publique' AND b0_.mode_actualite <> 'supprime' AND b0_.date_mise_en_ligne <= '20260425201453' AND ((b1_.id_localisation LIKE '32%' OR b1_.id_localisation = '32' OR b1_.id_localisation_2 LIKE '32%' OR b1_.id_localisation_2 = '32') OR (b0_.id_localisation LIKE '32%' OR b0_.id_localisation = '32')) ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1;