Query Metrics
5
Database Queries
5
Different statements
2.39 ms
Query time
0
Invalid entities
40
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.54 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.currency AS currency_3, t0.is_available AS is_available_4, t0.display_order AS display_order_5, t0.average_rating AS average_rating_6, t0.ratings_count AS ratings_count_7, t0.chef_note AS chef_note_8, t0.image_name AS image_name_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.contribution_status AS contribution_status_12, t0.is_image_ai_generated AS is_image_ai_generated_13, t0.image_ai_provider AS image_ai_provider_14, t0.image_generated_at AS image_generated_at_15, t0.unavailable_reports_count AS unavailable_reports_count_16, t0.archived_at AS archived_at_17, t0.restaurant_id AS restaurant_id_18, t0.menu_id AS menu_id_19, t0.recipe_id AS recipe_id_20 FROM restaurant_dish t0 WHERE t0.id = ?
Parameters:
[
b".#¶ýJD\x14«k¾cïüž%"
]
|
||||||||||||||||||||||||||||
| 2 | 0.73 ms |
SELECT r0_.id AS id_0, r0_.score AS score_1, r0_.comment AS comment_2, r0_.created_at AS created_at_3, r0_.moderation_status AS moderation_status_4, u1_.id AS id_5, u1_.email AS email_6, u1_.roles AS roles_7, u1_.password AS password_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.avatar_name AS avatar_name_11, u1_.google_avatar AS google_avatar_12, u1_.points AS points_13, u1_.preferences AS preferences_14, u1_.created_at AS created_at_15, u1_.updated_at AS updated_at_16, u1_.last_login_at AS last_login_at_17, u1_.location_city AS location_city_18, u1_.location_latitude AS location_latitude_19, u1_.location_longitude AS location_longitude_20, u1_.google_id AS google_id_21, u1_.allergies AS allergies_22, r0_.user_id AS user_id_23, r0_.restaurant_dish_id AS restaurant_dish_id_24 FROM rating r0_ LEFT JOIN user u1_ ON r0_.user_id = u1_.id WHERE r0_.restaurant_dish_id = ? AND (r0_.moderation_status IS NULL OR r0_.moderation_status = ?) ORDER BY r0_.created_at DESC
Parameters:
[ b".#¶ýJD\x14«k¾cïüž%" "approved" ]
|
||||||||||||||||||||||||||||
| 3 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_vegetarian AS is_vegetarian_5, t0.is_vegan AS is_vegan_6, t0.is_gluten_free AS is_gluten_free_7, t0.image_name AS image_name_8, t0.average_price AS average_price_9, t0.global_rating AS global_rating_10, t0.restaurant_count AS restaurant_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category_id AS category_id_14 FROM recipe t0 WHERE t0.id = ?
Parameters:
[
b"ŠÅ\x13BH=EP¹”¸ï$ž•\x16"
]
|
||||||||||||||||||||||||||||
| 4 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.phone AS phone_11, t0.email AS email_12, t0.website AS website_13, t0.logo AS logo_14, t0.cover_image AS cover_image_15, t0.opening_hours AS opening_hours_16, t0.is_active AS is_active_17, t0.is_verified AS is_verified_18, t0.subscription_type AS subscription_type_19, t0.subscription_expires_at AS subscription_expires_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.source_provider AS source_provider_23, t0.source_external_id AS source_external_id_24, t0.imported_at AS imported_at_25, t0.contribution_status AS contribution_status_26, t0.owner_id AS owner_id_27, t0.contributed_by_id AS contributed_by_id_28 FROM restaurant t0 WHERE t0.id = ?
Parameters:
[
b"$Ð\x15Ô@\x02EÌœkâ㋞E£"
]
|
||||||||||||||||||||||||||||
| 5 | 0.30 ms |
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.id = ?
Parameters:
[
52
]
|
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\User | 18 |
| App\Entity\Rating | 17 |
| App\Entity\RestaurantDish | 1 |
| App\Entity\Restaurant | 1 |
| App\Entity\Menu | 1 |
| App\Entity\Recipe | 1 |
| App\Entity\Category | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\RestaurantDish | No errors. |
| App\Entity\Restaurant | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\Recipe | No errors. |
| App\Entity\Rating | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Ingredient | No errors. |
| App\Entity\RestaurantEnrichment | No errors. |
| App\Entity\Dish | No errors. |