Query Metrics
154
Database Queries
10
Different statements
85.16 ms
Query time
7
Invalid entities
13828
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
18.80 ms (22.08%) |
46 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
16.07 ms (18.87%) |
40 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
14.90 ms (17.49%) |
29 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
607
]
|
|
11.65 ms (13.68%) |
1 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.date AS date_3, t0.production_location_id AS production_location_id_4, t0.product_id AS product_id_5, t0.product_attribute_id AS product_attribute_id_6 FROM production t0
Parameters:
[] |
|
11.22 ms (13.17%) |
26 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
64
]
|
|
5.24 ms (6.16%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.quantity AS quantity_3, t0.client_id AS client_id_4, t0.product_id AS product_id_5, t0.attribute_id AS attribute_id_6, t0.order_id_id AS order_id_id_7, t0.production_location_id AS production_location_id_8 FROM loading t0
Parameters:
[] |
|
4.50 ms (5.29%) |
8 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
1
]
|
|
1.26 ms (1.48%) |
1 |
SELECT o0_.id AS id_0, o0_.completed AS completed_1, o0_.client_id AS client_id_2 FROM `order` o0_ WHERE o0_.completed = 0 ORDER BY o0_.id ASC LIMIT 1000
Parameters:
[] |
|
0.84 ms (0.99%) |
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:
[
1
]
|
|
0.68 ms (0.80%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.location_id AS location_id_3 FROM production_location t0
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\Production | 9065 |
| App\Entity\Loading | 3046 |
| App\Entity\Order | 877 |
| App\Entity\Client | 470 |
| App\Entity\Warehouse | 207 |
| App\Entity\OrderProducts | 64 |
| App\Entity\Product | 46 |
| App\Entity\Attributes | 40 |
| App\Entity\ProductionLocation | 8 |
| App\Entity\Location | 4 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\ProductionLocation |
|
| App\Entity\Location | No errors. |
| App\Entity\Warehouse |
|
| App\Entity\Order |
|
| App\Entity\Client |
|
| App\Entity\OrderProducts |
|
| App\Entity\Loading | No errors. |
| App\Entity\Product |
|
| App\Entity\Attributes |
|
| App\Entity\Production | No errors. |