Symfony Profiler

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

Log Messages

"score_index"

[
  "route" => "score_index"
  "route_parameters" => [
    "_route" => "score_index"
    "_controller" => "App\Controller\ScoreController::index"
  ]
  "request_uri" => "http://wsl-dev.taile26cbc.ts.net/?dir=asc&page=3"
  "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" => "medieval"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "medieval"
  "serverVersion" => "10.11.2-MariaDB"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "medieval"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "medieval"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

"SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, title_1 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.composer AS composer_2, s0_.source AS source_3, s0_.library AS library_4, s0_.century AS century_5, s0_.genre AS genre_6, s0_.performance_type AS performance_type_7, s0_.solo_instrument AS solo_instrument_8, s0_.notes AS notes_9, s0_.source_url AS source_url_10, s0_.rism_incipit_url AS rism_incipit_url_11 FROM score s0_) dctrn_result_inner ORDER BY title_1 ASC) dctrn_result LIMIT 25 OFFSET 50"

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, title_1 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.composer AS composer_2, s0_.source AS source_3, s0_.library AS library_4, s0_.century AS century_5, s0_.genre AS genre_6, s0_.performance_type AS performance_type_7, s0_.solo_instrument AS solo_instrument_8, s0_.notes AS notes_9, s0_.source_url AS source_url_10, s0_.rism_incipit_url AS rism_incipit_url_11 FROM score s0_) dctrn_result_inner ORDER BY title_1 ASC) dctrn_result LIMIT 25 OFFSET 50"
]

"SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.composer AS composer_2, s0_.source AS source_3, s0_.library AS library_4, s0_.century AS century_5, s0_.genre AS genre_6, s0_.performance_type AS performance_type_7, s0_.solo_instrument AS solo_instrument_8, s0_.notes AS notes_9, s0_.source_url AS source_url_10, s0_.rism_incipit_url AS rism_incipit_url_11 FROM score s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.title ASC"

[
  1 => 8
  2 => 65
  3 => 66
  4 => 67
  5 => 68
  6 => 73
  7 => 37
  8 => 40
  9 => 39
  10 => 43
  11 => 25
  12 => 7
  13 => 2
  14 => 30
  15 => 17
  16 => 72
  17 => 76
  18 => 31
  19 => 18
  20 => 70
  21 => 1
  22 => 34
  23 => 77
  24 => 3
  25 => 32
]

[
  1 => Doctrine\DBAL\ParameterType {#912
    +name: "INTEGER"
  }
  2 => Doctrine\DBAL\ParameterType {#912}
  3 => Doctrine\DBAL\ParameterType {#912}
  4 => Doctrine\DBAL\ParameterType {#912}
  5 => Doctrine\DBAL\ParameterType {#912}
  6 => Doctrine\DBAL\ParameterType {#912}
  7 => Doctrine\DBAL\ParameterType {#912}
  8 => Doctrine\DBAL\ParameterType {#912}
  9 => Doctrine\DBAL\ParameterType {#912}
  10 => Doctrine\DBAL\ParameterType {#912}
  11 => Doctrine\DBAL\ParameterType {#912}
  12 => Doctrine\DBAL\ParameterType {#912}
  13 => Doctrine\DBAL\ParameterType {#912}
  14 => Doctrine\DBAL\ParameterType {#912}
  15 => Doctrine\DBAL\ParameterType {#912}
  16 => Doctrine\DBAL\ParameterType {#912}
  17 => Doctrine\DBAL\ParameterType {#912}
  18 => Doctrine\DBAL\ParameterType {#912}
  19 => Doctrine\DBAL\ParameterType {#912}
  20 => Doctrine\DBAL\ParameterType {#912}
  21 => Doctrine\DBAL\ParameterType {#912}
  22 => Doctrine\DBAL\ParameterType {#912}
  23 => Doctrine\DBAL\ParameterType {#912}
  24 => Doctrine\DBAL\ParameterType {#912}
  25 => Doctrine\DBAL\ParameterType {#912}
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.composer AS composer_2, s0_.source AS source_3, s0_.library AS library_4, s0_.century AS century_5, s0_.genre AS genre_6, s0_.performance_type AS performance_type_7, s0_.solo_instrument AS solo_instrument_8, s0_.notes AS notes_9, s0_.source_url AS source_url_10, s0_.rism_incipit_url AS rism_incipit_url_11 FROM score s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.title ASC"
  "params" => [
    1 => 8
    2 => 65
    3 => 66
    4 => 67
    5 => 68
    6 => 73
    7 => 37
    8 => 40
    9 => 39
    10 => 43
    11 => 25
    12 => 7
    13 => 2
    14 => 30
    15 => 17
    16 => 72
    17 => 76
    18 => 31
    19 => 18
    20 => 70
    21 => 1
    22 => 34
    23 => 77
    24 => 3
    25 => 32
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#912
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#912}
    3 => Doctrine\DBAL\ParameterType {#912}
    4 => Doctrine\DBAL\ParameterType {#912}
    5 => Doctrine\DBAL\ParameterType {#912}
    6 => Doctrine\DBAL\ParameterType {#912}
    7 => Doctrine\DBAL\ParameterType {#912}
    8 => Doctrine\DBAL\ParameterType {#912}
    9 => Doctrine\DBAL\ParameterType {#912}
    10 => Doctrine\DBAL\ParameterType {#912}
    11 => Doctrine\DBAL\ParameterType {#912}
    12 => Doctrine\DBAL\ParameterType {#912}
    13 => Doctrine\DBAL\ParameterType {#912}
    14 => Doctrine\DBAL\ParameterType {#912}
    15 => Doctrine\DBAL\ParameterType {#912}
    16 => Doctrine\DBAL\ParameterType {#912}
    17 => Doctrine\DBAL\ParameterType {#912}
    18 => Doctrine\DBAL\ParameterType {#912}
    19 => Doctrine\DBAL\ParameterType {#912}
    20 => Doctrine\DBAL\ParameterType {#912}
    21 => Doctrine\DBAL\ParameterType {#912}
    22 => Doctrine\DBAL\ParameterType {#912}
    23 => Doctrine\DBAL\ParameterType {#912}
    24 => Doctrine\DBAL\ParameterType {#912}
    25 => Doctrine\DBAL\ParameterType {#912}
  ]
]

"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.composer AS composer_2, s0_.source AS source_3, s0_.library AS library_4, s0_.century AS century_5, s0_.genre AS genre_6, s0_.performance_type AS performance_type_7, s0_.solo_instrument AS solo_instrument_8, s0_.notes AS notes_9, s0_.source_url AS source_url_10, s0_.rism_incipit_url AS rism_incipit_url_11 FROM score s0_ ORDER BY s0_.title ASC) dctrn_result) dctrn_table"

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.composer AS composer_2, s0_.source AS source_3, s0_.library AS library_4, s0_.century AS century_5, s0_.genre AS genre_6, s0_.performance_type AS performance_type_7, s0_.solo_instrument AS solo_instrument_8, s0_.notes AS notes_9, s0_.source_url AS source_url_10, s0_.rism_incipit_url AS rism_incipit_url_11 FROM score s0_ ORDER BY s0_.title ASC) dctrn_result) dctrn_table"
]

[
  "exception" => ErrorException {#792
    #message: "User Deprecated: Passing string as $order to Doctrine\ORM\QueryBuilder::orderBy() is deprecated, use an instance of SortDirection instead. (QueryBuilder.php:1518 called by QueryBuilder.php:1235, https://github.com/doctrine/orm/issues/11313, package doctrine/orm)"
    #code: 0
    #file: "/var/www/dev/medieval/vendor/doctrine/deprecations/src/Deprecation.php"
    #line: 208
    #severity: E_USER_DEPRECATED
    trace: {
      /var/www/dev/medieval/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);
        › }
      }
      /var/www/dev/medieval/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);
        › }
      }
      /var/www/dev/medieval/vendor/doctrine/orm/src/QueryBuilder.php:1518 {
        Doctrine\ORM\QueryBuilder->getSortDirection(SortDirection|string|null $order, string $method): SortDirection …
        › 
        › Deprecation::trigger(
        ›     'doctrine/orm',
      }
      /var/www/dev/medieval/vendor/doctrine/orm/src/QueryBuilder.php:1235 {
        Doctrine\ORM\QueryBuilder->orderBy(Doctrine\ORM\Query\Expr\OrderBy|string $sort, SortDirection|string|null $order = null): static …
        ›     $sort,
        ›     $this->getSortDirection($order, __METHOD__),
        › );
      }
      /var/www/dev/medieval/src/Repository/ScoreRepository.php:92 {
        App\Repository\ScoreRepository->findDistinctGenres(): array …
        › ->select('DISTINCT s.genre AS genre')
        › ->orderBy('s.genre', 'ASC')
        › ->getQuery()
      }
      /var/www/dev/medieval/src/Controller/ScoreController.php:41 {
        App\Controller\ScoreController->index(Request $request, ScoreRepository $scoreRepository): Response …
        › 'pageCount' => (int) ceil($result['total'] / 25),
        › 'genres' => $scoreRepository->findDistinctGenres(),
        › 'centuries' => $scoreRepository->findDistinctCenturies(),
      }
      /var/www/dev/medieval/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);
        › 
      }
      /var/www/dev/medieval/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/dev/medieval/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 {
      }
      /var/www/dev/medieval/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /var/www/dev/medieval/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /var/www/dev/medieval/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
      }
    }
  }
]

{
  /var/www/dev/medieval/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);
    › }
  }
  /var/www/dev/medieval/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);
    › }
  }
  /var/www/dev/medieval/vendor/doctrine/orm/src/QueryBuilder.php:1518 {
    Doctrine\ORM\QueryBuilder->getSortDirection(SortDirection|string|null $order, string $method): SortDirection …
    › 
    › Deprecation::trigger(
    ›     'doctrine/orm',
  }
  /var/www/dev/medieval/vendor/doctrine/orm/src/QueryBuilder.php:1235 {
    Doctrine\ORM\QueryBuilder->orderBy(Doctrine\ORM\Query\Expr\OrderBy|string $sort, SortDirection|string|null $order = null): static …
    ›     $sort,
    ›     $this->getSortDirection($order, __METHOD__),
    › );
  }
  /var/www/dev/medieval/src/Repository/ScoreRepository.php:92 {
    App\Repository\ScoreRepository->findDistinctGenres(): array …
    › ->select('DISTINCT s.genre AS genre')
    › ->orderBy('s.genre', 'ASC')
    › ->getQuery()
  }
  /var/www/dev/medieval/src/Controller/ScoreController.php:41 {
    App\Controller\ScoreController->index(Request $request, ScoreRepository $scoreRepository): Response …
    › 'pageCount' => (int) ceil($result['total'] / 25),
    › 'genres' => $scoreRepository->findDistinctGenres(),
    › 'centuries' => $scoreRepository->findDistinctCenturies(),
  }
  /var/www/dev/medieval/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);
    › 
  }
  /var/www/dev/medieval/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/dev/medieval/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 {
  }
  /var/www/dev/medieval/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /var/www/dev/medieval/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /var/www/dev/medieval/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
  }
}

"SELECT DISTINCT s0_.genre AS genre_0 FROM score s0_ ORDER BY s0_.genre ASC"

[
  "sql" => "SELECT DISTINCT s0_.genre AS genre_0 FROM score s0_ ORDER BY s0_.genre ASC"
]

"SELECT DISTINCT s0_.century AS century_0 FROM score s0_ WHERE s0_.century IS NOT NULL ORDER BY s0_.century ASC"

[
  "sql" => "SELECT DISTINCT s0_.century AS century_0 FROM score s0_ WHERE s0_.century IS NOT NULL ORDER BY s0_.century ASC"
]

"SELECT DISTINCT s0_.performance_type AS performance_type_0 FROM score s0_ WHERE s0_.performance_type IS NOT NULL ORDER BY s0_.performance_type ASC"

[
  "sql" => "SELECT DISTINCT s0_.performance_type AS performance_type_0 FROM score s0_ WHERE s0_.performance_type IS NOT NULL ORDER BY s0_.performance_type ASC"
]

"rism_incipit_png_550450390"

[
  "key" => "rism_incipit_png_550450390"
]

200

"https://rism.online/sources/550450390"

0.1311

[
  "http_code" => 200
  "url" => "https://rism.online/sources/550450390"
  "total_time" => 0.1311
]

"rism_incipit_png_850691086"

[
  "key" => "rism_incipit_png_850691086"
]

200

"https://rism.online/sources/850691086"

0.026059

[
  "http_code" => 200
  "url" => "https://rism.online/sources/850691086"
  "total_time" => 0.026059
]