1
0.55 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_ . level AS level_7 , d0_ . class_name AS class_name_8 , d0_ . subclass_name AS subclass_name_9 , d0_ . feature_type AS feature_type_10 , d0_ . srd AS srd_11 , d0_ . basic_rules AS basic_rules_12 , d0_ . srd52 AS srd52_13 , d0_ . basic_rules_2024 AS basic_rules_2024_14 , d0_ . has_fluff AS has_fluff_15 , d0_ . has_fluff_images AS has_fluff_images_16 , d0_ . class_id AS class_id_17 , d0_ . subclass_id AS subclass_id_18 FROM dnd_class_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
Parameters :
[
"font-of-magic "
]
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_ . level AS level_7 , d0_ . class_name AS class_name_8 , d0_ . subclass_name AS subclass_name_9 , d0_ . feature_type AS feature_type_10 , d0_ . srd AS srd_11 , d0_ . basic_rules AS basic_rules_12 , d0_ . srd52 AS srd52_13 , d0_ . basic_rules_2024 AS basic_rules_2024_14 , d0_ . has_fluff AS has_fluff_15 , d0_ . has_fluff_images AS has_fluff_images_16 , d0_ . class_id AS class_id_17 , d0_ . subclass_id AS subclass_id_18 FROM dnd_class_feature d0_ WHERE d0_ . slug = 'font-of-magic' ORDER BY CASE WHEN d0_ . edition = 'one' THEN 0 ELSE 1 END ASC , d0_ . source ASC , d0_ . id ASC LIMIT 1 ;
Copy
2
0.37 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_ . level AS level_7 , d0_ . class_name AS class_name_8 , d0_ . subclass_name AS subclass_name_9 , d0_ . feature_type AS feature_type_10 , d0_ . srd AS srd_11 , d0_ . basic_rules AS basic_rules_12 , d0_ . srd52 AS srd52_13 , d0_ . basic_rules_2024 AS basic_rules_2024_14 , d0_ . has_fluff AS has_fluff_15 , d0_ . has_fluff_images AS has_fluff_images_16 , d0_ . class_id AS class_id_17 , d0_ . subclass_id AS subclass_id_18 FROM dnd_class_feature d0_ WHERE d0_ . slug = ? ORDER BY d0_ . source ASC , d0_ . page ASC
Parameters :
[
"font-of-magic "
]
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_ . level AS level_7 , d0_ . class_name AS class_name_8 , d0_ . subclass_name AS subclass_name_9 , d0_ . feature_type AS feature_type_10 , d0_ . srd AS srd_11 , d0_ . basic_rules AS basic_rules_12 , d0_ . srd52 AS srd52_13 , d0_ . basic_rules_2024 AS basic_rules_2024_14 , d0_ . has_fluff AS has_fluff_15 , d0_ . has_fluff_images AS has_fluff_images_16 , d0_ . class_id AS class_id_17 , d0_ . subclass_id AS subclass_id_18 FROM dnd_class_feature d0_ WHERE d0_ . slug = 'font-of-magic' ORDER BY d0_ . source ASC , d0_ . page ASC ;
Copy
3
0.70 ms
SELECT MIN (d0_ . id ) AS sclr_0 , d0_ . name AS name_1 , d0_ . slug AS slug_2 FROM dnd_class_feature d0_ WHERE LOWER (d0_ . name ) < LOWER (? ) GROUP BY d0_ . name , d0_ . slug ORDER BY d0_ . name DESC LIMIT 1
Parameters :
[
"Font of Magic "
]
SELECT MIN (d0_ . id ) AS sclr_0 , d0_ . name AS name_1 , d0_ . slug AS slug_2 FROM dnd_class_feature d0_ WHERE LOWER (d0_ . name ) < LOWER ('Font of Magic' ) GROUP BY d0_ . name , d0_ . slug ORDER BY d0_ . name DESC LIMIT 1 ;
Copy
4
0.81 ms
SELECT MIN (d0_ . id ) AS sclr_0 , d0_ . name AS name_1 , d0_ . slug AS slug_2 FROM dnd_class_feature d0_ WHERE LOWER (d0_ . name ) > LOWER (? ) GROUP BY d0_ . name , d0_ . slug ORDER BY d0_ . name ASC LIMIT 1
Parameters :
[
"Font of Magic "
]
SELECT MIN (d0_ . id ) AS sclr_0 , d0_ . name AS name_1 , d0_ . slug AS slug_2 FROM dnd_class_feature d0_ WHERE LOWER (d0_ . name ) > LOWER ('Font of Magic' ) GROUP BY d0_ . name , d0_ . slug ORDER BY d0_ . name ASC LIMIT 1 ;
Copy
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 . caption AS caption_8 , t0 . json_payload AS json_payload_9 , t0 . feature_id AS feature_id_10 , t0 . parent_id AS parent_id_11 FROM dnd_class_feature_entry_block t0 WHERE t0 . feature_id = ? ORDER BY t0 . sort_order ASC , t0 . id ASC
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 . caption AS caption_8 , t0 . json_payload AS json_payload_9 , t0 . feature_id AS feature_id_10 , t0 . parent_id AS parent_id_11 FROM dnd_class_feature_entry_block t0 WHERE t0 . feature_id = 371 ORDER BY t0 . sort_order ASC , t0 . id ASC ;
Copy
6
0.21 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 . caption AS caption_8 , t0 . json_payload AS json_payload_9 , t0 . feature_id AS feature_id_10 , t0 . parent_id AS parent_id_11 FROM dnd_class_feature_entry_block t0 WHERE t0 . parent_id = ? ORDER BY t0 . sort_order ASC , t0 . id ASC
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 . caption AS caption_8 , t0 . json_payload AS json_payload_9 , t0 . feature_id AS feature_id_10 , t0 . parent_id AS parent_id_11 FROM dnd_class_feature_entry_block t0 WHERE t0 . parent_id = 8516 ORDER BY t0 . sort_order ASC , t0 . id ASC ;
Copy
7
0.18 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 . caption AS caption_8 , t0 . json_payload AS json_payload_9 , t0 . feature_id AS feature_id_10 , t0 . parent_id AS parent_id_11 FROM dnd_class_feature_entry_block t0 WHERE t0 . parent_id = ? ORDER BY t0 . sort_order ASC , t0 . id ASC
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 . caption AS caption_8 , t0 . json_payload AS json_payload_9 , t0 . feature_id AS feature_id_10 , t0 . parent_id AS parent_id_11 FROM dnd_class_feature_entry_block t0 WHERE t0 . parent_id = 8517 ORDER BY t0 . sort_order ASC , t0 . id ASC ;
Copy
8
0.17 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 . caption AS caption_8 , t0 . json_payload AS json_payload_9 , t0 . feature_id AS feature_id_10 , t0 . parent_id AS parent_id_11 FROM dnd_class_feature_entry_block t0 WHERE t0 . parent_id = ? ORDER BY t0 . sort_order ASC , t0 . id ASC
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 . caption AS caption_8 , t0 . json_payload AS json_payload_9 , t0 . feature_id AS feature_id_10 , t0 . parent_id AS parent_id_11 FROM dnd_class_feature_entry_block t0 WHERE t0 . parent_id = 8518 ORDER BY t0 . sort_order ASC , t0 . id ASC ;
Copy