Query Metrics
4
Database Queries
4
Different statements
116.16 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 113.58 ms |
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:
[] |
2 | 1.61 ms |
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
]
|
3 | 0.30 ms |
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
]
|
4 | 0.68 ms |
SELECT count(p0_.id) AS sclr_0 FROM products__products p0_ WHERE p0_.article_search = '1780150060'
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.
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. |