Symfony Profiler

[
  "route" => "app_metiers_list"
  "route_parameters" => [
    "_route" => "app_metiers_list"
    "_controller" => "App\Controller\HomeController::metiersList"
  ]
  "request_uri" => "https://temporaire.daip.ci/metiers"
  "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 m0_.id AS id_0 FROM metier m0_ LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id ORDER BY m0_.nom ASC"
]

[
  "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 WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.nom ASC"
  "params" => [
    1 => 64
    2 => 65
    3 => 32
    4 => 74
    5 => 16
    6 => 7
    7 => 61
    8 => 73
    9 => 82
    10 => 67
    11 => 15
    12 => 34
    13 => 57
    14 => 30
    15 => 58
    16 => 6
    17 => 47
    18 => 77
    19 => 56
    20 => 22
    21 => 41
    22 => 69
    23 => 70
    24 => 71
    25 => 11
    26 => 76
    27 => 79
    28 => 25
    29 => 62
    30 => 46
    31 => 3
    32 => 19
    33 => 12
    34 => 54
    35 => 42
    36 => 28
    37 => 53
    38 => 8
    39 => 50
    40 => 51
    41 => 63
    42 => 83
    43 => 55
    44 => 81
    45 => 14
    46 => 21
    47 => 4
    48 => 1
    49 => 85
    50 => 20
    51 => 44
    52 => 13
    53 => 45
    54 => 48
    55 => 78
    56 => 9
    57 => 5
    58 => 60
    59 => 75
    60 => 17
    61 => 80
    62 => 72
    63 => 29
    64 => 2
    65 => 10
    66 => 38
    67 => 39
    68 => 43
    69 => 33
    70 => 36
    71 => 37
    72 => 35
    73 => 26
    74 => 52
    75 => 24
    76 => 31
    77 => 27
    78 => 23
    79 => 66
    80 => 84
    81 => 68
    82 => 18
    83 => 59
    84 => 40
    85 => 49
    86 => 86
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
    31 => 1
    32 => 1
    33 => 1
    34 => 1
    35 => 1
    36 => 1
    37 => 1
    38 => 1
    39 => 1
    40 => 1
    41 => 1
    42 => 1
    43 => 1
    44 => 1
    45 => 1
    46 => 1
    47 => 1
    48 => 1
    49 => 1
    50 => 1
    51 => 1
    52 => 1
    53 => 1
    54 => 1
    55 => 1
    56 => 1
    57 => 1
    58 => 1
    59 => 1
    60 => 1
    61 => 1
    62 => 1
    63 => 1
    64 => 1
    65 => 1
    66 => 1
    67 => 1
    68 => 1
    69 => 1
    70 => 1
    71 => 1
    72 => 1
    73 => 1
    74 => 1
    75 => 1
    76 => 1
    77 => 1
    78 => 1
    79 => 1
    80 => 1
    81 => 1
    82 => 1
    83 => 1
    84 => 1
    85 => 1
    86 => 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 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"
]