Symfony Profiler

SELECT
  c0_.name AS name_0,
  c0_.id AS id_1,
  COUNT(r1_.id) AS sclr_2
FROM
  restaurant_cooking_style r2_
  INNER JOIN cooking_style c0_ ON r2_.cooking_style_id = c0_.id
  INNER JOIN restaurant r1_ ON r2_.restaurant_id = r1_.id
GROUP BY
  c0_.name,
  c0_.id
ORDER BY
  sclr_2 DESC

SELECT c0_.name AS name_0, c0_.id AS id_1, COUNT(r1_.id) AS sclr_2 FROM restaurant_cooking_style r2_ INNER JOIN cooking_style c0_ ON r2_.cooking_style_id = c0_.id INNER JOIN restaurant r1_ ON r2_.restaurant_id = r1_.id GROUP BY c0_.name, c0_.id ORDER BY sclr_2 DESC;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.tab_id AS tab_id_5,
  t0.meal_part_id AS meal_part_id_6,
  t0.has_photo AS has_photo_7,
  t0.photo_extension AS photo_extension_8,
  t0.restaurant_id AS restaurant_id_9,
  t0.cooking_style_id AS cooking_style_id_10
FROM
  food t0
WHERE
  t0.has_photo = ?
  AND t0.restaurant_id = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.price AS price_2, t0.name AS name_3, t0.description AS description_4, t0.tab_id AS tab_id_5, t0.meal_part_id AS meal_part_id_6, t0.has_photo AS has_photo_7, t0.photo_extension AS photo_extension_8, t0.restaurant_id AS restaurant_id_9, t0.cooking_style_id AS cooking_style_id_10 FROM food t0 WHERE t0.has_photo = 1 AND t0.restaurant_id = 372 LIMIT 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.has_map AS has_map_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.quotation AS quotation_8,
  t0.stripe_bank_account_id AS stripe_bank_account_id_9,
  t0.stripe_account_id AS stripe_account_id_10,
  t0.stripe_bank_account_token_id AS stripe_bank_account_token_id_11,
  t0.phone_number AS phone_number_12,
  t0.support_url AS support_url_13,
  t0.email AS email_14,
  t0.restaurant_chain_id AS restaurant_chain_id_15,
  t0.shop_address_id AS shop_address_id_16,
  t0.bill_address_id AS bill_address_id_17
FROM
  restaurant t0
WHERE
  t0.slug = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.has_map AS has_map_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.quotation AS quotation_8, t0.stripe_bank_account_id AS stripe_bank_account_id_9, t0.stripe_account_id AS stripe_account_id_10, t0.stripe_bank_account_token_id AS stripe_bank_account_token_id_11, t0.phone_number AS phone_number_12, t0.support_url AS support_url_13, t0.email AS email_14, t0.restaurant_chain_id AS restaurant_chain_id_15, t0.shop_address_id AS shop_address_id_16, t0.bill_address_id AS bill_address_id_17 FROM restaurant t0 WHERE t0.slug = 'l-oasis';

SELECT
  r0_.id AS id_0,
  c1_.id AS id_1,
  c1_.name AS name_2
FROM
  restaurant r0_
  LEFT JOIN address a2_ ON r0_.shop_address_id = a2_.id
  LEFT JOIN city c1_ ON a2_.city_id = c1_.id
WHERE
  a2_.id IS NOT NULL
GROUP BY
  c1_.name
ORDER BY
  c1_.name ASC

SELECT r0_.id AS id_0, c1_.id AS id_1, c1_.name AS name_2 FROM restaurant r0_ LEFT JOIN address a2_ ON r0_.shop_address_id = a2_.id LEFT JOIN city c1_ ON a2_.city_id = c1_.id WHERE a2_.id IS NOT NULL GROUP BY c1_.name ORDER BY c1_.name ASC;

SELECT
  r0_.waiting_appreciation AS waiting_appreciation_0,
  r0_.friendliness_waiters AS friendliness_waiters_1,
  r0_.experience AS experience_2,
  r0_.id AS id_3
FROM
  restaurant r1_
  LEFT JOIN review r0_ ON r1_.id = r0_.restaurant_id
WHERE
  r0_.id IS NOT NULL
  AND r0_.restaurant_id = ?

SELECT r0_.waiting_appreciation AS waiting_appreciation_0, r0_.friendliness_waiters AS friendliness_waiters_1, r0_.experience AS experience_2, r0_.id AS id_3 FROM restaurant r1_ LEFT JOIN review r0_ ON r1_.id = r0_.restaurant_id WHERE r0_.id IS NOT NULL AND r0_.restaurant_id = 372;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  cooking_style t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM cooking_style t0 WHERE t0.id = 134;

SELECT
  count(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.created_at >= ?
  AND o0_.created_at < DATE_ADD(?, INTERVAL 24 HOUR)

SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.created_at >= '2025-12-06 00:00:00' AND o0_.created_at < DATE_ADD('2025-12-06 00:00:00', INTERVAL 24 HOUR);

SELECT
  t0.id AS id_1,
  t0.restaurant_id AS restaurant_id_2,
  t0.cooking_style_id AS cooking_style_id_3
FROM
  restaurant_cooking_style t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.restaurant_id AS restaurant_id_2, t0.cooking_style_id AS cooking_style_id_3 FROM restaurant_cooking_style t0 WHERE t0.restaurant_id = 372;

SELECT
  t0.id AS id_1,
  t0.geo_lat AS geo_lat_2,
  t0.geo_lng AS geo_lng_3,
  t0.street_name AS street_name_4,
  t0.street_number AS street_number_5,
  t0.city_id AS city_id_6
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.geo_lat AS geo_lat_2, t0.geo_lng AS geo_lng_3, t0.street_name AS street_name_4, t0.street_number AS street_number_5, t0.city_id AS city_id_6 FROM address t0 WHERE t0.id = 304;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.tab_id AS tab_id_5,
  t0.meal_part_id AS meal_part_id_6,
  t0.has_photo AS has_photo_7,
  t0.photo_extension AS photo_extension_8,
  t0.restaurant_id AS restaurant_id_9,
  t0.cooking_style_id AS cooking_style_id_10
FROM
  food t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.name AS name_3, t0.description AS description_4, t0.tab_id AS tab_id_5, t0.meal_part_id AS meal_part_id_6, t0.has_photo AS has_photo_7, t0.photo_extension AS photo_extension_8, t0.restaurant_id AS restaurant_id_9, t0.cooking_style_id AS cooking_style_id_10 FROM food t0 WHERE t0.restaurant_id = 372;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.has_photo AS has_photo_3,
  t0.has_map AS has_map_4,
  t0.max_guest AS max_guest_5,
  t0.restaurant_id AS restaurant_id_6
FROM
  restaurant_area t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.has_photo AS has_photo_3, t0.has_map AS has_map_4, t0.max_guest AS max_guest_5, t0.restaurant_id AS restaurant_id_6 FROM restaurant_area t0 WHERE t0.restaurant_id = 372;

SELECT
  t0.id AS id_1,
  t0.zip_code AS zip_code_2,
  t0.name AS name_3,
  t0.parent_id AS parent_id_4,
  t0.country_id AS country_id_5
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.name AS name_3, t0.parent_id AS parent_id_4, t0.country_id AS country_id_5 FROM city t0 WHERE t0.id = 304;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.title AS title_3,
  t0.slot_duration_minutes AS slot_duration_minutes_4,
  t0.nb_slot AS nb_slot_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.service_start_at_minutes AS service_start_at_minutes_8,
  t0.restaurant_id AS restaurant_id_9
FROM
  restaurant_service_time t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.slot_duration_minutes AS slot_duration_minutes_4, t0.nb_slot AS nb_slot_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.service_start_at_minutes AS service_start_at_minutes_8, t0.restaurant_id AS restaurant_id_9 FROM restaurant_service_time t0 WHERE t0.restaurant_id = 372;