POST https://dev.valt.forasoft.com/wowza/api/updateDeviceStatus

Query Metrics

23 Database Queries
17 Different statements
29.68 ms Query time
2 Invalid entities
27 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_llm_vision AS has_llm_vision_15, t0.has_live_asr AS has_live_asr_16, t0.scene_signer_trusted_until AS scene_signer_trusted_until_17, t0.rtmp_username AS rtmp_username_18, t0.rtmp_password AS rtmp_password_19, t0.llm_available AS llm_available_20, t0.llm_signer_trusted_until AS llm_signer_trusted_until_21, t0.dysfluency_available AS dysfluency_available_22, t0.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_23, t0.translation_available AS translation_available_24, t0.translation_signer_trusted_until AS translation_signer_trusted_until_25, t0.transcription_service_id AS transcription_service_id_26, t0.sync_id AS sync_id_27, t28.stream AS stream_29, t28.video AS video_30, t28.video_prefix AS video_prefix_31, t28.wowza_id AS wowza_id_32, t33.active AS active_34, t33.wowza_id AS wowza_id_35, t33.storage_id AS storage_id_36 FROM wowza t0 LEFT JOIN wowza_routing t28 ON t28.wowza_id = t0.id LEFT JOIN wowza_status t33 ON t33.wowza_id = t0.id
Parameters:
[]
2 1.17 ms
SELECT t0.id AS id_1, t0.provider_type, t0.name AS name_2, t0.aws_access_key_id AS aws_access_key_id_3, t0.aws_secret_key AS aws_secret_key_4, t0.aws_s3_bucket_name AS aws_s3_bucket_name_5, t0.aws_region AS aws_region_6, t0.host_wowza_id AS host_wowza_id_7 FROM transcription_service t0 WHERE t0.id = ? AND t0.provider_type IN ('aws', 'local')
Parameters:
[
  23
]
3 1.12 ms
SELECT DISTINCT w0_.media_server_id AS media_server_id_0 FROM workload_job w1_ INNER JOIN workload_execution_target w0_ ON (w0_.id = w1_.execution_target_id) AND w0_.kind IN ('media_server') WHERE (w1_.status IN (?, ?, ?) OR (w1_.status = ? AND w1_.auto_retry_attempts > 0)) AND w1_.type IN ('dysfluency')
Parameters:
[
  "starting"
  "awaiting_confirmation"
  "running"
  "queued"
]
4 1.00 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_llm_vision AS has_llm_vision_14, w0_.has_live_asr AS has_live_asr_15, w0_.scene_signer_trusted_until AS scene_signer_trusted_until_16, w0_.rtmp_username AS rtmp_username_17, w0_.rtmp_password AS rtmp_password_18, w0_.llm_available AS llm_available_19, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_20, w0_.dysfluency_available AS dysfluency_available_21, w0_.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_22, w0_.translation_available AS translation_available_23, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_24, w0_.transcription_service_id AS transcription_service_id_25, w0_.sync_id AS sync_id_26 FROM wowza w0_ WHERE w0_.dysfluency_available = 1 OR w0_.dysfluency_signer_trusted_until > ? ORDER BY w0_.id ASC
Parameters:
[
  "2026-11-11 01:11:51"
]
5 1.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_llm_vision AS has_llm_vision_15, t0.has_live_asr AS has_live_asr_16, t0.scene_signer_trusted_until AS scene_signer_trusted_until_17, t0.rtmp_username AS rtmp_username_18, t0.rtmp_password AS rtmp_password_19, t0.llm_available AS llm_available_20, t0.llm_signer_trusted_until AS llm_signer_trusted_until_21, t0.dysfluency_available AS dysfluency_available_22, t0.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_23, t0.translation_available AS translation_available_24, t0.translation_signer_trusted_until AS translation_signer_trusted_until_25, t0.transcription_service_id AS transcription_service_id_26, t0.sync_id AS sync_id_27, t28.stream AS stream_29, t28.video AS video_30, t28.video_prefix AS video_prefix_31, t28.wowza_id AS wowza_id_32, t33.active AS active_34, t33.wowza_id AS wowza_id_35, t33.storage_id AS storage_id_36 FROM wowza t0 LEFT JOIN wowza_routing t28 ON t28.wowza_id = t0.id LEFT JOIN wowza_status t33 ON t33.wowza_id = t0.id
Parameters:
[]
6 0.74 ms
SELECT t0.id AS id_1, t0.host_wowza_id AS host_wowza_id_2, t0.provider_type FROM transcription_service t0 WHERE t0.provider_type IN ('local')
Parameters:
[]
7 0.94 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_llm_vision AS has_llm_vision_14, w0_.has_live_asr AS has_live_asr_15, w0_.scene_signer_trusted_until AS scene_signer_trusted_until_16, w0_.rtmp_username AS rtmp_username_17, w0_.rtmp_password AS rtmp_password_18, w0_.llm_available AS llm_available_19, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_20, w0_.dysfluency_available AS dysfluency_available_21, w0_.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_22, w0_.translation_available AS translation_available_23, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_24, w0_.transcription_service_id AS transcription_service_id_25, w0_.sync_id AS sync_id_26 FROM wowza w0_ WHERE w0_.translation_available = ? OR w0_.translation_signer_trusted_until > ? ORDER BY w0_.name ASC
Parameters:
[
  1
  "2026-11-11 01:11:51"
]
8 0.86 ms
SELECT DISTINCT w0_.selected_llm_host_id AS selected_llm_host_id_0 FROM workload_job w0_ WHERE (w0_.status IN (?, ?, ?) AND w0_.selected_llm_host_id IS NOT NULL) AND w0_.type IN ('summary')
Parameters:
[
  "starting"
  "awaiting_confirmation"
  "running"
]
9 1.12 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_llm_vision AS has_llm_vision_14, w0_.has_live_asr AS has_live_asr_15, w0_.scene_signer_trusted_until AS scene_signer_trusted_until_16, w0_.rtmp_username AS rtmp_username_17, w0_.rtmp_password AS rtmp_password_18, w0_.llm_available AS llm_available_19, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_20, w0_.dysfluency_available AS dysfluency_available_21, w0_.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_22, w0_.translation_available AS translation_available_23, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_24, w0_.transcription_service_id AS transcription_service_id_25, w0_.sync_id AS sync_id_26 FROM wowza w0_ WHERE w0_.llm_available = 1 OR w0_.llm_signer_trusted_until > ? ORDER BY w0_.name ASC
Parameters:
[
  "2026-11-11 01:11:51"
]
10 1.16 ms
SELECT DISTINCT w0_.media_server_id AS media_server_id_0 FROM workload_job w1_ INNER JOIN workload_execution_target w0_ ON (w0_.id = w1_.execution_target_id) AND w0_.kind IN ('media_server') WHERE (w1_.status IN (?, ?, ?) OR (w1_.status = ? AND w1_.auto_retry_attempts > 0)) AND w1_.type IN ('dysfluency')
Parameters:
[
  "starting"
  "awaiting_confirmation"
  "running"
  "queued"
]
11 1.05 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_llm_vision AS has_llm_vision_14, w0_.has_live_asr AS has_live_asr_15, w0_.scene_signer_trusted_until AS scene_signer_trusted_until_16, w0_.rtmp_username AS rtmp_username_17, w0_.rtmp_password AS rtmp_password_18, w0_.llm_available AS llm_available_19, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_20, w0_.dysfluency_available AS dysfluency_available_21, w0_.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_22, w0_.translation_available AS translation_available_23, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_24, w0_.transcription_service_id AS transcription_service_id_25, w0_.sync_id AS sync_id_26 FROM wowza w0_ WHERE w0_.dysfluency_available = 1 OR w0_.dysfluency_signer_trusted_until > ? ORDER BY w0_.id ASC
Parameters:
[
  "2026-11-11 01:11:51"
]
12 1.26 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_llm_vision AS has_llm_vision_14, w0_.has_live_asr AS has_live_asr_15, w0_.scene_signer_trusted_until AS scene_signer_trusted_until_16, w0_.rtmp_username AS rtmp_username_17, w0_.rtmp_password AS rtmp_password_18, w0_.llm_available AS llm_available_19, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_20, w0_.dysfluency_available AS dysfluency_available_21, w0_.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_22, w0_.translation_available AS translation_available_23, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_24, w0_.transcription_service_id AS transcription_service_id_25, w0_.sync_id AS sync_id_26 FROM wowza w0_ WHERE w0_.llm_available = ? OR w0_.scene_signer_trusted_until > ? ORDER BY w0_.name ASC
Parameters:
[
  1
  "2026-11-11 01:11:51"
]
13 1.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_llm_vision AS has_llm_vision_15, t0.has_live_asr AS has_live_asr_16, t0.scene_signer_trusted_until AS scene_signer_trusted_until_17, t0.rtmp_username AS rtmp_username_18, t0.rtmp_password AS rtmp_password_19, t0.llm_available AS llm_available_20, t0.llm_signer_trusted_until AS llm_signer_trusted_until_21, t0.dysfluency_available AS dysfluency_available_22, t0.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_23, t0.translation_available AS translation_available_24, t0.translation_signer_trusted_until AS translation_signer_trusted_until_25, t0.transcription_service_id AS transcription_service_id_26, t0.sync_id AS sync_id_27, t28.stream AS stream_29, t28.video AS video_30, t28.video_prefix AS video_prefix_31, t28.wowza_id AS wowza_id_32, t33.active AS active_34, t33.wowza_id AS wowza_id_35, t33.storage_id AS storage_id_36 FROM wowza t0 LEFT JOIN wowza_routing t28 ON t28.wowza_id = t0.id LEFT JOIN wowza_status t33 ON t33.wowza_id = t0.id WHERE t0.address = ? LIMIT 1
Parameters:
[
  "dev-wowza.valt.forasoft.com"
]
14 0.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.controller AS controller_3, t0.io_last_call AS io_last_call_4, t0.io_last_port_called AS io_last_port_called_5, t0.io_configured AS io_configured_6, t0.has_audio AS has_audio_7, t0.control_enabled AS control_enabled_8, t0.status AS status_9, t0.camera_has_been_online AS camera_has_been_online_10, t0.pending_alert_token AS pending_alert_token_11, t12.device_id AS device_id_13, t0.wowza_id AS wowza_id_14, t0.type, t0.brand AS brand_15, t0.ip AS ip_16, t0.port AS port_17, t0.rtsp_port AS rtsp_port_18, t0.use_ssl AS use_ssl_19, t0.username AS username_20, t0.password AS password_21, t0.ptz_supported AS ptz_supported_22, t0.rtsp_url AS rtsp_url_23, t0.rtsp_url AS rtsp_url_24, t0.linked_user_id AS linked_user_id_25 FROM device t0 LEFT JOIN device_ocr t12 ON t12.device_id = t0.id WHERE t0.id = ? AND t0.type IN ('camera', 'beam', 'roam', 'controller', 'stream')
Parameters:
[
  "1478"
]
15 0.41 ms
"START TRANSACTION"
Parameters:
[]
16 0.69 ms
UPDATE device SET status = ? WHERE id = ?
Parameters:
[
  "online"
  1478
]
17 5.52 ms
"COMMIT"
Parameters:
[]
18 1.37 ms
SELECT t0.id AS id_1, t0.date_time_format AS date_time_format_2, t0.time_format AS time_format_3, t0.comment_overlay_font_size AS comment_overlay_font_size_4, t0.streaming_method AS streaming_method_5, t0.smtp_server_address AS smtp_server_address_6, t0.smtp_server_port AS smtp_server_port_7, t0.email_encryption AS email_encryption_8, t0.email_username AS email_username_9, t0.email_password AS email_password_10, t0.email_from_name AS email_from_name_11, t0.email_bcc_email AS email_bcc_email_12, t0.email_from_address AS email_from_address_13, t0.camera_alert_delay_seconds AS camera_alert_delay_seconds_14, t0.notifications_enabled AS notifications_enabled_15, t0.alerts_enabled AS alerts_enabled_16, t0.schedule_enabled AS schedule_enabled_17, t0.scene_recognition_enabled AS scene_recognition_enabled_18, t0.info_template_id AS info_template_id_19 FROM global_settings t0 LIMIT 1
Parameters:
[]
19 0.49 ms
"START TRANSACTION"
Parameters:
[]
20 0.91 ms
UPDATE device SET pending_alert_token = ? WHERE id = ?
Parameters:
[
  "c32ada6e-0bef-484e-9bd3-a0e72ef9926c"
  1478
]
21 3.19 ms
"COMMIT"
Parameters:
[]
22 0.81 ms
SELECT t0.id AS id_1, t0.motion_detection_enabled AS motion_detection_enabled_2, t0.room_id AS room_id_3, t0.video_id AS video_id_4, t0.audio_id AS audio_id_5 FROM device_source t0 WHERE t0.video_id = ?
Parameters:
[
  1478
]
23 1.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_llm_vision AS has_llm_vision_15, t0.has_live_asr AS has_live_asr_16, t0.scene_signer_trusted_until AS scene_signer_trusted_until_17, t0.rtmp_username AS rtmp_username_18, t0.rtmp_password AS rtmp_password_19, t0.llm_available AS llm_available_20, t0.llm_signer_trusted_until AS llm_signer_trusted_until_21, t0.dysfluency_available AS dysfluency_available_22, t0.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_23, t0.translation_available AS translation_available_24, t0.translation_signer_trusted_until AS translation_signer_trusted_until_25, t0.transcription_service_id AS transcription_service_id_26, t0.sync_id AS sync_id_27, t28.stream AS stream_29, t28.video AS video_30, t28.video_prefix AS video_prefix_31, t28.wowza_id AS wowza_id_32, t33.active AS active_34, t33.wowza_id AS wowza_id_35, t33.storage_id AS storage_id_36 FROM wowza t0 LEFT JOIN wowza_routing t28 ON t28.wowza_id = t0.id LEFT JOIN wowza_status t33 ON t33.wowza_id = t0.id
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
Valt\CamBundle\Entity\DeviceSource 5
Valt\CamBundle\Entity\Room 5
Valt\CamBundle\Entity\Wowza 3
Valt\CamBundle\Entity\Wowza\Routing 3
Valt\CamBundle\Entity\Wowza\Status 3
Valt\CamBundle\Entity\TranscriptionService 2
Valt\CamBundle\Entity\Wowza\Storage 1
Valt\CamBundle\Entity\WowzaSync 1
Valt\CamBundle\Entity\Device\Device 1
Valt\OCR\Domain\Entity\OcrConfig 1
Valt\BasicBundle\Entity\GlobalSettings 1
Valt\Template\Domain\Entity\Template 1

Entities Mapping

Class Mapping errors
Valt\CamBundle\Entity\CallbackSidecar No errors.
Valt\CamBundle\Entity\Wowza
  • The field Valt\CamBundle\Entity\Wowza#rooms is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Room#wowza does not contain the required 'inversedBy: "rooms"' attribute.
  • The field Valt\CamBundle\Entity\Wowza#videoLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Record\Video\VideoLocation#wowza does not contain the required 'inversedBy: "videoLocations"' attribute.
  • The field Valt\CamBundle\Entity\Wowza#audioRecordings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Audio#wowza does not contain the required 'inversedBy: "audioRecordings"' attribute.
Valt\CamBundle\Entity\TranscriptionService No errors.
Valt\CamBundle\Entity\WowzaSync No errors.
Valt\CamBundle\Entity\Wowza\Routing No errors.
Valt\CamBundle\Entity\Wowza\Status No errors.
Valt\CamBundle\Entity\Wowza\Storage No errors.
Valt\CamBundle\Entity\Room
  • The field Valt\CamBundle\Entity\Room#groups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\UserBundle\Entity\UserGroup#rooms does not contain the required 'inversedBy: "groups"' attribute.
Valt\CamBundle\Entity\Device\Device No errors.
Valt\CamBundle\Entity\TranscriptionService\AwsTranscriptionService No errors.
Valt\CamBundle\Entity\TranscriptionService\LocalTranscriptionService No errors.
Valt\UserBundle\Entity\UserGroup No errors.
Valt\CamBundle\Entity\Record\Video\VideoLocation No errors.
Valt\CamBundle\Entity\Audio No errors.
Valt\Workload\Domain\Entity\Job No errors.
Valt\Workload\Domain\Entity\DysfluencyAnalysisJob No errors.
Valt\Workload\Domain\Entity\ExecutionTarget No errors.
Valt\Workload\Domain\Entity\MediaServerExecutionTarget No errors.
Valt\Workload\Domain\Entity\SummarySectionJob No errors.
Valt\OCR\Domain\Entity\OcrConfig No errors.
Valt\CamBundle\Entity\Device\Camera\Camera No errors.
Valt\CamBundle\Entity\Device\MobileDevice\MobileDevice No errors.
Valt\CamBundle\Entity\Device\MobileDevice\Beam No errors.
Valt\CamBundle\Entity\Device\MobileDevice\Roam No errors.
Valt\CamBundle\Entity\Device\Controller No errors.
Valt\CamBundle\Entity\Device\Stream No errors.
Valt\UserBundle\Entity\User No errors.
Valt\CamBundle\Entity\DeviceSource No errors.
Valt\CamBundle\Entity\Preset No errors.
Valt\CamBundle\Entity\Alert No errors.
Valt\OCR\Domain\Entity\OcrArea No errors.
Valt\BasicBundle\Entity\GlobalSettings No errors.
Valt\Template\Domain\Entity\Template No errors.