Query Metrics
92
Database Queries
5
Different statements
39.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
30.65 ms (77.63%) |
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
]
|
|
4.37 ms (11.07%) |
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
]
|
|
2.96 ms (7.49%) |
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.81 ms (2.06%) |
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.69 ms (1.75%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.image AS image_4, t0.imagemini AS imagemini_5 FROM cake 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. |