Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

13.06 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.41 ms
(56.75%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 430)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 66)
4	App\EventListener\ExceptionListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
9	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.50 ms
(11.50%)

INSERT INTO error_log (url, ip_address, error_code, error_message, error_detail, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "https://pms-uat.birlaopenminds.com/media/cache/resolve/md/d18644234e75f850b865e7b9e7ddb098605b4c56.pdf"
  "34.120.117.174"
  "500"
  "Unable to create image for path "d18644234e75f850b865e7b9e7ddb098605b4c56.pdf" and filter "md". Message was "Unable to open image /var/www/birla-open-minds/public/uploads/d18644234e75f850b865e7b9e7ddb098605b4c56.pdf""
  "{"file":"\/var\/www\/birla-open-minds\/vendor\/liip\/imagine-bundle\/Controller\/ImagineController.php","line":172}"
  "2026-04-03 16:28:05"
  "2026-04-03 16:28:05"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO error_log (
  url, ip_address, error_code, error_message,
  error_detail, created_at, updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO error_log (url, ip_address, error_code, error_message, error_detail, created_at, updated_at) VALUES ('https://pms-uat.birlaopenminds.com/media/cache/resolve/md/d18644234e75f850b865e7b9e7ddb098605b4c56.pdf', '34.120.117.174', '500', 'Unable to create image for path \"d18644234e75f850b865e7b9e7ddb098605b4c56.pdf\" and filter \"md\". Message was \"Unable to open image /var/www/birla-open-minds/public/uploads/d18644234e75f850b865e7b9e7ddb098605b4c56.pdf\"', '{\"file\":\"\\/var\\/www\\/birla-open-minds\\/vendor\\/liip\\/imagine-bundle\\/Controller\\/ImagineController.php\",\"line\":172}', '2026-04-03 16:28:05', '2026-04-03 16:28:05');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 133)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 66)
7	App\EventListener\ExceptionListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
12	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.46 ms
(11.20%)

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 74)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():71} (line 34)
14	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 44)
16	Stof\DoctrineExtensionsBundle\EventListener\BlameListener->onKernelRequest (line 115)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

1.43 ms
(10.91%)

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 74)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():71} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 44)
14	Stof\DoctrineExtensionsBundle\EventListener\BlameListener->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.26 ms
(9.65%)

"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 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 66)
4	App\EventListener\ExceptionListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
9	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.
App\Entity\ErrorLog	No errors.

Symfony Profiler

GET https://pms-uat.birlaopenminds.com/media/cache/resolve/md/d18644234e75f850b865e7b9e7ddb098605b4c56.pdf

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping