Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.67 ms Query time

3 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.29 ms
(43.99%)

DELETE FROM user_sessions WHERE last_activity < ?

Parameters:

[
  "2026-07-31 12:44:51"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  user_sessions
WHERE
  last_activity < ?

DELETE FROM user_sessions WHERE last_activity < '2026-07-31 12:44:51';

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 38)
2	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 95)
6	App\Repository\UserSessionRepository->cleanupOldSessions (line 118)
7	App\Service\UserSessionService->cleanupOldSessions (line 28)
8	App\EventListener\SessionExpirationListener->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 6)

0.26 ms
(38.90%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenoms AS prenoms_4, t0.telephone AS telephone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.is_email_auth_enabled AS is_email_auth_enabled_9, t0.is_sms_auth_enabled AS is_sms_auth_enabled_10, t0.auth_code AS auth_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.avatar AS avatar_14, t0.push_token AS push_token_15, t0.push_subscription AS push_subscription_16, t0.must_change_password AS must_change_password_17, t0.agence_id AS agence_id_18, t0.service_transfert_id AS service_transfert_id_19, t20.id AS id_21, t20.nom AS nom_22, t20.prenoms AS prenoms_23, t20.contact AS contact_24, t20.email AS email_25, t20.registre_commerce AS registre_commerce_26, t20.profession AS profession_27, t20.created_at AS created_at_28, t20.ifu AS ifu_29, t20.code_client AS code_client_30, t20.created_by_id AS created_by_id_31, t20.agence_id AS agence_id_32, t20.user_id AS user_id_33 FROM user t0 LEFT JOIN client t20 ON t20.user_id = t0.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "ojosephine@retouralasourcefx.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenoms AS prenoms_4,
  t0.telephone AS telephone_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.is_active AS is_active_8,
  t0.is_email_auth_enabled AS is_email_auth_enabled_9,
  t0.is_sms_auth_enabled AS is_sms_auth_enabled_10,
  t0.auth_code AS auth_code_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.avatar AS avatar_14,
  t0.push_token AS push_token_15,
  t0.push_subscription AS push_subscription_16,
  t0.must_change_password AS must_change_password_17,
  t0.agence_id AS agence_id_18,
  t0.service_transfert_id AS service_transfert_id_19,
  t20.id AS id_21,
  t20.nom AS nom_22,
  t20.prenoms AS prenoms_23,
  t20.contact AS contact_24,
  t20.email AS email_25,
  t20.registre_commerce AS registre_commerce_26,
  t20.profession AS profession_27,
  t20.created_at AS created_at_28,
  t20.ifu AS ifu_29,
  t20.code_client AS code_client_30,
  t20.created_by_id AS created_by_id_31,
  t20.agence_id AS agence_id_32,
  t20.user_id AS user_id_33
FROM
  user t0
  LEFT JOIN client t20 ON t20.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenoms AS prenoms_4, t0.telephone AS telephone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.is_email_auth_enabled AS is_email_auth_enabled_9, t0.is_sms_auth_enabled AS is_sms_auth_enabled_10, t0.auth_code AS auth_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.avatar AS avatar_14, t0.push_token AS push_token_15, t0.push_subscription AS push_subscription_16, t0.must_change_password AS must_change_password_17, t0.agence_id AS agence_id_18, t0.service_transfert_id AS service_transfert_id_19, t20.id AS id_21, t20.nom AS nom_22, t20.prenoms AS prenoms_23, t20.contact AS contact_24, t20.email AS email_25, t20.registre_commerce AS registre_commerce_26, t20.profession AS profession_27, t20.created_at AS created_at_28, t20.ifu AS ifu_29, t20.code_client AS code_client_30, t20.created_by_id AS created_by_id_31, t20.agence_id AS agence_id_32, t20.user_id AS user_id_33 FROM user t0 LEFT JOIN client t20 ON t20.user_id = t0.id WHERE t0.email = 'ojosephine@retouralasourcefx.com' 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 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 29)
5	App\Security\UserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 101)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 6)

0.11 ms
(17.11%)

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.destinataire_id = ? AND n0_.lu = 0

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notification n0_
WHERE
  n0_.destinataire_id = ?
  AND n0_.lu = 0

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.destinataire_id = 21 AND n0_.lu = 0;

#	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 38)
8	App\Repository\NotificationRepository->countUnreadForUser (line 47)
9	App\Controller\NotificationController->unreadCount (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 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 6)

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\User	1
App\Entity\Agence	1

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\User	No errors.
App\Entity\Agence	No errors.
App\Entity\ServiceTransfert	No errors.
App\Entity\Client	No errors.
App\Entity\AffectationAgence	No errors.
App\Entity\ApproAgence	The mappings App\Entity\ApproAgence#validePar and App\Entity\User#approAgences are inconsistent with each other.
App\Entity\ApproCaisse	No errors.
App\Entity\ApproCompteGeneral	No errors.
App\Entity\MouvementCaisse	No errors.
App\Entity\MouvementCompteBancaire	No errors.
App\Entity\MouvementCompteClient	No errors.
App\Entity\Operation	The mappings App\Entity\Operation#deviseCible and App\Entity\Devise#operations are inconsistent with each other. The field App\Entity\Operation#mouvementCaisses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MouvementCaisse#operation does not contain the required 'inversedBy="mouvementCaisses"' attribute. The field App\Entity\Operation#mouvementBancaires is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MouvementCompteBancaire#operation does not contain the required 'inversedBy="mouvementBancaires"' attribute. The field App\Entity\Operation#mouvementCompteClients is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MouvementCompteClient#operation does not contain the required 'inversedBy="mouvementCompteClients"' attribute.
App\Entity\AffectationCaisse	No errors.
App\Entity\Pret	The association App\Entity\Pret#agence refers to the inverse side field App\Entity\Agence#prets which does not exist. The association App\Entity\Pret#caisse refers to the inverse side field App\Entity\Caisse#prets which does not exist.
App\Entity\Remboursement	No errors.
App\Entity\UserSession	No errors.
App\Entity\Notification	No errors.

Symfony Profiler

GET https://app.retouralasourcefx.com/api/notifications/unread-count

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping