2.82 ms (19.52%)
3
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 ;
Copy
2.77 ms (19.15%)
1
"COMMIT"
1.36 ms (9.41%)
1
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 "
]
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' );
Copy
1.33 ms (9.18%)
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 = ? LIMIT 1
Parameters :
[
"dev-wowza.valt.forasoft.com "
]
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 ;
Copy
0.98 ms (6.76%)
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 = ? 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 ;
Copy
0.93 ms (6.46%)
1
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
Parameters :
[
1
"2026-10-10 17:48:18 "
]
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 ;
Copy
0.89 ms (6.16%)
1
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
Parameters :
[
"2026-10-10 17:48:18 "
]
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 ;
Copy
0.84 ms (5.81%)
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 ;
Copy
0.79 ms (5.49%)
1
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' );
Copy
0.69 ms (4.75%)
1
UPDATE wowza_storage SET size = ? , available_size = ? , reserved_size = ? WHERE id = ?
Parameters :
[
"474453426176 "
"92836638720 "
"0 "
5031
]
UPDATE wowza_storage SET size = '474453426176' , available_size = '92836638720' , reserved_size = '0' WHERE id = 5031 ;
Copy
0.67 ms (4.64%)
1
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' );
Copy
0.39 ms (2.68%)
1
"START TRANSACTION"
"START TRANSACTION" ;
Copy