POST https://system.tesera.lt/admin/production/2/2/submit

Query Metrics

11 Database Queries
9 Different statements
9.52 ms Query time
5 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 0.56 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.55 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  2
]
3 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.location_id AS location_id_3 FROM production_location t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
5 1.01 ms
SELECT w0_.id AS id_0, w0_.quantity AS quantity_1, w0_.product_id AS product_id_2, w0_.product_attribute_id AS product_attribute_id_3, w0_.location_id AS location_id_4 FROM warehouse w0_ WHERE w0_.product_id = 2 AND w0_.product_attribute_id = 2 AND w0_.location_id = 1 ORDER BY w0_.id ASC LIMIT 1000
Parameters:
[]
6 0.23 ms
"START TRANSACTION"
Parameters:
[]
7 0.47 ms
UPDATE warehouse SET quantity = ? WHERE id = ?
Parameters:
[
  870
  7
]
8 2.59 ms
"COMMIT"
Parameters:
[]
9 0.23 ms
"START TRANSACTION"
Parameters:
[]
10 0.61 ms
INSERT INTO production (quantity, date, production_location_id, product_id, product_attribute_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  37
  "2026-04-21"
  1
  2
  2
]
11 2.32 ms
"COMMIT"
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\User 1
App\Entity\Product 1
App\Entity\Attributes 1
App\Entity\ProductionLocation 1
App\Entity\Location 1
App\Entity\Warehouse 1
App\Entity\Production 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.
App\Entity\ProductionLocation
  • The association App\Entity\ProductionLocation#warehouses refers to the owning side field App\Entity\Warehouse#ProductionLocation which does not exist.
App\Entity\Location No errors.