[2021-07-20T08:42:44+08:00][sql] CONNECT:[ UseTime:0.011701s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:44+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.010512s ] [2021-07-20T08:42:44+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 1 LIMIT 1 [ RunTime:0.000480s ] [2021-07-20T08:42:45+08:00][sql] CONNECT:[ UseTime:0.001533s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:45+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu` [ RunTime:0.020436s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000572s ] [2021-07-20T08:42:45+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.009864s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 53 [ RunTime:0.000569s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 53 ORDER BY `sort` ASC [ RunTime:0.000445s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 54 [ RunTime:0.000555s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 54 ORDER BY `sort` ASC [ RunTime:0.000425s ] [2021-07-20T08:42:45+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu_type` [ RunTime:0.009666s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000425s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000349s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 27 [ RunTime:0.000498s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 27 ORDER BY `sort` ASC [ RunTime:0.000395s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 28 [ RunTime:0.000491s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 28 ORDER BY `sort` ASC [ RunTime:0.000367s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000344s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 29 [ RunTime:0.000454s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 29 ORDER BY `sort` ASC [ RunTime:0.000379s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000304s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 31 [ RunTime:0.000456s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 31 ORDER BY `sort` ASC [ RunTime:0.000379s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000334s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000297s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 43 [ RunTime:0.000476s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 43 ORDER BY `sort` ASC [ RunTime:0.000363s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 44 [ RunTime:0.000422s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 44 ORDER BY `sort` ASC [ RunTime:0.000326s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000250s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 45 [ RunTime:0.000422s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 45 ORDER BY `sort` ASC [ RunTime:0.000287s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000237s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000225s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 46 [ RunTime:0.000358s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 46 ORDER BY `sort` ASC [ RunTime:0.000295s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 47 [ RunTime:0.000355s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 47 ORDER BY `sort` ASC [ RunTime:0.000279s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000291s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 48 [ RunTime:0.000361s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 48 ORDER BY `sort` ASC [ RunTime:0.000390s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000244s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000246s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 49 [ RunTime:0.000466s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 49 ORDER BY `sort` ASC [ RunTime:0.000381s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 50 [ RunTime:0.000526s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 50 ORDER BY `sort` ASC [ RunTime:0.000346s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000253s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 51 [ RunTime:0.000396s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 51 ORDER BY `sort` ASC [ RunTime:0.000344s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000278s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000257s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 14 [ RunTime:0.000375s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 14 ORDER BY `sort` ASC [ RunTime:0.000314s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 15 [ RunTime:0.000338s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 15 ORDER BY `sort` ASC [ RunTime:0.000283s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000233s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 16 [ RunTime:0.000327s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 16 ORDER BY `sort` ASC [ RunTime:0.000305s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000377s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 17 [ RunTime:0.000360s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 17 ORDER BY `sort` ASC [ RunTime:0.000299s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000235s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 18 [ RunTime:0.000394s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 18 ORDER BY `sort` ASC [ RunTime:0.000278s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000249s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 19 [ RunTime:0.000404s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 19 ORDER BY `sort` ASC [ RunTime:0.000286s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000229s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000232s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 24 [ RunTime:0.000482s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 24 ORDER BY `sort` ASC [ RunTime:0.000365s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 38 [ RunTime:0.000402s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 38 ORDER BY `sort` ASC [ RunTime:0.000321s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000264s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 25 [ RunTime:0.000492s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 25 ORDER BY `sort` ASC [ RunTime:0.000432s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000264s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 26 [ RunTime:0.000441s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 26 ORDER BY `sort` ASC [ RunTime:0.000293s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000228s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 37 [ RunTime:0.000380s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 37 ORDER BY `sort` ASC [ RunTime:0.000280s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000258s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000221s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 39 [ RunTime:0.000332s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 39 ORDER BY `sort` ASC [ RunTime:0.000321s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 40 [ RunTime:0.000350s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 40 ORDER BY `sort` ASC [ RunTime:0.000276s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000225s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 41 [ RunTime:0.000325s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 41 ORDER BY `sort` ASC [ RunTime:0.000275s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000227s ] [2021-07-20T08:42:45+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 42 [ RunTime:0.000417s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 42 ORDER BY `sort` ASC [ RunTime:0.000297s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000234s ] [2021-07-20T08:42:45+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000242s ] [2021-07-20T08:42:47+08:00][sql] CONNECT:[ UseTime:0.001585s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.011578s ] [2021-07-20T08:42:47+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.001168s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000681s ] [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply_borrow` [ RunTime:0.010409s ] [2021-07-20T08:42:47+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002073s ] [2021-07-20T08:42:47+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 9 LIMIT 1 [ RunTime:0.001881s ] [2021-07-20T08:42:47+08:00][sql] CONNECT:[ UseTime:0.001677s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.013838s ] [2021-07-20T08:42:47+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.001849s ] [2021-07-20T08:42:47+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.001220s ] [2021-07-20T08:42:47+08:00][sql] CONNECT:[ UseTime:0.002142s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.013666s ] [2021-07-20T08:42:47+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000466s ] [2021-07-20T08:42:47+08:00][sql] CONNECT:[ UseTime:0.001766s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.012541s ] [2021-07-20T08:42:47+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.001039s ] [2021-07-20T08:42:47+08:00][sql] CONNECT:[ UseTime:0.001615s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.011543s ] [2021-07-20T08:42:47+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' ORDER BY `exm_time` DESC LIMIT 0,20 [ RunTime:0.001430s ] [2021-07-20T08:42:47+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.000965s ] [2021-07-20T08:42:47+08:00][sql] CONNECT:[ UseTime:0.001944s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.011932s ] [2021-07-20T08:42:47+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.000833s ] [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.011976s ] [2021-07-20T08:42:47+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.000673s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000574s ] [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.010384s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000298s ] [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.010851s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001848s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002665s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001746s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000547s ] [2021-07-20T08:42:47+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.000825s ] [2021-07-20T08:42:47+08:00][sql] CONNECT:[ UseTime:0.001566s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.009933s ] [2021-07-20T08:42:47+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.000905s ] [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.009483s ] [2021-07-20T08:42:47+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.000780s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000542s ] [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.009797s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000326s ] [2021-07-20T08:42:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.010435s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001929s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002748s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002018s ] [2021-07-20T08:42:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000932s ] [2021-07-20T08:42:47+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.000726s ] [2021-07-20T08:43:28+08:00][sql] CONNECT:[ UseTime:0.001670s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:28+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.010124s ] [2021-07-20T08:43:28+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 1 LIMIT 1 [ RunTime:0.000439s ] [2021-07-20T08:43:29+08:00][sql] CONNECT:[ UseTime:0.012358s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:29+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu` [ RunTime:0.010099s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000556s ] [2021-07-20T08:43:29+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.009051s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 53 [ RunTime:0.000557s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 53 ORDER BY `sort` ASC [ RunTime:0.000398s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 54 [ RunTime:0.000497s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 54 ORDER BY `sort` ASC [ RunTime:0.000424s ] [2021-07-20T08:43:29+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu_type` [ RunTime:0.008921s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000330s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000355s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 27 [ RunTime:0.000458s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 27 ORDER BY `sort` ASC [ RunTime:0.000475s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 28 [ RunTime:0.000424s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 28 ORDER BY `sort` ASC [ RunTime:0.000341s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000306s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 29 [ RunTime:0.000382s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 29 ORDER BY `sort` ASC [ RunTime:0.000287s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000232s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 31 [ RunTime:0.000450s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 31 ORDER BY `sort` ASC [ RunTime:0.000288s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000233s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000224s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 43 [ RunTime:0.000351s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 43 ORDER BY `sort` ASC [ RunTime:0.000295s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 44 [ RunTime:0.000385s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 44 ORDER BY `sort` ASC [ RunTime:0.000339s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000327s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 45 [ RunTime:0.000444s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 45 ORDER BY `sort` ASC [ RunTime:0.000337s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000325s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000332s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 46 [ RunTime:0.000444s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 46 ORDER BY `sort` ASC [ RunTime:0.000439s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 47 [ RunTime:0.000474s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 47 ORDER BY `sort` ASC [ RunTime:0.000377s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000331s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 48 [ RunTime:0.000510s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 48 ORDER BY `sort` ASC [ RunTime:0.000444s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000330s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000260s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 49 [ RunTime:0.000397s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 49 ORDER BY `sort` ASC [ RunTime:0.000319s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 50 [ RunTime:0.000410s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 50 ORDER BY `sort` ASC [ RunTime:0.000302s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000244s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 51 [ RunTime:0.000396s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 51 ORDER BY `sort` ASC [ RunTime:0.000307s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000234s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000226s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 14 [ RunTime:0.000332s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 14 ORDER BY `sort` ASC [ RunTime:0.000302s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 15 [ RunTime:0.000335s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 15 ORDER BY `sort` ASC [ RunTime:0.000277s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000296s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 16 [ RunTime:0.000399s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 16 ORDER BY `sort` ASC [ RunTime:0.000310s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000262s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 17 [ RunTime:0.000356s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 17 ORDER BY `sort` ASC [ RunTime:0.000411s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000248s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 18 [ RunTime:0.000450s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 18 ORDER BY `sort` ASC [ RunTime:0.000317s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000238s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 19 [ RunTime:0.000340s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 19 ORDER BY `sort` ASC [ RunTime:0.000343s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000295s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000290s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 24 [ RunTime:0.000447s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 24 ORDER BY `sort` ASC [ RunTime:0.000414s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 38 [ RunTime:0.000440s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 38 ORDER BY `sort` ASC [ RunTime:0.000355s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000339s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 25 [ RunTime:0.000510s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 25 ORDER BY `sort` ASC [ RunTime:0.000394s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000342s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 26 [ RunTime:0.000512s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 26 ORDER BY `sort` ASC [ RunTime:0.000420s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000374s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 37 [ RunTime:0.000524s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 37 ORDER BY `sort` ASC [ RunTime:0.000435s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000374s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000376s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 39 [ RunTime:0.000502s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 39 ORDER BY `sort` ASC [ RunTime:0.000491s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 40 [ RunTime:0.000465s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 40 ORDER BY `sort` ASC [ RunTime:0.000362s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000284s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 41 [ RunTime:0.000374s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 41 ORDER BY `sort` ASC [ RunTime:0.000330s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000301s ] [2021-07-20T08:43:29+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 42 [ RunTime:0.000381s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 42 ORDER BY `sort` ASC [ RunTime:0.000318s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000265s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000268s ] [2021-07-20T08:43:29+08:00][sql] CONNECT:[ UseTime:0.001510s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:29+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.010674s ] [2021-07-20T08:43:29+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.001032s ] [2021-07-20T08:43:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000678s ] [2021-07-20T08:43:29+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply_borrow` [ RunTime:0.010203s ] [2021-07-20T08:43:29+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 13 LIMIT 1 [ RunTime:0.001969s ] [2021-07-20T08:43:29+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 9 LIMIT 1 [ RunTime:0.002011s ] [2021-07-20T08:43:30+08:00][sql] CONNECT:[ UseTime:0.002420s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.012662s ] [2021-07-20T08:43:30+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000671s ] [2021-07-20T08:43:30+08:00][sql] CONNECT:[ UseTime:0.002087s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.015167s ] [2021-07-20T08:43:30+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' ORDER BY `exm_time` DESC LIMIT 0,20 [ RunTime:0.001564s ] [2021-07-20T08:43:30+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.001166s ] [2021-07-20T08:43:30+08:00][sql] CONNECT:[ UseTime:0.002271s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.015704s ] [2021-07-20T08:43:30+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.001370s ] [2021-07-20T08:43:30+08:00][sql] CONNECT:[ UseTime:0.001799s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.015393s ] [2021-07-20T08:43:30+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.001551s ] [2021-07-20T08:43:30+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.000955s ] [2021-07-20T08:43:30+08:00][sql] CONNECT:[ UseTime:0.003374s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.011553s ] [2021-07-20T08:43:30+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.001090s ] [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.011759s ] [2021-07-20T08:43:30+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.000649s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000519s ] [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.010292s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000291s ] [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.009293s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002067s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.003009s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002007s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000622s ] [2021-07-20T08:43:30+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.000722s ] [2021-07-20T08:43:30+08:00][sql] CONNECT:[ UseTime:0.001989s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.012847s ] [2021-07-20T08:43:30+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.000921s ] [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.014033s ] [2021-07-20T08:43:30+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.000911s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000535s ] [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.013711s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000424s ] [2021-07-20T08:43:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.012449s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002119s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002917s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001979s ] [2021-07-20T08:43:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000696s ] [2021-07-20T08:43:30+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.000742s ] [2021-07-20T08:43:32+08:00][sql] CONNECT:[ UseTime:0.011823s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:32+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.009379s ] [2021-07-20T08:43:32+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 7 LIMIT 1 [ RunTime:0.000431s ] [2021-07-20T08:43:33+08:00][sql] CONNECT:[ UseTime:0.001482s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu` [ RunTime:0.010070s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000580s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.009236s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 53 [ RunTime:0.000554s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 53 ORDER BY `sort` ASC [ RunTime:0.000442s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 54 [ RunTime:0.000564s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 54 ORDER BY `sort` ASC [ RunTime:0.000408s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu_type` [ RunTime:0.009303s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000484s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000369s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 27 [ RunTime:0.000582s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 27 ORDER BY `sort` ASC [ RunTime:0.000419s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 28 [ RunTime:0.000440s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 28 ORDER BY `sort` ASC [ RunTime:0.000334s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000264s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 29 [ RunTime:0.000417s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 29 ORDER BY `sort` ASC [ RunTime:0.000328s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000283s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 31 [ RunTime:0.000413s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 31 ORDER BY `sort` ASC [ RunTime:0.000314s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000253s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000248s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 43 [ RunTime:0.000354s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 43 ORDER BY `sort` ASC [ RunTime:0.000307s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 44 [ RunTime:0.000389s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 44 ORDER BY `sort` ASC [ RunTime:0.000285s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000257s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 45 [ RunTime:0.000383s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 45 ORDER BY `sort` ASC [ RunTime:0.000286s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000247s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000251s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 46 [ RunTime:0.000363s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 46 ORDER BY `sort` ASC [ RunTime:0.000298s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 47 [ RunTime:0.000419s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 47 ORDER BY `sort` ASC [ RunTime:0.000332s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000234s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 48 [ RunTime:0.000507s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 48 ORDER BY `sort` ASC [ RunTime:0.000305s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000227s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000242s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 49 [ RunTime:0.000371s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 49 ORDER BY `sort` ASC [ RunTime:0.000309s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 50 [ RunTime:0.000358s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 50 ORDER BY `sort` ASC [ RunTime:0.000358s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000247s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 51 [ RunTime:0.000376s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 51 ORDER BY `sort` ASC [ RunTime:0.000370s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000274s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000265s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 14 [ RunTime:0.000387s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 14 ORDER BY `sort` ASC [ RunTime:0.000322s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 15 [ RunTime:0.000348s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 15 ORDER BY `sort` ASC [ RunTime:0.000299s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000236s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 16 [ RunTime:0.000343s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 16 ORDER BY `sort` ASC [ RunTime:0.000275s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000303s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 17 [ RunTime:0.000334s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 17 ORDER BY `sort` ASC [ RunTime:0.000281s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000227s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 18 [ RunTime:0.000419s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 18 ORDER BY `sort` ASC [ RunTime:0.000353s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000314s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 19 [ RunTime:0.000394s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 19 ORDER BY `sort` ASC [ RunTime:0.000387s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000276s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000274s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 24 [ RunTime:0.000470s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 24 ORDER BY `sort` ASC [ RunTime:0.000352s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 38 [ RunTime:0.000367s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 38 ORDER BY `sort` ASC [ RunTime:0.000298s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000232s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 25 [ RunTime:0.000411s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 25 ORDER BY `sort` ASC [ RunTime:0.000286s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000226s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 26 [ RunTime:0.000385s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 26 ORDER BY `sort` ASC [ RunTime:0.000288s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000268s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 37 [ RunTime:0.000372s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 37 ORDER BY `sort` ASC [ RunTime:0.000285s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000232s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000298s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 39 [ RunTime:0.000377s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 39 ORDER BY `sort` ASC [ RunTime:0.000297s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 40 [ RunTime:0.000331s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 40 ORDER BY `sort` ASC [ RunTime:0.000275s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000234s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 41 [ RunTime:0.000332s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 41 ORDER BY `sort` ASC [ RunTime:0.000326s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000310s ] [2021-07-20T08:43:33+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 42 [ RunTime:0.000420s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 42 ORDER BY `sort` ASC [ RunTime:0.000313s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000312s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000330s ] [2021-07-20T08:43:33+08:00][sql] CONNECT:[ UseTime:0.001729s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.010483s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.001009s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000605s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply_borrow` [ RunTime:0.010105s ] [2021-07-20T08:43:33+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 13 LIMIT 1 [ RunTime:0.001860s ] [2021-07-20T08:43:33+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 9 LIMIT 1 [ RunTime:0.002355s ] [2021-07-20T08:43:33+08:00][sql] CONNECT:[ UseTime:0.002245s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.012032s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000544s ] [2021-07-20T08:43:33+08:00][sql] CONNECT:[ UseTime:0.001369s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.012929s ] [2021-07-20T08:43:33+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.000984s ] [2021-07-20T08:43:33+08:00][sql] CONNECT:[ UseTime:0.011899s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.012505s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '0' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.001009s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '0' [ RunTime:0.000659s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply_borrow` [ RunTime:0.010775s ] [2021-07-20T08:43:33+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 11 LIMIT 1 [ RunTime:0.001930s ] [2021-07-20T08:43:33+08:00][sql] CONNECT:[ UseTime:0.001721s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.012091s ] [2021-07-20T08:43:33+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '1' ORDER BY `exm_time` DESC LIMIT 0,20 [ RunTime:0.001109s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '1' [ RunTime:0.000895s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply_borrow` [ RunTime:0.011099s ] [2021-07-20T08:43:33+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.001857s ] [2021-07-20T08:43:33+08:00][sql] CONNECT:[ UseTime:0.001523s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.013837s ] [2021-07-20T08:43:33+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.001057s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.011409s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '0' [ RunTime:0.000682s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000546s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.010540s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000385s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.010069s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001931s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002625s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001851s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000698s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '1' [ RunTime:0.000731s ] [2021-07-20T08:43:33+08:00][sql] CONNECT:[ UseTime:0.001940s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.010345s ] [2021-07-20T08:43:33+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.000748s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.010156s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '0' [ RunTime:0.000692s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '4' [ RunTime:0.000508s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.009843s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000414s ] [2021-07-20T08:43:33+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.010065s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002050s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002736s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001778s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '4' AND `step` = '1' [ RunTime:0.000672s ] [2021-07-20T08:43:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '1' [ RunTime:0.000720s ] [2021-07-20T08:43:35+08:00][sql] CONNECT:[ UseTime:0.001739s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T08:43:35+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.009499s ] [2021-07-20T08:43:35+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '0' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.000911s ] [2021-07-20T08:43:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '4' AND `next_flow_node_role_id` = '7' AND `check_status` = '0' [ RunTime:0.000639s ] [2021-07-20T08:43:35+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply_borrow` [ RunTime:0.010102s ] [2021-07-20T08:43:35+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 11 LIMIT 1 [ RunTime:0.001873s ] [2021-07-20T15:03:36+08:00][sql] CONNECT:[ UseTime:0.013483s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:36+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.017280s ] [2021-07-20T15:03:36+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 1 LIMIT 1 [ RunTime:0.016068s ] [2021-07-20T15:03:37+08:00][sql] CONNECT:[ UseTime:0.002300s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:37+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu` [ RunTime:0.043001s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.033390s ] [2021-07-20T15:03:37+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_permission` [ RunTime:0.017816s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 53 [ RunTime:0.018716s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 53 ORDER BY `sort` ASC [ RunTime:0.002000s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 54 [ RunTime:0.002295s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 54 ORDER BY `sort` ASC [ RunTime:0.001709s ] [2021-07-20T15:03:37+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_menu_type` [ RunTime:0.011088s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000366s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000365s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 27 [ RunTime:0.000501s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 27 ORDER BY `sort` ASC [ RunTime:0.000329s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 28 [ RunTime:0.000408s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 28 ORDER BY `sort` ASC [ RunTime:0.000310s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000351s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 29 [ RunTime:0.000480s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 29 ORDER BY `sort` ASC [ RunTime:0.000395s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000349s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 31 [ RunTime:0.000495s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 31 ORDER BY `sort` ASC [ RunTime:0.000453s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000362s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000352s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 43 [ RunTime:0.000514s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 43 ORDER BY `sort` ASC [ RunTime:0.000356s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 44 [ RunTime:0.000410s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 44 ORDER BY `sort` ASC [ RunTime:0.000310s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000243s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 45 [ RunTime:0.000376s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 45 ORDER BY `sort` ASC [ RunTime:0.000281s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000234s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000220s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 46 [ RunTime:0.000371s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 46 ORDER BY `sort` ASC [ RunTime:0.000285s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 47 [ RunTime:0.000359s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 47 ORDER BY `sort` ASC [ RunTime:0.000278s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000225s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 48 [ RunTime:0.000374s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 48 ORDER BY `sort` ASC [ RunTime:0.000354s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000334s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000298s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 49 [ RunTime:0.000456s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 49 ORDER BY `sort` ASC [ RunTime:0.000367s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 50 [ RunTime:0.000455s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 50 ORDER BY `sort` ASC [ RunTime:0.000343s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000292s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 51 [ RunTime:0.000421s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 51 ORDER BY `sort` ASC [ RunTime:0.000342s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000293s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000260s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 14 [ RunTime:0.000354s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 14 ORDER BY `sort` ASC [ RunTime:0.000335s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 15 [ RunTime:0.000366s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 15 ORDER BY `sort` ASC [ RunTime:0.000300s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000255s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 16 [ RunTime:0.000366s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 16 ORDER BY `sort` ASC [ RunTime:0.000434s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000337s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 17 [ RunTime:0.000437s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 17 ORDER BY `sort` ASC [ RunTime:0.000359s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000296s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 18 [ RunTime:0.000365s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 18 ORDER BY `sort` ASC [ RunTime:0.000305s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000255s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 19 [ RunTime:0.000348s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 19 ORDER BY `sort` ASC [ RunTime:0.000306s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000253s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000284s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 24 [ RunTime:0.000526s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 24 ORDER BY `sort` ASC [ RunTime:0.000407s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 38 [ RunTime:0.000443s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 38 ORDER BY `sort` ASC [ RunTime:0.000449s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000421s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 25 [ RunTime:0.000581s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 25 ORDER BY `sort` ASC [ RunTime:0.000390s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000325s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 26 [ RunTime:0.000597s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 26 ORDER BY `sort` ASC [ RunTime:0.000367s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000293s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 37 [ RunTime:0.000484s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 37 ORDER BY `sort` ASC [ RunTime:0.000340s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000320s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000296s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 39 [ RunTime:0.000415s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 39 ORDER BY `sort` ASC [ RunTime:0.000398s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 40 [ RunTime:0.000438s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 40 ORDER BY `sort` ASC [ RunTime:0.000356s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000326s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 41 [ RunTime:0.000366s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 41 ORDER BY `sort` ASC [ RunTime:0.000389s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000313s ] [2021-07-20T15:03:37+08:00][sql] SELECT `roles` FROM `v_doc_permission` WHERE `menu_id` = 42 [ RunTime:0.000408s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu` WHERE `pid` = 42 ORDER BY `sort` ASC [ RunTime:0.000331s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 2 LIMIT 1 [ RunTime:0.000276s ] [2021-07-20T15:03:37+08:00][sql] SELECT * FROM `t_doc_menu_type` WHERE `type_id` = 1 LIMIT 1 [ RunTime:0.000253s ] [2021-07-20T15:03:39+08:00][sql] CONNECT:[ UseTime:0.024074s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:39+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.012088s ] [2021-07-20T15:03:39+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '1' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.027024s ] [2021-07-20T15:03:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '1' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' [ RunTime:0.001285s ] [2021-07-20T15:03:39+08:00][sql] CONNECT:[ UseTime:0.002494s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:39+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.191630s ] [2021-07-20T15:03:39+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `apply_user_id` = '1' AND `step` = '1' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.120342s ] [2021-07-20T15:03:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '1' AND `step` = '1' [ RunTime:0.051232s ] [2021-07-20T15:03:39+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.052971s ] [2021-07-20T15:03:39+08:00][sql] SELECT `status`,`status_type` FROM `v_doc_archive_file` WHERE `id` = 85 LIMIT 1 [ RunTime:0.051090s ] [2021-07-20T15:03:39+08:00][sql] SELECT `status`,`status_type` FROM `v_doc_archive_file` WHERE `id` = 84 LIMIT 1 [ RunTime:0.000891s ] [2021-07-20T15:03:39+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply_borrow` [ RunTime:0.011880s ] [2021-07-20T15:03:39+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 14 LIMIT 1 [ RunTime:0.012531s ] [2021-07-20T15:03:39+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.002355s ] [2021-07-20T15:03:39+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 11 LIMIT 1 [ RunTime:0.001956s ] [2021-07-20T15:03:39+08:00][sql] SELECT `status`,`status_type` FROM `v_doc_archive_file` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000738s ] [2021-07-20T15:03:39+08:00][sql] SELECT `status`,`status_type` FROM `v_doc_archive_file` WHERE `id` = 82 LIMIT 1 [ RunTime:0.000732s ] [2021-07-20T15:03:39+08:00][sql] SELECT `status`,`status_type` FROM `v_doc_archive_file` WHERE `id` = 78 LIMIT 1 [ RunTime:0.000643s ] [2021-07-20T15:03:39+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 10 LIMIT 1 [ RunTime:0.003228s ] [2021-07-20T15:03:39+08:00][sql] SELECT `status`,`status_type` FROM `v_doc_archive_file` WHERE `id` = 81 LIMIT 1 [ RunTime:0.000955s ] [2021-07-20T15:03:39+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 8 LIMIT 1 [ RunTime:0.002768s ] [2021-07-20T15:03:39+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 7 LIMIT 1 [ RunTime:0.002463s ] [2021-07-20T15:03:39+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 4 LIMIT 1 [ RunTime:0.034001s ] [2021-07-20T15:03:39+08:00][sql] SELECT `file_status`,`file_status_type` FROM `v_doc_apply_borrow` WHERE `id` = 2 LIMIT 1 [ RunTime:0.002400s ] [2021-07-20T15:03:39+08:00][sql] CONNECT:[ UseTime:0.022288s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:39+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.015435s ] [2021-07-20T15:03:39+08:00][sql] SELECT * FROM `v_doc_borrow_record` WHERE `apply_user_id` = '1' AND `status` = '2' AND `borrow_type_id` = '2' ORDER BY `return_time` DESC [ RunTime:0.000920s ] [2021-07-20T15:03:39+08:00][sql] CONNECT:[ UseTime:0.004399s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:39+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.012714s ] [2021-07-20T15:03:39+08:00][sql] SELECT * FROM `v_doc_apply` WHERE `next_exm_user_id` = '1' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' ORDER BY `exm_time` DESC LIMIT 0,20 [ RunTime:0.001115s ] [2021-07-20T15:03:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '1' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' [ RunTime:0.000707s ] [2021-07-20T15:03:39+08:00][sql] CONNECT:[ UseTime:0.005352s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:39+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.014209s ] [2021-07-20T15:03:39+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 1 [ RunTime:0.016359s ] [2021-07-20T15:03:40+08:00][sql] CONNECT:[ UseTime:0.012385s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:40+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.019458s ] [2021-07-20T15:03:40+08:00][sql] SELECT * FROM `v_doc_borrow_record` WHERE `apply_user_id` = '1' AND `status` = '2' AND `borrow_type_id` = '2' ORDER BY `return_time` DESC [ RunTime:0.000931s ] [2021-07-20T15:03:40+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.009195s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '1' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' [ RunTime:0.000581s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '1' [ RunTime:0.000638s ] [2021-07-20T15:03:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.008800s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000294s ] [2021-07-20T15:03:40+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.008859s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001844s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002662s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001884s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '1' AND `step` = '1' [ RunTime:0.000839s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '1' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' [ RunTime:0.000501s ] [2021-07-20T15:03:40+08:00][sql] CONNECT:[ UseTime:0.011711s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:40+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_borrow_record` [ RunTime:0.009633s ] [2021-07-20T15:03:40+08:00][sql] SELECT * FROM `v_doc_borrow_record` WHERE `apply_user_id` = '1' AND `status` = '2' AND `borrow_type_id` = '2' ORDER BY `return_time` DESC [ RunTime:0.001128s ] [2021-07-20T15:03:40+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_apply` [ RunTime:0.009583s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '1' AND `next_flow_node_role_id` = '1' AND `check_status` = '0' [ RunTime:0.000659s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_borrow_record` WHERE `apply_user_id` = '1' [ RunTime:0.000647s ] [2021-07-20T15:03:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_project` [ RunTime:0.009357s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `t_doc_project` [ RunTime:0.000317s ] [2021-07-20T15:03:40+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.009873s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.002030s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '1' [ RunTime:0.002817s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `status` = '2' [ RunTime:0.001945s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `apply_user_id` = '1' AND `step` = '1' [ RunTime:0.001038s ] [2021-07-20T15:03:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_apply` WHERE `next_exm_user_id` = '1' AND `next_flow_node_role_id` = '1' AND `check_status` = '1' [ RunTime:0.000766s ] [2021-07-20T15:03:41+08:00][sql] CONNECT:[ UseTime:0.035851s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:41+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.021146s ] [2021-07-20T15:03:41+08:00][sql] SELECT * FROM `v_doc_project` ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000706s ] [2021-07-20T15:03:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` [ RunTime:0.000418s ] [2021-07-20T15:03:41+08:00][sql] CONNECT:[ UseTime:0.019531s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:41+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.009394s ] [2021-07-20T15:03:41+08:00][sql] SELECT * FROM `v_doc_archive_file` [ RunTime:0.007899s ] [2021-07-20T15:03:41+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.009243s ] [2021-07-20T15:03:41+08:00][sql] SELECT `profession_type` FROM `t_doc_dict_profession_type` [ RunTime:0.000394s ] [2021-07-20T15:03:42+08:00][sql] CONNECT:[ UseTime:0.001900s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:42+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_borrow_type` [ RunTime:0.010092s ] [2021-07-20T15:03:42+08:00][sql] SELECT * FROM `t_doc_dict_borrow_type` [ RunTime:0.000428s ] [2021-07-20T15:03:43+08:00][sql] CONNECT:[ UseTime:0.012451s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:43+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_project` [ RunTime:0.009287s ] [2021-07-20T15:03:43+08:00][sql] SELECT * FROM `v_doc_project` ORDER BY `create_date` DESC LIMIT 0,15 [ RunTime:0.000720s ] [2021-07-20T15:03:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_project` [ RunTime:0.000395s ] [2021-07-20T15:03:45+08:00][sql] CONNECT:[ UseTime:0.011562s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:45+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_template_project_menu` [ RunTime:0.008930s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `status` = 1 AND `project_no` = '13132234' [ RunTime:0.000408s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000325s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1.1' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000356s ] [2021-07-20T15:03:45+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_profession_type` [ RunTime:0.008824s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000357s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '1.2' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000383s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000307s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000251s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000296s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2.1' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000327s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000246s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '2.2' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000340s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000291s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000317s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000370s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3.1' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000294s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000286s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_template_project_menu` WHERE `tep_menu_pid` = '3.2' AND `project_no` = '13132234' AND `status` = 1 [ RunTime:0.000342s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000250s ] [2021-07-20T15:03:45+08:00][sql] SELECT * FROM `t_doc_dict_profession_type` WHERE `profession_id` = 1 LIMIT 1 [ RunTime:0.000257s ] [2021-07-20T15:03:47+08:00][sql] CONNECT:[ UseTime:0.009292s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:47+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_dict_borrow_type` [ RunTime:0.009804s ] [2021-07-20T15:03:47+08:00][sql] SELECT * FROM `t_doc_dict_borrow_type` [ RunTime:0.000389s ] [2021-07-20T15:03:47+08:00][sql] CONNECT:[ UseTime:0.004548s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:47+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_archive_file` [ RunTime:0.010571s ] [2021-07-20T15:03:47+08:00][sql] SELECT * FROM `v_doc_archive_file` WHERE `file_menu_id` = '1.1' AND `project_no` = '13132234' AND `status` = '2' ORDER BY `modify_time` DESC LIMIT 0,15 [ RunTime:0.001405s ] [2021-07-20T15:03:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `v_doc_archive_file` WHERE `file_menu_id` = '1.1' AND `project_no` = '13132234' AND `status` = '2' [ RunTime:0.002127s ] [2021-07-20T15:03:49+08:00][sql] CONNECT:[ UseTime:0.002860s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:49+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_flow` [ RunTime:0.030077s ] [2021-07-20T15:03:49+08:00][sql] SELECT * FROM `v_doc_flow` WHERE `pre_node_id` = '1' AND `flow_no` = '1' [ RunTime:0.010094s ] [2021-07-20T15:03:50+08:00][sql] CONNECT:[ UseTime:0.001482s ] mysql:host=localhost;port=3306;dbname=document;charset=utf8mb4 [2021-07-20T15:03:50+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.009867s ] [2021-07-20T15:03:50+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `role_id` = 6 [ RunTime:0.000591s ]