Query Metrics
3
Database Queries
3
Different statements
1.18 ms
Query time
0
Invalid entities
8
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.52 ms (44.04%) |
1 |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.description AS description_3, r0_.is_vegetarian AS is_vegetarian_4, r0_.is_vegan AS is_vegan_5, r0_.is_gluten_free AS is_gluten_free_6, r0_.image_name AS image_name_7, r0_.average_price AS average_price_8, r0_.global_rating AS global_rating_9, r0_.restaurant_count AS restaurant_count_10, r0_.created_at AS created_at_11, r0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.icon AS icon_16, c1_.display_order AS display_order_17, r0_.category_id AS category_id_18 FROM recipe r0_ LEFT JOIN category c1_ ON r0_.category_id = c1_.id WHERE r0_.category_id = ? AND r0_.is_vegetarian = ? AND r0_.is_vegan = ? ORDER BY r0_.global_rating ASC LIMIT 50
Parameters:
[ 53 1 1 ]
|
||||||||||||||||||||||||||||
|
0.37 ms (31.39%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.display_order AS display_order_5 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"pizzas"
]
|
||||||||||||||||||||||||||||
|
0.29 ms (24.57%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.display_order AS display_order_5 FROM category t0 ORDER BY t0.display_order ASC
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Category | 8 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\Dish | No errors. |
| App\Entity\Recipe | No errors. |