Symfony Profiler

Query Metrics

15 Database Queries

3 Different statements

2.37 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.47 ms
(61.91%)

SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))

Parameters:

[
  null
  "REC_GEST"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.profil_id AS profil_id_1,
  h0_.module AS module_2
FROM
  habilitation_profil_module h0_
  INNER JOIN utilisateur u1_
WHERE
  h0_.profil_id = u1_.profil_id
  AND (
    (u1_.id = ?)
    AND (h0_.module = ?)
  )

SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = NULL) AND (h0_.module = 'REC_GEST'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 166)
7	App\Repository\HabilitationprofilmoduleRepository->estHabilite (line 1909)
8	Twig\Extension\CoreExtension::getAttribute (line 107)
9	__TwigTemplate_f559228ad2f49959d94b8d96669ea5f9->doDisplay (line 402)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_9e51d987fc7f726b098628bfa47b54b7->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 95)
20	App\Controller\AideController->apropos (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 7)

0.81 ms
(34.10%)

SELECT t0.id AS id_1, t0.abrege AS abrege_2, t0.intitule AS intitule_3, t0.type_abonnement AS type_abonnement_4, t0.tarif AS tarif_5 FROM forfait t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.abrege AS abrege_2,
  t0.intitule AS intitule_3,
  t0.type_abonnement AS type_abonnement_4,
  t0.tarif AS tarif_5
FROM
  forfait t0

SELECT t0.id AS id_1, t0.abrege AS abrege_2, t0.intitule AS intitule_3, t0.type_abonnement AS type_abonnement_4, t0.tarif AS tarif_5 FROM forfait t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 91)
6	App\Controller\AideController->apropos (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 7)

0.09 ms
(3.99%)

SELECT t0.id AS id_1, t0.date_livraison AS date_livraison_2, t0.numero_version AS numero_version_3, t0.description AS description_4 FROM version t0 ORDER BY t0.date_livraison DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_livraison AS date_livraison_2,
  t0.numero_version AS numero_version_3,
  t0.description AS description_4
FROM
  version t0
ORDER BY
  t0.date_livraison DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.date_livraison AS date_livraison_2, t0.numero_version AS numero_version_3, t0.description AS description_4 FROM version t0 ORDER BY t0.date_livraison DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 157)
5	App\Repository\VersionRepository->obtenirLaderniereversion (line 1909)
6	Twig\Extension\CoreExtension::getAttribute (line 102)
7	__TwigTemplate_9e51d987fc7f726b098628bfa47b54b7->block_contenu (line 446)
8	Twig\Template->yieldBlock (line 476)
9	__TwigTemplate_f559228ad2f49959d94b8d96669ea5f9->doDisplay (line 402)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_9e51d987fc7f726b098628bfa47b54b7->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 95)
20	App\Controller\AideController->apropos (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 7)

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\Forfait	3
App\Entity\Version	1

Entities Mapping

Class	Mapping errors
App\Entity\Forfait	No errors.
App\Entity\Societe	No errors.
App\Entity\Forfaitmodule	No errors.
App\Entity\Module	No errors.
App\Entity\Parametres	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\Version	No errors.
App\Entity\Devisemonetaire	No errors.
App\Entity\Habilitationprofilmodule	No errors.

Symfony Profiler

GET https://facture.mayexperinfo.com/aide/apropos

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping