Symfony Profiler

[
  "route" => "app_orders_cartid"
  "route_parameters" => [
    "_route" => "app_orders_cartid"
    "_controller" => "App\Controller\OrdersController::index"
    "cartid" => "bWiue8lAlbGSOTFmRG3vUxwX"
  ]
  "request_uri" => "https://www.anuppu.in/orders/cart/bWiue8lAlbGSOTFmRG3vUxwX?p=orders%2Fcart%2FbWiue8lAlbGSOTFmRG3vUxwX"
  "method" => "GET"
]

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

[
  "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\Bridge\Doctrine\Middleware\IdleConnection\Listener::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\EventListener\TimezoneListener::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\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "ContainerZ98K78R\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "demodump_anuppu"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "demodump_anuppu"
    "serverVersion" => "10.6.20-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.orderid AS orderid_1, o0_.userid AS userid_2, o0_.establishmentid AS establishmentid_3, o0_.ordertotal AS ordertotal_4, o0_.ordertime AS ordertime_5 FROM orders o0_ WHERE o0_.orderid = ?"
  "params" => [
    1 => "gFMTVT0LIsKBvEkP"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.cartid = ?"
  "params" => [
    1 => "bWiue8lAlbGSOTFmRG3vUxwX"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "select * from shopproducts where shopid = :shopid and (shopproductid = '654073660')"
  "params" => [
    "shopid" => "5998269"
  ]
  "types" => []
]

[
  "sql" => """
    SELECT p1.shopid as shopid, p1.productid as productid, p1.productprice as productprice\n
                                            FROM prodproductprice p1\n
                                            WHERE p1.id = (\n
                                                SELECT MAX(p2.id)\n
                                                FROM prodproductprice p2\n
                                                WHERE p2.shopid = p1.shopid AND p2.productid = p1.productid \n
                                            ) AND p1.shopid = '5998269' 
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    insert into orderproducts (orderid, productid, productvariantid, productname, productorderprice, quantity, engravetext, addedtime) \n
                        values ('gFMTVT0LIsKBvEkP','654073660','0','Carrot','13','3','','2026-08-20 15:28:29')
    """
  "params" => []
  "types" => []
]

[
  "sql" => "select * from cartproductvariant where cartid = 'bWiue8lAlbGSOTFmRG3vUxwX' and shopid = '5998269' and productid = '654073660'"
  "params" => []
  "types" => []
]

[
  "sql" => """
    insert into orderproductvariant (orderid, productid, productvariantid, productname, productorderprice, quantity, engravetext, addedtime) \n
                            values ('gFMTVT0LIsKBvEkP','654073660','Zom10gjPzdED','1 kg','32','2','','2026-08-20 15:28:29')
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    insert into orderproductvariant (orderid, productid, productvariantid, productname, productorderprice, quantity, engravetext, addedtime) \n
                            values ('gFMTVT0LIsKBvEkP','654073660','ej8fVwsm6QFA','1/2 kg','18','3','','2026-08-20 15:28:29')
    """
  "params" => []
  "types" => []
]

[
  "sql" => "INSERT INTO orders (orderid, userid, establishmentid, ordertotal, ordertime) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "gFMTVT0LIsKBvEkP"
    2 => "22270733"
    3 => "5998269"
    4 => 39.0
    5 => "2026-08-20 15:28:29"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "select * from cartprescription where cartid = 'bWiue8lAlbGSOTFmRG3vUxwX' and userid = '22270733'"
  "params" => []
  "types" => []
]

[
  "sql" => "insert into orderstatus (userid, orderid, status, statustime, orderstatusupdatedby) values ('22270733','gFMTVT0LIsKBvEkP','preview','2026/08/20 15:28:29','buyer-22270733') "
  "params" => []
  "types" => []
]

[
  "sql" => """
    insert into orderdeliverytimeslot (userid, orderid, shopid, ordertimeslotid, ordertimeslotvalue, ordertime )\n
                    values ('22270733','gFMTVT0LIsKBvEkP','5998269','10000000','Any Time','2026-08-20 15:28:29')
    """
  "params" => []
  "types" => []
]