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 = 'amoursucrede47@gmail.com' AND c3_.tel = '+33618853113' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.tel AS tel_5,
  t0.address AS address_6,
  t0.zip_code AS zip_code_7,
  t0.city AS city_8,
  t0.proprietaire_id AS proprietaire_id_9,
  t0.vendeur_id AS vendeur_id_10
FROM
  contact t0
WHERE
  t0.email = ?
  AND t0.tel = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.tel AS tel_5, t0.address AS address_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.proprietaire_id AS proprietaire_id_9, t0.vendeur_id AS vendeur_id_10 FROM contact t0 WHERE t0.email = 'amoursucrede47@gmail.com' AND t0.tel = '+33618853113' 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 = '8519' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1
FROM
  equipe e0_
WHERE
  e0_.name LIKE ?
ORDER BY
  e0_.id DESC
LIMIT
  1

SELECT e0_.id AS id_0, e0_.name AS name_1 FROM equipe e0_ WHERE e0_.name LIKE '%Toulouse 1%' ORDER BY e0_.id DESC LIMIT 1;

INSERT INTO demande_logement (
  uuid, date_demande, source_prospect,
  date_entree_souhaitee, composition_familiale,
  nb_enfant, typologie_recherche,
  parking, balcon, budget_max, commentaire_demande,
  decision_demande, date_dernier_appel,
  nb_appel, secteur_recherche, creation_dossier,
  borne_electrique, id_access, ref_annonce_souhaitee,
  utm_form, utm_source, utm_medium,
  utm_campaign, utm_term, attribution,
  createur_demande_id, createur_prems_visite_id,
  user_dernier_appel_id, lot_id, mel_id,
  equipe_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO demande_logement (uuid, date_demande, source_prospect, date_entree_souhaitee, composition_familiale, nb_enfant, typologie_recherche, parking, balcon, budget_max, commentaire_demande, decision_demande, date_dernier_appel, nb_appel, secteur_recherche, creation_dossier, borne_electrique, id_access, ref_annonce_souhaitee, utm_form, utm_source, utm_medium, utm_campaign, utm_term, attribution, createur_demande_id, createur_prems_visite_id, user_dernier_appel_id, lot_id, mel_id, equipe_id) VALUES ('019c52f4-ff3f-7078-bc3c-48feff51702d', '2026-02-12 18:45:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5);

INSERT INTO demande_logement_candidat (
  demande_logement_id, candidat_id
)
VALUES
  (?, ?)

INSERT INTO demande_logement_candidat (demande_logement_id, candidat_id) VALUES (158007, 158007);

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 ('019c52f4-fd03-7371-a57a-962938d7639a', '', 'Emilie Ronne', 'amoursucrede47@gmail.com', '+33618853113', '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.', 'My Se Loger pro (SGL)', 'My Se Loger pro (SGL)', 'ApiLeadsBuy', '', '', 'Location Toulouse 1', '8519', NULL, '2026-02-12 18:45:13', 158007, NULL);

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO contact (
  first_name, last_name, email, tel,
  address, zip_code, city, proprietaire_id,
  vendeur_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO contact (first_name, last_name, email, tel, address, zip_code, city, proprietaire_id, vendeur_id) VALUES ('', 'Emilie Ronne', 'amoursucrede47@gmail.com', '+33618853113', NULL, NULL, 'TOULOUSE ', NULL, NULL);

INSERT INTO candidat (situation, garant, contact_id)
VALUES
  (?, ?, ?)

INSERT INTO candidat (situation, garant, contact_id) VALUES (NULL, NULL, 180424);

"COMMIT"

"COMMIT";