Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 21
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• Doctrine
• Debug
• Emails
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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.slug = ? LIMIT 1

[
  "Altmuehltal"
]

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.slug = ?
LIMIT
  1

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.slug = 'Altmuehltal' LIMIT 1;

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_.lat AS lat_6, r0_.lng AS lng_7, r0_.orientation AS orientation_8, r0_.sunny AS sunny_9, r0_.image AS image_10, r0_.preview_image AS preview_image_11, r0_.banned AS banned_12, a1_.name AS name_13, a1_.slug AS slug_14, COUNT(DISTINCT r2_.id) AS sclr_15, SUM(CASE WHEN r2_.grade_no > 0 AND r2_.grade_no <= 15 THEN 1 ELSE 0 END) AS sclr_16, SUM(CASE WHEN r2_.grade_no > 15 AND r2_.grade_no <= 29 THEN 1 ELSE 0 END) AS sclr_17, SUM(CASE WHEN r2_.grade_no > 29 AND r2_.grade_no <= 60 THEN 1 ELSE 0 END) AS sclr_18, SUM(CASE WHEN r2_.grade_no = 0 OR r2_.grade_no IS NULL THEN 1 ELSE 0 END) AS sclr_19 FROM rock r0_ LEFT JOIN area a1_ ON r0_.area_id = a1_.id LEFT JOIN routes r2_ ON r0_.id = r2_.rock_id WHERE a1_.slug LIKE ? AND r0_.online = 1 GROUP BY r0_.id ORDER BY r0_.nr ASC

[
  "Altmuehltal"
]

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_.lat AS lat_6,
  r0_.lng AS lng_7,
  r0_.orientation AS orientation_8,
  r0_.sunny AS sunny_9,
  r0_.image AS image_10,
  r0_.preview_image AS preview_image_11,
  r0_.banned AS banned_12,
  a1_.name AS name_13,
  a1_.slug AS slug_14,
  COUNT(DISTINCT r2_.id) AS sclr_15,
  SUM(
    CASE WHEN r2_.grade_no > 0
    AND r2_.grade_no <= 15 THEN
      1
    ELSE
      0
    END
  ) AS sclr_16,
  SUM(
    CASE WHEN r2_.grade_no > 15
    AND r2_.grade_no <= 29 THEN
      1
    ELSE
      0
    END
  ) AS sclr_17,
  SUM(
    CASE WHEN r2_.grade_no > 29
    AND r2_.grade_no <= 60 THEN
      1
    ELSE
      0
    END
  ) AS sclr_18,
  SUM(
    CASE WHEN r2_.grade_no = 0
    OR r2_.grade_no IS NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_19
FROM
  rock r0_
  LEFT JOIN area a1_ ON r0_.area_id = a1_.id
  LEFT JOIN routes r2_ ON r0_.id = r2_.rock_id
WHERE
  a1_.slug LIKE ?
  AND r0_.online = 1
GROUP BY
  r0_.id
ORDER BY
  r0_.nr 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_.lat AS lat_6, r0_.lng AS lng_7, r0_.orientation AS orientation_8, r0_.sunny AS sunny_9, r0_.image AS image_10, r0_.preview_image AS preview_image_11, r0_.banned AS banned_12, a1_.name AS name_13, a1_.slug AS slug_14, COUNT(DISTINCT r2_.id) AS sclr_15, SUM(CASE WHEN r2_.grade_no > 0 AND r2_.grade_no <= 15 THEN 1 ELSE 0 END) AS sclr_16, SUM(CASE WHEN r2_.grade_no > 15 AND r2_.grade_no <= 29 THEN 1 ELSE 0 END) AS sclr_17, SUM(CASE WHEN r2_.grade_no > 29 AND r2_.grade_no <= 60 THEN 1 ELSE 0 END) AS sclr_18, SUM(CASE WHEN r2_.grade_no = 0 OR r2_.grade_no IS NULL THEN 1 ELSE 0 END) AS sclr_19 FROM rock r0_ LEFT JOIN area a1_ ON r0_.area_id = a1_.id LEFT JOIN routes r2_ ON r0_.id = r2_.rock_id WHERE a1_.slug LIKE 'Altmuehltal' AND r0_.online = 1 GROUP BY r0_.id ORDER BY r0_.nr ASC;

SELECT r0_.id AS id_0, r0_.slug AS slug_1, r1_.grade_no AS grade_no_2 FROM rock r0_ LEFT JOIN area a2_ ON r0_.area_id = a2_.id LEFT JOIN routes r1_ ON r0_.id = r1_.rock_id WHERE a2_.slug LIKE ? AND r0_.online = 1 AND r1_.grade_no IS NOT NULL ORDER BY r0_.id ASC, r1_.grade_no ASC

[
  "Altmuehltal"
]

SELECT
  r0_.id AS id_0,
  r0_.slug AS slug_1,
  r1_.grade_no AS grade_no_2
FROM
  rock r0_
  LEFT JOIN area a2_ ON r0_.area_id = a2_.id
  LEFT JOIN routes r1_ ON r0_.id = r1_.rock_id
WHERE
  a2_.slug LIKE ?
  AND r0_.online = 1
  AND r1_.grade_no IS NOT NULL
ORDER BY
  r0_.id ASC,
  r1_.grade_no ASC

SELECT r0_.id AS id_0, r0_.slug AS slug_1, r1_.grade_no AS grade_no_2 FROM rock r0_ LEFT JOIN area a2_ ON r0_.area_id = a2_.id LEFT JOIN routes r1_ ON r0_.id = r1_.rock_id WHERE a2_.slug LIKE 'Altmuehltal' AND r0_.online = 1 AND r1_.grade_no IS NOT NULL ORDER BY r0_.id ASC, r1_.grade_no 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, 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 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;