Query Metrics
2
Database Queries
2
Different statements
3.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.42 ms (64.75%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.promoted AS promoted_2 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug LIKE CONCAT('%', ?, '%') AND p0_.public = ? ORDER BY p0_.updated_at DESC, p0_.promoted DESC LIMIT 30
Parameters:
[ "rosliny-motylkowate-grubonasienne" 1 ] |
|
1.32 ms (35.25%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug LIKE CONCAT('%', ?, '%') AND p0_.public = ?
Parameters:
[ "rosliny-motylkowate-grubonasienne" 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\FilterUse | No errors. |
| App\Entity\ProductType | No errors. |
| App\Entity\MediaObject | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Content | No errors. |