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 '33%' AND b0_.date_mise_en_ligne <= '20260416100840' AND b0_.type_actualite = 'reference';

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,
  b0_.photo_actualite AS photo_actualite_13
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 OFFSET 6900

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, b0_.photo_actualite AS photo_actualite_13 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 '33%' AND b0_.date_mise_en_ligne <= '20260416100840' AND b0_.type_actualite = 'reference' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 20 OFFSET 6900;

SELECT
  nom_commercial_societe,
  titre_service
FROM
  fusacq_dbo.services_prestataire
WHERE
  id_service_prestataire = ?
LIMIT
  1

SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = 1099 LIMIT 1;

SELECT
  id_actualite,
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_operation = ?
  AND id_actualite != ?
  AND mode_actualite = ?
  AND photo_actualite IS NOT NULL
  AND photo_actualite != ""
  AND photo_actualite != "NULL"
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  1

SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = 18138 
                AND id_actualite != 147028 
                AND mode_actualite = 'publique'
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_operations bo
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  bo.id_operation = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = 18138
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
                ;

SELECT
  nom_commercial_societe,
  titre_service
FROM
  fusacq_dbo.services_prestataire
WHERE
  id_service_prestataire = ?
LIMIT
  1

SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = 1099 LIMIT 1;

SELECT
  id_actualite,
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_operation = ?
  AND id_actualite != ?
  AND mode_actualite = ?
  AND photo_actualite IS NOT NULL
  AND photo_actualite != ""
  AND photo_actualite != "NULL"
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  1

SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = 18135 
                AND id_actualite != 147024 
                AND mode_actualite = 'publique'
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_operations bo
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  bo.id_operation = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = 18135
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
                ;

SELECT
  nom_commercial_societe,
  titre_service
FROM
  fusacq_dbo.services_prestataire
WHERE
  id_service_prestataire = ?
LIMIT
  1

SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = 1099 LIMIT 1;

SELECT
  id_actualite,
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_operation = ?
  AND id_actualite != ?
  AND mode_actualite = ?
  AND photo_actualite IS NOT NULL
  AND photo_actualite != ""
  AND photo_actualite != "NULL"
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  1

SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = 18127 
                AND id_actualite != 146973 
                AND mode_actualite = 'publique'
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_operations bo
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  bo.id_operation = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = 18127
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
                ;

SELECT
  nom_commercial_societe,
  titre_service
FROM
  fusacq_dbo.services_prestataire
WHERE
  id_service_prestataire = ?
LIMIT
  1

SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = 1100 LIMIT 1;

SELECT
  id_actualite,
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_operation = ?
  AND id_actualite != ?
  AND mode_actualite = ?
  AND photo_actualite IS NOT NULL
  AND photo_actualite != ""
  AND photo_actualite != "NULL"
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  1

SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = 18136 
                AND id_actualite != 147026 
                AND mode_actualite = 'publique'
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_operations bo
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  bo.id_operation = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = 18136
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
                ;

SELECT
  nom_commercial_societe,
  titre_service
FROM
  fusacq_dbo.services_prestataire
WHERE
  id_service_prestataire = ?
LIMIT
  1

SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = 1099 LIMIT 1;

SELECT
  id_actualite,
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_operation = ?
  AND id_actualite != ?
  AND mode_actualite = ?
  AND photo_actualite IS NOT NULL
  AND photo_actualite != ""
  AND photo_actualite != "NULL"
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  1

SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = 18139 
                AND id_actualite != 147030 
                AND mode_actualite = 'publique'
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_operations bo
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  bo.id_operation = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = 18139
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
                ;

SELECT
  nom_commercial_societe,
  titre_service
FROM
  fusacq_dbo.services_prestataire
WHERE
  id_service_prestataire = ?
LIMIT
  1

SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = 1100 LIMIT 1;

SELECT
  id_actualite,
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_operation = ?
  AND id_actualite != ?
  AND mode_actualite = ?
  AND photo_actualite IS NOT NULL
  AND photo_actualite != ""
  AND photo_actualite != "NULL"
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  1

SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = 18126 
                AND id_actualite != 146971 
                AND mode_actualite = 'publique'
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_operations bo
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  bo.id_operation = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = 18126
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
                ;