POST https://ivsdevac3.ipivs.info/wowza/api/sendWowzaState

Query Metrics

19 Database Queries
15 Different statements
21.69 ms Query time
2 Invalid entities
5 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.93 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 0.66 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:
[
  2
]
3 0.96 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 0.68 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-10-12 10:35:43"
]
5 0.58 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.41 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.64 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-10-12 10:35:43"
]
8 0.70 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 0.63 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-10-12 10:35:43"
]
10 0.94 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 0.65 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-10-12 10:35:43"
]
12 0.60 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-10-12 10:35:43"
]
13 0.71 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:
[
  "ivsdevac3.ipivs.info"
]
14 0.38 ms
SELECT t0.id AS id_1, t0.size AS size_2, t0.available_size AS available_size_3, t0.reserved_size AS reserved_size_4 FROM wowza_storage t0 WHERE t0.id = ?
Parameters:
[
  21
]
15 0.48 ms
SELECT 1 AS sclr_0 FROM room_motion_detection r0_ INNER JOIN rooms r1_ ON r0_.room_id = r1_.id WHERE r0_.suspended_at IS NOT NULL AND r0_.enabled_by_id IS NOT NULL AND r1_.wowza_id = ? LIMIT 1
Parameters:
[
  1
]
16 0.16 ms
"START TRANSACTION"
Parameters:
[]
17 0.36 ms
UPDATE wowza_storage SET size = ?, available_size = ?, reserved_size = ? WHERE id = ?
Parameters:
[
  "209129086976"
  "68407996416"
  "0"
  21
]
18 10.63 ms
"COMMIT"
Parameters:
[]
19 0.59 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\Wowza 1
Valt\CamBundle\Entity\TranscriptionService 1
Valt\CamBundle\Entity\Wowza\Routing 1
Valt\CamBundle\Entity\Wowza\Status 1
Valt\CamBundle\Entity\Wowza\Storage 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\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\CamBundle\Entity\Room\MotionDetection No errors.