Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

1.18 ms Query time

0 Invalid entities

63 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.53 ms
(45.18%)

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.47 ms
(39.99%)

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.17 ms
(14.83%)

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)

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

Entities Mapping

Class	Mapping errors
App\Entity\Masterlistelg	No errors.
App\Entity\Masterliste	No errors.
App\Entity\ThemeSettings	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping