Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.94 ms Query time

0 Invalid entities

15 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.49 ms

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_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id WHERE a1_.nom LIKE ? AND LOWER(REPLACE(REPLACE(REPLACE(REPLACE(m0_.titre, ',', ' '), '-', ' '), '\'', ' '), '  ', ' ')) LIKE ? ORDER BY m0_.date_crea DESC

Parameters:

[
  "%Trenet%"
  "%Le cor%"
]

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_
  LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id
  LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id
WHERE
  a1_.nom LIKE ?
  AND LOWER(
    REPLACE(
      REPLACE(
        REPLACE(
          REPLACE(m0_.titre, ',', ' '),
          '-',
          ' '
        ),
        '\'',
        ' '
      ),
      '  ',
      ' '
    )
  ) LIKE ?
ORDER BY
  m0_.date_crea DESC

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_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id WHERE a1_.nom LIKE '%Trenet%' AND LOWER(REPLACE(REPLACE(REPLACE(REPLACE(m0_.titre, ',', ' '), '-', ' '), '\'', ' '), '  ', ' ')) LIKE '%Le cor%' ORDER BY m0_.date_crea DESC;

#	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 106)
7	App\Repository\MediasRepository->findSearchDetail (line 421)
8	App\Controller\ZFrontController->front_filmography_detail (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.66 ms

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:

[
  32
]

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

#	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 106)
12	App\Repository\MediasRepository->findSearchDetail (line 421)
13	App\Controller\ZFrontController->front_filmography_detail (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)

0.43 ms

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:

[
  32
]

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

#	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 74)
9	__TwigTemplate_6d993164577a9f2ad6f16d88663a122e->doDisplay (line 388)
10	Twig\Template->yield (line 156)
11	__TwigTemplate_64dabfd2ed73c33cf421f920a2814b5c->block_body (line 432)
12	Twig\Template->yieldBlock (line 131)
13	__TwigTemplate_524d7b10e6d6f14400beb3479db76af1->doDisplay (line 388)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_64dabfd2ed73c33cf421f920a2814b5c->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 422)
24	App\Controller\ZFrontController->front_filmography_detail (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.36 ms

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.actif AS actif_4, t0.ordre AS ordre_5, t0.media_id AS media_id_6 FROM diapos t0 WHERE t0.media_id = ?

Parameters:

[
  32
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.titre AS titre_3,
  t0.actif AS actif_4,
  t0.ordre AS ordre_5,
  t0.media_id AS media_id_6
FROM
  diapos t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.actif AS actif_4, t0.ordre AS ordre_5, t0.media_id AS media_id_6 FROM diapos t0 WHERE t0.media_id = 32;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 126)
10	__TwigTemplate_6d993164577a9f2ad6f16d88663a122e->doDisplay (line 388)
11	Twig\Template->yield (line 156)
12	__TwigTemplate_64dabfd2ed73c33cf421f920a2814b5c->block_body (line 432)
13	Twig\Template->yieldBlock (line 131)
14	__TwigTemplate_524d7b10e6d6f14400beb3479db76af1->doDisplay (line 388)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_64dabfd2ed73c33cf421f920a2814b5c->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 422)
25	App\Controller\ZFrontController->front_filmography_detail (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)

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\Diapos	12
App\Entity\Medias	1
App\Entity\Paroles	1
App\Entity\Auteurs	1

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/filmography/detail/Trenet/Le-cor

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping