Query Metrics
3
Database Queries
3
Different statements
1.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.02 ms (56.18%) |
1 |
SELECT p0_.name AS name_0, p0_.category AS category_1, p0_.description AS description_2, p0_.price AS price_3, p0_.image AS image_4, p0_.uri AS uri_5, p0_.brand AS brand_6, p0_.model AS model_7, p0_.specification AS specification_8, p0_.active AS active_9, p0_.createdAt AS createdAt_10, p0_.updatedAt AS updatedAt_11, p0_.id AS id_12 FROM PRODUCT p0_ WHERE p0_.active = ? ORDER BY p0_.id DESC LIMIT 20
Parameters:
[
1
]
|
|
0.44 ms (24.28%) |
1 |
SELECT p0_.category AS category_0, COUNT(p0_.category) AS sclr_1 FROM PRODUCT p0_ GROUP BY p0_.category
Parameters:
[] |
|
0.35 ms (19.54%) |
1 |
SELECT p0_.brand AS brand_0, COUNT(p0_.brand) AS sclr_1 FROM PRODUCT p0_ GROUP BY p0_.brand
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 |
|---|---|
| TroskiShop\Domain\Model\Product | No errors. |