Symfony Profiler

[
  "route" => "show_rocks"
  "route_parameters" => [
    "_route" => "show_rocks"
    "_controller" => "App\Controller\FrontendController::showRocksArea"
    "slug" => "Donaudurchbruch"
  ]
  "request_uri" => "https://www.munichclimbs.com/Donaudurchbruch"
  "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"
]

[
  "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 t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.orientation AS orientation_4, t0.sequence AS sequence_5, t0.online AS online_6, t0.image AS image_7, t0.header_image AS header_image_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.zoom AS zoom_11, t0.travel_time_minutes AS travel_time_minutes_12, t0.rock_responsibility AS rock_responsibility_13, t0.railway_station AS railway_station_14, t0.kletterkonzeption AS kletterkonzeption_15 FROM area t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "Donaudurchbruch"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#905
      +name: "STRING"
    }
  ]
]

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

[
  "sql" => "SELECT r0_.name AS name_0, r0_.slug AS slug_1, r0_.height AS height_2, r0_.child_friendly AS child_friendly_3, r0_.rain AS rain_4, r0_.train AS train_5, r0_.bike AS bike_6, r0_.lat AS lat_7, r0_.lng AS lng_8, r0_.orientation AS orientation_9, r0_.sunny AS sunny_10, r0_.image AS image_11, r0_.preview_image AS preview_image_12, r0_.banned AS banned_13, a1_.name AS name_14, a1_.slug AS slug_15, COUNT(DISTINCT r2_.id) AS sclr_16, SUM(CASE WHEN r2_.grade_no > 0 AND r2_.grade_no <= 15 THEN 1 ELSE 0 END) AS sclr_17, SUM(CASE WHEN r2_.grade_no > 15 AND r2_.grade_no <= 29 THEN 1 ELSE 0 END) AS sclr_18, SUM(CASE WHEN r2_.grade_no > 29 AND r2_.grade_no <= 65 THEN 1 ELSE 0 END) AS sclr_19, SUM(CASE WHEN r2_.grade_no = 0 OR r2_.grade_no IS NULL THEN 1 ELSE 0 END) AS sclr_20, SUM(CASE WHEN r2_.grade IN (?, ?, ?) THEN 1 ELSE 0 END) AS sclr_21, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_22, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_23, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_24, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_25, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_26, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_27, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_28, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_29 FROM rock r0_ LEFT JOIN area a1_ ON r0_.area_id = a1_.id LEFT JOIN routes r2_ ON r0_.id = r2_.rock_id WHERE a1_.slug LIKE ? AND r0_.online = 1 GROUP BY r0_.id ORDER BY r0_.nr ASC"
  "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"
    119 => "Donaudurchbruch"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#905
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#905}
    3 => Doctrine\DBAL\ParameterType {#905}
    4 => Doctrine\DBAL\ParameterType {#905}
    5 => Doctrine\DBAL\ParameterType {#905}
    6 => Doctrine\DBAL\ParameterType {#905}
    7 => Doctrine\DBAL\ParameterType {#905}
    8 => Doctrine\DBAL\ParameterType {#905}
    9 => Doctrine\DBAL\ParameterType {#905}
    10 => Doctrine\DBAL\ParameterType {#905}
    11 => Doctrine\DBAL\ParameterType {#905}
    12 => Doctrine\DBAL\ParameterType {#905}
    13 => Doctrine\DBAL\ParameterType {#905}
    14 => Doctrine\DBAL\ParameterType {#905}
    15 => Doctrine\DBAL\ParameterType {#905}
    16 => Doctrine\DBAL\ParameterType {#905}
    17 => Doctrine\DBAL\ParameterType {#905}
    18 => Doctrine\DBAL\ParameterType {#905}
    19 => Doctrine\DBAL\ParameterType {#905}
    20 => Doctrine\DBAL\ParameterType {#905}
    21 => Doctrine\DBAL\ParameterType {#905}
    22 => Doctrine\DBAL\ParameterType {#905}
    23 => Doctrine\DBAL\ParameterType {#905}
    24 => Doctrine\DBAL\ParameterType {#905}
    25 => Doctrine\DBAL\ParameterType {#905}
    26 => Doctrine\DBAL\ParameterType {#905}
    27 => Doctrine\DBAL\ParameterType {#905}
    28 => Doctrine\DBAL\ParameterType {#905}
    29 => Doctrine\DBAL\ParameterType {#905}
    30 => Doctrine\DBAL\ParameterType {#905}
    31 => Doctrine\DBAL\ParameterType {#905}
    32 => Doctrine\DBAL\ParameterType {#905}
    33 => Doctrine\DBAL\ParameterType {#905}
    34 => Doctrine\DBAL\ParameterType {#905}
    35 => Doctrine\DBAL\ParameterType {#905}
    36 => Doctrine\DBAL\ParameterType {#905}
    37 => Doctrine\DBAL\ParameterType {#905}
    38 => Doctrine\DBAL\ParameterType {#905}
    39 => Doctrine\DBAL\ParameterType {#905}
    40 => Doctrine\DBAL\ParameterType {#905}
    41 => Doctrine\DBAL\ParameterType {#905}
    42 => Doctrine\DBAL\ParameterType {#905}
    43 => Doctrine\DBAL\ParameterType {#905}
    44 => Doctrine\DBAL\ParameterType {#905}
    45 => Doctrine\DBAL\ParameterType {#905}
    46 => Doctrine\DBAL\ParameterType {#905}
    47 => Doctrine\DBAL\ParameterType {#905}
    48 => Doctrine\DBAL\ParameterType {#905}
    49 => Doctrine\DBAL\ParameterType {#905}
    50 => Doctrine\DBAL\ParameterType {#905}
    51 => Doctrine\DBAL\ParameterType {#905}
    52 => Doctrine\DBAL\ParameterType {#905}
    53 => Doctrine\DBAL\ParameterType {#905}
    54 => Doctrine\DBAL\ParameterType {#905}
    55 => Doctrine\DBAL\ParameterType {#905}
    56 => Doctrine\DBAL\ParameterType {#905}
    57 => Doctrine\DBAL\ParameterType {#905}
    58 => Doctrine\DBAL\ParameterType {#905}
    59 => Doctrine\DBAL\ParameterType {#905}
    60 => Doctrine\DBAL\ParameterType {#905}
    61 => Doctrine\DBAL\ParameterType {#905}
    62 => Doctrine\DBAL\ParameterType {#905}
    63 => Doctrine\DBAL\ParameterType {#905}
    64 => Doctrine\DBAL\ParameterType {#905}
    65 => Doctrine\DBAL\ParameterType {#905}
    66 => Doctrine\DBAL\ParameterType {#905}
    67 => Doctrine\DBAL\ParameterType {#905}
    68 => Doctrine\DBAL\ParameterType {#905}
    69 => Doctrine\DBAL\ParameterType {#905}
    70 => Doctrine\DBAL\ParameterType {#905}
    71 => Doctrine\DBAL\ParameterType {#905}
    72 => Doctrine\DBAL\ParameterType {#905}
    73 => Doctrine\DBAL\ParameterType {#905}
    74 => Doctrine\DBAL\ParameterType {#905}
    75 => Doctrine\DBAL\ParameterType {#905}
    76 => Doctrine\DBAL\ParameterType {#905}
    77 => Doctrine\DBAL\ParameterType {#905}
    78 => Doctrine\DBAL\ParameterType {#905}
    79 => Doctrine\DBAL\ParameterType {#905}
    80 => Doctrine\DBAL\ParameterType {#905}
    81 => Doctrine\DBAL\ParameterType {#905}
    82 => Doctrine\DBAL\ParameterType {#905}
    83 => Doctrine\DBAL\ParameterType {#905}
    84 => Doctrine\DBAL\ParameterType {#905}
    85 => Doctrine\DBAL\ParameterType {#905}
    86 => Doctrine\DBAL\ParameterType {#905}
    87 => Doctrine\DBAL\ParameterType {#905}
    88 => Doctrine\DBAL\ParameterType {#905}
    89 => Doctrine\DBAL\ParameterType {#905}
    90 => Doctrine\DBAL\ParameterType {#905}
    91 => Doctrine\DBAL\ParameterType {#905}
    92 => Doctrine\DBAL\ParameterType {#905}
    93 => Doctrine\DBAL\ParameterType {#905}
    94 => Doctrine\DBAL\ParameterType {#905}
    95 => Doctrine\DBAL\ParameterType {#905}
    96 => Doctrine\DBAL\ParameterType {#905}
    97 => Doctrine\DBAL\ParameterType {#905}
    98 => Doctrine\DBAL\ParameterType {#905}
    99 => Doctrine\DBAL\ParameterType {#905}
    100 => Doctrine\DBAL\ParameterType {#905}
    101 => Doctrine\DBAL\ParameterType {#905}
    102 => Doctrine\DBAL\ParameterType {#905}
    103 => Doctrine\DBAL\ParameterType {#905}
    104 => Doctrine\DBAL\ParameterType {#905}
    105 => Doctrine\DBAL\ParameterType {#905}
    106 => Doctrine\DBAL\ParameterType {#905}
    107 => Doctrine\DBAL\ParameterType {#905}
    108 => Doctrine\DBAL\ParameterType {#905}
    109 => Doctrine\DBAL\ParameterType {#905}
    110 => Doctrine\DBAL\ParameterType {#905}
    111 => Doctrine\DBAL\ParameterType {#905}
    112 => Doctrine\DBAL\ParameterType {#905}
    113 => Doctrine\DBAL\ParameterType {#905}
    114 => Doctrine\DBAL\ParameterType {#905}
    115 => Doctrine\DBAL\ParameterType {#905}
    116 => Doctrine\DBAL\ParameterType {#905}
    117 => Doctrine\DBAL\ParameterType {#905}
    118 => Doctrine\DBAL\ParameterType {#905}
    119 => Doctrine\DBAL\ParameterType {#905}
  ]
]

[
  "key" => "area_route_grades_Donaudurchbruch"
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.slug AS slug_1, r1_.grade_no AS grade_no_2 FROM rock r0_ LEFT JOIN area a2_ ON r0_.area_id = a2_.id LEFT JOIN routes r1_ ON r0_.id = r1_.rock_id WHERE a2_.slug LIKE ? AND r0_.online = 1 AND r1_.grade_no IS NOT NULL ORDER BY r0_.id ASC, r1_.grade_no ASC"
  "params" => [
    1 => "Donaudurchbruch"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#905
      +name: "STRING"
    }
  ]
]

[
  "key" => "area_top100_routes_3"
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.grade AS grade_2, r0_.grade_no AS grade_no_3, r0_.first_ascent AS first_ascent_4, r0_.year_first_ascent AS year_first_ascent_5, r0_.rating AS rating_6, r0_.protection AS protection_7, r0_.rock_quality AS rock_quality_8, r0_.climbing_style AS climbing_style_9, r1_.name AS name_10, r1_.slug AS slug_11, a2_.slug AS slug_12 FROM routes r0_ LEFT JOIN rock r1_ ON r0_.rock_id = r1_.id LEFT JOIN area a2_ ON r0_.area_id = a2_.id WHERE a2_.id = ? AND r0_.grade_no IS NOT NULL AND r1_.online = 1 ORDER BY r0_.grade_no DESC, r0_.name ASC LIMIT 100"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1007
      +name: "INTEGER"
    }
  ]
]

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