Symfony Profiler

[
  "route" => "afficher_questionnaire"
  "route_parameters" => [
    "_route" => "afficher_questionnaire"
    "_controller" => "App\Controller\QuestionnaireController::afficher"
  ]
  "request_uri" => "http://86.65.9.120/questionnaire"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "proagri_gard"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "proagri_gard"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.titre AS titre_3, t0.actif AS actif_4 FROM questionnaire t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.sujets_preoccupants AS sujets_preoccupants_3, t0.min_sujets AS min_sujets_4, t0.max_sujets AS max_sujets_5, t0.ordre AS ordre_6, t0.classe AS classe_7 FROM categorie_question t0 ORDER BY t0.ordre ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_departement AS nom_departement_2, t0.code_departement AS code_departement_3, t0.code_region AS code_region_4, t0.nom_region AS nom_region_5 FROM departement t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM systeme_production t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.libelle_fix AS libelle_fix_4, t0.active AS active_5, t0.coef AS coef_6, t0.commentaire_sujets_preoccupants AS commentaire_sujets_preoccupants_7, t0.questionnaire_id AS questionnaire_id_8, t0.categorie_id AS categorie_id_9 FROM question t0 WHERE t0.questionnaire_id = ? AND t0.type = ? AND t0.active = ?"
  "params" => [
    1 => 1
    2 => "fix"
    3 => 1
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.libelle_fix AS libelle_fix_4, t0.active AS active_5, t0.coef AS coef_6, t0.commentaire_sujets_preoccupants AS commentaire_sujets_preoccupants_7, t0.questionnaire_id AS questionnaire_id_8, t0.categorie_id AS categorie_id_9 FROM question t0 WHERE t0.questionnaire_id = ? AND t0.type = ? AND t0.active = ?"
  "params" => [
    1 => 1
    2 => "jauge"
    3 => 1
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.min AS min_3, t0.max AS max_4, t0.couleur AS couleur_5, t0.question_id AS question_id_6 FROM libelle_reponse t0 WHERE t0.question_id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.min ASC"
  "params" => [
    1 => 5
    2 => 6
    3 => 7
    4 => 8
    5 => 9
    6 => 10
    7 => 11
    8 => 12
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.texte AS texte_2 FROM mentions_legales t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]