Symfony Profiler

[
  "route" => "app_etablissements_list"
  "route_parameters" => [
    "_route" => "app_etablissements_list"
    "_controller" => "App\Controller\HomeController::etablissementsList"
  ]
  "request_uri" => "https://www.temporaire.daip.ci/etablissements"
  "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 e0_.id AS id_0 FROM etablissement e0_ ORDER BY e0_.nom ASC"
]

[
  "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
    10 => 14
    11 => 11
    12 => 16
    13 => 1
    14 => 18
    15 => 19
    16 => 17
    17 => 20
    18 => 21
    19 => 22
    20 => 23
    21 => 24
    22 => 15
    23 => 25
    24 => 75
    25 => 74
    26 => 77
    27 => 78
    28 => 76
    29 => 27
    30 => 28
    31 => 112
    32 => 111
    33 => 26
    34 => 114
    35 => 113
    36 => 103
    37 => 29
    38 => 101
    39 => 4
    40 => 31
    41 => 33
    42 => 34
    43 => 35
    44 => 36
    45 => 37
    46 => 38
    47 => 39
    48 => 40
    49 => 41
    50 => 42
    51 => 43
    52 => 44
    53 => 45
    54 => 46
    55 => 47
    56 => 48
    57 => 50
    58 => 51
    59 => 52
    60 => 53
    61 => 54
    62 => 49
    63 => 115
    64 => 58
    65 => 59
    66 => 60
    67 => 61
    68 => 62
    69 => 63
    70 => 57
    71 => 64
    72 => 65
    73 => 32
    74 => 55
    75 => 66
    76 => 56
    77 => 68
    78 => 67
    79 => 69
    80 => 70
    81 => 71
    82 => 72
    83 => 2
    84 => 73
    85 => 8
    86 => 105
    87 => 5
    88 => 80
    89 => 79
    90 => 81
    91 => 82
    92 => 83
    93 => 84
    94 => 85
    95 => 86
    96 => 87
    97 => 88
    98 => 89
    99 => 90
    100 => 95
    101 => 91
    102 => 97
    103 => 92
    104 => 93
    105 => 94
    106 => 96
    107 => 98
    108 => 99
    109 => 6
    110 => 106
    111 => 107
    112 => 108
    113 => 109
    114 => 110
  ]
  "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
    87 => 1
    88 => 1
    89 => 1
    90 => 1
    91 => 1
    92 => 1
    93 => 1
    94 => 1
    95 => 1
    96 => 1
    97 => 1
    98 => 1
    99 => 1
    100 => 1
    101 => 1
    102 => 1
    103 => 1
    104 => 1
    105 => 1
    106 => 1
    107 => 1
    108 => 1
    109 => 1
    110 => 1
    111 => 1
    112 => 1
    113 => 1
    114 => 1
  ]
]

[
  "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 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"
]