Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.93 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.93 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.phone AS phone_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.gender AS gender_9, t0.profile_image AS profile_image_10, t0.bio AS bio_11, t0.password_reset AS password_reset_12, t0.password_reset_token_ttl AS password_reset_token_ttl_13, t0.password_reset_token AS password_reset_token_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.verified_at AS verified_at_17, t0.speciality AS speciality_18, t0.country AS country_19, t0.email_verified AS email_verified_20, t0.phone_verified AS phone_verified_21, t0.primary_use AS primary_use_22, t0.user_type AS user_type_23, t0.brand_name AS brand_name_24, t0.location AS location_25, t0.onboarding_step AS onboarding_step_26, t0.birthday AS birthday_27 FROM user t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.phone AS phone_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.gender AS gender_9,
  t0.profile_image AS profile_image_10,
  t0.bio AS bio_11,
  t0.password_reset AS password_reset_12,
  t0.password_reset_token_ttl AS password_reset_token_ttl_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.verified_at AS verified_at_17,
  t0.speciality AS speciality_18,
  t0.country AS country_19,
  t0.email_verified AS email_verified_20,
  t0.phone_verified AS phone_verified_21,
  t0.primary_use AS primary_use_22,
  t0.user_type AS user_type_23,
  t0.brand_name AS brand_name_24,
  t0.location AS location_25,
  t0.onboarding_step AS onboarding_step_26,
  t0.birthday AS birthday_27
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.phone AS phone_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.gender AS gender_9, t0.profile_image AS profile_image_10, t0.bio AS bio_11, t0.password_reset AS password_reset_12, t0.password_reset_token_ttl AS password_reset_token_ttl_13, t0.password_reset_token AS password_reset_token_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.verified_at AS verified_at_17, t0.speciality AS speciality_18, t0.country AS country_19, t0.email_verified AS email_verified_20, t0.phone_verified AS phone_verified_21, t0.primary_use AS primary_use_22, t0.user_type AS user_type_23, t0.brand_name AS brand_name_24, t0.location AS location_25, t0.onboarding_step AS onboarding_step_26, t0.birthday AS birthday_27 FROM user t0 WHERE t0.id = 2;

#	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 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 35)
14	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 111)
15	App\Controller\DashboardController->checkSession (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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\Booking	No errors.
App\Entity\ProviderService	No errors.
App\Entity\ShowcaseImage	No errors.
App\Entity\Identification	No errors.
App\Entity\Business	No errors.
App\Entity\SocialMedia	No errors.
App\Entity\Address	No errors.
App\Entity\BusinessHour	No errors.
App\Entity\Experience	No errors.

Symfony Profiler

GET https://app.nairobifashionhub.co.ke/session/check

Configuration Settings

Theme