Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\Web\DashboardController::index"
  ]
  "request_uri" => "https://supermarche.cassaclock.com/admin/?period=today"
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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\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.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" => "Container3aJHhnl\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "postgres"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "supermarche_db"
    "serverVersion" => "15"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0, SUM(s0_.total_amount) AS sclr_1, AVG(s0_.total_amount) AS sclr_2 FROM sales s0_ WHERE s0_.created_at >= ? AND s0_.created_at <= ? AND s0_.status = ?"
  "params" => [
    1 => "2026-01-02 00:00:00"
    2 => "2026-01-02 19:49:50"
    3 => "completed"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#513
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#513}
    3 => Doctrine\DBAL\ParameterType {#513}
  ]
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0, SUM(s0_.total_amount) AS sclr_1, AVG(s0_.total_amount) AS sclr_2 FROM sales s0_ WHERE s0_.created_at >= ? AND s0_.created_at <= ? AND s0_.status = ?"
  "params" => [
    1 => "2025-12-31 00:00:00"
    2 => "2026-01-01 00:00:00"
    3 => "completed"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#513
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#513}
    3 => Doctrine\DBAL\ParameterType {#513}
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM products t0 WHERE t0.is_active = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#670
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.barcode AS barcode_3, p0_.purchase_price AS purchase_price_4, p0_.selling_price AS selling_price_5, p0_.stock_quantity AS stock_quantity_6, p0_.min_stock_alert AS min_stock_alert_7, p0_.unit AS unit_8, p0_.image AS image_9, p0_.is_active AS is_active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.category_id AS category_id_13, p0_.supplier_id AS supplier_id_14 FROM products p0_ WHERE p0_.is_active = ? AND p0_.stock_quantity <= p0_.min_stock_alert ORDER BY p0_.stock_quantity ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#670
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT SUM(p0_.stock_quantity * p0_.purchase_price) AS sclr_0 FROM products p0_ WHERE p0_.is_active = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#670
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.barcode AS barcode_3, p0_.purchase_price AS purchase_price_4, p0_.selling_price AS selling_price_5, p0_.stock_quantity AS stock_quantity_6, p0_.min_stock_alert AS min_stock_alert_7, p0_.unit AS unit_8, p0_.image AS image_9, p0_.is_active AS is_active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.category_id AS category_id_13, p0_.supplier_id AS supplier_id_14 FROM products p0_ WHERE p0_.is_active = ? AND p0_.stock_quantity <= p0_.min_stock_alert ORDER BY p0_.stock_quantity ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#670
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.barcode AS barcode_2, SUM(s1_.quantity) AS sclr_3, SUM(s1_.subtotal) AS sclr_4 FROM sale_items s1_ INNER JOIN products p0_ ON s1_.product_id = p0_.id INNER JOIN sales s2_ ON s1_.sale_id = s2_.id WHERE s2_.created_at >= ? AND s2_.created_at <= ? AND s2_.status = ? GROUP BY p0_.id ORDER BY sclr_3 DESC LIMIT 10"
  "params" => [
    1 => "2026-01-02 00:00:00"
    2 => "2026-01-02 19:49:50"
    3 => "completed"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#513
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#513}
    3 => Doctrine\DBAL\ParameterType {#513}
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(s0_.total_amount), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sales s0_ WHERE s0_.created_at >= ? AND s0_.created_at < ? AND s0_.status = ?"
  "params" => [
    1 => "2026-01-02 19:49:50"
    2 => "2026-01-03 19:49:50"
    3 => "completed"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#513
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#513}
    3 => Doctrine\DBAL\ParameterType {#513}
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_amount AS total_amount_2, s0_.amount_paid AS amount_paid_3, s0_.payment_method AS payment_method_4, s0_.status AS status_5, s0_.customer_name AS customer_name_6, s0_.customer_phone AS customer_phone_7, s0_.notes AS notes_8, s0_.created_at AS created_at_9, s0_.cashier_id AS cashier_id_10 FROM sales s0_ ORDER BY s0_.created_at DESC LIMIT 10"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

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

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

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

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

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

[
  "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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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