Symfony Profiler

[
  "route" => "homepage"
  "route_parameters" => [
    "_route" => "homepage"
    "_controller" => "App\Controller\FrontendController::home"
  ]
  "request_uri" => "https://circulaire.developpe.net/"
  "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"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerJWRfa9f\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "develorcircular.mysql.db"
    "port" => 3306
    "user" => "develorcircular"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "develorcircular"
    "serverVersion" => "10.04.32-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.capital AS capital_3, t0.code_iso AS code_iso_4 FROM district t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                SELECT a.*, \n
                       ta.libelle as type_acteur_libelle,\n
                       dp.region_id as region_id,\n
                       r.district_id as district_id\n
                FROM acteur a \n
                LEFT JOIN type_acteur ta ON a.type_acteur_id = ta.id \n
                LEFT JOIN departement dp ON a.departement_id = dp.id\n
                LEFT JOIN region r ON dp.region_id = r.id\n
             WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL
    """
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM type_acteur t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM role_principal t0"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "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\HttpKernel\EventListener\CacheAttributeListener::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.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\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

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