1
1.43 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 . address AS address_7 , t0 . storage_folder AS storage_folder_8 , t0 . use_ssl AS use_ssl_9 , t0 . use_s3 AS use_s3_10 , t0 . is_default AS is_default_11 , t0 . licensor AS licensor_12 , t0 . has_gpu AS has_gpu_13 , t0 . has_translation AS has_translation_14 , t0 . rtmp_username AS rtmp_username_15 , t0 . rtmp_password AS rtmp_password_16 , t0 . transcription_service_id AS transcription_service_id_17 , t0 . sync_id AS sync_id_18 , t19 . stream AS stream_20 , t19 . video AS video_21 , t19 . video_prefix AS video_prefix_22 , t19 . wowza_id AS wowza_id_23 , t24 . active AS active_25 , t24 . wowza_id AS wowza_id_26 , t24 . storage_id AS storage_id_27 FROM wowza t0 LEFT JOIN wowza_routing t19 ON t19 . wowza_id = t0 . id LEFT JOIN wowza_status t24 ON t24 . 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 . address AS address_7 , t0 . storage_folder AS storage_folder_8 , t0 . use_ssl AS use_ssl_9 , t0 . use_s3 AS use_s3_10 , t0 . is_default AS is_default_11 , t0 . licensor AS licensor_12 , t0 . has_gpu AS has_gpu_13 , t0 . has_translation AS has_translation_14 , t0 . rtmp_username AS rtmp_username_15 , t0 . rtmp_password AS rtmp_password_16 , t0 . transcription_service_id AS transcription_service_id_17 , t0 . sync_id AS sync_id_18 , t19 . stream AS stream_20 , t19 . video AS video_21 , t19 . video_prefix AS video_prefix_22 , t19 . wowza_id AS wowza_id_23 , t24 . active AS active_25 , t24 . wowza_id AS wowza_id_26 , t24 . storage_id AS storage_id_27 FROM wowza t0 LEFT JOIN wowza_routing t19 ON t19 . wowza_id = t0 . id LEFT JOIN wowza_status t24 ON t24 . wowza_id = t0 . id ;
Copy
2
1.45 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' )
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 = 1 AND t0 . provider_type IN ('aws' , 'local' );
Copy
3
1.50 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 . address AS address_7 , t0 . storage_folder AS storage_folder_8 , t0 . use_ssl AS use_ssl_9 , t0 . use_s3 AS use_s3_10 , t0 . is_default AS is_default_11 , t0 . licensor AS licensor_12 , t0 . has_gpu AS has_gpu_13 , t0 . has_translation AS has_translation_14 , t0 . rtmp_username AS rtmp_username_15 , t0 . rtmp_password AS rtmp_password_16 , t0 . transcription_service_id AS transcription_service_id_17 , t0 . sync_id AS sync_id_18 , t19 . stream AS stream_20 , t19 . video AS video_21 , t19 . video_prefix AS video_prefix_22 , t19 . wowza_id AS wowza_id_23 , t24 . active AS active_25 , t24 . wowza_id AS wowza_id_26 , t24 . storage_id AS storage_id_27 FROM wowza t0 LEFT JOIN wowza_routing t19 ON t19 . wowza_id = t0 . id LEFT JOIN wowza_status t24 ON t24 . 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 . address AS address_7 , t0 . storage_folder AS storage_folder_8 , t0 . use_ssl AS use_ssl_9 , t0 . use_s3 AS use_s3_10 , t0 . is_default AS is_default_11 , t0 . licensor AS licensor_12 , t0 . has_gpu AS has_gpu_13 , t0 . has_translation AS has_translation_14 , t0 . rtmp_username AS rtmp_username_15 , t0 . rtmp_password AS rtmp_password_16 , t0 . transcription_service_id AS transcription_service_id_17 , t0 . sync_id AS sync_id_18 , t19 . stream AS stream_20 , t19 . video AS video_21 , t19 . video_prefix AS video_prefix_22 , t19 . wowza_id AS wowza_id_23 , t24 . active AS active_25 , t24 . wowza_id AS wowza_id_26 , t24 . storage_id AS storage_id_27 FROM wowza t0 LEFT JOIN wowza_routing t19 ON t19 . wowza_id = t0 . id LEFT JOIN wowza_status t24 ON t24 . wowza_id = t0 . id ;
Copy
4
0.82 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' )
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
5
1.34 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_ . address AS address_6 , w0_ . storage_folder AS storage_folder_7 , w0_ . use_ssl AS use_ssl_8 , w0_ . use_s3 AS use_s3_9 , w0_ . is_default AS is_default_10 , w0_ . licensor AS licensor_11 , w0_ . has_gpu AS has_gpu_12 , w0_ . has_translation AS has_translation_13 , w0_ . rtmp_username AS rtmp_username_14 , w0_ . rtmp_password AS rtmp_password_15 , w0_ . transcription_service_id AS transcription_service_id_16 , w0_ . sync_id AS sync_id_17 FROM wowza w0_ WHERE w0_ . has_translation = ? 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_ . address AS address_6 , w0_ . storage_folder AS storage_folder_7 , w0_ . use_ssl AS use_ssl_8 , w0_ . use_s3 AS use_s3_9 , w0_ . is_default AS is_default_10 , w0_ . licensor AS licensor_11 , w0_ . has_gpu AS has_gpu_12 , w0_ . has_translation AS has_translation_13 , w0_ . rtmp_username AS rtmp_username_14 , w0_ . rtmp_password AS rtmp_password_15 , w0_ . transcription_service_id AS transcription_service_id_16 , w0_ . sync_id AS sync_id_17 FROM wowza w0_ WHERE w0_ . has_translation = 1 ORDER BY w0_ . name ASC ;
Copy
6
1.33 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 . address AS address_7 , t0 . storage_folder AS storage_folder_8 , t0 . use_ssl AS use_ssl_9 , t0 . use_s3 AS use_s3_10 , t0 . is_default AS is_default_11 , t0 . licensor AS licensor_12 , t0 . has_gpu AS has_gpu_13 , t0 . has_translation AS has_translation_14 , t0 . rtmp_username AS rtmp_username_15 , t0 . rtmp_password AS rtmp_password_16 , t0 . transcription_service_id AS transcription_service_id_17 , t0 . sync_id AS sync_id_18 , t19 . stream AS stream_20 , t19 . video AS video_21 , t19 . video_prefix AS video_prefix_22 , t19 . wowza_id AS wowza_id_23 , t24 . active AS active_25 , t24 . wowza_id AS wowza_id_26 , t24 . storage_id AS storage_id_27 FROM wowza t0 LEFT JOIN wowza_routing t19 ON t19 . wowza_id = t0 . id LEFT JOIN wowza_status t24 ON t24 . wowza_id = t0 . id WHERE t0 . address = ? LIMIT 1
Parameters :
[
"ivsdevac3.ipivs.info "
]
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 . address AS address_7 , t0 . storage_folder AS storage_folder_8 , t0 . use_ssl AS use_ssl_9 , t0 . use_s3 AS use_s3_10 , t0 . is_default AS is_default_11 , t0 . licensor AS licensor_12 , t0 . has_gpu AS has_gpu_13 , t0 . has_translation AS has_translation_14 , t0 . rtmp_username AS rtmp_username_15 , t0 . rtmp_password AS rtmp_password_16 , t0 . transcription_service_id AS transcription_service_id_17 , t0 . sync_id AS sync_id_18 , t19 . stream AS stream_20 , t19 . video AS video_21 , t19 . video_prefix AS video_prefix_22 , t19 . wowza_id AS wowza_id_23 , t24 . active AS active_25 , t24 . wowza_id AS wowza_id_26 , t24 . storage_id AS storage_id_27 FROM wowza t0 LEFT JOIN wowza_routing t19 ON t19 . wowza_id = t0 . id LEFT JOIN wowza_status t24 ON t24 . wowza_id = t0 . id WHERE t0 . address = 'ivsdevac3.ipivs.info' LIMIT 1 ;
Copy
7
1.08 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 = ?
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 = 18 ;
Copy
8
0.52 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
9
1.17 ms
UPDATE wowza_storage SET size = ? , available_size = ? , reserved_size = ? WHERE id = ?
Parameters :
[
"209129086976 "
"129326276608 "
"0 "
18
]
UPDATE wowza_storage SET size = '209129086976' , available_size = '129326276608' , reserved_size = '0' WHERE id = 18 ;
Copy
10
4.51 ms
"COMMIT"
11
1.43 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 . address AS address_7 , t0 . storage_folder AS storage_folder_8 , t0 . use_ssl AS use_ssl_9 , t0 . use_s3 AS use_s3_10 , t0 . is_default AS is_default_11 , t0 . licensor AS licensor_12 , t0 . has_gpu AS has_gpu_13 , t0 . has_translation AS has_translation_14 , t0 . rtmp_username AS rtmp_username_15 , t0 . rtmp_password AS rtmp_password_16 , t0 . transcription_service_id AS transcription_service_id_17 , t0 . sync_id AS sync_id_18 , t19 . stream AS stream_20 , t19 . video AS video_21 , t19 . video_prefix AS video_prefix_22 , t19 . wowza_id AS wowza_id_23 , t24 . active AS active_25 , t24 . wowza_id AS wowza_id_26 , t24 . storage_id AS storage_id_27 FROM wowza t0 LEFT JOIN wowza_routing t19 ON t19 . wowza_id = t0 . id LEFT JOIN wowza_status t24 ON t24 . 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 . address AS address_7 , t0 . storage_folder AS storage_folder_8 , t0 . use_ssl AS use_ssl_9 , t0 . use_s3 AS use_s3_10 , t0 . is_default AS is_default_11 , t0 . licensor AS licensor_12 , t0 . has_gpu AS has_gpu_13 , t0 . has_translation AS has_translation_14 , t0 . rtmp_username AS rtmp_username_15 , t0 . rtmp_password AS rtmp_password_16 , t0 . transcription_service_id AS transcription_service_id_17 , t0 . sync_id AS sync_id_18 , t19 . stream AS stream_20 , t19 . video AS video_21 , t19 . video_prefix AS video_prefix_22 , t19 . wowza_id AS wowza_id_23 , t24 . active AS active_25 , t24 . wowza_id AS wowza_id_26 , t24 . storage_id AS storage_id_27 FROM wowza t0 LEFT JOIN wowza_routing t19 ON t19 . wowza_id = t0 . id LEFT JOIN wowza_status t24 ON t24 . wowza_id = t0 . id ;
Copy