Symfony Profiler

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

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#2653
    +count: 2
    -severity: E_USER_DEPRECATED
    trace: {
      /home/spedi/spedi/vendor/symfony/config/Definition/ArrayNode.php:228 {
        Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
        ›     $deprecation = $child->getDeprecation($name, $this->getPath());
        ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
        › }
      }
      /home/spedi/spedi/vendor/symfony/config/Definition/BaseNode.php:420 {
        › 
        › $value = $this->finalizeValue($value);
        › 
      }
    }
  }
]

{
  /home/spedi/spedi/vendor/symfony/config/Definition/ArrayNode.php:228 {
    Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
    ›     $deprecation = $child->getDeprecation($name, $this->getPath());
    ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
    › }
  }
  /home/spedi/spedi/vendor/symfony/config/Definition/BaseNode.php:420 {
    › 
    › $value = $this->finalizeValue($value);
    › 
  }
}

"app_register"

[
  "route" => "app_register"
  "route_parameters" => [
    "_route" => "app_register"
    "_controller" => "App\Controller\RegistrationController::register"
  ]
  "request_uri" => "https://spedi.ku.edu/register"
  "method" => "POST"
]

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

[
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "unit2db.ku.edu"
  "port" => 3306
  "user" => "spedi_user"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "spedi_app"
  "serverVersion" => "8.0.32"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "unit2db.ku.edu"
    "port" => 3306
    "user" => "spedi_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "spedi_app"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

"SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.birth_year AS birth_year_6, t0.gender AS gender_7, t0.education_level AS education_level_8, t0.disorders AS disorders_9, t0.disorders_other AS disorders_other_10, t0.primary_language AS primary_language_11, t0.secondary_language AS secondary_language_12, t0.region_dialect AS region_dialect_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15 FROM users t0 WHERE t0.email = ? LIMIT 2"

[
  1 => "1gyhujjikk@anonmails.de"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.birth_year AS birth_year_6, t0.gender AS gender_7, t0.education_level AS education_level_8, t0.disorders AS disorders_9, t0.disorders_other AS disorders_other_10, t0.primary_language AS primary_language_11, t0.secondary_language AS secondary_language_12, t0.region_dialect AS region_dialect_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15 FROM users t0 WHERE t0.email = ? LIMIT 2"
  "params" => [
    1 => "1gyhujjikk@anonmails.de"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1469
      +name: "STRING"
    }
  ]
]

"SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.birth_year AS birth_year_6, t0.gender AS gender_7, t0.education_level AS education_level_8, t0.disorders AS disorders_9, t0.disorders_other AS disorders_other_10, t0.primary_language AS primary_language_11, t0.secondary_language AS secondary_language_12, t0.region_dialect AS region_dialect_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15 FROM users t0 WHERE t0.username = ? LIMIT 2"

[
  1 => "Davidmerly"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.birth_year AS birth_year_6, t0.gender AS gender_7, t0.education_level AS education_level_8, t0.disorders AS disorders_9, t0.disorders_other AS disorders_other_10, t0.primary_language AS primary_language_11, t0.secondary_language AS secondary_language_12, t0.region_dialect AS region_dialect_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15 FROM users t0 WHERE t0.username = ? LIMIT 2"
  "params" => [
    1 => "Davidmerly"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1469
      +name: "STRING"
    }
  ]
]

"INSERT INTO users (username, email, roles, password, birth_year, gender, education_level, disorders, disorders_other, primary_language, secondary_language, region_dialect, reset_token, reset_token_expires_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

[
  1 => "Davidmerly"
  2 => "1gyhujjikk@anonmails.de"
  3 => "[]"
  4 => "$2y$13$keaEyJnTISxRbS0EfnClWOyKLi2S7B2f6uRs4ye83Maveo6I8dRam"
  5 => 1937
  6 => "female"
  7 => "someCollege"
  8 => "[]"
  9 => """
    <img src="https://i.ibb.co/4nRc7Mhd/1win.jpg">\n
    \n
    \n
        Для всех игроков: Эти поощрения доступны для всех клиентов, независимо от их опыта и статуса.\n
        Выберите удобный вариант регистрации: в 1 клик, через социальные сети или почтовый ящик.\n
    1Win Промокод Казахстан: 1W2026FREE предназначен для новых пользователей. Он позволяет получить бонус до 500%. При регистрации на 1win необходимо указать этот промокод, чтобы активировать все доступные акции и бонусы на вашем аккаунте. Срок действия промокода истекает 31 декабря 2026 года.\n
        Возможность выиграть крупные призы в розыгрышах, доступ к которым открывается только после использования промокода 1win.\n
    После того как вы зарегистрировались и ввели промокод 1win для пополнения счета и получения приветственного бонуса, вы можете начать игру. Однако, нельзя сразу вывести бонусные средства - сначала их нужно отыграть. <a href=https://mywrite.ru/blacksprut-sc-zerkalo.html><img src="https://san2.ru/smiles/smile.gif"></a>
    """
  10 => "en"
  11 => "en"
  12 => "en_JP"
  13 => null
  14 => null
]

[
  1 => Doctrine\DBAL\ParameterType {#1469
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#1469}
  3 => Doctrine\DBAL\ParameterType {#1469}
  4 => Doctrine\DBAL\ParameterType {#1469}
  5 => Doctrine\DBAL\ParameterType {#1471
    +name: "INTEGER"
  }
  6 => Doctrine\DBAL\ParameterType {#1469}
  7 => Doctrine\DBAL\ParameterType {#1469}
  8 => Doctrine\DBAL\ParameterType {#1469}
  9 => Doctrine\DBAL\ParameterType {#1469}
  10 => Doctrine\DBAL\ParameterType {#1469}
  11 => Doctrine\DBAL\ParameterType {#1469}
  12 => Doctrine\DBAL\ParameterType {#1469}
  13 => Doctrine\DBAL\ParameterType {#1469}
  14 => Doctrine\DBAL\ParameterType {#1469}
]

[
  "sql" => "INSERT INTO users (username, email, roles, password, birth_year, gender, education_level, disorders, disorders_other, primary_language, secondary_language, region_dialect, reset_token, reset_token_expires_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "Davidmerly"
    2 => "1gyhujjikk@anonmails.de"
    3 => "[]"
    4 => "$2y$13$keaEyJnTISxRbS0EfnClWOyKLi2S7B2f6uRs4ye83Maveo6I8dRam"
    5 => 1937
    6 => "female"
    7 => "someCollege"
    8 => "[]"
    9 => """
      <img src="https://i.ibb.co/4nRc7Mhd/1win.jpg">\n
      \n
      \n
          Для всех игроков: Эти поощрения доступны для всех клиентов, независимо от их опыта и статуса.\n
          Выберите удобный вариант регистрации: в 1 клик, через социальные сети или почтовый ящик.\n
      1Win Промокод Казахстан: 1W2026FREE предназначен для новых пользователей. Он позволяет получить бонус до 500%. При регистрации на 1win необходимо указать этот промокод, чтобы активировать все доступные акции и бонусы на вашем аккаунте. Срок действия промокода истекает 31 декабря 2026 года.\n
          Возможность выиграть крупные призы в розыгрышах, доступ к которым открывается только после использования промокода 1win.\n
      После того как вы зарегистрировались и ввели промокод 1win для пополнения счета и получения приветственного бонуса, вы можете начать игру. Однако, нельзя сразу вывести бонусные средства - сначала их нужно отыграть. <a href=https://mywrite.ru/blacksprut-sc-zerkalo.html><img src="https://san2.ru/smiles/smile.gif"></a>
      """
    10 => "en"
    11 => "en"
    12 => "en_JP"
    13 => null
    14 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1469
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1469}
    3 => Doctrine\DBAL\ParameterType {#1469}
    4 => Doctrine\DBAL\ParameterType {#1469}
    5 => Doctrine\DBAL\ParameterType {#1471
      +name: "INTEGER"
    }
    6 => Doctrine\DBAL\ParameterType {#1469}
    7 => Doctrine\DBAL\ParameterType {#1469}
    8 => Doctrine\DBAL\ParameterType {#1469}
    9 => Doctrine\DBAL\ParameterType {#1469}
    10 => Doctrine\DBAL\ParameterType {#1469}
    11 => Doctrine\DBAL\ParameterType {#1469}
    12 => Doctrine\DBAL\ParameterType {#1469}
    13 => Doctrine\DBAL\ParameterType {#1469}
    14 => Doctrine\DBAL\ParameterType {#1469}
  ]
]

[
  "exception" => Doctrine\DBAL\Exception\DriverException {#1504
    #message: "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'disorders_other' at row 1"
    #code: 1406
    #file: "/home/spedi/spedi/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
    #line: 102
    -previous: Doctrine\DBAL\Driver\PDO\Exception {#1501 …}
    -query: Doctrine\DBAL\Query {#1497 …}
    trace: {
      /home/spedi/spedi/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:102 {
        Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
        ›     1566 => new NotNullConstraintViolationException($exception, $query),
        ›     default => new DriverException($exception, $query),
        › };
      }
      /home/spedi/spedi/vendor/doctrine/dbal/src/Connection.php:1460 {
        Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
        › $this->exceptionConverter ??= $this->driver->getExceptionConverter();
        › $exception                  = $this->exceptionConverter->convert($driverException, $query);
        › 
        arguments: {
          $exception: Doctrine\DBAL\Driver\PDO\Exception {#1501 …}
          $query: Doctrine\DBAL\Query {#1497 …}
        }
      }
      /home/spedi/spedi/vendor/doctrine/dbal/src/Connection.php:1396 {
        Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
        › ): DriverException {
        ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
        › }
        arguments: {
          $driverException: Doctrine\DBAL\Driver\PDO\Exception {#1501 …}
          $query: Doctrine\DBAL\Query {#1497 …}
        }
      }
      /home/spedi/spedi/vendor/doctrine/dbal/src/Statement.php:108 {
        Doctrine\DBAL\Statement->execute(): Result …
        › } catch (Driver\Exception $ex) {
        ›     throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
        › }
        arguments: {
          $e: Doctrine\DBAL\Driver\PDO\Exception {#1501 …}
          $sql: "INSERT INTO users (username, email, roles, password, birth_year, gender, education_level, disorders, disorders_other, primary_language, secondary_language, region_dialect, reset_token, reset_token_expires_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
          $params: [ …14]
          $types: [ …14]
        }
      }
      /home/spedi/spedi/vendor/doctrine/dbal/src/Statement.php:133 {
        Doctrine\DBAL\Statement->executeStatement(): string|int …
        › {
        ›     return $this->execute()->rowCount();
        › }
      }
      /home/spedi/spedi/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:253 {
        Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts(): void …
        › 
        › $stmt->executeStatement();
        › 
      }
      /home/spedi/spedi/vendor/doctrine/orm/src/UnitOfWork.php:1060 {
        Doctrine\ORM\UnitOfWork->executeInserts(): void …
        › 
        › $persister->executeInserts();
        › 
      }
      /home/spedi/spedi/vendor/doctrine/orm/src/UnitOfWork.php:403 {
        Doctrine\ORM\UnitOfWork->commit(): void …
        ›     // in the database.
        ›     $this->executeInserts();
        › }
      }
      /home/spedi/spedi/vendor/doctrine/orm/src/EntityManager.php:268 {
        Doctrine\ORM\EntityManager->flush(): void …
        ›     $this->errorIfClosed();
        ›     $this->unitOfWork->commit();
        › }
      }
      /home/spedi/spedi/src/Controller/RegistrationController.php:38 {
        App\Controller\RegistrationController->register(Request $request, UserPasswordHasherInterface $userPasswordHasher, EntityManagerInterface $entityManager): Response …
        › $entityManager->persist($user);
        › $entityManager->flush();
        › 
      }
      /home/spedi/spedi/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);
        › 
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#2 …}
          $userPasswordHasher: Symfony\Component\PasswordHasher\Hasher\UserPasswordHasher {#711 …}
          $entityManager: Doctrine\ORM\EntityManager {#245 …}
        }
      }
      /home/spedi/spedi/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) {
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#2 …}
          $type: 1
        }
      }
      /home/spedi/spedi/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 {
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#2 …}
          $type: 1
          $catch: true
        }
      }
      /home/spedi/spedi/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#2 …}
        }
      }
      /home/spedi/spedi/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /home/spedi/spedi/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
        arguments: {
          "/home/spedi/spedi/vendor/autoload_runtime.php"
        }
      }
    }
  }
]

{
  /home/spedi/spedi/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:102 {
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
    ›     1566 => new NotNullConstraintViolationException($exception, $query),
    ›     default => new DriverException($exception, $query),
    › };
  }
  /home/spedi/spedi/vendor/doctrine/dbal/src/Connection.php:1460 {
    Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
    › $this->exceptionConverter ??= $this->driver->getExceptionConverter();
    › $exception                  = $this->exceptionConverter->convert($driverException, $query);
    › 
    arguments: {
      $exception: Doctrine\DBAL\Driver\PDO\Exception {#1501 …}
      $query: Doctrine\DBAL\Query {#1497 …}
    }
  }
  /home/spedi/spedi/vendor/doctrine/dbal/src/Connection.php:1396 {
    Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
    › ): DriverException {
    ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
    › }
    arguments: {
      $driverException: Doctrine\DBAL\Driver\PDO\Exception {#1501 …}
      $query: Doctrine\DBAL\Query {#1497 …}
    }
  }
  /home/spedi/spedi/vendor/doctrine/dbal/src/Statement.php:108 {
    Doctrine\DBAL\Statement->execute(): Result …
    › } catch (Driver\Exception $ex) {
    ›     throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
    › }
    arguments: {
      $e: Doctrine\DBAL\Driver\PDO\Exception {#1501 …}
      $sql: "INSERT INTO users (username, email, roles, password, birth_year, gender, education_level, disorders, disorders_other, primary_language, secondary_language, region_dialect, reset_token, reset_token_expires_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
      $params: [ …14]
      $types: [ …14]
    }
  }
  /home/spedi/spedi/vendor/doctrine/dbal/src/Statement.php:133 {
    Doctrine\DBAL\Statement->executeStatement(): string|int …
    › {
    ›     return $this->execute()->rowCount();
    › }
  }
  /home/spedi/spedi/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:253 {
    Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts(): void …
    › 
    › $stmt->executeStatement();
    › 
  }
  /home/spedi/spedi/vendor/doctrine/orm/src/UnitOfWork.php:1060 {
    Doctrine\ORM\UnitOfWork->executeInserts(): void …
    › 
    › $persister->executeInserts();
    › 
  }
  /home/spedi/spedi/vendor/doctrine/orm/src/UnitOfWork.php:403 {
    Doctrine\ORM\UnitOfWork->commit(): void …
    ›     // in the database.
    ›     $this->executeInserts();
    › }
  }
  /home/spedi/spedi/vendor/doctrine/orm/src/EntityManager.php:268 {
    Doctrine\ORM\EntityManager->flush(): void …
    ›     $this->errorIfClosed();
    ›     $this->unitOfWork->commit();
    › }
  }
  /home/spedi/spedi/src/Controller/RegistrationController.php:38 {
    App\Controller\RegistrationController->register(Request $request, UserPasswordHasherInterface $userPasswordHasher, EntityManagerInterface $entityManager): Response …
    › $entityManager->persist($user);
    › $entityManager->flush();
    › 
  }
  /home/spedi/spedi/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);
    › 
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#2 …}
      $userPasswordHasher: Symfony\Component\PasswordHasher\Hasher\UserPasswordHasher {#711 …}
      $entityManager: Doctrine\ORM\EntityManager {#245 …}
    }
  }
  /home/spedi/spedi/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) {
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#2 …}
      $type: 1
    }
  }
  /home/spedi/spedi/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 {
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#2 …}
      $type: 1
      $catch: true
    }
  }
  /home/spedi/spedi/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#2 …}
    }
  }
  /home/spedi/spedi/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /home/spedi/spedi/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
    arguments: {
      "/home/spedi/spedi/vendor/autoload_runtime.php"
    }
  }
}