Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.51 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.97 ms
(27.65%)

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 m0_.actif = 1 AND LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(m0_.titre, '-', ' '), ',', ''), '\'', ' '), '’', ' '), 'é', 'e'), 'è', 'e'), 'ê', 'e'), 'ë', 'e'), 'à', 'a'), 'â', 'a'), 'ä', 'a'), 'î', 'i'), 'ï', 'i'), 'ù', 'u'), 'û', 'u'), 'ü', 'u')) LIKE ? AND a1_.nom LIKE ? ORDER BY m0_.titre ASC

Parameters:

[
  "%comme un igloo%"
  "Daho"
]

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
  m0_.actif = 1
  AND LOWER(
    REPLACE(
      REPLACE(
        REPLACE(
          REPLACE(
            REPLACE(
              REPLACE(
                REPLACE(
                  REPLACE(
                    REPLACE(
                      REPLACE(
                        REPLACE(
                          REPLACE(
                            REPLACE(
                              REPLACE(
                                REPLACE(
                                  REPLACE(m0_.titre, '-', ' '),
                                  ',',
                                  ''
                                ),
                                '\'',
                                ' '
                              ),
                              '’',
                              ' '
                            ),
                            'é',
                            'e'
                          ),
                          'è',
                          'e'
                        ),
                        'ê',
                        'e'
                      ),
                      'ë',
                      'e'
                    ),
                    'à',
                    'a'
                  ),
                  'â',
                  'a'
                ),
                'ä',
                'a'
              ),
              'î',
              'i'
            ),
            'ï',
            'i'
          ),
          'ù',
          'u'
        ),
        'û',
        'u'
      ),
      'ü',
      'u'
    )
  ) LIKE ?
  AND a1_.nom LIKE ?
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_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id WHERE m0_.actif = 1 AND LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(m0_.titre, '-', ' '), ',', ''), '\'', ' '), '’', ' '), 'é', 'e'), 'è', 'e'), 'ê', 'e'), 'ë', 'e'), 'à', 'a'), 'â', 'a'), 'ä', 'a'), 'î', 'i'), 'ï', 'i'), 'ù', 'u'), 'û', 'u'), 'ü', 'u')) LIKE '%comme un igloo%' AND a1_.nom LIKE 'Daho' 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 332)
7	App\Repository\MediasRepository->findAllActifByVarTitreEtAuteur (line 344)
8	App\Controller\ZFrontController->front_works_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.85 ms
(24.09%)

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 LOWER(REPLACE(REPLACE(REPLACE(a1_.nom, 'é', 'e'), 'è', 'e'), 'ê', 'e')) LIKE ? AND LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(m0_.titre, '', ''), '\'', ' '), '’', ' '), 'é', 'e'), 'è', 'e'), 'ê', 'e'), 'ë', 'e'), 'à', 'a'), 'â', 'a'), 'ä', 'a'), 'î', 'i'), 'ï', 'i'), 'ù', 'u'), 'û', 'u'), 'ü', 'u')) LIKE ? ORDER BY m0_.date_crea DESC

Parameters:

[
  "Daho"
  "Comme un igloo"
]

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
  LOWER(
    REPLACE(
      REPLACE(
        REPLACE(a1_.nom, 'é', 'e'),
        'è',
        'e'
      ),
      'ê',
      'e'
    )
  ) LIKE ?
  AND LOWER(
    REPLACE(
      REPLACE(
        REPLACE(
          REPLACE(
            REPLACE(
              REPLACE(
                REPLACE(
                  REPLACE(
                    REPLACE(
                      REPLACE(
                        REPLACE(
                          REPLACE(
                            REPLACE(
                              REPLACE(
                                REPLACE(m0_.titre, '', ''),
                                '\'',
                                ' '
                              ),
                              '’',
                              ' '
                            ),
                            'é',
                            'e'
                          ),
                          'è',
                          'e'
                        ),
                        'ê',
                        'e'
                      ),
                      'ë',
                      'e'
                    ),
                    'à',
                    'a'
                  ),
                  'â',
                  'a'
                ),
                'ä',
                'a'
              ),
              'î',
              'i'
            ),
            'ï',
            'i'
          ),
          'ù',
          'u'
        ),
        'û',
        'u'
      ),
      'ü',
      'u'
    )
  ) 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 LOWER(REPLACE(REPLACE(REPLACE(a1_.nom, 'é', 'e'), 'è', 'e'), 'ê', 'e')) LIKE 'Daho' AND LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(m0_.titre, '', ''), '\'', ' '), '’', ' '), 'é', 'e'), 'è', 'e'), 'ê', 'e'), 'ë', 'e'), 'à', 'a'), 'â', 'a'), 'ä', 'a'), 'î', 'i'), 'ï', 'i'), 'ù', 'u'), 'û', 'u'), 'ü', 'u')) LIKE 'Comme un igloo' 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 125)
7	App\Repository\MediasRepository->findDetailAuteurTitre (line 347)
8	App\Controller\ZFrontController->front_works_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.73 ms
(20.79%)

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_ WHERE a0_.nom LIKE ? ORDER BY a0_.date_crea DESC

Parameters:

[
  "Daho"
]

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_
WHERE
  a0_.nom LIKE ?
ORDER BY
  a0_.date_crea DESC

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_ WHERE a0_.nom LIKE 'Daho' ORDER BY a0_.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 103)
7	App\Repository\AuteursRepository->findAuteurByName (line 333)
8	App\Controller\ZFrontController->front_works_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.48 ms
(13.81%)

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:

[
  87
]

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

#	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 72)
9	__TwigTemplate_428f851596be936ef4a3a4749494e3eb->doDisplay (line 388)
10	Twig\Template->yield (line 156)
11	__TwigTemplate_18bdf81afd9f4d62d6dfd906e8b6c272->block_body (line 432)
12	Twig\Template->yieldBlock (line 131)
13	__TwigTemplate_524d7b10e6d6f14400beb3479db76af1->doDisplay (line 388)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_18bdf81afd9f4d62d6dfd906e8b6c272->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 348)
24	App\Controller\ZFrontController->front_works_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)

0.48 ms
(13.67%)

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:

[
  87
]

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

#	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 332)
12	App\Repository\MediasRepository->findAllActifByVarTitreEtAuteur (line 344)
13	App\Controller\ZFrontController->front_works_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)

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

Entities Mapping

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

Symfony Profiler

GET https://philippegautier.com/works/detail/Daho/Comme%20un%20igloo

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping