Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

4.13 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.29 ms
(31.21%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.uuid AS uuid_3, t0.is_active AS is_active_4, t0.public_key AS public_key_5, t0.public_key_alg AS public_key_alg_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.sites_id AS sites_id_9, t0.organization_id AS organization_id_10 FROM display t0 WHERE t0.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uuid AS uuid_3,
  t0.is_active AS is_active_4,
  t0.public_key AS public_key_5,
  t0.public_key_alg AS public_key_alg_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.sites_id AS sites_id_9,
  t0.organization_id AS organization_id_10
FROM
  display t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uuid AS uuid_3, t0.is_active AS is_active_4, t0.public_key AS public_key_5, t0.public_key_alg AS public_key_alg_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.sites_id AS sites_id_9, t0.organization_id AS organization_id_10 FROM display t0 WHERE t0.id = 16;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Security\DisplayJwtUserProvider->loadUserByIdentifier (line 37)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
8	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->{closure:Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator::authenticate():105} (line 105)
9	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 101)
10	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
11	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
22	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.76 ms
(18.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.valid_from AS valid_from_4, t0.valid_to AS valid_to_5, t0.is_active AS is_active_6, t0.playback_mode AS playback_mode_7, t0.screen_ratio AS screen_ratio_8, t0.screen_orientation AS screen_orientation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.organization_id AS organization_id_12 FROM planning t0 INNER JOIN planning_display ON t0.id = planning_display.planning_id WHERE planning_display.display_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.valid_from AS valid_from_4,
  t0.valid_to AS valid_to_5,
  t0.is_active AS is_active_6,
  t0.playback_mode AS playback_mode_7,
  t0.screen_ratio AS screen_ratio_8,
  t0.screen_orientation AS screen_orientation_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.organization_id AS organization_id_12
FROM
  planning t0
  INNER JOIN planning_display ON t0.id = planning_display.planning_id
WHERE
  planning_display.display_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.valid_from AS valid_from_4, t0.valid_to AS valid_to_5, t0.is_active AS is_active_6, t0.playback_mode AS playback_mode_7, t0.screen_ratio AS screen_ratio_8, t0.screen_orientation AS screen_orientation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.organization_id AS organization_id_12 FROM planning t0 INNER JOIN planning_display ON t0.id = planning_display.planning_id WHERE planning_display.display_id = 16;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->contains (line 68)
7	Doctrine\ORM\PersistentCollection->contains (line 361)
8	App\Service\DisplayTelemetryService->findDisplayPlanning (line 243)
9	App\Service\DisplayTelemetryService->applyStatusPayload (line 154)
10	App\Service\DisplayTelemetryService->markSeen (line 41)
11	App\Controller\Api\DisplayTelemetryController->heartbeat (line 37)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.73 ms
(17.68%)

"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 432)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Service\DisplayTelemetryService->markSeen (line 44)
5	App\Controller\Api\DisplayTelemetryController->heartbeat (line 37)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.65 ms
(15.72%)

UPDATE display_status SET last_seen_at = ?, device_time = ?, current_media_started_at = ?, playback_position_ms = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-07-17 17:39:08"
  "2026-07-17 19:39:08"
  "2026-07-17 19:39:00"
  8017
  "2026-07-17 17:39:08"
  6
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  display_status
SET
  last_seen_at = ?,
  device_time = ?,
  current_media_started_at = ?,
  playback_position_ms = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE display_status SET last_seen_at = '2026-07-17 17:39:08', device_time = '2026-07-17 19:39:08', current_media_started_at = '2026-07-17 19:39:00', playback_position_ms = 8017, updated_at = '2026-07-17 17:39:08' WHERE id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1139)
4	Doctrine\ORM\UnitOfWork->commit (line 407)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\DisplayTelemetryService->markSeen (line 44)
7	App\Controller\Api\DisplayTelemetryController->heartbeat (line 37)
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 5)

0.53 ms
(12.77%)

SELECT t0.id AS id_1, t0.last_seen_at AS last_seen_at_2, t0.last_sync_at AS last_sync_at_3, t0.app_version AS app_version_4, t0.platform AS platform_5, t0.device_timezone AS device_timezone_6, t0.device_time AS device_time_7, t0.current_media_started_at AS current_media_started_at_8, t0.playback_position_ms AS playback_position_ms_9, t0.is_playing AS is_playing_10, t0.last_checksum AS last_checksum_11, t0.ip_address AS ip_address_12, t0.user_agent AS user_agent_13, t0.screen_width AS screen_width_14, t0.screen_height AS screen_height_15, t0.storage_free_bytes AS storage_free_bytes_16, t0.storage_total_bytes AS storage_total_bytes_17, t0.last_error_code AS last_error_code_18, t0.last_error_message AS last_error_message_19, t0.last_error_at AS last_error_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.display_id AS display_id_23, t0.current_planning_id AS current_planning_id_24, t0.current_media_id AS current_media_id_25 FROM display_status t0 WHERE t0.display_id = ? LIMIT 1

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.last_seen_at AS last_seen_at_2,
  t0.last_sync_at AS last_sync_at_3,
  t0.app_version AS app_version_4,
  t0.platform AS platform_5,
  t0.device_timezone AS device_timezone_6,
  t0.device_time AS device_time_7,
  t0.current_media_started_at AS current_media_started_at_8,
  t0.playback_position_ms AS playback_position_ms_9,
  t0.is_playing AS is_playing_10,
  t0.last_checksum AS last_checksum_11,
  t0.ip_address AS ip_address_12,
  t0.user_agent AS user_agent_13,
  t0.screen_width AS screen_width_14,
  t0.screen_height AS screen_height_15,
  t0.storage_free_bytes AS storage_free_bytes_16,
  t0.storage_total_bytes AS storage_total_bytes_17,
  t0.last_error_code AS last_error_code_18,
  t0.last_error_message AS last_error_message_19,
  t0.last_error_at AS last_error_at_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.display_id AS display_id_23,
  t0.current_planning_id AS current_planning_id_24,
  t0.current_media_id AS current_media_id_25
FROM
  display_status t0
WHERE
  t0.display_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_seen_at AS last_seen_at_2, t0.last_sync_at AS last_sync_at_3, t0.app_version AS app_version_4, t0.platform AS platform_5, t0.device_timezone AS device_timezone_6, t0.device_time AS device_time_7, t0.current_media_started_at AS current_media_started_at_8, t0.playback_position_ms AS playback_position_ms_9, t0.is_playing AS is_playing_10, t0.last_checksum AS last_checksum_11, t0.ip_address AS ip_address_12, t0.user_agent AS user_agent_13, t0.screen_width AS screen_width_14, t0.screen_height AS screen_height_15, t0.storage_free_bytes AS storage_free_bytes_16, t0.storage_total_bytes AS storage_total_bytes_17, t0.last_error_code AS last_error_code_18, t0.last_error_message AS last_error_message_19, t0.last_error_at AS last_error_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.display_id AS display_id_23, t0.current_planning_id AS current_planning_id_24, t0.current_media_id AS current_media_id_25 FROM display_status t0 WHERE t0.display_id = 16 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\DisplayTelemetryService->getOrCreateStatus (line 108)
5	App\Service\DisplayTelemetryService->markSeen (line 26)
6	App\Controller\Api\DisplayTelemetryController->heartbeat (line 37)
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 5)

0.17 ms
(4.16%)

"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 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\DisplayTelemetryService->markSeen (line 44)
4	App\Controller\Api\DisplayTelemetryController->heartbeat (line 37)
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 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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Display	1
App\Entity\Organization	1
App\Entity\DisplayStatus	1
App\Entity\Planning	1
App\Entity\Media	1

Entities Mapping

Class	Mapping errors
App\Entity\Display	No errors.
App\Entity\Site	No errors.
App\Entity\Organization	No errors.
App\Entity\DisplayChallenge	No errors.
App\Entity\Planning	No errors.
App\Entity\DisplayStatus	No errors.
App\Entity\Media	No errors.
App\Entity\MediaMapping	No errors.
App\Entity\PlanningSchedule	No errors.

Symfony Profiler

POST https://dev.pixplay.fr/api/display/heartbeat

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping