[2021-11-11T22:11:55+08:00][sql] CONNECT:[ UseTime:0.003875s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:55+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.010766s ] [2021-11-11T22:11:55+08:00][sql] SELECT `menu_id`,`name` FROM `v_doc_permission` WHERE `role_id` = '1' [ RunTime:0.000714s ] [2021-11-11T22:11:56+08:00][sql] CONNECT:[ UseTime:0.007341s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.016195s ] [2021-11-11T22:11:56+08:00][sql] SELECT DISTINCT `project_no`,`project_name_easy` FROM `t_doc_project` WHERE `project_no` = '#####' [ RunTime:0.000623s ] [2021-11-11T22:11:56+08:00][sql] CONNECT:[ UseTime:0.005620s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.015493s ] [2021-11-11T22:11:56+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000647s ] [2021-11-11T22:11:56+08:00][sql] CONNECT:[ UseTime:0.005437s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.016856s ] [2021-11-11T22:11:56+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '' [ RunTime:0.001386s ] [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_security_classification` [ RunTime:0.014854s ] [2021-11-11T22:11:56+08:00][sql] SELECT `security_classification` FROM `t_doc_dict_security_classification` [ RunTime:0.000438s ] [2021-11-11T22:11:56+08:00][sql] CONNECT:[ UseTime:0.006149s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.015703s ] [2021-11-11T22:11:56+08:00][sql] SELECT * FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' AND `status` = '2' AND `borrow_type_id` = '2' ORDER BY `return_time` DESC [ RunTime:0.001124s ] [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.016159s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' [ RunTime:0.001130s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000879s ] [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.014652s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000497s ] [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.011154s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002773s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002036s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.003038s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.001032s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' [ RunTime:0.000952s ] [2021-11-11T22:11:56+08:00][sql] CONNECT:[ UseTime:0.004914s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.011640s ] [2021-11-11T22:11:56+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `project_no` = '' [ RunTime:0.001021s ] [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_security_classification` [ RunTime:0.010371s ] [2021-11-11T22:11:56+08:00][sql] SELECT `security_classification` FROM `t_doc_dict_security_classification` [ RunTime:0.000390s ] [2021-11-11T22:11:56+08:00][sql] CONNECT:[ UseTime:0.003677s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.012915s ] [2021-11-11T22:11:56+08:00][sql] SELECT * FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' AND `status` = '2' AND `borrow_type_id` = '2' ORDER BY `return_time` DESC [ RunTime:0.001102s ] [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.012851s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' [ RunTime:0.000823s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000742s ] [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.012288s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000480s ] [2021-11-11T22:11:56+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.013007s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.004492s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002818s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.003919s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.001024s ] [2021-11-11T22:11:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' [ RunTime:0.000646s ] [2021-11-11T22:11:57+08:00][sql] CONNECT:[ UseTime:0.003163s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:57+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_roles` [ RunTime:0.012260s ] [2021-11-11T22:11:57+08:00][sql] SELECT * FROM `t_doc_roles` [ RunTime:0.000460s ] [2021-11-11T22:11:57+08:00][sql] CONNECT:[ UseTime:0.003174s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:57+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.012704s ] [2021-11-11T22:11:57+08:00][sql] SELECT * FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' AND `status` = '2' AND `borrow_type_id` = '2' ORDER BY `return_time` DESC [ RunTime:0.000975s ] [2021-11-11T22:11:57+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.011615s ] [2021-11-11T22:11:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' [ RunTime:0.000705s ] [2021-11-11T22:11:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000467s ] [2021-11-11T22:11:57+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.009769s ] [2021-11-11T22:11:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000414s ] [2021-11-11T22:11:57+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.009538s ] [2021-11-11T22:11:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002541s ] [2021-11-11T22:11:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.001758s ] [2021-11-11T22:11:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002446s ] [2021-11-11T22:11:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000747s ] [2021-11-11T22:11:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' [ RunTime:0.000629s ] [2021-11-11T22:11:57+08:00][sql] CONNECT:[ UseTime:0.013381s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:57+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_roles` [ RunTime:0.009736s ] [2021-11-11T22:11:57+08:00][sql] SELECT * FROM `t_doc_roles` [ RunTime:0.000498s ] [2021-11-11T22:11:58+08:00][sql] CONNECT:[ UseTime:0.003144s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:58+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_roles` [ RunTime:0.009188s ] [2021-11-11T22:11:58+08:00][sql] SELECT * FROM `t_doc_roles` [ RunTime:0.000464s ] [2021-11-11T22:11:58+08:00][sql] CONNECT:[ UseTime:0.002986s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T22:11:58+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_roles` [ RunTime:0.009027s ] [2021-11-11T22:11:58+08:00][sql] SELECT * FROM `t_doc_roles` [ RunTime:0.000456s ] [2021-11-11T23:04:33+08:00][sql] CONNECT:[ UseTime:0.003523s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-11T23:04:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.010220s ] [2021-11-11T23:04:33+08:00][sql] SELECT * FROM `v_doc_project` WHERE `project_no` = '#####' ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000718s ] [2021-11-11T23:04:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` WHERE `project_no` = '#####' [ RunTime:0.000487s ]