Symfony Profiler

Query Metrics

11 Database Queries

6 Different statements

7.70 ms Query time

0 Invalid entities

47 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.03 ms
(39.31%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3
FROM
  departement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\Departement::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Departement->__get (line 45)
8	App\Entity\Departement->getNom (line 99)
9	App\Entity\Departement->__toString (line 126)
10	Twig\Runtime\EscaperRuntime->escape (line 144)
11	__TwigTemplate_59b6a49965450cab79cd94fde7d35737->block_body (line 446)
12	Twig\Template->yieldBlock (line 111)
13	__TwigTemplate_e0a65a267e3dfb150ca195ce14c6f2e2->doDisplay (line 402)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_59b6a49965450cab79cd94fde7d35737->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
24	App\Controller\UserController->show (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 31)
28	{closure} (line 25)
29	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
30	require_once (line 11)

1.97 ms
(25.64%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.plain_password AS plain_password_9, t0.enable AS enable_10, t0.deleted AS deleted_11, t0.birth_date AS birth_date_12, t0.birth_place AS birth_place_13, t0.cnps AS cnps_14, t0.embauche_date AS embauche_date_15, t0.renvoi_date AS renvoi_date_16, t0.signature_url AS signature_url_17, t0.initiale AS initiale_18, t0.signature_data AS signature_data_19, t0.signature_name AS signature_name_20, t0.signature_size AS signature_size_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.service_id AS service_id_24, t0.departement_id AS departement_id_25 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  163
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenoms AS prenoms_6,
  t0.telephone AS telephone_7,
  t0.fonction AS fonction_8,
  t0.plain_password AS plain_password_9,
  t0.enable AS enable_10,
  t0.deleted AS deleted_11,
  t0.birth_date AS birth_date_12,
  t0.birth_place AS birth_place_13,
  t0.cnps AS cnps_14,
  t0.embauche_date AS embauche_date_15,
  t0.renvoi_date AS renvoi_date_16,
  t0.signature_url AS signature_url_17,
  t0.initiale AS initiale_18,
  t0.signature_data AS signature_data_19,
  t0.signature_name AS signature_name_20,
  t0.signature_size AS signature_size_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.service_id AS service_id_24,
  t0.departement_id AS departement_id_25
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.plain_password AS plain_password_9, t0.enable AS enable_10, t0.deleted AS deleted_11, t0.birth_date AS birth_date_12, t0.birth_place AS birth_place_13, t0.cnps AS cnps_14, t0.embauche_date AS embauche_date_15, t0.renvoi_date AS renvoi_date_16, t0.signature_url AS signature_url_17, t0.initiale AS initiale_18, t0.signature_data AS signature_data_19, t0.signature_name AS signature_name_20, t0.signature_size AS signature_size_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.service_id AS service_id_24, t0.departement_id AS departement_id_25 FROM `user` t0 WHERE t0.id = 163;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 31)
21	{closure} (line 25)
22	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
23	require_once (line 11)

0.97 ms
(12.57%)

SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.link_to AS link_to_2, n0_.unread AS unread_3, n0_.permission AS permission_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.document_id AS document_id_7, n0_.owner_id AS owner_id_8, n0_.destinataire_id AS destinataire_id_9 FROM notification n0_ WHERE n0_.permission IN (?, ?, ?, ?, ?) AND n0_.unread = 1 ORDER BY n0_.created_at DESC

Parameters:

[
  "ROLE_ADMIN"
  "ROLE_DELIVERY"
  "ROLE_CANCEL"
  "ROLE_EMISSION"
  "ROLE_USER"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.message AS message_1,
  n0_.link_to AS link_to_2,
  n0_.unread AS unread_3,
  n0_.permission AS permission_4,
  n0_.created_at AS created_at_5,
  n0_.updated_at AS updated_at_6,
  n0_.document_id AS document_id_7,
  n0_.owner_id AS owner_id_8,
  n0_.destinataire_id AS destinataire_id_9
FROM
  notification n0_
WHERE
  n0_.permission IN (?, ?, ?, ?, ?)
  AND n0_.unread = 1
ORDER BY
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.link_to AS link_to_2, n0_.unread AS unread_3, n0_.permission AS permission_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.document_id AS document_id_7, n0_.owner_id AS owner_id_8, n0_.destinataire_id AS destinataire_id_9 FROM notification n0_ WHERE n0_.permission IN ('ROLE_ADMIN', 'ROLE_DELIVERY', 'ROLE_CANCEL', 'ROLE_EMISSION', 'ROLE_USER') AND n0_.unread = 1 ORDER BY n0_.created_at DESC;

#	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 61)
7	App\Repository\NotificationRepository->findAll (line 17)
8	App\Service\Notification->getNotifies (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 175)
10	__TwigTemplate_a5f0aad6a3c00b34a1bf04bfc050147a->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1520)
15	Twig\Extension\CoreExtension::include (line 92)
16	__TwigTemplate_e0a65a267e3dfb150ca195ce14c6f2e2->doDisplay (line 402)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_59b6a49965450cab79cd94fde7d35737->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
27	App\Controller\UserController->show (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 31)
31	{closure} (line 25)
32	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
33	require_once (line 11)

0.76 ms
(9.81%)

SELECT m0_.id AS id_0, m0_.commentaire AS commentaire_1, m0_.unread AS unread_2, m0_.link_to AS link_to_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.emissaire_id AS emissaire_id_6, m0_.destinataire_id AS destinataire_id_7, m0_.document_id AS document_id_8 FROM message m0_ WHERE m0_.destinataire_id = ? AND m0_.unread = 1 ORDER BY m0_.created_at DESC

Parameters:

[
  163
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.commentaire AS commentaire_1,
  m0_.unread AS unread_2,
  m0_.link_to AS link_to_3,
  m0_.created_at AS created_at_4,
  m0_.updated_at AS updated_at_5,
  m0_.emissaire_id AS emissaire_id_6,
  m0_.destinataire_id AS destinataire_id_7,
  m0_.document_id AS document_id_8
FROM
  message m0_
WHERE
  m0_.destinataire_id = ?
  AND m0_.unread = 1
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.commentaire AS commentaire_1, m0_.unread AS unread_2, m0_.link_to AS link_to_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.emissaire_id AS emissaire_id_6, m0_.destinataire_id AS destinataire_id_7, m0_.document_id AS document_id_8 FROM message m0_ WHERE m0_.destinataire_id = 163 AND m0_.unread = 1 ORDER BY m0_.created_at DESC;

#	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 56)
7	App\Repository\MessageRepository->findAll (line 15)
8	App\Service\Message->getMessages (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 178)
10	__TwigTemplate_a5f0aad6a3c00b34a1bf04bfc050147a->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1520)
15	Twig\Extension\CoreExtension::include (line 92)
16	__TwigTemplate_e0a65a267e3dfb150ca195ce14c6f2e2->doDisplay (line 402)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_59b6a49965450cab79cd94fde7d35737->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
27	App\Controller\UserController->show (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 31)
31	{closure} (line 25)
32	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
33	require_once (line 11)

0.72 ms
(9.28%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM permission t0 INNER JOIN permission_user ON t0.id = permission_user.permission_id WHERE permission_user.user_id = ?

Parameters:

[
  163
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3
FROM
  permission t0
  INNER JOIN permission_user ON t0.id = permission_user.permission_id
WHERE
  permission_user.user_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM permission t0 INNER JOIN permission_user ON t0.id = permission_user.permission_id WHERE permission_user.user_id = 163;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 274)
8	App\Entity\User->getRoles (line 318)
9	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 217)
10	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 31)
23	{closure} (line 25)
24	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
25	require_once (line 11)

0.26 ms
(3.39%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  service t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\Service::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Service->__get (line 54)
8	App\Entity\Service->getNom (line 138)
9	App\Entity\Service->__toString (line 126)
10	Twig\Runtime\EscaperRuntime->escape (line 140)
11	__TwigTemplate_59b6a49965450cab79cd94fde7d35737->block_body (line 446)
12	Twig\Template->yieldBlock (line 111)
13	__TwigTemplate_e0a65a267e3dfb150ca195ce14c6f2e2->doDisplay (line 402)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_59b6a49965450cab79cd94fde7d35737->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
24	App\Controller\UserController->show (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 31)
28	{closure} (line 25)
29	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
30	require_once (line 11)

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\Message	13
App\Entity\Document	11
App\Entity\Notification	8
App\Entity\User	5
App\Entity\Permission	4
App\Entity\Service	3
App\Entity\Departement	3

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Service	No errors.
App\Entity\Departement	No errors.
App\Entity\Document	No errors.
App\Entity\Permission	No errors.
App\Entity\Notification	No errors.
App\Entity\DetailItineraire	No errors.
App\Entity\Message	No errors.
App\Entity\Prix	No errors.

Symfony Profiler

GET https://www.logisport.pro/user/14/show

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping