Symfony Profiler

[
  "route" => "show_rock"
  "route_parameters" => [
    "_route" => "show_rock"
    "_locale" => "de"
    "_controller" => "App\Controller\FrontendController::showRock"
    "areaSlug" => "Zwischen_Rosenheim_und_Kufstein"
    "slug" => "Schlossberg"
  ]
  "request_uri" => "https://www.munichclimbs.com/Zwischen_Rosenheim_und_Kufstein/Schlossberg"
  "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.nr AS nr_4, t0.zone AS zone_5, t0.banned AS banned_6, t0.height AS height_7, t0.orientation AS orientation_8, t0.season AS season_9, t0.child_friendly AS child_friendly_10, t0.sunny AS sunny_11, t0.rain AS rain_12, t0.image AS image_13, t0.lat AS lat_14, t0.lng AS lng_15, t0.online AS online_16, t0.path_coordinates AS path_coordinates_17, t0.zoom AS zoom_18, t0.preview_image AS preview_image_19, t0.train AS train_20, t0.bike AS bike_21, t0.area_id AS area_id_22 FROM rock t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "Schlossberg"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1221
      +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"
]

[
  "sql" => "SELECT r0_.id AS id_0 FROM rock r0_ WHERE r0_.slug LIKE ?"
  "params" => [
    1 => "Schlossberg"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1221
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0_.name AS name_0, t0_.number AS number_1 FROM topo t0_ INNER JOIN rock r1_ ON t0_.rocks_id = r1_.id WHERE r1_.id LIKE ? AND t0_.with_sector = 1 ORDER BY t0_.number ASC"
  "params" => [
    1 => 947
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1219
      +name: "INTEGER"
    }
  ]
]

[
  "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_.zone AS zone_9, r0_.zoom AS zoom_10, r0_.path_coordinates AS path_coordinates_11, r0_.orientation AS orientation_12, r0_.sunny AS sunny_13, r0_.image AS image_14, r0_.season AS season_15, r0_.banned AS banned_16, a1_.name AS name_17, a1_.slug AS slug_18, COUNT(DISTINCT r2_.id) AS sclr_19, SUM(CASE WHEN r2_.grade_no > 0 AND r2_.grade_no <= 15 THEN 1 ELSE 0 END) AS sclr_20, SUM(CASE WHEN r2_.grade_no > 15 AND r2_.grade_no <= 29 THEN 1 ELSE 0 END) AS sclr_21, SUM(CASE WHEN r2_.grade_no > 29 AND r2_.grade_no <= 65 THEN 1 ELSE 0 END) AS sclr_22, SUM(CASE WHEN r2_.grade_no = 0 OR r2_.grade_no IS NULL 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, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_30, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_31, SUM(CASE WHEN r2_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN 1 ELSE 0 END) AS sclr_32 FROM rock r0_ LEFT JOIN area a1_ ON r0_.area_id = a1_.id LEFT JOIN routes r2_ ON r0_.id = r2_.rock_id WHERE r0_.slug LIKE ? AND r0_.online = 1 GROUP BY r0_.id ORDER BY r0_.id 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 => "Schlossberg"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1221
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1221}
    3 => Doctrine\DBAL\ParameterType {#1221}
    4 => Doctrine\DBAL\ParameterType {#1221}
    5 => Doctrine\DBAL\ParameterType {#1221}
    6 => Doctrine\DBAL\ParameterType {#1221}
    7 => Doctrine\DBAL\ParameterType {#1221}
    8 => Doctrine\DBAL\ParameterType {#1221}
    9 => Doctrine\DBAL\ParameterType {#1221}
    10 => Doctrine\DBAL\ParameterType {#1221}
    11 => Doctrine\DBAL\ParameterType {#1221}
    12 => Doctrine\DBAL\ParameterType {#1221}
    13 => Doctrine\DBAL\ParameterType {#1221}
    14 => Doctrine\DBAL\ParameterType {#1221}
    15 => Doctrine\DBAL\ParameterType {#1221}
    16 => Doctrine\DBAL\ParameterType {#1221}
    17 => Doctrine\DBAL\ParameterType {#1221}
    18 => Doctrine\DBAL\ParameterType {#1221}
    19 => Doctrine\DBAL\ParameterType {#1221}
    20 => Doctrine\DBAL\ParameterType {#1221}
    21 => Doctrine\DBAL\ParameterType {#1221}
    22 => Doctrine\DBAL\ParameterType {#1221}
    23 => Doctrine\DBAL\ParameterType {#1221}
    24 => Doctrine\DBAL\ParameterType {#1221}
    25 => Doctrine\DBAL\ParameterType {#1221}
    26 => Doctrine\DBAL\ParameterType {#1221}
    27 => Doctrine\DBAL\ParameterType {#1221}
    28 => Doctrine\DBAL\ParameterType {#1221}
    29 => Doctrine\DBAL\ParameterType {#1221}
    30 => Doctrine\DBAL\ParameterType {#1221}
    31 => Doctrine\DBAL\ParameterType {#1221}
    32 => Doctrine\DBAL\ParameterType {#1221}
    33 => Doctrine\DBAL\ParameterType {#1221}
    34 => Doctrine\DBAL\ParameterType {#1221}
    35 => Doctrine\DBAL\ParameterType {#1221}
    36 => Doctrine\DBAL\ParameterType {#1221}
    37 => Doctrine\DBAL\ParameterType {#1221}
    38 => Doctrine\DBAL\ParameterType {#1221}
    39 => Doctrine\DBAL\ParameterType {#1221}
    40 => Doctrine\DBAL\ParameterType {#1221}
    41 => Doctrine\DBAL\ParameterType {#1221}
    42 => Doctrine\DBAL\ParameterType {#1221}
    43 => Doctrine\DBAL\ParameterType {#1221}
    44 => Doctrine\DBAL\ParameterType {#1221}
    45 => Doctrine\DBAL\ParameterType {#1221}
    46 => Doctrine\DBAL\ParameterType {#1221}
    47 => Doctrine\DBAL\ParameterType {#1221}
    48 => Doctrine\DBAL\ParameterType {#1221}
    49 => Doctrine\DBAL\ParameterType {#1221}
    50 => Doctrine\DBAL\ParameterType {#1221}
    51 => Doctrine\DBAL\ParameterType {#1221}
    52 => Doctrine\DBAL\ParameterType {#1221}
    53 => Doctrine\DBAL\ParameterType {#1221}
    54 => Doctrine\DBAL\ParameterType {#1221}
    55 => Doctrine\DBAL\ParameterType {#1221}
    56 => Doctrine\DBAL\ParameterType {#1221}
    57 => Doctrine\DBAL\ParameterType {#1221}
    58 => Doctrine\DBAL\ParameterType {#1221}
    59 => Doctrine\DBAL\ParameterType {#1221}
    60 => Doctrine\DBAL\ParameterType {#1221}
    61 => Doctrine\DBAL\ParameterType {#1221}
    62 => Doctrine\DBAL\ParameterType {#1221}
    63 => Doctrine\DBAL\ParameterType {#1221}
    64 => Doctrine\DBAL\ParameterType {#1221}
    65 => Doctrine\DBAL\ParameterType {#1221}
    66 => Doctrine\DBAL\ParameterType {#1221}
    67 => Doctrine\DBAL\ParameterType {#1221}
    68 => Doctrine\DBAL\ParameterType {#1221}
    69 => Doctrine\DBAL\ParameterType {#1221}
    70 => Doctrine\DBAL\ParameterType {#1221}
    71 => Doctrine\DBAL\ParameterType {#1221}
    72 => Doctrine\DBAL\ParameterType {#1221}
    73 => Doctrine\DBAL\ParameterType {#1221}
    74 => Doctrine\DBAL\ParameterType {#1221}
    75 => Doctrine\DBAL\ParameterType {#1221}
    76 => Doctrine\DBAL\ParameterType {#1221}
    77 => Doctrine\DBAL\ParameterType {#1221}
    78 => Doctrine\DBAL\ParameterType {#1221}
    79 => Doctrine\DBAL\ParameterType {#1221}
    80 => Doctrine\DBAL\ParameterType {#1221}
    81 => Doctrine\DBAL\ParameterType {#1221}
    82 => Doctrine\DBAL\ParameterType {#1221}
    83 => Doctrine\DBAL\ParameterType {#1221}
    84 => Doctrine\DBAL\ParameterType {#1221}
    85 => Doctrine\DBAL\ParameterType {#1221}
    86 => Doctrine\DBAL\ParameterType {#1221}
    87 => Doctrine\DBAL\ParameterType {#1221}
    88 => Doctrine\DBAL\ParameterType {#1221}
    89 => Doctrine\DBAL\ParameterType {#1221}
    90 => Doctrine\DBAL\ParameterType {#1221}
    91 => Doctrine\DBAL\ParameterType {#1221}
    92 => Doctrine\DBAL\ParameterType {#1221}
    93 => Doctrine\DBAL\ParameterType {#1221}
    94 => Doctrine\DBAL\ParameterType {#1221}
    95 => Doctrine\DBAL\ParameterType {#1221}
    96 => Doctrine\DBAL\ParameterType {#1221}
    97 => Doctrine\DBAL\ParameterType {#1221}
    98 => Doctrine\DBAL\ParameterType {#1221}
    99 => Doctrine\DBAL\ParameterType {#1221}
    100 => Doctrine\DBAL\ParameterType {#1221}
    101 => Doctrine\DBAL\ParameterType {#1221}
    102 => Doctrine\DBAL\ParameterType {#1221}
    103 => Doctrine\DBAL\ParameterType {#1221}
    104 => Doctrine\DBAL\ParameterType {#1221}
    105 => Doctrine\DBAL\ParameterType {#1221}
    106 => Doctrine\DBAL\ParameterType {#1221}
    107 => Doctrine\DBAL\ParameterType {#1221}
    108 => Doctrine\DBAL\ParameterType {#1221}
    109 => Doctrine\DBAL\ParameterType {#1221}
    110 => Doctrine\DBAL\ParameterType {#1221}
    111 => Doctrine\DBAL\ParameterType {#1221}
    112 => Doctrine\DBAL\ParameterType {#1221}
    113 => Doctrine\DBAL\ParameterType {#1221}
    114 => Doctrine\DBAL\ParameterType {#1221}
    115 => Doctrine\DBAL\ParameterType {#1221}
    116 => Doctrine\DBAL\ParameterType {#1221}
    117 => Doctrine\DBAL\ParameterType {#1221}
    118 => Doctrine\DBAL\ParameterType {#1221}
    119 => Doctrine\DBAL\ParameterType {#1221}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, r1_.id AS id_1, r2_.id AS id_2, r2_.name AS name_3, r2_.grade AS grade_4, r2_.topo_id AS topo_id_5, r2_.rating AS rating_6, r2_.protection AS protection_7, r2_.rock_quality AS rock_quality_8, r2_.climbing_style AS climbing_style_9, r2_.first_ascent AS first_ascent_10, r2_.year_first_ascent AS year_first_ascent_11, t3_.name AS name_12, t3_.number AS number_13, v4_.video_link AS video_link_14, t3_.image AS image_15, t3_.path_collection AS path_collection_16, t3_.with_sector AS with_sector_17 FROM rock r1_ INNER JOIN area a0_ ON r1_.area_id = a0_.id INNER JOIN routes r2_ ON r1_.id = r2_.rock_id INNER JOIN topo t3_ ON (t3_.rocks_id = r1_.id) LEFT JOIN videos v4_ ON (v4_.video_routes_id = r2_.id) WHERE r1_.slug LIKE ? AND r2_.rock_id = t3_.rocks_id AND r2_.topo_id = t3_.number ORDER BY r1_.id ASC, t3_.number ASC, r2_.nr ASC"
  "params" => [
    1 => "Schlossberg"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1221
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, c1_.comment AS comment_1, c1_.datetime AS datetime_2, u2_.username AS username_3 FROM routes r0_ INNER JOIN comment c1_ ON r0_.id = c1_.route_id LEFT JOIN `user` u2_ ON c1_.user_id = u2_.id INNER JOIN rock r3_ ON r0_.rock_id = r3_.id WHERE r3_.slug LIKE ?"
  "params" => [
    1 => "Schlossberg"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1221
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT r0_.description AS description_0, r0_.access AS access_1, r0_.nature AS nature_2, r0_.flowers AS flowers_3 FROM rock r1_ LEFT JOIN rock_translation r0_ ON r1_.id = r0_.rock_id WHERE r1_.slug = ? AND r0_.locale = ?"
  "params" => [
    1 => "Schlossberg"
    2 => "de"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1221
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1221}
  ]
]

[
  "sql" => "SELECT COUNT(r0_.id) AS sclr_0 FROM rock r1_ LEFT JOIN rock_translation r0_ ON r1_.id = r0_.rock_id WHERE r1_.slug = ? AND r0_.locale = ? AND r0_.description IS NOT NULL"
  "params" => [
    1 => "Schlossberg"
    2 => "de"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1221
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1221}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.photgrapher AS photgrapher_3, p0_.status AS status_4, p0_.created_at AS created_at_5, p0_.uploader_name AS uploader_name_6, p0_.uploader_email AS uploader_email_7, p0_.belongs_to_area_id AS belongs_to_area_id_8, p0_.belongs_to_rock_id AS belongs_to_rock_id_9, p0_.belongs_to_route_id AS belongs_to_route_id_10 FROM photos p0_ WHERE p0_.belongs_to_rock_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC"
  "params" => [
    1 => 947
    2 => "approved"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1219
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1221
      +name: "STRING"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1219
      +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"
]