GET https://exile-economics.com/economy/Settlers/Artifact

Query Metrics

27 Database Queries
2 Different statements
4.41 ms Query time
1 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0.70 ms
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.type AS type_2, i0_.icon AS icon_3, i0_.slug AS slug_4, i0_.sub_category AS sub_category_5 FROM item i0_ WHERE i0_.type = ? ORDER BY i0_.name ASC
Parameters:
[
  "Artifact"
]
2 0.21 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:
[]
3 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:
[]
4 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:
[]
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.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:
[]
8 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:
[]
9 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:
[]
10 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:
[]
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.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:
[]
13 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:
[]
14 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:
[]
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.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:
[]
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.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:
[]
19 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:
[]
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.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:
[]
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:
[]
25 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:
[]
26 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:
[]
27 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:
[]

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\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\League No errors.