Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

62.59 ms Query time

0 Invalid entities

69 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.57 ms
(26.46%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.login AS login_5,
  t0.password AS password_6,
  t0.auditeur AS auditeur_7,
  t0.formateur AS formateur_8,
  t0.etat AS etat_9,
  t0.image AS image_10,
  t0.create_at AS create_at_11,
  t0.create_by AS create_by_12,
  t0.comptable AS comptable_13,
  t0.informatique AS informatique_14,
  t0.commercial AS commercial_15,
  t0.hotline AS hotline_16,
  t0.direction AS direction_17,
  t0.administratif AS administratif_18,
  t0.telephone AS telephone_19,
  t0.id_rise_up AS id_rise_up_20,
  t0.superviseur_audit AS superviseur_audit_21,
  t0.initial AS initial_22,
  t0.fonction_id AS fonction_id_23,
  t0.FKUser AS FKUser_24
FROM
  bo_personnel_abs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

15.51 ms
(24.77%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.auditeur = ? AND t0.etat = ? ORDER BY t0.nom ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.login AS login_5,
  t0.password AS password_6,
  t0.auditeur AS auditeur_7,
  t0.formateur AS formateur_8,
  t0.etat AS etat_9,
  t0.image AS image_10,
  t0.create_at AS create_at_11,
  t0.create_by AS create_by_12,
  t0.comptable AS comptable_13,
  t0.informatique AS informatique_14,
  t0.commercial AS commercial_15,
  t0.hotline AS hotline_16,
  t0.direction AS direction_17,
  t0.administratif AS administratif_18,
  t0.telephone AS telephone_19,
  t0.id_rise_up AS id_rise_up_20,
  t0.superviseur_audit AS superviseur_audit_21,
  t0.initial AS initial_22,
  t0.fonction_id AS fonction_id_23,
  t0.FKUser AS FKUser_24
FROM
  bo_personnel_abs t0
WHERE
  t0.auditeur = ?
  AND t0.etat = ?
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.auditeur = 1 AND t0.etat = 1 ORDER BY t0.nom ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 1197)
4	App\Controller\ParameterController->gestionAudits (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

15.37 ms
(24.55%)

SELECT t0.IDAuditType AS IDAuditType_1, t0.LibelleAuditType AS LibelleAuditType_2, t0.VL AS VL_3, t0.PL AS PL_4, t0.CL AS CL_5, t0.Tarif AS Tarif_6, t0.Duree AS Duree_7, t0.DateHeureMajMYSQL AS DateHeureMajMYSQL_8 FROM t_audittype t0 ORDER BY t0.LibelleAuditType ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDAuditType AS IDAuditType_1,
  t0.LibelleAuditType AS LibelleAuditType_2,
  t0.VL AS VL_3,
  t0.PL AS PL_4,
  t0.CL AS CL_5,
  t0.Tarif AS Tarif_6,
  t0.Duree AS Duree_7,
  t0.DateHeureMajMYSQL AS DateHeureMajMYSQL_8
FROM
  t_audittype t0
ORDER BY
  t0.LibelleAuditType ASC

SELECT t0.IDAuditType AS IDAuditType_1, t0.LibelleAuditType AS LibelleAuditType_2, t0.VL AS VL_3, t0.PL AS PL_4, t0.CL AS CL_5, t0.Tarif AS Tarif_6, t0.Duree AS Duree_7, t0.DateHeureMajMYSQL AS DateHeureMajMYSQL_8 FROM t_audittype t0 ORDER BY t0.LibelleAuditType ASC;

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

15.15 ms
(24.21%)

SELECT DISTINCT type_centre FROM aut_audit WHERE type_centre IS NOT NULL AND type_centre != '' ORDER BY type_centre

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT type_centre
FROM
  aut_audit
WHERE
  type_centre IS NOT NULL
  AND type_centre != ''
ORDER BY
  type_centre

SELECT DISTINCT type_centre FROM aut_audit WHERE type_centre IS NOT NULL AND type_centre != '' ORDER BY type_centre;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1204)
2	App\Controller\ParameterController->gestionAudits (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	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\PersonnelAbs	20
App\Entity\TUser	20
App\Entity\TAudittype	20
App\Entity\FonctionAbs	9

Entities Mapping

Class	Mapping errors
App\Entity\PersonnelAbs	No errors.
App\Entity\FonctionAbs	No errors.
App\Entity\TUser	No errors.
App\Entity\DroitsAbs	No errors.
App\Entity\FormationSession	No errors.
App\Entity\TCentre	No errors.
App\Entity\TAudittype	No errors.

Symfony Profiler

GET https://mercure-qualite-web-test.autobilan-systems.com/admin/gestion_audits

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping