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

Query Metrics

39 Database Queries
2 Different statements
6.24 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:
[
  "Oil"
]
2 0.24 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.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:
[]
4 0.17 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.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:
[]
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.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:
[]
10 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:
[]
11 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:
[]
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.17 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.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:
[]
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.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.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:
[]
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.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:
[]
23 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:
[]
24 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:
[]
25 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:
[]
26 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:
[]
27 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:
[]
28 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:
[]
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.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:
[]
31 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:
[]
32 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:
[]
33 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:
[]
34 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:
[]
35 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:
[]
36 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:
[]
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.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:
[]

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.