Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
21.63 ms
(94.31%)
51
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
]
0.68 ms
(2.95%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0
Parameters:
[]
0.63 ms
(2.74%)
1
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
]

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.