GET https://exile-economics.com/economy/Settlers/Currency/Blessing-of-Esh

Query Metrics

24 Database Queries
3 Different statements
4.20 ms Query time
2 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.icon AS icon_4, t0.quantity_between AS quantity_between_5, t0.slug AS slug_6, t0.sub_category AS sub_category_7 FROM item t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "Blessing-of-Esh"
]
2 0.40 ms
SELECT p0_.id AS id_0, p0_.price_aggregate AS price_aggregate_1, p0_.created_at AS created_at_2, p0_.total_listed AS total_listed_3, p0_.quantity_between AS quantity_between_4, p0_.type_id AS type_id_5 FROM price_history p0_ WHERE p0_.type_id = ? AND p0_.created_at >= '2025-05-22 10:04:29' ORDER BY p0_.created_at ASC
Parameters:
[
  1414
]
3 0.18 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
4 0.15 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
5 0.16 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
6 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
7 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
8 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
9 0.15 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
10 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
11 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
12 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
13 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
14 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
15 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
16 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
17 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
18 0.15 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
19 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
20 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
21 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
22 0.15 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
23 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]
24 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1
Parameters:
[]

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\PriceHistory 35
App\Entity\Item 1
App\Entity\League 1

Entities Mapping

Class Mapping errors
App\Entity\Item
  • The mappings App\Entity\Item#currencyPrices and App\Entity\CurrencyPrice#type are inconsistent with each other.
App\Entity\PriceHistory No errors.
App\Entity\CurrencyPrice
  • The field 'App\Entity\CurrencyPrice#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The association App\Entity\CurrencyPrice#type refers to the inverse side field App\Entity\Item#CurrencyPrice which does not exist.
App\Entity\League No errors.