Symfony Profiler

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,
  t0.blr_chart_color AS blr_chart_color_13
FROM
  bailleur t0
WHERE
  t0.blr_actif = ?
ORDER BY
  t0.blr_nom ASC

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, t0.blr_chart_color AS blr_chart_color_13 FROM bailleur t0 WHERE t0.blr_actif = 1 ORDER BY t0.blr_nom ASC;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = 'DELAI_TEMPO_SIGNALEMENT' LIMIT 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

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 <= '2026-07-13 00:00:00')) AND ((i0_.info_date_fin IS NULL OR i0_.info_date_fin >= '2026-07-13 00:00:00')) AND i0_.info_hero = 1 ORDER BY i0_.info_ddm DESC;

SELECT
  t0_.tpg_id AS tpg_id_0,
  t0_.tpg_libelle AS tpg_libelle_1,
  t0_.tpg_reference AS tpg_reference_2,
  t0_.tpg_chart_color AS tpg_chart_color_3
FROM
  typologie t0_

SELECT t0_.tpg_id AS tpg_id_0, t0_.tpg_libelle AS tpg_libelle_1, t0_.tpg_reference AS tpg_reference_2, t0_.tpg_chart_color AS tpg_chart_color_3 FROM typologie t0_;

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_

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_;

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_

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_;