Symfony Profiler

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

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 = 'Obere_Vilstalwaende' LIMIT 1;

SELECT
  r0_.id AS id_0
FROM
  rock r0_
WHERE
  r0_.slug LIKE ?

SELECT r0_.id AS id_0 FROM rock r0_ WHERE r0_.slug LIKE 'Obere_Vilstalwaende';

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

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 1019 AND t0_.with_sector = 1 ORDER BY t0_.number ASC;

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

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 ('3-', 3, '3+') THEN 1 ELSE 0 END) AS sclr_24, SUM(CASE WHEN r2_.grade IN ('4-', 4, '4a', '4b', '4c', '4c+', '4+') THEN 1 ELSE 0 END) AS sclr_25, SUM(CASE WHEN r2_.grade IN ('5-', 5, '5/5+', '5+', '5a', '5a/5b+', 'FB 3') THEN 1 ELSE 0 END) AS sclr_26, SUM(CASE WHEN r2_.grade IN ('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+') THEN 1 ELSE 0 END) AS sclr_27, SUM(CASE WHEN r2_.grade IN ('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+') THEN 1 ELSE 0 END) AS sclr_28, SUM(CASE WHEN r2_.grade IN ('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') THEN 1 ELSE 0 END) AS sclr_29, SUM(CASE WHEN r2_.grade IN ('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+') THEN 1 ELSE 0 END) AS sclr_30, SUM(CASE WHEN r2_.grade IN ('9+/10-', '9a/9a+', '9a+', '10-', '10-/10', 10, '10/10+', '10+', '9b', 'FB 7C', 'FB 7C+', 'FB 8A') THEN 1 ELSE 0 END) AS sclr_31, SUM(CASE WHEN r2_.grade IN ('10+/11-', '11-', '11-/11', 11, '9b+', 'FB 8A+', 'FB 8B', 'FB 8B+', 'FB 8C', 'FB 8C+', 'FB 9A') 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 'Obere_Vilstalwaende' AND r0_.online = 1 GROUP BY r0_.id ORDER BY r0_.id ASC;

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

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 'Obere_Vilstalwaende' AND r2_.rock_id = t3_.rocks_id AND r2_.topo_id = t3_.number ORDER BY r1_.id ASC, t3_.number ASC, r2_.nr ASC;

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 ?

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 'Obere_Vilstalwaende';

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 = ?

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 = 'Obere_Vilstalwaende' AND r0_.locale = 'de';

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

SELECT COUNT(r0_.id) AS sclr_0 FROM rock r1_ LEFT JOIN rock_translation r0_ ON r1_.id = r0_.rock_id WHERE r1_.slug = 'Obere_Vilstalwaende' AND r0_.locale = 'de' AND r0_.description IS NOT NULL;

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

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 = 1019 AND p0_.status = 'approved' ORDER BY p0_.created_at DESC;

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 = 5;