Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Log Messages

"astisoft_login"

[
  "route" => "astisoft_login"
  "route_parameters" => [
    "_route" => "astisoft_login"
    "astisoft_host" => "astisoft.develop.compay.name"
    "_controller" => "App\Controller\AstisoftController::login"
  ]
  "request_uri" => "https://astisoft.develop.compay.name/site/login"
  "method" => "GET"
]

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

[
  "use_savepoints" => true
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "yii_remote"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "compayy_new_prod"
  "serverVersion" => "8.0"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "yii_remote"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "compayy_new_prod"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "exception" => ErrorException {#665
    #message: "User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:80 called by AbstractDriverMiddleware.php:32, https://github.com/doctrine/dbal/pull/6343, package doctrine/dbal)"
    #code: 0
    #file: "/home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/deprecations/src/Deprecation.php"
    #line: 208
    #severity: E_USER_DEPRECATED
    trace: {
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/deprecations/src/Deprecation.php:208 {
        Doctrine\Deprecations\Deprecation::delegateTriggerToBackend(string $message, array $backtrace, string $link, string $package): void …
        › 
        ›     @trigger_error($message, E_USER_DEPRECATED);
        › }
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/deprecations/src/Deprecation.php:108 {
        Doctrine\Deprecations\Deprecation::trigger(string $package, string $link, string $message, ...$args): void …
        › 
        ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
        › }
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:80 {
        Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
        › 
        › Deprecation::trigger(
        ›     'doctrine/dbal',
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Connection.php:196 {
        Doctrine\DBAL\Connection->getDatabasePlatform(): AbstractPlatform …
        › 
        ›     $this->platform = $this->driver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Connection.php:1433 {
        Doctrine\DBAL\Connection->expandArrayParameters(string $sql, array $params, array $types): array …
        › 
        › $this->parser ??= $this->getDatabasePlatform()->createSQLParser();
        › $visitor        = new ExpandArrayParameters($params, $types);
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Connection.php:794 {
        Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
        › if (count($params) > 0) {
        ›     [$sql, $params, $types] = $this->expandArrayParameters($sql, $params, $types);
        › 
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Connection.php:620 {
        Doctrine\DBAL\Connection->fetchAllAssociative(string $query, array $params = [], array $types = []): array …
        › {
        ›     return $this->executeQuery($query, $params, $types)->fetchAllAssociative();
        › }
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/src/Repository/LegacyCatalogRepository.php:18 {
        App\Repository\LegacyCatalogRepository->categories(int $siteId): array …
        › {
        ›     return $this->connection->fetchAllAssociative(
        ›         'SELECT c.id, c.parent_id, c.image, c.sort_order, cd.name, cd.description
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/src/Controller/AstisoftController.php:236 {
        App\Controller\AstisoftController->login(Request $request): Response …
        ›     'site' => $site,
        ›     'categories' => $this->catalog->categories($site->id),
        › ]);
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/symfony/http-kernel/HttpKernel.php:183 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
        › // call controller
        › $response = $controller(...$arguments);
        › 
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/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) {
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/symfony/http-kernel/Kernel.php:193 {
        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/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /home/compayy/web/symfonyd.compay.name/public_html/symfony/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
      }
    }
  }
]

{
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/deprecations/src/Deprecation.php:208 {
    Doctrine\Deprecations\Deprecation::delegateTriggerToBackend(string $message, array $backtrace, string $link, string $package): void …
    › 
    ›     @trigger_error($message, E_USER_DEPRECATED);
    › }
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/deprecations/src/Deprecation.php:108 {
    Doctrine\Deprecations\Deprecation::trigger(string $package, string $link, string $message, ...$args): void …
    › 
    ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
    › }
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:80 {
    Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
    › 
    › Deprecation::trigger(
    ›     'doctrine/dbal',
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Connection.php:196 {
    Doctrine\DBAL\Connection->getDatabasePlatform(): AbstractPlatform …
    › 
    ›     $this->platform = $this->driver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Connection.php:1433 {
    Doctrine\DBAL\Connection->expandArrayParameters(string $sql, array $params, array $types): array …
    › 
    › $this->parser ??= $this->getDatabasePlatform()->createSQLParser();
    › $visitor        = new ExpandArrayParameters($params, $types);
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Connection.php:794 {
    Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
    › if (count($params) > 0) {
    ›     [$sql, $params, $types] = $this->expandArrayParameters($sql, $params, $types);
    › 
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/doctrine/dbal/src/Connection.php:620 {
    Doctrine\DBAL\Connection->fetchAllAssociative(string $query, array $params = [], array $types = []): array …
    › {
    ›     return $this->executeQuery($query, $params, $types)->fetchAllAssociative();
    › }
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/src/Repository/LegacyCatalogRepository.php:18 {
    App\Repository\LegacyCatalogRepository->categories(int $siteId): array …
    › {
    ›     return $this->connection->fetchAllAssociative(
    ›         'SELECT c.id, c.parent_id, c.image, c.sort_order, cd.name, cd.description
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/src/Controller/AstisoftController.php:236 {
    App\Controller\AstisoftController->login(Request $request): Response …
    ›     'site' => $site,
    ›     'categories' => $this->catalog->categories($site->id),
    › ]);
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/symfony/http-kernel/HttpKernel.php:183 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
    › // call controller
    › $response = $controller(...$arguments);
    › 
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/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) {
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/symfony/http-kernel/Kernel.php:193 {
    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/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /home/compayy/web/symfonyd.compay.name/public_html/symfony/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
  }
}

"""
SELECT c.id, c.parent_id, c.image, c.sort_order, cd.name, cd.description\n
             FROM category c\n
             LEFT JOIN category_description cd ON cd.category_id = c.id AND cd.language_id = ?\n
             WHERE c.site_id = ? AND c.status = 1\n
             ORDER BY c.sort_order ASC, c.id ASC
"""

[
  1 => "en"
  2 => 26
]

[
  1 => Doctrine\DBAL\ParameterType {#692
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#692}
]

[
  "sql" => """
    SELECT c.id, c.parent_id, c.image, c.sort_order, cd.name, cd.description\n
                 FROM category c\n
                 LEFT JOIN category_description cd ON cd.category_id = c.id AND cd.language_id = ?\n
                 WHERE c.site_id = ? AND c.status = 1\n
                 ORDER BY c.sort_order ASC, c.id ASC
    """
  "params" => [
    1 => "en"
    2 => 26
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#692}
  ]
]