Symfony Profiler

Query Metrics

9 Database Queries

6 Different statements

19.58 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.30 ms
(32.18%)

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.email AS email_4, u0_.last_login AS last_login_5, u0_.firstname AS firstname_6, u0_.lastname AS lastname_7 FROM user u0_ WHERE u0_.username = ? OR u0_.email = ?

Parameters:

[
  "admin"
  "admin"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.email AS email_4,
  u0_.last_login AS last_login_5,
  u0_.firstname AS firstname_6,
  u0_.lastname AS lastname_7
FROM
  user u0_
WHERE
  u0_.username = ?
  OR u0_.email = ?

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.email AS email_4, u0_.last_login AS last_login_5, u0_.firstname AS firstname_6, u0_.lastname AS lastname_7 FROM user u0_ WHERE u0_.username = 'admin' OR u0_.email = 'admin';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\UserRepository->loadUserByIdentifier (line 25)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 62)
8	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
9	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->{closure:Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator::authenticate():105} (line 105)
10	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
11	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
12	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 182)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
20	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
21	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
22	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
31	Symfony\Component\HttpKernel\Kernel->handle (line 143)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 5)

5.86 ms
(29.91%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	Gesdinet\JWTRefreshTokenBundle\Doctrine\RefreshTokenManager->save (line 69)
4	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->authenticate (line 97)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

2.99 ms
(15.24%)

SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1

Parameters:

[
  "cd640ceb31a36d68073df8b916b882a034f9e902f34e667021439e86d7579248a27ef1f9def92c64040c8bd164fdb357eeaadaa8dc79a5e2e793f5ae6e86c48c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.refresh_token AS refresh_token_1,
  t0.username AS username_2,
  t0.valid AS valid_3,
  t0.id AS id_4
FROM
  refresh_tokens t0
WHERE
  t0.refresh_token = ?
LIMIT
  1

SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = 'cd640ceb31a36d68073df8b916b882a034f9e902f34e667021439e86d7579248a27ef1f9def92c64040c8bd164fdb357eeaadaa8dc79a5e2e793f5ae6e86c48c' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Gesdinet\JWTRefreshTokenBundle\Doctrine\RefreshTokenManager->get (line 56)
4	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->authenticate (line 75)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

2.38 ms
(12.13%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 434)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	Gesdinet\JWTRefreshTokenBundle\Doctrine\RefreshTokenManager->save (line 69)
4	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->authenticate (line 97)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

1.09 ms
(5.58%)

UPDATE user SET last_login = ? WHERE id = ?

Parameters:

[
  "2026-08-19 04:39:47"
  2
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  last_login = ?
WHERE
  id = ?

UPDATE user SET last_login = '2026-08-19 04:39:47' WHERE id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Listener\AuthenticationSuccessListener->onAuthenticationSuccessResponse (line 41)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Lexik\Bundle\JWTAuthenticationBundle\Security\Http\Authentication\AuthenticationSuccessHandler->handleAuthenticationSuccess (line 65)
12	Lexik\Bundle\JWTAuthenticationBundle\Security\Http\Authentication\AuthenticationSuccessHandler->onAuthenticationSuccess (line 48)
13	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authentication\AuthenticationSuccessHandler->onAuthenticationSuccess (line 40)
14	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->onAuthenticationSuccess (line 127)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 89)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 219)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
20	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
21	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
22	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
31	Symfony\Component\HttpKernel\Kernel->handle (line 143)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 5)

0.97 ms
(4.95%)

UPDATE refresh_tokens SET valid = ? WHERE id = ?

Parameters:

[
  "2026-08-20 04:39:47"
  12
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  refresh_tokens
SET
  valid = ?
WHERE
  id = ?

UPDATE refresh_tokens SET valid = '2026-08-20 04:39:47' WHERE id = 12;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	Gesdinet\JWTRefreshTokenBundle\Doctrine\RefreshTokenManager->save (line 69)
7	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->authenticate (line 97)
8	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
23	Symfony\Component\HttpKernel\Kernel->handle (line 143)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
25	require_once (line 32)
26	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\User	1
App\Entity\RefreshToken	1

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\User	No errors.

POST https://dev.supercai.oroe.eu/rest/token/refresh

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping