8.88 ms (47.85%)
1
SELECT MIN (d0_ . id ) AS sclr_0 , d0_ . name AS name_1 , d0_ . slug AS slug_2 FROM dnd_monster d0_ WHERE LOWER (d0_ . name ) > LOWER (? ) GROUP BY d0_ . name , d0_ . slug ORDER BY d0_ . name ASC LIMIT 1
Parameters :
[
"Ancient Deep Dragon "
]
SELECT MIN (d0_ . id ) AS sclr_0 , d0_ . name AS name_1 , d0_ . slug AS slug_2 FROM dnd_monster d0_ WHERE LOWER (d0_ . name ) > LOWER ('Ancient Deep Dragon' ) GROUP BY d0_ . name , d0_ . slug ORDER BY d0_ . name ASC LIMIT 1 ;
Copy
2.04 ms (11.00%)
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_ . cr AS cr_7 , d0_ . xp AS xp_8 , d0_ . pb_note AS pb_note_9 , d0_ . environment_json AS environment_json_10 , d0_ . is_legendary AS is_legendary_11 , d0_ . is_mythic AS is_mythic_12 , d0_ . is_named_creature AS is_named_creature_13 , d0_ . srd AS srd_14 , d0_ . basic_rules AS basic_rules_15 , d0_ . srd52 AS srd52_16 , d0_ . basic_rules_2024 AS basic_rules_2024_17 , d0_ . has_fluff AS has_fluff_18 , d0_ . has_fluff_images AS has_fluff_images_19 FROM dnd_monster 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
Parameters :
[
"ancient-deep-dragon "
"FRAIF "
]
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_ . cr AS cr_7 , d0_ . xp AS xp_8 , d0_ . pb_note AS pb_note_9 , d0_ . environment_json AS environment_json_10 , d0_ . is_legendary AS is_legendary_11 , d0_ . is_mythic AS is_mythic_12 , d0_ . is_named_creature AS is_named_creature_13 , d0_ . srd AS srd_14 , d0_ . basic_rules AS basic_rules_15 , d0_ . srd52 AS srd52_16 , d0_ . basic_rules_2024 AS basic_rules_2024_17 , d0_ . has_fluff AS has_fluff_18 , d0_ . has_fluff_images AS has_fluff_images_19 FROM dnd_monster d0_ WHERE d0_ . slug = 'ancient-deep-dragon' AND UPPER (d0_ . source ) = 'FRAIF' ORDER BY CASE WHEN d0_ . edition = 'one' THEN 0 ELSE 1 END ASC , d0_ . source ASC , d0_ . id ASC LIMIT 1 ;
Copy
1.81 ms (9.76%)
1
SELECT MIN (d0_ . id ) AS sclr_0 , d0_ . name AS name_1 , d0_ . slug AS slug_2 FROM dnd_monster d0_ WHERE LOWER (d0_ . name ) < LOWER (? ) GROUP BY d0_ . name , d0_ . slug ORDER BY d0_ . name DESC LIMIT 1
Parameters :
[
"Ancient Deep Dragon "
]
SELECT MIN (d0_ . id ) AS sclr_0 , d0_ . name AS name_1 , d0_ . slug AS slug_2 FROM dnd_monster d0_ WHERE LOWER (d0_ . name ) < LOWER ('Ancient Deep Dragon' ) GROUP BY d0_ . name , d0_ . slug ORDER BY d0_ . name DESC LIMIT 1 ;
Copy
1.75 ms (9.42%)
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_ . cr AS cr_7 , d0_ . xp AS xp_8 , d0_ . pb_note AS pb_note_9 , d0_ . environment_json AS environment_json_10 , d0_ . is_legendary AS is_legendary_11 , d0_ . is_mythic AS is_mythic_12 , d0_ . is_named_creature AS is_named_creature_13 , d0_ . srd AS srd_14 , d0_ . basic_rules AS basic_rules_15 , d0_ . srd52 AS srd52_16 , d0_ . basic_rules_2024 AS basic_rules_2024_17 , d0_ . has_fluff AS has_fluff_18 , d0_ . has_fluff_images AS has_fluff_images_19 FROM dnd_monster d0_ WHERE d0_ . slug = ? ORDER BY d0_ . source ASC , d0_ . page ASC
Parameters :
[
"ancient-deep-dragon "
]
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_ . cr AS cr_7 , d0_ . xp AS xp_8 , d0_ . pb_note AS pb_note_9 , d0_ . environment_json AS environment_json_10 , d0_ . is_legendary AS is_legendary_11 , d0_ . is_mythic AS is_mythic_12 , d0_ . is_named_creature AS is_named_creature_13 , d0_ . srd AS srd_14 , d0_ . basic_rules AS basic_rules_15 , d0_ . srd52 AS srd52_16 , d0_ . basic_rules_2024 AS basic_rules_2024_17 , d0_ . has_fluff AS has_fluff_18 , d0_ . has_fluff_images AS has_fluff_images_19 FROM dnd_monster d0_ WHERE d0_ . slug = 'ancient-deep-dragon' ORDER BY d0_ . source ASC , d0_ . page ASC ;
Copy
0.34 ms (1.82%)
1
SELECT t0 . id AS id_1 , t0 . size_code AS size_code_2 , t0 . sort_order AS sort_order_3 , t0 . monster_id AS monster_id_4 FROM dnd_monster_size t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . size_code AS size_code_2 , t0 . sort_order AS sort_order_3 , t0 . monster_id AS monster_id_4 FROM dnd_monster_size t0 WHERE t0 . monster_id = 764 ;
Copy
0.27 ms (1.44%)
1
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 . monster_id AS monster_id_9 , t0 . parent_id AS parent_id_10 FROM dnd_monster_entry_block t0 WHERE t0 . monster_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 . monster_id AS monster_id_9 , t0 . parent_id AS parent_id_10 FROM dnd_monster_entry_block t0 WHERE t0 . monster_id = 764 ;
Copy
0.22 ms (1.19%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_action t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_action t0 WHERE t0 . monster_id = 764 ;
Copy
0.22 ms (1.16%)
1
SELECT t0 . id AS id_1 , t0 . alignment_code AS alignment_code_2 , t0 . chance AS chance_3 , t0 . special_text AS special_text_4 , t0 . sort_order AS sort_order_5 , t0 . monster_id AS monster_id_6 FROM dnd_monster_alignment t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . alignment_code AS alignment_code_2 , t0 . chance AS chance_3 , t0 . special_text AS special_text_4 , t0 . sort_order AS sort_order_5 , t0 . monster_id AS monster_id_6 FROM dnd_monster_alignment t0 WHERE t0 . monster_id = 764 ;
Copy
0.21 ms (1.15%)
1
SELECT t0 . id AS id_1 , t0 . ac_value AS ac_value_2 , t0 . ac_text AS ac_text_3 , t0 . from_json AS from_json_4 , t0 . condition_text AS condition_text_5 , t0 . sort_order AS sort_order_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_armor_class t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . ac_value AS ac_value_2 , t0 . ac_text AS ac_text_3 , t0 . from_json AS from_json_4 , t0 . condition_text AS condition_text_5 , t0 . sort_order AS sort_order_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_armor_class t0 WHERE t0 . monster_id = 764 ;
Copy
0.21 ms (1.14%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_bonus_action t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_bonus_action t0 WHERE t0 . monster_id = 764 ;
Copy
0.20 ms (1.10%)
1
SELECT t0 . id AS id_1 , t0 . language_name AS language_name_2 , t0 . note AS note_3 , t0 . sort_order AS sort_order_4 , t0 . monster_id AS monster_id_5 , t0 . language_id AS language_id_6 FROM dnd_monster_language t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . language_name AS language_name_2 , t0 . note AS note_3 , t0 . sort_order AS sort_order_4 , t0 . monster_id AS monster_id_5 , t0 . language_id AS language_id_6 FROM dnd_monster_language t0 WHERE t0 . monster_id = 764 ;
Copy
0.20 ms (1.07%)
1
SELECT t0 . id AS id_1 , t0 . type_name AS type_name_2 , t0 . subtype_name AS subtype_name_3 , t0 . tags_json AS tags_json_4 , t0 . sort_order AS sort_order_5 , t0 . monster_id AS monster_id_6 FROM dnd_monster_type t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . type_name AS type_name_2 , t0 . subtype_name AS subtype_name_3 , t0 . tags_json AS tags_json_4 , t0 . sort_order AS sort_order_5 , t0 . monster_id AS monster_id_6 FROM dnd_monster_type t0 WHERE t0 . monster_id = 764 ;
Copy
0.20 ms (1.07%)
1
SELECT t0 . id AS id_1 , t0 . skill_name AS skill_name_2 , t0 . bonus_value AS bonus_value_3 , t0 . bonus_text AS bonus_text_4 , t0 . monster_id AS monster_id_5 , t0 . skill_id AS skill_id_6 FROM dnd_monster_skill t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . skill_name AS skill_name_2 , t0 . bonus_value AS bonus_value_3 , t0 . bonus_text AS bonus_text_4 , t0 . monster_id AS monster_id_5 , t0 . skill_id AS skill_id_6 FROM dnd_monster_skill t0 WHERE t0 . monster_id = 764 ;
Copy
0.19 ms (1.04%)
1
SELECT t0 . id AS id_1 , t0 . ability_code AS ability_code_2 , t0 . score AS score_3 , t0 . monster_id AS monster_id_4 FROM dnd_monster_ability_score t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . ability_code AS ability_code_2 , t0 . score AS score_3 , t0 . monster_id AS monster_id_4 FROM dnd_monster_ability_score t0 WHERE t0 . monster_id = 764 ;
Copy
0.19 ms (1.03%)
1
SELECT t0 . id AS id_1 , t0 . movement_type AS movement_type_2 , t0 . amount AS amount_3 , t0 . condition_text AS condition_text_4 , t0 . can_hover AS can_hover_5 , t0 . sort_order AS sort_order_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_speed t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . movement_type AS movement_type_2 , t0 . amount AS amount_3 , t0 . condition_text AS condition_text_4 , t0 . can_hover AS can_hover_5 , t0 . sort_order AS sort_order_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_speed t0 WHERE t0 . monster_id = 764 ;
Copy
0.19 ms (1.02%)
1
SELECT t0 . id AS id_1 , t0 . ability_code AS ability_code_2 , t0 . bonus_value AS bonus_value_3 , t0 . bonus_text AS bonus_text_4 , t0 . monster_id AS monster_id_5 FROM dnd_monster_saving_throw t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . ability_code AS ability_code_2 , t0 . bonus_value AS bonus_value_3 , t0 . bonus_text AS bonus_text_4 , t0 . monster_id AS monster_id_5 FROM dnd_monster_saving_throw t0 WHERE t0 . monster_id = 764 ;
Copy
0.19 ms (1.01%)
1
SELECT t0 . id AS id_1 , t0 . modifier_type AS modifier_type_2 , t0 . damage_type AS damage_type_3 , t0 . note AS note_4 , t0 . sort_order AS sort_order_5 , t0 . monster_id AS monster_id_6 FROM dnd_monster_damage_modifier t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . modifier_type AS modifier_type_2 , t0 . damage_type AS damage_type_3 , t0 . note AS note_4 , t0 . sort_order AS sort_order_5 , t0 . monster_id AS monster_id_6 FROM dnd_monster_damage_modifier t0 WHERE t0 . monster_id = 764 ;
Copy
0.18 ms (0.98%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_trait t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_trait t0 WHERE t0 . monster_id = 764 ;
Copy
0.18 ms (0.97%)
1
SELECT t0 . id AS id_1 , t0 . condition_name AS condition_name_2 , t0 . note AS note_3 , t0 . sort_order AS sort_order_4 , t0 . monster_id AS monster_id_5 FROM dnd_monster_condition_immunity t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . condition_name AS condition_name_2 , t0 . note AS note_3 , t0 . sort_order AS sort_order_4 , t0 . monster_id AS monster_id_5 FROM dnd_monster_condition_immunity t0 WHERE t0 . monster_id = 764 ;
Copy
0.18 ms (0.97%)
1
SELECT t0 . id AS id_1 , t0 . sense_name AS sense_name_2 , t0 . range_feet AS range_feet_3 , t0 . note AS note_4 , t0 . sort_order AS sort_order_5 , t0 . monster_id AS monster_id_6 , t0 . sense_id AS sense_id_7 FROM dnd_monster_sense t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . sense_name AS sense_name_2 , t0 . range_feet AS range_feet_3 , t0 . note AS note_4 , t0 . sort_order AS sort_order_5 , t0 . monster_id AS monster_id_6 , t0 . sense_id AS sense_id_7 FROM dnd_monster_sense t0 WHERE t0 . monster_id = 764 ;
Copy
0.18 ms (0.96%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_reaction t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_reaction t0 WHERE t0 . monster_id = 764 ;
Copy
0.18 ms (0.95%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_mythic_action t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_mythic_action t0 WHERE t0 . monster_id = 764 ;
Copy
0.17 ms (0.94%)
1
SELECT t0 . id AS id_1 , t0 . average_hp AS average_hp_2 , t0 . formula AS formula_3 , t0 . special_text AS special_text_4 , t0 . monster_id AS monster_id_5 FROM dnd_monster_hit_points t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . average_hp AS average_hp_2 , t0 . formula AS formula_3 , t0 . special_text AS special_text_4 , t0 . monster_id AS monster_id_5 FROM dnd_monster_hit_points t0 WHERE t0 . monster_id = 764 ;
Copy
0.17 ms (0.93%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_legendary_action t0 WHERE t0 . monster_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_type AS display_type_3 , t0 . sort_order AS sort_order_4 , t0 . entries_json AS entries_json_5 , t0 . text_content AS text_content_6 , t0 . monster_id AS monster_id_7 FROM dnd_monster_legendary_action t0 WHERE t0 . monster_id = 764 ;
Copy