1
0.53 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . username_canonical AS username_canonical_3 , t0 . password AS password_4 , t0 . email AS email_5 , t0 . email_canonical AS email_canonical_6 , t0 . enabled AS enabled_7 , t0 . salt AS salt_8 , t0 . roles AS roles_9 , t0 . userType AS userType_10 , t0 . ldapScript AS ldapScript_11 , t0 . ldapDomain AS ldapDomain_12 , t0 . ldapDN AS ldapDN_13 , t0 . display_name AS display_name_14 , t0 . card_number AS card_number_15 , t0 . pin AS pin_16 , t0 . control_type AS control_type_17 , t0 . disabled_access AS disabled_access_18 , t0 . ldap_extra_data AS ldap_extra_data_19 , t0 . login_failures AS login_failures_20 , t0 . login_block_start AS login_block_start_21 , t0 . last_passwords AS last_passwords_22 , t0 . last_change_password_date AS last_change_password_date_23 , t0 . night_mode AS night_mode_24 , t0 . auto_pause_record_when_comment AS auto_pause_record_when_comment_25 , t0 . auto_play_audio_comments AS auto_play_audio_comments_26 , t0 . notification_sound AS notification_sound_27 , t0 . avatar_filename AS avatar_filename_28 , t0 . avatar_original_filename AS avatar_original_filename_29 , t0 . emails_alerts_enabled AS emails_alerts_enabled_30 , t0 . zoom_step AS zoom_step_31 , t0 . api_token AS api_token_32 , t0 . deleted_at AS deleted_at_33 , t0 . group_id AS group_id_34 , t0 . ldap_sync_id AS ldap_sync_id_35 , t0 . saml_config_id AS saml_config_id_36 , t0 . zoom_account_id AS zoom_account_id_37 , t38 . notifications_enabled AS notifications_enabled_39 , t38 . notifications_frequency AS notifications_frequency_40 , t38 . notifications_schedule_enabled AS notifications_schedule_enabled_41 , t38 . notifications_cron_last_execute AS notifications_cron_last_execute_42 , t38 . user_id AS user_id_43 , t44 . created_at AS created_at_45 , t44 . session_id AS session_id_46 , t44 . device_id AS device_id_47 , t44 . user_id AS user_id_48 , t0 . expiration_from_id AS expiration_from_id_49 , t0 . r_access_id AS r_access_id_50 FROM users t0 LEFT JOIN user_email_settings t38 ON t38 . user_id = t0 . id LEFT JOIN session_connection t44 ON t44 . user_id = t0 . id WHERE t0 . id = ? LIMIT 1
SELECT
t0 . id AS id_1 ,
t0 . username AS username_2 ,
t0 . username_canonical AS username_canonical_3 ,
t0 . password AS password_4 ,
t0 . email AS email_5 ,
t0 . email_canonical AS email_canonical_6 ,
t0 . enabled AS enabled_7 ,
t0 . salt AS salt_8 ,
t0 . roles AS roles_9 ,
t0 . userType AS userType_10 ,
t0 . ldapScript AS ldapScript_11 ,
t0 . ldapDomain AS ldapDomain_12 ,
t0 . ldapDN AS ldapDN_13 ,
t0 . display_name AS display_name_14 ,
t0 . card_number AS card_number_15 ,
t0 . pin AS pin_16 ,
t0 . control_type AS control_type_17 ,
t0 . disabled_access AS disabled_access_18 ,
t0 . ldap_extra_data AS ldap_extra_data_19 ,
t0 . login_failures AS login_failures_20 ,
t0 . login_block_start AS login_block_start_21 ,
t0 . last_passwords AS last_passwords_22 ,
t0 . last_change_password_date AS last_change_password_date_23 ,
t0 . night_mode AS night_mode_24 ,
t0 . auto_pause_record_when_comment AS auto_pause_record_when_comment_25 ,
t0 . auto_play_audio_comments AS auto_play_audio_comments_26 ,
t0 . notification_sound AS notification_sound_27 ,
t0 . avatar_filename AS avatar_filename_28 ,
t0 . avatar_original_filename AS avatar_original_filename_29 ,
t0 . emails_alerts_enabled AS emails_alerts_enabled_30 ,
t0 . zoom_step AS zoom_step_31 ,
t0 . api_token AS api_token_32 ,
t0 . deleted_at AS deleted_at_33 ,
t0 . group_id AS group_id_34 ,
t0 . ldap_sync_id AS ldap_sync_id_35 ,
t0 . saml_config_id AS saml_config_id_36 ,
t0 . zoom_account_id AS zoom_account_id_37 ,
t38 . notifications_enabled AS notifications_enabled_39 ,
t38 . notifications_frequency AS notifications_frequency_40 ,
t38 . notifications_schedule_enabled AS notifications_schedule_enabled_41 ,
t38 . notifications_cron_last_execute AS notifications_cron_last_execute_42 ,
t38 . user_id AS user_id_43 ,
t44 . created_at AS created_at_45 ,
t44 . session_id AS session_id_46 ,
t44 . device_id AS device_id_47 ,
t44 . user_id AS user_id_48 ,
t0 . expiration_from_id AS expiration_from_id_49 ,
t0 . r_access_id AS r_access_id_50
FROM
users t0
LEFT JOIN user_email_settings t38 ON t38 . user_id = t0 . id
LEFT JOIN session_connection t44 ON t44 . user_id = t0 . id
WHERE
t0 . id = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . username_canonical AS username_canonical_3 , t0 . password AS password_4 , t0 . email AS email_5 , t0 . email_canonical AS email_canonical_6 , t0 . enabled AS enabled_7 , t0 . salt AS salt_8 , t0 . roles AS roles_9 , t0 . userType AS userType_10 , t0 . ldapScript AS ldapScript_11 , t0 . ldapDomain AS ldapDomain_12 , t0 . ldapDN AS ldapDN_13 , t0 . display_name AS display_name_14 , t0 . card_number AS card_number_15 , t0 . pin AS pin_16 , t0 . control_type AS control_type_17 , t0 . disabled_access AS disabled_access_18 , t0 . ldap_extra_data AS ldap_extra_data_19 , t0 . login_failures AS login_failures_20 , t0 . login_block_start AS login_block_start_21 , t0 . last_passwords AS last_passwords_22 , t0 . last_change_password_date AS last_change_password_date_23 , t0 . night_mode AS night_mode_24 , t0 . auto_pause_record_when_comment AS auto_pause_record_when_comment_25 , t0 . auto_play_audio_comments AS auto_play_audio_comments_26 , t0 . notification_sound AS notification_sound_27 , t0 . avatar_filename AS avatar_filename_28 , t0 . avatar_original_filename AS avatar_original_filename_29 , t0 . emails_alerts_enabled AS emails_alerts_enabled_30 , t0 . zoom_step AS zoom_step_31 , t0 . api_token AS api_token_32 , t0 . deleted_at AS deleted_at_33 , t0 . group_id AS group_id_34 , t0 . ldap_sync_id AS ldap_sync_id_35 , t0 . saml_config_id AS saml_config_id_36 , t0 . zoom_account_id AS zoom_account_id_37 , t38 . notifications_enabled AS notifications_enabled_39 , t38 . notifications_frequency AS notifications_frequency_40 , t38 . notifications_schedule_enabled AS notifications_schedule_enabled_41 , t38 . notifications_cron_last_execute AS notifications_cron_last_execute_42 , t38 . user_id AS user_id_43 , t44 . created_at AS created_at_45 , t44 . session_id AS session_id_46 , t44 . device_id AS device_id_47 , t44 . user_id AS user_id_48 , t0 . expiration_from_id AS expiration_from_id_49 , t0 . r_access_id AS r_access_id_50 FROM users t0 LEFT JOIN user_email_settings t38 ON t38 . user_id = t0 . id LEFT JOIN session_connection t44 ON t44 . user_id = t0 . id WHERE t0 . id = 2 LIMIT 1 ;
Copy
5
0.22 ms
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 . 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 . id = 1 ;
Copy
7
0.42 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 . rtmp_username AS rtmp_username_13 , t0 . rtmp_password AS rtmp_password_14 , t0 . transcription_service_id AS transcription_service_id_15 , t0 . sync_id AS sync_id_16 , t17 . stream AS stream_18 , t17 . video AS video_19 , t17 . video_prefix AS video_prefix_20 , t17 . wowza_id AS wowza_id_21 , t22 . active AS active_23 , t22 . wowza_id AS wowza_id_24 , t22 . storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17 . wowza_id = t0 . id LEFT JOIN wowza_status t22 ON t22 . 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 . rtmp_username AS rtmp_username_13 , t0 . rtmp_password AS rtmp_password_14 , t0 . transcription_service_id AS transcription_service_id_15 , t0 . sync_id AS sync_id_16 , t17 . stream AS stream_18 , t17 . video AS video_19 , t17 . video_prefix AS video_prefix_20 , t17 . wowza_id AS wowza_id_21 , t22 . active AS active_23 , t22 . wowza_id AS wowza_id_24 , t22 . storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17 . wowza_id = t0 . id LEFT JOIN wowza_status t22 ON t22 . wowza_id = t0 . id ;
Copy