Query Metrics
92
Database Queries
5
Different statements
27.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
24.48 ms (87.72%) |
85 |
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
1
]
|
|
1.72 ms (6.17%) |
4 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.image AS image_4, t0.imagemini AS imagemini_5, t0.category_id AS category_id_6, t7.id AS id_8, t7.label AS label_9 FROM item t0 LEFT JOIN category t7 ON t0.category_id = t7.id INNER JOIN menu_item ON t0.id = menu_item.item_id WHERE menu_item.menu_id = ?
Parameters:
[
1
]
|
|
0.90 ms (3.24%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.image AS image_3, t0.imagemini AS imagemini_4, t0.status_id AS status_id_5, t6.id AS id_7, t6.label AS label_8 FROM menu t0 LEFT JOIN status t6 ON t0.status_id = t6.id
Parameters:
[] |
|
0.57 ms (2.02%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.image AS image_4, t0.imagemini AS imagemini_5, t0.category_id AS category_id_6, t7.id AS id_8, t7.label AS label_9 FROM item t0 LEFT JOIN category t7 ON t0.category_id = t7.id
Parameters:
[] |
|
0.24 ms (0.85%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2 FROM category t0
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\Menu | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Item | No errors. |
| App\Entity\Criterion | No errors. |
| App\Entity\Cake | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\Status | No errors. |