Symfony Profiler

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.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.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.slug = 'Allinger_Waende' 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 'Allinger_Waende';

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 982 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_.lat AS lat_5,
  r0_.lng AS lng_6,
  r0_.zone AS zone_7,
  r0_.zoom AS zoom_8,
  r0_.path_coordinates AS path_coordinates_9,
  r0_.orientation AS orientation_10,
  r0_.sunny AS sunny_11,
  r0_.image AS image_12,
  r0_.season AS season_13,
  r0_.description AS description_14,
  r0_.access AS access_15,
  r0_.nature AS nature_16,
  r0_.header_image AS header_image_17,
  r0_.banned AS banned_18,
  a1_.name AS name_19,
  a1_.slug AS slug_20,
  COUNT(DISTINCT r2_.id) AS sclr_21,
  SUM(
    CASE WHEN r2_.grade_no > 0
    AND r2_.grade_no <= 15 THEN
      1
    ELSE
      0
    END
  ) AS sclr_22,
  SUM(
    CASE WHEN r2_.grade_no > 15
    AND r2_.grade_no <= 29 THEN
      1
    ELSE
      0
    END
  ) AS sclr_23,
  SUM(
    CASE WHEN r2_.grade_no > 29
    AND r2_.grade_no <= 60 THEN
      1
    ELSE
      0
    END
  ) AS sclr_24,
  SUM(
    CASE WHEN r2_.grade_no = 0
    OR r2_.grade_no IS NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_25
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_.lat AS lat_5, r0_.lng AS lng_6, r0_.zone AS zone_7, r0_.zoom AS zoom_8, r0_.path_coordinates AS path_coordinates_9, r0_.orientation AS orientation_10, r0_.sunny AS sunny_11, r0_.image AS image_12, r0_.season AS season_13, r0_.description AS description_14, r0_.access AS access_15, r0_.nature AS nature_16, r0_.header_image AS header_image_17, r0_.banned AS banned_18, a1_.name AS name_19, a1_.slug AS slug_20, COUNT(DISTINCT r2_.id) AS sclr_21, SUM(CASE WHEN r2_.grade_no > 0 AND r2_.grade_no <= 15 THEN 1 ELSE 0 END) AS sclr_22, SUM(CASE WHEN r2_.grade_no > 15 AND r2_.grade_no <= 29 THEN 1 ELSE 0 END) AS sclr_23, SUM(CASE WHEN r2_.grade_no > 29 AND r2_.grade_no <= 60 THEN 1 ELSE 0 END) AS sclr_24, SUM(CASE WHEN r2_.grade_no = 0 OR r2_.grade_no IS NULL THEN 1 ELSE 0 END) AS sclr_25 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 'Allinger_Waende' 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_.first_ascent AS first_ascent_9,
  r2_.year_first_ascent AS year_first_ascent_10,
  r2_.description AS description_11,
  t3_.name AS name_12,
  t3_.number AS number_13,
  v4_.video_link AS video_link_14,
  t3_.svg AS svg_15,
  t3_.with_sector AS with_sector_16
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_.first_ascent AS first_ascent_9, r2_.year_first_ascent AS year_first_ascent_10, r2_.description AS description_11, t3_.name AS name_12, t3_.number AS number_13, v4_.video_link AS video_link_14, t3_.svg AS svg_15, t3_.with_sector AS with_sector_16 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 'Allinger_Waende' 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 'Allinger_Waende';

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 = 'Allinger_Waende' 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 = 'Allinger_Waende' 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_.belongs_to_area_id AS belongs_to_area_id_4,
  p0_.belongs_to_rock_id AS belongs_to_rock_id_5,
  p0_.belongs_to_route_id AS belongs_to_route_id_6
FROM
  photos p0_
WHERE
  p0_.belongs_to_rock_id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.photgrapher AS photgrapher_3, p0_.belongs_to_area_id AS belongs_to_area_id_4, p0_.belongs_to_rock_id AS belongs_to_rock_id_5, p0_.belongs_to_route_id AS belongs_to_route_id_6 FROM photos p0_ WHERE p0_.belongs_to_rock_id = 982;

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

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
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 FROM area t0 WHERE t0.id = 4;