Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.rappelprive AS rappelprive_1,
  c0_.daterappel AS daterappel_2,
  c0_.historique AS historique_3,
  c0_.commentaire AS commentaire_4,
  c0_.traitementdate AS traitementdate_5,
  c0_.traitementencore AS traitementencore_6,
  c0_.campagne_id AS campagne_id_7,
  c0_.prospect_id AS prospect_id_8,
  c0_.utilisateur_id AS utilisateur_id_9,
  c0_.appelstatut_id AS appelstatut_id_10,
  c0_.traitementpar_id AS traitementpar_id_11
FROM
  campagneprospect c0_
WHERE
  c0_.rappelprive = ?
  AND DATE(c0_.daterappel) = ?

SELECT c0_.id AS id_0, c0_.rappelprive AS rappelprive_1, c0_.daterappel AS daterappel_2, c0_.historique AS historique_3, c0_.commentaire AS commentaire_4, c0_.traitementdate AS traitementdate_5, c0_.traitementencore AS traitementencore_6, c0_.campagne_id AS campagne_id_7, c0_.prospect_id AS prospect_id_8, c0_.utilisateur_id AS utilisateur_id_9, c0_.appelstatut_id AS appelstatut_id_10, c0_.traitementpar_id AS traitementpar_id_11 FROM campagneprospect c0_ WHERE c0_.rappelprive = 1 AND DATE(c0_.daterappel) = '2026-09-22';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.active AS active_6,
  t0.session_active AS session_active_7,
  t0.otp_secret AS otp_secret_8,
  t0.otp_enabled AS otp_enabled_9,
  t0.password_changed_at AS password_changed_at_10,
  t0.parametres AS parametres_11,
  t0.erreur AS erreur_12,
  t0.erreurdate AS erreurdate_13,
  t0.groupe_id AS groupe_id_14,
  t0.photo_id AS photo_id_15,
  t0.client_id AS client_id_16
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.otp_secret AS otp_secret_8, t0.otp_enabled AS otp_enabled_9, t0.password_changed_at AS password_changed_at_10, t0.parametres AS parametres_11, t0.erreur AS erreur_12, t0.erreurdate AS erreurdate_13, t0.groupe_id AS groupe_id_14, t0.photo_id AS photo_id_15, t0.client_id AS client_id_16 FROM utilisateur t0 WHERE t0.id = 56;

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.siren AS siren_3,
  t0.adresse AS adresse_4,
  t0.adressesuite AS adressesuite_5,
  t0.chiffre_affaire AS chiffre_affaire_6,
  t0.active AS active_7,
  t0.standard AS standard_8,
  t0.email AS email_9,
  t0.datecreation AS datecreation_10,
  t0.datemodification AS datemodification_11,
  t0.siteweb AS siteweb_12,
  t0.effectif AS effectif_13,
  t0.siret AS siret_14,
  t0.description AS description_15,
  t0.linkedin AS linkedin_16,
  t0.type_structure AS type_structure_17,
  t0.qualification_structure AS qualification_structure_18,
  t0.motif_qualification AS motif_qualification_19,
  t0.ville_id AS ville_id_20,
  t0.codenaf_id AS codenaf_id_21,
  t22.id AS id_23,
  t22.consultationderniere AS consultationderniere_24,
  t22.consultationprochaine AS consultationprochaine_25,
  t22.prestataire AS prestataire_26,
  t22.sitedecionnaire AS sitedecionnaire_27,
  t22.societedecisionnaire AS societedecisionnaire_28,
  t22.effectif2 AS effectif2_29,
  t22.description AS description_30,
  t22.segmentmarche_id AS segmentmarche_id_31,
  t22.prospect_id AS prospect_id_32,
  t22.politiquerenouvellement_id AS politiquerenouvellement_id_33,
  t34.id AS id_35,
  t34.siren_interroge AS siren_interroge_36,
  t34.nature_juridique AS nature_juridique_37,
  t34.activite_principale AS activite_principale_38,
  t34.est_administration AS est_administration_39,
  t34.convention_collective_renseignee AS convention_collective_renseignee_40,
  t34.liste_idcc AS liste_idcc_41,
  t34.liste_finess_juridique AS liste_finess_juridique_42,
  t34.egapro_renseignee AS egapro_renseignee_43,
  t34.est_achats_responsables AS est_achats_responsables_44,
  t34.est_alim_confiance AS est_alim_confiance_45,
  t34.est_association AS est_association_46,
  t34.est_avocat AS est_avocat_47,
  t34.est_bio AS est_bio_48,
  t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49,
  t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50,
  t34.est_ess AS est_ess_51,
  t34.est_finess AS est_finess_52,
  t34.est_organisme_formation AS est_organisme_formation_53,
  t34.est_qualiopi AS est_qualiopi_54,
  t34.liste_id_organisme_formation AS liste_id_organisme_formation_55,
  t34.est_rge AS est_rge_56,
  t34.est_siae AS est_siae_57,
  t34.est_societe_mission AS est_societe_mission_58,
  t34.est_uai AS est_uai_59,
  t34.est_patrimoine_vivant AS est_patrimoine_vivant_60,
  t34.bilan_ges_renseigne AS bilan_ges_renseigne_61,
  t34.identifiant_association AS identifiant_association_62,
  t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63,
  t34.type_siae AS type_siae_64,
  t34.date_synchronisation AS date_synchronisation_65,
  t34.date_derniere_tentative AS date_derniere_tentative_66,
  t34.prochaine_tentative AS prochaine_tentative_67,
  t34.statut_synchronisation AS statut_synchronisation_68,
  t34.nombre_tentatives AS nombre_tentatives_69,
  t34.code_erreur AS code_erreur_70,
  t34.message_erreur AS message_erreur_71,
  t34.source AS source_72,
  t34.date_mise_ajour_api AS date_mise_ajour_api_73,
  t34.prospect_id AS prospect_id_74
FROM
  prospect t0
  LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id
  LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.siren AS siren_3, t0.adresse AS adresse_4, t0.adressesuite AS adressesuite_5, t0.chiffre_affaire AS chiffre_affaire_6, t0.active AS active_7, t0.standard AS standard_8, t0.email AS email_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.siteweb AS siteweb_12, t0.effectif AS effectif_13, t0.siret AS siret_14, t0.description AS description_15, t0.linkedin AS linkedin_16, t0.type_structure AS type_structure_17, t0.qualification_structure AS qualification_structure_18, t0.motif_qualification AS motif_qualification_19, t0.ville_id AS ville_id_20, t0.codenaf_id AS codenaf_id_21, t22.id AS id_23, t22.consultationderniere AS consultationderniere_24, t22.consultationprochaine AS consultationprochaine_25, t22.prestataire AS prestataire_26, t22.sitedecionnaire AS sitedecionnaire_27, t22.societedecisionnaire AS societedecisionnaire_28, t22.effectif2 AS effectif2_29, t22.description AS description_30, t22.segmentmarche_id AS segmentmarche_id_31, t22.prospect_id AS prospect_id_32, t22.politiquerenouvellement_id AS politiquerenouvellement_id_33, t34.id AS id_35, t34.siren_interroge AS siren_interroge_36, t34.nature_juridique AS nature_juridique_37, t34.activite_principale AS activite_principale_38, t34.est_administration AS est_administration_39, t34.convention_collective_renseignee AS convention_collective_renseignee_40, t34.liste_idcc AS liste_idcc_41, t34.liste_finess_juridique AS liste_finess_juridique_42, t34.egapro_renseignee AS egapro_renseignee_43, t34.est_achats_responsables AS est_achats_responsables_44, t34.est_alim_confiance AS est_alim_confiance_45, t34.est_association AS est_association_46, t34.est_avocat AS est_avocat_47, t34.est_bio AS est_bio_48, t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49, t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50, t34.est_ess AS est_ess_51, t34.est_finess AS est_finess_52, t34.est_organisme_formation AS est_organisme_formation_53, t34.est_qualiopi AS est_qualiopi_54, t34.liste_id_organisme_formation AS liste_id_organisme_formation_55, t34.est_rge AS est_rge_56, t34.est_siae AS est_siae_57, t34.est_societe_mission AS est_societe_mission_58, t34.est_uai AS est_uai_59, t34.est_patrimoine_vivant AS est_patrimoine_vivant_60, t34.bilan_ges_renseigne AS bilan_ges_renseigne_61, t34.identifiant_association AS identifiant_association_62, t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63, t34.type_siae AS type_siae_64, t34.date_synchronisation AS date_synchronisation_65, t34.date_derniere_tentative AS date_derniere_tentative_66, t34.prochaine_tentative AS prochaine_tentative_67, t34.statut_synchronisation AS statut_synchronisation_68, t34.nombre_tentatives AS nombre_tentatives_69, t34.code_erreur AS code_erreur_70, t34.message_erreur AS message_erreur_71, t34.source AS source_72, t34.date_mise_ajour_api AS date_mise_ajour_api_73, t34.prospect_id AS prospect_id_74 FROM prospect t0 LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id WHERE t0.id = 20537;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.active AS active_4,
  t0.datecreation AS datecreation_5,
  t0.datedebut AS datedebut_6,
  t0.datefin AS datefin_7,
  t0.objectif AS objectif_8,
  t0.objectifagent AS objectifagent_9,
  t0.type AS type_10,
  t0.campagnecible AS campagnecible_11,
  t0.recuperer_tous_historique AS recuperer_tous_historique_12,
  t0.client_id AS client_id_13,
  t0.reponsable_id AS reponsable_id_14,
  t0.clientmanager_id AS clientmanager_id_15
FROM
  campagne t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.active AS active_4, t0.datecreation AS datecreation_5, t0.datedebut AS datedebut_6, t0.datefin AS datefin_7, t0.objectif AS objectif_8, t0.objectifagent AS objectifagent_9, t0.type AS type_10, t0.campagnecible AS campagnecible_11, t0.recuperer_tous_historique AS recuperer_tous_historique_12, t0.client_id AS client_id_13, t0.reponsable_id AS reponsable_id_14, t0.clientmanager_id AS clientmanager_id_15 FROM campagne t0 WHERE t0.id = 118;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.active AS active_3,
  t0.horscible AS horscible_4,
  t0.nrp AS nrp_5,
  t0.rdv AS rdv_6,
  t0.rappel AS rappel_7,
  t0.couleur AS couleur_8,
  t0.objectif AS objectif_9,
  t0.fichequalifie AS fichequalifie_10,
  t0.fichearequalifie AS fichearequalifie_11,
  t0.ordre_affichage AS ordre_affichage_12
FROM
  appelstatut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3, t0.horscible AS horscible_4, t0.nrp AS nrp_5, t0.rdv AS rdv_6, t0.rappel AS rappel_7, t0.couleur AS couleur_8, t0.objectif AS objectif_9, t0.fichequalifie AS fichequalifie_10, t0.fichearequalifie AS fichearequalifie_11, t0.ordre_affichage AS ordre_affichage_12 FROM appelstatut t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.siren AS siren_3,
  t0.adresse AS adresse_4,
  t0.adressesuite AS adressesuite_5,
  t0.chiffre_affaire AS chiffre_affaire_6,
  t0.active AS active_7,
  t0.standard AS standard_8,
  t0.email AS email_9,
  t0.datecreation AS datecreation_10,
  t0.datemodification AS datemodification_11,
  t0.siteweb AS siteweb_12,
  t0.effectif AS effectif_13,
  t0.siret AS siret_14,
  t0.description AS description_15,
  t0.linkedin AS linkedin_16,
  t0.type_structure AS type_structure_17,
  t0.qualification_structure AS qualification_structure_18,
  t0.motif_qualification AS motif_qualification_19,
  t0.ville_id AS ville_id_20,
  t0.codenaf_id AS codenaf_id_21,
  t22.id AS id_23,
  t22.consultationderniere AS consultationderniere_24,
  t22.consultationprochaine AS consultationprochaine_25,
  t22.prestataire AS prestataire_26,
  t22.sitedecionnaire AS sitedecionnaire_27,
  t22.societedecisionnaire AS societedecisionnaire_28,
  t22.effectif2 AS effectif2_29,
  t22.description AS description_30,
  t22.segmentmarche_id AS segmentmarche_id_31,
  t22.prospect_id AS prospect_id_32,
  t22.politiquerenouvellement_id AS politiquerenouvellement_id_33,
  t34.id AS id_35,
  t34.siren_interroge AS siren_interroge_36,
  t34.nature_juridique AS nature_juridique_37,
  t34.activite_principale AS activite_principale_38,
  t34.est_administration AS est_administration_39,
  t34.convention_collective_renseignee AS convention_collective_renseignee_40,
  t34.liste_idcc AS liste_idcc_41,
  t34.liste_finess_juridique AS liste_finess_juridique_42,
  t34.egapro_renseignee AS egapro_renseignee_43,
  t34.est_achats_responsables AS est_achats_responsables_44,
  t34.est_alim_confiance AS est_alim_confiance_45,
  t34.est_association AS est_association_46,
  t34.est_avocat AS est_avocat_47,
  t34.est_bio AS est_bio_48,
  t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49,
  t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50,
  t34.est_ess AS est_ess_51,
  t34.est_finess AS est_finess_52,
  t34.est_organisme_formation AS est_organisme_formation_53,
  t34.est_qualiopi AS est_qualiopi_54,
  t34.liste_id_organisme_formation AS liste_id_organisme_formation_55,
  t34.est_rge AS est_rge_56,
  t34.est_siae AS est_siae_57,
  t34.est_societe_mission AS est_societe_mission_58,
  t34.est_uai AS est_uai_59,
  t34.est_patrimoine_vivant AS est_patrimoine_vivant_60,
  t34.bilan_ges_renseigne AS bilan_ges_renseigne_61,
  t34.identifiant_association AS identifiant_association_62,
  t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63,
  t34.type_siae AS type_siae_64,
  t34.date_synchronisation AS date_synchronisation_65,
  t34.date_derniere_tentative AS date_derniere_tentative_66,
  t34.prochaine_tentative AS prochaine_tentative_67,
  t34.statut_synchronisation AS statut_synchronisation_68,
  t34.nombre_tentatives AS nombre_tentatives_69,
  t34.code_erreur AS code_erreur_70,
  t34.message_erreur AS message_erreur_71,
  t34.source AS source_72,
  t34.date_mise_ajour_api AS date_mise_ajour_api_73,
  t34.prospect_id AS prospect_id_74
FROM
  prospect t0
  LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id
  LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.siren AS siren_3, t0.adresse AS adresse_4, t0.adressesuite AS adressesuite_5, t0.chiffre_affaire AS chiffre_affaire_6, t0.active AS active_7, t0.standard AS standard_8, t0.email AS email_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.siteweb AS siteweb_12, t0.effectif AS effectif_13, t0.siret AS siret_14, t0.description AS description_15, t0.linkedin AS linkedin_16, t0.type_structure AS type_structure_17, t0.qualification_structure AS qualification_structure_18, t0.motif_qualification AS motif_qualification_19, t0.ville_id AS ville_id_20, t0.codenaf_id AS codenaf_id_21, t22.id AS id_23, t22.consultationderniere AS consultationderniere_24, t22.consultationprochaine AS consultationprochaine_25, t22.prestataire AS prestataire_26, t22.sitedecionnaire AS sitedecionnaire_27, t22.societedecisionnaire AS societedecisionnaire_28, t22.effectif2 AS effectif2_29, t22.description AS description_30, t22.segmentmarche_id AS segmentmarche_id_31, t22.prospect_id AS prospect_id_32, t22.politiquerenouvellement_id AS politiquerenouvellement_id_33, t34.id AS id_35, t34.siren_interroge AS siren_interroge_36, t34.nature_juridique AS nature_juridique_37, t34.activite_principale AS activite_principale_38, t34.est_administration AS est_administration_39, t34.convention_collective_renseignee AS convention_collective_renseignee_40, t34.liste_idcc AS liste_idcc_41, t34.liste_finess_juridique AS liste_finess_juridique_42, t34.egapro_renseignee AS egapro_renseignee_43, t34.est_achats_responsables AS est_achats_responsables_44, t34.est_alim_confiance AS est_alim_confiance_45, t34.est_association AS est_association_46, t34.est_avocat AS est_avocat_47, t34.est_bio AS est_bio_48, t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49, t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50, t34.est_ess AS est_ess_51, t34.est_finess AS est_finess_52, t34.est_organisme_formation AS est_organisme_formation_53, t34.est_qualiopi AS est_qualiopi_54, t34.liste_id_organisme_formation AS liste_id_organisme_formation_55, t34.est_rge AS est_rge_56, t34.est_siae AS est_siae_57, t34.est_societe_mission AS est_societe_mission_58, t34.est_uai AS est_uai_59, t34.est_patrimoine_vivant AS est_patrimoine_vivant_60, t34.bilan_ges_renseigne AS bilan_ges_renseigne_61, t34.identifiant_association AS identifiant_association_62, t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63, t34.type_siae AS type_siae_64, t34.date_synchronisation AS date_synchronisation_65, t34.date_derniere_tentative AS date_derniere_tentative_66, t34.prochaine_tentative AS prochaine_tentative_67, t34.statut_synchronisation AS statut_synchronisation_68, t34.nombre_tentatives AS nombre_tentatives_69, t34.code_erreur AS code_erreur_70, t34.message_erreur AS message_erreur_71, t34.source AS source_72, t34.date_mise_ajour_api AS date_mise_ajour_api_73, t34.prospect_id AS prospect_id_74 FROM prospect t0 LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id WHERE t0.id = 24621;

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.siren AS siren_3,
  t0.adresse AS adresse_4,
  t0.adressesuite AS adressesuite_5,
  t0.chiffre_affaire AS chiffre_affaire_6,
  t0.active AS active_7,
  t0.standard AS standard_8,
  t0.email AS email_9,
  t0.datecreation AS datecreation_10,
  t0.datemodification AS datemodification_11,
  t0.siteweb AS siteweb_12,
  t0.effectif AS effectif_13,
  t0.siret AS siret_14,
  t0.description AS description_15,
  t0.linkedin AS linkedin_16,
  t0.type_structure AS type_structure_17,
  t0.qualification_structure AS qualification_structure_18,
  t0.motif_qualification AS motif_qualification_19,
  t0.ville_id AS ville_id_20,
  t0.codenaf_id AS codenaf_id_21,
  t22.id AS id_23,
  t22.consultationderniere AS consultationderniere_24,
  t22.consultationprochaine AS consultationprochaine_25,
  t22.prestataire AS prestataire_26,
  t22.sitedecionnaire AS sitedecionnaire_27,
  t22.societedecisionnaire AS societedecisionnaire_28,
  t22.effectif2 AS effectif2_29,
  t22.description AS description_30,
  t22.segmentmarche_id AS segmentmarche_id_31,
  t22.prospect_id AS prospect_id_32,
  t22.politiquerenouvellement_id AS politiquerenouvellement_id_33,
  t34.id AS id_35,
  t34.siren_interroge AS siren_interroge_36,
  t34.nature_juridique AS nature_juridique_37,
  t34.activite_principale AS activite_principale_38,
  t34.est_administration AS est_administration_39,
  t34.convention_collective_renseignee AS convention_collective_renseignee_40,
  t34.liste_idcc AS liste_idcc_41,
  t34.liste_finess_juridique AS liste_finess_juridique_42,
  t34.egapro_renseignee AS egapro_renseignee_43,
  t34.est_achats_responsables AS est_achats_responsables_44,
  t34.est_alim_confiance AS est_alim_confiance_45,
  t34.est_association AS est_association_46,
  t34.est_avocat AS est_avocat_47,
  t34.est_bio AS est_bio_48,
  t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49,
  t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50,
  t34.est_ess AS est_ess_51,
  t34.est_finess AS est_finess_52,
  t34.est_organisme_formation AS est_organisme_formation_53,
  t34.est_qualiopi AS est_qualiopi_54,
  t34.liste_id_organisme_formation AS liste_id_organisme_formation_55,
  t34.est_rge AS est_rge_56,
  t34.est_siae AS est_siae_57,
  t34.est_societe_mission AS est_societe_mission_58,
  t34.est_uai AS est_uai_59,
  t34.est_patrimoine_vivant AS est_patrimoine_vivant_60,
  t34.bilan_ges_renseigne AS bilan_ges_renseigne_61,
  t34.identifiant_association AS identifiant_association_62,
  t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63,
  t34.type_siae AS type_siae_64,
  t34.date_synchronisation AS date_synchronisation_65,
  t34.date_derniere_tentative AS date_derniere_tentative_66,
  t34.prochaine_tentative AS prochaine_tentative_67,
  t34.statut_synchronisation AS statut_synchronisation_68,
  t34.nombre_tentatives AS nombre_tentatives_69,
  t34.code_erreur AS code_erreur_70,
  t34.message_erreur AS message_erreur_71,
  t34.source AS source_72,
  t34.date_mise_ajour_api AS date_mise_ajour_api_73,
  t34.prospect_id AS prospect_id_74
FROM
  prospect t0
  LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id
  LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.siren AS siren_3, t0.adresse AS adresse_4, t0.adressesuite AS adressesuite_5, t0.chiffre_affaire AS chiffre_affaire_6, t0.active AS active_7, t0.standard AS standard_8, t0.email AS email_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.siteweb AS siteweb_12, t0.effectif AS effectif_13, t0.siret AS siret_14, t0.description AS description_15, t0.linkedin AS linkedin_16, t0.type_structure AS type_structure_17, t0.qualification_structure AS qualification_structure_18, t0.motif_qualification AS motif_qualification_19, t0.ville_id AS ville_id_20, t0.codenaf_id AS codenaf_id_21, t22.id AS id_23, t22.consultationderniere AS consultationderniere_24, t22.consultationprochaine AS consultationprochaine_25, t22.prestataire AS prestataire_26, t22.sitedecionnaire AS sitedecionnaire_27, t22.societedecisionnaire AS societedecisionnaire_28, t22.effectif2 AS effectif2_29, t22.description AS description_30, t22.segmentmarche_id AS segmentmarche_id_31, t22.prospect_id AS prospect_id_32, t22.politiquerenouvellement_id AS politiquerenouvellement_id_33, t34.id AS id_35, t34.siren_interroge AS siren_interroge_36, t34.nature_juridique AS nature_juridique_37, t34.activite_principale AS activite_principale_38, t34.est_administration AS est_administration_39, t34.convention_collective_renseignee AS convention_collective_renseignee_40, t34.liste_idcc AS liste_idcc_41, t34.liste_finess_juridique AS liste_finess_juridique_42, t34.egapro_renseignee AS egapro_renseignee_43, t34.est_achats_responsables AS est_achats_responsables_44, t34.est_alim_confiance AS est_alim_confiance_45, t34.est_association AS est_association_46, t34.est_avocat AS est_avocat_47, t34.est_bio AS est_bio_48, t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49, t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50, t34.est_ess AS est_ess_51, t34.est_finess AS est_finess_52, t34.est_organisme_formation AS est_organisme_formation_53, t34.est_qualiopi AS est_qualiopi_54, t34.liste_id_organisme_formation AS liste_id_organisme_formation_55, t34.est_rge AS est_rge_56, t34.est_siae AS est_siae_57, t34.est_societe_mission AS est_societe_mission_58, t34.est_uai AS est_uai_59, t34.est_patrimoine_vivant AS est_patrimoine_vivant_60, t34.bilan_ges_renseigne AS bilan_ges_renseigne_61, t34.identifiant_association AS identifiant_association_62, t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63, t34.type_siae AS type_siae_64, t34.date_synchronisation AS date_synchronisation_65, t34.date_derniere_tentative AS date_derniere_tentative_66, t34.prochaine_tentative AS prochaine_tentative_67, t34.statut_synchronisation AS statut_synchronisation_68, t34.nombre_tentatives AS nombre_tentatives_69, t34.code_erreur AS code_erreur_70, t34.message_erreur AS message_erreur_71, t34.source AS source_72, t34.date_mise_ajour_api AS date_mise_ajour_api_73, t34.prospect_id AS prospect_id_74 FROM prospect t0 LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id WHERE t0.id = 24250;

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.siren AS siren_3,
  t0.adresse AS adresse_4,
  t0.adressesuite AS adressesuite_5,
  t0.chiffre_affaire AS chiffre_affaire_6,
  t0.active AS active_7,
  t0.standard AS standard_8,
  t0.email AS email_9,
  t0.datecreation AS datecreation_10,
  t0.datemodification AS datemodification_11,
  t0.siteweb AS siteweb_12,
  t0.effectif AS effectif_13,
  t0.siret AS siret_14,
  t0.description AS description_15,
  t0.linkedin AS linkedin_16,
  t0.type_structure AS type_structure_17,
  t0.qualification_structure AS qualification_structure_18,
  t0.motif_qualification AS motif_qualification_19,
  t0.ville_id AS ville_id_20,
  t0.codenaf_id AS codenaf_id_21,
  t22.id AS id_23,
  t22.consultationderniere AS consultationderniere_24,
  t22.consultationprochaine AS consultationprochaine_25,
  t22.prestataire AS prestataire_26,
  t22.sitedecionnaire AS sitedecionnaire_27,
  t22.societedecisionnaire AS societedecisionnaire_28,
  t22.effectif2 AS effectif2_29,
  t22.description AS description_30,
  t22.segmentmarche_id AS segmentmarche_id_31,
  t22.prospect_id AS prospect_id_32,
  t22.politiquerenouvellement_id AS politiquerenouvellement_id_33,
  t34.id AS id_35,
  t34.siren_interroge AS siren_interroge_36,
  t34.nature_juridique AS nature_juridique_37,
  t34.activite_principale AS activite_principale_38,
  t34.est_administration AS est_administration_39,
  t34.convention_collective_renseignee AS convention_collective_renseignee_40,
  t34.liste_idcc AS liste_idcc_41,
  t34.liste_finess_juridique AS liste_finess_juridique_42,
  t34.egapro_renseignee AS egapro_renseignee_43,
  t34.est_achats_responsables AS est_achats_responsables_44,
  t34.est_alim_confiance AS est_alim_confiance_45,
  t34.est_association AS est_association_46,
  t34.est_avocat AS est_avocat_47,
  t34.est_bio AS est_bio_48,
  t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49,
  t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50,
  t34.est_ess AS est_ess_51,
  t34.est_finess AS est_finess_52,
  t34.est_organisme_formation AS est_organisme_formation_53,
  t34.est_qualiopi AS est_qualiopi_54,
  t34.liste_id_organisme_formation AS liste_id_organisme_formation_55,
  t34.est_rge AS est_rge_56,
  t34.est_siae AS est_siae_57,
  t34.est_societe_mission AS est_societe_mission_58,
  t34.est_uai AS est_uai_59,
  t34.est_patrimoine_vivant AS est_patrimoine_vivant_60,
  t34.bilan_ges_renseigne AS bilan_ges_renseigne_61,
  t34.identifiant_association AS identifiant_association_62,
  t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63,
  t34.type_siae AS type_siae_64,
  t34.date_synchronisation AS date_synchronisation_65,
  t34.date_derniere_tentative AS date_derniere_tentative_66,
  t34.prochaine_tentative AS prochaine_tentative_67,
  t34.statut_synchronisation AS statut_synchronisation_68,
  t34.nombre_tentatives AS nombre_tentatives_69,
  t34.code_erreur AS code_erreur_70,
  t34.message_erreur AS message_erreur_71,
  t34.source AS source_72,
  t34.date_mise_ajour_api AS date_mise_ajour_api_73,
  t34.prospect_id AS prospect_id_74
FROM
  prospect t0
  LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id
  LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.siren AS siren_3, t0.adresse AS adresse_4, t0.adressesuite AS adressesuite_5, t0.chiffre_affaire AS chiffre_affaire_6, t0.active AS active_7, t0.standard AS standard_8, t0.email AS email_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.siteweb AS siteweb_12, t0.effectif AS effectif_13, t0.siret AS siret_14, t0.description AS description_15, t0.linkedin AS linkedin_16, t0.type_structure AS type_structure_17, t0.qualification_structure AS qualification_structure_18, t0.motif_qualification AS motif_qualification_19, t0.ville_id AS ville_id_20, t0.codenaf_id AS codenaf_id_21, t22.id AS id_23, t22.consultationderniere AS consultationderniere_24, t22.consultationprochaine AS consultationprochaine_25, t22.prestataire AS prestataire_26, t22.sitedecionnaire AS sitedecionnaire_27, t22.societedecisionnaire AS societedecisionnaire_28, t22.effectif2 AS effectif2_29, t22.description AS description_30, t22.segmentmarche_id AS segmentmarche_id_31, t22.prospect_id AS prospect_id_32, t22.politiquerenouvellement_id AS politiquerenouvellement_id_33, t34.id AS id_35, t34.siren_interroge AS siren_interroge_36, t34.nature_juridique AS nature_juridique_37, t34.activite_principale AS activite_principale_38, t34.est_administration AS est_administration_39, t34.convention_collective_renseignee AS convention_collective_renseignee_40, t34.liste_idcc AS liste_idcc_41, t34.liste_finess_juridique AS liste_finess_juridique_42, t34.egapro_renseignee AS egapro_renseignee_43, t34.est_achats_responsables AS est_achats_responsables_44, t34.est_alim_confiance AS est_alim_confiance_45, t34.est_association AS est_association_46, t34.est_avocat AS est_avocat_47, t34.est_bio AS est_bio_48, t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49, t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50, t34.est_ess AS est_ess_51, t34.est_finess AS est_finess_52, t34.est_organisme_formation AS est_organisme_formation_53, t34.est_qualiopi AS est_qualiopi_54, t34.liste_id_organisme_formation AS liste_id_organisme_formation_55, t34.est_rge AS est_rge_56, t34.est_siae AS est_siae_57, t34.est_societe_mission AS est_societe_mission_58, t34.est_uai AS est_uai_59, t34.est_patrimoine_vivant AS est_patrimoine_vivant_60, t34.bilan_ges_renseigne AS bilan_ges_renseigne_61, t34.identifiant_association AS identifiant_association_62, t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63, t34.type_siae AS type_siae_64, t34.date_synchronisation AS date_synchronisation_65, t34.date_derniere_tentative AS date_derniere_tentative_66, t34.prochaine_tentative AS prochaine_tentative_67, t34.statut_synchronisation AS statut_synchronisation_68, t34.nombre_tentatives AS nombre_tentatives_69, t34.code_erreur AS code_erreur_70, t34.message_erreur AS message_erreur_71, t34.source AS source_72, t34.date_mise_ajour_api AS date_mise_ajour_api_73, t34.prospect_id AS prospect_id_74 FROM prospect t0 LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id WHERE t0.id = 15466;

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.siren AS siren_3,
  t0.adresse AS adresse_4,
  t0.adressesuite AS adressesuite_5,
  t0.chiffre_affaire AS chiffre_affaire_6,
  t0.active AS active_7,
  t0.standard AS standard_8,
  t0.email AS email_9,
  t0.datecreation AS datecreation_10,
  t0.datemodification AS datemodification_11,
  t0.siteweb AS siteweb_12,
  t0.effectif AS effectif_13,
  t0.siret AS siret_14,
  t0.description AS description_15,
  t0.linkedin AS linkedin_16,
  t0.type_structure AS type_structure_17,
  t0.qualification_structure AS qualification_structure_18,
  t0.motif_qualification AS motif_qualification_19,
  t0.ville_id AS ville_id_20,
  t0.codenaf_id AS codenaf_id_21,
  t22.id AS id_23,
  t22.consultationderniere AS consultationderniere_24,
  t22.consultationprochaine AS consultationprochaine_25,
  t22.prestataire AS prestataire_26,
  t22.sitedecionnaire AS sitedecionnaire_27,
  t22.societedecisionnaire AS societedecisionnaire_28,
  t22.effectif2 AS effectif2_29,
  t22.description AS description_30,
  t22.segmentmarche_id AS segmentmarche_id_31,
  t22.prospect_id AS prospect_id_32,
  t22.politiquerenouvellement_id AS politiquerenouvellement_id_33,
  t34.id AS id_35,
  t34.siren_interroge AS siren_interroge_36,
  t34.nature_juridique AS nature_juridique_37,
  t34.activite_principale AS activite_principale_38,
  t34.est_administration AS est_administration_39,
  t34.convention_collective_renseignee AS convention_collective_renseignee_40,
  t34.liste_idcc AS liste_idcc_41,
  t34.liste_finess_juridique AS liste_finess_juridique_42,
  t34.egapro_renseignee AS egapro_renseignee_43,
  t34.est_achats_responsables AS est_achats_responsables_44,
  t34.est_alim_confiance AS est_alim_confiance_45,
  t34.est_association AS est_association_46,
  t34.est_avocat AS est_avocat_47,
  t34.est_bio AS est_bio_48,
  t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49,
  t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50,
  t34.est_ess AS est_ess_51,
  t34.est_finess AS est_finess_52,
  t34.est_organisme_formation AS est_organisme_formation_53,
  t34.est_qualiopi AS est_qualiopi_54,
  t34.liste_id_organisme_formation AS liste_id_organisme_formation_55,
  t34.est_rge AS est_rge_56,
  t34.est_siae AS est_siae_57,
  t34.est_societe_mission AS est_societe_mission_58,
  t34.est_uai AS est_uai_59,
  t34.est_patrimoine_vivant AS est_patrimoine_vivant_60,
  t34.bilan_ges_renseigne AS bilan_ges_renseigne_61,
  t34.identifiant_association AS identifiant_association_62,
  t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63,
  t34.type_siae AS type_siae_64,
  t34.date_synchronisation AS date_synchronisation_65,
  t34.date_derniere_tentative AS date_derniere_tentative_66,
  t34.prochaine_tentative AS prochaine_tentative_67,
  t34.statut_synchronisation AS statut_synchronisation_68,
  t34.nombre_tentatives AS nombre_tentatives_69,
  t34.code_erreur AS code_erreur_70,
  t34.message_erreur AS message_erreur_71,
  t34.source AS source_72,
  t34.date_mise_ajour_api AS date_mise_ajour_api_73,
  t34.prospect_id AS prospect_id_74
FROM
  prospect t0
  LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id
  LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id
WHERE
  t0.id = ?