GET https://foodan.app/recettes/plat/40551966-ce33-4e24-9f5e-8a8f5bb6ee1e

Query Metrics

5 Database Queries
5 Different statements
2.20 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 0.43 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"@U\x19fÎ3N$Ÿ^Š[¶î\x1E"
]
2 0.63 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"@U\x19fÎ3N$Ÿ^Š[¶î\x1E"
  "approved"
]
3 0.34 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"ÕñËÐ\x1AM•†ß\x03òï\x14\x1C\x1A"
]
4 0.46 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"Ίޚ¢\F–¹Áë\x1E™4¬\x1F"
]
5 0.34 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:
[
  54
]

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 8
App\Entity\Rating 7
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.