Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

12.87 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	7.54 ms	SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id WHERE t0.id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id WHERE t0.id = '1';
2	5.33 ms	SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id;

#▲

Time

Info

7.54 ms

SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.id_fiche AS id_fiche_2,
  t0.nom_du_projet AS nom_du_projet_3,
  t0.nom_du_projet_court AS nom_du_projet_court_4,
  t0.nom_usage_court AS nom_usage_court_5,
  t0.moa AS moa_6,
  t0.ville AS ville_7,
  t0.departement AS departement_8,
  t0.time AS time_9,
  t0.nom_initial_fichier AS nom_initial_fichier_10,
  t0.id_fichier AS id_fichier_11,
  t0.surface_shon AS surface_shon_12,
  t0.bbio_total_annuel AS bbio_total_annuel_13,
  t0.bbiomax AS bbiomax_14,
  t0.bbio_chaud_annuel AS bbio_chaud_annuel_15,
  t0.bbio_froid_annuel AS bbio_froid_annuel_16,
  t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17,
  t0.ratio_psi AS ratio_psi_18,
  t0.q4_pa_surf AS q4_pa_surf_19,
  t0.total_surface_opaque AS total_surface_opaque_20,
  t0.total_surface_vitree AS total_surface_vitree_21,
  t0.volume_groupe AS volume_groupe_22,
  t0.surface_totale_enveloppe AS surface_totale_enveloppe_23,
  t0.compacite AS compacite_24,
  t0.taux_vitrage AS taux_vitrage_25,
  t0.uw_moyen AS uw_moyen_26,
  t0.usage_zone AS usage_zone_27,
  t0.gain_bbio AS gain_bbio_28,
  t0.cep_projet AS cep_projet_29,
  t0.cep_max AS cep_max_30,
  t0.gain_cep AS gain_cep_31,
  t0.cep_ch AS cep_ch_32,
  t0.cep_fr AS cep_fr_33,
  t0.cep_ecs AS cep_ecs_34,
  t0.cep_ecl AS cep_ecl_35,
  t0.cep_ventil AS cep_ventil_36,
  t0.cep_distrib AS cep_distrib_37,
  t0.cep_pv AS cep_pv_38,
  t0.aepenr AS aepenr_39,
  t0.zone_climatique AS zone_climatique_40,
  t0.taux_brassage_bbio AS taux_brassage_bbio_41,
  t0.part_baies_sud_batiment AS part_baies_sud_batiment_42,
  t0.nom_usage AS nom_usage_43,
  t0.ratio_ecl_nat AS ratio_ecl_nat_44,
  t0.masque_moyen AS masque_moyen_45,
  t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46,
  t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47,
  t0.pvent_souf_batiment AS pvent_souf_batiment_48,
  t0.pvent_rep_batiment AS pvent_rep_batiment_49,
  t0.pvent_specifique_batiment AS pvent_specifique_batiment_50,
  t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51,
  t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52,
  t0.deperdition_batiment AS deperdition_batiment_53,
  t0.deperdition_surfacique AS deperdition_surfacique_54,
  t0.version AS version_55,
  t0.the_user_id AS the_user_id_56,
  t57.id AS id_58,
  t57.the_fiche_batiment_id AS the_fiche_batiment_id_59
FROM
  fiche_batiment t0
  LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id WHERE t0.id = '1';

5.33 ms

SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.id_fiche AS id_fiche_2,
  t0.nom_du_projet AS nom_du_projet_3,
  t0.nom_du_projet_court AS nom_du_projet_court_4,
  t0.nom_usage_court AS nom_usage_court_5,
  t0.moa AS moa_6,
  t0.ville AS ville_7,
  t0.departement AS departement_8,
  t0.time AS time_9,
  t0.nom_initial_fichier AS nom_initial_fichier_10,
  t0.id_fichier AS id_fichier_11,
  t0.surface_shon AS surface_shon_12,
  t0.bbio_total_annuel AS bbio_total_annuel_13,
  t0.bbiomax AS bbiomax_14,
  t0.bbio_chaud_annuel AS bbio_chaud_annuel_15,
  t0.bbio_froid_annuel AS bbio_froid_annuel_16,
  t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17,
  t0.ratio_psi AS ratio_psi_18,
  t0.q4_pa_surf AS q4_pa_surf_19,
  t0.total_surface_opaque AS total_surface_opaque_20,
  t0.total_surface_vitree AS total_surface_vitree_21,
  t0.volume_groupe AS volume_groupe_22,
  t0.surface_totale_enveloppe AS surface_totale_enveloppe_23,
  t0.compacite AS compacite_24,
  t0.taux_vitrage AS taux_vitrage_25,
  t0.uw_moyen AS uw_moyen_26,
  t0.usage_zone AS usage_zone_27,
  t0.gain_bbio AS gain_bbio_28,
  t0.cep_projet AS cep_projet_29,
  t0.cep_max AS cep_max_30,
  t0.gain_cep AS gain_cep_31,
  t0.cep_ch AS cep_ch_32,
  t0.cep_fr AS cep_fr_33,
  t0.cep_ecs AS cep_ecs_34,
  t0.cep_ecl AS cep_ecl_35,
  t0.cep_ventil AS cep_ventil_36,
  t0.cep_distrib AS cep_distrib_37,
  t0.cep_pv AS cep_pv_38,
  t0.aepenr AS aepenr_39,
  t0.zone_climatique AS zone_climatique_40,
  t0.taux_brassage_bbio AS taux_brassage_bbio_41,
  t0.part_baies_sud_batiment AS part_baies_sud_batiment_42,
  t0.nom_usage AS nom_usage_43,
  t0.ratio_ecl_nat AS ratio_ecl_nat_44,
  t0.masque_moyen AS masque_moyen_45,
  t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46,
  t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47,
  t0.pvent_souf_batiment AS pvent_souf_batiment_48,
  t0.pvent_rep_batiment AS pvent_rep_batiment_49,
  t0.pvent_specifique_batiment AS pvent_specifique_batiment_50,
  t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51,
  t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52,
  t0.deperdition_batiment AS deperdition_batiment_53,
  t0.deperdition_surfacique AS deperdition_surfacique_54,
  t0.version AS version_55,
  t0.the_user_id AS the_user_id_56,
  t57.id AS id_58,
  t57.the_fiche_batiment_id AS the_fiche_batiment_id_59
