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

Grouped Statements

Show all queries

Time Count Info
4.91 ms
(51.54%)
2
"COMMIT"
Parameters:
[]
1.01 ms
(10.56%)
1
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:
[]
0.61 ms
(6.41%)
1
INSERT INTO production (quantity, date, production_location_id, product_id, product_attribute_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  37
  "2026-04-21"
  1
  2
  2
]
0.58 ms
(6.04%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.56 ms
(5.84%)
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
]
0.55 ms
(5.74%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.47 ms
(4.94%)
1
UPDATE warehouse SET quantity = ? WHERE id = ?
Parameters:
[
  870
  7
]
0.46 ms
(4.84%)
2
"START TRANSACTION"
Parameters:
[]
0.39 ms
(4.09%)
1
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"
]

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.