Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.record_duration AS record_duration_2,
  u0_.record_duration_selection_type AS record_duration_selection_type_3,
  u0_.io_record_name AS io_record_name_4,
  u0_.search_results AS search_results_5,
  u0_.room_sorting_order AS room_sorting_order_6,
  u0_.disabled_access AS disabled_access_7,
  u0_.default_review_view AS default_review_view_8,
  u0_.default_schedule_view AS default_schedule_view_9,
  u0_.default_report_view AS default_report_view_10,
  u0_.default_review_list_period AS default_review_list_period_11,
  u0_.deleted_users_video_access AS deleted_users_video_access_12,
  u0_.without_groups_users_video_access AS without_groups_users_video_access_13,
  u0_.deleted_at AS deleted_at_14,
  u0_.comment_template_id AS comment_template_id_15,
  u0_.marker_template_id AS marker_template_id_16,
  u0_.info_template_id AS info_template_id_17,
  u0_.evaluation_template_id AS evaluation_template_id_18,
  u0_.default_retention_rule_id AS default_retention_rule_id_19,
  u0_.expiration_from_id AS expiration_from_id_20,
  u0_.container_id AS container_id_21,
  u0_.r_access_id AS r_access_id_22
FROM
  user_groups u0_
WHERE
  u0_.deleted_at IS NULL
ORDER BY
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.record_duration AS record_duration_2, u0_.record_duration_selection_type AS record_duration_selection_type_3, u0_.io_record_name AS io_record_name_4, u0_.search_results AS search_results_5, u0_.room_sorting_order AS room_sorting_order_6, u0_.disabled_access AS disabled_access_7, u0_.default_review_view AS default_review_view_8, u0_.default_schedule_view AS default_schedule_view_9, u0_.default_report_view AS default_report_view_10, u0_.default_review_list_period AS default_review_list_period_11, u0_.deleted_users_video_access AS deleted_users_video_access_12, u0_.without_groups_users_video_access AS without_groups_users_video_access_13, u0_.deleted_at AS deleted_at_14, u0_.comment_template_id AS comment_template_id_15, u0_.marker_template_id AS marker_template_id_16, u0_.info_template_id AS info_template_id_17, u0_.evaluation_template_id AS evaluation_template_id_18, u0_.default_retention_rule_id AS default_retention_rule_id_19, u0_.expiration_from_id AS expiration_from_id_20, u0_.container_id AS container_id_21, u0_.r_access_id AS r_access_id_22 FROM user_groups u0_ WHERE u0_.deleted_at IS NULL ORDER BY u0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.value AS value_3,
  t0.field_id AS field_id_4
FROM
  template_field_options t0
WHERE
  t0.field_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.field_id AS field_id_4 FROM template_field_options t0 WHERE t0.field_id = 10;

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

SELECT
  t0.id AS id_1,
  t0.date_time_format AS date_time_format_2,
  t0.time_format AS time_format_3,
  t0.comment_overlay_font_size AS comment_overlay_font_size_4,
  t0.streaming_method AS streaming_method_5,
  t0.smtp_server_address AS smtp_server_address_6,
  t0.smtp_server_port AS smtp_server_port_7,
  t0.email_encryption AS email_encryption_8,
  t0.email_username AS email_username_9,
  t0.email_password AS email_password_10,
  t0.email_from_name AS email_from_name_11,
  t0.email_bcc_email AS email_bcc_email_12,
  t0.email_from_address AS email_from_address_13,
  t0.camera_alert_delay_seconds AS camera_alert_delay_seconds_14,
  t0.notifications_enabled AS notifications_enabled_15,
  t0.alerts_enabled AS alerts_enabled_16,
  t0.schedule_enabled AS schedule_enabled_17,
  t0.scene_recognition_enabled AS scene_recognition_enabled_18,
  t0.info_template_id AS info_template_id_19
FROM
  global_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.date_time_format AS date_time_format_2, t0.time_format AS time_format_3, t0.comment_overlay_font_size AS comment_overlay_font_size_4, t0.streaming_method AS streaming_method_5, t0.smtp_server_address AS smtp_server_address_6, t0.smtp_server_port AS smtp_server_port_7, t0.email_encryption AS email_encryption_8, t0.email_username AS email_username_9, t0.email_password AS email_password_10, t0.email_from_name AS email_from_name_11, t0.email_bcc_email AS email_bcc_email_12, t0.email_from_address AS email_from_address_13, t0.camera_alert_delay_seconds AS camera_alert_delay_seconds_14, t0.notifications_enabled AS notifications_enabled_15, t0.alerts_enabled AS alerts_enabled_16, t0.schedule_enabled AS schedule_enabled_17, t0.scene_recognition_enabled AS scene_recognition_enabled_18, t0.info_template_id AS info_template_id_19 FROM global_settings t0 LIMIT 1;

SELECT
  s0_.id AS sclr_0,
  s0_.name AS sclr_1
FROM
  session_track s0_
WHERE
  (
    EXISTS (
      SELECT
        1 AS sclr_2
      FROM
        session s1_
      WHERE
        s1_.session_track_id = s0_.id
        AND s1_.information_template_id = ?
    )
  )
  OR (
    EXISTS (
      SELECT
        1 AS sclr_3
      FROM
        session_assignment s2_
        INNER JOIN session s3_ ON s2_.session_id = s3_.id
      WHERE
        s3_.session_track_id = s0_.id
        AND s2_.evaluation_template_id = ?
    )
  )
ORDER BY
  NATURAL_SORT_KEY(s0_.name) ASC,
  s0_.id ASC

SELECT s0_.id AS sclr_0, s0_.name AS sclr_1 FROM session_track s0_ WHERE (EXISTS (SELECT 1 AS sclr_2 FROM session s1_ WHERE s1_.session_track_id = s0_.id AND s1_.information_template_id = 7)) OR (EXISTS (SELECT 1 AS sclr_3 FROM session_assignment s2_ INNER JOIN session s3_ ON s2_.session_id = s3_.id WHERE s3_.session_track_id = s0_.id AND s2_.evaluation_template_id = 7)) ORDER BY NATURAL_SORT_KEY(s0_.name) ASC, s0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.entity_name AS entity_name_3,
  t0.type AS type_4,
  t0.is_hidden AS is_hidden_5,
  t0.duration_type AS duration_type_6,
  t0.duration AS duration_7,
  t0.deleted_at AS deleted_at_8,
  t0.container_id AS container_id_9,
  t10.id AS id_11,
  t10.date_time_format AS date_time_format_12,
  t10.time_format AS time_format_13,
  t10.comment_overlay_font_size AS comment_overlay_font_size_14,
  t10.streaming_method AS streaming_method_15,
  t10.smtp_server_address AS smtp_server_address_16,
  t10.smtp_server_port AS smtp_server_port_17,
  t10.email_encryption AS email_encryption_18,
  t10.email_username AS email_username_19,
  t10.email_password AS email_password_20,
  t10.email_from_name AS email_from_name_21,
  t10.email_bcc_email AS email_bcc_email_22,
  t10.email_from_address AS email_from_address_23,
  t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_24,
  t10.notifications_enabled AS notifications_enabled_25,
  t10.alerts_enabled AS alerts_enabled_26,
  t10.schedule_enabled AS schedule_enabled_27,
  t10.scene_recognition_enabled AS scene_recognition_enabled_28,
  t10.info_template_id AS info_template_id_29
FROM
  templates t0
  LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity_name AS entity_name_3, t0.type AS type_4, t0.is_hidden AS is_hidden_5, t0.duration_type AS duration_type_6, t0.duration AS duration_7, t0.deleted_at AS deleted_at_8, t0.container_id AS container_id_9, t10.id AS id_11, t10.date_time_format AS date_time_format_12, t10.time_format AS time_format_13, t10.comment_overlay_font_size AS comment_overlay_font_size_14, t10.streaming_method AS streaming_method_15, t10.smtp_server_address AS smtp_server_address_16, t10.smtp_server_port AS smtp_server_port_17, t10.email_encryption AS email_encryption_18, t10.email_username AS email_username_19, t10.email_password AS email_password_20, t10.email_from_name AS email_from_name_21, t10.email_bcc_email AS email_bcc_email_22, t10.email_from_address AS email_from_address_23, t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_24, t10.notifications_enabled AS notifications_enabled_25, t10.alerts_enabled AS alerts_enabled_26, t10.schedule_enabled AS schedule_enabled_27, t10.scene_recognition_enabled AS scene_recognition_enabled_28, t10.info_template_id AS info_template_id_29 FROM templates t0 LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id WHERE t0.id = '7';

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.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.template_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.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.template_id = 7 AND t0.type IN ('record', 'motion', 'upload', 'zoom');

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
WHERE
  t0.info_template_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 WHERE t0.info_template_id = 7;

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.drawing AS drawing_3,
  t0.name AS name_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.record_time AS record_time_7,
  t0.start_time AS start_time_8,
  t0.end_time AS end_time_9,
  t0.color AS color_10,
  t0.template_data AS template_data_11,
  t0.author_id AS author_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.record_id AS record_id_14,
  t0.template_id AS template_id_15,
  t0.parent_id AS parent_id_16,
  t0.audio_id AS audio_id_17,
  t0.type,
  t0.transcript_id AS transcript_id_18
FROM
  comment t0
WHERE
  t0.template_id = ?
  AND t0.type IN (
    'simple', 'transcription', 'duration',
    'drawing'
  )

SELECT t0.id AS id_1, t0.message AS message_2, t0.drawing AS drawing_3, t0.name AS name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.record_time AS record_time_7, t0.start_time AS start_time_8, t0.end_time AS end_time_9, t0.color AS color_10, t0.template_data AS template_data_11, t0.author_id AS author_id_12, t0.updated_by_id AS updated_by_id_13, t0.record_id AS record_id_14, t0.template_id AS template_id_15, t0.parent_id AS parent_id_16, t0.audio_id AS audio_id_17, t0.type, t0.transcript_id AS transcript_id_18 FROM comment t0 WHERE t0.template_id = 7 AND t0.type IN ('simple', 'transcription', 'duration', 'drawing');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.search_for AS search_for_4,
  t0.search_for_type AS search_for_type_5,
  t0.template_fields_ids AS template_fields_ids_6,
  t0.record_selection_type AS record_selection_type_7,
  t0.room_selection_type AS room_selection_type_8,
  t0.user_selection_type AS user_selection_type_9,
  t0.created_by_id AS created_by_id_10,
  t0.date_range_id AS date_range_id_11,
  t0.comment_template_id AS comment_template_id_12,
  t0.type
FROM
  report t0
WHERE
  t0.comment_template_id = ?
  AND t0.type IN ('comment')

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.search_for AS search_for_4, t0.search_for_type AS search_for_type_5, t0.template_fields_ids AS template_fields_ids_6, t0.record_selection_type AS record_selection_type_7, t0.room_selection_type AS room_selection_type_8, t0.user_selection_type AS user_selection_type_9, t0.created_by_id AS created_by_id_10, t0.date_range_id AS date_range_id_11, t0.comment_template_id AS comment_template_id_12, t0.type FROM report t0 WHERE t0.comment_template_id = 7 AND t0.type IN ('comment');

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

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