Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.reward_type AS reward_type_7, d0_.rarity AS rarity_8, d0_.entries_json AS entries_json_9, d0_.additional_spells_json AS additional_spells_json_10, d0_.reprinted_as_json AS reprinted_as_json_11, d0_.other_sources_json AS other_sources_json_12 FROM dnd_reward d0_ WHERE d0_.slug = ? AND UPPER(d0_.source) = ? ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1

[
  "blessing-of-valhalla"
  "XDMG"
]

SELECT
  d0_.id AS id_0,
  d0_.source_key AS source_key_1,
  d0_.name AS name_2,
  d0_.slug AS slug_3,
  d0_.source AS source_4,
  d0_.page AS page_5,
  d0_.edition AS edition_6,
  d0_.reward_type AS reward_type_7,
  d0_.rarity AS rarity_8,
  d0_.entries_json AS entries_json_9,
  d0_.additional_spells_json AS additional_spells_json_10,
  d0_.reprinted_as_json AS reprinted_as_json_11,
  d0_.other_sources_json AS other_sources_json_12
FROM
  dnd_reward d0_
WHERE
  d0_.slug = ?
  AND UPPER(d0_.source) = ?
ORDER BY
  CASE WHEN d0_.edition = 'one' THEN
    0
  ELSE
    1
  END ASC,
  d0_.source ASC,
  d0_.id ASC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.reward_type AS reward_type_7, d0_.rarity AS rarity_8, d0_.entries_json AS entries_json_9, d0_.additional_spells_json AS additional_spells_json_10, d0_.reprinted_as_json AS reprinted_as_json_11, d0_.other_sources_json AS other_sources_json_12 FROM dnd_reward d0_ WHERE d0_.slug = 'blessing-of-valhalla' AND UPPER(d0_.source) = 'XDMG' ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1;

SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.reward_type AS reward_type_7, d0_.rarity AS rarity_8, d0_.entries_json AS entries_json_9, d0_.additional_spells_json AS additional_spells_json_10, d0_.reprinted_as_json AS reprinted_as_json_11, d0_.other_sources_json AS other_sources_json_12 FROM dnd_reward d0_ WHERE d0_.slug = ? ORDER BY d0_.source ASC, d0_.page ASC

[
  "blessing-of-valhalla"
]

SELECT
  d0_.id AS id_0,
  d0_.source_key AS source_key_1,
  d0_.name AS name_2,
  d0_.slug AS slug_3,
  d0_.source AS source_4,
  d0_.page AS page_5,
  d0_.edition AS edition_6,
  d0_.reward_type AS reward_type_7,
  d0_.rarity AS rarity_8,
  d0_.entries_json AS entries_json_9,
  d0_.additional_spells_json AS additional_spells_json_10,
  d0_.reprinted_as_json AS reprinted_as_json_11,
  d0_.other_sources_json AS other_sources_json_12
FROM
  dnd_reward d0_
WHERE
  d0_.slug = ?
ORDER BY
  d0_.source ASC,
  d0_.page ASC

SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.reward_type AS reward_type_7, d0_.rarity AS rarity_8, d0_.entries_json AS entries_json_9, d0_.additional_spells_json AS additional_spells_json_10, d0_.reprinted_as_json AS reprinted_as_json_11, d0_.other_sources_json AS other_sources_json_12 FROM dnd_reward d0_ WHERE d0_.slug = 'blessing-of-valhalla' ORDER BY d0_.source ASC, d0_.page ASC;

SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_reward d0_ WHERE LOWER(d0_.name) < LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1

[
  "Blessing of Valhalla"
]

SELECT
  MIN(d0_.id) AS sclr_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  dnd_reward d0_
WHERE
  LOWER(d0_.name) < LOWER(?)
GROUP BY
  d0_.name,
  d0_.slug
ORDER BY
  d0_.name DESC
LIMIT
  1

SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_reward d0_ WHERE LOWER(d0_.name) < LOWER('Blessing of Valhalla') GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1;

SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_reward d0_ WHERE LOWER(d0_.name) > LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1

[
  "Blessing of Valhalla"
]

SELECT
  MIN(d0_.id) AS sclr_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  dnd_reward d0_
WHERE
  LOWER(d0_.name) > LOWER(?)
GROUP BY
  d0_.name,
  d0_.slug
ORDER BY
  d0_.name ASC
LIMIT
  1

SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_reward d0_ WHERE LOWER(d0_.name) > LOWER('Blessing of Valhalla') GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1;