Symfony Profiler

[
  "route" => "api_orders_list"
  "route_parameters" => [
    "_route" => "api_orders_list"
    "_controller" => "App\Controller\OrderController::listOrders"
    "restaurantId" => "1"
  ]
  "request_uri" => "https://api.theswarm.io/api/orders/list/1"
  "method" => "GET"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::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" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurity"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostDenormalize"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::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\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "localhost"
    "port" => 3306
    "user" => "theswiba"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "usrdb_theswiba_api"
    "serverVersion" => "8"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status = ? AND c0_.restaurant_id = ? AND (c0_.created_at BETWEEN ? AND ?) ORDER BY c0_.id DESC"
  "params" => [
    1 => "dispatched"
    2 => 1
    3 => "2025-04-05 00:00:00"
    4 => "2025-04-05 23:59:59"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status IN (?, ?) AND c0_.restaurant_id = ? AND (c0_.created_at BETWEEN ? AND ?) ORDER BY c0_.id DESC"
  "params" => [
    1 => "sent"
    2 => "rejected"
    3 => 1
    4 => "2025-04-05 00:00:00"
    5 => "2025-04-05 23:59:59"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 2
    5 => 2
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "ApiPlatform\Hydra\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "ApiPlatform\HttpCache\EventListener\AddHeadersListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

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

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

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

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

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