Symfony Profiler

[
  "route" => "accueil"
  "route_parameters" => [
    "_route" => "accueil"
    "_controller" => "BEL\FrontOfficeBundle\Controller\FrontOfficeController::indexAction"
  ]
  "request_uri" => "https://sandbox.bourse-aux-logements.fr/?rest_route=%2Fwp%2Fv2%2Fusers%2F"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "sql9565.webmo.fr"
    "port" => "3306"
    "dbname" => "bel_sandbox"
    "user" => "bel_sandbox"
    "password" => "<redacted>"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "driverOptions" => []
    "defaultTableOptions" => []
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1262
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_EMAIL_MODIFICATION_TOKEN"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_INACTIVITE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_INACTIVITE_COMPTE_NON_FINALISE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_DESACTIVATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_DESACTIVATION_COMPTE_NON_FINALISE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_DESACTIVATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_DESACTIVATION_COMPTE_NON_FINALISE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_INSCRIPTION_REFUSEE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_INSCRIPTION_NON_ABOUTIE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_DESINSCRIPTION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_RELANCE_DEMANDE_CONTACT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_DEMANDE_CONTACT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_RELANCE_DEMANDE_VISITE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_DEMANDE_VISITE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_DEMANDE_NON_ABOUTIE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_ECHANGE_REFUSE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_SUPPR_ECHANGE_VALIDE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_ALERTE_INSCRIPTION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_TEMPO_NOTATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NB_MIN_PHOTOS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NB_MAX_PHOTOS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NB_MAX_TYPOLOGIES_RECHERCHE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NB_MAX_COMMUNES_RECHERCHE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "AIDE_ANNONCES_LOGEMENT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "PRE_LAUNCHED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "PRE_LAUNCHED_MESSAGE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "FORMULAIRE_QUALITE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_ARCHIVAGE_AUTOMATIQUE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DESTINATAIRES_RAPPORTS_MENSUELS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NB_MAX_SIGNALEMENTS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "DELAI_TEMPO_SIGNALEMENT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-09-30 00:00:00"
    2 => "2026-09-30 00:00:00"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1281
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1281}
    3 => Doctrine\DBAL\ParameterType {#1262
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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_"
]

[
  "sql" => "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_"
]

[
  "sql" => "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_"
]