Query Metrics
12
Database Queries
7
Different statements
4.57 ms
Query time
0
Invalid entities
10
Managed entities
Grouped Statements
| 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. |