Symfony Profiler

[
  "route" => "api_admin_slots"
  "route_parameters" => [
    "_route" => "api_admin_slots"
    "_controller" => "App\Controller\Api\SlotController::slots"
  ]
  "request_uri" => "https://www.gamechange.fr/api/admin/slots?date=2026-03-11&service=soir"
  "method" => "GET"
]

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

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

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

[
  "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\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "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\CncKillSwitchSubscriber::onKernelRequest"
]

[
  "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" => "ContainerLCIRSnr\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "charset" => "utf8mb4"
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "grrifburger"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET time_zone = '+00:00'"
    ]
    "serverVersion" => "mariadb-10.5.29"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "grrifburger"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.slots AS slots_4, t0.enabled AS enabled_5, t0.uber_enabled AS uber_enabled_6 FROM opening_day t0 WHERE t0.day = ? AND t0.service = ? AND t0.enabled = ? LIMIT 1"
  "params" => [
    1 => "mercredi"
    2 => "soir"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.max_midi AS max_midi_5, t0.max_soir AS max_soir_6, t0.product_id AS product_id_7, t0.product_category_id AS product_category_id_8 FROM slot_limit_rule t0 WHERE t0.enabled = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT o0_.slot AS slot_0, COUNT(o0_.id) AS sclr_1 FROM `order` o0_ WHERE o0_.service_date = ? AND o0_.service = ? AND o0_.status <> ? GROUP BY o0_.slot"
  "params" => [
    1 => "2026-03-11"
    2 => "soir"
    3 => "cancelled"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT o0_.slot AS slot_0, o1_.product_id AS product_id_1, SUM(o1_.qty) AS sclr_2 FROM order_line o1_ INNER JOIN `order` o0_ ON o1_.order_ref_id = o0_.id LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o0_.id AND o2_.status = ?) WHERE o0_.service_date = ? AND o0_.service = ? AND o0_.status <> ? AND o2_.id IS NULL GROUP BY o0_.slot, o1_.product_id"
  "params" => [
    1 => "cancelled"
    2 => "2026-03-11 00:00:00"
    3 => "soir"
    4 => "cancelled"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT o0_.slot AS slot_0, p1_.id AS id_1, SUM(o2_.qty) AS sclr_2 FROM order_line o2_ INNER JOIN `order` o0_ ON o2_.order_ref_id = o0_.id LEFT JOIN `order` o3_ ON (o3_.cancel_origin_id = o0_.id AND o3_.status = ?) LEFT JOIN product p4_ ON (p4_.id = o2_.product_id) LEFT JOIN product_category p1_ ON p4_.category_id = p1_.id WHERE o0_.service_date = ? AND o0_.service = ? AND o0_.status <> ? AND o3_.id IS NULL GROUP BY o0_.slot, p1_.id"
  "params" => [
    1 => "cancelled"
    2 => "2026-03-11 00:00:00"
    3 => "soir"
    4 => "cancelled"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => """
    SELECT\n
      o.slot                      AS slot_raw,\n
      pi.ingredient_id            AS ingredient_id,\n
      SUM(l.qty * pi.qty)         AS qty_used\n
    FROM order_line l\n
    JOIN `order` o              ON o.id = l.order_ref_id\n
    LEFT JOIN `order` c         ON c.cancel_origin_id = o.id AND c.status = 'cancelled'\n
    JOIN product p              ON p.id = l.product_id\n
    JOIN product_ingredient pi  ON pi.product_id = p.id\n
    WHERE o.service_date = ?\n
      AND o.service = ?\n
      AND o.status <> 'cancelled'\n
      AND c.id IS NULL\n
    GROUP BY slot_raw, ingredient_id
    """
  "params" => [
    1 => "2026-03-11"
    2 => "soir"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.qty AS qty_1, o0_.options AS options_2, o1_.slot AS slot_3 FROM order_line o0_ INNER JOIN `order` o1_ ON o0_.order_ref_id = o1_.id LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o1_.id AND o2_.status = ?) WHERE o1_.service_date = ? AND o1_.service = ? AND o1_.status <> ? AND o2_.id IS NULL"
  "params" => [
    1 => "cancelled"
    2 => "2026-03-11 00:00:00"
    3 => "soir"
    4 => "cancelled"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT o0_.slot AS slot_0, COUNT(o0_.id) AS sclr_1, SUM(CASE WHEN o1_.packing_done = 1 THEN 1 ELSE 0 END) AS sclr_2 FROM `order` o0_ LEFT JOIN order_flow_state o1_ ON (o1_.order_ref_id = o0_.id) LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o0_.id AND o2_.status = ?) WHERE o0_.service_date = ? AND o0_.service = ? AND o0_.status <> ? AND o2_.id IS NULL AND o0_.slot IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY o0_.slot"
  "params" => [
    1 => "cancelled"
    2 => "2026-03-11 00:00:00"
    3 => "soir"
    4 => "cancelled"
    5 => "18:30"
    6 => "19:00"
    7 => "19:10"
    8 => "19:20"
    9 => "19:30"
    10 => "19:40"
    11 => "19:50"
    12 => "20:00"
    13 => "18:50"
    14 => "20:10"
    15 => "20:20"
    16 => "20:30"
    17 => "20:40"
    18 => "20:50"
    19 => "21:00"
    20 => "21:10"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
  ]
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "grrifburger2@gmail.com"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::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" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

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

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