| 1 |
10.70 ms |
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_.tpe_pme = 'oui' AND a0_.id_annonce_acheteur = 16989
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_.tpe_pme = 'oui'
AND a0_.id_annonce_acheteur = 16989
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_.tpe_pme = 'oui' AND a0_.id_annonce_acheteur = 16989;
|
| 2 |
11.07 ms |
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 = ?
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 = '87706' LIMIT 1;
|