Symfony Profiler

Query Metrics

10 Database Queries

4 Different statements

9.60 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.99 ms
(41.59%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1

Parameters:

[
  "contact"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
  AND t0.parent_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'contact' AND t0.parent_id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Twig\Runtime\AppExtensionRuntime->recupererMenu (line 19)
5	__TwigTemplate_802add689eee27fe581ebd5b86c1c484->doDisplay (line 58)
6	Twig\Template->yield (line 402)
7	Twig\Template->display (line 358)
8	Twig\Template->render (line 373)
9	Twig\TemplateWrapper->render (line 51)
10	Twig\Environment->render (line 333)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
14	App\Controller\SiteController->contact (line 358)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

2.28 ms
(23.73%)

SELECT s0_.id AS id_0, s0_.titre_principal AS titre_principal_1, s0_.sous_titre_principal AS sous_titre_principal_2, s0_.contenu_principal AS contenu_principal_3, s0_.code_image_principale AS code_image_principale_4, s0_.position_page AS position_page_5, s0_.code_fichier AS code_fichier_6, s0_.position_template AS position_template_7, s0_.background_image AS background_image_8, s0_.background_color AS background_color_9, s0_.lien_bouton_action1 AS lien_bouton_action1_10, s0_.lien_bouton_action2 AS lien_bouton_action2_11, s0_.lien_bouton_action3 AS lien_bouton_action3_12, s0_.titre_bouton_action1 AS titre_bouton_action1_13, s0_.titre_bouton_action2 AS titre_bouton_action2_14, s0_.titre_bouton_action3 AS titre_bouton_action3_15, s0_.reference AS reference_16, s0_.autre_document_code_fichier AS autre_document_code_fichier_17, s0_.parent_id AS parent_id_18, s0_.menu_id AS menu_id_19, s0_.actualite_evenement_id AS actualite_evenement_id_20 FROM section s0_ LEFT JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s1_.id IS NULL AND s0_.menu_id = ? ORDER BY s0_.position_page ASC

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.titre_principal AS titre_principal_1,
  s0_.sous_titre_principal AS sous_titre_principal_2,
  s0_.contenu_principal AS contenu_principal_3,
  s0_.code_image_principale AS code_image_principale_4,
  s0_.position_page AS position_page_5,
  s0_.code_fichier AS code_fichier_6,
  s0_.position_template AS position_template_7,
  s0_.background_image AS background_image_8,
  s0_.background_color AS background_color_9,
  s0_.lien_bouton_action1 AS lien_bouton_action1_10,
  s0_.lien_bouton_action2 AS lien_bouton_action2_11,
  s0_.lien_bouton_action3 AS lien_bouton_action3_12,
  s0_.titre_bouton_action1 AS titre_bouton_action1_13,
  s0_.titre_bouton_action2 AS titre_bouton_action2_14,
  s0_.titre_bouton_action3 AS titre_bouton_action3_15,
  s0_.reference AS reference_16,
  s0_.autre_document_code_fichier AS autre_document_code_fichier_17,
  s0_.parent_id AS parent_id_18,
  s0_.menu_id AS menu_id_19,
  s0_.actualite_evenement_id AS actualite_evenement_id_20
FROM
  section s0_
  LEFT JOIN section s1_ ON s0_.id = s1_.parent_id
WHERE
  s0_.parent_id IS NULL
  AND s1_.id IS NULL
  AND s0_.menu_id = ?
ORDER BY
  s0_.position_page ASC

SELECT s0_.id AS id_0, s0_.titre_principal AS titre_principal_1, s0_.sous_titre_principal AS sous_titre_principal_2, s0_.contenu_principal AS contenu_principal_3, s0_.code_image_principale AS code_image_principale_4, s0_.position_page AS position_page_5, s0_.code_fichier AS code_fichier_6, s0_.position_template AS position_template_7, s0_.background_image AS background_image_8, s0_.background_color AS background_color_9, s0_.lien_bouton_action1 AS lien_bouton_action1_10, s0_.lien_bouton_action2 AS lien_bouton_action2_11, s0_.lien_bouton_action3 AS lien_bouton_action3_12, s0_.titre_bouton_action1 AS titre_bouton_action1_13, s0_.titre_bouton_action2 AS titre_bouton_action2_14, s0_.titre_bouton_action3 AS titre_bouton_action3_15, s0_.reference AS reference_16, s0_.autre_document_code_fichier AS autre_document_code_fichier_17, s0_.parent_id AS parent_id_18, s0_.menu_id AS menu_id_19, s0_.actualite_evenement_id AS actualite_evenement_id_20 FROM section s0_ LEFT JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s1_.id IS NULL AND s0_.menu_id = 7 ORDER BY s0_.position_page ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\SectionRepository->recupererSectionSansParentSansEnfant (line 73)
7	App\Controller\SiteController->contact (line 296)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

2.09 ms
(21.81%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.code_fichier AS code_fichier_4, t0.position_contenu AS position_contenu_5, t0.sous_titre AS sous_titre_6, t0.lien_bouton_action1 AS lien_bouton_action1_7, t0.lien_bouton_action2 AS lien_bouton_action2_8, t0.lien_bouton_action3 AS lien_bouton_action3_9, t0.titre_bouton_action1 AS titre_bouton_action1_10, t0.titre_bouton_action2 AS titre_bouton_action2_11, t0.titre_bouton_action3 AS titre_bouton_action3_12, t0.autre_document_code_fichier AS autre_document_code_fichier_13, t0.section_id AS section_id_14 FROM disposition t0 WHERE t0.section_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.contenu AS contenu_3,
  t0.code_fichier AS code_fichier_4,
  t0.position_contenu AS position_contenu_5,
  t0.sous_titre AS sous_titre_6,
  t0.lien_bouton_action1 AS lien_bouton_action1_7,
  t0.lien_bouton_action2 AS lien_bouton_action2_8,
  t0.lien_bouton_action3 AS lien_bouton_action3_9,
  t0.titre_bouton_action1 AS titre_bouton_action1_10,
  t0.titre_bouton_action2 AS titre_bouton_action2_11,
  t0.titre_bouton_action3 AS titre_bouton_action3_12,
  t0.autre_document_code_fichier AS autre_document_code_fichier_13,
  t0.section_id AS section_id_14
FROM
  disposition t0
WHERE
  t0.section_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.code_fichier AS code_fichier_4, t0.position_contenu AS position_contenu_5, t0.sous_titre AS sous_titre_6, t0.lien_bouton_action1 AS lien_bouton_action1_7, t0.lien_bouton_action2 AS lien_bouton_action2_8, t0.lien_bouton_action3 AS lien_bouton_action3_9, t0.titre_bouton_action1 AS titre_bouton_action1_10, t0.titre_bouton_action2 AS titre_bouton_action2_11, t0.titre_bouton_action3 AS titre_bouton_action3_12, t0.autre_document_code_fichier AS autre_document_code_fichier_13, t0.section_id AS section_id_14 FROM disposition t0 WHERE t0.section_id = 31;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1704)
10	__TwigTemplate_802add689eee27fe581ebd5b86c1c484::block_body (line 222)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_5459c42b4c15cbe8108cb2844beb7586->doDisplay (line 215)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_802add689eee27fe581ebd5b86c1c484->doDisplay (line 61)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\SiteController->contact (line 358)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.24 ms
(12.87%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "contact"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'contact' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\SiteController->contact (line 289)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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\Menu	6
App\Entity\Disposition	3
App\Entity\Section	1

Entities Mapping

Class	Mapping errors
App\Entity\Menu	No errors.
App\Entity\Section	No errors.
App\Entity\ActualiteEvenement	No errors.
App\Entity\Disposition	No errors.

Symfony Profiler

GET https://amai-group.com/contact

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping