Symfony Profiler

[
  "route" => "app_order_new"
  "route_parameters" => [
    "_route" => "app_order_new"
    "_controller" => "App\Controller\OrderController::newOrderProductSelection"
  ]
  "request_uri" => "https://demo.inlovewithpizza.de/order/new?amp=&error=C"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\WordPressCookieAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\WordPressCookieAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\SsoLogoutSubscriber::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\Subscriber\RequestSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\VipStatusSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerQxJGxJp\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "localhost"
    "port" => 3306
    "user" => "duderino_pizza_demo"
    "password" => "<redacted>"
    "driverOptions" => [
      "timezone" => "Europe/Berlin"
    ]
    "serverVersion" => "8.0.41"
    "defaultTableOptions" => []
    "dbname" => "duderino_pizza_demo"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "free"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 15:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 14:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 14:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 15:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 15:30:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 15:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 15:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 14:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 16:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 16:00:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 16:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 15:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 15:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 16:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 16:30:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 16:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 16:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 15:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 17:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 17:00:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 17:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 16:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 16:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 17:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 17:30:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 17:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 17:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 16:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 18:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 18:00:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 18:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 17:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 17:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 18:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 18:30:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 18:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 18:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 17:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 19:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 19:00:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 19:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 18:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 18:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 19:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 19:30:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 19:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 19:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 18:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 20:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 20:00:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 20:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 19:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 19:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 20:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 20:30:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 20:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 20:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 19:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 21:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 21:00:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 21:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 20:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 20:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 21:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 21:30:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 21:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 1
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 21:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 2
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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 >= ?))"
  "params" => [
    1 => "2026-07-06 20:30:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => 3
    5 => "2026-07-06 14:11:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-07-06 22:00:00"
    2 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    3 => "cancelled"
    4 => "2026-07-06 14:11:27"
    5 => "pizza_%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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 > ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 22:00:00"
    3 => "2026-07-06 14:16:27"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-06 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-07 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-08 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-09 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-10 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-11 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-12 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-13 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-14 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-15 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-16 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-17 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-18 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Ramsey\Uuid\Lazy\LazyUuidFromString {#1195
      -unwrapped: null
      -uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
      uuid: "98f3c433-2fee-407c-9f15-b0c8ac2f66a9"
    }
    2 => "2026-07-19 14:16:27"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]