Symfony Profiler

Query Metrics

14 Database Queries

5 Different statements

9.78 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.54 ms
(36.22%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.image AS image_5,
  t0.enabled AS enabled_6
FROM
  category t0
  INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id
WHERE
  categories_tracks.track_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 169)
8	Symfony\Component\Serializer\Serializer->normalize (line 226)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 49)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Serializer->normalize (line 73)
13	Symfony\Component\Serializer\Debug\TraceableSerializer->normalize (line 477)
14	App\Controller\api\TrackApiController->getTracksByCategory (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

3.13 ms
(32.04%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = ? AND c1_.id = ? AND (t0_.name LIKE ? OR t0_.description LIKE ?) ORDER BY t0_.id ASC

Parameters:

[
  1
  2
  "%%"
  "%%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.description AS description_2,
  t0_.created_at AS created_at_3,
  t0_.image AS image_4,
  t0_.image_path AS image_path_5,
  t0_.audio_path AS audio_path_6,
  t0_.enabled AS enabled_7,
  t0_.image_player_path AS image_player_path_8,
  t0_.starred AS starred_9
FROM
  track t0_
  INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  t0_.enabled = ?
  AND c1_.id = ?
  AND (
    t0_.name LIKE ?
    OR t0_.description LIKE ?
  )
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = 1 AND c1_.id = 2 AND (t0_.name LIKE '%%' OR t0_.description LIKE '%%') ORDER BY t0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 138)
7	App\Repository\TrackRepository->findEnabledTracksByCategory (line 465)
8	App\Controller\api\TrackApiController->getTracksByCategory (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.64 ms
(16.74%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.image AS image_5,
  t0.enabled AS enabled_6
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 447)
7	App\Controller\api\TrackApiController->getTracksByCategory (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.11 ms
(11.38%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.created_at AS created_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.username AS username_9, t0.reset_code AS reset_code_10, t0.reset_requested_at AS reset_requested_at_11, t0.register_code AS register_code_12, t0.register_requested_at AS register_requested_at_13, t0.logged_at_least_one_time AS logged_at_least_one_time_14, t0.parent_id AS parent_id_15, t0.avatar_id AS avatar_id_16, t0.level_id AS level_id_17 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  939
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.created_at AS created_at_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.enabled AS enabled_8,
  t0.username AS username_9,
  t0.reset_code AS reset_code_10,
  t0.reset_requested_at AS reset_requested_at_11,
  t0.register_code AS register_code_12,
  t0.register_requested_at AS register_requested_at_13,
  t0.logged_at_least_one_time AS logged_at_least_one_time_14,
  t0.parent_id AS parent_id_15,
  t0.avatar_id AS avatar_id_16,
  t0.level_id AS level_id_17
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.created_at AS created_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.username AS username_9, t0.reset_code AS reset_code_10, t0.reset_requested_at AS reset_requested_at_11, t0.register_code AS register_code_12, t0.register_requested_at AS register_requested_at_13, t0.logged_at_least_one_time AS logged_at_least_one_time_14, t0.parent_id AS parent_id_15, t0.avatar_id AS avatar_id_16, t0.level_id AS level_id_17 FROM `user` t0 WHERE t0.id = 939;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.35 ms
(3.62%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = ? AND c1_.id = ? AND (t0_.name LIKE ? OR t0_.description LIKE ?) ORDER BY t0_.id ASC LIMIT 10

Parameters:

[
  1
  2
  "%%"
  "%%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.description AS description_2,
  t0_.created_at AS created_at_3,
  t0_.image AS image_4,
  t0_.image_path AS image_path_5,
  t0_.audio_path AS audio_path_6,
  t0_.enabled AS enabled_7,
  t0_.image_player_path AS image_player_path_8,
  t0_.starred AS starred_9
FROM
  track t0_
  INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  t0_.enabled = ?
  AND c1_.id = ?
  AND (
    t0_.name LIKE ?
    OR t0_.description LIKE ?
  )
ORDER BY
  t0_.id ASC
LIMIT
  10

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = 1 AND c1_.id = 2 AND (t0_.name LIKE '%%' OR t0_.description LIKE '%%') ORDER BY t0_.id ASC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 142)
7	App\Repository\TrackRepository->findEnabledTracksByCategory (line 465)
8	App\Controller\api\TrackApiController->getTracksByCategory (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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\Track	10
App\Entity\User	1
App\Entity\Category	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Avatar	No errors.
App\Entity\Level	No errors.
App\Entity\Playlist	No errors.
App\Entity\Notification	No errors.
App\Entity\Track	No errors.
App\Entity\Membership	No errors.
App\Entity\Message	No errors.
App\Entity\Category	No errors.

Symfony Profiler

POST https://v2.louqman.fr/api/track/category/list

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping