Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.21 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.90 ms	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 Parameters: [`"1633c6a7e5a4a1"`] View formatted query View runnable query Explain query 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 = '1633c6a7e5a4a1' LIMIT 1;
2	0.31 ms	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 = ? Parameters: [`0`] View formatted query View runnable query Explain query 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 = 0;

#▲

Time

Info

0.90 ms

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

Parameters:

[
  "1633c6a7e5a4a1"
]

View formatted query View runnable query Explain query

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 = '1633c6a7e5a4a1' LIMIT 1;

0.31 ms

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 = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query

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 = 0;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Prospect	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\Entreprise	No errors.
App\Entity\Demande	No errors.
App\Entity\Proposition	No errors.
App\Entity\Impression	No errors.
App\Entity\Historique	The association App\Entity\Historique#entreprise refers to the inverse side field App\Entity\Entreprise#historiques which does not exist.
App\Entity\Denonciation	No errors.
App\Entity\InfosSuivi	No errors.
App\Entity\ActionTrace	No errors.
App\Entity\Typologie	No errors.
App\Entity\SecteurGeographique	No errors.
App\Entity\Etage	No errors.
App\Entity\VilleProgramme	No errors.
App\Entity\Lot	No errors.
App\Entity\Programme	No errors.

Symfony Profiler

https://lk1.test.genesii.fr/public/1633c6a7e5a4a1/lot

Configuration Settings

Theme