Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.39 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.71 ms

SELECT t0.id AS id_1, t0.employee_code AS employee_code_2, t0.employee_name AS employee_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.mobile AS mobile_9, t0.avatar AS avatar_10, t0.token AS token_11, t0.token_date AS token_date_12, t0.last_login AS last_login_13, t0.email_verified AS email_verified_14, t0.mobile_verified AS mobile_verified_15, t0.enabled AS enabled_16, t0.date_of_birth AS date_of_birth_17, t0.gender AS gender_18, t0.display_name AS display_name_19, t0.type AS type_20, t0.phone AS phone_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.office_location_id AS office_location_id_24, t0.zone_id AS zone_id_25, t0.department_id AS department_id_26 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.employee_code AS employee_code_2,
  t0.employee_name AS employee_name_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.mobile AS mobile_9,
  t0.avatar AS avatar_10,
  t0.token AS token_11,
  t0.token_date AS token_date_12,
  t0.last_login AS last_login_13,
  t0.email_verified AS email_verified_14,
  t0.mobile_verified AS mobile_verified_15,
  t0.enabled AS enabled_16,
  t0.date_of_birth AS date_of_birth_17,
  t0.gender AS gender_18,
  t0.display_name AS display_name_19,
  t0.type AS type_20,
  t0.phone AS phone_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.office_location_id AS office_location_id_24,
  t0.zone_id AS zone_id_25,
  t0.department_id AS department_id_26
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.employee_code AS employee_code_2, t0.employee_name AS employee_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.mobile AS mobile_9, t0.avatar AS avatar_10, t0.token AS token_11, t0.token_date AS token_date_12, t0.last_login AS last_login_13, t0.email_verified AS email_verified_14, t0.mobile_verified AS mobile_verified_15, t0.enabled AS enabled_16, t0.date_of_birth AS date_of_birth_17, t0.gender AS gender_18, t0.display_name AS display_name_19, t0.type AS type_20, t0.phone AS phone_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.office_location_id AS office_location_id_24, t0.zone_id AS zone_id_25, t0.department_id AS department_id_26 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 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.69 ms

SELECT t0.user_id AS user_id_1, t0.module_id AS module_id_2, t0.permission_id AS permission_id_3 FROM user_permission t0 WHERE t0.user_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.user_id AS user_id_1,
  t0.module_id AS module_id_2,
  t0.permission_id AS permission_id_3
FROM
  user_permission t0
WHERE
  t0.user_id = ?

SELECT t0.user_id AS user_id_1, t0.module_id AS module_id_2, t0.permission_id AS permission_id_3 FROM user_permission t0 WHERE t0.user_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 528)
8	App\Entity\User->getRoles (line 308)
9	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 217)
10	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\OfficeLocation	No errors.
App\Entity\EmployeeZone	No errors.
App\Entity\Department	No errors.
App\Entity\UserReportingManager	No errors.
App\Entity\UserPermission	No errors.
App\Entity\Module	No errors.
App\Entity\Permission	No errors.

Symfony Profiler

GET https://pms-uat.birlaopenminds.com/control/styles.css

Configuration Settings

Theme