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.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.rtmp_username AS rtmp_username_14,
  t0.rtmp_password AS rtmp_password_15,
  t0.transcription_service_id AS transcription_service_id_16,
  t0.sync_id AS sync_id_17,
  t18.stream AS stream_19,
  t18.video AS video_20,
  t18.video_prefix AS video_prefix_21,
  t18.wowza_id AS wowza_id_22,
  t23.active AS active_24,
  t23.wowza_id AS wowza_id_25,
  t23.storage_id AS storage_id_26
FROM
  wowza t0
  LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id
  LEFT JOIN wowza_status t23 ON t23.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.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.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 = 14 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.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.rtmp_username AS rtmp_username_14,
  t0.rtmp_password AS rtmp_password_15,
  t0.transcription_service_id AS transcription_service_id_16,
  t0.sync_id AS sync_id_17,
  t18.stream AS stream_19,
  t18.video AS video_20,
  t18.video_prefix AS video_prefix_21,
  t18.wowza_id AS wowza_id_22,
  t23.active AS active_24,
  t23.wowza_id AS wowza_id_25,
  t23.storage_id AS storage_id_26
FROM
  wowza t0
  LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id
  LEFT JOIN wowza_status t23 ON t23.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.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.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
  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.rtmp_username AS rtmp_username_14,
  t0.rtmp_password AS rtmp_password_15,
  t0.transcription_service_id AS transcription_service_id_16,
  t0.sync_id AS sync_id_17,
  t18.stream AS stream_19,
  t18.video AS video_20,
  t18.video_prefix AS video_prefix_21,
  t18.wowza_id AS wowza_id_22,
  t23.active AS active_24,
  t23.wowza_id AS wowza_id_25,
  t23.storage_id AS storage_id_26
FROM
  wowza t0
  LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id
  LEFT JOIN wowza_status t23 ON t23.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.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.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id WHERE t0.address = 'dev-wowza.valt.forasoft.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordinal AS ordinal_3,
  t0.record_id AS record_id_4,
  t0.type,
  t0.duration AS duration_5,
  t0.rotation AS rotation_6,
  t0.audio AS audio_7,
  t0.status_id AS status_id_8,
  t0.camera_id AS camera_id_9,
  t0.audio_device_id AS audio_device_id_10
FROM
  record_video t0
WHERE
  t0.id = ?
  AND t0.record_id = ?
  AND t0.type IN (
    'unplayable', 'playable', 'camera'
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordinal AS ordinal_3, t0.record_id AS record_id_4, t0.type, t0.duration AS duration_5, t0.rotation AS rotation_6, t0.audio AS audio_7, t0.status_id AS status_id_8, t0.camera_id AS camera_id_9, t0.audio_device_id AS audio_device_id_10 FROM record_video t0 WHERE t0.id = '7721f5a0-71f9-4a97-8ee2-e0ebcc0c73de' AND t0.record_id = '08a4f216-a588-4e67-9f9d-650f1b0d733c' AND t0.type IN ('unplayable', 'playable', 'camera') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_title AS name_title_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.status AS status_6,
  t0.`trigger` AS trigger_7,
  t0.preview_ready AS preview_ready_8,
  t0.started_at AS started_at_9,
  t0.grid AS grid_10,
  t0.template_data AS template_data_11,
  t0.created_by_id AS created_by_id_12,
  t0.container_id AS container_id_13,
  t0.retention_rule_id AS retention_rule_id_14,
  t0.template_id AS template_id_15,
  t0.sharing_link_id AS sharing_link_id_16,
  t0.type,
  t0.room_id AS room_id_17,
  t0.last_motion AS last_motion_18,
  t0.upload_sequence AS upload_sequence_19,
  t0.meeting_id AS meeting_id_20,
  t0.recording_id AS recording_id_21
FROM
  record t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'record', 'motion', 'upload', 'zoom'
  )

SELECT t0.id AS id_1, t0.name_title AS name_title_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.deleted_at AS deleted_at_5, t0.status AS status_6, t0.`trigger` AS trigger_7, t0.preview_ready AS preview_ready_8, t0.started_at AS started_at_9, t0.grid AS grid_10, t0.template_data AS template_data_11, t0.created_by_id AS created_by_id_12, t0.container_id AS container_id_13, t0.retention_rule_id AS retention_rule_id_14, t0.template_id AS template_id_15, t0.sharing_link_id AS sharing_link_id_16, t0.type, t0.room_id AS room_id_17, t0.last_motion AS last_motion_18, t0.upload_sequence AS upload_sequence_19, t0.meeting_id AS meeting_id_20, t0.recording_id AS recording_id_21 FROM record t0 WHERE t0.id = '08a4f216-a588-4e67-9f9d-650f1b0d733c' AND t0.type IN ('record', 'motion', 'upload', 'zoom');

SELECT
  t0.id AS id_1,
  t0.type,
  t0.current_frame AS current_frame_2,
  t0.total_frames AS total_frames_3
FROM
  record_video_status t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'created', 'conversion', 'ready',
    'paused'
  )

SELECT t0.id AS id_1, t0.type, t0.current_frame AS current_frame_2, t0.total_frames AS total_frames_3 FROM record_video_status t0 WHERE t0.id = 'dbd4c4c4-ec65-40ab-a28a-95cd6beb9bb5' AND t0.type IN ('created', 'conversion', 'ready', 'paused');

SELECT
  t0.id AS id_1,
  t0.filepath AS filepath_2,
  t0.status AS status_3,
  t0.progress AS progress_4,
  t0.video_id AS video_id_5
FROM
  transcripts t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.status AS status_3, t0.progress AS progress_4, t0.video_id AS video_id_5 FROM transcripts t0 WHERE t0.video_id = '7721f5a0-71f9-4a97-8ee2-e0ebcc0c73de';

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.progress AS progress_3,
  t0.config_snapshot AS config_snapshot_4,
  t0.video_id AS video_id_5
FROM
  ocr_job t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.progress AS progress_3, t0.config_snapshot AS config_snapshot_4, t0.video_id AS video_id_5 FROM ocr_job t0 WHERE t0.video_id = '7721f5a0-71f9-4a97-8ee2-e0ebcc0c73de';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  record_video_status
SET
  current_frame = ?
WHERE
  id = ?

UPDATE record_video_status SET current_frame = 70049 WHERE id = 'dbd4c4c4-ec65-40ab-a28a-95cd6beb9bb5';

"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.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.rtmp_username AS rtmp_username_14,
  t0.rtmp_password AS rtmp_password_15,
  t0.transcription_service_id AS transcription_service_id_16,
  t0.sync_id AS sync_id_17,
  t18.stream AS stream_19,
  t18.video AS video_20,
  t18.video_prefix AS video_prefix_21,
  t18.wowza_id AS wowza_id_22,
  t23.active AS active_24,
  t23.wowza_id AS wowza_id_25,
  t23.storage_id AS storage_id_26
FROM
  wowza t0
  LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id
  LEFT JOIN wowza_status t23 ON t23.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.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id;