Symfony Profiler

[
  "route" => "app_stats_trafic"
  "route_parameters" => [
    "_route" => "app_stats_trafic"
    "shopId" => null
    "_controller" => "App\Controller\StatsController::trafic"
  ]
  "request_uri" => "https://ctr.antallis-dev.com/stats/trafic"
  "method" => "GET"
]

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "5.196.225.213"
    "port" => 3306
    "user" => "antallis"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "yummydb_ctr"
    "charset" => "utf8mb4"
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.creation_date AS creation_date_4 FROM shop t0"
]

[
  "sql" => """
    select \r\n
                        req.day,\r\n
                        sum(req.cat1) as 8_12, \r\n
                        sum(req.cat2) as 12_16, \r\n
                        sum(req.cat3) as 16_20, \r\n
                        sum(req.cat4) as 20_00\r\n
                        from(\r\n
                            select s.id as vente, DAYOFWEEK(s.date) as day, s.shop_id as shop,\r\n
                            if (date_format(s.`date`, '%H') >= 8 and date_format(s.`date`, '%H') < 12 , 1 , 0 ) as cat1,\r\n
                            if (date_format(s.`date`, '%H') >= 12 and date_format(s.`date`, '%H') < 16 , 1 , 0 ) as cat2,\r\n
                            if (date_format(s.`date`, '%H') >= 16 and date_format(s.`date`, '%H') < 20 , 1 , 0 ) as cat3,\r\n
                            if (date_format(s.`date`, '%H') >= 20 and date_format(s.`date`, '%H') <= 23 , 1 , 0 ) as cat4\r\n
                            from sales s\r\n
                            where s.deleted != 1 and date_format(s.`date` , '%m') = 04\r\n
                        )req\r\n
                    group by day;\r\n
                    
    """
  "params" => []
  "types" => []
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "exception" => Symfony\Component\Security\Core\Exception\AccessDeniedException {#235
    #message: "Access Denied."
    #code: 403
    #file: "/home/antallf/ctr/vendor/symfony/framework-bundle/Controller/AbstractController.php"
    #line: 358
    -attributes: [
      "IS_AUTHENTICATED_FULLY"
    ]
    -subject: null
    trace: {
      /home/antallf/ctr/vendor/symfony/framework-bundle/Controller/AbstractController.php:358 {
        Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createAccessDeniedException(string $message = '…14', Throwable $previous = null): AccessDeniedException …
        › 
        ›     return new AccessDeniedException($message, $previous);
        › }
      }
      /home/antallf/ctr/vendor/symfony/framework-bundle/Controller/AbstractController.php:241 {
        Symfony\Bundle\FrameworkBundle\Controller\AbstractController->denyAccessUnlessGranted($attribute, $subject = null, string $message = '…14'): void …
        › if (!$this->isGranted($attribute, $subject)) {
        ›     $exception = $this->createAccessDeniedException($message);
        ›     $exception->setAttributes([$attribute]);
        arguments: {
          $message: "Access Denied."
        }
      }
      /home/antallf/ctr/src/Controller/AppController.php:41 {
        App\Controller\AppController->renderWithParams(string $view, array $params): Response …
        › {\r
        ›     $this->denyAccessUnlessGranted('IS_AUTHENTICATED_FULLY');\r
        ›     if($this->getUser() != null){\r
        arguments: {
          $attribute: "IS_AUTHENTICATED_FULLY"
        }
      }
      /home/antallf/ctr/src/Controller/StatsController.php:187 {
        App\Controller\StatsController->trafic($shopId, SalesRepository $salesRepository, EntityManagerInterface $entityManager): Response …
        ›     'sites' => $sites,\r
        ›     'selectedSite' => $selectedShopId\r
        › ]);\r
        arguments: {
          $view: "stats/trafic.html.twig"
          $params: [ …7]
        }
      }
      /home/antallf/ctr/vendor/symfony/http-kernel/HttpKernel.php:163 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
        › // call controller
        › $response = $controller(...$arguments);
        › 
        arguments: {
          $shopId: null
          $salesRepository: App\Repository\SalesRepository {#369 …}
          $entityManager: Doctrine\ORM\EntityManager {#320 …}
        }
      }
      /home/antallf/ctr/vendor/symfony/http-kernel/HttpKernel.php:75 {
        Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
        › try {
        ›     return $this->handleRaw($request, $type);
        › } catch (\Exception $e) {
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#57 …}
          $type: 1
        }
      }
      /home/antallf/ctr/vendor/symfony/http-kernel/Kernel.php:202 {
        Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
        › try {
        ›     return $this->getHttpKernel()->handle($request, $type, $catch);
        › } finally {
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#57 …}
          $type: 1
          $catch: true
        }
      }
      /home/antallf/ctr/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        ›     $response->send();
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#57 …}
        }
      }
      /home/antallf/ctr/vendor/autoload_runtime.php:35 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /home/antallf/ctr/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
        arguments: {
          "/home/antallf/ctr/vendor/autoload_runtime.php"
        }
      }
    }
  }
]

{
  /home/antallf/ctr/vendor/symfony/framework-bundle/Controller/AbstractController.php:358 {
    Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createAccessDeniedException(string $message = '…14', Throwable $previous = null): AccessDeniedException …
    › 
    ›     return new AccessDeniedException($message, $previous);
    › }
  }
  /home/antallf/ctr/vendor/symfony/framework-bundle/Controller/AbstractController.php:241 {
    Symfony\Bundle\FrameworkBundle\Controller\AbstractController->denyAccessUnlessGranted($attribute, $subject = null, string $message = '…14'): void …
    › if (!$this->isGranted($attribute, $subject)) {
    ›     $exception = $this->createAccessDeniedException($message);
    ›     $exception->setAttributes([$attribute]);
    arguments: {
      $message: "Access Denied."
    }
  }
  /home/antallf/ctr/src/Controller/AppController.php:41 {
    App\Controller\AppController->renderWithParams(string $view, array $params): Response …
    › {\r
    ›     $this->denyAccessUnlessGranted('IS_AUTHENTICATED_FULLY');\r
    ›     if($this->getUser() != null){\r
    arguments: {
      $attribute: "IS_AUTHENTICATED_FULLY"
    }
  }
  /home/antallf/ctr/src/Controller/StatsController.php:187 {
    App\Controller\StatsController->trafic($shopId, SalesRepository $salesRepository, EntityManagerInterface $entityManager): Response …
    ›     'sites' => $sites,\r
    ›     'selectedSite' => $selectedShopId\r
    › ]);\r
    arguments: {
      $view: "stats/trafic.html.twig"
      $params: [ …7]
    }
  }
  /home/antallf/ctr/vendor/symfony/http-kernel/HttpKernel.php:163 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
    › // call controller
    › $response = $controller(...$arguments);
    › 
    arguments: {
      $shopId: null
      $salesRepository: App\Repository\SalesRepository {#369 …}
      $entityManager: Doctrine\ORM\EntityManager {#320 …}
    }
  }
  /home/antallf/ctr/vendor/symfony/http-kernel/HttpKernel.php:75 {
    Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
    › try {
    ›     return $this->handleRaw($request, $type);
    › } catch (\Exception $e) {
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#57 …}
      $type: 1
    }
  }
  /home/antallf/ctr/vendor/symfony/http-kernel/Kernel.php:202 {
    Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
    › try {
    ›     return $this->getHttpKernel()->handle($request, $type, $catch);
    › } finally {
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#57 …}
      $type: 1
      $catch: true
    }
  }
  /home/antallf/ctr/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    ›     $response->send();
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#57 …}
    }
  }
  /home/antallf/ctr/vendor/autoload_runtime.php:35 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /home/antallf/ctr/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
    arguments: {
      "/home/antallf/ctr/vendor/autoload_runtime.php"
    }
  }
}

[
  "event" => "kernel.exception"
  "listener" => "Symfony\Component\Security\Http\Firewall\ExceptionListener::onKernelException"
]

[
  "event" => "kernel.exception"
  "listener" => "Symfony\Component\Security\Http\Firewall\ExceptionListener::onKernelException"
]

[
  "event" => "kernel.exception"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ExceptionListener::onKernelException"
]

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

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

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

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

[
  "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\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.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::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\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

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