Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.79 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.41 ms
(51.68%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.dateajout AS dateajout_3 FROM categorie t0 WHERE t0.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.dateajout AS dateajout_3
FROM
  categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.dateajout AS dateajout_3 FROM categorie t0 WHERE t0.id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
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 229)
7	App\Controller\SonoController->videosParCategorie (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 7)

0.32 ms
(40.74%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.image AS image_4, t0.description AS description_5, t0.realisateur AS realisateur_6, t0.producteur AS producteur_7, t0.acteur AS acteur_8, t0.annesortie AS annesortie_9, t0.dateajout AS dateajout_10, t0.titre_original AS titre_original_11, t0.numero_partie AS numero_partie_12, t0.categories AS categories_13, t0.traducteur_id AS traducteur_id_14 FROM video t0 WHERE t0.categories = ? ORDER BY t0.dateajout DESC

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.video AS video_3,
  t0.image AS image_4,
  t0.description AS description_5,
  t0.realisateur AS realisateur_6,
  t0.producteur AS producteur_7,
  t0.acteur AS acteur_8,
  t0.annesortie AS annesortie_9,
  t0.dateajout AS dateajout_10,
  t0.titre_original AS titre_original_11,
  t0.numero_partie AS numero_partie_12,
  t0.categories AS categories_13,
  t0.traducteur_id AS traducteur_id_14
FROM
  video t0
WHERE
  t0.categories = ?
ORDER BY
  t0.dateajout DESC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.image AS image_4, t0.description AS description_5, t0.realisateur AS realisateur_6, t0.producteur AS producteur_7, t0.acteur AS acteur_8, t0.annesortie AS annesortie_9, t0.dateajout AS dateajout_10, t0.titre_original AS titre_original_11, t0.numero_partie AS numero_partie_12, t0.categories AS categories_13, t0.traducteur_id AS traducteur_id_14 FROM video t0 WHERE t0.categories = 8 ORDER BY t0.dateajout DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 235)
5	App\Controller\SonoController->videosParCategorie (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 7)

0.06 ms
(7.58%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.dateajout AS dateajout_3 FROM categorie t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.dateajout AS dateajout_3
FROM
  categorie t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.dateajout AS dateajout_3 FROM categorie t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 246)
6	App\Controller\SonoController->videosParCategorie (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 7)

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\Categorie	10

Entities Mapping

Class	Mapping errors
App\Entity\Categorie	No errors.
App\Entity\Video	No errors.
App\Entity\Traducteur	No errors.

Symfony Profiler

GET https://cybersono.ags-i.fr/categories/8

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping