Symfony Profiler

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "host" => "cpamdugapconnect.mysql.db"
    "port" => 3306
    "user" => "cpamdugapconnect"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "cpamdugapconnect"
  ]
]

[
  "route" => "app_parcours_outils"
  "route_parameters" => [
    "_route" => "app_parcours_outils"
    "_controller" => "App\Controller\ParcoursController::outils"
    "id" => "52"
  ]
  "request_uri" => "https://parcours-connect.cpam-du-gard.fr/parcours/52/outils"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_online AS is_online_7, t0.couleur_id AS couleur_id_8 FROM parcours t0 WHERE t0.id = ?"
  "params" => [
    1 => "52"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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" => "ContainerKu2xP1I\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT DISTINCT f0_.id AS id_0, f0_.titre AS titre_1, f0_.type AS type_2, f0_.url AS url_3, f0_.filename AS filename_4, f0_.original_filename AS original_filename_5, f0_.mime_type AS mime_type_6, f0_.file_size AS file_size_7, f0_.uploaded_at AS uploaded_at_8, f0_.question AS question_9, f0_.reponse AS reponse_10, f0_.description AS description_11, f0_.informations_complementaires_type AS informations_complementaires_type_12, f0_.informations_complementaires_contenu AS informations_complementaires_contenu_13, f0_.facturation_type AS facturation_type_14, f0_.facturation_contenu AS facturation_contenu_15, f0_.definition_type AS definition_type_16, f0_.definition_contenu AS definition_contenu_17, f0_.icone1 AS icone1_18, f0_.icone2 AS icone2_19, f0_.updated_at AS updated_at_20 FROM fiche_outil f0_ LEFT JOIN pratique_fiche_outil p2_ ON f0_.id = p2_.fiche_outil_id LEFT JOIN pratique p1_ ON p1_.id = p2_.pratique_id LEFT JOIN rubrique r3_ ON p1_.rubrique_id = r3_.id LEFT JOIN parcours p4_ ON r3_.parcours_id = p4_.id LEFT JOIN etape_fiche_outil e6_ ON f0_.id = e6_.fiche_outil_id LEFT JOIN etape e5_ ON e5_.id = e6_.etape_id LEFT JOIN rubrique r7_ ON e5_.rubrique_id = r7_.id LEFT JOIN parcours p8_ ON r7_.parcours_id = p8_.id LEFT JOIN fiche_outil_niv2_fiche_outil f10_ ON f0_.id = f10_.fiche_outil_id LEFT JOIN fiche_outil_niv2 f9_ ON f9_.id = f10_.fiche_outil_niv2_id LEFT JOIN pratique p11_ ON f9_.pratique_id = p11_.id LEFT JOIN rubrique r12_ ON p11_.rubrique_id = r12_.id LEFT JOIN parcours p13_ ON r12_.parcours_id = p13_.id LEFT JOIN etape e14_ ON f9_.etape_id = e14_.id LEFT JOIN rubrique r15_ ON e14_.rubrique_id = r15_.id LEFT JOIN parcours p16_ ON r15_.parcours_id = p16_.id WHERE p4_.id = ? OR p8_.id = ? OR p13_.id = ? OR p16_.id = ? ORDER BY f0_.titre ASC"
  "params" => [
    1 => 52
    2 => 52
    3 => 52
    4 => 52
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.contenu AS contenu_6, t0.parcours_id AS parcours_id_7 FROM rubrique t0 WHERE t0.parcours_id = ? AND t0.type = ? LIMIT 1"
  "params" => [
    1 => 52
    2 => "liste"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type AS type_3, t0.url AS url_4, t0.filename AS filename_5, t0.original_filename AS original_filename_6, t0.mime_type AS mime_type_7, t0.file_size AS file_size_8, t0.uploaded_at AS uploaded_at_9, t0.question AS question_10, t0.reponse AS reponse_11, t0.description AS description_12, t0.informations_complementaires_type AS informations_complementaires_type_13, t0.informations_complementaires_contenu AS informations_complementaires_contenu_14, t0.facturation_type AS facturation_type_15, t0.facturation_contenu AS facturation_contenu_16, t0.definition_type AS definition_type_17, t0.definition_contenu AS definition_contenu_18, t0.icone1 AS icone1_19, t0.icone2 AS icone2_20, t0.updated_at AS updated_at_21 FROM fiche_outil t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 20
    2 => 21
    3 => 22
    4 => 31
    5 => 27
    6 => 7
    7 => 38
    8 => 39
    9 => 42
    10 => 44
    11 => 41
    12 => 24
    13 => 32
    14 => 28
    15 => 33
    16 => 49
    17 => 37
    18 => 30
    19 => 13
    20 => 43
    21 => 45
    22 => 46
    23 => 47
    24 => 48
    25 => 34
    26 => 35
    27 => 36
    28 => 29
    29 => 40
  ]
  "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
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.titre AS titre_1, r0_.description AS description_2, r0_.position AS position_3, r0_.type AS type_4, r0_.contenu AS contenu_5, p1_.id AS id_6, p1_.titre AS titre_7, p1_.description AS description_8, p1_.contenu AS contenu_9, p1_.position AS position_10, e2_.id AS id_11, e2_.titre AS titre_12, e2_.description AS description_13, e2_.contenu AS contenu_14, e2_.position AS position_15, e2_.logo AS logo_16, e2_.icon_filename AS icon_filename_17, e2_.updated_at AS updated_at_18, r0_.parcours_id AS parcours_id_19, p1_.rubrique_id AS rubrique_id_20, e2_.rubrique_id AS rubrique_id_21 FROM rubrique r0_ LEFT JOIN pratique p1_ ON r0_.id = p1_.rubrique_id LEFT JOIN etape e2_ ON r0_.id = e2_.rubrique_id WHERE r0_.parcours_id = ? ORDER BY r0_.position ASC, p1_.position ASC, e2_.position ASC"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_rgb AS code_rgb_3 FROM couleur t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "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\Security\Http\RememberMe\ResponseListener::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"
]