Symfony Profiler

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_.provenance_flux_actualite = ?
  AND b0_.visibilite_flux LIKE ?
  AND b0_.id_localisation LIKE ?
  AND b0_.date_mise_en_ligne <= ?
  AND b0_.type_actualite = ?

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_.provenance_flux_actualite = 'blog' AND b0_.visibilite_flux LIKE '%horsflux%' AND b0_.id_localisation LIKE '01%' AND b0_.date_mise_en_ligne <= '20260501195506' AND b0_.type_actualite = 'autre';

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_.id_operation AS id_operation_12
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_.provenance_flux_actualite = ?
  AND b0_.visibilite_flux LIKE ?
  AND b0_.id_localisation LIKE ?
  AND b0_.date_mise_en_ligne <= ?
  AND b0_.type_actualite = ?
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  20

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_.id_operation AS id_operation_12 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_.provenance_flux_actualite = 'blog' AND b0_.visibilite_flux LIKE '%horsflux%' AND b0_.id_localisation LIKE '01%' AND b0_.date_mise_en_ligne <= '20260501195506' AND b0_.type_actualite = 'autre' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 20;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0,
  s0_.titre_service AS titre_service_1,
  s0_.nom_commercial_societe AS nom_commercial_societe_2
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.id_service_prestataire = ?

SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = 1670;

SELECT
  s0_.image_filename AS image_filename_0
FROM
  fusacq_dbo.buzz_actualites b1_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b1_.id_operation = b2_.id_operation
  )
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b2_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_actualite = ?
  AND b1_.id_operation IS NOT NULL
  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_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = 245153 AND b1_.id_operation IS NOT NULL 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_actualites b1_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b1_.id_actualite = b2_.id_actualite_principale
  )
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b2_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_actualite = ?
  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_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_actualite = b2_.id_actualite_principale) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = 245153 AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0,
  s0_.titre_service AS titre_service_1,
  s0_.nom_commercial_societe AS nom_commercial_societe_2
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.id_service_prestataire = ?

SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = 1340;

SELECT
  s0_.image_filename AS image_filename_0
FROM
  fusacq_dbo.buzz_actualites b1_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b1_.id_operation = b2_.id_operation
  )
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b2_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_actualite = ?
  AND b1_.id_operation IS NOT NULL
  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_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = 221174 AND b1_.id_operation IS NOT NULL 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_actualites b1_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b1_.id_actualite = b2_.id_actualite_principale
  )
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b2_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_actualite = ?
  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_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_actualite = b2_.id_actualite_principale) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = 221174 AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0,
  s0_.titre_service AS titre_service_1,
  s0_.nom_commercial_societe AS nom_commercial_societe_2
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.id_service_prestataire = ?

SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = 1761;

SELECT
  s0_.image_filename AS image_filename_0
FROM
  fusacq_dbo.buzz_actualites b1_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b1_.id_operation = b2_.id_operation
  )
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b2_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_actualite = ?
  AND b1_.id_operation IS NOT NULL
  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_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = 210725 AND b1_.id_operation IS NOT NULL 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_actualites b1_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b1_.id_actualite = b2_.id_actualite_principale
  )
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b2_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_actualite = ?
  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_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_actualite = b2_.id_actualite_principale) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = 210725 AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0,
  s0_.titre_service AS titre_service_1,
  s0_.nom_commercial_societe AS nom_commercial_societe_2
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.id_service_prestataire = ?

SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = 1670;

SELECT
  s0_.image_filename AS image_filename_0
FROM
  fusacq_dbo.buzz_actualites b1_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b1_.id_operation = b2_.id_operation
  )
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b2_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_actualite = ?
  AND b1_.id_operation IS NOT NULL
  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_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = 199828 AND b1_.id_operation IS NOT NULL 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_actualites b1_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b1_.id_actualite = b2_.id_actualite_principale
  )
  LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (
    b2_.id_secteur_activite = s0_.id_secteur_activite
  )
WHERE
  b1_.id_actualite = ?
  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_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_actualite = b2_.id_actualite_principale) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = 199828 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
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 '01%' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 3;