Symfony Profiler

SELECT
  a0_.identifiant_profil AS identifiant_profil_0,
  COUNT(DISTINCT a1_.id_annonce_vendeur) AS sclr_1
FROM
  fusacq_dbo.annonces_vendeur a1_
  LEFT JOIN fusacq_dbo.annonces_vendeur_profils_standards a0_ ON (
    a0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND a0_.identifiant_profil IS NOT NULL
GROUP BY
  a0_.identifiant_profil

SELECT a0_.identifiant_profil AS identifiant_profil_0, COUNT(DISTINCT a1_.id_annonce_vendeur) AS sclr_1 FROM fusacq_dbo.annonces_vendeur a1_ LEFT JOIN fusacq_dbo.annonces_vendeur_profils_standards a0_ ON (a0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND a0_.identifiant_profil IS NOT NULL GROUP BY a0_.identifiant_profil;

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

SELECT
  a0_.id_pays AS id_pays_0,
  l1_.nom_localisation AS nom_localisation_1
FROM
  fusacq_dbo.annonces_vendeur a0_
  LEFT JOIN fusacq_dbo.localisations l1_ ON (
    l1_.id_localisation = a0_.id_pays
  )
WHERE
  a0_.mode_annonce = 'publique'
  AND a0_.id_pays <> '00'
GROUP BY
  a0_.id_pays
ORDER BY
  l1_.nom_localisation ASC

SELECT a0_.id_pays AS id_pays_0, l1_.nom_localisation AS nom_localisation_1 FROM fusacq_dbo.annonces_vendeur a0_ LEFT JOIN fusacq_dbo.localisations l1_ ON (l1_.id_localisation = a0_.id_pays) WHERE a0_.mode_annonce = 'publique' AND a0_.id_pays <> '00' GROUP BY a0_.id_pays ORDER BY l1_.nom_localisation ASC;

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_.provenance_flux_actualite = ?
  AND b0_.mode_actualite LIKE ?
  AND b0_.visibilite_flux LIKE ?
  AND b0_.date_mise_en_ligne <= ?
  AND SUBSTRING(
    b0_.id_localisation
    FROM
      1 FOR 2
  ) = ?
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 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.provenance_flux_actualite = 'blog' AND b0_.mode_actualite LIKE 'publique' AND b0_.visibilite_flux LIKE '%horsflux%' AND b0_.date_mise_en_ligne <= '20260422123750' AND SUBSTRING(b0_.id_localisation FROM 1 FOR 2) = '41' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 5;

SELECT
  a0_.id_pays AS id_pays_0,
  a0_.autres_localisations AS autres_localisations_1
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.mode_annonce = 'publique'
  AND (
    (
      a0_.type_raprochement = 'acquisition'
      OR a0_.type_raprochement IS NULL
    )
  )

SELECT a0_.id_pays AS id_pays_0, a0_.autres_localisations AS autres_localisations_1 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.mode_annonce = 'publique' AND ((a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL));

SELECT
  l.nom_localisation,
  s0_.id_service_prestataire,
  s0_.titre_service,
  s0_.src_image_si_artviper_desactive,
  s0_.url_site_web,
  s0_.date_mise_en_ligne,
  s0_.titre_service AS titre_service_0
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r1_
  LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (
    s0_.id_service_prestataire = r1_.id_service_prestataire
  )
  LEFT JOIN fusacq_dbo.localisations l ON (
    l.id_localisation = r1_.id_localisation_prestataire
  )
WHERE
  NULLIF(s0_.id_service_prestataire, '') IS NOT NULL
  AND r1_.type IN ('societe', 'secteur', 'service')
  AND (
    s0_.id_pays = 41
    OR s0_.pays = 41
  )
UNION
SELECT
  l.nom_localisation,
  s0_.id_service_prestataire,
  s0_.titre_service,
  s0_.src_image_si_artviper_desactive,
  s0_.url_site_web,
  s0_.date_mise_en_ligne,
  s0_.titre_service AS titre_service_0
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r1_
  LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (
    s0_.id_service_prestataire = r1_.id_service_prestataire
  )
  LEFT JOIN fusacq_dbo.localisations l ON (
    l.id_localisation = r1_.id_localisation_prestataire
  )
WHERE
  NULLIF(s0_.id_service_prestataire, '') IS NOT NULL
  AND r1_.type IN ('societe', 'secteur', 'service')
  AND (
    r1_.id_localisation_prestataire LIKE '41,%'
    OR r1_.id_localisation_prestataire LIKE '%,41,%'
    OR r1_.id_localisation_prestataire LIKE '%,41'
  )
UNION
SELECT
  l.nom_localisation,
  s0_.id_service_prestataire,
  s0_.titre_service,
  s0_.src_image_si_artviper_desactive,
  s0_.url_site_web,
  s0_.date_mise_en_ligne,
  s0_.titre_service AS titre_service_0
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r1_
  LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (
    s0_.id_service_prestataire = r1_.id_service_prestataire
  )
  LEFT JOIN fusacq_dbo.localisations l ON (
    l.id_localisation = r1_.id_localisation_prestataire
  )
WHERE
  NULLIF(s0_.id_service_prestataire, '') IS NOT NULL
  AND r1_.type IN ('societe', 'secteur', 'service')
  AND (
    s0_.id_pays = 33
    OR s0_.pays = 33
  )
LIMIT
  5

SELECT l.nom_localisation  ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0  
            FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ 
            LEFT JOIN  fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) 
            LEFT JOIN  fusacq_dbo.localisations l  ON (l.id_localisation = r1_.id_localisation_prestataire) 
            WHERE    NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') 
            AND  (s0_.id_pays =41 OR s0_.pays =41) 
            UNION
            SELECT l.nom_localisation  ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0  
            FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ 
            LEFT JOIN  fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) 
            LEFT JOIN  fusacq_dbo.localisations l  ON (l.id_localisation = r1_.id_localisation_prestataire) 
            WHERE    NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') 
            AND  (r1_.id_localisation_prestataire LIKE '41,%' OR r1_.id_localisation_prestataire LIKE '%,41,%' OR r1_.id_localisation_prestataire LIKE '%,41' ) 
            UNION 
            SELECT l.nom_localisation  ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0  
            FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ 
            LEFT JOIN  fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) 
            LEFT JOIN  fusacq_dbo.localisations l  ON (l.id_localisation = r1_.id_localisation_prestataire) 
            WHERE    NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') 
            AND  (s0_.id_pays =33 OR s0_.pays =33)
            LIMIT 5 ;

SELECT
  i0_.id_localisations_recherchees AS id_localisations_recherchees_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND i0_.id_localisations_recherchees IS NOT NULL

SELECT i0_.id_localisations_recherchees AS id_localisations_recherchees_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND i0_.id_localisations_recherchees IS NOT NULL;

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

SELECT
  DISTINCT a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_0,
  a0_.id_annonce_acheteur AS id_annonce_acheteur_1,
  a0_.type_raprochement AS type_raprochement_2,
  a0_.titre_annonce AS titre_annonce_3,
  a0_.date_parution_initiale AS date_parution_initiale_4,
  a0_.date_parution AS date_parution_5,
  a0_.ca_max AS ca_max_6,
  COALESCE(a1_.devise, 'EUR') AS sclr_7,
  a0_.id_pays AS id_pays_8,
  a0_.id_region AS id_region_9,
  a0_.id_departement AS id_departement_10,
  a0_.autres_localisations AS autres_localisations_11,
  a0_.type_acquereur AS type_acquereur_12
FROM
  fusacq_dbo.annonces_acheteur a0_
  LEFT JOIN fusacq_dbo.annonces_acheteur_details a1_ ON (
    a1_.id_annonce_acheteur = a0_.id_annonce_acheteur
  )
WHERE
  a0_.date_parution_initiale <= '20260422'
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (
    a0_.id_pays = '41'
    OR a0_.autres_localisations LIKE '41,%'
    OR a0_.autres_localisations LIKE '%,41'
    OR a0_.autres_localisations LIKE '%,41,%'
  )
  AND NULLIF(
    a0_.id_period_annonce_prioritaire,
    ''
  ) IS NOT NULL
  AND a0_.etat_annonce_prioritaire = 'active'
  AND (
    a0_.ca_max >= 0
    OR a0_.ca_max IS NULL
  )
ORDER BY
  a0_.date_debut_annonce_prioritaire ASC
LIMIT
  100

SELECT DISTINCT a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_0, a0_.id_annonce_acheteur AS id_annonce_acheteur_1, a0_.type_raprochement AS type_raprochement_2, a0_.titre_annonce AS titre_annonce_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.date_parution AS date_parution_5, a0_.ca_max AS ca_max_6, COALESCE(a1_.devise, 'EUR') AS sclr_7, a0_.id_pays AS id_pays_8, a0_.id_region AS id_region_9, a0_.id_departement AS id_departement_10, a0_.autres_localisations AS autres_localisations_11, a0_.type_acquereur AS type_acquereur_12 FROM fusacq_dbo.annonces_acheteur a0_ LEFT JOIN fusacq_dbo.annonces_acheteur_details a1_ ON (a1_.id_annonce_acheteur = a0_.id_annonce_acheteur) WHERE a0_.date_parution_initiale <= '20260422' AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_pays = '41' OR a0_.autres_localisations LIKE '41,%' OR a0_.autres_localisations LIKE '%,41' OR a0_.autres_localisations LIKE '%,41,%') AND NULLIF(a0_.id_period_annonce_prioritaire, '') IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active' AND (a0_.ca_max >= 0 OR a0_.ca_max IS NULL) ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 100;

SELECT
  DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.type_raprochement AS type_raprochement_1,
  a0_.titre_annonce AS titre_annonce_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution AS date_parution_4,
  a0_.ca_max AS ca_max_5,
  COALESCE(a1_.devise, 'EUR') AS sclr_6,
  a0_.id_pays AS id_pays_7,
  a0_.id_region AS id_region_8,
  a0_.id_departement AS id_departement_9,
  a0_.autres_localisations AS autres_localisations_10,
  a0_.type_acquereur AS type_acquereur_11
FROM
  fusacq_dbo.annonces_acheteur a0_
  LEFT JOIN fusacq_dbo.annonces_acheteur_details a1_ ON (
    a1_.id_annonce_acheteur = a0_.id_annonce_acheteur
  )
WHERE
  a0_.date_parution_initiale <= '20260422'
  AND a0_.mode_annonce = 'publique'
  AND (
    a0_.id_pays = '41'
    OR a0_.autres_localisations LIKE '41,%'
    OR a0_.autres_localisations LIKE '%,41'
    OR a0_.autres_localisations LIKE '%,41,%'
  )
ORDER BY
  a0_.date_parution ASC
LIMIT
  100

SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.type_raprochement AS type_raprochement_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.ca_max AS ca_max_5, COALESCE(a1_.devise, 'EUR') AS sclr_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.id_departement AS id_departement_9, a0_.autres_localisations AS autres_localisations_10, a0_.type_acquereur AS type_acquereur_11 FROM fusacq_dbo.annonces_acheteur a0_ LEFT JOIN fusacq_dbo.annonces_acheteur_details a1_ ON (a1_.id_annonce_acheteur = a0_.id_annonce_acheteur) WHERE a0_.date_parution_initiale <= '20260422' AND a0_.mode_annonce = 'publique' AND (a0_.id_pays = '41' OR a0_.autres_localisations LIKE '41,%' OR a0_.autres_localisations LIKE '%,41' OR a0_.autres_localisations LIKE '%,41,%') ORDER BY a0_.date_parution ASC LIMIT 100;

SELECT
  DISTINCT a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_0,
  a0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  a0_.type_raprochement AS type_raprochement_2,
  a0_.titre_annonce AS titre_annonce_3,
  a0_.date_parution_initiale AS date_parution_initiale_4,
  a0_.date_parution AS date_parution_5,
  a0_.ca_n AS ca_n_6,
  COALESCE(a1_.devise, 'EUR') AS sclr_7,
  a0_.id_pays AS id_pays_8,
  a0_.id_region AS id_region_9,
  a0_.id_departement AS id_departement_10
FROM
  fusacq_dbo.annonces_vendeur a0_
  LEFT JOIN fusacq_dbo.annonces_vendeur_details a1_ ON (
    a1_.id_annonce_vendeur = a0_.id_annonce_vendeur
  )
WHERE
  a0_.date_parution_initiale <= '20260422'
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_period_annonce_prioritaire <> ''
  AND a0_.id_period_annonce_prioritaire IS NOT NULL
  AND a0_.etat_annonce_prioritaire = 'active'
  AND (a0_.ca_n >= 0)
  AND a0_.id_pays = '41'
  AND (
    a0_.prix_cession >= 0
    OR NULLIF(a0_.prix_cession, '') IS NULL
  )
  AND (
    a0_.apport_fp_min >= 0
    OR NULLIF(a0_.apport_fp_min, '') IS NULL
  )
ORDER BY
  a0_.date_debut_annonce_prioritaire ASC
LIMIT
  100

SELECT DISTINCT a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_1, a0_.type_raprochement AS type_raprochement_2, a0_.titre_annonce AS titre_annonce_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.date_parution AS date_parution_5, a0_.ca_n AS ca_n_6, COALESCE(a1_.devise, 'EUR') AS sclr_7, a0_.id_pays AS id_pays_8, a0_.id_region AS id_region_9, a0_.id_departement AS id_departement_10 FROM fusacq_dbo.annonces_vendeur a0_ LEFT JOIN fusacq_dbo.annonces_vendeur_details a1_ ON (a1_.id_annonce_vendeur = a0_.id_annonce_vendeur) WHERE a0_.date_parution_initiale <= '20260422' AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_period_annonce_prioritaire <> '' AND a0_.id_period_annonce_prioritaire IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active' AND (a0_.ca_n >= 0) AND a0_.id_pays = '41' AND (a0_.prix_cession >= 0 OR NULLIF(a0_.prix_cession, '') IS NULL) AND (a0_.apport_fp_min >= 0 OR NULLIF(a0_.apport_fp_min, '') IS NULL) ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 100;

SELECT
  DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.type_raprochement AS type_raprochement_1,
  a0_.titre_annonce AS titre_annonce_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution AS date_parution_4,
  a0_.ca_n AS ca_n_5,
  COALESCE(a1_.devise, 'EUR') AS sclr_6,
  a0_.id_pays AS id_pays_7,
  a0_.id_region AS id_region_8,
  a0_.id_departement AS id_departement_9
FROM
  fusacq_dbo.annonces_vendeur a0_
  LEFT JOIN fusacq_dbo.annonces_vendeur_details a1_ ON (
    a1_.id_annonce_vendeur = a0_.id_annonce_vendeur
  )
WHERE
  a0_.date_parution_initiale <= '20260422'
  AND a0_.mode_annonce = 'publique'
  AND a0_.id_pays = '41'
ORDER BY
  a0_.date_parution ASC
LIMIT
  100

SELECT DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.type_raprochement AS type_raprochement_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.ca_n AS ca_n_5, COALESCE(a1_.devise, 'EUR') AS sclr_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.id_departement AS id_departement_9 FROM fusacq_dbo.annonces_vendeur a0_ LEFT JOIN fusacq_dbo.annonces_vendeur_details a1_ ON (a1_.id_annonce_vendeur = a0_.id_annonce_vendeur) WHERE a0_.date_parution_initiale <= '20260422' AND a0_.mode_annonce = 'publique' AND a0_.id_pays = '41' ORDER BY a0_.date_parution ASC LIMIT 100;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.titre_actualite AS titre_actualite_1,
  b0_.description_actualite AS description_actualite_2,
  b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_3,
  s1_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_5
FROM
  fusacq_dbo.buzz_actualites b0_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b0_.id_operation = b2_.id_operation
  )
  LEFT JOIN fusacq_dbo.services_prestataire s1_ ON (
    b0_.id_service_principal = s1_.id_service_prestataire
  )
WHERE
  SUBSTRING(
    b0_.id_localisation
    FROM
      1 FOR 2
  ) = '41'
  AND b0_.mode_actualite = ?
  AND b2_.type_operation = ?
  AND b0_.date_mise_en_ligne <= ?
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  5

SELECT b0_.id_actualite AS id_actualite_0, b0_.titre_actualite AS titre_actualite_1, b0_.description_actualite AS description_actualite_2, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_3, s1_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4, b0_.date_mise_en_ligne AS date_mise_en_ligne_5 FROM fusacq_dbo.buzz_actualites b0_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b0_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.services_prestataire s1_ ON (b0_.id_service_principal = s1_.id_service_prestataire) WHERE SUBSTRING(b0_.id_localisation FROM 1 FOR 2) = '41' AND b0_.mode_actualite = 'publique' AND b2_.type_operation = 'fusion_acquisition' AND b0_.date_mise_en_ligne <= '20260422123749' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 5;

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'nb_annonces_publiques_PDC' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  p0_.valeur_parametre AS valeur_parametre_0
FROM
  partage_dbo.parametres_divers p0_
WHERE
  p0_.id_type_parametre_divers = 1
  AND p0_.nom_parametre = 'list_nombres_acueil_fusacq'

SELECT p0_.valeur_parametre AS valeur_parametre_0 FROM partage_dbo.parametres_divers p0_ WHERE p0_.id_type_parametre_divers = 1 AND p0_.nom_parametre = 'list_nombres_acueil_fusacq';