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

Query Metrics

51 Database Queries
2 Different statements
7.74 ms Query time
1 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0.72 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:
[
  "UniqueMap"
]
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.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:
[]
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.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.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.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.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:
[]
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.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.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:
[]
18 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:
[]
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.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.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:
[]
24 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:
[]
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.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:
[]
28 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:
[]
29 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:
[]
30 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:
[]
31 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:
[]
32 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:
[]
33 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:
[]
34 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:
[]
35 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:
[]
36 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:
[]
37 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:
[]
38 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:
[]
39 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:
[]
40 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:
[]
41 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:
[]
42 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:
[]
43 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:
[]
44 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:
[]
45 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:
[]
46 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:
[]
47 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:
[]
48 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:
[]
49 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:
[]
50 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:
[]
51 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:
[]

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.