Symfony Profiler

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  order_header o0_
WHERE
  o0_.ordered_at = ?
  AND o0_.location_id = ?
  AND o0_.status <> ?
  AND o0_.blocks_next_slot >= ?
  AND (
    (o0_.paid = 1)
    OR (
      o0_.paid = 0
      AND o0_.created_at >= ?
    )
  )

SELECT COUNT(o0_.id) AS sclr_0 FROM order_header o0_ WHERE o0_.ordered_at = '2026-07-06 15:00:00' AND o0_.location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_.status <> 'cancelled' AND o0_.blocks_next_slot >= 1 AND ((o0_.paid = 1) OR (o0_.paid = 0 AND o0_.created_at >= '2026-07-06 14:11:27'));

SELECT
  p0_.name AS name_0,
  SUM(o1_.count) AS sclr_1
FROM
  order_header o2_
  INNER JOIN order_position o1_ ON o2_.id = o1_.order_id
  INNER JOIN product p0_ ON o1_.product_id = p0_.id
WHERE
  o2_.ordered_at = ?
  AND o2_.location_id = ?
  AND o2_.status <> ?
  AND (
    (o2_.paid = 1)
    OR (
      o2_.paid = 0
      AND o2_.created_at >= ?
    )
  )
  AND p0_.type LIKE ?
GROUP BY
  p0_.name

SELECT p0_.name AS name_0, SUM(o1_.count) AS sclr_1 FROM order_header o2_ INNER JOIN order_position o1_ ON o2_.id = o1_.order_id INNER JOIN product p0_ ON o1_.product_id = p0_.id WHERE o2_.ordered_at = '2026-07-06 15:30:00' AND o2_.location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o2_.status <> 'cancelled' AND ((o2_.paid = 1) OR (o2_.paid = 0 AND o2_.created_at >= '2026-07-06 14:11:27')) AND p0_.type LIKE 'pizza_%' GROUP BY p0_.name;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  slot_reservation s0_
WHERE
  s0_.location_id = ?
  AND s0_.slot_date_time = ?
  AND s0_.confirmed = 0
  AND s0_.expires_at > ?

SELECT COUNT(s0_.id) AS sclr_0 FROM slot_reservation s0_ WHERE s0_.location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND s0_.slot_date_time = '2026-07-06 15:30:00' AND s0_.confirmed = 0 AND s0_.expires_at > '2026-07-06 14:16:27';

SELECT
  d0_.blackout_date AS blackout_date_0,
  d0_.reason AS reason_1,
  d0_.notes AS notes_2,
  d0_.active AS active_3,
  d0_.id AS id_4,
  d0_.created_at AS created_at_5,
  d0_.updated_at AS updated_at_6,
  d0_.location_id AS location_id_7
FROM
  delivery_blackout_date d0_
WHERE
  d0_.location_id = ?
  AND d0_.blackout_date = ?
  AND d0_.active = ?

SELECT d0_.blackout_date AS blackout_date_0, d0_.reason AS reason_1, d0_.notes AS notes_2, d0_.active AS active_3, d0_.id AS id_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.location_id AS location_id_7 FROM delivery_blackout_date d0_ WHERE d0_.location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND d0_.blackout_date = '2026-07-06 14:16:27' AND d0_.active = 1;

SELECT
  t0.name AS name_1,
  t0.radius AS radius_2,
  t0.zipcodeslist AS zipcodeslist_3,
  t0.pizza_count AS pizza_count_4,
  t0.active AS active_5,
  t0.street AS street_6,
  t0.house_number AS house_number_7,
  t0.city AS city_8,
  t0.postal_code AS postal_code_9,
  t0.phone AS phone_10,
  t0.email AS email_11,
  t0.time_slot AS time_slot_12,
  t0.time_slot_start AS time_slot_start_13,
  t0.time_slot_end AS time_slot_end_14,
  t0.time_slot_break_start AS time_slot_break_start_15,
  t0.time_slot_break_end AS time_slot_break_end_16,
  t0.adress_lat AS adress_lat_17,
  t0.adress_long AS adress_long_18,
  t0.accept_orders_from AS accept_orders_from_19,
  t0.chatId AS chatId_20,
  t0.id AS id_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t24.email AS email_25,
  t24.password AS password_26,
  t24.first_name AS first_name_27,
  t24.last_name AS last_name_28,
  t24.street AS street_29,
  t24.house_number AS house_number_30,
  t24.city AS city_31,
  t24.postal_code AS postal_code_32,
  t24.birth_date AS birth_date_33,
  t24.phone AS phone_34,
  t24.invite_code_used AS invite_code_used_35,
  t24.invite_code AS invite_code_36,
  t24.is_verified AS is_verified_37,
  t24.roles AS roles_38,
  t24.shipping_adresses AS shipping_adresses_39,
  t24.delivery_address_count AS delivery_address_count_40,
  t24.store_name AS store_name_41,
  t24.tax_number AS tax_number_42,
  t24.tax_department AS tax_department_43,
  t24.tax_office_location AS tax_office_location_44,
  t24.bank_name AS bank_name_45,
  t24.bank_account_holder AS bank_account_holder_46,
  t24.bank_iban AS bank_iban_47,
  t24.bank_bic AS bank_bic_48,
  t24.access_code AS access_code_49,
  t24.id AS id_50,
  t24.created_at AS created_at_51,
  t24.updated_at AS updated_at_52,
  t24.location_id AS location_id_53
FROM
  location t0
  LEFT JOIN `user` t24 ON t24.location_id = t0.id

SELECT t0.name AS name_1, t0.radius AS radius_2, t0.zipcodeslist AS zipcodeslist_3, t0.pizza_count AS pizza_count_4, t0.active AS active_5, t0.street AS street_6, t0.house_number AS house_number_7, t0.city AS city_8, t0.postal_code AS postal_code_9, t0.phone AS phone_10, t0.email AS email_11, t0.time_slot AS time_slot_12, t0.time_slot_start AS time_slot_start_13, t0.time_slot_end AS time_slot_end_14, t0.time_slot_break_start AS time_slot_break_start_15, t0.time_slot_break_end AS time_slot_break_end_16, t0.adress_lat AS adress_lat_17, t0.adress_long AS adress_long_18, t0.accept_orders_from AS accept_orders_from_19, t0.chatId AS chatId_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t24.email AS email_25, t24.password AS password_26, t24.first_name AS first_name_27, t24.last_name AS last_name_28, t24.street AS street_29, t24.house_number AS house_number_30, t24.city AS city_31, t24.postal_code AS postal_code_32, t24.birth_date AS birth_date_33, t24.phone AS phone_34, t24.invite_code_used AS invite_code_used_35, t24.invite_code AS invite_code_36, t24.is_verified AS is_verified_37, t24.roles AS roles_38, t24.shipping_adresses AS shipping_adresses_39, t24.delivery_address_count AS delivery_address_count_40, t24.store_name AS store_name_41, t24.tax_number AS tax_number_42, t24.tax_department AS tax_department_43, t24.tax_office_location AS tax_office_location_44, t24.bank_name AS bank_name_45, t24.bank_account_holder AS bank_account_holder_46, t24.bank_iban AS bank_iban_47, t24.bank_bic AS bank_bic_48, t24.access_code AS access_code_49, t24.id AS id_50, t24.created_at AS created_at_51, t24.updated_at AS updated_at_52, t24.location_id AS location_id_53 FROM location t0 LEFT JOIN `user` t24 ON t24.location_id = t0.id;

SELECT
  t0.name AS name_1,
  t0.price AS price_2,
  t0.details AS details_3,
  t0.plan_id AS plan_id_4,
  t0.plan_id_light AS plan_id_light_5,
  t0.recurrance AS recurrance_6,
  t0.min_pizza_countper_order AS min_pizza_countper_order_7,
  t0.max_pizza_countper_order AS max_pizza_countper_order_8,
  t0.id AS id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  membership t0
WHERE
  t0.recurrance = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.price AS price_2, t0.details AS details_3, t0.plan_id AS plan_id_4, t0.plan_id_light AS plan_id_light_5, t0.recurrance AS recurrance_6, t0.min_pizza_countper_order AS min_pizza_countper_order_7, t0.max_pizza_countper_order AS max_pizza_countper_order_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM membership t0 WHERE t0.recurrance = 'free' LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.small_description AS small_description_3,
  t0.type AS type_4,
  t0.price AS price_5,
  t0.reduced_price AS reduced_price_6,
  t0.image AS image_7,
  t0.active AS active_8,
  t0.price_without_sub AS price_without_sub_9,
  t0.visibility AS visibility_10,
  t0.id AS id_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  product t0
WHERE
  t0.active = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.small_description AS small_description_3, t0.type AS type_4, t0.price AS price_5, t0.reduced_price AS reduced_price_6, t0.image AS image_7, t0.active AS active_8, t0.price_without_sub AS price_without_sub_9, t0.visibility AS visibility_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM product t0 WHERE t0.active = 1;