Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.21 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.94 ms
(29.24%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.composer AS composer_2, m0_.slug AS slug_3, m0_.difficulty AS difficulty_4, m0_.instrument AS instrument_5, m0_.xml_file_path AS xml_file_path_6, m0_.preview_image AS preview_image_7, m0_.description AS description_8, m0_.duration AS duration_9, m0_.total_measures AS total_measures_10, m0_.has_anacrusis AS has_anacrusis_11, m0_.created_at AS created_at_12, m0_.updated_at AS updated_at_13, m0_.is_public AS is_public_14, m0_.source_id AS source_id_15 FROM music_piece m0_ WHERE m0_.difficulty = ? AND m0_.instrument = ? AND m0_.id <> ? AND m0_.is_public = ? ORDER BY m0_.title ASC LIMIT 5

Parameters:

[
  "beginner"
  "violin"
  67
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.composer AS composer_2,
  m0_.slug AS slug_3,
  m0_.difficulty AS difficulty_4,
  m0_.instrument AS instrument_5,
  m0_.xml_file_path AS xml_file_path_6,
  m0_.preview_image AS preview_image_7,
  m0_.description AS description_8,
  m0_.duration AS duration_9,
  m0_.total_measures AS total_measures_10,
  m0_.has_anacrusis AS has_anacrusis_11,
  m0_.created_at AS created_at_12,
  m0_.updated_at AS updated_at_13,
  m0_.is_public AS is_public_14,
  m0_.source_id AS source_id_15
FROM
  music_piece m0_
WHERE
  m0_.difficulty = ?
  AND m0_.instrument = ?
  AND m0_.id <> ?
  AND m0_.is_public = ?
ORDER BY
  m0_.title ASC
LIMIT
  5

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.composer AS composer_2, m0_.slug AS slug_3, m0_.difficulty AS difficulty_4, m0_.instrument AS instrument_5, m0_.xml_file_path AS xml_file_path_6, m0_.preview_image AS preview_image_7, m0_.description AS description_8, m0_.duration AS duration_9, m0_.total_measures AS total_measures_10, m0_.has_anacrusis AS has_anacrusis_11, m0_.created_at AS created_at_12, m0_.updated_at AS updated_at_13, m0_.is_public AS is_public_14, m0_.source_id AS source_id_15 FROM music_piece m0_ WHERE m0_.difficulty = 'beginner' AND m0_.instrument = 'violin' AND m0_.id <> 67 AND m0_.is_public = 1 ORDER BY m0_.title ASC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 330)
7	App\Repository\MusicPieceRepository->findSameDifficultyAndInstrument (line 99)
8	App\Controller\PublicMusicController->play (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.90 ms
(28.08%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.composer AS composer_2, m0_.slug AS slug_3, m0_.difficulty AS difficulty_4, m0_.instrument AS instrument_5, m0_.xml_file_path AS xml_file_path_6, m0_.preview_image AS preview_image_7, m0_.description AS description_8, m0_.duration AS duration_9, m0_.total_measures AS total_measures_10, m0_.has_anacrusis AS has_anacrusis_11, m0_.created_at AS created_at_12, m0_.updated_at AS updated_at_13, m0_.is_public AS is_public_14, m0_.source_id AS source_id_15 FROM music_piece m0_ WHERE m0_.title = ? AND m0_.id <> ? AND m0_.instrument <> ? AND m0_.is_public = ? ORDER BY m0_.instrument ASC LIMIT 5

Parameters:

[
  "Ode To Joy (Violin)"
  67
  "violin"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.composer AS composer_2,
  m0_.slug AS slug_3,
  m0_.difficulty AS difficulty_4,
  m0_.instrument AS instrument_5,
  m0_.xml_file_path AS xml_file_path_6,
  m0_.preview_image AS preview_image_7,
  m0_.description AS description_8,
  m0_.duration AS duration_9,
  m0_.total_measures AS total_measures_10,
  m0_.has_anacrusis AS has_anacrusis_11,
  m0_.created_at AS created_at_12,
  m0_.updated_at AS updated_at_13,
  m0_.is_public AS is_public_14,
  m0_.source_id AS source_id_15
FROM
  music_piece m0_
WHERE
  m0_.title = ?
  AND m0_.id <> ?
  AND m0_.instrument <> ?
  AND m0_.is_public = ?
ORDER BY
  m0_.instrument ASC
LIMIT
  5

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.composer AS composer_2, m0_.slug AS slug_3, m0_.difficulty AS difficulty_4, m0_.instrument AS instrument_5, m0_.xml_file_path AS xml_file_path_6, m0_.preview_image AS preview_image_7, m0_.description AS description_8, m0_.duration AS duration_9, m0_.total_measures AS total_measures_10, m0_.has_anacrusis AS has_anacrusis_11, m0_.created_at AS created_at_12, m0_.updated_at AS updated_at_13, m0_.is_public AS is_public_14, m0_.source_id AS source_id_15 FROM music_piece m0_ WHERE m0_.title = 'Ode To Joy (Violin)' AND m0_.id <> 67 AND m0_.instrument <> 'violin' AND m0_.is_public = 1 ORDER BY m0_.instrument ASC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 242)
7	App\Repository\MusicPieceRepository->findSameTitleDifferentInstrument (line 98)
8	App\Controller\PublicMusicController->play (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.79 ms
(24.72%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.composer AS composer_2, m0_.slug AS slug_3, m0_.difficulty AS difficulty_4, m0_.instrument AS instrument_5, m0_.xml_file_path AS xml_file_path_6, m0_.preview_image AS preview_image_7, m0_.description AS description_8, m0_.duration AS duration_9, m0_.total_measures AS total_measures_10, m0_.has_anacrusis AS has_anacrusis_11, m0_.created_at AS created_at_12, m0_.updated_at AS updated_at_13, m0_.is_public AS is_public_14, m0_.source_id AS source_id_15 FROM music_piece m0_ WHERE (m0_.id <> ? AND m0_.instrument <> ? AND m0_.is_public = ?) OR LOWER(m0_.title) LIKE LOWER(?) OR LOWER(m0_.title) LIKE LOWER(?) OR LOWER(m0_.title) LIKE LOWER(?) ORDER BY m0_.title ASC LIMIT 5

Parameters:

[
  67
  "violin"
  1
  "%ode%"
  "%joy%"
  "%(violin)%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.composer AS composer_2,
  m0_.slug AS slug_3,
  m0_.difficulty AS difficulty_4,
  m0_.instrument AS instrument_5,
  m0_.xml_file_path AS xml_file_path_6,
  m0_.preview_image AS preview_image_7,
  m0_.description AS description_8,
  m0_.duration AS duration_9,
  m0_.total_measures AS total_measures_10,
  m0_.has_anacrusis AS has_anacrusis_11,
  m0_.created_at AS created_at_12,
  m0_.updated_at AS updated_at_13,
  m0_.is_public AS is_public_14,
  m0_.source_id AS source_id_15
FROM
  music_piece m0_
WHERE
  (
    m0_.id <> ?
    AND m0_.instrument <> ?
    AND m0_.is_public = ?
  )
  OR LOWER(m0_.title) LIKE LOWER(?)
  OR LOWER(m0_.title) LIKE LOWER(?)
  OR LOWER(m0_.title) LIKE LOWER(?)
ORDER BY
  m0_.title ASC
LIMIT
  5

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.composer AS composer_2, m0_.slug AS slug_3, m0_.difficulty AS difficulty_4, m0_.instrument AS instrument_5, m0_.xml_file_path AS xml_file_path_6, m0_.preview_image AS preview_image_7, m0_.description AS description_8, m0_.duration AS duration_9, m0_.total_measures AS total_measures_10, m0_.has_anacrusis AS has_anacrusis_11, m0_.created_at AS created_at_12, m0_.updated_at AS updated_at_13, m0_.is_public AS is_public_14, m0_.source_id AS source_id_15 FROM music_piece m0_ WHERE (m0_.id <> 67 AND m0_.instrument <> 'violin' AND m0_.is_public = 1) OR LOWER(m0_.title) LIKE LOWER('%ode%') OR LOWER(m0_.title) LIKE LOWER('%joy%') OR LOWER(m0_.title) LIKE LOWER('%(violin)%') ORDER BY m0_.title ASC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 280)
7	App\Repository\MusicPieceRepository->findSameTitleDifferentInstrument (line 98)
8	App\Controller\PublicMusicController->play (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.58 ms
(17.95%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.composer AS composer_3, t0.slug AS slug_4, t0.difficulty AS difficulty_5, t0.instrument AS instrument_6, t0.xml_file_path AS xml_file_path_7, t0.preview_image AS preview_image_8, t0.description AS description_9, t0.duration AS duration_10, t0.total_measures AS total_measures_11, t0.has_anacrusis AS has_anacrusis_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.is_public AS is_public_15, t0.source_id AS source_id_16 FROM music_piece t0 WHERE t0.id = ?

Parameters:

[
  "67"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.composer AS composer_3,
  t0.slug AS slug_4,
  t0.difficulty AS difficulty_5,
  t0.instrument AS instrument_6,
  t0.xml_file_path AS xml_file_path_7,
  t0.preview_image AS preview_image_8,
  t0.description AS description_9,
  t0.duration AS duration_10,
  t0.total_measures AS total_measures_11,
  t0.has_anacrusis AS has_anacrusis_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.is_public AS is_public_15,
  t0.source_id AS source_id_16
FROM
  music_piece t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.composer AS composer_3, t0.slug AS slug_4, t0.difficulty AS difficulty_5, t0.instrument AS instrument_6, t0.xml_file_path AS xml_file_path_7, t0.preview_image AS preview_image_8, t0.description AS description_9, t0.duration AS duration_10, t0.total_measures AS total_measures_11, t0.has_anacrusis AS has_anacrusis_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.is_public AS is_public_15, t0.source_id AS source_id_16 FROM music_piece t0 WHERE t0.id = '67';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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.

Entities Mapping

Class	Mapping errors
App\Entity\MusicPiece	No errors.
App\Entity\PracticeSession	No errors.
App\Entity\UserProgress	No errors.

Symfony Profiler

GET https://practito.com.babyblossom.co.ke/music/piece/67/ode-to-joy-violin-beethoven

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping