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

Query Metrics

6 Database Queries
6 Different statements
4.62 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 0.47 ms
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
]
2 0.47 ms
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
]
3 0.43 ms
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
]
4 0.11 ms
"START TRANSACTION"
Parameters:
[]
5 1.00 ms
UPDATE display_status SET last_seen_at = ?, device_time = ?, current_media_started_at = ?, playback_position_ms = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-07-17 15:34:08"
  "2026-07-17 17:34:08"
  "2026-07-17 17:34:00"
  8024
  "2026-07-17 15:34:08"
  6
]
6 2.14 ms
"COMMIT"
Parameters:
[]

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.