Symfony Profiler

Query Metrics

95 Database Queries

8 Different statements

11.97 ms Query time

3 Invalid entities

205 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.13 ms
(34.52%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.archive AS archive_4, t0.titlepage AS titlepage_5, t0.link AS link_6, t0.path AS path_7, t0.shortdescription AS shortdescription_8, t0.content AS content_9, t0.rang AS rang_10, t0.layout AS layout_11, t0.visible AS visible_12, t0.publication AS publication_13, t0.creationdate AS creationdate_14, t0.updatedate AS updatedate_15, t0.index_entity_type AS index_entity_type_16, t0.index_entity_id AS index_entity_id_17, t0.icon AS icon_18, t0.color AS color_19, t0.intitule_plus AS intitule_plus_20, t0.colorheader AS colorheader_21, t0.colorleft AS colorleft_22, t0.colorcontent AS colorcontent_23, t0.colorfooter AS colorfooter_24, t0.typeformation_id AS typeformation_id_25, t0.contentseo AS contentseo_26, t0.contentslider AS contentslider_27, t0.contenttemplate_id AS contenttemplate_id_28, t0.parent AS parent_29, t0.typepage_id AS typepage_id_30 FROM content_page t0 WHERE t0.parent = ? ORDER BY t0.rang ASC

Parameters:

[
  12382
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.archive AS archive_4,
  t0.titlepage AS titlepage_5,
  t0.link AS link_6,
  t0.path AS path_7,
  t0.shortdescription AS shortdescription_8,
  t0.content AS content_9,
  t0.rang AS rang_10,
  t0.layout AS layout_11,
  t0.visible AS visible_12,
  t0.publication AS publication_13,
  t0.creationdate AS creationdate_14,
  t0.updatedate AS updatedate_15,
  t0.index_entity_type AS index_entity_type_16,
  t0.index_entity_id AS index_entity_id_17,
  t0.icon AS icon_18,
  t0.color AS color_19,
  t0.intitule_plus AS intitule_plus_20,
  t0.colorheader AS colorheader_21,
  t0.colorleft AS colorleft_22,
  t0.colorcontent AS colorcontent_23,
  t0.colorfooter AS colorfooter_24,
  t0.typeformation_id AS typeformation_id_25,
  t0.contentseo AS contentseo_26,
  t0.contentslider AS contentslider_27,
  t0.contenttemplate_id AS contenttemplate_id_28,
  t0.parent AS parent_29,
  t0.typepage_id AS typepage_id_30
FROM
  content_page t0
WHERE
  t0.parent = ?
ORDER BY
  t0.rang ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.archive AS archive_4, t0.titlepage AS titlepage_5, t0.link AS link_6, t0.path AS path_7, t0.shortdescription AS shortdescription_8, t0.content AS content_9, t0.rang AS rang_10, t0.layout AS layout_11, t0.visible AS visible_12, t0.publication AS publication_13, t0.creationdate AS creationdate_14, t0.updatedate AS updatedate_15, t0.index_entity_type AS index_entity_type_16, t0.index_entity_id AS index_entity_id_17, t0.icon AS icon_18, t0.color AS color_19, t0.intitule_plus AS intitule_plus_20, t0.colorheader AS colorheader_21, t0.colorleft AS colorleft_22, t0.colorcontent AS colorcontent_23, t0.colorfooter AS colorfooter_24, t0.typeformation_id AS typeformation_id_25, t0.contentseo AS contentseo_26, t0.contentslider AS contentslider_27, t0.contenttemplate_id AS contenttemplate_id_28, t0.parent AS parent_29, t0.typepage_id AS typepage_id_30 FROM content_page t0 WHERE t0.parent = 12382 ORDER BY t0.rang ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Repository\ContentPageRepository->findByParent (line 82)
4	App\Service\FrontService->getPageFils (line 303)
5	App\Service\FrontService->getMenu (line 291)
6	App\Controller\ContentController->head (line 154)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
14	__TwigTemplate_80a9523a808e34df4e88bdc4015e252a->doDisplay (line 614)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_5927ff64536b34ef4c4fe8c5b93ab06c->doDisplay (line 57)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	App\Controller\IndexController->detailmodule (line 482)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

2.92 ms
(24.43%)

SELECT m0_.id AS id_0, m0_.rang AS rang_1, m0_.menu_id AS menu_id_2, m0_.contentpage_id AS contentpage_id_3 FROM menu_content_page m0_ INNER JOIN menu m1_ ON m0_.menu_id = m1_.id WHERE m1_.name = ? ORDER BY m0_.rang ASC

Parameters:

[
  "main_menu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.rang AS rang_1,
  m0_.menu_id AS menu_id_2,
  m0_.contentpage_id AS contentpage_id_3
FROM
  menu_content_page m0_
  INNER JOIN menu m1_ ON m0_.menu_id = m1_.id
WHERE
  m1_.name = ?
ORDER BY
  m0_.rang ASC

SELECT m0_.id AS id_0, m0_.rang AS rang_1, m0_.menu_id AS menu_id_2, m0_.contentpage_id AS contentpage_id_3 FROM menu_content_page m0_ INNER JOIN menu m1_ ON m0_.menu_id = m1_.id WHERE m1_.name = 'main_menu' ORDER BY m0_.rang ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\MenuContentPageRepository->getBymenuIdentifiant (line 34)
7	App\Service\FrontService->getMenu (line 279)
8	App\Controller\ContentController->head (line 154)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
16	__TwigTemplate_80a9523a808e34df4e88bdc4015e252a->doDisplay (line 614)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_5927ff64536b34ef4c4fe8c5b93ab06c->doDisplay (line 57)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\IndexController->detailmodule (line 482)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

1.40 ms
(11.71%)

SELECT t0.id AS id_1, t0.archive AS archive_2, t0.label AS label_3, t0.name AS name_4, t0.creationdate AS creationdate_5, t0.updatedate AS updatedate_6, t0.rang AS rang_7, t0.categorie_id AS categorie_id_8, t0.type_id AS type_id_9, t0.diffusion_id AS diffusion_id_10 FROM menu t0 WHERE t0.name IN (?) LIMIT 1

Parameters:

[
  "main_menu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.archive AS archive_2,
  t0.label AS label_3,
  t0.name AS name_4,
  t0.creationdate AS creationdate_5,
  t0.updatedate AS updatedate_6,
  t0.rang AS rang_7,
  t0.categorie_id AS categorie_id_8,
  t0.type_id AS type_id_9,
  t0.diffusion_id AS diffusion_id_10
FROM
  menu t0
WHERE
  t0.name IN (?)
LIMIT
  1

SELECT t0.id AS id_1, t0.archive AS archive_2, t0.label AS label_3, t0.name AS name_4, t0.creationdate AS creationdate_5, t0.updatedate AS updatedate_6, t0.rang AS rang_7, t0.categorie_id AS categorie_id_8, t0.type_id AS type_id_9, t0.diffusion_id AS diffusion_id_10 FROM menu t0 WHERE t0.name IN ('main_menu') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 364)
4	Doctrine\ORM\EntityRepository->__call (line 275)
5	App\Service\FrontService->getMenu (line 274)
6	App\Controller\ContentController->head (line 154)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
14	__TwigTemplate_80a9523a808e34df4e88bdc4015e252a->doDisplay (line 614)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_5927ff64536b34ef4c4fe8c5b93ab06c->doDisplay (line 57)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	App\Controller\IndexController->detailmodule (line 482)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

1.19 ms
(9.90%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.archive AS archive_4, t0.titlepage AS titlepage_5, t0.link AS link_6, t0.path AS path_7, t0.shortdescription AS shortdescription_8, t0.content AS content_9, t0.rang AS rang_10, t0.layout AS layout_11, t0.visible AS visible_12, t0.publication AS publication_13, t0.creationdate AS creationdate_14, t0.updatedate AS updatedate_15, t0.index_entity_type AS index_entity_type_16, t0.index_entity_id AS index_entity_id_17, t0.icon AS icon_18, t0.color AS color_19, t0.intitule_plus AS intitule_plus_20, t0.colorheader AS colorheader_21, t0.colorleft AS colorleft_22, t0.colorcontent AS colorcontent_23, t0.colorfooter AS colorfooter_24, t0.typeformation_id AS typeformation_id_25, t0.contentseo AS contentseo_26, t0.contentslider AS contentslider_27, t0.contenttemplate_id AS contenttemplate_id_28, t0.parent AS parent_29, t0.typepage_id AS typepage_id_30 FROM content_page t0 WHERE t0.id = ?

Parameters:

[
  12382
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.archive AS archive_4,
  t0.titlepage AS titlepage_5,
  t0.link AS link_6,
  t0.path AS path_7,
  t0.shortdescription AS shortdescription_8,
  t0.content AS content_9,
  t0.rang AS rang_10,
  t0.layout AS layout_11,
  t0.visible AS visible_12,
  t0.publication AS publication_13,
  t0.creationdate AS creationdate_14,
  t0.updatedate AS updatedate_15,
  t0.index_entity_type AS index_entity_type_16,
  t0.index_entity_id AS index_entity_id_17,
  t0.icon AS icon_18,
  t0.color AS color_19,
  t0.intitule_plus AS intitule_plus_20,
  t0.colorheader AS colorheader_21,
  t0.colorleft AS colorleft_22,
  t0.colorcontent AS colorcontent_23,
  t0.colorfooter AS colorfooter_24,
  t0.typeformation_id AS typeformation_id_25,
  t0.contentseo AS contentseo_26,
  t0.contentslider AS contentslider_27,
  t0.contenttemplate_id AS contenttemplate_id_28,
  t0.parent AS parent_29,
  t0.typepage_id AS typepage_id_30
FROM
  content_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.archive AS archive_4, t0.titlepage AS titlepage_5, t0.link AS link_6, t0.path AS path_7, t0.shortdescription AS shortdescription_8, t0.content AS content_9, t0.rang AS rang_10, t0.layout AS layout_11, t0.visible AS visible_12, t0.publication AS publication_13, t0.creationdate AS creationdate_14, t0.updatedate AS updatedate_15, t0.index_entity_type AS index_entity_type_16, t0.index_entity_id AS index_entity_id_17, t0.icon AS icon_18, t0.color AS color_19, t0.intitule_plus AS intitule_plus_20, t0.colorheader AS colorheader_21, t0.colorleft AS colorleft_22, t0.colorcontent AS colorcontent_23, t0.colorfooter AS colorfooter_24, t0.typeformation_id AS typeformation_id_25, t0.contentseo AS contentseo_26, t0.contentslider AS contentslider_27, t0.contenttemplate_id AS contenttemplate_id_28, t0.parent AS parent_29, t0.typepage_id AS typepage_id_30 FROM content_page t0 WHERE t0.id = 12382;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\ContentPage::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\ContentPage->__get (line 153)
7	App\Entity\ContentPage->getPath (line 240)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_e474397190fe479fe0fb6b45b6892ad4::doDisplay (line 59)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 261)
17	App\Controller\ContentController->head (line 158)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
21	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
22	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
23	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
24	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
25	__TwigTemplate_80a9523a808e34df4e88bdc4015e252a->doDisplay (line 614)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_5927ff64536b34ef4c4fe8c5b93ab06c->doDisplay (line 57)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
36	App\Controller\IndexController->detailmodule (line 482)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 182)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
41	require_once (line 32)
42	require_once (line 5)

1.06 ms
(8.90%)

SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.type AS type_4, t0.path AS path_5, t0.dataCreation AS dataCreation_6, t0.dataUpdated AS dataUpdated_7 FROM theme_settings t0 WHERE t0.field = ? LIMIT 1

Parameters:

[
  "default_vignette"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.field AS field_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.dataCreation AS dataCreation_6,
  t0.dataUpdated AS dataUpdated_7
FROM
  theme_settings t0
WHERE
  t0.field = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.type AS type_4, t0.path AS path_5, t0.dataCreation AS dataCreation_6, t0.dataUpdated AS dataUpdated_7 FROM theme_settings t0 WHERE t0.field = 'default_vignette' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 364)
4	Doctrine\ORM\EntityRepository->__call (line 275)
5	App\Controller\IndexController->__construct (line 40)
6	ContainerXJd2pzo\getIndexControllerService->do (line 24)
7	ContainerXJd2pzo\App_KernelDevDebugContainer::load (line 539)
8	Symfony\Component\DependencyInjection\Container->make (line 221)
9	Symfony\Component\DependencyInjection\Container::get (line 203)
10	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
11	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
12	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
14	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
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 32)
20	require_once (line 5)

0.57 ms
(4.73%)

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.valeur AS valeur_2, m0_.valeur2 AS valeur2_3, m0_.valeur3 AS valeur3_4, m0_.htmlvaleur AS htmlvaleur_5, m0_.designation AS designation_6, m1_.id AS id_7, m1_.module AS module_8, m1_.code AS code_9, m1_.designation AS designation_10, m0_.masterliste_id AS masterliste_id_11 FROM masterlistelgs m0_ INNER JOIN masterlistes m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1

Parameters:

[
  "NBHRSFORMATION"
  "NOYAU"
  "PARAMETRAGE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.valeur AS valeur_2,
  m0_.valeur2 AS valeur2_3,
  m0_.valeur3 AS valeur3_4,
  m0_.htmlvaleur AS htmlvaleur_5,
  m0_.designation AS designation_6,
  m1_.id AS id_7,
  m1_.module AS module_8,
  m1_.code AS code_9,
  m1_.designation AS designation_10,
  m0_.masterliste_id AS masterliste_id_11
FROM
  masterlistelgs m0_
  INNER JOIN masterlistes m1_ ON m0_.masterliste_id = m1_.id
WHERE
  m0_.code = ?
  AND m1_.module = ?
  AND m1_.code = ?
LIMIT
  1

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.valeur AS valeur_2, m0_.valeur2 AS valeur2_3, m0_.valeur3 AS valeur3_4, m0_.htmlvaleur AS htmlvaleur_5, m0_.designation AS designation_6, m1_.id AS id_7, m1_.module AS module_8, m1_.code AS code_9, m1_.designation AS designation_10, m0_.masterliste_id AS masterliste_id_11 FROM masterlistelgs m0_ INNER JOIN masterlistes m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = 'NBHRSFORMATION' AND m1_.module = 'NOYAU' AND m1_.code = 'PARAMETRAGE' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
6	App\Repository\MasterlistelgRepository->getOneByListeCode (line 242)
7	App\Service\FrontService->__construct (line 26)
8	ContainerXJd2pzo\getFrontServiceService->do (line 23)
9	ContainerXJd2pzo\App_KernelDevDebugContainer::load (line 539)
10	ContainerXJd2pzo\getIndexControllerService->do (line 24)
11	ContainerXJd2pzo\App_KernelDevDebugContainer::load (line 539)
12	Symfony\Component\DependencyInjection\Container->make (line 221)
13	Symfony\Component\DependencyInjection\Container::get (line 203)
14	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
15	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
18	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.56 ms
(4.68%)

SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.type AS type_4, t0.path AS path_5, t0.dataCreation AS dataCreation_6, t0.dataUpdated AS dataUpdated_7 FROM theme_settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.field AS field_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.dataCreation AS dataCreation_6,
  t0.dataUpdated AS dataUpdated_7
FROM
  theme_settings t0

SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.type AS type_4, t0.path AS path_5, t0.dataCreation AS dataCreation_6, t0.dataUpdated AS dataUpdated_7 FROM theme_settings t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	App\Service\FrontService->getThemeSettings (line 30)
5	App\Controller\IndexController->detailmodule (line 448)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.13 ms
(1.13%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt_logo AS alt_logo_4, t0.image_name AS image_name_5, t0.archive AS archive_6, t0.updated_at AS updated_at_7 FROM social_settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.alt_logo AS alt_logo_4,
  t0.image_name AS image_name_5,
  t0.archive AS archive_6,
  t0.updated_at AS updated_at_7
FROM
  social_settings t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt_logo AS alt_logo_4, t0.image_name AS image_name_5, t0.archive AS archive_6, t0.updated_at AS updated_at_7 FROM social_settings t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	App\Controller\ContentController->head (line 164)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_80a9523a808e34df4e88bdc4015e252a->doDisplay (line 614)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_5927ff64536b34ef4c4fe8c5b93ab06c->doDisplay (line 57)
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 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\IndexController->detailmodule (line 482)
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 32)
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\ThemeSettings	63
App\Entity\ContentPage	58
App\Entity\ContentSeo	50
App\Entity\MenuContentPage	14
App\Entity\Masterlistelg	9
App\Entity\ContentSlider	8
App\Entity\Menu	3

Entities Mapping

Class	Mapping errors
App\Entity\Masterlistelg	No errors.
App\Entity\Masterliste	No errors.
App\Entity\ThemeSettings	No errors.
App\Entity\ContentSeo	The field 'App\Entity\ContentSeo#archive' has the property type 'false' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Blog	No errors.
App\Entity\Lead	The field 'App\Entity\Lead#parcours' has the property type 'App\Entity\Parcours' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\Statistic	No errors.
App\Entity\Testimony	No errors.
App\Entity\User	No errors.
App\Entity\ContentPage	No errors.
App\Entity\ContentSection	No errors.
App\Entity\ContentSlide	The field 'App\Entity\ContentSlide#button' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\ContentSlider	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuContentPage	No errors.
App\Entity\PageSection	No errors.
App\Entity\SocialSettings	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://site.simplyform.lmosoft.com/module/detail/D%C3%89V101_JavaScript_initiation

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping