Symfony Profiler

Query Metrics

15 Database Queries

9 Different statements

1.90 ms Query time

6 Invalid entities

22 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.57 ms
(29.91%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_iso AS code_iso_3, t0.symbole AS symbole_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6 FROM devise t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code_iso AS code_iso_3,
  t0.symbole AS symbole_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6
FROM
  devise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_iso AS code_iso_3, t0.symbole AS symbole_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6 FROM devise t0 WHERE t0.id = 1;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Devise::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Devise->__get (line 167)
8	App\Entity\Devise->getNom (line 67)
9	App\Mapper\ProfilClientMapper->mapDevise (line 48)
10	App\Mapper\ProfilClientMapper->App\Mapper\{closure} (line 1)
11	array_map (line 45)
12	App\Mapper\ProfilClientMapper->toDto (line 1)
13	array_map (line 62)
14	App\Mapper\ProfilClientMapper->toDtoList (line 33)
15	App\Mapper\ClientMapper->toDto (line 292)
16	App\Controller\ClientController->show (line 183)
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 6)

0.31 ms
(16.10%)

SELECT t0.id AS id_1, t0.solde_initial AS solde_initial_2, t0.solde_actuel AS solde_actuel_3, t0.created_at AS created_at_4, t0.devise_id AS devise_id_5, t0.profil_client_id AS profil_client_id_6 FROM compte_client t0 WHERE t0.profil_client_id = ?

Parameters:

[
  66
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.solde_initial AS solde_initial_2,
  t0.solde_actuel AS solde_actuel_3,
  t0.created_at AS created_at_4,
  t0.devise_id AS devise_id_5,
  t0.profil_client_id AS profil_client_id_6
FROM
  compte_client t0
WHERE
  t0.profil_client_id = ?

SELECT t0.id AS id_1, t0.solde_initial AS solde_initial_2, t0.solde_actuel AS solde_actuel_3, t0.created_at AS created_at_4, t0.devise_id AS devise_id_5, t0.profil_client_id AS profil_client_id_6 FROM compte_client t0 WHERE t0.profil_client_id = 66;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
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 53)
8	App\Mapper\ProfilClientMapper->toDto (line 1)
9	array_map (line 62)
10	App\Mapper\ProfilClientMapper->toDtoList (line 33)
11	App\Mapper\ClientMapper->toDto (line 292)
12	App\Controller\ClientController->show (line 183)
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.27 ms
(14.10%)

DELETE FROM user_sessions WHERE last_activity < ?

Parameters:

[
  "2026-07-31 12:47:34"
]

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:47:34';

#	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.23 ms
(12.11%)

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:

[
  "zantoinette@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 = 'zantoinette@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.14 ms
(7.21%)

SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.is_active AS is_active_2, a0_.is_appro_initial_valide AS is_appro_initial_valide_3, a0_.date_fin AS date_fin_4, a0_.caissier_id AS caissier_id_5, a0_.caisse_id AS caisse_id_6 FROM affectation_caisse a0_ WHERE a0_.caissier_id = ? AND a0_.is_active = ? AND a0_.date_debut <= ? AND (a0_.date_fin IS NULL OR a0_.date_fin >= ?) ORDER BY a0_.date_debut DESC LIMIT 1

Parameters:

[
  20
  1
  "2026-07-31 13:02:34"
  "2026-07-31 13:02:34"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.date_debut AS date_debut_1,
  a0_.is_active AS is_active_2,
  a0_.is_appro_initial_valide AS is_appro_initial_valide_3,
  a0_.date_fin AS date_fin_4,
  a0_.caissier_id AS caissier_id_5,
  a0_.caisse_id AS caisse_id_6
FROM
  affectation_caisse a0_
WHERE
  a0_.caissier_id = ?
  AND a0_.is_active = ?
  AND a0_.date_debut <= ?
  AND (
    a0_.date_fin IS NULL
    OR a0_.date_fin >= ?
  )
ORDER BY
  a0_.date_debut DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.is_active AS is_active_2, a0_.is_appro_initial_valide AS is_appro_initial_valide_3, a0_.date_fin AS date_fin_4, a0_.caissier_id AS caissier_id_5, a0_.caisse_id AS caisse_id_6 FROM affectation_caisse a0_ WHERE a0_.caissier_id = 20 AND a0_.is_active = 1 AND a0_.date_debut <= '2026-07-31 13:02:34' AND (a0_.date_fin IS NULL OR a0_.date_fin >= '2026-07-31 13:02:34') ORDER BY a0_.date_debut DESC LIMIT 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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 49)
7	App\Repository\AffectationCaisseRepository->findActiveAffectationForUser (line 39)
8	App\Security\UserChecker->checkPreAuth (line 40)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 6)

0.11 ms
(5.57%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.contact AS contact_4, t0.email AS email_5, t0.registre_commerce AS registre_commerce_6, t0.profession AS profession_7, t0.created_at AS created_at_8, t0.ifu AS ifu_9, t0.code_client AS code_client_10, t0.created_by_id AS created_by_id_11, t0.agence_id AS agence_id_12, t0.user_id AS user_id_13 FROM client t0 WHERE t0.id = ?

Parameters:

[
  "66"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.contact AS contact_4,
  t0.email AS email_5,
  t0.registre_commerce AS registre_commerce_6,
  t0.profession AS profession_7,
  t0.created_at AS created_at_8,
  t0.ifu AS ifu_9,
  t0.code_client AS code_client_10,
  t0.created_by_id AS created_by_id_11,
  t0.agence_id AS agence_id_12,
  t0.user_id AS user_id_13
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.contact AS contact_4, t0.email AS email_5, t0.registre_commerce AS registre_commerce_6, t0.profession AS profession_7, t0.created_at AS created_at_8, t0.ifu AS ifu_9, t0.code_client AS code_client_10, t0.created_by_id AS created_by_id_11, t0.agence_id AS agence_id_12, t0.user_id AS user_id_13 FROM client t0 WHERE t0.id = '66';

#	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 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 6)

0.10 ms
(5.21%)

SELECT t0.id AS id_1, t0.montant_principal AS montant_principal_2, t0.montant_restant AS montant_restant_3, t0.taux_interet_annuel AS taux_interet_annuel_4, t0.duree_mois AS duree_mois_5, t0.date_echeance AS date_echeance_6, t0.contrat_signe AS contrat_signe_7, t0.montant_total_rembourse AS montant_total_rembourse_8, t0.statut AS statut_9, t0.commentaire AS commentaire_10, t0.created_at AS created_at_11, t0.profil_client_id AS profil_client_id_12, t0.devise_id AS devise_id_13, t0.agent_octroi_id AS agent_octroi_id_14, t0.agence_id AS agence_id_15, t0.caisse_id AS caisse_id_16 FROM pret t0 WHERE t0.profil_client_id = ?

Parameters:

[
  66
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.montant_principal AS montant_principal_2,
  t0.montant_restant AS montant_restant_3,
  t0.taux_interet_annuel AS taux_interet_annuel_4,
  t0.duree_mois AS duree_mois_5,
  t0.date_echeance AS date_echeance_6,
  t0.contrat_signe AS contrat_signe_7,
  t0.montant_total_rembourse AS montant_total_rembourse_8,
  t0.statut AS statut_9,
  t0.commentaire AS commentaire_10,
  t0.created_at AS created_at_11,
  t0.profil_client_id AS profil_client_id_12,
  t0.devise_id AS devise_id_13,
  t0.agent_octroi_id AS agent_octroi_id_14,
  t0.agence_id AS agence_id_15,
  t0.caisse_id AS caisse_id_16
FROM
  pret t0
WHERE
  t0.profil_client_id = ?

SELECT t0.id AS id_1, t0.montant_principal AS montant_principal_2, t0.montant_restant AS montant_restant_3, t0.taux_interet_annuel AS taux_interet_annuel_4, t0.duree_mois AS duree_mois_5, t0.date_echeance AS date_echeance_6, t0.contrat_signe AS contrat_signe_7, t0.montant_total_rembourse AS montant_total_rembourse_8, t0.statut AS statut_9, t0.commentaire AS commentaire_10, t0.created_at AS created_at_11, t0.profil_client_id AS profil_client_id_12, t0.devise_id AS devise_id_13, t0.agent_octroi_id AS agent_octroi_id_14, t0.agence_id AS agence_id_15, t0.caisse_id AS caisse_id_16 FROM pret t0 WHERE t0.profil_client_id = 66;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 57)
8	App\Mapper\PretMapper->toDtoList (line 55)
9	App\Mapper\ProfilClientMapper->toDto (line 1)
10	array_map (line 62)
11	App\Mapper\ProfilClientMapper->toDtoList (line 33)
12	App\Mapper\ClientMapper->toDto (line 292)
13	App\Controller\ClientController->show (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 6)

0.10 ms
(5.11%)

SELECT t0.id AS id_1, t0.numero_profil_compte AS numero_profil_compte_2, t0.is_actif AS is_actif_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.client_id AS client_id_6, t0.type_client_id AS type_client_id_7 FROM profil_client t0 WHERE t0.client_id = ?

Parameters:

[
  66
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero_profil_compte AS numero_profil_compte_2,
  t0.is_actif AS is_actif_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.client_id AS client_id_6,
  t0.type_client_id AS type_client_id_7
FROM
  profil_client t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.numero_profil_compte AS numero_profil_compte_2, t0.is_actif AS is_actif_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.client_id AS client_id_6, t0.type_client_id AS type_client_id_7 FROM profil_client t0 WHERE t0.client_id = 66;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 62)
8	App\Mapper\ProfilClientMapper->toDtoList (line 33)
9	App\Mapper\ClientMapper->toDto (line 292)
10	App\Controller\ClientController->show (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 6)

0.09 ms
(4.68%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_client t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  type_client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_client t0 WHERE t0.id = 1;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\TypeClient::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\TypeClient->__get (line 43)
8	App\Entity\TypeClient->getLibelle (line 40)
9	App\Mapper\ProfilClientMapper->toDto (line 1)
10	array_map (line 62)
11	App\Mapper\ProfilClientMapper->toDtoList (line 33)
12	App\Mapper\ClientMapper->toDto (line 292)
13	App\Controller\ClientController->show (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\CompteClient	7
App\Entity\Devise	7
App\Entity\User	2
App\Entity\Agence	1
App\Entity\AffectationCaisse	1
App\Entity\Caisse	1
App\Entity\Client	1
App\Entity\ProfilClient	1
App\Entity\TypeClient	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\Caisse	No errors.
App\Entity\UserSession	No errors.
App\Entity\ClientDocument	No errors.
App\Entity\ProfilClient	No errors.
App\Entity\TypeClient	No errors.
App\Entity\CompteClient	No errors.
App\Entity\Beneficiaire	No errors.
App\Entity\Devise	The field App\Entity\Devise#lignes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LigneDepense#devise does not contain the required 'inversedBy="lignes"' attribute.
App\Entity\CompteCaisse	No errors.
App\Entity\CompteAgence	The field App\Entity\CompteAgence#lignesDepenses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LigneDepense#compteAgence does not contain the required 'inversedBy="lignesDepenses"' attribute.
App\Entity\CompteGeneral	No errors.
App\Entity\Banque	No errors.
App\Entity\ApproCompteBancaire	No errors.
App\Entity\TauxChange	The mappings App\Entity\TauxChange#deviseCible and App\Entity\Devise#tauxChanges are inconsistent with each other.
App\Entity\LigneDepense	No errors.

Symfony Profiler

GET https://app.retouralasourcefx.com/api/clients/66

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping