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_.is_class_feature_variant AS is_class_feature_variant_7, d0_.srd AS srd_8, d0_.srd52 AS srd52_9, d0_.basic_rules AS basic_rules_10, d0_.basic_rules_2024 AS basic_rules_2024_11, d0_.prerequisite_json AS prerequisite_json_12, d0_.consumes_json AS consumes_json_13, d0_.additional_spells_json AS additional_spells_json_14, d0_.skill_proficiencies_json AS skill_proficiencies_json_15, d0_.senses_json AS senses_json_16, d0_.entries_json AS entries_json_17, d0_.other_sources_json AS other_sources_json_18, d0_.reprinted_as_json AS reprinted_as_json_19 FROM dnd_optional_feature d0_ WHERE d0_.slug = ? ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1

[
  "water-whip"
]

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_.is_class_feature_variant AS is_class_feature_variant_7,
  d0_.srd AS srd_8,
  d0_.srd52 AS srd52_9,
  d0_.basic_rules AS basic_rules_10,
  d0_.basic_rules_2024 AS basic_rules_2024_11,
  d0_.prerequisite_json AS prerequisite_json_12,
  d0_.consumes_json AS consumes_json_13,
  d0_.additional_spells_json AS additional_spells_json_14,
  d0_.skill_proficiencies_json AS skill_proficiencies_json_15,
  d0_.senses_json AS senses_json_16,
  d0_.entries_json AS entries_json_17,
  d0_.other_sources_json AS other_sources_json_18,
  d0_.reprinted_as_json AS reprinted_as_json_19
FROM
  dnd_optional_feature d0_
WHERE
  d0_.slug = ?
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_.is_class_feature_variant AS is_class_feature_variant_7, d0_.srd AS srd_8, d0_.srd52 AS srd52_9, d0_.basic_rules AS basic_rules_10, d0_.basic_rules_2024 AS basic_rules_2024_11, d0_.prerequisite_json AS prerequisite_json_12, d0_.consumes_json AS consumes_json_13, d0_.additional_spells_json AS additional_spells_json_14, d0_.skill_proficiencies_json AS skill_proficiencies_json_15, d0_.senses_json AS senses_json_16, d0_.entries_json AS entries_json_17, d0_.other_sources_json AS other_sources_json_18, d0_.reprinted_as_json AS reprinted_as_json_19 FROM dnd_optional_feature d0_ WHERE d0_.slug = 'water-whip' 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_.is_class_feature_variant AS is_class_feature_variant_7, d0_.srd AS srd_8, d0_.srd52 AS srd52_9, d0_.basic_rules AS basic_rules_10, d0_.basic_rules_2024 AS basic_rules_2024_11, d0_.prerequisite_json AS prerequisite_json_12, d0_.consumes_json AS consumes_json_13, d0_.additional_spells_json AS additional_spells_json_14, d0_.skill_proficiencies_json AS skill_proficiencies_json_15, d0_.senses_json AS senses_json_16, d0_.entries_json AS entries_json_17, d0_.other_sources_json AS other_sources_json_18, d0_.reprinted_as_json AS reprinted_as_json_19 FROM dnd_optional_feature d0_ WHERE d0_.slug = ? ORDER BY d0_.source ASC, d0_.page ASC

[
  "water-whip"
]

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_.is_class_feature_variant AS is_class_feature_variant_7,
  d0_.srd AS srd_8,
  d0_.srd52 AS srd52_9,
  d0_.basic_rules AS basic_rules_10,
  d0_.basic_rules_2024 AS basic_rules_2024_11,
  d0_.prerequisite_json AS prerequisite_json_12,
  d0_.consumes_json AS consumes_json_13,
  d0_.additional_spells_json AS additional_spells_json_14,
  d0_.skill_proficiencies_json AS skill_proficiencies_json_15,
  d0_.senses_json AS senses_json_16,
  d0_.entries_json AS entries_json_17,
  d0_.other_sources_json AS other_sources_json_18,
  d0_.reprinted_as_json AS reprinted_as_json_19
FROM
  dnd_optional_feature 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_.is_class_feature_variant AS is_class_feature_variant_7, d0_.srd AS srd_8, d0_.srd52 AS srd52_9, d0_.basic_rules AS basic_rules_10, d0_.basic_rules_2024 AS basic_rules_2024_11, d0_.prerequisite_json AS prerequisite_json_12, d0_.consumes_json AS consumes_json_13, d0_.additional_spells_json AS additional_spells_json_14, d0_.skill_proficiencies_json AS skill_proficiencies_json_15, d0_.senses_json AS senses_json_16, d0_.entries_json AS entries_json_17, d0_.other_sources_json AS other_sources_json_18, d0_.reprinted_as_json AS reprinted_as_json_19 FROM dnd_optional_feature d0_ WHERE d0_.slug = 'water-whip' 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_optional_feature d0_ WHERE LOWER(d0_.name) < LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1

[
  "Water Whip"
]

SELECT
  MIN(d0_.id) AS sclr_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  dnd_optional_feature 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_optional_feature d0_ WHERE LOWER(d0_.name) < LOWER('Water Whip') 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_optional_feature d0_ WHERE LOWER(d0_.name) > LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1

[
  "Water Whip"
]

SELECT
  MIN(d0_.id) AS sclr_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  dnd_optional_feature 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_optional_feature d0_ WHERE LOWER(d0_.name) > LOWER('Water Whip') GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1;

SELECT t0.id AS id_1, t0.code AS code_2, t0.sort_order AS sort_order_3, t0.optional_feature_id AS optional_feature_id_4 FROM dnd_optional_feature_type t0 WHERE t0.optional_feature_id = ? ORDER BY t0.sort_order ASC

[
  211
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sort_order AS sort_order_3,
  t0.optional_feature_id AS optional_feature_id_4
FROM
  dnd_optional_feature_type t0
WHERE
  t0.optional_feature_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.sort_order AS sort_order_3, t0.optional_feature_id AS optional_feature_id_4 FROM dnd_optional_feature_type t0 WHERE t0.optional_feature_id = 211 ORDER BY t0.sort_order ASC;