GET https://www.arrowscauldron.com/cauldron/skills/athletics?source=PHB

Query Metrics

4 Database Queries
4 Different statements
1.11 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.38 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_.ability AS ability_5, d0_.description AS description_6 FROM dnd_skill d0_ WHERE d0_.slug = ? AND UPPER(d0_.source) = ? ORDER BY d0_.source ASC, d0_.id ASC LIMIT 1
Parameters:
[
  "athletics"
  "PHB"
]
2 0.20 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_.ability AS ability_5, d0_.description AS description_6 FROM dnd_skill d0_ WHERE d0_.slug = ? ORDER BY d0_.source ASC
Parameters:
[
  "athletics"
]
3 0.25 ms
SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_skill d0_ WHERE LOWER(d0_.name) < LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1
Parameters:
[
  "Athletics"
]
4 0.27 ms
SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_skill d0_ WHERE LOWER(d0_.name) > LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1
Parameters:
[
  "Athletics"
]

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\DndSkill 2

Entities Mapping

Class Mapping errors
App\Entity\DndSkill No errors.