Symfony Profiler

Query Metrics

182 Database Queries

2 Different statements

76.79 ms Query time

0 Invalid entities

349 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

74.96 ms
(97.63%)

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:

[
  21
]

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 = 21;

#	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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 86)
10	__TwigTemplate_1adaee7c68dcc661652ee701e63c006e->doDisplay (line 388)
11	Twig\Template->yield (line 186)
12	__TwigTemplate_64bec16577d9c16d65586169b8154e53->block_javascripts (line 432)
13	Twig\Template->yieldBlock (line 196)
14	__TwigTemplate_524d7b10e6d6f14400beb3479db76af1->doDisplay (line 388)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_64bec16577d9c16d65586169b8154e53->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 129)
25	App\Controller\ZFrontController->front_jukebox_sstitres (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.82 ms
(2.37%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id

Parameters:

[]

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.poster AS poster_4,
  t0.categorie AS categorie_5,
  t0.legende AS legende_6,
  t0.title AS title_7,
  t0.actif AS actif_8,
  t0.date_crea AS date_crea_9,
  t0.date_modif AS date_modif_10,
  t0.poster_bd AS poster_bd_11,
  t0.ordre_g AS ordre_g_12,
  t0.ordre AS ordre_13,
  t14.id AS id_15,
  t14.texte AS texte_16,
  t14.date_crea AS date_crea_17,
  t14.date_modif AS date_modif_18,
  t14.actif AS actif_19,
  t14.media_id AS media_id_20
FROM
  medias t0
  LEFT JOIN paroles t14 ON t14.media_id = t0.id

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
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 128)
6	App\Controller\ZFrontController->front_jukebox_sstitres (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 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	123
App\Entity\Paroles	45

Entities Mapping

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

Symfony Profiler

GET https://philippegautier.com/jukebox_sstitres

Configuration Settings

Theme

Page Width