Symfony Profiler

Query Metrics

9 Database Queries

5 Different statements

12.62 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.94 ms
(47.11%)

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 LEFT JOIN paroles p3_ ON m0_.id = p3_.media_id WHERE m0_.actif = 1 AND ((m0_.titre LIKE ? OR m0_.categorie LIKE ? OR m0_.legende LIKE ? OR m0_.title LIKE ? OR a1_.nom LIKE ? OR a1_.prenom LIKE ? OR p3_.texte LIKE ?)) ORDER BY m0_.date_crea DESC

Parameters:

[
  "%chanter%"
  "%chanter%"
  "%chanter%"
  "%chanter%"
  "%chanter%"
  "%chanter%"
  "%chanter%"
]

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
  LEFT JOIN paroles p3_ ON m0_.id = p3_.media_id
WHERE
  m0_.actif = 1
  AND (
    (
      m0_.titre LIKE ?
      OR m0_.categorie LIKE ?
      OR m0_.legende LIKE ?
      OR m0_.title LIKE ?
      OR a1_.nom LIKE ?
      OR a1_.prenom LIKE ?
      OR p3_.texte 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 LEFT JOIN paroles p3_ ON m0_.id = p3_.media_id WHERE m0_.actif = 1 AND ((m0_.titre LIKE '%chanter%' OR m0_.categorie LIKE '%chanter%' OR m0_.legende LIKE '%chanter%' OR m0_.title LIKE '%chanter%' OR a1_.nom LIKE '%chanter%' OR a1_.prenom LIKE '%chanter%' OR p3_.texte LIKE '%chanter%')) 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 89)
7	App\Repository\MediasRepository->findAllActifSearch (line 593)
8	App\Controller\ZFrontController->front_recherche (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.41 ms
(19.12%)

SELECT n0_.id AS id_0, n0_.texte AS texte_1, n0_.date_publi AS date_publi_2, n0_.titre_lien AS titre_lien_3, n0_.lien AS lien_4, n0_.date_crea AS date_crea_5, n0_.date_modif AS date_modif_6, n0_.actif AS actif_7, n0_.titre AS titre_8 FROM news n0_ WHERE n0_.texte LIKE ? ORDER BY n0_.date_crea DESC

Parameters:

[
  "%chanter%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.texte AS texte_1,
  n0_.date_publi AS date_publi_2,
  n0_.titre_lien AS titre_lien_3,
  n0_.lien AS lien_4,
  n0_.date_crea AS date_crea_5,
  n0_.date_modif AS date_modif_6,
  n0_.actif AS actif_7,
  n0_.titre AS titre_8
FROM
  news n0_
WHERE
  n0_.texte LIKE ?
ORDER BY
  n0_.date_crea DESC

SELECT n0_.id AS id_0, n0_.texte AS texte_1, n0_.date_publi AS date_publi_2, n0_.titre_lien AS titre_lien_3, n0_.lien AS lien_4, n0_.date_crea AS date_crea_5, n0_.date_modif AS date_modif_6, n0_.actif AS actif_7, n0_.titre AS titre_8 FROM news n0_ WHERE n0_.texte LIKE '%chanter%' ORDER BY n0_.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 72)
7	App\Repository\NewsRepository->findAllSearch (line 595)
8	App\Controller\ZFrontController->front_recherche (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.46 ms
(11.54%)

SELECT p0_.id AS id_0, p0_.texte AS texte_1, p0_.date_crea AS date_crea_2, p0_.date_modif AS date_modif_3, p0_.actif AS actif_4, p0_.media_id AS media_id_5 FROM paroles p0_ WHERE p0_.texte LIKE ? ORDER BY p0_.date_crea DESC

Parameters:

[
  "%chanter%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.texte AS texte_1,
  p0_.date_crea AS date_crea_2,
  p0_.date_modif AS date_modif_3,
  p0_.actif AS actif_4,
  p0_.media_id AS media_id_5
FROM
  paroles p0_
WHERE
  p0_.texte LIKE ?
ORDER BY
  p0_.date_crea DESC

SELECT p0_.id AS id_0, p0_.texte AS texte_1, p0_.date_crea AS date_crea_2, p0_.date_modif AS date_modif_3, p0_.actif AS actif_4, p0_.media_id AS media_id_5 FROM paroles p0_ WHERE p0_.texte LIKE '%chanter%' ORDER BY p0_.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 58)
7	App\Repository\ParolesRepository->findAllSearch (line 597)
8	App\Controller\ZFrontController->front_recherche (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.41 ms
(11.17%)

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:

[
  84
]

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

#	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 89)
12	App\Repository\MediasRepository->findAllActifSearch (line 593)
13	App\Controller\ZFrontController->front_recherche (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)

1.40 ms
(11.06%)

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:

[
  84
]

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

#	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 144)
9	__TwigTemplate_ecf5c0d6fcf3b19acf1657da40e81f1f->doDisplay (line 388)
10	Twig\Template->yield (line 156)
11	__TwigTemplate_38ddeda82b8540d486031deccfb964de->block_body (line 432)
12	Twig\Template->yieldBlock (line 131)
13	__TwigTemplate_524d7b10e6d6f14400beb3479db76af1->doDisplay (line 388)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_38ddeda82b8540d486031deccfb964de->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 598)
24	App\Controller\ZFrontController->front_recherche (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)

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	3
App\Entity\Paroles	3
App\Entity\Auteurs	3

Entities Mapping

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

Symfony Profiler

GET https://www.philippegautier.com/recherche/chanter

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping