GET https://www.arrowscauldron.com/cauldron/deities/garl-glittergold?source=MTF

Query Metrics

12 Database Queries
7 Different statements
4.57 ms Query time
0 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.26 ms
(27.47%)
6
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.deity_id AS deity_id_9, t0.parent_id AS parent_id_10 FROM dnd_deity_entry_block t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  2156
]
0.93 ms
(20.38%)
1
SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_deity d0_ WHERE LOWER(d0_.name) > LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1
Parameters:
[
  "Garl Glittergold"
]
0.72 ms
(15.74%)
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_.pantheon AS pantheon_7, d0_.title AS title_8, d0_.category AS category_9, d0_.province AS province_10, d0_.symbol AS symbol_11, d0_.worshipers AS worshipers_12, d0_.plane AS plane_13, d0_.reprint_alias AS reprint_alias_14, d0_.alignment_json AS alignment_json_15, d0_.alt_names_json AS alt_names_json_16, d0_.symbol_img_json AS symbol_img_json_17, d0_.reference_sources_json AS reference_sources_json_18, d0_.other_sources_json AS other_sources_json_19, d0_.additional_sources_json AS additional_sources_json_20, d0_.reprinted_as_json AS reprinted_as_json_21, d0_.piety AS piety_22, d0_.srd AS srd_23, d0_.basic_rules AS basic_rules_24, d0_.srd52 AS srd52_25, d0_.basic_rules_2024 AS basic_rules_2024_26, d0_.has_fluff AS has_fluff_27, d0_.has_fluff_images AS has_fluff_images_28 FROM dnd_deity 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:
[
  "garl-glittergold"
  "MTF"
]
0.71 ms
(15.47%)
1
SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_deity d0_ WHERE LOWER(d0_.name) < LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1
Parameters:
[
  "Garl Glittergold"
]
0.47 ms
(10.37%)
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_.pantheon AS pantheon_7, d0_.title AS title_8, d0_.category AS category_9, d0_.province AS province_10, d0_.symbol AS symbol_11, d0_.worshipers AS worshipers_12, d0_.plane AS plane_13, d0_.reprint_alias AS reprint_alias_14, d0_.alignment_json AS alignment_json_15, d0_.alt_names_json AS alt_names_json_16, d0_.symbol_img_json AS symbol_img_json_17, d0_.reference_sources_json AS reference_sources_json_18, d0_.other_sources_json AS other_sources_json_19, d0_.additional_sources_json AS additional_sources_json_20, d0_.reprinted_as_json AS reprinted_as_json_21, d0_.piety AS piety_22, d0_.srd AS srd_23, d0_.basic_rules AS basic_rules_24, d0_.srd52 AS srd52_25, d0_.basic_rules_2024 AS basic_rules_2024_26, d0_.has_fluff AS has_fluff_27, d0_.has_fluff_images AS has_fluff_images_28 FROM dnd_deity d0_ WHERE d0_.slug = ? ORDER BY d0_.source ASC, d0_.page ASC
Parameters:
[
  "garl-glittergold"
]
0.28 ms
(6.19%)
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.deity_id AS deity_id_9, t0.parent_id AS parent_id_10 FROM dnd_deity_entry_block t0 WHERE t0.deity_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  516
]
0.20 ms
(4.38%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.deity_id AS deity_id_4 FROM dnd_deity_domain t0 WHERE t0.deity_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  516
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\DndDeityEntryBlock 6
App\Entity\DndDeity 3
App\Entity\DndDeityDomain 1

Entities Mapping

Class Mapping errors
App\Entity\DndDeity No errors.
App\Entity\DndDeityDomain No errors.
App\Entity\DndDeityEntryBlock No errors.