Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.uuid AS uuid_1,
  d0_.date_demande AS date_demande_2,
  d0_.source_prospect AS source_prospect_3,
  d0_.date_entree_souhaitee AS date_entree_souhaitee_4,
  d0_.composition_familiale AS composition_familiale_5,
  d0_.nb_enfant AS nb_enfant_6,
  d0_.typologie_recherche AS typologie_recherche_7,
  d0_.parking AS parking_8,
  d0_.balcon AS balcon_9,
  d0_.budget_max AS budget_max_10,
  d0_.commentaire_demande AS commentaire_demande_11,
  d0_.decision_demande AS decision_demande_12,
  d0_.date_dernier_appel AS date_dernier_appel_13,
  d0_.nb_appel AS nb_appel_14,
  d0_.secteur_recherche AS secteur_recherche_15,
  d0_.creation_dossier AS creation_dossier_16,
  d0_.borne_electrique AS borne_electrique_17,
  d0_.id_access AS id_access_18,
  d0_.ref_annonce_souhaitee AS ref_annonce_souhaitee_19,
  d0_.utm_form AS utm_form_20,
  d0_.utm_source AS utm_source_21,
  d0_.utm_medium AS utm_medium_22,
  d0_.utm_campaign AS utm_campaign_23,
  d0_.utm_term AS utm_term_24,
  d0_.attribution AS attribution_25,
  d0_.createur_demande_id AS createur_demande_id_26,
  d0_.createur_prems_visite_id AS createur_prems_visite_id_27,
  d0_.user_dernier_appel_id AS user_dernier_appel_id_28,
  d0_.lot_id AS lot_id_29,
  d0_.mel_id AS mel_id_30,
  d0_.equipe_id AS equipe_id_31
FROM
  demande_logement d0_
  INNER JOIN demande_logement_candidat d2_ ON d0_.id = d2_.demande_logement_id
  INNER JOIN candidat c1_ ON c1_.id = d2_.candidat_id
  INNER JOIN contact c3_ ON c1_.contact_id = c3_.id
WHERE
  d0_.decision_demande IS NULL
  AND c3_.email = ?
  AND c3_.tel = ?
LIMIT
  1

SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.date_demande AS date_demande_2, d0_.source_prospect AS source_prospect_3, d0_.date_entree_souhaitee AS date_entree_souhaitee_4, d0_.composition_familiale AS composition_familiale_5, d0_.nb_enfant AS nb_enfant_6, d0_.typologie_recherche AS typologie_recherche_7, d0_.parking AS parking_8, d0_.balcon AS balcon_9, d0_.budget_max AS budget_max_10, d0_.commentaire_demande AS commentaire_demande_11, d0_.decision_demande AS decision_demande_12, d0_.date_dernier_appel AS date_dernier_appel_13, d0_.nb_appel AS nb_appel_14, d0_.secteur_recherche AS secteur_recherche_15, d0_.creation_dossier AS creation_dossier_16, d0_.borne_electrique AS borne_electrique_17, d0_.id_access AS id_access_18, d0_.ref_annonce_souhaitee AS ref_annonce_souhaitee_19, d0_.utm_form AS utm_form_20, d0_.utm_source AS utm_source_21, d0_.utm_medium AS utm_medium_22, d0_.utm_campaign AS utm_campaign_23, d0_.utm_term AS utm_term_24, d0_.attribution AS attribution_25, d0_.createur_demande_id AS createur_demande_id_26, d0_.createur_prems_visite_id AS createur_prems_visite_id_27, d0_.user_dernier_appel_id AS user_dernier_appel_id_28, d0_.lot_id AS lot_id_29, d0_.mel_id AS mel_id_30, d0_.equipe_id AS equipe_id_31 FROM demande_logement d0_ INNER JOIN demande_logement_candidat d2_ ON d0_.id = d2_.demande_logement_id INNER JOIN candidat c1_ ON c1_.id = d2_.candidat_id INNER JOIN contact c3_ ON c1_.contact_id = c3_.id WHERE d0_.decision_demande IS NULL AND c3_.email = 'alhassanediaby85@gmail.com' AND c3_.tel = '+330781987548' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_mel AS date_mel_2,
  t0.ref_annonce AS ref_annonce_3,
  t0.estimation_locative AS estimation_locative_4,
  t0.reduire_frais_agence_loc AS reduire_frais_agence_loc_5,
  t0.reduire_frais_agence_prop AS reduire_frais_agence_prop_6,
  t0.creation_annonce AS creation_annonce_7,
  t0.raison_edls AS raison_edls_8,
  t0.sortir_avant AS sortir_avant_9,
  t0.proposer_autre_logement AS proposer_autre_logement_10,
  t0.etat_lot AS etat_lot_11,
  t0.video_bien AS video_bien_12,
  t0.suivi_photo AS suivi_photo_13,
  t0.visite_dossier_loc AS visite_dossier_loc_14,
  t0.edle_loc AS edle_loc_15,
  t0.frais_acte_loc AS frais_acte_loc_16,
  t0.visite_dossier_prop AS visite_dossier_prop_17,
  t0.edle_prop AS edle_prop_18,
  t0.frais_acte_prop AS frais_acte_prop_19,
  t0.total_delegataire AS total_delegataire_20,
  t0.total_location AS total_location_21,
  t0.plafond_alur_ttc AS plafond_alur_ttc_22,
  t0.lot_visite_dossier_loc AS lot_visite_dossier_loc_23,
  t0.lot_visite_dossier_prop AS lot_visite_dossier_prop_24,
  t0.pk_visite_dossier_loc AS pk_visite_dossier_loc_25,
  t0.pk_visite_dossier_prop AS pk_visite_dossier_prop_26,
  t0.loyer_hcmel AS loyer_hcmel_27,
  t0.charges_mel AS charges_mel_28,
  t0.locataire_injoignable AS locataire_injoignable_29,
  t0.id_access AS id_access_30,
  t0.date_dispo AS date_dispo_31,
  t0.date_edle AS date_edle_32,
  t0.date_edls AS date_edls_33,
  t0.commentaire AS commentaire_34,
  t0.suivi_evolution_loyer AS suivi_evolution_loyer_35,
  t0.suivi_evolution_frais_agence AS suivi_evolution_frais_agence_36,
  t0.disponibilite_loc AS disponibilite_loc_37,
  t0.sous_total_loc AS sous_total_loc_38,
  t0.sous_total_prop AS sous_total_prop_39,
  t0.total_loc AS total_loc_40,
  t0.total_prop AS total_prop_41,
  t0.total_mel AS total_mel_42,
  t0.loyer_ccmel AS loyer_ccmel_43,
  t0.cumul_esl AS cumul_esl_44,
  t0.exclusion_esl AS exclusion_esl_45,
  t0.fin_bail_sortant_at AS fin_bail_sortant_at_46,
  t0.dernier_loyer_hc AS dernier_loyer_hc_47,
  t0.last_ind_end_at AS last_ind_end_at_48,
  t0.mandat_gestion_id AS mandat_gestion_id_49,
  t0.commercial_id AS commercial_id_50,
  t0.chambre_id AS chambre_id_51
FROM
  mise_en_location t0
WHERE
  t0.ref_annonce = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_mel AS date_mel_2, t0.ref_annonce AS ref_annonce_3, t0.estimation_locative AS estimation_locative_4, t0.reduire_frais_agence_loc AS reduire_frais_agence_loc_5, t0.reduire_frais_agence_prop AS reduire_frais_agence_prop_6, t0.creation_annonce AS creation_annonce_7, t0.raison_edls AS raison_edls_8, t0.sortir_avant AS sortir_avant_9, t0.proposer_autre_logement AS proposer_autre_logement_10, t0.etat_lot AS etat_lot_11, t0.video_bien AS video_bien_12, t0.suivi_photo AS suivi_photo_13, t0.visite_dossier_loc AS visite_dossier_loc_14, t0.edle_loc AS edle_loc_15, t0.frais_acte_loc AS frais_acte_loc_16, t0.visite_dossier_prop AS visite_dossier_prop_17, t0.edle_prop AS edle_prop_18, t0.frais_acte_prop AS frais_acte_prop_19, t0.total_delegataire AS total_delegataire_20, t0.total_location AS total_location_21, t0.plafond_alur_ttc AS plafond_alur_ttc_22, t0.lot_visite_dossier_loc AS lot_visite_dossier_loc_23, t0.lot_visite_dossier_prop AS lot_visite_dossier_prop_24, t0.pk_visite_dossier_loc AS pk_visite_dossier_loc_25, t0.pk_visite_dossier_prop AS pk_visite_dossier_prop_26, t0.loyer_hcmel AS loyer_hcmel_27, t0.charges_mel AS charges_mel_28, t0.locataire_injoignable AS locataire_injoignable_29, t0.id_access AS id_access_30, t0.date_dispo AS date_dispo_31, t0.date_edle AS date_edle_32, t0.date_edls AS date_edls_33, t0.commentaire AS commentaire_34, t0.suivi_evolution_loyer AS suivi_evolution_loyer_35, t0.suivi_evolution_frais_agence AS suivi_evolution_frais_agence_36, t0.disponibilite_loc AS disponibilite_loc_37, t0.sous_total_loc AS sous_total_loc_38, t0.sous_total_prop AS sous_total_prop_39, t0.total_loc AS total_loc_40, t0.total_prop AS total_prop_41, t0.total_mel AS total_mel_42, t0.loyer_ccmel AS loyer_ccmel_43, t0.cumul_esl AS cumul_esl_44, t0.exclusion_esl AS exclusion_esl_45, t0.fin_bail_sortant_at AS fin_bail_sortant_at_46, t0.dernier_loyer_hc AS dernier_loyer_hc_47, t0.last_ind_end_at AS last_ind_end_at_48, t0.mandat_gestion_id AS mandat_gestion_id_49, t0.commercial_id AS commercial_id_50, t0.chambre_id AS chambre_id_51 FROM mise_en_location t0 WHERE t0.ref_annonce = '8704' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO lead_location (
  uuid, first_name, last_name, email,
  tel, city, source_prospect, commentaire_demande,
  utm_form, utm_source, utm_medium,
  utm_campaign, utm_term, attribution,
  ref_annonce, lien_annonce, created_at,
  demande_logement_id, mise_en_location_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO lead_location (uuid, first_name, last_name, email, tel, city, source_prospect, commentaire_demande, utm_form, utm_source, utm_medium, utm_campaign, utm_term, attribution, ref_annonce, lien_annonce, created_at, demande_logement_id, mise_en_location_id) VALUES ('019c5362-d8c9-7344-b7e5-5af5bf9d52a6', '', 'Benjamin Cisse', 'alhassanediaby85@gmail.com', '+330781987548', 'TOULOUSE ', 'My Se Loger pro (SGL)', 'Je suis intéressé par votre offre et souhaite organiser un rendez-vous de visite. Merci de bien vouloir me contacter. Je cherche urgemment un T2 avec un
 salaire net 2100€ par mois', 'My Se Loger pro (SGL)', 'My Se Loger pro (SGL)', 'ApiLeadsBuy', '', '', 'Location Toulouse 1', '8704', NULL, '2026-02-12 20:45:12', 157839, NULL);

"COMMIT"

"COMMIT";