Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://temporaire.daip.ci/"
  "method" => "GET"
]

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

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

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

[
  "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.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "daip_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "daip_temporaire"
    "serverVersion" => "mariadb-10.4.24"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT m0_.id) AS sclr_0 FROM metier m0_ LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id LEFT JOIN etablissement_metier e2_ ON m0_.id = e2_.metier_id LEFT JOIN etablissement e3_ ON e2_.etablissement_id = e3_.id"
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.creation AS creation_2, m0_.modification AS modification_3, s1_.id AS id_4, s1_.nom AS nom_5, s1_.creation AS creation_6, s1_.modification AS modification_7, e2_.id AS id_8, e2_.nbrplace AS nbrplace_9, e2_.niveau_requis AS niveau_requis_10, e2_.duree_formation AS duree_formation_11, e3_.id AS id_12, e3_.nom AS nom_13, e3_.definition AS definition_14, e3_.creation AS creation_15, e3_.modification AS modification_16, m0_.secteur_id AS secteur_id_17, m0_.user_id AS user_id_18, s1_.user_id AS user_id_19, e2_.etablissement_id AS etablissement_id_20, e2_.metier_id AS metier_id_21, e3_.localite_id AS localite_id_22, e3_.direction_regionale_id AS direction_regionale_id_23, e3_.user_id AS user_id_24 FROM metier m0_ LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id LEFT JOIN etablissement_metier e2_ ON m0_.id = e2_.metier_id LEFT JOIN etablissement e3_ ON e2_.etablissement_id = e3_.id ORDER BY m0_.nom ASC LIMIT 9"
]

[
  "sql" => "SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM etablissement e0_"
]

[
  "sql" => "SELECT e0_.id AS id_0 FROM etablissement e0_ ORDER BY e0_.nom ASC LIMIT 9"
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.definition AS definition_2, e0_.creation AS creation_3, e0_.modification AS modification_4, l1_.id AS id_5, l1_.nom AS nom_6, l1_.type AS type_7, l1_.creation AS creation_8, l1_.modification AS modification_9, d2_.id AS id_10, d2_.nom AS nom_11, d2_.chef_lieu AS chef_lieu_12, d2_.creation AS creation_13, d2_.modification AS modification_14, e3_.id AS id_15, e3_.nbrplace AS nbrplace_16, e3_.niveau_requis AS niveau_requis_17, e3_.duree_formation AS duree_formation_18, m4_.id AS id_19, m4_.nom AS nom_20, m4_.creation AS creation_21, m4_.modification AS modification_22, e0_.localite_id AS localite_id_23, e0_.direction_regionale_id AS direction_regionale_id_24, e0_.user_id AS user_id_25, l1_.parent_id AS parent_id_26, l1_.direction_regionale_id AS direction_regionale_id_27, l1_.user_id AS user_id_28, d2_.user_id AS user_id_29, e3_.etablissement_id AS etablissement_id_30, e3_.metier_id AS metier_id_31, m4_.secteur_id AS secteur_id_32, m4_.user_id AS user_id_33 FROM etablissement e0_ LEFT JOIN localite l1_ ON e0_.localite_id = l1_.id LEFT JOIN direction_regionale d2_ ON l1_.direction_regionale_id = d2_.id LEFT JOIN etablissement_metier e3_ ON e0_.id = e3_.etablissement_id LEFT JOIN metier m4_ ON e3_.metier_id = m4_.id WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.nom ASC"
  "params" => [
    1 => 12
    2 => 13
    3 => 3
    4 => 7
    5 => 102
    6 => 100
    7 => 9
    8 => 104
    9 => 10
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.creation AS creation_3, t0.modification AS modification_4, t0.user_id AS user_id_5 FROM secteur t0 ORDER BY t0.nom ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.chef_lieu AS chef_lieu_3, t0.creation AS creation_4, t0.modification AS modification_5, t0.user_id AS user_id_6 FROM direction_regionale t0 ORDER BY t0.nom ASC"
]

[
  "sql" => "SELECT COUNT(*) FROM metier t0"
]

[
  "sql" => "SELECT COUNT(*) FROM etablissement t0"
]

[
  "sql" => "SELECT COUNT(*) FROM secteur t0"
]

[
  "sql" => "SELECT SUM(nbrplace) as total FROM etablissement_metier"
]

[
  "sql" => "SELECT COUNT(*) FROM candidature t0"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "daip_temporaire"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::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\HttpKernel\EventListener\SurrogateListener::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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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

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