FROM
  fiche_batiment t0
  LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id

SELECT t0.id AS id_1, t0.id_fiche AS id_fiche_2, t0.nom_du_projet AS nom_du_projet_3, t0.nom_du_projet_court AS nom_du_projet_court_4, t0.nom_usage_court AS nom_usage_court_5, t0.moa AS moa_6, t0.ville AS ville_7, t0.departement AS departement_8, t0.time AS time_9, t0.nom_initial_fichier AS nom_initial_fichier_10, t0.id_fichier AS id_fichier_11, t0.surface_shon AS surface_shon_12, t0.bbio_total_annuel AS bbio_total_annuel_13, t0.bbiomax AS bbiomax_14, t0.bbio_chaud_annuel AS bbio_chaud_annuel_15, t0.bbio_froid_annuel AS bbio_froid_annuel_16, t0.bbio_eclairage_annuel AS bbio_eclairage_annuel_17, t0.ratio_psi AS ratio_psi_18, t0.q4_pa_surf AS q4_pa_surf_19, t0.total_surface_opaque AS total_surface_opaque_20, t0.total_surface_vitree AS total_surface_vitree_21, t0.volume_groupe AS volume_groupe_22, t0.surface_totale_enveloppe AS surface_totale_enveloppe_23, t0.compacite AS compacite_24, t0.taux_vitrage AS taux_vitrage_25, t0.uw_moyen AS uw_moyen_26, t0.usage_zone AS usage_zone_27, t0.gain_bbio AS gain_bbio_28, t0.cep_projet AS cep_projet_29, t0.cep_max AS cep_max_30, t0.gain_cep AS gain_cep_31, t0.cep_ch AS cep_ch_32, t0.cep_fr AS cep_fr_33, t0.cep_ecs AS cep_ecs_34, t0.cep_ecl AS cep_ecl_35, t0.cep_ventil AS cep_ventil_36, t0.cep_distrib AS cep_distrib_37, t0.cep_pv AS cep_pv_38, t0.aepenr AS aepenr_39, t0.zone_climatique AS zone_climatique_40, t0.taux_brassage_bbio AS taux_brassage_bbio_41, t0.part_baies_sud_batiment AS part_baies_sud_batiment_42, t0.nom_usage AS nom_usage_43, t0.ratio_ecl_nat AS ratio_ecl_nat_44, t0.masque_moyen AS masque_moyen_45, t0.qv_rep_occ_batiment AS qv_rep_occ_batiment_46, t0.qv_souf_occ_batiment AS qv_souf_occ_batiment_47, t0.pvent_souf_batiment AS pvent_souf_batiment_48, t0.pvent_rep_batiment AS pvent_rep_batiment_49, t0.pvent_specifique_batiment AS pvent_specifique_batiment_50, t0.combinaison_compacite_taux_vitrage AS combinaison_compacite_taux_vitrage_51, t0.combinaison_compacite_taux_vitrage_brassage_bbio AS combinaison_compacite_taux_vitrage_brassage_bbio_52, t0.deperdition_batiment AS deperdition_batiment_53, t0.deperdition_surfacique AS deperdition_surfacique_54, t0.version AS version_55, t0.the_user_id AS the_user_id_56, t57.id AS id_58, t57.the_fiche_batiment_id AS the_fiche_batiment_id_59 FROM fiche_batiment t0 LEFT JOIN fiche_batiment_exemple t57 ON t57.the_fiche_batiment_id = t0.id;

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\Fiche\FicheBatiment	No errors.
App\Entity\User\User	The association App\Entity\User\User#visaExigences refers to the inverse side field App\Entity\Visa\VisaExigences#User which does not exist.
App\Entity\Fiche\FicheBatimentExemple	No errors.

Symfony Profiler

https://app.quveo.fr/fiche-batiment/analyse/1

Configuration Settings

Theme