Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.51 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.85 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3 FROM realisateur t0 WHERE t0.id = ?

Parameters:

[
  493
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3
FROM
  realisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3 FROM realisateur t0 WHERE t0.id = 493;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 59)
7	App\Controller\RealisateurController->show (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)

0.89 ms

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM film f0_ INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id WHERE r1_.id = ?

Parameters:

[
  493
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT f0_.id) AS sclr_0
FROM
  film f0_
  INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id
  INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id
  LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id
WHERE
  r1_.id = ?

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM film f0_ INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id WHERE r1_.id = 493;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerGxfBKJb\PaginatorProxyBa079e5->paginate (line 74)
16	App\Controller\RealisateurController->show (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.77 ms

SELECT DISTINCT f0_.id AS id_0, a1_.annee AS annee_1 FROM film f0_ INNER JOIN film_realisateur f3_ ON f0_.id = f3_.film_id INNER JOIN realisateur r2_ ON r2_.id = f3_.realisateur_id LEFT JOIN annee a1_ ON f0_.film_annee = a1_.id WHERE r2_.id = ? ORDER BY a1_.annee DESC LIMIT 24

Parameters:

[
  493
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT f0_.id AS id_0,
  a1_.annee AS annee_1
FROM
  film f0_
  INNER JOIN film_realisateur f3_ ON f0_.id = f3_.film_id
  INNER JOIN realisateur r2_ ON r2_.id = f3_.realisateur_id
  LEFT JOIN annee a1_ ON f0_.film_annee = a1_.id
WHERE
  r2_.id = ?
ORDER BY
  a1_.annee DESC
LIMIT
  24

SELECT DISTINCT f0_.id AS id_0, a1_.annee AS annee_1 FROM film f0_ INNER JOIN film_realisateur f3_ ON f0_.id = f3_.film_id INNER JOIN realisateur r2_ ON r2_.id = f3_.realisateur_id LEFT JOIN annee a1_ ON f0_.film_annee = a1_.id WHERE r2_.id = 493 ORDER BY a1_.annee DESC LIMIT 24;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerGxfBKJb\PaginatorProxyBa079e5->paginate (line 74)
16	App\Controller\RealisateurController->show (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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\Realisateur	No errors.
App\Entity\Film	No errors.
App\Entity\Annee	No errors.
App\Entity\Genre	No errors.
App\Entity\Disque	No errors.
App\Entity\Langue	No errors.
App\Entity\Playlist	No errors.
App\Entity\StreamRequest	No errors.
App\Entity\FilmVu	The association App\Entity\FilmVu#utilisateur refers to the inverse side field App\Entity\Utilisateur#filmsVus which does not exist.
App\Entity\Serie	No errors.
App\Entity\Game	No errors.

Symfony Profiler

GET https://www.pulse.emiliecarion.com/realisateur/493

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping