GET https://recette-bourse-aux-logements.cdc-habitat.fr/

Query Metrics

31 Database Queries
7 Different statements
10.07 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.22 ms
(71.67%)
25
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
  "DELAI_EMAIL_MODIFICATION_TOKEN"
]
0.99 ms
(9.86%)
1
SELECT t0.blr_id AS blr_id_1, t0.blr_nom AS blr_nom_2, t0.blr_num_interne AS blr_num_interne_3, t0.blr_mail_rapport_import AS blr_mail_rapport_import_4, t0.blr_actif AS blr_actif_5, t0.blr_logo AS blr_logo_6, t0.blr_aide_inscri AS blr_aide_inscri_7, t0.blr_telephone_contact AS blr_telephone_contact_8, t0.blr_mail_contact AS blr_mail_contact_9, t0.blr_url_site_internet AS blr_url_site_internet_10, t0.blr_ddc AS blr_ddc_11, t0.blr_ddm AS blr_ddm_12 FROM bailleur t0 WHERE t0.blr_actif = ? ORDER BY t0.blr_nom ASC
Parameters:
[
  1
]
0.60 ms
(5.93%)
1
SELECT t0.faq_id AS faq_id_1, t0.faq_question AS faq_question_2, t0.faq_reponse AS faq_reponse_3, t0.faq_affich_home AS faq_affich_home_4, t0.categorie_faq AS categorie_faq_5 FROM faq t0 WHERE t0.faq_affich_home = ?
Parameters:
[
  1
]
0.38 ms
(3.80%)
1
SELECT i0_.info_id AS info_id_0, i0_.info_titre AS info_titre_1, i0_.info_content AS info_content_2, i0_.info_hero AS info_hero_3, i0_.info_visible AS info_visible_4, i0_.info_date_debut AS info_date_debut_5, i0_.info_date_fin AS info_date_fin_6, i0_.info_ddc AS info_ddc_7, i0_.info_ddm AS info_ddm_8, i0_.info_categorie AS info_categorie_9 FROM information i0_ WHERE i0_.info_visible = 1 AND ((i0_.info_date_debut IS NULL OR i0_.info_date_debut <= ?)) AND ((i0_.info_date_fin IS NULL OR i0_.info_date_fin >= ?)) AND i0_.info_hero = ? ORDER BY i0_.info_ddm DESC
Parameters:
[
  "2025-01-10 00:00:00"
  "2025-01-10 00:00:00"
  1
]
0.31 ms
(3.09%)
1
SELECT m0_.mch_id AS mch_id_0, m0_.mch_libelle AS mch_libelle_1, m0_.mch_reference AS mch_reference_2 FROM mode_chauffage m0_
Parameters:
[]
0.31 ms
(3.06%)
1
SELECT t0_.tch_id AS tch_id_0, t0_.tch_libelle AS tch_libelle_1, t0_.tch_reference AS tch_reference_2 FROM type_chauffage t0_
Parameters:
[]
0.26 ms
(2.59%)
1
SELECT t0_.tpg_id AS tpg_id_0, t0_.tpg_libelle AS tpg_libelle_1, t0_.tpg_reference AS tpg_reference_2 FROM typologie t0_
Parameters:
[]

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