Symfony Profiler

[
  "route" => "index"
  "route_parameters" => [
    "_route" => "index"
    "_locale" => "de"
    "_controller" => "App\Controller\FrontendController::index"
  ]
  "request_uri" => "https://www.munichclimbs.com/"
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\LocaleSubscriber::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" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

[
  "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\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

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

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

[
  "key" => "frontend_latest_routes"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3307
    "user" => "kre45tc3_munichclimbstest"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "kre45tc3_munichclimbstestumgebung"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.grade AS grade_2, r1_.name AS name_3, r1_.slug AS slug_4, a2_.slug AS slug_5 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id INNER JOIN area a2_ ON r0_.area_id = a2_.id WHERE r1_.slug IS NOT NULL AND a2_.slug IS NOT NULL AND r1_.online = 1 AND a2_.online = 1 ORDER BY r0_.year_first_ascent DESC LIMIT 5"
]

[
  "key" => "frontend_latest_comments"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.comment AS comment_1, c0_.datetime AS datetime_2, u1_.firstname AS firstname_3, r2_.name AS name_4, r3_.slug AS slug_5, r3_.name AS name_6, a4_.slug AS slug_7, c0_.comment AS comment_8, c0_.datetime AS datetime_9, c0_.user_id AS user_id_10, c0_.route_id AS route_id_11 FROM comment c0_ INNER JOIN `user` u1_ ON c0_.user_id = u1_.id INNER JOIN routes r2_ ON c0_.route_id = r2_.id INNER JOIN rock r3_ ON r2_.rock_id = r3_.id INNER JOIN area a4_ ON r2_.area_id = a4_.id WHERE c0_.datetime IS NOT NULL ORDER BY c0_.datetime DESC LIMIT 5"
]

[
  "key" => "frontend_banned_rocks_v2"
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.banned AS banned_3, a1_.name AS name_4, a1_.slug AS slug_5 FROM rock r0_ INNER JOIN area a1_ ON r0_.area_id = a1_.id WHERE r0_.banned IN (1, 2) AND r0_.slug IS NOT NULL AND a1_.slug IS NOT NULL AND a1_.online = 1 ORDER BY r0_.banned ASC"
]

[
  "key" => "areas_information_v2"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.image AS image_3, a0_.lat AS lat_4, a0_.lng AS lng_5, a0_.travel_time_minutes AS travel_time_minutes_6, COUNT(DISTINCT r1_.id) AS sclr_7, COUNT(DISTINCT r2_.id) AS sclr_8, COUNT(DISTINCT CASE WHEN r1_.grade_no > 0 AND r1_.grade_no <= 15 THEN r1_.id ELSE 0 END) AS sclr_9, COUNT(DISTINCT CASE WHEN r1_.grade_no > 15 AND r1_.grade_no <= 29 THEN r1_.id ELSE 0 END) AS sclr_10, COUNT(DISTINCT CASE WHEN r1_.grade_no > 29 THEN r1_.id ELSE 0 END) AS sclr_11, COUNT(DISTINCT CASE WHEN r1_.grade_no = 0 OR r1_.grade_no IS NULL THEN r1_.id ELSE 0 END) AS sclr_12 FROM area a0_ LEFT JOIN routes r1_ ON a0_.id = r1_.area_id LEFT JOIN rock r2_ ON a0_.id = r2_.area_id WHERE a0_.online = 1 GROUP BY a0_.id, a0_.name, a0_.slug, a0_.image, a0_.lat, a0_.lng, a0_.travel_time_minutes, a0_.sequence ORDER BY a0_.sequence ASC"
]

[
  "sql" => "SELECT r0_.area_id AS sclr_0, SUM(CASE WHEN r0_.grade IN (?, ?, ?) THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_5, SUM(CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_6, SUM(CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_7, SUM(CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_8, SUM(CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_9 FROM routes r0_ GROUP BY r0_.area_id"
  "params" => [
    1 => "3-"
    2 => 3
    3 => "3+"
    4 => "4-"
    5 => 4
    6 => "4a"
    7 => "4b"
    8 => "4c"
    9 => "4c+"
    10 => "4+"
    11 => "5-"
    12 => 5
    13 => "5/5+"
    14 => "5+"
    15 => "5a"
    16 => "5a/5b+"
    17 => "FB 3"
    18 => "5+/6-"
    19 => "5a+"
    20 => "5b"
    21 => "5b+"
    22 => "5c"
    23 => "5c+"
    24 => "6-"
    25 => "6-/6"
    26 => 6
    27 => "6/6+"
    28 => "6+"
    29 => "6a"
    30 => "6a/6a+"
    31 => "6a+"
    32 => "6a+/6b"
    33 => "6b"
    34 => "FB 4-"
    35 => "FB 4"
    36 => "FB 4+"
    37 => "6+/7-"
    38 => "6b/6b+"
    39 => "6b+"
    40 => "6c"
    41 => "6c+"
    42 => "6c+/7a"
    43 => "7-"
    44 => "7-/7"
    45 => 7
    46 => "7/7+"
    47 => "7+"
    48 => "7a"
    49 => "7a/7a+"
    50 => "7a+"
    51 => "7b"
    52 => "7b+"
    53 => "6b+/6c"
    54 => "7a+/7b"
    55 => "FB 5"
    56 => "FB 5+"
    57 => "FB 6A"
    58 => "FB 6A+"
    59 => "FB 6B"
    60 => "FB 6B+"
    61 => "7+/8-"
    62 => "7b+/7c"
    63 => "7c"
    64 => "7c/7c+"
    65 => "7c+"
    66 => "8-"
    67 => "8-/8"
    68 => 8
    69 => "8/8+"
    70 => "8+"
    71 => "8a"
    72 => "8a/8a+"
    73 => "8a+"
    74 => "8a+/8b"
    75 => "8b"
    76 => "7c+/8a"
    77 => "FB 6C"
    78 => "FB 6C+"
    79 => "FB 7A"
    80 => "8+/9-"
    81 => "8b/8b+"
    82 => "8b+"
    83 => "8b+/8c"
    84 => "8c"
    85 => "8c+"
    86 => "8c+/9a"
    87 => "9-"
    88 => "9-/9"
    89 => 9
    90 => "9/9+"
    91 => "9+"
    92 => "9a"
    93 => "FB 7A+"
    94 => "FB 7B"
    95 => "FB 7B+"
    96 => "9+/10-"
    97 => "9a/9a+"
    98 => "9a+"
    99 => "10-"
    100 => "10-/10"
    101 => 10
    102 => "10/10+"
    103 => "10+"
    104 => "9b"
    105 => "FB 7C"
    106 => "FB 7C+"
    107 => "FB 8A"
    108 => "10+/11-"
    109 => "11-"
    110 => "11-/11"
    111 => 11
    112 => "9b+"
    113 => "FB 8A+"
    114 => "FB 8B"
    115 => "FB 8B+"
    116 => "FB 8C"
    117 => "FB 8C+"
    118 => "FB 9A"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2016
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2016}
    3 => Doctrine\DBAL\ParameterType {#2016}
    4 => Doctrine\DBAL\ParameterType {#2016}
    5 => Doctrine\DBAL\ParameterType {#2016}
    6 => Doctrine\DBAL\ParameterType {#2016}
    7 => Doctrine\DBAL\ParameterType {#2016}
    8 => Doctrine\DBAL\ParameterType {#2016}
    9 => Doctrine\DBAL\ParameterType {#2016}
    10 => Doctrine\DBAL\ParameterType {#2016}
    11 => Doctrine\DBAL\ParameterType {#2016}
    12 => Doctrine\DBAL\ParameterType {#2016}
    13 => Doctrine\DBAL\ParameterType {#2016}
    14 => Doctrine\DBAL\ParameterType {#2016}
    15 => Doctrine\DBAL\ParameterType {#2016}
    16 => Doctrine\DBAL\ParameterType {#2016}
    17 => Doctrine\DBAL\ParameterType {#2016}
    18 => Doctrine\DBAL\ParameterType {#2016}
    19 => Doctrine\DBAL\ParameterType {#2016}
    20 => Doctrine\DBAL\ParameterType {#2016}
    21 => Doctrine\DBAL\ParameterType {#2016}
    22 => Doctrine\DBAL\ParameterType {#2016}
    23 => Doctrine\DBAL\ParameterType {#2016}
    24 => Doctrine\DBAL\ParameterType {#2016}
    25 => Doctrine\DBAL\ParameterType {#2016}
    26 => Doctrine\DBAL\ParameterType {#2016}
    27 => Doctrine\DBAL\ParameterType {#2016}
    28 => Doctrine\DBAL\ParameterType {#2016}
    29 => Doctrine\DBAL\ParameterType {#2016}
    30 => Doctrine\DBAL\ParameterType {#2016}
    31 => Doctrine\DBAL\ParameterType {#2016}
    32 => Doctrine\DBAL\ParameterType {#2016}
    33 => Doctrine\DBAL\ParameterType {#2016}
    34 => Doctrine\DBAL\ParameterType {#2016}
    35 => Doctrine\DBAL\ParameterType {#2016}
    36 => Doctrine\DBAL\ParameterType {#2016}
    37 => Doctrine\DBAL\ParameterType {#2016}
    38 => Doctrine\DBAL\ParameterType {#2016}
    39 => Doctrine\DBAL\ParameterType {#2016}
    40 => Doctrine\DBAL\ParameterType {#2016}
    41 => Doctrine\DBAL\ParameterType {#2016}
    42 => Doctrine\DBAL\ParameterType {#2016}
    43 => Doctrine\DBAL\ParameterType {#2016}
    44 => Doctrine\DBAL\ParameterType {#2016}
    45 => Doctrine\DBAL\ParameterType {#2016}
    46 => Doctrine\DBAL\ParameterType {#2016}
    47 => Doctrine\DBAL\ParameterType {#2016}
    48 => Doctrine\DBAL\ParameterType {#2016}
    49 => Doctrine\DBAL\ParameterType {#2016}
    50 => Doctrine\DBAL\ParameterType {#2016}
    51 => Doctrine\DBAL\ParameterType {#2016}
    52 => Doctrine\DBAL\ParameterType {#2016}
    53 => Doctrine\DBAL\ParameterType {#2016}
    54 => Doctrine\DBAL\ParameterType {#2016}
    55 => Doctrine\DBAL\ParameterType {#2016}
    56 => Doctrine\DBAL\ParameterType {#2016}
    57 => Doctrine\DBAL\ParameterType {#2016}
    58 => Doctrine\DBAL\ParameterType {#2016}
    59 => Doctrine\DBAL\ParameterType {#2016}
    60 => Doctrine\DBAL\ParameterType {#2016}
    61 => Doctrine\DBAL\ParameterType {#2016}
    62 => Doctrine\DBAL\ParameterType {#2016}
    63 => Doctrine\DBAL\ParameterType {#2016}
    64 => Doctrine\DBAL\ParameterType {#2016}
    65 => Doctrine\DBAL\ParameterType {#2016}
    66 => Doctrine\DBAL\ParameterType {#2016}
    67 => Doctrine\DBAL\ParameterType {#2016}
    68 => Doctrine\DBAL\ParameterType {#2016}
    69 => Doctrine\DBAL\ParameterType {#2016}
    70 => Doctrine\DBAL\ParameterType {#2016}
    71 => Doctrine\DBAL\ParameterType {#2016}
    72 => Doctrine\DBAL\ParameterType {#2016}
    73 => Doctrine\DBAL\ParameterType {#2016}
    74 => Doctrine\DBAL\ParameterType {#2016}
    75 => Doctrine\DBAL\ParameterType {#2016}
    76 => Doctrine\DBAL\ParameterType {#2016}
    77 => Doctrine\DBAL\ParameterType {#2016}
    78 => Doctrine\DBAL\ParameterType {#2016}
    79 => Doctrine\DBAL\ParameterType {#2016}
    80 => Doctrine\DBAL\ParameterType {#2016}
    81 => Doctrine\DBAL\ParameterType {#2016}
    82 => Doctrine\DBAL\ParameterType {#2016}
    83 => Doctrine\DBAL\ParameterType {#2016}
    84 => Doctrine\DBAL\ParameterType {#2016}
    85 => Doctrine\DBAL\ParameterType {#2016}
    86 => Doctrine\DBAL\ParameterType {#2016}
    87 => Doctrine\DBAL\ParameterType {#2016}
    88 => Doctrine\DBAL\ParameterType {#2016}
    89 => Doctrine\DBAL\ParameterType {#2016}
    90 => Doctrine\DBAL\ParameterType {#2016}
    91 => Doctrine\DBAL\ParameterType {#2016}
    92 => Doctrine\DBAL\ParameterType {#2016}
    93 => Doctrine\DBAL\ParameterType {#2016}
    94 => Doctrine\DBAL\ParameterType {#2016}
    95 => Doctrine\DBAL\ParameterType {#2016}
    96 => Doctrine\DBAL\ParameterType {#2016}
    97 => Doctrine\DBAL\ParameterType {#2016}
    98 => Doctrine\DBAL\ParameterType {#2016}
    99 => Doctrine\DBAL\ParameterType {#2016}
    100 => Doctrine\DBAL\ParameterType {#2016}
    101 => Doctrine\DBAL\ParameterType {#2016}
    102 => Doctrine\DBAL\ParameterType {#2016}
    103 => Doctrine\DBAL\ParameterType {#2016}
    104 => Doctrine\DBAL\ParameterType {#2016}
    105 => Doctrine\DBAL\ParameterType {#2016}
    106 => Doctrine\DBAL\ParameterType {#2016}
    107 => Doctrine\DBAL\ParameterType {#2016}
    108 => Doctrine\DBAL\ParameterType {#2016}
    109 => Doctrine\DBAL\ParameterType {#2016}
    110 => Doctrine\DBAL\ParameterType {#2016}
    111 => Doctrine\DBAL\ParameterType {#2016}
    112 => Doctrine\DBAL\ParameterType {#2016}
    113 => Doctrine\DBAL\ParameterType {#2016}
    114 => Doctrine\DBAL\ParameterType {#2016}
    115 => Doctrine\DBAL\ParameterType {#2016}
    116 => Doctrine\DBAL\ParameterType {#2016}
    117 => Doctrine\DBAL\ParameterType {#2016}
    118 => Doctrine\DBAL\ParameterType {#2016}
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

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