1
0.92 ms
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 ;
Copy
2
0.97 ms
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 ;
Copy
3
0.97 ms
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
Copy
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 ;
Copy
4
1.22 ms
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 13: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 12:33:59' ));
Copy
5
0.61 ms
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 12:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:33:59' ));
Copy
6
0.46 ms
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 12:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:33:59' ));
Copy
7
1.07 ms
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 13: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 12:33:59' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
8
0.83 ms
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 13:30:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:38:59' ;
Copy
9
0.54 ms
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 13:30: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 12:33:59' ));
Copy
10
0.48 ms
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 13:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:33:59' ));
Copy
11
0.46 ms
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 12:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:33:59' ));
Copy
12
0.61 ms
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 14:00: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 12:33:59' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
13
0.39 ms
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 14:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:38:59' ;
Copy
14
0.42 ms
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 14: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 12:33:59' ));
Copy
15
0.48 ms
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 13:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:33:59' ));
Copy
16
0.77 ms
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 13:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:33:59' ));
Copy
17
0.71 ms
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 14: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
18
0.59 ms
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 14:30:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
19
0.81 ms
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 14:30: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 12:34:00' ));
Copy
20
0.71 ms
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 14:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
21
0.66 ms
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 13:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
22
0.93 ms
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:00: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
23
0.42 ms
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:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
24
0.44 ms
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 12:34:00' ));
Copy
25
0.53 ms
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 14:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
26
0.44 ms
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 14:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
27
0.63 ms
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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
28
0.40 ms
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 12:39:00' ;
Copy
29
0.42 ms
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:30: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 12:34:00' ));
Copy
30
0.41 ms
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 > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
31
0.45 ms
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 14:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
32
0.55 ms
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 16:00: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
33
0.32 ms
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 16:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
34
0.40 ms
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 16: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 12:34:00' ));
Copy
35
0.37 ms
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:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
36
0.38 ms
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 > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
37
0.47 ms
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 16: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
38
0.32 ms
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 16:30:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
39
0.36 ms
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 16:30: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 12:34:00' ));
Copy
40
0.34 ms
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 16:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
41
0.38 ms
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:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
42
0.51 ms
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 17:00: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
43
0.37 ms
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 17:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
44
0.37 ms
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 17: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 12:34:00' ));
Copy
45
0.37 ms
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 16:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
46
0.41 ms
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 16:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
47
0.49 ms
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 17: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
48
0.35 ms
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 17:30:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
49
0.44 ms
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 17:30: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 12:34:00' ));
Copy
50
0.40 ms
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 17:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
51
0.39 ms
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 16:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
52
0.55 ms
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 18:00: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
53
0.35 ms
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 18:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
54
0.35 ms
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 18: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 12:34:00' ));
Copy
55
0.34 ms
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 17:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
56
0.32 ms
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 17:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
57
0.47 ms
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 18: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
58
0.30 ms
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 18:30:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
59
0.40 ms
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 18:30: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 12:34:00' ));
Copy
60
0.38 ms
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 18:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
61
0.35 ms
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 17:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
62
0.47 ms
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 19:00: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
63
0.32 ms
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 19:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
64
0.38 ms
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 19: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 12:34:00' ));
Copy
65
0.43 ms
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 18:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
66
0.34 ms
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 18:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
67
0.55 ms
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 19: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
68
0.33 ms
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 19:30:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
69
0.34 ms
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 19:30: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 12:34:00' ));
Copy
70
0.42 ms
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 19:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
71
0.44 ms
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 18:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
72
0.56 ms
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 20:00: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
73
0.33 ms
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 20:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
74
0.41 ms
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 20: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 12:34:00' ));
Copy
75
0.42 ms
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 19:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
76
0.42 ms
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 19:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
77
0.56 ms
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 20: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
78
0.34 ms
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 20:30:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
79
0.34 ms
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 20:30: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 12:34:00' ));
Copy
80
0.36 ms
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 20:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
81
0.34 ms
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 19:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
82
0.50 ms
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 21:00: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
83
0.30 ms
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 21:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
84
0.37 ms
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 21: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 12:34:00' ));
Copy
85
0.36 ms
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 20:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
86
0.33 ms
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 20:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
87
0.47 ms
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 21: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
88
0.28 ms
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 21:30:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
89
0.43 ms
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 21:30: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 12:34:00' ));
Copy
90
0.54 ms
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 21:00:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 2 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
91
0.68 ms
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 20:30:00' AND o0_ . location_id = '98f3c433-2fee-407c-9f15-b0c8ac2f66a9' AND o0_ . status < > 'cancelled' AND o0_ . blocks_next_slot > = 3 AND ((o0_ . paid = 1 ) OR (o0_ . paid = 0 AND o0_ . created_at > = '2026-07-06 12:34:00' ));
Copy
92
0.83 ms
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 22:00: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 12:34:00' )) AND p0_ . type LIKE 'pizza_%' GROUP BY p0_ . name ;
Copy
93
0.38 ms
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 22:00:00' AND s0_ . confirmed = 0 AND s0_ . expires_at > '2026-07-06 12:39:00' ;
Copy
94
0.64 ms
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 12:39:00' AND d0_ . active = 1 ;
Copy
95
0.32 ms
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-07 12:39:00' AND d0_ . active = 1 ;
Copy
96
0.38 ms
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-08 12:39:00' AND d0_ . active = 1 ;
Copy
97
0.34 ms
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-09 12:39:00' AND d0_ . active = 1 ;
Copy
98
0.30 ms
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-10 12:39:00' AND d0_ . active = 1 ;
Copy
99
0.37 ms
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-11 12:39:00' AND d0_ . active = 1 ;
Copy
100
0.39 ms
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-12 12:39:00' AND d0_ . active = 1 ;
Copy
101
0.34 ms
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-13 12:39:00' AND d0_ . active = 1 ;
Copy
102
0.38 ms
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-14 12:39:00' AND d0_ . active = 1 ;
Copy
103
0.22 ms
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-15 12:39:00' AND d0_ . active = 1 ;
Copy
104
0.22 ms
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-16 12:39:00' AND d0_ . active = 1 ;
Copy
105
0.19 ms
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-17 12:39:00' AND d0_ . active = 1 ;
Copy
106
0.26 ms
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-18 12:39:00' AND d0_ . active = 1 ;
Copy
107
0.25 ms
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-19 12:39:00' AND d0_ . active = 1 ;
Copy