Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

2.00 ms Query time

3 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.00 ms
(50.22%)

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	ContainerTvKoxnv\getFrontServiceService->do (line 23)
9	ContainerTvKoxnv\App_KernelDevDebugContainer::load (line 540)
10	ContainerTvKoxnv\getIndexControllerService->do (line 24)
11	ContainerTvKoxnv\App_KernelDevDebugContainer::load (line 540)
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.61 ms
(30.32%)

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 887)
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.39 ms
(19.46%)

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 45)
6	ContainerTvKoxnv\getIndexControllerService->do (line 24)
7	ContainerTvKoxnv\App_KernelDevDebugContainer::load (line 540)
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)

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	2

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\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\ContentSection	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\SocialSettings	No errors.
App\Entity\Statistic	No errors.
App\Entity\Testimony	No errors.
App\Entity\User	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://competences.simplyform-saas.fr/l-action-de-formation-conventionnee

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping