Symfony Profiler

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_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_.login_utilisateur AS login_utilisateur_4,
  a0_.date_parution_elite AS date_parution_elite_5,
  a0_.ca_n AS ca_n_6,
  a0_.id_pays AS id_pays_7,
  a0_.id_region AS id_region_8,
  a0_.zone_geographique AS zone_geographique_9,
  a0_.id_departement AS id_departement_10,
  a0_.statuts AS statuts_11,
  a0_.id_secteur_activite AS id_secteur_activite_12,
  a0_.mode_annonce AS mode_annonce_13,
  a0_.id_raison_cession AS id_raison_cession_14,
  a0_.date_creation_societe AS date_creation_societe_15,
  a0_.type_cession AS type_cession_16,
  a0_.description_activite AS description_activite_17,
  a0_.possession_brevets AS possession_brevets_18,
  a0_.possession_marques AS possession_marques_19,
  a0_.travail_export AS travail_export_20,
  a0_.raison_cession AS raison_cession_21,
  a0_.annee_n AS annee_n_22,
  a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23,
  a0_.ca_nmoinsun AS ca_nmoinsun_24,
  a0_.ca_nplusun AS ca_nplusun_25,
  a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26,
  a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27,
  a0_.marge_brute_n AS marge_brute_n_28,
  a0_.marge_brute_nplusun AS marge_brute_nplusun_29,
  a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30,
  a0_.EBE_nmoinsun AS EBE_nmoinsun_31,
  a0_.EBE_n AS EBE_n_32,
  a0_.EBE_nplusun AS EBE_nplusun_33,
  a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34,
  a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35,
  a0_.resultat_exploitation_n AS resultat_exploitation_n_36,
  a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37,
  a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38,
  a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39,
  a0_.resultat_net_n AS resultat_net_n_40,
  a0_.resultat_net_nplusun AS resultat_net_nplusun_41,
  a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42,
  a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43,
  a0_.nb_personnes_n AS nb_personnes_n_44,
  a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45,
  a0_.fonds_propres AS fonds_propres_46,
  a0_.dettes_financieres AS dettes_financieres_47,
  a0_.tresorerie_nette AS tresorerie_nette_48,
  a0_.points_forts AS points_forts_49,
  a0_.points_faibles AS points_faibles_50,
  a0_.positionnement_marche AS positionnement_marche_51,
  a0_.concurrence AS concurrence_52,
  a0_.prix_cession AS prix_cession_53,
  a0_.redressement_judiciaire AS redressement_judiciaire_54,
  a0_.apport_fp_min AS apport_fp_min_55,
  a0_.recherche_active AS recherche_active_56,
  a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57,
  a0_.elements_complementaires AS elements_complementaires_58,
  a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59,
  a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60,
  a0_.nom_contact AS nom_contact_61,
  a0_.email AS email_62,
  a0_.telephone AS telephone_63,
  a0_.commentaires AS commentaires_64,
  a0_.endettement_net_n AS endettement_net_n_65,
  a0_.id_langue AS id_langue_66,
  a0_.indicatif_telephone AS indicatif_telephone_67,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_68
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_annonce_vendeur = 85880

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_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_.login_utilisateur AS login_utilisateur_4, a0_.date_parution_elite AS date_parution_elite_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12, a0_.mode_annonce AS mode_annonce_13, a0_.id_raison_cession AS id_raison_cession_14, a0_.date_creation_societe AS date_creation_societe_15, a0_.type_cession AS type_cession_16, a0_.description_activite AS description_activite_17, a0_.possession_brevets AS possession_brevets_18, a0_.possession_marques AS possession_marques_19, a0_.travail_export AS travail_export_20, a0_.raison_cession AS raison_cession_21, a0_.annee_n AS annee_n_22, a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23, a0_.ca_nmoinsun AS ca_nmoinsun_24, a0_.ca_nplusun AS ca_nplusun_25, a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26, a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27, a0_.marge_brute_n AS marge_brute_n_28, a0_.marge_brute_nplusun AS marge_brute_nplusun_29, a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30, a0_.EBE_nmoinsun AS EBE_nmoinsun_31, a0_.EBE_n AS EBE_n_32, a0_.EBE_nplusun AS EBE_nplusun_33, a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34, a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35, a0_.resultat_exploitation_n AS resultat_exploitation_n_36, a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37, a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38, a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39, a0_.resultat_net_n AS resultat_net_n_40, a0_.resultat_net_nplusun AS resultat_net_nplusun_41, a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42, a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43, a0_.nb_personnes_n AS nb_personnes_n_44, a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45, a0_.fonds_propres AS fonds_propres_46, a0_.dettes_financieres AS dettes_financieres_47, a0_.tresorerie_nette AS tresorerie_nette_48, a0_.points_forts AS points_forts_49, a0_.points_faibles AS points_faibles_50, a0_.positionnement_marche AS positionnement_marche_51, a0_.concurrence AS concurrence_52, a0_.prix_cession AS prix_cession_53, a0_.redressement_judiciaire AS redressement_judiciaire_54, a0_.apport_fp_min AS apport_fp_min_55, a0_.recherche_active AS recherche_active_56, a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57, a0_.elements_complementaires AS elements_complementaires_58, a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59, a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60, a0_.nom_contact AS nom_contact_61, a0_.email AS email_62, a0_.telephone AS telephone_63, a0_.commentaires AS commentaires_64, a0_.endettement_net_n AS endettement_net_n_65, a0_.id_langue AS id_langue_66, a0_.indicatif_telephone AS indicatif_telephone_67, a0_.date_fin_publique_elite AS date_fin_publique_elite_68 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_vendeur = 85880;

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_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_.login_utilisateur AS login_utilisateur_4,
  a0_.date_parution_elite AS date_parution_elite_5,
  a0_.ca_n AS ca_n_6,
  a0_.id_pays AS id_pays_7,
  a0_.id_region AS id_region_8,
  a0_.zone_geographique AS zone_geographique_9,
  a0_.id_departement AS id_departement_10,
  a0_.statuts AS statuts_11,
  a0_.id_secteur_activite AS id_secteur_activite_12,
  a0_.mode_annonce AS mode_annonce_13,
  a0_.id_raison_cession AS id_raison_cession_14,
  a0_.date_creation_societe AS date_creation_societe_15,
  a0_.type_cession AS type_cession_16,
  a0_.description_activite AS description_activite_17,
  a0_.possession_brevets AS possession_brevets_18,
  a0_.possession_marques AS possession_marques_19,
  a0_.travail_export AS travail_export_20,
  a0_.raison_cession AS raison_cession_21,
  a0_.annee_n AS annee_n_22,
  a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23,
  a0_.ca_nmoinsun AS ca_nmoinsun_24,
  a0_.ca_nplusun AS ca_nplusun_25,
  a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26,
  a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27,
  a0_.marge_brute_n AS marge_brute_n_28,
  a0_.marge_brute_nplusun AS marge_brute_nplusun_29,
  a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30,
  a0_.EBE_nmoinsun AS EBE_nmoinsun_31,
  a0_.EBE_n AS EBE_n_32,
  a0_.EBE_nplusun AS EBE_nplusun_33,
  a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34,
  a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35,
  a0_.resultat_exploitation_n AS resultat_exploitation_n_36,
  a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37,
  a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38,
  a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39,
  a0_.resultat_net_n AS resultat_net_n_40,
  a0_.resultat_net_nplusun AS resultat_net_nplusun_41,
  a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42,
  a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43,
  a0_.nb_personnes_n AS nb_personnes_n_44,
  a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45,
  a0_.fonds_propres AS fonds_propres_46,
  a0_.dettes_financieres AS dettes_financieres_47,
  a0_.tresorerie_nette AS tresorerie_nette_48,
  a0_.points_forts AS points_forts_49,
  a0_.points_faibles AS points_faibles_50,
  a0_.positionnement_marche AS positionnement_marche_51,
  a0_.concurrence AS concurrence_52,
  a0_.prix_cession AS prix_cession_53,
  a0_.redressement_judiciaire AS redressement_judiciaire_54,
  a0_.apport_fp_min AS apport_fp_min_55,
  a0_.recherche_active AS recherche_active_56,
  a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57,
  a0_.elements_complementaires AS elements_complementaires_58,
  a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59,
  a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60,
  a0_.nom_contact AS nom_contact_61,
  a0_.email AS email_62,
  a0_.telephone AS telephone_63,
  a0_.commentaires AS commentaires_64,
  a0_.endettement_net_n AS endettement_net_n_65,
  a0_.id_langue AS id_langue_66,
  a0_.indicatif_telephone AS indicatif_telephone_67,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_68
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_annonce_vendeur = 85880

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_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_.login_utilisateur AS login_utilisateur_4, a0_.date_parution_elite AS date_parution_elite_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12, a0_.mode_annonce AS mode_annonce_13, a0_.id_raison_cession AS id_raison_cession_14, a0_.date_creation_societe AS date_creation_societe_15, a0_.type_cession AS type_cession_16, a0_.description_activite AS description_activite_17, a0_.possession_brevets AS possession_brevets_18, a0_.possession_marques AS possession_marques_19, a0_.travail_export AS travail_export_20, a0_.raison_cession AS raison_cession_21, a0_.annee_n AS annee_n_22, a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23, a0_.ca_nmoinsun AS ca_nmoinsun_24, a0_.ca_nplusun AS ca_nplusun_25, a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26, a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27, a0_.marge_brute_n AS marge_brute_n_28, a0_.marge_brute_nplusun AS marge_brute_nplusun_29, a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30, a0_.EBE_nmoinsun AS EBE_nmoinsun_31, a0_.EBE_n AS EBE_n_32, a0_.EBE_nplusun AS EBE_nplusun_33, a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34, a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35, a0_.resultat_exploitation_n AS resultat_exploitation_n_36, a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37, a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38, a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39, a0_.resultat_net_n AS resultat_net_n_40, a0_.resultat_net_nplusun AS resultat_net_nplusun_41, a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42, a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43, a0_.nb_personnes_n AS nb_personnes_n_44, a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45, a0_.fonds_propres AS fonds_propres_46, a0_.dettes_financieres AS dettes_financieres_47, a0_.tresorerie_nette AS tresorerie_nette_48, a0_.points_forts AS points_forts_49, a0_.points_faibles AS points_faibles_50, a0_.positionnement_marche AS positionnement_marche_51, a0_.concurrence AS concurrence_52, a0_.prix_cession AS prix_cession_53, a0_.redressement_judiciaire AS redressement_judiciaire_54, a0_.apport_fp_min AS apport_fp_min_55, a0_.recherche_active AS recherche_active_56, a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57, a0_.elements_complementaires AS elements_complementaires_58, a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59, a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60, a0_.nom_contact AS nom_contact_61, a0_.email AS email_62, a0_.telephone AS telephone_63, a0_.commentaires AS commentaires_64, a0_.endettement_net_n AS endettement_net_n_65, a0_.id_langue AS id_langue_66, a0_.indicatif_telephone AS indicatif_telephone_67, a0_.date_fin_publique_elite AS date_fin_publique_elite_68 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_vendeur = 85880;

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 = 30201 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 = 30201 LIMIT 1;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 85880
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260319

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 85880 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260319;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 85880
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 85880 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise';

SELECT
  DISTINCT a0_.mode_annonce AS mode_annonce_0,
  a0_.id_annonce_vendeur AS id_annonce_vendeur_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_.date_parution_initiale_elite AS date_parution_initiale_elite_5,
  a0_.date_parution_elite AS date_parution_elite_6,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_7,
  a0_.ca_n AS ca_n_8,
  a0_.id_pays AS id_pays_9,
  a0_.id_region AS id_region_10,
  a0_.zone_geographique AS zone_geographique_11,
  a0_.id_departement AS id_departement_12,
  a0_.statuts AS statuts_13,
  a0_.id_langue AS id_langue_14,
  a0_.id_secteur_activite AS id_secteur_activite_15
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts NOT LIKE '99%'
ORDER BY
  a0_.date_parution_initiale_complete DESC,
  a0_.id_annonce_vendeur DESC
LIMIT
  1 OFFSET 1

SELECT DISTINCT a0_.mode_annonce AS mode_annonce_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_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_.date_parution_initiale_elite AS date_parution_initiale_elite_5, a0_.date_parution_elite AS date_parution_elite_6, a0_.date_fin_publique_elite AS date_fin_publique_elite_7, a0_.ca_n AS ca_n_8, a0_.id_pays AS id_pays_9, a0_.id_region AS id_region_10, a0_.zone_geographique AS zone_geographique_11, a0_.id_departement AS id_departement_12, a0_.statuts AS statuts_13, a0_.id_langue AS id_langue_14, a0_.id_secteur_activite AS id_secteur_activite_15 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' ORDER BY a0_.date_parution_initiale_complete DESC, a0_.id_annonce_vendeur DESC LIMIT 1 OFFSET 1;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 85880
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260319

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 85880 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260319;

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 = 85880 AND v1_.mode = 'publique' ORDER BY v1_.date_mois_operation DESC LIMIT 10;

