Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.01 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.41 ms

SELECT id, code FROM langue WHERE actif = 1 and (supprime = 0 or supprime IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  code
FROM
  langue
WHERE
  actif = 1
  and (
    supprime = 0
    or supprime IS NULL
  )

SELECT id, code FROM langue WHERE actif = 1 and (supprime = 0 or supprime IS NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 195)
3	App\Controller\DefaultController->__construct (line 24)
4	Container8rgGi2Y\getDefaultControllerService::do (line 547)
5	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 229)
6	Symfony\Component\DependencyInjection\Container::make (line 211)
7	Symfony\Component\DependencyInjection\Container->get (line 40)
8	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
9	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
10	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
11	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
12	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.15 ms

SELECT versionapp, DATE_FORMAT(datemajversion, '%d/%m/%Y %H:%i') AS datemajversion FROM parametre WHERE (supprime = 0 or supprime IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  versionapp,
  DATE_FORMAT(
    datemajversion, '%d/%m/%Y %H:%i'
  ) AS datemajversion
FROM
  parametre
WHERE
  (
    supprime = 0
    or supprime IS NULL
  )

SELECT versionapp, DATE_FORMAT(datemajversion, '%d/%m/%Y %H:%i') AS datemajversion FROM parametre WHERE (supprime = 0 or supprime IS NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 226)
3	App\Controller\DefaultController->__construct (line 24)
4	Container8rgGi2Y\getDefaultControllerService::do (line 547)
5	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 229)
6	Symfony\Component\DependencyInjection\Container::make (line 211)
7	Symfony\Component\DependencyInjection\Container->get (line 40)
8	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
9	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
10	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
11	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
12	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.45 ms

SELECT t0.id AS id_1, t0.lib AS lib_2, t0.chemin AS chemin_3, t0.visuel_encode AS visuel_encode_4, t0.usermaj AS usermaj_5, t0.datemajutc AS datemajutc_6, t0.supprime AS supprime_7, t0.idgestion AS idgestion_8, t0.idmaitre AS idmaitre_9, t0.idrelay AS idrelay_10 FROM visuel t0 WHERE t0.lib = ? LIMIT 1

Parameters:

[
  "logo_sagim"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lib AS lib_2,
  t0.chemin AS chemin_3,
  t0.visuel_encode AS visuel_encode_4,
  t0.usermaj AS usermaj_5,
  t0.datemajutc AS datemajutc_6,
  t0.supprime AS supprime_7,
  t0.idgestion AS idgestion_8,
  t0.idmaitre AS idmaitre_9,
  t0.idrelay AS idrelay_10
FROM
  visuel t0
WHERE
  t0.lib = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lib AS lib_2, t0.chemin AS chemin_3, t0.visuel_encode AS visuel_encode_4, t0.usermaj AS usermaj_5, t0.datemajutc AS datemajutc_6, t0.supprime AS supprime_7, t0.idgestion AS idgestion_8, t0.idmaitre AS idmaitre_9, t0.idrelay AS idrelay_10 FROM visuel t0 WHERE t0.lib = 'logo_sagim' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 20)
4	App\Twig\AppExtension->getGlobals (line 359)
5	Twig\ExtensionSet->getGlobals (line 900)
6	Twig\Environment->getGlobals (line 398)
7	Twig\Template->yield (line 358)
8	Twig\Template->display (line 373)
9	Twig\Template->render (line 51)
10	Twig\TemplateWrapper->render (line 333)
11	Twig\Environment->render (line 448)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 337)
15	App\Controller\DefaultController->login (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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\Visuel	1

Entities Mapping

Class	Mapping errors
App\Entity\Visuel	No errors.

Symfony Profiler

GET https://gipv3-gestion.qosinus.com/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping