Query Metrics
4
Database Queries
4
Different statements
116.16 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
113.58 ms (97.78%) |
1 |
SELECT p0_.article_search AS article_search_0, p0_.article_original AS article_original_1, p0_.description AS description_2, p0_.id AS id_3, p0_.brand_id AS brand_id_4 FROM products__products p0_ INNER JOIN brands__brands b1_ ON p0_.brand_id = b1_.id WHERE p0_.article_search LIKE '%1780150060%' LIMIT 100
Parameters:
[] |
1.61 ms (1.38%) |
1 |
SELECT t0.place AS place_1, t0.id AS id_2, t0.product_id AS product_id_3 FROM storages__storages t0 WHERE t0.product_id = ?
Parameters:
[
104163
]
|
0.68 ms (0.58%) |
1 |
SELECT count(p0_.id) AS sclr_0 FROM products__products p0_ WHERE p0_.article_search = '1780150060'
Parameters:
[] |
0.30 ms (0.26%) |
1 |
SELECT t0.stock AS stock_1, t0.price AS price_2, t0.show_in_search AS show_in_search_3, t0.id AS id_4, t0.updated AS updated_5, t0.product_id AS product_id_6, t0.warehouse_id AS warehouse_id_7 FROM products__items t0 WHERE t0.product_id = ?
Parameters:
[
104163
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User |
|
App\Entity\Product |
|
App\Entity\Brand |
|
App\Entity\Item | No errors. |
App\Entity\SupplierItem |
|
App\Entity\ProductImage | No errors. |
App\Entity\Analog | No errors. |
App\Entity\Storage | No errors. |
App\Entity\Warehouse | No errors. |