Symfony Profiler

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_live_asr AS has_live_asr_15,
  t0.rtmp_username AS rtmp_username_16,
  t0.rtmp_password AS rtmp_password_17,
  t0.llm_available AS llm_available_18,
  t0.llm_signer_trusted_until AS llm_signer_trusted_until_19,
  t0.translation_available AS translation_available_20,
  t0.translation_signer_trusted_until AS translation_signer_trusted_until_21,
  t0.transcription_service_id AS transcription_service_id_22,
  t0.sync_id AS sync_id_23,
  t24.stream AS stream_25,
  t24.video AS video_26,
  t24.video_prefix AS video_prefix_27,
  t24.wowza_id AS wowza_id_28,
  t29.active AS active_30,
  t29.wowza_id AS wowza_id_31,
  t29.storage_id AS storage_id_32
FROM
  wowza t0
  LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id
  LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id

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_live_asr AS has_live_asr_15, t0.rtmp_username AS rtmp_username_16, t0.rtmp_password AS rtmp_password_17, t0.llm_available AS llm_available_18, t0.llm_signer_trusted_until AS llm_signer_trusted_until_19, t0.translation_available AS translation_available_20, t0.translation_signer_trusted_until AS translation_signer_trusted_until_21, t0.transcription_service_id AS transcription_service_id_22, t0.sync_id AS sync_id_23, t24.stream AS stream_25, t24.video AS video_26, t24.video_prefix AS video_prefix_27, t24.wowza_id AS wowza_id_28, t29.active AS active_30, t29.wowza_id AS wowza_id_31, t29.storage_id AS storage_id_32 FROM wowza t0 LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id;

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')

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 = 23 AND t0.provider_type IN ('aws', 'local');

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_live_asr AS has_live_asr_15,
  t0.rtmp_username AS rtmp_username_16,
  t0.rtmp_password AS rtmp_password_17,
  t0.llm_available AS llm_available_18,
  t0.llm_signer_trusted_until AS llm_signer_trusted_until_19,
  t0.translation_available AS translation_available_20,
  t0.translation_signer_trusted_until AS translation_signer_trusted_until_21,
  t0.transcription_service_id AS transcription_service_id_22,
  t0.sync_id AS sync_id_23,
  t24.stream AS stream_25,
  t24.video AS video_26,
  t24.video_prefix AS video_prefix_27,
  t24.wowza_id AS wowza_id_28,
  t29.active AS active_30,
  t29.wowza_id AS wowza_id_31,
  t29.storage_id AS storage_id_32
FROM
  wowza t0
  LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id
  LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id

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_live_asr AS has_live_asr_15, t0.rtmp_username AS rtmp_username_16, t0.rtmp_password AS rtmp_password_17, t0.llm_available AS llm_available_18, t0.llm_signer_trusted_until AS llm_signer_trusted_until_19, t0.translation_available AS translation_available_20, t0.translation_signer_trusted_until AS translation_signer_trusted_until_21, t0.transcription_service_id AS transcription_service_id_22, t0.sync_id AS sync_id_23, t24.stream AS stream_25, t24.video AS video_26, t24.video_prefix AS video_prefix_27, t24.wowza_id AS wowza_id_28, t29.active AS active_30, t29.wowza_id AS wowza_id_31, t29.storage_id AS storage_id_32 FROM wowza t0 LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id;

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')

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');

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_live_asr AS has_live_asr_14,
  w0_.rtmp_username AS rtmp_username_15,
  w0_.rtmp_password AS rtmp_password_16,
  w0_.llm_available AS llm_available_17,
  w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18,
  w0_.translation_available AS translation_available_19,
  w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20,
  w0_.transcription_service_id AS transcription_service_id_21,
  w0_.sync_id AS sync_id_22
FROM
  wowza w0_
WHERE
  w0_.translation_available = ?
  OR w0_.translation_signer_trusted_until > ?
ORDER BY
  w0_.name ASC

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_live_asr AS has_live_asr_14, w0_.rtmp_username AS rtmp_username_15, w0_.rtmp_password AS rtmp_password_16, w0_.llm_available AS llm_available_17, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18, w0_.translation_available AS translation_available_19, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20, w0_.transcription_service_id AS transcription_service_id_21, w0_.sync_id AS sync_id_22 FROM wowza w0_ WHERE w0_.translation_available = 1 OR w0_.translation_signer_trusted_until > '2026-10-10 17:48:18' ORDER BY w0_.name ASC;

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')

SELECT DISTINCT w0_.selected_llm_host_id AS selected_llm_host_id_0 FROM workload_job w0_ WHERE (w0_.status IN ('starting', 'awaiting_confirmation', 'running') AND w0_.selected_llm_host_id IS NOT NULL) AND w0_.type IN ('summary');

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_live_asr AS has_live_asr_14,
  w0_.rtmp_username AS rtmp_username_15,
  w0_.rtmp_password AS rtmp_password_16,
  w0_.llm_available AS llm_available_17,
  w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18,
  w0_.translation_available AS translation_available_19,
  w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20,
  w0_.transcription_service_id AS transcription_service_id_21,
  w0_.sync_id AS sync_id_22
FROM
  wowza w0_
  LEFT JOIN wowza_status w1_ ON w0_.id = w1_.wowza_id
WHERE
  (
    w0_.llm_available = 1
    AND w1_.active = 1
  )
  OR w0_.llm_signer_trusted_until > ?
ORDER BY
  w0_.name ASC

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_live_asr AS has_live_asr_14, w0_.rtmp_username AS rtmp_username_15, w0_.rtmp_password AS rtmp_password_16, w0_.llm_available AS llm_available_17, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18, w0_.translation_available AS translation_available_19, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20, w0_.transcription_service_id AS transcription_service_id_21, w0_.sync_id AS sync_id_22 FROM wowza w0_ LEFT JOIN wowza_status w1_ ON w0_.id = w1_.wowza_id WHERE (w0_.llm_available = 1 AND w1_.active = 1) OR w0_.llm_signer_trusted_until > '2026-10-10 17:48:18' ORDER BY w0_.name ASC;

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_live_asr AS has_live_asr_15,
  t0.rtmp_username AS rtmp_username_16,
  t0.rtmp_password AS rtmp_password_17,
  t0.llm_available AS llm_available_18,
  t0.llm_signer_trusted_until AS llm_signer_trusted_until_19,
  t0.translation_available AS translation_available_20,
  t0.translation_signer_trusted_until AS translation_signer_trusted_until_21,
  t0.transcription_service_id AS transcription_service_id_22,
  t0.sync_id AS sync_id_23,
  t24.stream AS stream_25,
  t24.video AS video_26,
  t24.video_prefix AS video_prefix_27,
  t24.wowza_id AS wowza_id_28,
  t29.active AS active_30,
  t29.wowza_id AS wowza_id_31,
  t29.storage_id AS storage_id_32
FROM
  wowza t0
  LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id
  LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id
WHERE
  t0.address = ?
LIMIT
  1

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_live_asr AS has_live_asr_15, t0.rtmp_username AS rtmp_username_16, t0.rtmp_password AS rtmp_password_17, t0.llm_available AS llm_available_18, t0.llm_signer_trusted_until AS llm_signer_trusted_until_19, t0.translation_available AS translation_available_20, t0.translation_signer_trusted_until AS translation_signer_trusted_until_21, t0.transcription_service_id AS transcription_service_id_22, t0.sync_id AS sync_id_23, t24.stream AS stream_25, t24.video AS video_26, t24.video_prefix AS video_prefix_27, t24.wowza_id AS wowza_id_28, t29.active AS active_30, t29.wowza_id AS wowza_id_31, t29.storage_id AS storage_id_32 FROM wowza t0 LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id WHERE t0.address = 'dev-wowza.valt.forasoft.com' LIMIT 1;

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 = ?

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 = 5031;

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

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 = 70 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  wowza_storage
SET
  size = ?,
  available_size = ?,
  reserved_size = ?
WHERE
  id = ?

UPDATE wowza_storage SET size = '474453426176', available_size = '92836638720', reserved_size = '0' WHERE id = 5031;

"COMMIT"

"COMMIT";

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_live_asr AS has_live_asr_15,
  t0.rtmp_username AS rtmp_username_16,
  t0.rtmp_password AS rtmp_password_17,
  t0.llm_available AS llm_available_18,
  t0.llm_signer_trusted_until AS llm_signer_trusted_until_19,
  t0.translation_available AS translation_available_20,
  t0.translation_signer_trusted_until AS translation_signer_trusted_until_21,
  t0.transcription_service_id AS transcription_service_id_22,
  t0.sync_id AS sync_id_23,
  t24.stream AS stream_25,
  t24.video AS video_26,
  t24.video_prefix AS video_prefix_27,
  t24.wowza_id AS wowza_id_28,
  t29.active AS active_30,
  t29.wowza_id AS wowza_id_31,
  t29.storage_id AS storage_id_32
FROM
  wowza t0
  LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id
  LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id

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_live_asr AS has_live_asr_15, t0.rtmp_username AS rtmp_username_16, t0.rtmp_password AS rtmp_password_17, t0.llm_available AS llm_available_18, t0.llm_signer_trusted_until AS llm_signer_trusted_until_19, t0.translation_available AS translation_available_20, t0.translation_signer_trusted_until AS translation_signer_trusted_until_21, t0.transcription_service_id AS transcription_service_id_22, t0.sync_id AS sync_id_23, t24.stream AS stream_25, t24.video AS video_26, t24.video_prefix AS video_prefix_27, t24.wowza_id AS wowza_id_28, t29.active AS active_30, t29.wowza_id AS wowza_id_31, t29.storage_id AS storage_id_32 FROM wowza t0 LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id;