Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

16.22 ms Query time

0 Invalid entities

7 Managed entities

Queries

Group similar statements

#▲

Time

Info

15.35 ms

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.42 ms

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.44 ms

SELECT COALESCE(SUM(p0_.valeur), 0) AS sclr_0 FROM prix p0_ LEFT JOIN service s1_ ON p0_.service_id = s1_.id LEFT JOIN `user` u2_ ON s1_.id = u2_.service_id WHERE u2_.id = ? AND p0_.charge_id = ?

Parameters:

[
  "209"
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COALESCE(
    SUM(p0_.valeur),
    0
  ) AS sclr_0
FROM
  prix p0_
  LEFT JOIN service s1_ ON p0_.service_id = s1_.id
  LEFT JOIN `user` u2_ ON s1_.id = u2_.service_id
WHERE
  u2_.id = ?
  AND p0_.charge_id = ?

SELECT COALESCE(SUM(p0_.valeur), 0) AS sclr_0 FROM prix p0_ LEFT JOIN service s1_ ON p0_.service_id = s1_.id LEFT JOIN `user` u2_ ON s1_.id = u2_.service_id WHERE u2_.id = '209' AND p0_.charge_id = '1';

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 55)
8	App\Repository\PrixRepository->findPriceForParticipantAndCharge (line 161)
9	App\Controller\PriceController->getPrice (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 31)
13	{closure} (line 25)
14	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
15	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\Permission	4
App\Entity\User	1
App\Entity\Service	1
App\Entity\Departement	1

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/api/price?charge=1&titulaire=209

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping