Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 7
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

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.slug = ? LIMIT 1

[
  "cheese-deluxe"
]

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.slug = ?
LIMIT
  1

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.slug = 'cheese-deluxe' LIMIT 1;

SELECT r0_.id AS id_0, r0_.price AS price_1, r0_.currency AS currency_2, r0_.is_available AS is_available_3, r0_.display_order AS display_order_4, r0_.average_rating AS average_rating_5, r0_.ratings_count AS ratings_count_6, r0_.chef_note AS chef_note_7, r0_.image_name AS image_name_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.contribution_status AS contribution_status_11, r0_.is_image_ai_generated AS is_image_ai_generated_12, r0_.image_ai_provider AS image_ai_provider_13, r0_.image_generated_at AS image_generated_at_14, r0_.unavailable_reports_count AS unavailable_reports_count_15, r0_.archived_at AS archived_at_16, r1_.id AS id_17, r1_.name AS name_18, r1_.slug AS slug_19, r1_.description AS description_20, r1_.address AS address_21, r1_.city AS city_22, r1_.postal_code AS postal_code_23, r1_.country AS country_24, r1_.latitude AS latitude_25, r1_.longitude AS longitude_26, r1_.phone AS phone_27, r1_.email AS email_28, r1_.website AS website_29, r1_.logo AS logo_30, r1_.cover_image AS cover_image_31, r1_.opening_hours AS opening_hours_32, r1_.is_active AS is_active_33, r1_.is_verified AS is_verified_34, r1_.subscription_type AS subscription_type_35, r1_.subscription_expires_at AS subscription_expires_at_36, r1_.created_at AS created_at_37, r1_.updated_at AS updated_at_38, r1_.source_provider AS source_provider_39, r1_.source_external_id AS source_external_id_40, r1_.imported_at AS imported_at_41, r1_.contribution_status AS contribution_status_42, r2_.id AS id_43, r2_.name AS name_44, r2_.slug AS slug_45, r2_.description AS description_46, r2_.is_vegetarian AS is_vegetarian_47, r2_.is_vegan AS is_vegan_48, r2_.is_gluten_free AS is_gluten_free_49, r2_.image_name AS image_name_50, r2_.average_price AS average_price_51, r2_.global_rating AS global_rating_52, r2_.restaurant_count AS restaurant_count_53, r2_.created_at AS created_at_54, r2_.updated_at AS updated_at_55, r0_.restaurant_id AS restaurant_id_56, r0_.menu_id AS menu_id_57, r0_.recipe_id AS recipe_id_58, r1_.owner_id AS owner_id_59, r1_.contributed_by_id AS contributed_by_id_60, r2_.category_id AS category_id_61 FROM restaurant_dish r0_ INNER JOIN restaurant r1_ ON r0_.restaurant_id = r1_.id INNER JOIN recipe r2_ ON r0_.recipe_id = r2_.id WHERE r0_.recipe_id = ? AND r0_.is_available = ? ORDER BY r0_.average_rating DESC

[
  b"7ê\x06Ä\x1D\tK¸—JÝ\x1F5,w\r"
  1
]

SELECT
  r0_.id AS id_0,
  r0_.price AS price_1,
  r0_.currency AS currency_2,
  r0_.is_available AS is_available_3,
  r0_.display_order AS display_order_4,
  r0_.average_rating AS average_rating_5,
  r0_.ratings_count AS ratings_count_6,
  r0_.chef_note AS chef_note_7,
  r0_.image_name AS image_name_8,
  r0_.created_at AS created_at_9,
  r0_.updated_at AS updated_at_10,
  r0_.contribution_status AS contribution_status_11,
  r0_.is_image_ai_generated AS is_image_ai_generated_12,
  r0_.image_ai_provider AS image_ai_provider_13,
  r0_.image_generated_at AS image_generated_at_14,
  r0_.unavailable_reports_count AS unavailable_reports_count_15,
  r0_.archived_at AS archived_at_16,
  r1_.id AS id_17,
  r1_.name AS name_18,
  r1_.slug AS slug_19,
  r1_.description AS description_20,
  r1_.address AS address_21,
  r1_.city AS city_22,
  r1_.postal_code AS postal_code_23,
  r1_.country AS country_24,
  r1_.latitude AS latitude_25,
  r1_.longitude AS longitude_26,
  r1_.phone AS phone_27,
  r1_.email AS email_28,
  r1_.website AS website_29,
  r1_.logo AS logo_30,
  r1_.cover_image AS cover_image_31,
  r1_.opening_hours AS opening_hours_32,
  r1_.is_active AS is_active_33,
  r1_.is_verified AS is_verified_34,
  r1_.subscription_type AS subscription_type_35,
  r1_.subscription_expires_at AS subscription_expires_at_36,
  r1_.created_at AS created_at_37,
  r1_.updated_at AS updated_at_38,
  r1_.source_provider AS source_provider_39,
  r1_.source_external_id AS source_external_id_40,
  r1_.imported_at AS imported_at_41,
  r1_.contribution_status AS contribution_status_42,
  r2_.id AS id_43,
  r2_.name AS name_44,
  r2_.slug AS slug_45,
  r2_.description AS description_46,
  r2_.is_vegetarian AS is_vegetarian_47,
  r2_.is_vegan AS is_vegan_48,
  r2_.is_gluten_free AS is_gluten_free_49,
  r2_.image_name AS image_name_50,
  r2_.average_price AS average_price_51,
  r2_.global_rating AS global_rating_52,
  r2_.restaurant_count AS restaurant_count_53,
  r2_.created_at AS created_at_54,
  r2_.updated_at AS updated_at_55,
  r0_.restaurant_id AS restaurant_id_56,
  r0_.menu_id AS menu_id_57,
  r0_.recipe_id AS recipe_id_58,
  r1_.owner_id AS owner_id_59,
  r1_.contributed_by_id AS contributed_by_id_60,
  r2_.category_id AS category_id_61
FROM
  restaurant_dish r0_
  INNER JOIN restaurant r1_ ON r0_.restaurant_id = r1_.id
  INNER JOIN recipe r2_ ON r0_.recipe_id = r2_.id
WHERE
  r0_.recipe_id = ?
  AND r0_.is_available = ?
ORDER BY
  r0_.average_rating DESC

SELECT r0_.id AS id_0, r0_.price AS price_1, r0_.currency AS currency_2, r0_.is_available AS is_available_3, r0_.display_order AS display_order_4, r0_.average_rating AS average_rating_5, r0_.ratings_count AS ratings_count_6, r0_.chef_note AS chef_note_7, r0_.image_name AS image_name_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.contribution_status AS contribution_status_11, r0_.is_image_ai_generated AS is_image_ai_generated_12, r0_.image_ai_provider AS image_ai_provider_13, r0_.image_generated_at AS image_generated_at_14, r0_.unavailable_reports_count AS unavailable_reports_count_15, r0_.archived_at AS archived_at_16, r1_.id AS id_17, r1_.name AS name_18, r1_.slug AS slug_19, r1_.description AS description_20, r1_.address AS address_21, r1_.city AS city_22, r1_.postal_code AS postal_code_23, r1_.country AS country_24, r1_.latitude AS latitude_25, r1_.longitude AS longitude_26, r1_.phone AS phone_27, r1_.email AS email_28, r1_.website AS website_29, r1_.logo AS logo_30, r1_.cover_image AS cover_image_31, r1_.opening_hours AS opening_hours_32, r1_.is_active AS is_active_33, r1_.is_verified AS is_verified_34, r1_.subscription_type AS subscription_type_35, r1_.subscription_expires_at AS subscription_expires_at_36, r1_.created_at AS created_at_37, r1_.updated_at AS updated_at_38, r1_.source_provider AS source_provider_39, r1_.source_external_id AS source_external_id_40, r1_.imported_at AS imported_at_41, r1_.contribution_status AS contribution_status_42, r2_.id AS id_43, r2_.name AS name_44, r2_.slug AS slug_45, r2_.description AS description_46, r2_.is_vegetarian AS is_vegetarian_47, r2_.is_vegan AS is_vegan_48, r2_.is_gluten_free AS is_gluten_free_49, r2_.image_name AS image_name_50, r2_.average_price AS average_price_51, r2_.global_rating AS global_rating_52, r2_.restaurant_count AS restaurant_count_53, r2_.created_at AS created_at_54, r2_.updated_at AS updated_at_55, r0_.restaurant_id AS restaurant_id_56, r0_.menu_id AS menu_id_57, r0_.recipe_id AS recipe_id_58, r1_.owner_id AS owner_id_59, r1_.contributed_by_id AS contributed_by_id_60, r2_.category_id AS category_id_61 FROM restaurant_dish r0_ INNER JOIN restaurant r1_ ON r0_.restaurant_id = r1_.id INNER JOIN recipe r2_ ON r0_.recipe_id = r2_.id WHERE r0_.recipe_id = 0x37EA06C41D094BB8974ADD1F352C770D AND r0_.is_available = 1 ORDER BY r0_.average_rating DESC;

SELECT DISTINCT r0_.city AS city_0 FROM restaurant_dish r1_ INNER JOIN restaurant r0_ ON r1_.restaurant_id = r0_.id WHERE r1_.recipe_id = ? AND r1_.is_available = ? ORDER BY r0_.city ASC

[
  b"7ê\x06Ä\x1D\tK¸—JÝ\x1F5,w\r"
  1
]

SELECT
  DISTINCT r0_.city AS city_0
FROM
  restaurant_dish r1_
  INNER JOIN restaurant r0_ ON r1_.restaurant_id = r0_.id
WHERE
  r1_.recipe_id = ?
  AND r1_.is_available = ?
ORDER BY
  r0_.city ASC

SELECT DISTINCT r0_.city AS city_0 FROM restaurant_dish r1_ INNER JOIN restaurant r0_ ON r1_.restaurant_id = r0_.id WHERE r1_.recipe_id = 0x37EA06C41D094BB8974ADD1F352C770D AND r1_.is_available = 1 ORDER BY r0_.city ASC;

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 = ?

[
  54
]

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 = ?

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 = 54;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.is_allergen AS is_allergen_5, t0.allergen_type AS allergen_type_6, t0.created_at AS created_at_7 FROM ingredient t0 INNER JOIN recipe_ingredient ON t0.id = recipe_ingredient.ingredient_id WHERE recipe_ingredient.recipe_id = ?

[
  b"7ê\x06Ä\x1D\tK¸—JÝ\x1F5,w\r"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.icon AS icon_4,
  t0.is_allergen AS is_allergen_5,
  t0.allergen_type AS allergen_type_6,
  t0.created_at AS created_at_7
FROM
  ingredient t0
  INNER JOIN recipe_ingredient ON t0.id = recipe_ingredient.ingredient_id
WHERE
  recipe_ingredient.recipe_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.is_allergen AS is_allergen_5, t0.allergen_type AS allergen_type_6, t0.created_at AS created_at_7 FROM ingredient t0 INNER JOIN recipe_ingredient ON t0.id = recipe_ingredient.ingredient_id WHERE recipe_ingredient.recipe_id = 0x37EA06C41D094BB8974ADD1F352C770D;