Query Metrics
4
Database Queries
4
Different statements
127.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
125.29 ms (98.50%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.public AS public_2, p0_.product_id AS product_id_3, p0_.position_id AS position_id_4 FROM product_article p0_ LEFT JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_oem p2_ ON p0_.id = p2_.product_article_id WHERE p0_.title LIKE ? OR p2_.oem LIKE ? OR p2_.oem_trim LIKE ? ORDER BY p0_.title ASC
Parameters:
[ "%583022PA00%" "%583022PA00%" "%583022PA00%" ] |
|
0.72 ms (0.56%) |
1 |
SELECT t0.id AS id_1, t0.oem AS oem_2, t0.oem_trim AS oem_trim_3, t0.product_article_id AS product_article_id_4, t0.product_id AS product_id_5 FROM product_oem t0 WHERE t0.product_article_id = ?
Parameters:
[
459
]
|
|
0.63 ms (0.49%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.file AS file_3, t0.public AS public_4, t0.type_id AS type_id_5, t0.season_id AS season_id_6, t0.category_id AS category_id_7 FROM product t0 WHERE t0.id = ?
Parameters:
[
15
]
|
|
0.56 ms (0.44%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
4
]
|
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\ProductOem | No errors. |
| App\Entity\ProductArticle | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Position | No errors. |
| App\Entity\SelectionWiper | No errors. |
| App\Entity\Type | No errors. |
| App\Entity\Season | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\SelectionPart | No errors. |