Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

3.20 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.73 ms
(22.83%)

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 75

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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
  75

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 75;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getResultForOffset (line 154)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 105)
8	App\Repository\ScoreRepository->search (line 79)
9	App\Controller\ScoreController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.61 ms
(18.97%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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

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 (63, 10, 71) ORDER BY s0_.title ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getResultForOffset (line 172)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 105)
8	App\Repository\ScoreRepository->search (line 79)
9	App\Controller\ScoreController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.49 ms
(15.35%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 89)
7	count (line 80)
8	App\Repository\ScoreRepository::search (line 80)
9	App\Controller\ScoreController->index (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.47 ms
(14.63%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\ScoreRepository->findDistinctPerformanceTypes (line 129)
7	App\Controller\ScoreController->index (line 43)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.47 ms
(14.58%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\ScoreRepository->findDistinctCenturies (line 112)
7	App\Controller\ScoreController->index (line 42)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.44 ms
(13.63%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\ScoreRepository->findDistinctGenres (line 94)
7	App\Controller\ScoreController->index (line 41)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Score	3

Entities Mapping

Class	Mapping errors
App\Entity\Score	No errors.

Symfony Profiler

GET http://wsl-dev.taile26cbc.ts.net/?dir=asc&page=4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping