Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.58 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.31 ms

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 251)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 132)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
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 80)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.27 ms

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.name AS name_2, u0_.surname AS surname_3, u0_.phone_prefix AS phone_prefix_4, u0_.phone AS phone_5, u0_.email AS email_6, u0_.roles AS roles_7, u0_.region AS region_8, u0_.card_number AS card_number_9, u0_.last_sync_at AS last_sync_at_10, u0_.campus_rank AS campus_rank_11, u0_.points_sum AS points_sum_12, u0_.campus_token AS campus_token_13, u0_.access_level AS access_level_14, u0_.account_type AS account_type_15, u0_.organization_id AS organization_id_16, u0_.campus_id AS campus_id_17, u0_.avatar AS avatar_18, u0_.aigymaccesstoken AS aigymaccesstoken_19, u0_.aigymrefreshtoken AS aigymrefreshtoken_20, u0_.promptbookaccesstoken AS promptbookaccesstoken_21, u0_.promptbookrefreshtoken AS promptbookrefreshtoken_22, u0_.campusappaccesstoken AS campusappaccesstoken_23, u0_.campusapprefreshtoken AS campusapprefreshtoken_24, u0_.metaverse_ssid AS metaverse_ssid_25, u0_.multibotaccesstoken AS multibotaccesstoken_26, u0_.multibotrefreshtoken AS multibotrefreshtoken_27, r1_.id AS id_28, r1_.name AS name_29, r1_.last_sync_at AS last_sync_at_30, u2_.id AS id_31, u2_.progress AS progress_32, u2_.last_sync_at AS last_sync_at_33, c3_.id AS id_34, c3_.name AS name_35, c3_.description AS description_36, c3_.campus_course_id AS campus_course_id_37, c3_.last_sync_at AS last_sync_at_38, u0_.rank_id AS rank_id_39, u2_.user_id AS user_id_40, u2_.course_id AS course_id_41 FROM user u0_ LEFT JOIN rank_entity r1_ ON u0_.rank_id = r1_.id LEFT JOIN user_course u2_ ON u0_.id = u2_.user_id LEFT JOIN course c3_ ON u2_.course_id = c3_.id WHERE u0_.id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.name AS name_2,
  u0_.surname AS surname_3,
  u0_.phone_prefix AS phone_prefix_4,
  u0_.phone AS phone_5,
  u0_.email AS email_6,
  u0_.roles AS roles_7,
  u0_.region AS region_8,
  u0_.card_number AS card_number_9,
  u0_.last_sync_at AS last_sync_at_10,
  u0_.campus_rank AS campus_rank_11,
  u0_.points_sum AS points_sum_12,
  u0_.campus_token AS campus_token_13,
  u0_.access_level AS access_level_14,
  u0_.account_type AS account_type_15,
  u0_.organization_id AS organization_id_16,
  u0_.campus_id AS campus_id_17,
  u0_.avatar AS avatar_18,
  u0_.aigymaccesstoken AS aigymaccesstoken_19,
  u0_.aigymrefreshtoken AS aigymrefreshtoken_20,
  u0_.promptbookaccesstoken AS promptbookaccesstoken_21,
  u0_.promptbookrefreshtoken AS promptbookrefreshtoken_22,
  u0_.campusappaccesstoken AS campusappaccesstoken_23,
  u0_.campusapprefreshtoken AS campusapprefreshtoken_24,
  u0_.metaverse_ssid AS metaverse_ssid_25,
  u0_.multibotaccesstoken AS multibotaccesstoken_26,
  u0_.multibotrefreshtoken AS multibotrefreshtoken_27,
  r1_.id AS id_28,
  r1_.name AS name_29,
  r1_.last_sync_at AS last_sync_at_30,
  u2_.id AS id_31,
  u2_.progress AS progress_32,
  u2_.last_sync_at AS last_sync_at_33,
  c3_.id AS id_34,
  c3_.name AS name_35,
  c3_.description AS description_36,
  c3_.campus_course_id AS campus_course_id_37,
  c3_.last_sync_at AS last_sync_at_38,
  u0_.rank_id AS rank_id_39,
  u2_.user_id AS user_id_40,
  u2_.course_id AS course_id_41
FROM
  user u0_
  LEFT JOIN rank_entity r1_ ON u0_.rank_id = r1_.id
  LEFT JOIN user_course u2_ ON u0_.id = u2_.user_id
  LEFT JOIN course c3_ ON u2_.course_id = c3_.id
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.name AS name_2, u0_.surname AS surname_3, u0_.phone_prefix AS phone_prefix_4, u0_.phone AS phone_5, u0_.email AS email_6, u0_.roles AS roles_7, u0_.region AS region_8, u0_.card_number AS card_number_9, u0_.last_sync_at AS last_sync_at_10, u0_.campus_rank AS campus_rank_11, u0_.points_sum AS points_sum_12, u0_.campus_token AS campus_token_13, u0_.access_level AS access_level_14, u0_.account_type AS account_type_15, u0_.organization_id AS organization_id_16, u0_.campus_id AS campus_id_17, u0_.avatar AS avatar_18, u0_.aigymaccesstoken AS aigymaccesstoken_19, u0_.aigymrefreshtoken AS aigymrefreshtoken_20, u0_.promptbookaccesstoken AS promptbookaccesstoken_21, u0_.promptbookrefreshtoken AS promptbookrefreshtoken_22, u0_.campusappaccesstoken AS campusappaccesstoken_23, u0_.campusapprefreshtoken AS campusapprefreshtoken_24, u0_.metaverse_ssid AS metaverse_ssid_25, u0_.multibotaccesstoken AS multibotaccesstoken_26, u0_.multibotrefreshtoken AS multibotrefreshtoken_27, r1_.id AS id_28, r1_.name AS name_29, r1_.last_sync_at AS last_sync_at_30, u2_.id AS id_31, u2_.progress AS progress_32, u2_.last_sync_at AS last_sync_at_33, c3_.id AS id_34, c3_.name AS name_35, c3_.description AS description_36, c3_.campus_course_id AS campus_course_id_37, c3_.last_sync_at AS last_sync_at_38, u0_.rank_id AS rank_id_39, u2_.user_id AS user_id_40, u2_.course_id AS course_id_41 FROM user u0_ LEFT JOIN rank_entity r1_ ON u0_.rank_id = r1_.id LEFT JOIN user_course u2_ ON u0_.id = u2_.user_id LEFT JOIN course c3_ ON u2_.course_id = c3_.id WHERE u0_.id = 21;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 84)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 75)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 48)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 53)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 47)
12	ApiPlatform\State\Provider\DeserializeProvider->provide (line 53)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 42)
14	ApiPlatform\Symfony\Validator\State\QueryParameterValidateProvider->provide (line 32)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 53)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 56)
17	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 82)
18	ApiPlatform\Symfony\Controller\MainController->__invoke (line 178)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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
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.
App\Entity\Course	No errors.

Symfony Profiler

GET https://apidev.campusai.flowmakersdigital.pl/api/users/21

Configuration Settings

Theme