Query Metrics

53 Database Queries
3 Different statements
22.93 ms Query time
4 Invalid entities
86 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.63 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0
Parameters:
[]
3 1.14 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  1
]
4 0.90 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  2
]
5 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  3
]
6 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  4
]
7 1.18 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  5
]
8 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  6
]
9 0.88 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  7
]
10 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  8
]
11 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  9
]
12 1.59 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  10
]
13 0.82 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  11
]
14 0.99 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  12
]
15 0.85 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  13
]
16 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  14
]
17 0.96 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  15
]
18 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  16
]
19 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  17
]
20 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  20
]
21 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  21
]
22 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  22
]
23 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  23
]
24 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  24
]
25 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  25
]
26 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  26
]
27 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  27
]
28 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  28
]
29 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  29
]
30 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  30
]
31 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  31
]
32 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  32
]
33 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  33
]
34 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  34
]
35 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  35
]
36 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  37
]
37 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  38
]
38 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  39
]
39 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  40
]
40 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  41
]
41 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  42
]
42 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  43
]
43 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  44
]
44 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  45
]
45 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  46
]
46 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  47
]
47 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  48
]
48 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  49
]
49 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  50
]
50 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  51
]
51 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  52
]
52 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  53
]
53 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 INNER JOIN attributes_product ON t0.id = attributes_product.attributes_id WHERE attributes_product.product_id = ?
Parameters:
[
  54
]

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\Product 51
App\Entity\Attributes 34
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Product
  • The association App\Entity\Product#productOrders refers to the owning side field App\Entity\OrderProducts#productId which does not exist.
  • The mappings App\Entity\Product#Attributes and App\Entity\Warehouse#Product are inconsistent with each other.
App\Entity\Attributes
  • The mappings App\Entity\Attributes#attributeOrders and App\Entity\OrderProducts#orderProductAttribute are inconsistent with each other.
  • The association App\Entity\Attributes#warehouses refers to the owning side field App\Entity\Warehouse#Attributes which does not exist.
App\Entity\OrderProducts
  • The mappings App\Entity\OrderProducts#product and App\Entity\Product#productOrders are inconsistent with each other.
  • The association App\Entity\OrderProducts#orderProductAttribute refers to the inverse side field App\Entity\Attributes#AttributeOrders which does not exist.
App\Entity\Production No errors.
App\Entity\Warehouse
  • The mappings App\Entity\Warehouse#Location and App\Entity\ProductionLocation#warehouses are inconsistent with each other.