Symfony Profiler

Query Metrics

366 Database Queries

6 Different statements

157.65 ms Query time

0 Invalid entities

355 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

81.09 ms
(51.44%)

181

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prenom AS prenom_2,
  t0.nom AS nom_3,
  t0.date_crea AS date_crea_4,
  t0.date_modif AS date_modif_5,
  t0.texte AS texte_6
FROM
  auteurs t0
  INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id
WHERE
  medias_auteurs.medias_id = ?

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = 31;

#	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 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1671)
10	Twig\Extension\CoreExtension::getAttribute (line 107)
11	__TwigTemplate_398cc7727861790a11f01dc520c141df->doDisplay (line 388)
12	Twig\Template->yield (line 156)
13	__TwigTemplate_18bdf81afd9f4d62d6dfd906e8b6c272->block_body (line 432)
14	Twig\Template->yieldBlock (line 131)
15	__TwigTemplate_524d7b10e6d6f14400beb3479db76af1->doDisplay (line 388)
16	Twig\Template->yield (line 57)
17	__TwigTemplate_18bdf81afd9f4d62d6dfd906e8b6c272->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 516)
26	App\Controller\ZFrontController->front_realisations_type (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

68.60 ms
(43.52%)

181

SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.texte AS texte_2,
  t0.date_crea AS date_crea_3,
  t0.date_modif AS date_modif_4,
  t0.actif AS actif_5,
  t0.media_id AS media_id_6
FROM
  paroles t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 136)
12	App\Repository\MediasRepository->findAllActifByCat (line 509)
13	App\Controller\ZFrontController->front_realisations_type (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

3.49 ms
(2.21%)

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ WHERE m0_.actif = 1 AND m0_.categorie LIKE ? ORDER BY m0_.ordre ASC

Parameters:

[
  "%Music Videos%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.video AS video_2,
  m0_.poster AS poster_3,
  m0_.categorie AS categorie_4,
  m0_.legende AS legende_5,
  m0_.title AS title_6,
  m0_.actif AS actif_7,
  m0_.date_crea AS date_crea_8,
  m0_.date_modif AS date_modif_9,
  m0_.poster_bd AS poster_bd_10,
  m0_.ordre_g AS ordre_g_11,
  m0_.ordre AS ordre_12
FROM
  medias m0_
WHERE
  m0_.actif = 1
  AND m0_.categorie LIKE ?
ORDER BY
  m0_.ordre ASC

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ WHERE m0_.actif = 1 AND m0_.categorie LIKE '%Music Videos%' ORDER BY m0_.ordre 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 136)
7	App\Repository\MediasRepository->findAllActifByCat (line 509)
8	App\Controller\ZFrontController->front_realisations_type (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)

2.38 ms
(1.51%)

SELECT a0_.id AS id_0, a0_.prenom AS prenom_1, a0_.nom AS nom_2, a0_.date_crea AS date_crea_3, a0_.date_modif AS date_modif_4, a0_.texte AS texte_5 FROM auteurs a0_ ORDER BY a0_.nom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.prenom AS prenom_1,
  a0_.nom AS nom_2,
  a0_.date_crea AS date_crea_3,
  a0_.date_modif AS date_modif_4,
  a0_.texte AS texte_5
FROM
  auteurs a0_
ORDER BY
  a0_.nom ASC

SELECT a0_.id AS id_0, a0_.prenom AS prenom_1, a0_.nom AS nom_2, a0_.date_crea AS date_crea_3, a0_.date_modif AS date_modif_4, a0_.texte AS texte_5 FROM auteurs a0_ ORDER BY a0_.nom 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 92)
7	App\Repository\AuteursRepository->findAllByName (line 513)
8	App\Controller\ZFrontController->front_realisations_type (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.15 ms
(0.73%)

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ WHERE m0_.actif = 1 ORDER BY m0_.titre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.video AS video_2,
  m0_.poster AS poster_3,
  m0_.categorie AS categorie_4,
  m0_.legende AS legende_5,
  m0_.title AS title_6,
  m0_.actif AS actif_7,
  m0_.date_crea AS date_crea_8,
  m0_.date_modif AS date_modif_9,
  m0_.poster_bd AS poster_bd_10,
  m0_.ordre_g AS ordre_g_11,
  m0_.ordre AS ordre_12
FROM
  medias m0_
WHERE
  m0_.actif = 1
ORDER BY
  m0_.titre ASC

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ WHERE m0_.actif = 1 ORDER BY m0_.titre 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 286)
7	App\Repository\MediasRepository->findAllActifByTitre (line 515)
8	App\Controller\ZFrontController->front_realisations_type (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)

0.94 ms
(0.59%)

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ WHERE m0_.actif = 1 AND m0_.categorie LIKE ? ORDER BY m0_.ordre ASC LIMIT 9

Parameters:

[
  "%Music Videos%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.video AS video_2,
  m0_.poster AS poster_3,
  m0_.categorie AS categorie_4,
  m0_.legende AS legende_5,
  m0_.title AS title_6,
  m0_.actif AS actif_7,
  m0_.date_crea AS date_crea_8,
  m0_.date_modif AS date_modif_9,
  m0_.poster_bd AS poster_bd_10,
  m0_.ordre_g AS ordre_g_11,
  m0_.ordre AS ordre_12
FROM
  medias m0_
WHERE
  m0_.actif = 1
  AND m0_.categorie LIKE ?
ORDER BY
  m0_.ordre ASC
LIMIT
  9

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ WHERE m0_.actif = 1 AND m0_.categorie LIKE '%Music Videos%' ORDER BY m0_.ordre ASC LIMIT 9;

#	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 163)
7	App\Repository\MediasRepository->findAllActifByCatByNine (line 511)
8	App\Controller\ZFrontController->front_realisations_type (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\Medias	181
App\Entity\Auteurs	129
App\Entity\Paroles	45

Entities Mapping

Class	Mapping errors
App\Entity\Medias	No errors.
App\Entity\Auteurs	No errors.
App\Entity\Diapos	No errors.
App\Entity\Paroles	No errors.

Symfony Profiler

GET https://philippegautier.com/realisations/music-videos

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping