--------------------------------------------------------------- [2021-12-30T10:01:39+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000774s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035745s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15313233596' LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.026262s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('15313233596' , 0 , 584857 , 1640829699 , '2021-12-30 10:01:39') [ RunTime:0.004561s ] --------------------------------------------------------------- [2021-12-30T10:01:55+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000705s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.034629s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '15313233596' AND `phone_code` = '584857' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.015878s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0026' , 1 , 0 , 0 , 1640829715 , '2021-12-30 10:01:55') [ RunTime:0.003722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020308s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('15313233596' , '0592adf727386b178dc2b4e14c625968' , '0026' , 0 , 0 , 1640829715 , '2021-12-30 10:01:55' , 1640829715 , 35) [ RunTime:0.002165s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018257s ] [ sql ] [ SQL ] INSERT INTO `v_staff_action` (`status` , `is_delete` , `create_time` , `create_date` , `is_create_item` , `is_create_task` , `staff_id`) VALUES (0 , 0 , 1640829715 , '2021-12-30 10:01:55' , 1 , 1 , 45) [ RunTime:0.003907s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025412s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1640829715 , '2021-12-30 10:01:55' , 45) [ RunTime:0.003399s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '45|c1f7e631c6be5026f68643432caff274' WHERE `id` = 45 [ RunTime:0.003330s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 17 [ RunTime:0.003253s ] --------------------------------------------------------------- [2021-12-30T10:02:21+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.012122s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027747s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '张云' , `sex` = 2 WHERE `id` = 45 [ RunTime:0.000417s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018654s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 45 [ RunTime:0.000496s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.016921s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 45,1,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,2,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,3,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,4,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,5,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,6,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,7,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,8,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,9,0,1640829741,'2021-12-30 10:02:21' ) , ( 45,10,0,1640829741,'2021-12-30 10:02:21' ) [ RunTime:0.001153s ] --------------------------------------------------------------- [2021-12-30T10:02:22+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000667s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033707s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028775s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000451s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.027218s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 45 [ RunTime:0.001008s ] --------------------------------------------------------------- [2021-12-30T10:02:22+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000708s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016462s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.016512s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000539s ] --------------------------------------------------------------- [2021-12-30T10:02:37+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000996s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039596s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023965s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025277s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000921s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000650s ] --------------------------------------------------------------- [2021-12-30T10:02:39+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000854s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030426s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019490s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018790s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.017294s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000527s ] --------------------------------------------------------------- [2021-12-30T10:02:39+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.002716s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022487s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022638s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.015503s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000717s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 20,20 [ RunTime:0.000507s ] --------------------------------------------------------------- [2021-12-30T10:02:41+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.010287s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025462s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017986s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018343s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000745s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000557s ] --------------------------------------------------------------- [2021-12-30T10:02:44+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Hospital/hospitalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010889s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025370s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017877s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` = 1 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018968s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `hospital_id` = 1 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC [ RunTime:0.000689s ] --------------------------------------------------------------- [2021-12-30T10:02:52+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Hospital/hospitalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.018012s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032793s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.040881s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` = 5 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.033476s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `hospital_id` = 5 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC [ RunTime:0.000637s ] --------------------------------------------------------------- [2021-12-30T10:02:56+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008867s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023886s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SELECT `s`.`id`,`s`.`job_num`,`s`.`name`,`s`.`sex`,`s`.`phone`,se.name as sector_name,p.name as position_name FROM v_staff s LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`id` = 45 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.033611s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 45 LIMIT 1 [ RunTime:0.000528s ] --------------------------------------------------------------- [2021-12-30T10:02:56+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000607s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016161s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019195s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 45 AND `status` = 0 [ RunTime:0.000418s ] --------------------------------------------------------------- [2021-12-30T10:03:01+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000653s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025655s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020037s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`staff_id` = 45 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.001029s ] --------------------------------------------------------------- [2021-12-30T10:03:02+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.001282s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024977s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.018351s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 45 AND `d`.`is_delete` = 0 [ RunTime:0.000584s ] --------------------------------------------------------------- [2021-12-30T10:03:04+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.004057s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024384s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.016953s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `staff_id` = 45 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000655s ] --------------------------------------------------------------- [2021-12-30T10:03:06+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.001091s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024536s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018328s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`create_staff_id` = 45 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000733s ] --------------------------------------------------------------- [2021-12-30T10:03:08+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.008568s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024407s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019482s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`create_staff_id` = 45 AND `t`.`staff_id` > 0 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000768s ] --------------------------------------------------------------- [2021-12-30T10:03:17+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000696s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026360s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018665s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`staff_id` = 45 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000735s ] --------------------------------------------------------------- [2021-12-30T10:03:29+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001022s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046198s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021900s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000496s ] --------------------------------------------------------------- [2021-12-30T10:03:30+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000498s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026426s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.050111s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000856s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019385s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 45 [ RunTime:0.000817s ] --------------------------------------------------------------- [2021-12-30T10:03:33+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001162s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032587s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.042127s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [2021-12-30T10:03:34+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000874s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026686s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029213s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017447s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 45 [ RunTime:0.000743s ] --------------------------------------------------------------- [2021-12-30T10:03:37+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000745s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032710s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.036051s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023246s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 45 [ RunTime:0.000917s ] --------------------------------------------------------------- [2021-12-30T10:03:37+08:00] 111.163.121.92 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001179s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024713s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '45|c1f7e631c6be5026f68643432caff274' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.053988s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 45 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000583s ]