Symfony Profiler

[
  "route" => "main_index"
  "route_parameters" => [
    "_route" => "main_index"
    "_controller" => "App\Controller\MainMenuController::index"
  ]
  "request_uri" => "https://ambiente-test.amaeco.it/"
  "method" => "GET"
]

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

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

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

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

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

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

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

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

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

[
  "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 {#543
    #message: "Access Denied. The user doesn't have ROLE_USER."
    #code: 403
    #file: "/var/www/ambiente-test/vendor/symfony/security-http/Firewall/AccessListener.php"
    #line: 79
    -attributes: [
      "ROLE_USER"
    ]
    -subject: Symfony\Component\HttpFoundation\Request {#22 …}
    -accessDecision: Symfony\Component\Security\Core\Authorization\AccessDecision {#547 …}
    trace: {
      /var/www/ambiente-test/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);
      }
      /var/www/ambiente-test/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) {
      }
      /var/www/ambiente-test/vendor/symfony/security-bundle/Security/LazyFirewallContext.php:64 {
        Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate(RequestEvent $event): void …
        › foreach ($listeners as $listener) {
        ›     $listener->authenticate($event);
        › 
      }
      /var/www/ambiente-test/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:88 {
        Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners(RequestEvent $event, iterable $listeners): void …
        › 
        › $listener->authenticate($event);
        › 
      }
      /var/www/ambiente-test/vendor/symfony/security-http/Firewall.php:86 {
        Symfony\Component\Security\Http\Firewall->onKernelRequest(RequestEvent $event): void …
        › 
        ›     $this->callListeners($event, $authenticationListeners());
        › }
      }
      /var/www/ambiente-test/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 {
      }
      /var/www/ambiente-test/vendor/symfony/event-dispatcher/EventDispatcher.php:206 {
        Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event): void …
        ›     }
        ›     $listener($event, $eventName, $this);
        › }
      }
      /var/www/ambiente-test/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);
        › }
      }
      /var/www/ambiente-test/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 {
      }
      /var/www/ambiente-test/vendor/symfony/http-kernel/HttpKernel.php:159 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
        › $event = new RequestEvent($this, $request, $type);
        › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
        › 
      }
      /var/www/ambiente-test/vendor/symfony/http-kernel/HttpKernel.php:76 {
        Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
        › try {
        ›     return $response = $this->handleRaw($request, $type);
        › } catch (\Throwable $e) {
      }
      /var/www/ambiente-test/vendor/symfony/http-kernel/Kernel.php:191 {
        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 {
      }
      /var/www/ambiente-test/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /var/www/ambiente-test/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /var/www/ambiente-test/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
        arguments: {
          "/var/www/ambiente-test/vendor/autoload_runtime.php"
        }
      }
    }
  }
]

{
  /var/www/ambiente-test/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);
  }
  /var/www/ambiente-test/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) {
  }
  /var/www/ambiente-test/vendor/symfony/security-bundle/Security/LazyFirewallContext.php:64 {
    Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate(RequestEvent $event): void …
    › foreach ($listeners as $listener) {
    ›     $listener->authenticate($event);
    › 
  }
  /var/www/ambiente-test/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:88 {
    Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners(RequestEvent $event, iterable $listeners): void …
    › 
    › $listener->authenticate($event);
    › 
  }
  /var/www/ambiente-test/vendor/symfony/security-http/Firewall.php:86 {
    Symfony\Component\Security\Http\Firewall->onKernelRequest(RequestEvent $event): void …
    › 
    ›     $this->callListeners($event, $authenticationListeners());
    › }
  }
  /var/www/ambiente-test/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 {
  }
  /var/www/ambiente-test/vendor/symfony/event-dispatcher/EventDispatcher.php:206 {
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event): void …
    ›     }
    ›     $listener($event, $eventName, $this);
    › }
  }
  /var/www/ambiente-test/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);
    › }
  }
  /var/www/ambiente-test/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 {
  }
  /var/www/ambiente-test/vendor/symfony/http-kernel/HttpKernel.php:159 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
    › $event = new RequestEvent($this, $request, $type);
    › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
    › 
  }
  /var/www/ambiente-test/vendor/symfony/http-kernel/HttpKernel.php:76 {
    Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
    › try {
    ›     return $response = $this->handleRaw($request, $type);
    › } catch (\Throwable $e) {
  }
  /var/www/ambiente-test/vendor/symfony/http-kernel/Kernel.php:191 {
    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 {
  }
  /var/www/ambiente-test/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /var/www/ambiente-test/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /var/www/ambiente-test/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
    arguments: {
      "/var/www/ambiente-test/vendor/autoload_runtime.php"
    }
  }
}

[
  "entry_point" => Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator {#253
    -options: [
      "username_parameter" => "_username"
      "password_parameter" => "_password"
      "check_path" => "account_login"
      "post_only" => true
      "form_only" => false
      "enable_csrf" => true
      "csrf_parameter" => "_csrf_token"
      "csrf_token_id" => "authenticate"
      "login_path" => "account_login"
      "use_forward" => false
    ]
    -httpKernel: ? Symfony\Component\HttpKernel\HttpKernelInterface
    -httpUtils: Symfony\Component\Security\Http\HttpUtils {#336 …}
    -userProvider: Symfony\Bridge\Doctrine\Security\User\EntityUserProvider {#281 …}
    -successHandler: Symfony\Component\Security\Http\Authentication\DefaultAuthenticationSuccessHandler {#286 …}
    -failureHandler: Symfony\Component\Security\Http\Authentication\DefaultAuthenticationFailureHandler {#393 …}
  }
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "amaecosql01.c8xef5u0pxvk.eu-west-3.rds.amazonaws.com"
    "port" => 3306
    "user" => "ambuser"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "ambiente_test"
    "serverVersion" => "10.6.11-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "ambiente_test"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#968
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "ambiente_test"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#968
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT @@character_set_database, @@collation_database"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT c.TABLE_NAME,\n
           c.COLUMN_NAME,\n
               IF(\n
            c.DATA_TYPE = 'longtext'\n
            AND EXISTS(\n
                SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c\n
                WHERE i_c.CONSTRAINT_SCHEMA = 'ambiente_test'\n
                AND i_c.TABLE_NAME = c.TABLE_NAME\n
                AND i_c.CHECK_CLAUSE = CONCAT(\n
                    'json_valid(`',\n
                        c.COLUMN_NAME,\n
                    '`)'\n
                )\n
            ),\n
            'json',\n
            c.DATA_TYPE\n
        ),\n
           c.COLUMN_TYPE,\n
           c.CHARACTER_MAXIMUM_LENGTH,\n
           c.CHARACTER_OCTET_LENGTH,\n
           c.NUMERIC_PRECISION,\n
           c.NUMERIC_SCALE,\n
           c.IS_NULLABLE,\n
           c.COLUMN_DEFAULT,\n
           c.EXTRA,\n
           c.COLUMN_COMMENT,\n
           c.CHARACTER_SET_NAME,\n
           c.COLLATION_NAME\n
    FROM information_schema.COLUMNS c\n
             INNER JOIN information_schema.TABLES t\n
                        ON t.TABLE_NAME = c.TABLE_NAME\n
    WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ?\n
      AND t.TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY c.TABLE_NAME,\n
             c.ORDINAL_POSITION
    """
  "params" => [
    1 => "ambiente_test"
    2 => "ambiente_test"
    3 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#968
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#968}
    3 => Doctrine\DBAL\ParameterType {#968}
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
        SELECT t.TABLE_NAME,\n
               t.ENGINE,\n
               t.AUTO_INCREMENT,\n
               t.TABLE_COMMENT,\n
               t.CREATE_OPTIONS,\n
               t.TABLE_COLLATION,\n
               ccsa.CHARACTER_SET_NAME\n
          FROM information_schema.TABLES t\n
            INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa\n
              ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
    """
  "params" => [
    1 => "ambiente_test"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#968
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#968}
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT tc.TABLE_NAME,\n
           tc.CONSTRAINT_NAME,\n
           kcu.COLUMN_NAME\n
    FROM information_schema.TABLE_CONSTRAINTS tc\n
             INNER JOIN information_schema.KEY_COLUMN_USAGE kcu\n
                        ON kcu.TABLE_NAME = tc.TABLE_NAME\n
                            AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME\n
    WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ?\n
      AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'\n
    ORDER BY TABLE_NAME,\n
        kcu.ORDINAL_POSITION
    """
  "params" => [
    1 => "ambiente_test"
    2 => "ambiente_test"
    3 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#968
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#968}
    3 => Doctrine\DBAL\ParameterType {#968}
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME,\n
           INDEX_NAME,\n
           INDEX_TYPE,\n
           NON_UNIQUE,\n
           COLUMN_NAME,\n
           SUB_PART\n
    FROM information_schema.STATISTICS\n
    WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?\n
      AND INDEX_NAME != 'PRIMARY'\n
    ORDER BY TABLE_NAME,\n
        SEQ_IN_INDEX
    """
  "params" => [
    1 => "ambiente_test"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#968
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#968}
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT k.TABLE_NAME,\n
           k.CONSTRAINT_NAME,\n
           k.REFERENCED_TABLE_NAME,\n
           c.UPDATE_RULE,\n
           c.DELETE_RULE,\n
           k.COLUMN_NAME,\n
           k.REFERENCED_COLUMN_NAME\n
    FROM information_schema.KEY_COLUMN_USAGE k\n
             INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c\n
                        ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\n
                            AND c.TABLE_NAME = k.TABLE_NAME\n
    WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?\n
      AND k.REFERENCED_COLUMN_NAME IS NOT NULL\n
    ORDER BY k.TABLE_NAME,\n
             k.CONSTRAINT_NAME,\n
             k.ORDINAL_POSITION
    """
  "params" => [
    1 => "ambiente_test"
    2 => "ambiente_test"
    3 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#968
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#968}
    3 => Doctrine\DBAL\ParameterType {#968}
  ]
]

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

[
  "sql" => "SELECT DATABASE()"
]