Symfony Profiler

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,
  a0_.travel_time_minutes AS travel_time_minutes_6,
  COUNT(DISTINCT r1_.id) AS sclr_7,
  COUNT(DISTINCT r2_.id) AS sclr_8,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 0
    AND r1_.grade_no <= 15 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_9,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 15
    AND r1_.grade_no <= 29 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_10,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 29 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_11,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no = 0
    OR r1_.grade_no IS NULL THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_12
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,
  a0_.slug,
  a0_.image,
  a0_.lat,
  a0_.lng,
  a0_.travel_time_minutes,
  a0_.sequence
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, a0_.travel_time_minutes AS travel_time_minutes_6, COUNT(DISTINCT r1_.id) AS sclr_7, COUNT(DISTINCT r2_.id) AS sclr_8, COUNT(DISTINCT CASE WHEN r1_.grade_no > 0 AND r1_.grade_no <= 15 THEN r1_.id ELSE 0 END) AS sclr_9, COUNT(DISTINCT CASE WHEN r1_.grade_no > 15 AND r1_.grade_no <= 29 THEN r1_.id ELSE 0 END) AS sclr_10, COUNT(DISTINCT CASE WHEN r1_.grade_no > 29 THEN r1_.id ELSE 0 END) AS sclr_11, COUNT(DISTINCT CASE WHEN r1_.grade_no = 0 OR r1_.grade_no IS NULL THEN r1_.id ELSE 0 END) AS sclr_12 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, a0_.slug, a0_.image, a0_.lat, a0_.lng, a0_.travel_time_minutes, a0_.sequence ORDER BY a0_.sequence ASC;

SELECT
  r0_.area_id AS sclr_0,
  SUM(
    CASE WHEN r0_.grade IN (?, ?, ?) THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?) THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(
    CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?) THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  SUM(
    CASE WHEN r0_.grade IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_4,
  SUM(
    CASE WHEN r0_.grade IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_5,
  SUM(
    CASE WHEN r0_.grade IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_6,
  SUM(
    CASE WHEN r0_.grade IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_7,
  SUM(
    CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN
      1
    ELSE
      0
    END
  ) AS sclr_8,
  SUM(
    CASE WHEN r0_.grade IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN
      1
    ELSE
      0
    END
  ) AS sclr_9
FROM
  routes r0_
GROUP BY
  r0_.area_id

SELECT r0_.area_id AS sclr_0, SUM(CASE WHEN r0_.grade IN ('3-', 3, '3+') THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN r0_.grade IN ('4-', 4, '4a', '4b', '4c', '4c+', '4+') THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN r0_.grade IN ('5-', 5, '5/5+', '5+', '5a', '5a/5b+', 'FB 3') THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN r0_.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_4, SUM(CASE WHEN r0_.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_5, SUM(CASE WHEN r0_.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_6, SUM(CASE WHEN r0_.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_7, SUM(CASE WHEN r0_.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_8, SUM(CASE WHEN r0_.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_9 FROM routes r0_ GROUP BY r0_.area_id;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.grade AS grade_2,
  r1_.name AS name_3,
  r1_.slug AS slug_4,
  a2_.slug AS slug_5
FROM
  routes r0_
  INNER JOIN rock r1_ ON r0_.rock_id = r1_.id
  INNER JOIN area a2_ ON r0_.area_id = a2_.id
WHERE
  r1_.slug IS NOT NULL
  AND a2_.slug IS NOT NULL
  AND r1_.online = 1
  AND a2_.online = 1
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, r1_.name AS name_3, r1_.slug AS slug_4, a2_.slug AS slug_5 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id INNER JOIN area a2_ ON r0_.area_id = a2_.id WHERE r1_.slug IS NOT NULL AND a2_.slug IS NOT NULL AND r1_.online = 1 AND a2_.online = 1 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
  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
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.slug AS slug_2,
  r0_.banned AS banned_3,
  a1_.name AS name_4,
  a1_.slug AS slug_5
FROM
  rock r0_
  INNER JOIN area a1_ ON r0_.area_id = a1_.id
WHERE
  r0_.banned IN (1, 2)
  AND r0_.slug IS NOT NULL
  AND a1_.slug IS NOT NULL
  AND a1_.online = 1
ORDER BY
  r0_.banned ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.banned AS banned_3, a1_.name AS name_4, a1_.slug AS slug_5 FROM rock r0_ INNER JOIN area a1_ ON r0_.area_id = a1_.id WHERE r0_.banned IN (1, 2) AND r0_.slug IS NOT NULL AND a1_.slug IS NOT NULL AND a1_.online = 1 ORDER BY r0_.banned ASC;