Symfony Profiler

Query Metrics

97 Database Queries

13 Different statements

23.91 ms Query time

3 Invalid entities

212 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.02 ms
(41.91%)

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_5db3ffb3782d43ff69be47d3c34edc6b->doDisplay (line 54)
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->viewsAction (line 552)
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)

3.79 ms
(15.87%)

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->viewsAction (line 533)
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)

3.61 ms
(15.10%)

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_5db3ffb3782d43ff69be47d3c34edc6b->doDisplay (line 54)
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->viewsAction (line 552)
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.99 ms
(12.51%)

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_5db3ffb3782d43ff69be47d3c34edc6b->doDisplay (line 54)
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->viewsAction (line 552)
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.08 ms
(4.53%)

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_5db3ffb3782d43ff69be47d3c34edc6b->doDisplay (line 54)
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->viewsAction (line 552)
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)

0.77 ms
(3.21%)

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.59 ms
(2.47%)

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.31 ms
(1.29%)

SELECT t0.id AS id_1, t0.creationdate AS creationdate_2, t0.updatedate AS updatedate_3, t0.rang AS rang_4, t0.contentpage_id AS contentpage_id_5, t0.contentsection_id AS contentsection_id_6 FROM page_section t0 WHERE t0.contentpage_id = ? ORDER BY t0.rang ASC

Parameters:

[
  12428
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.creationdate AS creationdate_2,
  t0.updatedate AS updatedate_3,
  t0.rang AS rang_4,
  t0.contentpage_id AS contentpage_id_5,
  t0.contentsection_id AS contentsection_id_6
FROM
  page_section t0
WHERE
  t0.contentpage_id = ?
ORDER BY
  t0.rang ASC

SELECT t0.id AS id_1, t0.creationdate AS creationdate_2, t0.updatedate AS updatedate_3, t0.rang AS rang_4, t0.contentpage_id AS contentpage_id_5, t0.contentsection_id AS contentsection_id_6 FROM page_section t0 WHERE t0.contentpage_id = 12428 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\Controller\IndexController->viewsAction (line 535)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.27 ms
(1.14%)

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.path = ? AND t0.publication = ? LIMIT 1

Parameters:

[
  "l-action-de-formation-conventionnee"
  1
]

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.path = ?
  AND t0.publication = ?
LIMIT
  1

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.path = 'l-action-de-formation-conventionnee' AND t0.publication = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\IndexController->viewsAction (line 519)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.18 ms
(0.74%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.archive AS archive_3, t0.creationdate AS creationdate_4, t0.updatedate AS updatedate_5, t0.keyword AS keyword_6, t0.description AS description_7, t0.robots AS robots_8, t9.id AS id_10, t9.title AS title_11, t9.type AS type_12, t9.archive AS archive_13, t9.titlepage AS titlepage_14, t9.link AS link_15, t9.path AS path_16, t9.shortdescription AS shortdescription_17, t9.content AS content_18, t9.rang AS rang_19, t9.layout AS layout_20, t9.visible AS visible_21, t9.publication AS publication_22, t9.creationdate AS creationdate_23, t9.updatedate AS updatedate_24, t9.index_entity_type AS index_entity_type_25, t9.index_entity_id AS index_entity_id_26, t9.icon AS icon_27, t9.color AS color_28, t9.intitule_plus AS intitule_plus_29, t9.colorheader AS colorheader_30, t9.colorleft AS colorleft_31, t9.colorcontent AS colorcontent_32, t9.colorfooter AS colorfooter_33, t9.typeformation_id AS typeformation_id_34, t9.contentseo AS contentseo_35, t9.contentslider AS contentslider_36, t9.contenttemplate_id AS contenttemplate_id_37, t9.parent AS parent_38, t9.typepage_id AS typepage_id_39 FROM content_seo t0 LEFT JOIN content_page t9 ON t9.contentseo = t0.id WHERE t0.id = ?

Parameters:

[
  16406
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.archive AS archive_3,
  t0.creationdate AS creationdate_4,
  t0.updatedate AS updatedate_5,
  t0.keyword AS keyword_6,
  t0.description AS description_7,
  t0.robots AS robots_8,
  t9.id AS id_10,
  t9.title AS title_11,
  t9.type AS type_12,
  t9.archive AS archive_13,
  t9.titlepage AS titlepage_14,
  t9.link AS link_15,
  t9.path AS path_16,
  t9.shortdescription AS shortdescription_17,
  t9.content AS content_18,
  t9.rang AS rang_19,
  t9.layout AS layout_20,
  t9.visible AS visible_21,
  t9.publication AS publication_22,
  t9.creationdate AS creationdate_23,
  t9.updatedate AS updatedate_24,
  t9.index_entity_type AS index_entity_type_25,
  t9.index_entity_id AS index_entity_id_26,
  t9.icon AS icon_27,
  t9.color AS color_28,
  t9.intitule_plus AS intitule_plus_29,
  t9.colorheader AS colorheader_30,
  t9.colorleft AS colorleft_31,
  t9.colorcontent AS colorcontent_32,
  t9.colorfooter AS colorfooter_33,
  t9.typeformation_id AS typeformation_id_34,
  t9.contentseo AS contentseo_35,
  t9.contentslider AS contentslider_36,
  t9.contenttemplate_id AS contenttemplate_id_37,
  t9.parent AS parent_38,
  t9.typepage_id AS typepage_id_39
FROM
  content_seo t0
  LEFT JOIN content_page t9 ON t9.contentseo = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.archive AS archive_3, t0.creationdate AS creationdate_4, t0.updatedate AS updatedate_5, t0.keyword AS keyword_6, t0.description AS description_7, t0.robots AS robots_8, t9.id AS id_10, t9.title AS title_11, t9.type AS type_12, t9.archive AS archive_13, t9.titlepage AS titlepage_14, t9.link AS link_15, t9.path AS path_16, t9.shortdescription AS shortdescription_17, t9.content AS content_18, t9.rang AS rang_19, t9.layout AS layout_20, t9.visible AS visible_21, t9.publication AS publication_22, t9.creationdate AS creationdate_23, t9.updatedate AS updatedate_24, t9.index_entity_type AS index_entity_type_25, t9.index_entity_id AS index_entity_id_26, t9.icon AS icon_27, t9.color AS color_28, t9.intitule_plus AS intitule_plus_29, t9.colorheader AS colorheader_30, t9.colorleft AS colorleft_31, t9.colorcontent AS colorcontent_32, t9.colorfooter AS colorfooter_33, t9.typeformation_id AS typeformation_id_34, t9.contentseo AS contentseo_35, t9.contentslider AS contentslider_36, t9.contenttemplate_id AS contenttemplate_id_37, t9.parent AS parent_38, t9.typepage_id AS typepage_id_39 FROM content_seo t0 LEFT JOIN content_page t9 ON t9.contentseo = t0.id WHERE t0.id = 16406;

#	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\ContentSeo::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\ContentSeo->__get (line 153)
7	App\Entity\ContentSeo->getTitle (line 57)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_80a9523a808e34df4e88bdc4015e252a::doDisplay (line 59)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_5db3ffb3782d43ff69be47d3c34edc6b->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	App\Controller\IndexController->viewsAction (line 552)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.13 ms
(0.56%)

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_5db3ffb3782d43ff69be47d3c34edc6b->doDisplay (line 54)
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->viewsAction (line 552)
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)

0.09 ms
(0.36%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.valeur AS valeur_3, t0.valeur2 AS valeur2_4, t0.valeur3 AS valeur3_5, t0.htmlvaleur AS htmlvaleur_6, t0.designation AS designation_7, t0.masterliste_id AS masterliste_id_8 FROM masterlistelgs t0 WHERE t0.id = ?

Parameters:

[
  3442
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.valeur AS valeur_3,
  t0.valeur2 AS valeur2_4,
  t0.valeur3 AS valeur3_5,
  t0.htmlvaleur AS htmlvaleur_6,
  t0.designation AS designation_7,
  t0.masterliste_id AS masterliste_id_8
FROM
  masterlistelgs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.valeur AS valeur_3, t0.valeur2 AS valeur2_4, t0.valeur3 AS valeur3_5, t0.htmlvaleur AS htmlvaleur_6, t0.designation AS designation_7, t0.masterliste_id AS masterliste_id_8 FROM masterlistelgs t0 WHERE t0.id = 3442;

#	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\Masterlistelg::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Masterlistelg->__get (line 153)
7	App\Entity\Masterlistelg->getCode (line 60)
8	App\Controller\ContentController->contentPageCms (line 65)
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_5db3ffb3782d43ff69be47d3c34edc6b->block_content (line 111)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_80a9523a808e34df4e88bdc4015e252a->doDisplay (line 630)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_5db3ffb3782d43ff69be47d3c34edc6b->doDisplay (line 54)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
29	App\Controller\IndexController->viewsAction (line 552)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

0.07 ms
(0.31%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.color AS color_4, t0.archive AS archive_5, t0.updatedate AS updatedate_6, t0.creationdate AS creationdate_7 FROM statistic 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.number AS number_3,
  t0.color AS color_4,
  t0.archive AS archive_5,
  t0.updatedate AS updatedate_6,
  t0.creationdate AS creationdate_7
FROM
  statistic t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.color AS color_4, t0.archive AS archive_5, t0.updatedate AS updatedate_6, t0.creationdate AS creationdate_7 FROM statistic 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->contentPageCms (line 56)
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_5db3ffb3782d43ff69be47d3c34edc6b->block_content (line 111)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_80a9523a808e34df4e88bdc4015e252a->doDisplay (line 630)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_5db3ffb3782d43ff69be47d3c34edc6b->doDisplay (line 54)
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->viewsAction (line 552)
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)

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\Statistic	6
App\Entity\Menu	3
App\Entity\Masterliste	1

Entities Mapping

Class	Mapping errors
App\Entity\Masterlistelg	No errors.
App\Entity\Masterliste	No errors.
App\Entity\ThemeSettings	No errors.
App\Entity\ContentPage	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\ContentSlider	No errors.
App\Entity\MenuContentPage	No errors.
App\Entity\PageSection	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\Menu	No errors.
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\SocialSettings	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://site.simplyform.lmosoft.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CContentController%253A%253Afooter

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping