Symfony Profiler

Query Metrics

11 Database Queries

8 Different statements

2.21 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.79 ms
(35.51%)

SELECT COUNT(*) FROM vacation_requests WHERE user_id = ? AND status = 'pending'

Parameters:

[
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  vacation_requests
WHERE
  user_id = ?
  AND status = 'pending'

SELECT COUNT(*) FROM vacation_requests WHERE user_id = 46 AND status = 'pending';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\AttendanceController->notifications (line 428)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 31)

0.45 ms
(20.39%)

UPDATE system_session SET last_activity = NOW() WHERE identifier = ?

Parameters:

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  system_session
SET
  last_activity = NOW()
WHERE
  identifier = ?

UPDATE system_session SET last_activity = NOW() WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

#	File/Call
1	App\Session\SessionHandler->updateSession (line 188)
2	App\EventSubscriber\AuthenticationSubscriber->onKernelController (line 65)
3	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
4	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
6	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 31)

0.25 ms
(11.31%)

SELECT user_id, permission FROM user_permissions

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  user_id,
  permission
FROM
  user_permissions

SELECT user_id, permission FROM user_permissions;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Permissions\PermissionManager->loadPermissionsIfNeeded (line 194)
3	App\Permissions\PermissionManager->getUserPermissions (line 183)
4	App\Permissions\AccessValidator->isPermissionGranted (line 79)
5	App\Permissions\AccessValidator->isAccessAllowedOnAction (line 59)
6	App\EventSubscriber\AuthenticationSubscriber->onKernelController (line 76)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 31)

0.22 ms
(9.81%)

SELECT * FROM system_session WHERE identifier = ?

Parameters:

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 300)
2	App\Session\SessionHandler->getSessionData (line 118)
3	App\Session\SessionHandler->isLoggedAndValidSession (line 84)
4	App\EventSubscriber\AuthenticationSubscriber->onKernelController (line 59)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 31)

0.16 ms
(7.28%)

SELECT COUNT(*) FROM attendance_activity_requests WHERE user_id = ? AND status = 'pending'

Parameters:

[
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  attendance_activity_requests
WHERE
  user_id = ?
  AND status = 'pending'

SELECT COUNT(*) FROM attendance_activity_requests WHERE user_id = 46 AND status = 'pending';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\AttendanceController->notifications (line 432)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 31)

0.14 ms
(6.29%)

SELECT MAX(updated_at) FROM attendance_activity_requests WHERE user_id = ? AND status IN ('approved','rejected')

Parameters:

[
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(updated_at)
FROM
  attendance_activity_requests
WHERE
  user_id = ?
  AND status IN ('approved', 'rejected')

SELECT MAX(updated_at) FROM attendance_activity_requests WHERE user_id = 46 AND status IN ('approved','rejected');

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\AttendanceController->notifications (line 440)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 31)

0.13 ms
(5.79%)

SELECT MAX(updated_at) FROM vacation_requests WHERE user_id = ? AND status IN ('approved','rejected')

Parameters:

[
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(updated_at)
FROM
  vacation_requests
WHERE
  user_id = ?
  AND status IN ('approved', 'rejected')

SELECT MAX(updated_at) FROM vacation_requests WHERE user_id = 46 AND status IN ('approved','rejected');

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\AttendanceController->notifications (line 436)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 31)

0.08 ms
(3.62%)

SELECT * FROM system_users

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Data\User->loadUsersIfNeeded (line 266)
3	App\Data\User->get (line 49)
4	App\Session\SessionHandler->isLoggedAndValidSession (line 93)
5	App\EventSubscriber\AuthenticationSubscriber->onKernelController (line 59)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 31)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://intranet.makro-nd.cz/api/attendance/notifications

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

Entities Mapping