Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

28.65 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

27.57 ms
(96.22%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 184)
5	App\EventSubscriber\TokenRefreshSubscriber->onTokenRefresh (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 46)
10	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authentication\AuthenticationSuccessHandler->onAuthenticationSuccess (line 173)
11	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->onAuthenticationSuccess (line 85)
12	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 235)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 221)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
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 80)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.37 ms
(1.28%)

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:

[
  "54d3abf74ada5f2e7cf68099a94d2e14ac1e891fc525f1f0ab20e253da8b994706966068bc4d6f8c9feb0d8df76cea2d93898238f50910a48446627d86e7b44d"
]

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 = '54d3abf74ada5f2e7cf68099a94d2e14ac1e891fc525f1f0ab20e253da8b994706966068bc4d6f8c9feb0d8df76cea2d93898238f50910a48446627d86e7b44d' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Gesdinet\JWTRefreshTokenBundle\Doctrine\RefreshTokenManager->get (line 107)
5	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->authenticate (line 70)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.34 ms
(1.20%)

UPDATE user SET aigymaccesstoken = ?, aigymrefreshtoken = ?, promptbookaccesstoken = ?, promptbookrefreshtoken = ?, campusappaccesstoken = ?, campusapprefreshtoken = ?, multibotaccesstoken = ?, multibotrefreshtoken = ? WHERE id = ?

Parameters:

[
  "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI2ODM3MjdhNWVmNjAwNDQ0ZWEzYmFjNDQiLCJlbWFpbCI6ImRpc3RyaWN0ZGV2QGNhbXB1c2FpLnBsIiwiYXBwSWQiOiIxIiwidXNlcm5hbWUiOiJUZXN0IGRldk1ldGF2ZXJzZSIsImF2YXRhciI6Imh0dHBzOi8vdWktYXZhdGFycy5jb20vYXBpLz9iYWNrZ3JvdW5kPXJhbmRvbSZib2xkPXRydWUmbmFtZT1kaXN0cmljdHU4MzkiLCJ0eXBlIjoiYWNjZXNzIiwidXNlcklkIjoiNjgzNzI3YTVlZjYwMDQ0NGVhM2JhYzQ0Iiwic2lkIjoiNjlkNGY2MDRmYmY0ZGQzNjE5MjE5NjE5IiwiaWF0IjoxNzc1ODA4MjYyLCJleHAiOjE3NzU4MDkxNjJ9.D4DlmRoq7PVdK_KMZWPNywZg58UE9_1XijXfq3ysLLc"
  "788b41e53a93d6c2ef44a5fdd5569adc2cb3a539edad29c2e7c7d98b376a9d4a961856e9bfc88951e136704ca557db17fc1d8a738daabaca2622c6fde40909d6"
  "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI2ODM3MjdhNWVmNjAwNDQ0ZWEzYmFjNDQiLCJlbWFpbCI6ImRpc3RyaWN0ZGV2QGNhbXB1c2FpLnBsIiwiYXBwSWQiOiIzIiwidXNlcm5hbWUiOiJUZXN0IGRldk1ldGF2ZXJzZSIsImF2YXRhciI6Imh0dHBzOi8vdWktYXZhdGFycy5jb20vYXBpLz9iYWNrZ3JvdW5kPXJhbmRvbSZib2xkPXRydWUmbmFtZT1kaXN0cmljdHU4MzkiLCJ0eXBlIjoiYWNjZXNzIiwidXNlcklkIjoiNjgzNzI3YTVlZjYwMDQ0NGVhM2JhYzQ0Iiwic2lkIjoiNjlkNGY2MDRmYmY0ZGQzNjE5MjE5NjFjIiwiaWF0IjoxNzc1ODA4MjYyLCJleHAiOjE3NzU4MDkxNjJ9.6rUoK-kL0wYK_kz_933BOlSwWPQIXDqsvlCA_o0VQgQ"
  "06de9c1a012ab779d5c8adc12f839d6df8c663d4aa239a3d67525b501ddb5fb6246fdab870304e8b98925d7aec87ef261d182635c939679dd17eb82db63c7cb0"
  "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI2ODM3MjdhNWVmNjAwNDQ0ZWEzYmFjNDQiLCJlbWFpbCI6ImRpc3RyaWN0ZGV2QGNhbXB1c2FpLnBsIiwiYXBwSWQiOiIyMCIsInVzZXJuYW1lIjoiVGVzdCBkZXZNZXRhdmVyc2UiLCJhdmF0YXIiOiJodHRwczovL3VpLWF2YXRhcnMuY29tL2FwaS8_YmFja2dyb3VuZD1yYW5kb20mYm9sZD10cnVlJm5hbWU9ZGlzdHJpY3R1ODM5IiwidHlwZSI6ImFjY2VzcyIsInVzZXJJZCI6IjY4MzcyN2E1ZWY2MDA0NDRlYTNiYWM0NCIsInNpZCI6IjY5ZDRmNjA0ZmJmNGRkMzYxOTIxOTYxYiIsImlhdCI6MTc3NTgwODI2MiwiZXhwIjoxNzc1ODA5MTYyfQ.8CwN1ray1wtLQi-32q734RYdaLxJFFRqASi1ruHSBvo"
  "9c190560b6030c910fdfd755a76bde2dd481baa284ce693028452c2949fbde58c0a5fa4c89b41cc89b41e80882fd7934125f3cfa904a782922c7cb721e8677ae"
  "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI2ODM3MjdhNWVmNjAwNDQ0ZWEzYmFjNDQiLCJlbWFpbCI6ImRpc3RyaWN0ZGV2QGNhbXB1c2FpLnBsIiwiYXBwSWQiOiIzNyIsInVzZXJuYW1lIjoiVGVzdCBkZXZNZXRhdmVyc2UiLCJhdmF0YXIiOiJodHRwczovL3VpLWF2YXRhcnMuY29tL2FwaS8_YmFja2dyb3VuZD1yYW5kb20mYm9sZD10cnVlJm5hbWU9ZGlzdHJpY3R1ODM5IiwidHlwZSI6ImFjY2VzcyIsInVzZXJJZCI6IjY4MzcyN2E1ZWY2MDA0NDRlYTNiYWM0NCIsInNpZCI6IjY5ZDRmNjA0ZmJmNGRkMzYxOTIxOTYxZSIsImlhdCI6MTc3NTgwODI2MiwiZXhwIjoxNzc1ODA5MTYyfQ.uwPt4F11YuTfNvFL9K-reoLiAY_SvZQHHCAheVCR_fA"
  "bb2a180a9bc59c5cc95d0eb1c5425a4fbc125bfaed7bdf43f1e961f7723410db6594b67004cdb8aac162af4227065585abff8cbd1517d573ef2833fa662601b3"
  21
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  aigymaccesstoken = ?,
  aigymrefreshtoken = ?,
  promptbookaccesstoken = ?,
  promptbookrefreshtoken = ?,
  campusappaccesstoken = ?,
  campusapprefreshtoken = ?,
  multibotaccesstoken = ?,
  multibotrefreshtoken = ?
WHERE
  id = ?

UPDATE user SET aigymaccesstoken = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI2ODM3MjdhNWVmNjAwNDQ0ZWEzYmFjNDQiLCJlbWFpbCI6ImRpc3RyaWN0ZGV2QGNhbXB1c2FpLnBsIiwiYXBwSWQiOiIxIiwidXNlcm5hbWUiOiJUZXN0IGRldk1ldGF2ZXJzZSIsImF2YXRhciI6Imh0dHBzOi8vdWktYXZhdGFycy5jb20vYXBpLz9iYWNrZ3JvdW5kPXJhbmRvbSZib2xkPXRydWUmbmFtZT1kaXN0cmljdHU4MzkiLCJ0eXBlIjoiYWNjZXNzIiwidXNlcklkIjoiNjgzNzI3YTVlZjYwMDQ0NGVhM2JhYzQ0Iiwic2lkIjoiNjlkNGY2MDRmYmY0ZGQzNjE5MjE5NjE5IiwiaWF0IjoxNzc1ODA4MjYyLCJleHAiOjE3NzU4MDkxNjJ9.D4DlmRoq7PVdK_KMZWPNywZg58UE9_1XijXfq3ysLLc', aigymrefreshtoken = '788b41e53a93d6c2ef44a5fdd5569adc2cb3a539edad29c2e7c7d98b376a9d4a961856e9bfc88951e136704ca557db17fc1d8a738daabaca2622c6fde40909d6', promptbookaccesstoken = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI2ODM3MjdhNWVmNjAwNDQ0ZWEzYmFjNDQiLCJlbWFpbCI6ImRpc3RyaWN0ZGV2QGNhbXB1c2FpLnBsIiwiYXBwSWQiOiIzIiwidXNlcm5hbWUiOiJUZXN0IGRldk1ldGF2ZXJzZSIsImF2YXRhciI6Imh0dHBzOi8vdWktYXZhdGFycy5jb20vYXBpLz9iYWNrZ3JvdW5kPXJhbmRvbSZib2xkPXRydWUmbmFtZT1kaXN0cmljdHU4MzkiLCJ0eXBlIjoiYWNjZXNzIiwidXNlcklkIjoiNjgzNzI3YTVlZjYwMDQ0NGVhM2JhYzQ0Iiwic2lkIjoiNjlkNGY2MDRmYmY0ZGQzNjE5MjE5NjFjIiwiaWF0IjoxNzc1ODA4MjYyLCJleHAiOjE3NzU4MDkxNjJ9.6rUoK-kL0wYK_kz_933BOlSwWPQIXDqsvlCA_o0VQgQ', promptbookrefreshtoken = '06de9c1a012ab779d5c8adc12f839d6df8c663d4aa239a3d67525b501ddb5fb6246fdab870304e8b98925d7aec87ef261d182635c939679dd17eb82db63c7cb0', campusappaccesstoken = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI2ODM3MjdhNWVmNjAwNDQ0ZWEzYmFjNDQiLCJlbWFpbCI6ImRpc3RyaWN0ZGV2QGNhbXB1c2FpLnBsIiwiYXBwSWQiOiIyMCIsInVzZXJuYW1lIjoiVGVzdCBkZXZNZXRhdmVyc2UiLCJhdmF0YXIiOiJodHRwczovL3VpLWF2YXRhcnMuY29tL2FwaS8_YmFja2dyb3VuZD1yYW5kb20mYm9sZD10cnVlJm5hbWU9ZGlzdHJpY3R1ODM5IiwidHlwZSI6ImFjY2VzcyIsInVzZXJJZCI6IjY4MzcyN2E1ZWY2MDA0NDRlYTNiYWM0NCIsInNpZCI6IjY5ZDRmNjA0ZmJmNGRkMzYxOTIxOTYxYiIsImlhdCI6MTc3NTgwODI2MiwiZXhwIjoxNzc1ODA5MTYyfQ.8CwN1ray1wtLQi-32q734RYdaLxJFFRqASi1ruHSBvo', campusapprefreshtoken = '9c190560b6030c910fdfd755a76bde2dd481baa284ce693028452c2949fbde58c0a5fa4c89b41cc89b41e80882fd7934125f3cfa904a782922c7cb721e8677ae', multibotaccesstoken = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI2ODM3MjdhNWVmNjAwNDQ0ZWEzYmFjNDQiLCJlbWFpbCI6ImRpc3RyaWN0ZGV2QGNhbXB1c2FpLnBsIiwiYXBwSWQiOiIzNyIsInVzZXJuYW1lIjoiVGVzdCBkZXZNZXRhdmVyc2UiLCJhdmF0YXIiOiJodHRwczovL3VpLWF2YXRhcnMuY29tL2FwaS8_YmFja2dyb3VuZD1yYW5kb20mYm9sZD10cnVlJm5hbWU9ZGlzdHJpY3R1ODM5IiwidHlwZSI6ImFjY2VzcyIsInVzZXJJZCI6IjY4MzcyN2E1ZWY2MDA0NDRlYTNiYWM0NCIsInNpZCI6IjY5ZDRmNjA0ZmJmNGRkMzYxOTIxOTYxZSIsImlhdCI6MTc3NTgwODI2MiwiZXhwIjoxNzc1ODA5MTYyfQ.uwPt4F11YuTfNvFL9K-reoLiAY_SvZQHHCAheVCR_fA', multibotrefreshtoken = 'bb2a180a9bc59c5cc95d0eb1c5425a4fbc125bfaed7bdf43f1e961f7723410db6594b67004cdb8aac162af4227065585abff8cbd1517d573ef2833fa662601b3' WHERE id = 21;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 490)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 374)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 184)
7	App\EventSubscriber\TokenRefreshSubscriber->onTokenRefresh (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 46)
12	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authentication\AuthenticationSuccessHandler->onAuthenticationSuccess (line 173)
13	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->onAuthenticationSuccess (line 85)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 235)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 221)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
22	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.26 ms
(0.92%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.name AS name_3, t0.surname AS surname_4, t0.phone_prefix AS phone_prefix_5, t0.phone AS phone_6, t0.email AS email_7, t0.roles AS roles_8, t0.region AS region_9, t0.card_number AS card_number_10, t0.last_sync_at AS last_sync_at_11, t0.campus_rank AS campus_rank_12, t0.points_sum AS points_sum_13, t0.campus_token AS campus_token_14, t0.access_level AS access_level_15, t0.account_type AS account_type_16, t0.organization_id AS organization_id_17, t0.campus_id AS campus_id_18, t0.avatar AS avatar_19, t0.aigymaccesstoken AS aigymaccesstoken_20, t0.aigymrefreshtoken AS aigymrefreshtoken_21, t0.promptbookaccesstoken AS promptbookaccesstoken_22, t0.promptbookrefreshtoken AS promptbookrefreshtoken_23, t0.campusappaccesstoken AS campusappaccesstoken_24, t0.campusapprefreshtoken AS campusapprefreshtoken_25, t0.metaverse_ssid AS metaverse_ssid_26, t0.multibotaccesstoken AS multibotaccesstoken_27, t0.multibotrefreshtoken AS multibotrefreshtoken_28, t0.rank_id AS rank_id_29 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "districtdev@campusai.pl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.phone_prefix AS phone_prefix_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.roles AS roles_8,
  t0.region AS region_9,
  t0.card_number AS card_number_10,
  t0.last_sync_at AS last_sync_at_11,
  t0.campus_rank AS campus_rank_12,
  t0.points_sum AS points_sum_13,
  t0.campus_token AS campus_token_14,
  t0.access_level AS access_level_15,
  t0.account_type AS account_type_16,
  t0.organization_id AS organization_id_17,
  t0.campus_id AS campus_id_18,
  t0.avatar AS avatar_19,
  t0.aigymaccesstoken AS aigymaccesstoken_20,
  t0.aigymrefreshtoken AS aigymrefreshtoken_21,
  t0.promptbookaccesstoken AS promptbookaccesstoken_22,
  t0.promptbookrefreshtoken AS promptbookrefreshtoken_23,
  t0.campusappaccesstoken AS campusappaccesstoken_24,
  t0.campusapprefreshtoken AS campusapprefreshtoken_25,
  t0.metaverse_ssid AS metaverse_ssid_26,
  t0.multibotaccesstoken AS multibotaccesstoken_27,
  t0.multibotrefreshtoken AS multibotrefreshtoken_28,
  t0.rank_id AS rank_id_29
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.name AS name_3, t0.surname AS surname_4, t0.phone_prefix AS phone_prefix_5, t0.phone AS phone_6, t0.email AS email_7, t0.roles AS roles_8, t0.region AS region_9, t0.card_number AS card_number_10, t0.last_sync_at AS last_sync_at_11, t0.campus_rank AS campus_rank_12, t0.points_sum AS points_sum_13, t0.campus_token AS campus_token_14, t0.access_level AS access_level_15, t0.account_type AS account_type_16, t0.organization_id AS organization_id_17, t0.campus_id AS campus_id_18, t0.avatar AS avatar_19, t0.aigymaccesstoken AS aigymaccesstoken_20, t0.aigymrefreshtoken AS aigymrefreshtoken_21, t0.promptbookaccesstoken AS promptbookaccesstoken_22, t0.promptbookrefreshtoken AS promptbookrefreshtoken_23, t0.campusappaccesstoken AS campusappaccesstoken_24, t0.campusapprefreshtoken AS campusapprefreshtoken_25, t0.metaverse_ssid AS metaverse_ssid_26, t0.multibotaccesstoken AS multibotaccesstoken_27, t0.multibotrefreshtoken AS multibotrefreshtoken_28, t0.rank_id AS rank_id_29 FROM user t0 WHERE t0.email = 'districtdev@campusai.pl' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 87)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
19	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.11 ms
(0.37%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 184)
4	App\EventSubscriber\TokenRefreshSubscriber->onTokenRefresh (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 46)
9	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authentication\AuthenticationSuccessHandler->onAuthenticationSuccess (line 173)
10	Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator->onAuthenticationSuccess (line 85)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 235)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 221)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
19	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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.

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\User	No errors.
App\Entity\Rank	No errors.
App\Entity\UserCourse	No errors.
App\Entity\Point	No errors.
App\Entity\SaveGame	No errors.

Symfony Profiler

POST https://apidev.campusai.flowmakersdigital.pl/api/token/refresh

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping