Symfony Profiler

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
ORDER BY
  r0_.year_first_ascent DESC
LIMIT
  5

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 ORDER BY r0_.year_first_ascent DESC LIMIT 5;

SELECT
  c0_.id AS id_0,
  c0_.comment AS comment_1,
  c0_.datetime AS datetime_2,
  u1_.firstname AS firstname_3,
  r2_.name AS name_4,
  r3_.slug AS slug_5,
  r3_.name AS name_6,
  a4_.slug AS slug_7,
  c0_.comment AS comment_8,
  c0_.datetime AS datetime_9,
  c0_.user_id AS user_id_10,
  c0_.route_id AS route_id_11
FROM
  comment c0_
  INNER JOIN `user` u1_ ON c0_.user_id = u1_.id
  INNER JOIN routes r2_ ON c0_.route_id = r2_.id
  INNER JOIN rock r3_ ON r2_.rock_id = r3_.id
  INNER JOIN area a4_ ON r2_.area_id = a4_.id
WHERE
  c0_.datetime IS NOT NULL
ORDER BY
  c0_.datetime DESC
LIMIT
  5

SELECT c0_.id AS id_0, c0_.comment AS comment_1, c0_.datetime AS datetime_2, u1_.firstname AS firstname_3, r2_.name AS name_4, r3_.slug AS slug_5, r3_.name AS name_6, a4_.slug AS slug_7, c0_.comment AS comment_8, c0_.datetime AS datetime_9, c0_.user_id AS user_id_10, c0_.route_id AS route_id_11 FROM comment c0_ INNER JOIN `user` u1_ ON c0_.user_id = u1_.id INNER JOIN routes r2_ ON c0_.route_id = r2_.id INNER JOIN rock r3_ ON r2_.rock_id = r3_.id INNER JOIN area a4_ ON r2_.area_id = a4_.id WHERE c0_.datetime IS NOT NULL ORDER BY c0_.datetime DESC LIMIT 5;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.slug AS slug_2,
  r0_.nr AS nr_3,
  r0_.description AS description_4,
  r0_.access AS access_5,
  r0_.nature AS nature_6,
  r0_.zone AS zone_7,
  r0_.banned AS banned_8,
  r0_.height AS height_9,
  r0_.orientation AS orientation_10,
  r0_.season AS season_11,
  r0_.child_friendly AS child_friendly_12,
  r0_.sunny AS sunny_13,
  r0_.rain AS rain_14,
  r0_.image AS image_15,
  r0_.header_image AS header_image_16,
  r0_.lat AS lat_17,
  r0_.lng AS lng_18,
  r0_.online AS online_19,
  r0_.path_coordinates AS path_coordinates_20,
  r0_.zoom AS zoom_21,
  r0_.preview_image AS preview_image_22,
  r0_.train AS train_23,
  r0_.area_id AS area_id_24
FROM
  rock r0_
WHERE
  r0_.banned = 1
  OR r0_.banned = 2
ORDER BY
  r0_.banned ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.nr AS nr_3, r0_.description AS description_4, r0_.access AS access_5, r0_.nature AS nature_6, r0_.zone AS zone_7, r0_.banned AS banned_8, r0_.height AS height_9, r0_.orientation AS orientation_10, r0_.season AS season_11, r0_.child_friendly AS child_friendly_12, r0_.sunny AS sunny_13, r0_.rain AS rain_14, r0_.image AS image_15, r0_.header_image AS header_image_16, r0_.lat AS lat_17, r0_.lng AS lng_18, r0_.online AS online_19, r0_.path_coordinates AS path_coordinates_20, r0_.zoom AS zoom_21, r0_.preview_image AS preview_image_22, r0_.train AS train_23, r0_.area_id AS area_id_24 FROM rock r0_ WHERE r0_.banned = 1 OR r0_.banned = 2 ORDER BY r0_.banned ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.image AS image_3,
  a0_.lat AS lat_4,
  a0_.lng AS lng_5,
  COUNT(DISTINCT r1_.id) AS sclr_6,
  COUNT(DISTINCT r2_.id) AS sclr_7,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 0
    AND r1_.grade_no <= 15 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_8,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 15
    AND r1_.grade_no <= 29 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_9,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 29
    AND r1_.grade_no <= 60 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_10,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no = 0
    OR r1_.grade_no IS NULL THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_11
FROM
  area a0_
  LEFT JOIN routes r1_ ON a0_.id = r1_.area_id
  LEFT JOIN rock r2_ ON a0_.id = r2_.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, a0_.image AS image_3, a0_.lat AS lat_4, a0_.lng AS lng_5, COUNT(DISTINCT r1_.id) AS sclr_6, COUNT(DISTINCT r2_.id) AS sclr_7, COUNT(DISTINCT CASE WHEN r1_.grade_no > 0 AND r1_.grade_no <= 15 THEN r1_.id ELSE 0 END) AS sclr_8, COUNT(DISTINCT CASE WHEN r1_.grade_no > 15 AND r1_.grade_no <= 29 THEN r1_.id ELSE 0 END) AS sclr_9, COUNT(DISTINCT CASE WHEN r1_.grade_no > 29 AND r1_.grade_no <= 60 THEN r1_.id ELSE 0 END) AS sclr_10, COUNT(DISTINCT CASE WHEN r1_.grade_no = 0 OR r1_.grade_no IS NULL THEN r1_.id ELSE 0 END) AS sclr_11 FROM area a0_ LEFT JOIN routes r1_ ON a0_.id = r1_.area_id LEFT JOIN rock r2_ ON a0_.id = r2_.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,
  a0_.image AS image_3,
  a0_.lat AS lat_4,
  a0_.lng AS lng_5,
  COUNT(DISTINCT r1_.id) AS sclr_6,
  COUNT(DISTINCT r2_.id) AS sclr_7,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 0
    AND r1_.grade_no <= 15 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_8,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 15
    AND r1_.grade_no <= 29 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_9,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 29
    AND r1_.grade_no <= 60 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_10,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no = 0
    OR r1_.grade_no IS NULL THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_11
FROM
  area a0_
  LEFT JOIN routes r1_ ON a0_.id = r1_.area_id
  LEFT JOIN rock r2_ ON a0_.id = r2_.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, a0_.image AS image_3, a0_.lat AS lat_4, a0_.lng AS lng_5, COUNT(DISTINCT r1_.id) AS sclr_6, COUNT(DISTINCT r2_.id) AS sclr_7, COUNT(DISTINCT CASE WHEN r1_.grade_no > 0 AND r1_.grade_no <= 15 THEN r1_.id ELSE 0 END) AS sclr_8, COUNT(DISTINCT CASE WHEN r1_.grade_no > 15 AND r1_.grade_no <= 29 THEN r1_.id ELSE 0 END) AS sclr_9, COUNT(DISTINCT CASE WHEN r1_.grade_no > 29 AND r1_.grade_no <= 60 THEN r1_.id ELSE 0 END) AS sclr_10, COUNT(DISTINCT CASE WHEN r1_.grade_no = 0 OR r1_.grade_no IS NULL THEN r1_.id ELSE 0 END) AS sclr_11 FROM area a0_ LEFT JOIN routes r1_ ON a0_.id = r1_.area_id LEFT JOIN rock r2_ ON a0_.id = r2_.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,
  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;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.image AS image_3,
  a0_.lat AS lat_4,
  a0_.lng AS lng_5,
  COUNT(DISTINCT r1_.id) AS sclr_6,
  COUNT(DISTINCT r2_.id) AS sclr_7,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 0
    AND r1_.grade_no <= 15 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_8,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 15
    AND r1_.grade_no <= 29 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_9,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 29
    AND r1_.grade_no <= 60 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_10,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no = 0
    OR r1_.grade_no IS NULL THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_11
FROM
  area a0_
  LEFT JOIN routes r1_ ON a0_.id = r1_.area_id
  LEFT JOIN rock r2_ ON a0_.id = r2_.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, a0_.image AS image_3, a0_.lat AS lat_4, a0_.lng AS lng_5, COUNT(DISTINCT r1_.id) AS sclr_6, COUNT(DISTINCT r2_.id) AS sclr_7, COUNT(DISTINCT CASE WHEN r1_.grade_no > 0 AND r1_.grade_no <= 15 THEN r1_.id ELSE 0 END) AS sclr_8, COUNT(DISTINCT CASE WHEN r1_.grade_no > 15 AND r1_.grade_no <= 29 THEN r1_.id ELSE 0 END) AS sclr_9, COUNT(DISTINCT CASE WHEN r1_.grade_no > 29 AND r1_.grade_no <= 60 THEN r1_.id ELSE 0 END) AS sclr_10, COUNT(DISTINCT CASE WHEN r1_.grade_no = 0 OR r1_.grade_no IS NULL THEN r1_.id ELSE 0 END) AS sclr_11 FROM area a0_ LEFT JOIN routes r1_ ON a0_.id = r1_.area_id LEFT JOIN rock r2_ ON a0_.id = r2_.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,
  a0_.image AS image_3,
  a0_.lat AS lat_4,
  a0_.lng AS lng_5,
  COUNT(DISTINCT r1_.id) AS sclr_6,
  COUNT(DISTINCT r2_.id) AS sclr_7,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 0
    AND r1_.grade_no <= 15 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_8,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 15
    AND r1_.grade_no <= 29 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_9,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 29
    AND r1_.grade_no <= 60 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_10,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no = 0
    OR r1_.grade_no IS NULL THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_11
FROM
  area a0_
  LEFT JOIN routes r1_ ON a0_.id = r1_.area_id
  LEFT JOIN rock r2_ ON a0_.id = r2_.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, a0_.image AS image_3, a0_.lat AS lat_4, a0_.lng AS lng_5, COUNT(DISTINCT r1_.id) AS sclr_6, COUNT(DISTINCT r2_.id) AS sclr_7, COUNT(DISTINCT CASE WHEN r1_.grade_no > 0 AND r1_.grade_no <= 15 THEN r1_.id ELSE 0 END) AS sclr_8, COUNT(DISTINCT CASE WHEN r1_.grade_no > 15 AND r1_.grade_no <= 29 THEN r1_.id ELSE 0 END) AS sclr_9, COUNT(DISTINCT CASE WHEN r1_.grade_no > 29 AND r1_.grade_no <= 60 THEN r1_.id ELSE 0 END) AS sclr_10, COUNT(DISTINCT CASE WHEN r1_.grade_no = 0 OR r1_.grade_no IS NULL THEN r1_.id ELSE 0 END) AS sclr_11 FROM area a0_ LEFT JOIN routes r1_ ON a0_.id = r1_.area_id LEFT JOIN rock r2_ ON a0_.id = r2_.area_id WHERE a0_.online = 1 GROUP BY a0_.id, a0_.name ORDER BY a0_.sequence ASC;

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;

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;

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;

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;