Symfony Profiler

[
  "route" => "default"
  "route_parameters" => [
    "_route" => "default"
    "_controller" => "App\Controller\DefaultController::index"
  ]
  "request_uri" => "https://flashcard.raphael-salique.me/"
  "method" => "GET"
]

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

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

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

[
  "exception" => Symfony\Component\Security\Core\Exception\AccessDeniedException {#532
    #message: "Access Denied. The user doesn't have ROLE_USER."
    #code: 403
    #file: "/home/raphaelsalique/Public/flashcard/vendor/symfony/security-http/Firewall/AccessListener.php"
    #line: 79
    -attributes: [
      "ROLE_USER"
    ]
    -subject: Symfony\Component\HttpFoundation\Request {#2 …}
    -accessDecision: Symfony\Component\Security\Core\Authorization\AccessDecision {#530 …}
    trace: {
      /home/raphaelsalique/Public/flashcard/vendor/symfony/security-http/Firewall/AccessListener.php:79 {
        Symfony\Component\Security\Http\Firewall\AccessListener->authenticate(RequestEvent $event): void …
        › if (!$accessDecision->isGranted = $this->accessDecisionManager->decide($token, $attributes, $request, $accessDecision, true)) {
        ›     $e = new AccessDeniedException($accessDecision->getMessage());
        ›     $e->setAttributes($attributes);
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/security-bundle/Debug/WrappedLazyListener.php:52 {
        Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate(RequestEvent $event): void …
        › try {
        ›     $this->listener->authenticate($event);
        › } catch (LazyResponseException $e) {
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/security-bundle/Security/LazyFirewallContext.php:64 {
        Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate(RequestEvent $event): void …
        › foreach ($listeners as $listener) {
        ›     $listener->authenticate($event);
        › 
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:88 {
        Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners(RequestEvent $event, iterable $listeners): void …
        › 
        › $listener->authenticate($event);
        › 
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/security-http/Firewall.php:86 {
        Symfony\Component\Security\Http\Firewall->onKernelRequest(RequestEvent $event): void …
        › 
        ›     $this->callListeners($event, $authenticationListeners());
        › }
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115 {
        Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
        › try {
        ›     ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
        › } finally {
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/event-dispatcher/EventDispatcher.php:206 {
        Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event): void …
        ›     }
        ›     $listener($event, $eventName, $this);
        › }
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/event-dispatcher/EventDispatcher.php:56 {
        Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, ?string $eventName = null): object …
        › if ($listeners) {
        ›     $this->callListeners($listeners, $eventName, $event);
        › }
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:129 {
        Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, ?string $eventName = null): object …
        › try {
        ›     $this->dispatcher->dispatch($event, $eventName);
        › } finally {
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/http-kernel/HttpKernel.php:162 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST, ?ControllerMetadata &$controllerMetadata = null): Response …
        › $event = new RequestEvent($this, $request, $type);
        › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
        › 
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/http-kernel/HttpKernel.php:79 {
        Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
        › try {
        ›     return $response = $this->handleRaw($request, $type, $controllerMetadata);
        › } catch (\Throwable $e) {
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/http-kernel/Kernel.php:143 {
        Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
        › try {
        ›     return $this->getHttpKernel()->handle($request, $type, $catch);
        › } finally {
      }
      /home/raphaelsalique/Public/flashcard/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /home/raphaelsalique/Public/flashcard/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /home/raphaelsalique/Public/flashcard/public/index.php:5 {
        › 
        › require_once dirname(__DIR__) . '/vendor/autoload_runtime.php';
        › 
        arguments: {
          "/home/raphaelsalique/Public/flashcard/vendor/autoload_runtime.php"
        }
      }
    }
  }
]

{
  /home/raphaelsalique/Public/flashcard/vendor/symfony/security-http/Firewall/AccessListener.php:79 {
    Symfony\Component\Security\Http\Firewall\AccessListener->authenticate(RequestEvent $event): void …
    › if (!$accessDecision->isGranted = $this->accessDecisionManager->decide($token, $attributes, $request, $accessDecision, true)) {
    ›     $e = new AccessDeniedException($accessDecision->getMessage());
    ›     $e->setAttributes($attributes);
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/security-bundle/Debug/WrappedLazyListener.php:52 {
    Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate(RequestEvent $event): void …
    › try {
    ›     $this->listener->authenticate($event);
    › } catch (LazyResponseException $e) {
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/security-bundle/Security/LazyFirewallContext.php:64 {
    Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate(RequestEvent $event): void …
    › foreach ($listeners as $listener) {
    ›     $listener->authenticate($event);
    › 
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:88 {
    Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners(RequestEvent $event, iterable $listeners): void …
    › 
    › $listener->authenticate($event);
    › 
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/security-http/Firewall.php:86 {
    Symfony\Component\Security\Http\Firewall->onKernelRequest(RequestEvent $event): void …
    › 
    ›     $this->callListeners($event, $authenticationListeners());
    › }
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115 {
    Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
    › try {
    ›     ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
    › } finally {
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/event-dispatcher/EventDispatcher.php:206 {
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event): void …
    ›     }
    ›     $listener($event, $eventName, $this);
    › }
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/event-dispatcher/EventDispatcher.php:56 {
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, ?string $eventName = null): object …
    › if ($listeners) {
    ›     $this->callListeners($listeners, $eventName, $event);
    › }
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:129 {
    Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, ?string $eventName = null): object …
    › try {
    ›     $this->dispatcher->dispatch($event, $eventName);
    › } finally {
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/http-kernel/HttpKernel.php:162 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST, ?ControllerMetadata &$controllerMetadata = null): Response …
    › $event = new RequestEvent($this, $request, $type);
    › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
    › 
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/http-kernel/HttpKernel.php:79 {
    Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
    › try {
    ›     return $response = $this->handleRaw($request, $type, $controllerMetadata);
    › } catch (\Throwable $e) {
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/http-kernel/Kernel.php:143 {
    Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
    › try {
    ›     return $this->getHttpKernel()->handle($request, $type, $catch);
    › } finally {
  }
  /home/raphaelsalique/Public/flashcard/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /home/raphaelsalique/Public/flashcard/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /home/raphaelsalique/Public/flashcard/public/index.php:5 {
    › 
    › require_once dirname(__DIR__) . '/vendor/autoload_runtime.php';
    › 
    arguments: {
      "/home/raphaelsalique/Public/flashcard/vendor/autoload_runtime.php"
    }
  }
}

[
  "entry_point" => App\Security\LoginFormAuthenticator {#460
    -urlGenerator: Symfony\Bundle\FrameworkBundle\Routing\Router {#177 …}
    -authUsername: "raphael"
    -authPassword: "flash@stpwlsd!"
  }
]

[
  "params" => [
    "driver" => "pdo_sqlite"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "root"
    "password" => null
    "driverOptions" => []
    "defaultTableOptions" => []
    "path" => "/home/raphaelsalique/Public/flashcard/var/data.db"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT 'main'"
]

[
  "sql" => """
    SELECT name AS table_name\n
    FROM sqlite_master\n
    WHERE type = 'table'\n
      AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence')\n
    UNION ALL\n
    SELECT name\n
    FROM sqlite_temp_master\n
    WHERE type = 'table'\n
    ORDER BY name
    """
]

[
  "sql" => "SELECT 'main'"
]

[
  "sql" => """
    SELECT name AS table_name\n
    FROM sqlite_master\n
    WHERE type = 'table'\n
      AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence')\n
    UNION ALL\n
    SELECT name\n
    FROM sqlite_temp_master\n
    WHERE type = 'table'\n
    ORDER BY name
    """
]

[
  "sql" => """
    SELECT t.name,\n
           c.name,\n
           c.type,\n
           c."notnull",\n
           c.dflt_value\n
    FROM sqlite_master t\n
             JOIN pragma_table_info(t.name) c\n
    WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
    ORDER BY t.name,\n
             c.cid
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#813
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT sql\n
    FROM sqlite_master\n
    WHERE type = 'table'\n
      AND name = ?
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#813
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT sql\n
    FROM sqlite_master\n
    WHERE type = 'table'\n
      AND name = ?
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#813
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
        SELECT t.name,\n
               c.name\n
        FROM sqlite_master t\n
                 JOIN pragma_table_info(t.name) c\n
        WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
          AND c.pk > 0\n
        ORDER BY t.name,\n
                 c.pk
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#813
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT t.name,\n
           i.name,\n
           i."unique",\n
           c.name\n
    FROM sqlite_master t\n
             JOIN pragma_index_list(t.name) i\n
             JOIN pragma_index_info(i.name) c\n
    WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
      AND i.name NOT LIKE 'sqlite_%'\n
    ORDER BY t.name,\n
             i.name,\n
             c.seqno
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#813
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
                SELECT t.name,\n
                       c.id,\n
                       c."table",\n
                       c.on_update,\n
                       c.on_delete,\n
                       c."from",\n
                       c."to"\n
                FROM sqlite_master t\n
                         JOIN pragma_foreign_key_list(t.name) c\n
                WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
                ORDER BY t.name,\n
                         c.id DESC,\n
                         c.seq
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#813
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT 'main'"
]