GET https://www.munichclimbs.com/Konstein

Response
200 OK
IP
216.73.216.255
Profiled on
Token
77fd38

Query Metrics

6 Database Queries
6 Different statements
31.14 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
16.47 ms
(52.89%) 		1 
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
Parameters: 
[
  "3-"
  3
  "3+"
  "4-"
  4
  "4a"
  "4b"
  "4c"
  "4c+"
  "4+"
  "5-"
  5
  "5/5+"
  "5+"
  "5a"
  "5a/5b+"
  "FB 3"
  "5+/6-"
  "5a+"
  "5b"
  "5b+"
  "5c"
  "5c+"
  "6-"
  "6-/6"
  6
  "6/6+"
  "6+"
  "6a"
  "6a/6a+"
  "6a+"
  "6a+/6b"
  "6b"
  "FB 4-"
  "FB 4"
  "FB 4+"
  "6+/7-"
  "6b/6b+"
  "6b+"
  "6c"
  "6c+"
  "6c+/7a"
  "7-"
  "7-/7"
  7
  "7/7+"
  "7+"
  "7a"
  "7a/7a+"
  "7a+"
  "7b"
  "7b+"
  "6b+/6c"
  "7a+/7b"
  "FB 5"
  "FB 5+"
  "FB 6A"
  "FB 6A+"
  "FB 6B"
  "FB 6B+"
  "7+/8-"
  "7b+/7c"
  "7c"
  "7c/7c+"
  "7c+"
  "8-"
  "8-/8"
  8
  "8/8+"
  "8+"
  "8a"
  "8a/8a+"
  "8a+"
  "8a+/8b"
  "8b"
  "7c+/8a"
  "FB 6C"
  "FB 6C+"
  "FB 7A"
  "8+/9-"
  "8b/8b+"
  "8b+"
  "8b+/8c"
  "8c"
  "8c+"
  "8c+/9a"
  "9-"
  "9-/9"
  9
  "9/9+"
  "9+"
  "9a"
  "FB 7A+"
  "FB 7B"
  "FB 7B+"
  "9+/10-"
  "9a/9a+"
  "9a+"
  "10-"
  "10-/10"
  10
  "10/10+"
  "10+"
  "9b"
  "FB 7C"
  "FB 7C+"
  "FB 8A"
  "10+/11-"
  "11-"
  "11-/11"
  11
  "9b+"
  "FB 8A+"
  "FB 8B"
  "FB 8B+"
  "FB 8C"
  "FB 8C+"
  "FB 9A"
  "Konstein"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.53 ms
(20.96%) 		1 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3.60 ms
(11.57%) 		1 
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
Parameters: 
[
  "Konstein"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.23 ms
(7.16%) 		1 
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.image AS image_3, r1_.id AS id_4, r1_.name AS name_5, r1_.slug AS slug_6 FROM area a0_ LEFT JOIN rock r1_ ON a0_.id = r1_.area_id WHERE a0_.online = 1 AND r1_.online = 1 ORDER BY a0_.sequence ASC, r1_.nr ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.32 ms
(4.23%) 		1 
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM area a0_ LEFT JOIN rock r1_ ON a0_.id = r1_.area_id WHERE a0_.online = 1 GROUP BY a0_.id, a0_.name ORDER BY a0_.sequence ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.99 ms
(3.19%) 		1 
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
Parameters: 
[
  "Konstein"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Area 1

Entities Mapping

Class Mapping errors
App\Entity\Area No errors.
App\Entity\Rock No errors.
App\Entity\Routes No errors.