1
2.13 ms
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 = ?
Copy
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 = 911 ;
Copy
8
1.04 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 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 = 911 ;
Copy
13
2.03 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 . 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 ;
Copy