Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.56 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.08 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 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.47 ms

SELECT b0_.id AS id_0, b0_.begin_at AS begin_at_1, b0_.end_at AS end_at_2, b0_.title AS title_3, b0_.note AS note_4, b0_.created_at AS created_at_5, b0_.updated_at AS updated_at_6, b0_.client_accepted AS client_accepted_7, b0_.client_declined AS client_declined_8, b0_.client_reason AS client_reason_9, b0_.provider_accepted AS provider_accepted_10, b0_.provider_declined AS provider_declined_11, b0_.provider_reason AS provider_reason_12, b0_.rescheduled AS rescheduled_13, b0_.created_by_id AS created_by_id_14, b0_.client_id AS client_id_15, b0_.provider_id AS provider_id_16, b0_.service_id AS service_id_17 FROM booking b0_ LEFT JOIN user u1_ ON b0_.created_by_id = u1_.id LEFT JOIN user u2_ ON b0_.client_id = u2_.id LEFT JOIN user u3_ ON b0_.provider_id = u3_.id WHERE (b0_.begin_at BETWEEN ? AND ? OR b0_.end_at BETWEEN ? AND ?) AND (u1_.email = ? OR u2_.email = ? OR u3_.email = ?)

Parameters:

[
  "2025-02-23 00:00:00"
  "2025-04-06 00:00:00"
  "2025-02-23 00:00:00"
  "2025-04-06 00:00:00"
  "osryancar@gmail.com"
  "osryancar@gmail.com"
  "osryancar@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.begin_at AS begin_at_1,
  b0_.end_at AS end_at_2,
  b0_.title AS title_3,
  b0_.note AS note_4,
  b0_.created_at AS created_at_5,
  b0_.updated_at AS updated_at_6,
  b0_.client_accepted AS client_accepted_7,
  b0_.client_declined AS client_declined_8,
  b0_.client_reason AS client_reason_9,
  b0_.provider_accepted AS provider_accepted_10,
  b0_.provider_declined AS provider_declined_11,
  b0_.provider_reason AS provider_reason_12,
  b0_.rescheduled AS rescheduled_13,
  b0_.created_by_id AS created_by_id_14,
  b0_.client_id AS client_id_15,
  b0_.provider_id AS provider_id_16,
  b0_.service_id AS service_id_17
FROM
  booking b0_
  LEFT JOIN user u1_ ON b0_.created_by_id = u1_.id
  LEFT JOIN user u2_ ON b0_.client_id = u2_.id
  LEFT JOIN user u3_ ON b0_.provider_id = u3_.id
WHERE
  (
    b0_.begin_at BETWEEN ?
    AND ?
    OR b0_.end_at BETWEEN ?
    AND ?
  )
  AND (
    u1_.email = ?
    OR u2_.email = ?
    OR u3_.email = ?
  )

SELECT b0_.id AS id_0, b0_.begin_at AS begin_at_1, b0_.end_at AS end_at_2, b0_.title AS title_3, b0_.note AS note_4, b0_.created_at AS created_at_5, b0_.updated_at AS updated_at_6, b0_.client_accepted AS client_accepted_7, b0_.client_declined AS client_declined_8, b0_.client_reason AS client_reason_9, b0_.provider_accepted AS provider_accepted_10, b0_.provider_declined AS provider_declined_11, b0_.provider_reason AS provider_reason_12, b0_.rescheduled AS rescheduled_13, b0_.created_by_id AS created_by_id_14, b0_.client_id AS client_id_15, b0_.provider_id AS provider_id_16, b0_.service_id AS service_id_17 FROM booking b0_ LEFT JOIN user u1_ ON b0_.created_by_id = u1_.id LEFT JOIN user u2_ ON b0_.client_id = u2_.id LEFT JOIN user u3_ ON b0_.provider_id = u3_.id WHERE (b0_.begin_at BETWEEN '2025-02-23 00:00:00' AND '2025-04-06 00:00:00' OR b0_.end_at BETWEEN '2025-02-23 00:00:00' AND '2025-04-06 00:00:00') AND (u1_.email = 'osryancar@gmail.com' OR u2_.email = 'osryancar@gmail.com' OR u3_.email = 'osryancar@gmail.com');

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 42)
7	App\Repository\BookingRepository->getUserBookings (line 34)
8	App\EventListener\Calendar\CalendarEventListener->onCalendarSetData (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 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 53)
13	CalendarBundle\Controller\CalendarController->load (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 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

POST https://app.nairobifashionhub.co.ke/fc-load-events

Configuration Settings

Theme