| 1 |
0.47 ms |
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_.action_type AS action_type_7, d0_.srd AS srd_8, d0_.basic_rules AS basic_rules_9, d0_.srd52 AS srd52_10, d0_.basic_rules_2024 AS basic_rules_2024_11 FROM dnd_action 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_.action_type AS action_type_7, d0_.srd AS srd_8, d0_.basic_rules AS basic_rules_9, d0_.srd52 AS srd52_10, d0_.basic_rules_2024 AS basic_rules_2024_11 FROM dnd_action d0_ WHERE d0_.slug = 'help' ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1;
|
| 2 |
0.26 ms |
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_.action_type AS action_type_7, d0_.srd AS srd_8, d0_.basic_rules AS basic_rules_9, d0_.srd52 AS srd52_10, d0_.basic_rules_2024 AS basic_rules_2024_11 FROM dnd_action 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_.action_type AS action_type_7, d0_.srd AS srd_8, d0_.basic_rules AS basic_rules_9, d0_.srd52 AS srd52_10, d0_.basic_rules_2024 AS basic_rules_2024_11 FROM dnd_action d0_ WHERE d0_.slug = 'help' ORDER BY d0_.source ASC, d0_.page ASC;
|
| 3 |
0.28 ms |
SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_action 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_action d0_ WHERE LOWER(d0_.name) < LOWER('Help') GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1;
|
| 4 |
0.27 ms |
SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_action 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_action d0_ WHERE LOWER(d0_.name) > LOWER('Help') GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1;
|
| 5 |
0.28 ms |
SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.json_payload AS json_payload_8, t0.action_id AS action_id_9, t0.parent_id AS parent_id_10 FROM dnd_action_entry_block t0 WHERE t0.action_id = ?
SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.json_payload AS json_payload_8, t0.action_id AS action_id_9, t0.parent_id AS parent_id_10 FROM dnd_action_entry_block t0 WHERE t0.action_id = 45;
|
| 6 |
0.23 ms |
SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.json_payload AS json_payload_8, t0.action_id AS action_id_9, t0.parent_id AS parent_id_10 FROM dnd_action_entry_block t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.json_payload AS json_payload_8, t0.action_id AS action_id_9, t0.parent_id AS parent_id_10 FROM dnd_action_entry_block t0 WHERE t0.parent_id = 110;
|
| 7 |
0.27 ms |
SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.json_payload AS json_payload_8, t0.action_id AS action_id_9, t0.parent_id AS parent_id_10 FROM dnd_action_entry_block t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.json_payload AS json_payload_8, t0.action_id AS action_id_9, t0.parent_id AS parent_id_10 FROM dnd_action_entry_block t0 WHERE t0.parent_id = 111;
|