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

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

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

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

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

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

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_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
  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
  c0_.id AS id_0
FROM
  container c0_
  INNER JOIN user_groups u1_ ON c0_.id = u1_.container_id
  INNER JOIN users u2_ ON u1_.id = u2_.group_id
WHERE
  u2_.id = ?

SELECT c0_.id AS id_0 FROM container c0_ INNER JOIN user_groups u1_ ON c0_.id = u1_.container_id INNER JOIN users u2_ ON u1_.id = u2_.group_id WHERE u2_.id = 7;

SELECT
  c0_.id AS id_0
FROM
  container c0_
  INNER JOIN user_groups u1_ ON c0_.id = u1_.container_id
  INNER JOIN additional_user_groups a3_ ON u1_.id = a3_.group_id
  INNER JOIN users u2_ ON u2_.id = a3_.user_id
WHERE
  u2_.id = ?

SELECT c0_.id AS id_0 FROM container c0_ INNER JOIN user_groups u1_ ON c0_.id = u1_.container_id INNER JOIN additional_user_groups a3_ ON u1_.id = a3_.group_id INNER JOIN users u2_ ON u2_.id = a3_.user_id WHERE u2_.id = 7;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c1_.id AS id_2,
  c1_.name AS name_3,
  c0_.c_id AS c_id_4,
  c1_.c_id AS c_id_5
FROM
  container c0_
  LEFT JOIN container c1_ ON c0_.c_id = c1_.id

SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, c0_.c_id AS c_id_4, c1_.c_id AS c_id_5 FROM container c0_ LEFT JOIN container c1_ ON c0_.c_id = c1_.id;

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.type AS type_3,
  t0.required AS required_4,
  t0.default_data AS default_data_5,
  t0.total_value AS total_value_6,
  t0.color AS color_7,
  t0.image_file_name AS image_file_name_8,
  t0.ordinal AS ordinal_9,
  t0.template_id AS template_id_10
FROM
  template_fields t0
WHERE
  t0.template_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.required AS required_4, t0.default_data AS default_data_5, t0.total_value AS total_value_6, t0.color AS color_7, t0.image_file_name AS image_file_name_8, t0.ordinal AS ordinal_9, t0.template_id AS template_id_10 FROM template_fields t0 WHERE t0.template_id = 7;