Symfony Profiler

Query Metrics

18 Database Queries

4 Different statements

6.70 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.21 ms
(62.89%)

SELECT t0.id AS id_1, t0.contenu_fr AS contenu_fr_2, t0.contenu_en AS contenu_en_3, t0.contenu_es AS contenu_es_4, t0.est_modifiable AS est_modifiable_5, t0.image_fond AS image_fond_6, t0.image_contenu AS image_contenu_7, t0.pdf_fr AS pdf_fr_8, t0.pdf_en AS pdf_en_9, t0.pdf_es AS pdf_es_10, t0.sous_menu_id AS sous_menu_id_11, t0.menu_id AS menu_id_12 FROM page t0 WHERE t0.menu_id = ?

Parameters:

[
  248
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.contenu_fr AS contenu_fr_2,
  t0.contenu_en AS contenu_en_3,
  t0.contenu_es AS contenu_es_4,
  t0.est_modifiable AS est_modifiable_5,
  t0.image_fond AS image_fond_6,
  t0.image_contenu AS image_contenu_7,
  t0.pdf_fr AS pdf_fr_8,
  t0.pdf_en AS pdf_en_9,
  t0.pdf_es AS pdf_es_10,
  t0.sous_menu_id AS sous_menu_id_11,
  t0.menu_id AS menu_id_12
FROM
  page t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.contenu_fr AS contenu_fr_2, t0.contenu_en AS contenu_en_3, t0.contenu_es AS contenu_es_4, t0.est_modifiable AS est_modifiable_5, t0.image_fond AS image_fond_6, t0.image_contenu AS image_contenu_7, t0.pdf_fr AS pdf_fr_8, t0.pdf_en AS pdf_en_9, t0.pdf_es AS pdf_es_10, t0.sous_menu_id AS sous_menu_id_11, t0.menu_id AS menu_id_12 FROM page t0 WHERE t0.menu_id = 248;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 833)
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 58)
12	App\Twig\AppExtension->header (line 303)
13	__TwigTemplate_8577221a429931ff639a0d410c71cd50->doDisplay (line 393)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_14c7cec8f8ce35dbb375b01213663c84->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
24	App\Controller\ActualiteController->viewActualite (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.86 ms
(12.89%)

SELECT a0_.id AS id_0, a0_.titre_fr AS titre_fr_1, a0_.contenu_fr AS contenu_fr_2, a0_.date_creation AS date_creation_3, a0_.est_actif AS est_actif_4, a0_.titre_en AS titre_en_5, a0_.titre_es AS titre_es_6, a0_.contenu_en AS contenu_en_7, a0_.contenu_es AS contenu_es_8 FROM actualite a0_ WHERE a0_.id LIKE ? AND a0_.est_actif = 1 LIMIT 1

Parameters:

[
  "19"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre_fr AS titre_fr_1,
  a0_.contenu_fr AS contenu_fr_2,
  a0_.date_creation AS date_creation_3,
  a0_.est_actif AS est_actif_4,
  a0_.titre_en AS titre_en_5,
  a0_.titre_es AS titre_es_6,
  a0_.contenu_en AS contenu_en_7,
  a0_.contenu_es AS contenu_es_8
FROM
  actualite a0_
WHERE
  a0_.id LIKE ?
  AND a0_.est_actif = 1
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre_fr AS titre_fr_1, a0_.contenu_fr AS contenu_fr_2, a0_.date_creation AS date_creation_3, a0_.est_actif AS est_actif_4, a0_.titre_en AS titre_en_5, a0_.titre_es AS titre_es_6, a0_.contenu_en AS contenu_en_7, a0_.contenu_es AS contenu_es_8 FROM actualite a0_ WHERE a0_.id LIKE '19' AND a0_.est_actif = 1 LIMIT 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 40)
7	App\Repository\ActualiteRepository->getActiveActualiteFromID (line 44)
8	App\Controller\ActualiteController->viewActualite (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.86 ms
(12.86%)

SELECT p0_.id AS id_0, p0_.mail_destinataire AS mail_destinataire_1, p0_.mail_expediteur AS mail_expediteur_2, p0_.facebook AS facebook_3, p0_.instagram AS instagram_4, p0_.latitude AS latitude_5, p0_.longitude AS longitude_6, p0_.linkedin AS linkedin_7 FROM parametres_globaux p0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.mail_destinataire AS mail_destinataire_1,
  p0_.mail_expediteur AS mail_expediteur_2,
  p0_.facebook AS facebook_3,
  p0_.instagram AS instagram_4,
  p0_.latitude AS latitude_5,
  p0_.longitude AS longitude_6,
  p0_.linkedin AS linkedin_7
FROM
  parametres_globaux p0_
LIMIT
  1

SELECT p0_.id AS id_0, p0_.mail_destinataire AS mail_destinataire_1, p0_.mail_expediteur AS mail_expediteur_2, p0_.facebook AS facebook_3, p0_.instagram AS instagram_4, p0_.latitude AS latitude_5, p0_.longitude AS longitude_6, p0_.linkedin AS linkedin_7 FROM parametres_globaux p0_ LIMIT 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 69)
7	App\Twig\AppExtension->globalParameter (line 594)
8	__TwigTemplate_8577221a429931ff639a0d410c71cd50->doDisplay (line 393)
9	Twig\Template->yield (line 56)
10	__TwigTemplate_14c7cec8f8ce35dbb375b01213663c84->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
19	App\Controller\ActualiteController->viewActualite (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.76 ms
(11.36%)

SELECT m0_.id AS id_0, m0_.libelle_fr AS libelle_fr_1, m0_.libelle_en AS libelle_en_2, m0_.libelle_es AS libelle_es_3, m0_.est_actif AS est_actif_4, m0_.peut_contenir_page AS peut_contenir_page_5, m0_.est_footer AS est_footer_6, m0_.est_affiche AS est_affiche_7, m0_.ordre AS ordre_8, m0_.image AS image_9, m0_.nom_route AS nom_route_10 FROM menu m0_ WHERE m0_.est_actif = ? AND m0_.est_footer = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.libelle_fr AS libelle_fr_1,
  m0_.libelle_en AS libelle_en_2,
  m0_.libelle_es AS libelle_es_3,
  m0_.est_actif AS est_actif_4,
  m0_.peut_contenir_page AS peut_contenir_page_5,
  m0_.est_footer AS est_footer_6,
  m0_.est_affiche AS est_affiche_7,
  m0_.ordre AS ordre_8,
  m0_.image AS image_9,
  m0_.nom_route AS nom_route_10
FROM
  menu m0_
WHERE
  m0_.est_actif = ?
  AND m0_.est_footer = ?

SELECT m0_.id AS id_0, m0_.libelle_fr AS libelle_fr_1, m0_.libelle_en AS libelle_en_2, m0_.libelle_es AS libelle_es_3, m0_.est_actif AS est_actif_4, m0_.peut_contenir_page AS peut_contenir_page_5, m0_.est_footer AS est_footer_6, m0_.est_affiche AS est_affiche_7, m0_.ordre AS ordre_8, m0_.image AS image_9, m0_.nom_route AS nom_route_10 FROM menu m0_ WHERE m0_.est_actif = 1 AND m0_.est_footer = 0;

#	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\Twig\AppExtension->header (line 303)
8	__TwigTemplate_8577221a429931ff639a0d410c71cd50->doDisplay (line 393)
9	Twig\Template->yield (line 56)
10	__TwigTemplate_14c7cec8f8ce35dbb375b01213663c84->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
19	App\Controller\ActualiteController->viewActualite (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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.

Entities Mapping

Class	Mapping errors
App\Entity\Actualite	No errors.
App\Entity\Menu	No errors.
App\Entity\SousMenu	No errors.
App\Entity\Page	No errors.
App\Entity\ParametresGlobaux	No errors.

Symfony Profiler

GET http://86.65.9.121/en/actualite/19

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping