Symfony Profiler

SELECT
  a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.date_parution_initiale AS date_parution_initiale_2,
  a0_.date_parution AS date_parution_3,
  a0_.ca_max AS ca_max_4,
  a0_.id_pays AS id_pays_5,
  a0_.id_region AS id_region_6,
  a0_.id_departement AS id_departement_7,
  a0_.autres_localisations AS autres_localisations_8,
  a0_.type_acquereur AS type_acquereur_9,
  a0_.id_secteur_activite AS id_secteur_activite_10,
  a0_.login_utilisateur AS login_utilisateur_11,
  a0_.ca_min AS ca_min_12,
  a0_.ca_max AS ca_max_13,
  a0_.ca_societe AS ca_societe_14,
  a0_.res_net_societe AS res_net_societe_15,
  a0_.type_raprochement AS type_raprochement_16,
  a0_.mode_annonce AS mode_annonce_17,
  a0_.description_activite AS description_activite_18,
  a0_.raison_achat AS raison_achat_19,
  a0_.nb_personnes_max AS nb_personnes_max_20,
  a0_.nb_personnes_min AS nb_personnes_min_21,
  a0_.date_creation_societe AS date_creation_societe_22,
  a0_.nb_personnes_societe AS nb_personnes_societe_23,
  a0_.ca_societe AS ca_societe_24,
  a0_.res_net_societe AS res_net_societe_25,
  a0_.description_activite_societe AS description_activite_societe_26,
  a0_.date_creation_societe AS date_creation_societe_27,
  a0_.annee_naissance_repreneur AS annee_naissance_repreneur_28,
  a0_.apport_perso_repreneur AS apport_perso_repreneur_29,
  a0_.formation_repreneur AS formation_repreneur_30,
  a0_.parcours_pro_repreneur AS parcours_pro_repreneur_31,
  a0_.elements_complementaires AS elements_complementaires_32,
  a0_.recherche_active AS recherche_active_33,
  a0_.demarche AS demarche_34,
  a0_.recherche_entreprise_difficulte AS recherche_entreprise_difficulte_35,
  a0_.nom_contact AS nom_contact_36,
  a0_.email AS email_37,
  a0_.telephone AS telephone_38,
  a0_.commentaires AS commentaires_39,
  a0_.id_langue AS id_langue_40,
  a0_.indicatif_telephone AS indicatif_telephone_41
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_annonce_acheteur = 17905

SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.id_pays AS id_pays_5, a0_.id_region AS id_region_6, a0_.id_departement AS id_departement_7, a0_.autres_localisations AS autres_localisations_8, a0_.type_acquereur AS type_acquereur_9, a0_.id_secteur_activite AS id_secteur_activite_10, a0_.login_utilisateur AS login_utilisateur_11, a0_.ca_min AS ca_min_12, a0_.ca_max AS ca_max_13, a0_.ca_societe AS ca_societe_14, a0_.res_net_societe AS res_net_societe_15, a0_.type_raprochement AS type_raprochement_16, a0_.mode_annonce AS mode_annonce_17, a0_.description_activite AS description_activite_18, a0_.raison_achat AS raison_achat_19, a0_.nb_personnes_max AS nb_personnes_max_20, a0_.nb_personnes_min AS nb_personnes_min_21, a0_.date_creation_societe AS date_creation_societe_22, a0_.nb_personnes_societe AS nb_personnes_societe_23, a0_.ca_societe AS ca_societe_24, a0_.res_net_societe AS res_net_societe_25, a0_.description_activite_societe AS description_activite_societe_26, a0_.date_creation_societe AS date_creation_societe_27, a0_.annee_naissance_repreneur AS annee_naissance_repreneur_28, a0_.apport_perso_repreneur AS apport_perso_repreneur_29, a0_.formation_repreneur AS formation_repreneur_30, a0_.parcours_pro_repreneur AS parcours_pro_repreneur_31, a0_.elements_complementaires AS elements_complementaires_32, a0_.recherche_active AS recherche_active_33, a0_.demarche AS demarche_34, a0_.recherche_entreprise_difficulte AS recherche_entreprise_difficulte_35, a0_.nom_contact AS nom_contact_36, a0_.email AS email_37, a0_.telephone AS telephone_38, a0_.commentaires AS commentaires_39, a0_.id_langue AS id_langue_40, a0_.indicatif_telephone AS indicatif_telephone_41 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_acheteur = 17905;

SELECT
  t0.id_utilisateur AS id_utilisateur_1,
  t0.login_utilisateur AS login_utilisateur_2,
  t0.password_encrypted_utilisateur AS password_encrypted_utilisateur_3,
  t0.is_verified AS is_verified_4,
  t0.mode_utilisateur AS mode_utilisateur_5,
  t0.type_abonnement AS type_abonnement_6,
  t0.date_demande_inscription AS date_demande_inscription_7,
  t0.date_demande_inscription_complete AS date_demande_inscription_complete_8,
  t0.date_relance AS date_relance_9,
  t0.date_inscription_reelle AS date_inscription_reelle_10,
  t0.langue_utilisee AS langue_utilisee_11,
  t0.type_utilisateur AS type_utilisateur_12,
  t0.nom_utilisateur AS nom_utilisateur_13,
  t0.prenom_utilisateur AS prenom_utilisateur_14,
  t0.email_utilisateur AS email_utilisateur_15,
  t0.societe_utilisateur AS societe_utilisateur_16,
  t0.rcs_utilisateur AS rcs_utilisateur_17,
  t0.relance_mail_utilisateur AS relance_mail_utilisateur_18,
  t0.pieces_necessaires AS pieces_necessaires_19,
  t0.pays_utilisateur AS pays_utilisateur_20,
  t0.region_utilisateur AS region_utilisateur_21,
  t0.ville_utilisateur AS ville_utilisateur_22,
  t0.code_postal_utilisateur AS code_postal_utilisateur_23,
  t0.adresse_utilisateur AS adresse_utilisateur_24,
  t0.commentaire_utilisateur AS commentaire_utilisateur_25,
  t0.litige_utilisateur AS litige_utilisateur_26,
  t0.compte_facturation AS compte_facturation_27,
  t0.factur_nom_societe AS factur_nom_societe_28,
  t0.factur_adresse AS factur_adresse_29,
  t0.factur_code_postal AS factur_code_postal_30,
  t0.factur_ville AS factur_ville_31,
  t0.factur_pays AS factur_pays_32,
  t0.factur_id_pays AS factur_id_pays_33,
  t0.id_type_structure AS id_type_structure_34,
  t0.telephone_utilisateur AS telephone_utilisateur_35,
  t0.indicatif_tel AS indicatif_tel_36,
  t0.id_structure AS id_structure_37,
  t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_38,
  t0.fonction_utilisateur AS fonction_utilisateur_39,
  t0.lien_internet AS lien_internet_40,
  t0.tva_intracommunautaire AS tva_intracommunautaire_41,
  t0.id_client_publicite AS id_client_publicite_42,
  t0.inscription_partenaire AS inscription_partenaire_43,
  t0.site_partenaire AS site_partenaire_44,
  t0.provenance_connexion_fusacq AS provenance_connexion_fusacq_45,
  t0.suivi AS suivi_46,
  t0.date_derniere_connexion AS date_derniere_connexion_47,
  t0.date_desinscription_fusacq AS date_desinscription_fusacq_48,
  t0.type_commande AS type_commande_49,
  t0.date_derniere_commande AS date_derniere_commande_50,
  t0.date_dernier_depot_annonce AS date_dernier_depot_annonce_51,
  t0.etat_relance AS etat_relance_52,
  t0.agence_utilisateur AS agence_utilisateur_53,
  t0.cookie_authentification AS cookie_authentification_54,
  t0.id_pays_utilisateur AS id_pays_utilisateur_55,
  t0.id_region AS id_region_56,
  t0.contact_suite_inscription AS contact_suite_inscription_57,
  t0.id_societe_prestataire AS id_societe_prestataire_58,
  t0.association_societe_prestataire AS association_societe_prestataire_59,
  t0.mail_note_qualite_mer AS mail_note_qualite_mer_60,
  t0.provenance_notoriete_fusacq AS provenance_notoriete_fusacq_61,
  t0.id_reseau_commerce AS id_reseau_commerce_62,
  t0.montant_contact_defaut AS montant_contact_defaut_63,
  t0.montant_contact_international_defaut AS montant_contact_international_defaut_64,
  t0.type_utilisateur_commerce AS type_utilisateur_commerce_65,
  t0.annee_naissance AS annee_naissance_66,
  t0.civilite AS civilite_67,
  t0.inscription_validee AS inscription_validee_68,
  t0.plateforme_inscription AS plateforme_inscription_69,
  t0.frequence_envoi_alertes_commerces AS frequence_envoi_alertes_commerces_70,
  t0.date_dernier_envoi_alerte_commerces AS date_dernier_envoi_alerte_commerces_71,
  t0.mode_reglement_commerce AS mode_reglement_commerce_72,
  t0.id_agence_commerce AS id_agence_commerce_73,
  t0.provenance_connexion_commerces AS provenance_connexion_commerces_74,
  t0.importer_annonces_pdc_sur_ce_compte AS importer_annonces_pdc_sur_ce_compte_75,
  t0.email_invalide AS email_invalide_76,
  t0.personne_societe AS personne_societe_77,
  t0.type_utilisateur_franchise AS type_utilisateur_franchise_78,
  t0.mode_reglement_franchise AS mode_reglement_franchise_79,
  t0.montant_cv_defaut AS montant_cv_defaut_80,
  t0.montant_cv_international_defaut AS montant_cv_international_defaut_81,
  t0.id_cv AS id_cv_82,
  t0.telephone_utilisateur_back AS telephone_utilisateur_back_83,
  t0.site_derniere_connexion AS site_derniere_connexion_84,
  t0.date_derniere_notification_propose_cv_pdc AS date_derniere_notification_propose_cv_pdc_85,
  t0.devise AS devise_86,
  t0.id_pays_tarif_applicable AS id_pays_tarif_applicable_87,
  t0.identifiant_entreprise AS identifiant_entreprise_88,
  t0.non_assujetti_tva AS non_assujetti_tva_89
FROM
  fusacq_dbo.utilisateurs t0
WHERE
  t0.login_utilisateur = ?
LIMIT
  1

SELECT t0.id_utilisateur AS id_utilisateur_1, t0.login_utilisateur AS login_utilisateur_2, t0.password_encrypted_utilisateur AS password_encrypted_utilisateur_3, t0.is_verified AS is_verified_4, t0.mode_utilisateur AS mode_utilisateur_5, t0.type_abonnement AS type_abonnement_6, t0.date_demande_inscription AS date_demande_inscription_7, t0.date_demande_inscription_complete AS date_demande_inscription_complete_8, t0.date_relance AS date_relance_9, t0.date_inscription_reelle AS date_inscription_reelle_10, t0.langue_utilisee AS langue_utilisee_11, t0.type_utilisateur AS type_utilisateur_12, t0.nom_utilisateur AS nom_utilisateur_13, t0.prenom_utilisateur AS prenom_utilisateur_14, t0.email_utilisateur AS email_utilisateur_15, t0.societe_utilisateur AS societe_utilisateur_16, t0.rcs_utilisateur AS rcs_utilisateur_17, t0.relance_mail_utilisateur AS relance_mail_utilisateur_18, t0.pieces_necessaires AS pieces_necessaires_19, t0.pays_utilisateur AS pays_utilisateur_20, t0.region_utilisateur AS region_utilisateur_21, t0.ville_utilisateur AS ville_utilisateur_22, t0.code_postal_utilisateur AS code_postal_utilisateur_23, t0.adresse_utilisateur AS adresse_utilisateur_24, t0.commentaire_utilisateur AS commentaire_utilisateur_25, t0.litige_utilisateur AS litige_utilisateur_26, t0.compte_facturation AS compte_facturation_27, t0.factur_nom_societe AS factur_nom_societe_28, t0.factur_adresse AS factur_adresse_29, t0.factur_code_postal AS factur_code_postal_30, t0.factur_ville AS factur_ville_31, t0.factur_pays AS factur_pays_32, t0.factur_id_pays AS factur_id_pays_33, t0.id_type_structure AS id_type_structure_34, t0.telephone_utilisateur AS telephone_utilisateur_35, t0.indicatif_tel AS indicatif_tel_36, t0.id_structure AS id_structure_37, t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_38, t0.fonction_utilisateur AS fonction_utilisateur_39, t0.lien_internet AS lien_internet_40, t0.tva_intracommunautaire AS tva_intracommunautaire_41, t0.id_client_publicite AS id_client_publicite_42, t0.inscription_partenaire AS inscription_partenaire_43, t0.site_partenaire AS site_partenaire_44, t0.provenance_connexion_fusacq AS provenance_connexion_fusacq_45, t0.suivi AS suivi_46, t0.date_derniere_connexion AS date_derniere_connexion_47, t0.date_desinscription_fusacq AS date_desinscription_fusacq_48, t0.type_commande AS type_commande_49, t0.date_derniere_commande AS date_derniere_commande_50, t0.date_dernier_depot_annonce AS date_dernier_depot_annonce_51, t0.etat_relance AS etat_relance_52, t0.agence_utilisateur AS agence_utilisateur_53, t0.cookie_authentification AS cookie_authentification_54, t0.id_pays_utilisateur AS id_pays_utilisateur_55, t0.id_region AS id_region_56, t0.contact_suite_inscription AS contact_suite_inscription_57, t0.id_societe_prestataire AS id_societe_prestataire_58, t0.association_societe_prestataire AS association_societe_prestataire_59, t0.mail_note_qualite_mer AS mail_note_qualite_mer_60, t0.provenance_notoriete_fusacq AS provenance_notoriete_fusacq_61, t0.id_reseau_commerce AS id_reseau_commerce_62, t0.montant_contact_defaut AS montant_contact_defaut_63, t0.montant_contact_international_defaut AS montant_contact_international_defaut_64, t0.type_utilisateur_commerce AS type_utilisateur_commerce_65, t0.annee_naissance AS annee_naissance_66, t0.civilite AS civilite_67, t0.inscription_validee AS inscription_validee_68, t0.plateforme_inscription AS plateforme_inscription_69, t0.frequence_envoi_alertes_commerces AS frequence_envoi_alertes_commerces_70, t0.date_dernier_envoi_alerte_commerces AS date_dernier_envoi_alerte_commerces_71, t0.mode_reglement_commerce AS mode_reglement_commerce_72, t0.id_agence_commerce AS id_agence_commerce_73, t0.provenance_connexion_commerces AS provenance_connexion_commerces_74, t0.importer_annonces_pdc_sur_ce_compte AS importer_annonces_pdc_sur_ce_compte_75, t0.email_invalide AS email_invalide_76, t0.personne_societe AS personne_societe_77, t0.type_utilisateur_franchise AS type_utilisateur_franchise_78, t0.mode_reglement_franchise AS mode_reglement_franchise_79, t0.montant_cv_defaut AS montant_cv_defaut_80, t0.montant_cv_international_defaut AS montant_cv_international_defaut_81, t0.id_cv AS id_cv_82, t0.telephone_utilisateur_back AS telephone_utilisateur_back_83, t0.site_derniere_connexion AS site_derniere_connexion_84, t0.date_derniere_notification_propose_cv_pdc AS date_derniere_notification_propose_cv_pdc_85, t0.devise AS devise_86, t0.id_pays_tarif_applicable AS id_pays_tarif_applicable_87, t0.identifiant_entreprise AS identifiant_entreprise_88, t0.non_assujetti_tva AS non_assujetti_tva_89 FROM fusacq_dbo.utilisateurs t0 WHERE t0.login_utilisateur = '302330' LIMIT 1;

SELECT
  t0.id_annonce AS id_annonce_1,
  t0.nb_consultations AS nb_consultations_2,
  t0.mail_notification AS mail_notification_3
FROM
  fusacq_dbo.statistiques_nb_consultations_annonces_acheteur t0
WHERE
  t0.id_annonce = ?

SELECT t0.id_annonce AS id_annonce_1, t0.nb_consultations AS nb_consultations_2, t0.mail_notification AS mail_notification_3 FROM fusacq_dbo.statistiques_nb_consultations_annonces_acheteur t0 WHERE t0.id_annonce = '17905';

SELECT
  b0_.id_operation AS id_operation_0,
  b1_.id_actualite_principale AS id_actualite_principale_1,
  b2_.titre_actualite AS titre_actualite_2,
  b2_.sous_titre AS sous_titre_3,
  b2_.date_mise_en_ligne AS date_mise_en_ligne_4,
  b2_.provenance_flux_actualite AS provenance_flux_actualite_5
FROM
  buzz_lien_operations_annonces_acheteur b0_
  LEFT JOIN fusacq_dbo.buzz_operations b1_ ON (
    b0_.id_operation = b1_.id_operation
  )
  LEFT JOIN fusacq_dbo.buzz_actualites b2_ ON (
    b1_.id_actualite_principale = b2_.id_actualite
  )
WHERE
  b0_.id_annonce = ?
  AND b2_.mode_actualite = 'publique'
  AND (
    b2_.provenance_flux_actualite <> 'blog'
    OR (
      b2_.provenance_flux_actualite = 'blog'
      AND b2_.visibilite_flux LIKE '%collaborative%'
    )
  )
  AND b2_.date_mise_en_ligne <= 20260407224048
ORDER BY
  b2_.date_mise_en_ligne DESC
LIMIT
  10

SELECT b0_.id_operation AS id_operation_0, b1_.id_actualite_principale AS id_actualite_principale_1, b2_.titre_actualite AS titre_actualite_2, b2_.sous_titre AS sous_titre_3, b2_.date_mise_en_ligne AS date_mise_en_ligne_4, b2_.provenance_flux_actualite AS provenance_flux_actualite_5 FROM buzz_lien_operations_annonces_acheteur b0_ LEFT JOIN fusacq_dbo.buzz_operations b1_ ON (b0_.id_operation = b1_.id_operation) LEFT JOIN fusacq_dbo.buzz_actualites b2_ ON (b1_.id_actualite_principale = b2_.id_actualite) WHERE b0_.id_annonce = 17905 AND b2_.mode_actualite = 'publique' AND (b2_.provenance_flux_actualite <> 'blog' OR (b2_.provenance_flux_actualite = 'blog' AND b2_.visibilite_flux LIKE '%collaborative%')) AND b2_.date_mise_en_ligne <= 20260407224048 ORDER BY b2_.date_mise_en_ligne DESC LIMIT 10;

SELECT
  v0_.id_valorisation AS id_valorisation_0,
  v1_.titre_valorisation AS titre_valorisation_1,
  v1_.ca_n_affichage AS ca_n_affichage_2,
  v1_.date_mois_operation AS date_mois_operation_3,
  v1_.societe_difficulte AS societe_difficulte_4,
  v1_.type_rachat AS type_rachat_5,
  v1_.type_acquereur AS type_acquereur_6,
  v1_.description_publique AS description_publique_7
FROM
  fusacq_dbo.valorisations_liens_annonces_vendeur v0_
  LEFT JOIN valorisations v1_ ON (
    v0_.id_valorisation = v1_.id_valorisation
  )
WHERE
  v0_.id_annonce = ?
  AND v1_.mode = 'publique'
ORDER BY
  v1_.date_mois_operation DESC
LIMIT
  10

SELECT v0_.id_valorisation AS id_valorisation_0, v1_.titre_valorisation AS titre_valorisation_1, v1_.ca_n_affichage AS ca_n_affichage_2, v1_.date_mois_operation AS date_mois_operation_3, v1_.societe_difficulte AS societe_difficulte_4, v1_.type_rachat AS type_rachat_5, v1_.type_acquereur AS type_acquereur_6, v1_.description_publique AS description_publique_7 FROM fusacq_dbo.valorisations_liens_annonces_vendeur v0_ LEFT JOIN valorisations v1_ ON (v0_.id_valorisation = v1_.id_valorisation) WHERE v0_.id_annonce = 17905 AND v1_.mode = 'publique' ORDER BY v1_.date_mois_operation DESC LIMIT 10;

SELECT
  DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.date_parution_initiale AS date_parution_initiale_2,
  a0_.date_parution AS date_parution_3,
  a0_.ca_max AS ca_max_4,
  a0_.apport_perso_repreneur AS apport_perso_repreneur_5,
  a0_.id_pays AS id_pays_6,
  a0_.id_region AS id_region_7,
  a0_.id_departement AS id_departement_8,
  a0_.autres_localisations AS autres_localisations_9,
  a0_.type_acquereur AS type_acquereur_10,
  a0_.id_langue AS id_langue_11,
  CASE WHEN (
    a0_.id_pays = ?
    AND (
      a0_.id_region = ''
      OR a0_.id_region IS NULL
      OR a0_.id_region = ?
    )
    AND (
      a0_.id_departement = ''
      OR a0_.id_departement IS NULL
    )
  )
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 4 WHEN (
    a0_.id_pays = ?
    AND (
      a0_.id_departement = ''
      OR a0_.id_departement IS NULL
    )
  )
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 3 WHEN a0_.id_pays = ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 2 ELSE 1 END AS sclr_12
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (
    a0_.type_raprochement = 'acquisition'
    OR a0_.type_raprochement IS NULL
  )
  AND (
    a0_.id_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )
ORDER BY
  sclr_12 DESC,
  a0_.ca_max DESC,
  a0_.id_annonce_acheteur DESC
LIMIT
  1 OFFSET 282

SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11, CASE WHEN (a0_.id_pays = 33 AND (a0_.id_region = '' OR a0_.id_region IS NULL OR a0_.id_region = '33_99') AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE 33 OR a0_.autres_localisations LIKE '33,%' OR a0_.autres_localisations LIKE '%,33,%' OR a0_.autres_localisations LIKE '%,33' THEN 4 WHEN (a0_.id_pays = 33 AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%' THEN 3 WHEN a0_.id_pays = 33 OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%' THEN 2 ELSE 1 END AS sclr_12 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL) AND (a0_.id_pays = 33 OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%') ORDER BY sclr_12 DESC, a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 1 OFFSET 282;

SELECT
  DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.date_parution_initiale AS date_parution_initiale_2,
  a0_.date_parution AS date_parution_3,
  a0_.ca_max AS ca_max_4,
  a0_.apport_perso_repreneur AS apport_perso_repreneur_5,
  a0_.id_pays AS id_pays_6,
  a0_.id_region AS id_region_7,
  a0_.id_departement AS id_departement_8,
  a0_.autres_localisations AS autres_localisations_9,
  a0_.type_acquereur AS type_acquereur_10,
  a0_.id_langue AS id_langue_11,
  CASE WHEN (
    a0_.id_pays = ?
    AND (
      a0_.id_region = ''
      OR a0_.id_region IS NULL
      OR a0_.id_region = ?
    )
    AND (
      a0_.id_departement = ''
      OR a0_.id_departement IS NULL
    )
  )
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 4 WHEN (
    a0_.id_pays = ?
    AND (
      a0_.id_departement = ''
      OR a0_.id_departement IS NULL
    )
  )
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 3 WHEN a0_.id_pays = ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 2 ELSE 1 END AS sclr_12
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (
    a0_.type_raprochement = 'acquisition'
    OR a0_.type_raprochement IS NULL
  )
  AND (
    a0_.id_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )
ORDER BY
  sclr_12 DESC,
  a0_.ca_max DESC,
  a0_.id_annonce_acheteur DESC
LIMIT
  1 OFFSET 284

SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11, CASE WHEN (a0_.id_pays = 33 AND (a0_.id_region = '' OR a0_.id_region IS NULL OR a0_.id_region = '33_99') AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE 33 OR a0_.autres_localisations LIKE '33,%' OR a0_.autres_localisations LIKE '%,33,%' OR a0_.autres_localisations LIKE '%,33' THEN 4 WHEN (a0_.id_pays = 33 AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%' THEN 3 WHEN a0_.id_pays = 33 OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%' THEN 2 ELSE 1 END AS sclr_12 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL) AND (a0_.id_pays = 33 OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%') ORDER BY sclr_12 DESC, a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 1 OFFSET 284;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = 60707 LIMIT 1;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '607' LIMIT 1;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '6' LIMIT 1;