| 1 |
12.93 ms |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.grade AS grade_2, r0_.climbed AS climbed_3, r0_.first_ascent AS first_ascent_4, r0_.year_first_ascent AS year_first_ascent_5, r0_.protection AS protection_6, r0_.scale AS scale_7, r0_.grade_no AS grade_no_8, r0_.rating AS rating_9, r0_.topo_id AS topo_id_10, r0_.nr AS nr_11, r0_.rock_quality AS rock_quality_12, r0_.climbing_style AS climbing_style_13, r0_.area_id AS area_id_14, r0_.rock_id AS rock_id_15 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id WHERE r0_.year_first_ascent >= ? ORDER BY r0_.year_first_ascent DESC
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.grade AS grade_2, r0_.climbed AS climbed_3, r0_.first_ascent AS first_ascent_4, r0_.year_first_ascent AS year_first_ascent_5, r0_.protection AS protection_6, r0_.scale AS scale_7, r0_.grade_no AS grade_no_8, r0_.rating AS rating_9, r0_.topo_id AS topo_id_10, r0_.nr AS nr_11, r0_.rock_quality AS rock_quality_12, r0_.climbing_style AS climbing_style_13, r0_.area_id AS area_id_14, r0_.rock_id AS rock_id_15 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id WHERE r0_.year_first_ascent >= 2024 ORDER BY r0_.year_first_ascent DESC;
|
| 2 |
1.16 ms |
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 = ?
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 = 2;
|
| 3 |
1.04 ms |
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.id = ?
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.id = 714;
|
| 4 |
1.36 ms |
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.id = ?
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.id = 709;
|
| 5 |
0.81 ms |
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.id = ?
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.id = 730;
|
| 6 |
0.67 ms |
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.id = ?
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.id = 733;
|
| 7 |
0.70 ms |
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.id = ?
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.id = 735;
|
| 8 |
0.64 ms |
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.id = ?
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.id = 919;
|
| 9 |
0.58 ms |
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 = ?
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 = 15;
|
| 10 |
0.62 ms |
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.id = ?
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.id = 975;
|
| 11 |
0.78 ms |
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 = ?
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 = 4;
|
| 12 |
0.63 ms |
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.id = ?
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.id = 981;
|
| 13 |
0.47 ms |
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.id = ?
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.id = 725;
|
| 14 |
0.46 ms |
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.id = ?
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.id = 734;
|