Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.username_canonical AS username_canonical_2,
  u0_.password AS password_3,
  u0_.email AS email_4,
  u0_.email_canonical AS email_canonical_5,
  u0_.enabled AS enabled_6,
  u0_.salt AS salt_7,
  u0_.roles AS roles_8,
  u0_.userType AS userType_9,
  u0_.ldapScript AS ldapScript_10,
  u0_.ldapDomain AS ldapDomain_11,
  u0_.ldapDN AS ldapDN_12,
  u0_.display_name AS display_name_13,
  u0_.card_number AS card_number_14,
  u0_.pin AS pin_15,
  u0_.control_type AS control_type_16,
  u0_.disabled_access AS disabled_access_17,
  u0_.ldap_extra_data AS ldap_extra_data_18,
  u0_.login_failures AS login_failures_19,
  u0_.login_block_start AS login_block_start_20,
  u0_.last_passwords AS last_passwords_21,
  u0_.last_change_password_date AS last_change_password_date_22,
  u0_.night_mode AS night_mode_23,
  u0_.auto_pause_record_when_comment AS auto_pause_record_when_comment_24,
  u0_.auto_play_audio_comments AS auto_play_audio_comments_25,
  u0_.notification_sound AS notification_sound_26,
  u0_.avatar_filename AS avatar_filename_27,
  u0_.avatar_original_filename AS avatar_original_filename_28,
  u0_.emails_alerts_enabled AS emails_alerts_enabled_29,
  u0_.zoom_step AS zoom_step_30,
  u0_.api_token AS api_token_31,
  u0_.deleted_at AS deleted_at_32,
  u1_.id AS id_33,
  u1_.name AS name_34,
  u1_.record_duration AS record_duration_35,
  u1_.record_duration_selection_type AS record_duration_selection_type_36,
  u1_.io_record_name AS io_record_name_37,
  u1_.search_results AS search_results_38,
  u1_.room_sorting_order AS room_sorting_order_39,
  u1_.disabled_access AS disabled_access_40,
  u1_.default_review_view AS default_review_view_41,
  u1_.default_schedule_view AS default_schedule_view_42,
  u1_.default_report_view AS default_report_view_43,
  u1_.default_review_list_period AS default_review_list_period_44,
  u1_.deleted_users_video_access AS deleted_users_video_access_45,
  u1_.without_groups_users_video_access AS without_groups_users_video_access_46,
  u1_.deleted_at AS deleted_at_47,
  u2_.id AS id_48,
  r3_.id AS id_49,
  r3_.name AS name_50,
  r3_.enabled AS enabled_51,
  u0_.group_id AS group_id_52,
  u0_.ldap_sync_id AS ldap_sync_id_53,
  u0_.saml_config_id AS saml_config_id_54,
  u0_.zoom_account_id AS zoom_account_id_55,
  u0_.expiration_from_id AS expiration_from_id_56,
  u0_.r_access_id AS r_access_id_57,
  u1_.comment_template_id AS comment_template_id_58,
  u1_.marker_template_id AS marker_template_id_59,
  u1_.info_template_id AS info_template_id_60,
  u1_.evaluation_template_id AS evaluation_template_id_61,
  u1_.default_retention_rule_id AS default_retention_rule_id_62,
  u1_.expiration_from_id AS expiration_from_id_63,
  u1_.container_id AS container_id_64,
  u1_.r_access_id AS r_access_id_65,
  u2_.user_group_id AS user_group_id_66,
  u2_.right_id AS right_id_67
FROM
  users u0_
  LEFT JOIN user_groups u1_ ON u0_.group_id = u1_.id
  LEFT JOIN user_groups_rights u2_ ON u1_.id = u2_.user_group_id
  LEFT JOIN rights r3_ ON u2_.right_id = r3_.id
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.username_canonical AS username_canonical_2, u0_.password AS password_3, u0_.email AS email_4, u0_.email_canonical AS email_canonical_5, u0_.enabled AS enabled_6, u0_.salt AS salt_7, u0_.roles AS roles_8, u0_.userType AS userType_9, u0_.ldapScript AS ldapScript_10, u0_.ldapDomain AS ldapDomain_11, u0_.ldapDN AS ldapDN_12, u0_.display_name AS display_name_13, u0_.card_number AS card_number_14, u0_.pin AS pin_15, u0_.control_type AS control_type_16, u0_.disabled_access AS disabled_access_17, u0_.ldap_extra_data AS ldap_extra_data_18, u0_.login_failures AS login_failures_19, u0_.login_block_start AS login_block_start_20, u0_.last_passwords AS last_passwords_21, u0_.last_change_password_date AS last_change_password_date_22, u0_.night_mode AS night_mode_23, u0_.auto_pause_record_when_comment AS auto_pause_record_when_comment_24, u0_.auto_play_audio_comments AS auto_play_audio_comments_25, u0_.notification_sound AS notification_sound_26, u0_.avatar_filename AS avatar_filename_27, u0_.avatar_original_filename AS avatar_original_filename_28, u0_.emails_alerts_enabled AS emails_alerts_enabled_29, u0_.zoom_step AS zoom_step_30, u0_.api_token AS api_token_31, u0_.deleted_at AS deleted_at_32, u1_.id AS id_33, u1_.name AS name_34, u1_.record_duration AS record_duration_35, u1_.record_duration_selection_type AS record_duration_selection_type_36, u1_.io_record_name AS io_record_name_37, u1_.search_results AS search_results_38, u1_.room_sorting_order AS room_sorting_order_39, u1_.disabled_access AS disabled_access_40, u1_.default_review_view AS default_review_view_41, u1_.default_schedule_view AS default_schedule_view_42, u1_.default_report_view AS default_report_view_43, u1_.default_review_list_period AS default_review_list_period_44, u1_.deleted_users_video_access AS deleted_users_video_access_45, u1_.without_groups_users_video_access AS without_groups_users_video_access_46, u1_.deleted_at AS deleted_at_47, u2_.id AS id_48, r3_.id AS id_49, r3_.name AS name_50, r3_.enabled AS enabled_51, u0_.group_id AS group_id_52, u0_.ldap_sync_id AS ldap_sync_id_53, u0_.saml_config_id AS saml_config_id_54, u0_.zoom_account_id AS zoom_account_id_55, u0_.expiration_from_id AS expiration_from_id_56, u0_.r_access_id AS r_access_id_57, u1_.comment_template_id AS comment_template_id_58, u1_.marker_template_id AS marker_template_id_59, u1_.info_template_id AS info_template_id_60, u1_.evaluation_template_id AS evaluation_template_id_61, u1_.default_retention_rule_id AS default_retention_rule_id_62, u1_.expiration_from_id AS expiration_from_id_63, u1_.container_id AS container_id_64, u1_.r_access_id AS r_access_id_65, u2_.user_group_id AS user_group_id_66, u2_.right_id AS right_id_67 FROM users u0_ LEFT JOIN user_groups u1_ ON u0_.group_id = u1_.id LEFT JOIN user_groups_rights u2_ ON u1_.id = u2_.user_group_id LEFT JOIN rights r3_ ON u2_.right_id = r3_.id WHERE u0_.id = 3;

SELECT
  t0.notifications_enabled AS notifications_enabled_1,
  t0.notifications_frequency AS notifications_frequency_2,
  t0.notifications_schedule_enabled AS notifications_schedule_enabled_3,
  t0.notifications_cron_last_execute AS notifications_cron_last_execute_4,
  t0.user_id AS user_id_5
FROM
  user_email_settings t0
WHERE
  t0.user_id = ?

SELECT t0.notifications_enabled AS notifications_enabled_1, t0.notifications_frequency AS notifications_frequency_2, t0.notifications_schedule_enabled AS notifications_schedule_enabled_3, t0.notifications_cron_last_execute AS notifications_cron_last_execute_4, t0.user_id AS user_id_5 FROM user_email_settings t0 WHERE t0.user_id = 3;

SELECT
  t0.id AS id_1
FROM
  restrict_access t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM restrict_access t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.week_day AS week_day_2,
  t0.enabled AS enabled_3,
  t0.start_time AS start_time_4,
  t0.end_time AS end_time_5,
  t0.full_day AS full_day_6,
  t0.r_access_id AS r_access_id_7
FROM
  restrict_access_week_day t0
WHERE
  t0.r_access_id = ?

SELECT t0.id AS id_1, t0.week_day AS week_day_2, t0.enabled AS enabled_3, t0.start_time AS start_time_4, t0.end_time AS end_time_5, t0.full_day AS full_day_6, t0.r_access_id AS r_access_id_7 FROM restrict_access_week_day t0 WHERE t0.r_access_id = 5;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.expiration_from AS expiration_from_3
FROM
  expiration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.expiration_from AS expiration_from_3 FROM expiration t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.expiration_from AS expiration_from_3
FROM
  expiration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.expiration_from AS expiration_from_3 FROM expiration t0 WHERE t0.id = 4;

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.upload_link_id AS upload_link_id_20,
  t0.meeting_id AS meeting_id_21,
  t0.recording_id AS recording_id_22
FROM
  record t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'record', 'motion', 'upload', 'zoom'
  )
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.upload_link_id AS upload_link_id_20, t0.meeting_id AS meeting_id_21, t0.recording_id AS recording_id_22 FROM record t0 WHERE t0.id = '46bdddcb-66df-4c43-aece-9d7152ecca55' AND t0.type IN ('record', 'motion', 'upload', 'zoom') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.record_duration AS record_duration_3,
  t0.record_duration_selection_type AS record_duration_selection_type_4,
  t0.io_record_name AS io_record_name_5,
  t0.search_results AS search_results_6,
  t0.room_sorting_order AS room_sorting_order_7,
  t0.disabled_access AS disabled_access_8,
  t0.default_review_view AS default_review_view_9,
  t0.default_schedule_view AS default_schedule_view_10,
  t0.default_report_view AS default_report_view_11,
  t0.default_review_list_period AS default_review_list_period_12,
  t0.deleted_users_video_access AS deleted_users_video_access_13,
  t0.without_groups_users_video_access AS without_groups_users_video_access_14,
  t0.deleted_at AS deleted_at_15,
  t0.comment_template_id AS comment_template_id_16,
  t0.marker_template_id AS marker_template_id_17,
  t0.info_template_id AS info_template_id_18,
  t0.evaluation_template_id AS evaluation_template_id_19,
  t0.default_retention_rule_id AS default_retention_rule_id_20,
  t0.expiration_from_id AS expiration_from_id_21,
  t0.container_id AS container_id_22,
  t0.r_access_id AS r_access_id_23
FROM
  user_groups t0
  INNER JOIN additional_user_groups ON t0.id = additional_user_groups.group_id
WHERE
  additional_user_groups.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.record_duration AS record_duration_3, t0.record_duration_selection_type AS record_duration_selection_type_4, t0.io_record_name AS io_record_name_5, t0.search_results AS search_results_6, t0.room_sorting_order AS room_sorting_order_7, t0.disabled_access AS disabled_access_8, t0.default_review_view AS default_review_view_9, t0.default_schedule_view AS default_schedule_view_10, t0.default_report_view AS default_report_view_11, t0.default_review_list_period AS default_review_list_period_12, t0.deleted_users_video_access AS deleted_users_video_access_13, t0.without_groups_users_video_access AS without_groups_users_video_access_14, t0.deleted_at AS deleted_at_15, t0.comment_template_id AS comment_template_id_16, t0.marker_template_id AS marker_template_id_17, t0.info_template_id AS info_template_id_18, t0.evaluation_template_id AS evaluation_template_id_19, t0.default_retention_rule_id AS default_retention_rule_id_20, t0.expiration_from_id AS expiration_from_id_21, t0.container_id AS container_id_22, t0.r_access_id AS r_access_id_23 FROM user_groups t0 INNER JOIN additional_user_groups ON t0.id = additional_user_groups.group_id WHERE additional_user_groups.user_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.c_id AS c_id_3
FROM
  container t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.c_id AS c_id_3 FROM container t0 WHERE t0.id = 1;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.provider AS provider_2,
  t0_.model AS model_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5,
  t0_.published_at AS published_at_6,
  t1_.id AS id_7,
  t1_.section_key AS section_key_8,
  t1_.label AS label_9,
  t1_.position AS position_10,
  t1_.content AS content_11,
  t1_.status AS status_12,
  t1_.regenerated_at AS regenerated_at_13,
  t1_.dispatched_at AS dispatched_at_14,
  t1_.attempts AS attempts_15,
  t1_.generation AS generation_16,
  t1_.version AS version_17,
  t1_.tokens_in AS tokens_in_18,
  t1_.tokens_out AS tokens_out_19,
  t1_.latency_ms AS latency_ms_20,
  t2_.id AS id_21,
  t2_.name AS name_22,
  t2_.version AS version_23,
  t2_.archived AS archived_24,
  t2_.created_at AS created_at_25,
  t0_.record_id AS record_id_26,
  t0_.source_transcript_id AS source_transcript_id_27,
  t0_.template_id AS template_id_28,
  t0_.published_by_id AS published_by_id_29,
  t1_.summary_id AS summary_id_30
FROM
  transcript_summary t0_
  LEFT JOIN transcript_summary_section t1_ ON t0_.id = t1_.summary_id
  LEFT JOIN transcript_summary_template t2_ ON t0_.template_id = t2_.id
WHERE
  t0_.record_id = ?
ORDER BY
  t1_.position ASC

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.provider AS provider_2, t0_.model AS model_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.published_at AS published_at_6, t1_.id AS id_7, t1_.section_key AS section_key_8, t1_.label AS label_9, t1_.position AS position_10, t1_.content AS content_11, t1_.status AS status_12, t1_.regenerated_at AS regenerated_at_13, t1_.dispatched_at AS dispatched_at_14, t1_.attempts AS attempts_15, t1_.generation AS generation_16, t1_.version AS version_17, t1_.tokens_in AS tokens_in_18, t1_.tokens_out AS tokens_out_19, t1_.latency_ms AS latency_ms_20, t2_.id AS id_21, t2_.name AS name_22, t2_.version AS version_23, t2_.archived AS archived_24, t2_.created_at AS created_at_25, t0_.record_id AS record_id_26, t0_.source_transcript_id AS source_transcript_id_27, t0_.template_id AS template_id_28, t0_.published_by_id AS published_by_id_29, t1_.summary_id AS summary_id_30 FROM transcript_summary t0_ LEFT JOIN transcript_summary_section t1_ ON t0_.id = t1_.summary_id LEFT JOIN transcript_summary_template t2_ ON t0_.template_id = t2_.id WHERE t0_.record_id = '46bdddcb-66df-4c43-aece-9d7152ecca55' ORDER BY t1_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.section_key AS section_key_1,
  t0_.label AS label_2,
  t0_.position AS position_3,
  t0_.content AS content_4,
  t0_.status AS status_5,
  t0_.regenerated_at AS regenerated_at_6,
  t0_.dispatched_at AS dispatched_at_7,
  t0_.attempts AS attempts_8,
  t0_.generation AS generation_9,
  t0_.version AS version_10,
  t0_.tokens_in AS tokens_in_11,
  t0_.tokens_out AS tokens_out_12,
  t0_.latency_ms AS latency_ms_13,
  t1_.id AS id_14,
  t1_.ordinal AS ordinal_15,
  t1_.transcript_offset_start_ms AS transcript_offset_start_ms_16,
  t1_.transcript_offset_end_ms AS transcript_offset_end_ms_17,
  t1_.quote AS quote_18,
  t0_.summary_id AS summary_id_19,
  t1_.section_id AS section_id_20
FROM
  transcript_summary_section t0_
  LEFT JOIN transcript_summary_citation t1_ ON t0_.id = t1_.section_id
WHERE
  t0_.summary_id = ?
ORDER BY
  t1_.ordinal ASC

SELECT t0_.id AS id_0, t0_.section_key AS section_key_1, t0_.label AS label_2, t0_.position AS position_3, t0_.content AS content_4, t0_.status AS status_5, t0_.regenerated_at AS regenerated_at_6, t0_.dispatched_at AS dispatched_at_7, t0_.attempts AS attempts_8, t0_.generation AS generation_9, t0_.version AS version_10, t0_.tokens_in AS tokens_in_11, t0_.tokens_out AS tokens_out_12, t0_.latency_ms AS latency_ms_13, t1_.id AS id_14, t1_.ordinal AS ordinal_15, t1_.transcript_offset_start_ms AS transcript_offset_start_ms_16, t1_.transcript_offset_end_ms AS transcript_offset_end_ms_17, t1_.quote AS quote_18, t0_.summary_id AS summary_id_19, t1_.section_id AS section_id_20 FROM transcript_summary_section t0_ LEFT JOIN transcript_summary_citation t1_ ON t0_.id = t1_.section_id WHERE t0_.summary_id = '01a130a3-ca98-7256-9aa0-4c536888c0c6' ORDER BY t1_.ordinal ASC;

SELECT
  t0.id AS id_1,
  t0.section_key AS section_key_2,
  t0.label AS label_3,
  t0.position AS position_4,
  t0.system_prompt AS system_prompt_5,
  t0.user_prompt_template AS user_prompt_template_6,
  t0.reduce_system_prompt AS reduce_system_prompt_7,
  t0.output_schema AS output_schema_8,
  t0.max_tokens AS max_tokens_9,
  t0.template_id AS template_id_10
FROM
  transcript_summary_template_section t0
WHERE
  t0.template_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.section_key AS section_key_2, t0.label AS label_3, t0.position AS position_4, t0.system_prompt AS system_prompt_5, t0.user_prompt_template AS user_prompt_template_6, t0.reduce_system_prompt AS reduce_system_prompt_7, t0.output_schema AS output_schema_8, t0.max_tokens AS max_tokens_9, t0.template_id AS template_id_10 FROM transcript_summary_template_section t0 WHERE t0.template_id = '01a0f2ea-7d16-7382-b71b-44f30260a0cd' ORDER BY t0.position 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_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

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;

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