Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.dateheure AS dateheure_2,
  t0.date_derniere_modification AS date_derniere_modification_3,
  t0.apporteur AS apporteur_4,
  t0.societe AS societe_5,
  t0.emprunteur_nom AS emprunteur_nom_6,
  t0.emprunteur_prenom AS emprunteur_prenom_7,
  t0.emprunteur_date_naissance AS emprunteur_date_naissance_8,
  t0.emprunteur_adresse AS emprunteur_adresse_9,
  t0.emprunteur_tel_fr AS emprunteur_tel_fr_10,
  t0.emprunteur_tel_ch AS emprunteur_tel_ch_11,
  t0.emprunteur_email AS emprunteur_email_12,
  t0.emprunteur_lieu_travail AS emprunteur_lieu_travail_13,
  t0.co_emprunteur_nom AS co_emprunteur_nom_14,
  t0.co_emprunteur_prenom AS co_emprunteur_prenom_15,
  t0.co_emprunteur_date_naissance AS co_emprunteur_date_naissance_16,
  t0.co_emprunteur_adresse AS co_emprunteur_adresse_17,
  t0.co_emprunteur_tel_fr AS co_emprunteur_tel_fr_18,
  t0.co_emprunteur_tel_ch AS co_emprunteur_tel_ch_19,
  t0.co_emprunteur_email AS co_emprunteur_email_20,
  t0.co_emprunteur_lieu_travail AS co_emprunteur_lieu_travail_21,
  t0.is_rp AS is_rp_22,
  t0.is_locatif AS is_locatif_23,
  t0.is_terrain AS is_terrain_24,
  t0.is_construction AS is_construction_25,
  t0.is_lmnp AS is_lmnp_26,
  t0.budget_approximatif AS budget_approximatif_27,
  t0.mensualite_souhaitee AS mensualite_souhaitee_28,
  t0.description_projet_global AS description_projet_global_29,
  t0.rdv_date_heure1 AS rdv_date_heure1_30,
  t0.rdv_date_heure2 AS rdv_date_heure2_31,
  t0.rdv_dateheure3 AS rdv_dateheure3_32,
  t0.rdv_date_heure4 AS rdv_date_heure4_33,
  t0.rdv_date_heure5 AS rdv_date_heure5_34,
  t0.rdv_date_heure6 AS rdv_date_heure6_35,
  t0.description_denonciations AS description_denonciations_36,
  t0.description_secteur AS description_secteur_37,
  t0.description_criteres_particuliers AS description_criteres_particuliers_38,
  t0.description_criteres_generaux AS description_criteres_generaux_39,
  t0.description_situation_actuelle AS description_situation_actuelle_40,
  t0.description_programmes_proposes AS description_programmes_proposes_41,
  t0.emprunteur_ville AS emprunteur_ville_42,
  t0.emprunteur_code_postal AS emprunteur_code_postal_43,
  t0.coemprunteur_ville AS coemprunteur_ville_44,
  t0.coemprunteur_code_postal AS coemprunteur_code_postal_45,
  t0.token AS token_46,
  t0.type AS type_47,
  t0.statut AS statut_48,
  t0.afficher_nom_co_emprunteur AS afficher_nom_co_emprunteur_49,
  t0.afficher_nom_emprunteur AS afficher_nom_emprunteur_50,
  t0.auteur_id AS auteur_id_51,
  t0.entreprise_id AS entreprise_id_52
