Symfony Profiler

Query Metrics

31 Database Queries

5 Different statements

51.55 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

28.07 ms
(54.45%)

SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "android-acc3e605-9dfd-4348-b3a7-0cc50bfd38c5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.platform AS platform_3,
  t0.app_version AS app_version_4,
  t0.os_version AS os_version_5,
  t0.locale AS locale_6,
  t0.external_user_id AS external_user_id_7,
  t0.app AS app_8,
  t0.apns_env AS apns_env_9,
  t0.is_active AS is_active_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.last_seen_at AS last_seen_at_13
FROM
  push_devices t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.platform AS platform_3, t0.app_version AS app_version_4, t0.os_version AS os_version_5, t0.locale AS locale_6, t0.external_user_id AS external_user_id_7, t0.app AS app_8, t0.apns_env AS apns_env_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_seen_at AS last_seen_at_13 FROM push_devices t0 WHERE t0.token = 'android-acc3e605-9dfd-4348-b3a7-0cc50bfd38c5' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Repository\PushDeviceRepository->findByToken (line 22)
4	App\Controller\NotificationApiController->poll (line 40)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 7)

20.08 ms
(38.95%)

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 100

Parameters:

[
  19
  "pending"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.error AS error_2,
  p0_.created_at AS created_at_3,
  p0_.delivered_at AS delivered_at_4,
  p0_.seen_at AS seen_at_5,
  p0_.notification_id AS notification_id_6,
  p0_.device_id AS device_id_7
FROM
  push_deliveries p0_
WHERE
  p0_.device_id = ?
  AND p0_.status = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  100

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.error AS error_2, p0_.created_at AS created_at_3, p0_.delivered_at AS delivered_at_4, p0_.seen_at AS seen_at_5, p0_.notification_id AS notification_id_6, p0_.device_id AS device_id_7 FROM push_deliveries p0_ WHERE p0_.device_id = 19 AND p0_.status = 'pending' ORDER BY p0_.created_at DESC LIMIT 100;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PushDeliveryRepository->findPendingForDevice (line 33)
7	App\Controller\NotificationApiController->poll (line 49)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 7)

1.55 ms
(3.00%)

UPDATE push_devices SET last_seen_at = ? WHERE id = ?

Parameters:

[
  "2026-06-07 23:55:18"
  19
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  push_devices
SET
  last_seen_at = ?
WHERE
  id = ?

UPDATE push_devices SET last_seen_at = '2026-06-07 23:55:18' WHERE id = 19;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 536)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 422)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1283)
4	Doctrine\ORM\UnitOfWork->commit (line 456)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Controller\NotificationApiController->poll (line 46)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 7)

1.01 ms
(1.97%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 480)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Controller\NotificationApiController->poll (line 46)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 7)

0.84 ms
(1.63%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 430)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Controller\NotificationApiController->poll (line 46)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 7)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\PushDevice	1

Entities Mapping

Class	Mapping errors
App\Entity\PushDevice	No errors.
App\Entity\PushDelivery	No errors.
App\Entity\PushNotification	No errors.

Symfony Profiler

POST https://pushapp.webground.bg/api/notifications/poll

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping