Symfony Profiler

[
  "route" => "bel_user_registration_register"
  "route_parameters" => [
    "_route" => "bel_user_registration_register"
    "_controller" => "BEL\UserBundle\Controller\Account\RegistrationController::registerAction"
  ]
  "request_uri" => "https://sandbox.bourse-aux-logements.fr/inscription"
  "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.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.categorie_faq = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2203
      +name: "INTEGER"
    }
  ]
]

[
  "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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +name: "STRING"
    }
  ]
]

[
  "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 {#2513
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0_.tcp_id AS tcp_id_0, t0_.tcp_libelle AS tcp_libelle_1 FROM type_contact_privilegie t0_"
]

[
  "sql" => "SELECT b0_.blr_id AS blr_id_0, b0_.blr_nom AS blr_nom_1, b0_.blr_num_interne AS blr_num_interne_2, b0_.blr_mail_rapport_import AS blr_mail_rapport_import_3, b0_.blr_actif AS blr_actif_4, b0_.blr_logo AS blr_logo_5, b0_.blr_aide_inscri AS blr_aide_inscri_6, b0_.blr_telephone_contact AS blr_telephone_contact_7, b0_.blr_mail_contact AS blr_mail_contact_8, b0_.blr_url_site_internet AS blr_url_site_internet_9, b0_.blr_ddc AS blr_ddc_10, b0_.blr_ddm AS blr_ddm_11, b0_.blr_chart_color AS blr_chart_color_12 FROM bailleur b0_ WHERE b0_.blr_actif = 1 ORDER BY b0_.blr_nom ASC"
]

[
  "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 c0_.com_id AS com_id_0, c0_.com_code_postal AS com_code_postal_1, c0_.com_libelle AS com_libelle_2, c0_.com_ncc AS com_ncc_3, c0_.com_code_insee AS com_code_insee_4, c0_.departement AS departement_5, c0_.com_actif AS com_actif_6, c0_.com_geopoint AS com_geopoint_7, c0_.com_geoshape AS com_geoshape_8, c0_.com_groupement AS com_groupement_9, c0_.com_rel_id AS com_rel_id_10 FROM commune c0_ LIMIT 0"
]

[
  "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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +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 {#2204
      +name: "STRING"
    }
  ]
]