FROM
  prospect t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.dateheure AS dateheure_2, t0.date_derniere_modification AS date_derniere_modification_3, t0.apporteur AS apporteur_4, t0.societe AS societe_5, t0.emprunteur_nom AS emprunteur_nom_6, t0.emprunteur_prenom AS emprunteur_prenom_7, t0.emprunteur_date_naissance AS emprunteur_date_naissance_8, t0.emprunteur_adresse AS emprunteur_adresse_9, t0.emprunteur_tel_fr AS emprunteur_tel_fr_10, t0.emprunteur_tel_ch AS emprunteur_tel_ch_11, t0.emprunteur_email AS emprunteur_email_12, t0.emprunteur_lieu_travail AS emprunteur_lieu_travail_13, t0.co_emprunteur_nom AS co_emprunteur_nom_14, t0.co_emprunteur_prenom AS co_emprunteur_prenom_15, t0.co_emprunteur_date_naissance AS co_emprunteur_date_naissance_16, t0.co_emprunteur_adresse AS co_emprunteur_adresse_17, t0.co_emprunteur_tel_fr AS co_emprunteur_tel_fr_18, t0.co_emprunteur_tel_ch AS co_emprunteur_tel_ch_19, t0.co_emprunteur_email AS co_emprunteur_email_20, t0.co_emprunteur_lieu_travail AS co_emprunteur_lieu_travail_21, t0.is_rp AS is_rp_22, t0.is_locatif AS is_locatif_23, t0.is_terrain AS is_terrain_24, t0.is_construction AS is_construction_25, t0.is_lmnp AS is_lmnp_26, t0.budget_approximatif AS budget_approximatif_27, t0.mensualite_souhaitee AS mensualite_souhaitee_28, t0.description_projet_global AS description_projet_global_29, t0.rdv_date_heure1 AS rdv_date_heure1_30, t0.rdv_date_heure2 AS rdv_date_heure2_31, t0.rdv_dateheure3 AS rdv_dateheure3_32, t0.rdv_date_heure4 AS rdv_date_heure4_33, t0.rdv_date_heure5 AS rdv_date_heure5_34, t0.rdv_date_heure6 AS rdv_date_heure6_35, t0.description_denonciations AS description_denonciations_36, t0.description_secteur AS description_secteur_37, t0.description_criteres_particuliers AS description_criteres_particuliers_38, t0.description_criteres_generaux AS description_criteres_generaux_39, t0.description_situation_actuelle AS description_situation_actuelle_40, t0.description_programmes_proposes AS description_programmes_proposes_41, t0.emprunteur_ville AS emprunteur_ville_42, t0.emprunteur_code_postal AS emprunteur_code_postal_43, t0.coemprunteur_ville AS coemprunteur_ville_44, t0.coemprunteur_code_postal AS coemprunteur_code_postal_45, t0.token AS token_46, t0.type AS type_47, t0.statut AS statut_48, t0.afficher_nom_co_emprunteur AS afficher_nom_co_emprunteur_49, t0.afficher_nom_emprunteur AS afficher_nom_emprunteur_50, t0.auteur_id AS auteur_id_51, t0.entreprise_id AS entreprise_id_52 FROM prospect t0 WHERE t0.token = '5x08o2' LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.notification AS notification_4,
  u0_.hide_account AS hide_account_5,
  u0_.hide_entreprise AS hide_entreprise_6,
  u0_.all_programmes AS all_programmes_7,
  u0_.couleur AS couleur_8,
  u0_.telephone AS telephone_9,
  u0_.nom AS nom_10,
  u0_.prenom AS prenom_11,
  u0_.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_12,
  u0_.peut_modifier AS peut_modifier_13,
  u0_.entreprise_id AS entreprise_id_14
FROM
  utilisateur u0_
WHERE
  u0_.email LIKE ?
  AND u0_.notification = 1

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.notification AS notification_4, u0_.hide_account AS hide_account_5, u0_.hide_entreprise AS hide_entreprise_6, u0_.all_programmes AS all_programmes_7, u0_.couleur AS couleur_8, u0_.telephone AS telephone_9, u0_.nom AS nom_10, u0_.prenom AS prenom_11, u0_.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_12, u0_.peut_modifier AS peut_modifier_13, u0_.entreprise_id AS entreprise_id_14 FROM utilisateur u0_ WHERE u0_.email LIKE 'killian@genesii.fr' AND u0_.notification = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO infos_suivi (
  type, description, date, lu, utilisateur_id,
  auteur_id, connected_user_id, historique_id,
  programme_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO infos_suivi (type, description, date, lu, utilisateur_id, auteur_id, connected_user_id, historique_id, programme_id) VALUES ('visite', '[prospect] a [visite] son espace public.', '2025-08-27 23:01:39', 0, 12, NULL, NULL, 1178, NULL);

"COMMIT"

"COMMIT";

INSERT INTO visite (datevisite, historique_id)
VALUES
  (?, ?)

INSERT INTO visite (datevisite, historique_id) VALUES ('2025-08-27 23:01:39', 1178);

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.type AS type_3,
  t0.adresse AS adresse_4,
  t0.ville AS ville_5,
  t0.code_postal AS code_postal_6,
  t0.prix AS prix_7,
  t0.date_livraison AS date_livraison_8,
  t0.titre AS titre_9,
  t0.description AS description_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.etage AS etage_13,
  t0.superficie AS superficie_14,
  t0.terrasse AS terrasse_15,
  t0.orientation AS orientation_16,
  t0.annexes AS annexes_17,
  t0.livraison AS livraison_18,
  t0.promoteur AS promoteur_19,
  t0.programme AS programme_20,
  t0.image AS image_21,
  t0.jardin AS jardin_22,
  t0.terrasse2 AS terrasse2_23,
  t0.frais_notaire_type AS frais_notaire_type_24,
  t0.frais_notaire_inclus AS frais_notaire_inclus_25,
  t0.brochure AS brochure_26,
  t0.plan_masse AS plan_masse_27,
  t0.statut AS statut_28,
  t0.nature AS nature_29,
  t0.type_moteur_recherche AS type_moteur_recherche_30,
  t0.etage_moteur_recherche AS etage_moteur_recherche_31,
  t0.etat_lot AS etat_lot_32,
  t0.pj_progression AS pj_progression_33,
  t0.programme_parent_id AS programme_parent_id_34
FROM
  lot t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.type AS type_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.code_postal AS code_postal_6, t0.prix AS prix_7, t0.date_livraison AS date_livraison_8, t0.titre AS titre_9, t0.description AS description_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.etage AS etage_13, t0.superficie AS superficie_14, t0.terrasse AS terrasse_15, t0.orientation AS orientation_16, t0.annexes AS annexes_17, t0.livraison AS livraison_18, t0.promoteur AS promoteur_19, t0.programme AS programme_20, t0.image AS image_21, t0.jardin AS jardin_22, t0.terrasse2 AS terrasse2_23, t0.frais_notaire_type AS frais_notaire_type_24, t0.frais_notaire_inclus AS frais_notaire_inclus_25, t0.brochure AS brochure_26, t0.plan_masse AS plan_masse_27, t0.statut AS statut_28, t0.nature AS nature_29, t0.type_moteur_recherche AS type_moteur_recherche_30, t0.etage_moteur_recherche AS etage_moteur_recherche_31, t0.etat_lot AS etat_lot_32, t0.pj_progression AS pj_progression_33, t0.programme_parent_id AS programme_parent_id_34 FROM lot t0 WHERE t0.id = 2255;

INSERT INTO infos_suivi_prospect (infos_suivi_id, prospect_id)
VALUES
  (?, ?)

INSERT INTO infos_suivi_prospect (infos_suivi_id, prospect_id) VALUES (2840, 771);

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.email AS email_3,
  t0.telephone AS telephone_4,
  t0.adresse AS adresse_5,
  t0.website AS website_6,
  t0.logo AS logo_7,
  t0.logo_admin AS logo_admin_8,
  t0.updated_at AS updated_at_9,
  t0.available_roles AS available_roles_10
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.adresse AS adresse_5, t0.website AS website_6, t0.logo AS logo_7, t0.logo_admin AS logo_admin_8, t0.updated_at AS updated_at_9, t0.available_roles AS available_roles_10 FROM entreprise t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.adresse AS adresse_3,
  t0.ville AS ville_4,
  t0.code_postal AS code_postal_5,
  t0.date_livraison AS date_livraison_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.livraison AS livraison_9,
  t0.visu_livraison AS visu_livraison_10,
  t0.nom AS nom_11,
  t0.image AS image_12,
  t0.brochure AS brochure_13,
  t0.promoteur AS promoteur_14,
  t0.plan_masse AS plan_masse_15,
  t0.type_plan AS type_plan_16,
  t0.zoom_map AS zoom_map_17,
  t0.libelle_brochure AS libelle_brochure_18,
  t0.demande_suppression AS demande_suppression_19,
  t0.note_globale AS note_globale_20,
  t0.entreprise_id AS entreprise_id_21,
  t0.prescripteur_id AS prescripteur_id_22
FROM
  programme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.adresse AS adresse_3, t0.ville AS ville_4, t0.code_postal AS code_postal_5, t0.date_livraison AS date_livraison_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.livraison AS livraison_9, t0.visu_livraison AS visu_livraison_10, t0.nom AS nom_11, t0.image AS image_12, t0.brochure AS brochure_13, t0.promoteur AS promoteur_14, t0.plan_masse AS plan_masse_15, t0.type_plan AS type_plan_16, t0.zoom_map AS zoom_map_17, t0.libelle_brochure AS libelle_brochure_18, t0.demande_suppression AS demande_suppression_19, t0.note_globale AS note_globale_20, t0.entreprise_id AS entreprise_id_21, t0.prescripteur_id AS prescripteur_id_22 FROM programme t0 WHERE t0.id = 199;

SELECT
  t0.id AS id_1,
  t0.active_proposition AS active_proposition_2,
  t0.dateheure AS dateheure_3,
  t0.lot_id AS lot_id_4,
  t0.prospect_id AS prospect_id_5
FROM
  proposition t0
WHERE
  t0.prospect_id = ?
ORDER BY
  t0.dateheure DESC

SELECT t0.id AS id_1, t0.active_proposition AS active_proposition_2, t0.dateheure AS dateheure_3, t0.lot_id AS lot_id_4, t0.prospect_id AS prospect_id_5 FROM proposition t0 WHERE t0.prospect_id = 771 ORDER BY t0.dateheure DESC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.description_courte AS description_courte_3,
  t0.ordre AS ordre_4,
  t0.show_public AS show_public_5,
  t0.est_un_plan AS est_un_plan_6,
  t0.est_image_admin AS est_image_admin_7,
  t0.lot_id AS lot_id_8,
  t0.programme_id AS programme_id_9,
  t0.piece_jointe_mere_id AS piece_jointe_mere_id_10
FROM
  piece_jointe t0
WHERE
  t0.lot_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.description_courte AS description_courte_3, t0.ordre AS ordre_4, t0.show_public AS show_public_5, t0.est_un_plan AS est_un_plan_6, t0.est_image_admin AS est_image_admin_7, t0.lot_id AS lot_id_8, t0.programme_id AS programme_id_9, t0.piece_jointe_mere_id AS piece_jointe_mere_id_10 FROM piece_jointe t0 WHERE t0.lot_id = 2255 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.mode_envoi AS mode_envoi_2,
  t0.dateheure AS dateheure_3,
  t0.contenu AS contenu_4,
  t0.visite AS visite_5,
  t0.prospect_id AS prospect_id_6,
  t0.expediteur_id AS expediteur_id_7,
  t0.entreprise_id AS entreprise_id_8
FROM
  historique t0
WHERE
  t0.prospect_id = ?

SELECT t0.id AS id_1, t0.mode_envoi AS mode_envoi_2, t0.dateheure AS dateheure_3, t0.contenu AS contenu_4, t0.visite AS visite_5, t0.prospect_id AS prospect_id_6, t0.expediteur_id AS expediteur_id_7, t0.entreprise_id AS entreprise_id_8 FROM historique t0 WHERE t0.prospect_id = 771;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.notification AS notification_5,
  t0.hide_account AS hide_account_6,
  t0.hide_entreprise AS hide_entreprise_7,
  t0.all_programmes AS all_programmes_8,
  t0.couleur AS couleur_9,
  t0.telephone AS telephone_10,
  t0.nom AS nom_11,
  t0.prenom AS prenom_12,
  t0.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_13,
  t0.peut_modifier AS peut_modifier_14,
  t0.entreprise_id AS entreprise_id_15
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.notification AS notification_5, t0.hide_account AS hide_account_6, t0.hide_entreprise AS hide_entreprise_7, t0.all_programmes AS all_programmes_8, t0.couleur AS couleur_9, t0.telephone AS telephone_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_13, t0.peut_modifier AS peut_modifier_14, t0.entreprise_id AS entreprise_id_15 FROM utilisateur t0 WHERE t0.id = 12;