| 1 |
11.92 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_.description AS description_7, r0_.scale AS scale_8, r0_.grade_no AS grade_no_9, r0_.rating AS rating_10, r0_.topo_id AS topo_id_11, r0_.nr AS nr_12, r0_.rock_quality AS rock_quality_13, r0_.area_id AS area_id_14, r0_.rock_id AS rock_id_15, r0_.relates_to_route_id AS relates_to_route_id_16 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_.description AS description_7, r0_.scale AS scale_8, r0_.grade_no AS grade_no_9, r0_.rating AS rating_10, r0_.topo_id AS topo_id_11, r0_.nr AS nr_12, r0_.rock_quality AS rock_quality_13, r0_.area_id AS area_id_14, r0_.rock_id AS rock_id_15, r0_.relates_to_route_id AS relates_to_route_id_16 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id WHERE r0_.year_first_ascent >= 2023 ORDER BY r0_.year_first_ascent DESC;
|
| 2 |
2.26 ms |
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
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;
|
| 3 |
0.81 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 FROM area t0 WHERE t0.id = 2;
|
| 4 |
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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 733;
|
| 5 |
0.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 730;
|
| 6 |
0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 734;
|
| 7 |
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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 725;
|
| 8 |
0.48 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 FROM area t0 WHERE t0.id = 4;
|
| 9 |
0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 981;
|
| 10 |
0.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 919;
|
| 11 |
0.53 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 FROM area t0 WHERE t0.id = 15;
|
| 12 |
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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 975;
|
| 13 |
0.50 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 FROM area t0 WHERE t0.id = 1;
|
| 14 |
0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 5;
|
| 15 |
0.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 708;
|
| 16 |
0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 709;
|
| 17 |
0.50 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13, t0.kletterkonzeption AS kletterkonzeption_14 FROM area t0 WHERE t0.id = 8;
|
| 18 |
0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 968;
|
| 19 |
0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 26;
|
| 20 |
0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 964;
|
| 21 |
0.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 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.description AS description_5, t0.access AS access_6, t0.nature AS nature_7, t0.zone AS zone_8, t0.banned AS banned_9, t0.height AS height_10, t0.orientation AS orientation_11, t0.season AS season_12, t0.child_friendly AS child_friendly_13, t0.sunny AS sunny_14, t0.rain AS rain_15, t0.image AS image_16, t0.header_image AS header_image_17, t0.lat AS lat_18, t0.lng AS lng_19, t0.online AS online_20, t0.path_coordinates AS path_coordinates_21, t0.zoom AS zoom_22, t0.preview_image AS preview_image_23, t0.train AS train_24, t0.area_id AS area_id_25 FROM rock t0 WHERE t0.id = 960;
|
| 22 |
1.03 ms |
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
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;
|