SELECT
  d0_.id AS id_0,
  d0_.id_annonce AS id_annonce_1,
  d0_.date_envoi_deposant AS date_envoi_deposant_2,
  d0_.date_generation AS date_generation_3,
  d0_.synthese_strategique AS synthese_strategique_4,
  d0_.positionnement_marche AS positionnement_marche_5,
  d0_.valeur_clientele AS valeur_clientele_6,
  d0_.potentiel_developpement AS potentiel_developpement_7,
  d0_.repreneur_ideal AS repreneur_ideal_8,
  d0_.note AS note_9,
  d0_.commentaire AS commentaire_10,
  d0_.date_debut_consult_gratuite AS date_debut_consult_gratuite_11,
  d0_.date_fin_consult_gratuite AS date_fin_consult_gratuite_12,
  a1_.titre_annonce AS titre_annonce_13,
  a1_.id_annonce_vendeur AS id_annonce_vendeur_14
FROM
  fusacq_dbo.detail_annonce_synthese_strategique d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    a1_.id_annonce_vendeur = d0_.id_annonce
  )
WHERE
  d0_.id_annonce = ?
  AND d0_.date_envoi_deposant IS NOT NULL
ORDER BY
  d0_.date_envoi_deposant DESC,
  d0_.date_generation DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.id_annonce AS id_annonce_1, d0_.date_envoi_deposant AS date_envoi_deposant_2, d0_.date_generation AS date_generation_3, d0_.synthese_strategique AS synthese_strategique_4, d0_.positionnement_marche AS positionnement_marche_5, d0_.valeur_clientele AS valeur_clientele_6, d0_.potentiel_developpement AS potentiel_developpement_7, d0_.repreneur_ideal AS repreneur_ideal_8, d0_.note AS note_9, d0_.commentaire AS commentaire_10, d0_.date_debut_consult_gratuite AS date_debut_consult_gratuite_11, d0_.date_fin_consult_gratuite AS date_fin_consult_gratuite_12, a1_.titre_annonce AS titre_annonce_13, a1_.id_annonce_vendeur AS id_annonce_vendeur_14 FROM fusacq_dbo.detail_annonce_synthese_strategique d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (a1_.id_annonce_vendeur = d0_.id_annonce) WHERE d0_.id_annonce = 85880 AND d0_.date_envoi_deposant IS NOT NULL ORDER BY d0_.date_envoi_deposant DESC, d0_.date_generation DESC LIMIT 1;

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 = 'tarif_MER_type3_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_1' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_pack_mer_5_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_2' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_pack_mer_10_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_3' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_pack_mer_20_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_abo_annuel_1' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';