Symfony Profiler

Query Metrics

43 Database Queries

7 Different statements

26.68 ms Query time

0 Invalid entities

68 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.78 ms
(51.65%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1

Parameters:

[
  "5PeDc5VTLJLeK8if"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.location AS location_5,
  t0.size AS size_6,
  t0.reference_code AS reference_code_7,
  t0.temp AS temp_8,
  t0.lien AS lien_9
FROM
  files t0
WHERE
  t0.reference_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = '5PeDc5VTLJLeK8if' 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\Services\FileUploader2->getFilesByFileCode (line 133)
5	App\Twig\FileExtension->getFilesByFileCode (line 29)
6	__TwigTemplate_865afda164ebe5b4dfe8f4fe17192bd0->block_body (line 223)
7	Twig\Template->yieldBlock (line 446)
8	__TwigTemplate_5459c42b4c15cbe8108cb2844beb7586->doDisplay (line 215)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_865afda164ebe5b4dfe8f4fe17192bd0->doDisplay (line 58)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
19	App\Controller\SiteController->opportunite (line 93)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

3.97 ms
(14.89%)

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:

[
  "opportunites"
]

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 = 'opportunites' 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_865afda164ebe5b4dfe8f4fe17192bd0->doDisplay (line 55)
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->opportunite (line 93)
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)

3.86 ms
(14.48%)

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:

[
  13
]

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

#	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_865afda164ebe5b4dfe8f4fe17192bd0::block_body (line 168)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_5459c42b4c15cbe8108cb2844beb7586->doDisplay (line 215)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_865afda164ebe5b4dfe8f4fe17192bd0->doDisplay (line 58)
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->opportunite (line 93)
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)

2.48 ms
(9.28%)

SELECT DISTINCT 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_ INNER JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s0_.menu_id = ? ORDER BY s0_.position_page ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT 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_
  INNER JOIN section s1_ ON s0_.id = s1_.parent_id
WHERE
  s0_.parent_id IS NULL
  AND s0_.menu_id = ?
ORDER BY
  s0_.position_page ASC

SELECT DISTINCT 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_ INNER JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s0_.menu_id = 2 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->recupererSectionSansParentAvecEnfant (line 44)
7	App\Controller\SiteController->opportunite (line 90)
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)

1.30 ms
(4.89%)

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:

[
  "opportunites"
]

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 = 'opportunites' 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->opportunite (line 84)
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)

0.81 ms
(3.02%)

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:

[
  2
]

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 = 2 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->opportunite (line 91)
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)

0.48 ms
(1.79%)

SELECT t0.id AS id_1, t0.titre_principal AS titre_principal_2, t0.sous_titre_principal AS sous_titre_principal_3, t0.contenu_principal AS contenu_principal_4, t0.code_image_principale AS code_image_principale_5, t0.position_page AS position_page_6, t0.code_fichier AS code_fichier_7, t0.position_template AS position_template_8, t0.background_image AS background_image_9, t0.background_color AS background_color_10, t0.lien_bouton_action1 AS lien_bouton_action1_11, t0.lien_bouton_action2 AS lien_bouton_action2_12, t0.lien_bouton_action3 AS lien_bouton_action3_13, t0.titre_bouton_action1 AS titre_bouton_action1_14, t0.titre_bouton_action2 AS titre_bouton_action2_15, t0.titre_bouton_action3 AS titre_bouton_action3_16, t0.reference AS reference_17, t0.autre_document_code_fichier AS autre_document_code_fichier_18, t0.parent_id AS parent_id_19, t0.menu_id AS menu_id_20, t0.actualite_evenement_id AS actualite_evenement_id_21 FROM section t0 WHERE t0.parent_id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre_principal AS titre_principal_2,
  t0.sous_titre_principal AS sous_titre_principal_3,
  t0.contenu_principal AS contenu_principal_4,
  t0.code_image_principale AS code_image_principale_5,
  t0.position_page AS position_page_6,
  t0.code_fichier AS code_fichier_7,
  t0.position_template AS position_template_8,
  t0.background_image AS background_image_9,
  t0.background_color AS background_color_10,
  t0.lien_bouton_action1 AS lien_bouton_action1_11,
  t0.lien_bouton_action2 AS lien_bouton_action2_12,
  t0.lien_bouton_action3 AS lien_bouton_action3_13,
  t0.titre_bouton_action1 AS titre_bouton_action1_14,
  t0.titre_bouton_action2 AS titre_bouton_action2_15,
  t0.titre_bouton_action3 AS titre_bouton_action3_16,
  t0.reference AS reference_17,
  t0.autre_document_code_fichier AS autre_document_code_fichier_18,
  t0.parent_id AS parent_id_19,
  t0.menu_id AS menu_id_20,
  t0.actualite_evenement_id AS actualite_evenement_id_21
FROM
  section t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.titre_principal AS titre_principal_2, t0.sous_titre_principal AS sous_titre_principal_3, t0.contenu_principal AS contenu_principal_4, t0.code_image_principale AS code_image_principale_5, t0.position_page AS position_page_6, t0.code_fichier AS code_fichier_7, t0.position_template AS position_template_8, t0.background_image AS background_image_9, t0.background_color AS background_color_10, t0.lien_bouton_action1 AS lien_bouton_action1_11, t0.lien_bouton_action2 AS lien_bouton_action2_12, t0.lien_bouton_action3 AS lien_bouton_action3_13, t0.titre_bouton_action1 AS titre_bouton_action1_14, t0.titre_bouton_action2 AS titre_bouton_action2_15, t0.titre_bouton_action3 AS titre_bouton_action3_16, t0.reference AS reference_17, t0.autre_document_code_fichier AS autre_document_code_fichier_18, t0.parent_id AS parent_id_19, t0.menu_id AS menu_id_20, t0.actualite_evenement_id AS actualite_evenement_id_21 FROM section t0 WHERE t0.parent_id = 14;

#	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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_865afda164ebe5b4dfe8f4fe17192bd0->block_body (line 283)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_5459c42b4c15cbe8108cb2844beb7586->doDisplay (line 215)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_865afda164ebe5b4dfe8f4fe17192bd0->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\SiteController->opportunite (line 93)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	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\Disposition	30
App\Entity\Files	27
App\Entity\Menu	6
App\Entity\Section	5

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.
App\Entity\Files	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping