--------------------------------------------------------------- [2020-01-12T15:28:40+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/sector/index.html?spm=m-4-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.013868s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.027565s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000609s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000542s ] --------------------------------------------------------------- [2020-01-12T15:28:41+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.008304s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022691s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 [ RunTime:0.000875s ] [ sql ] [ SQL ] SELECT `s`.*,se.name as sector_name,p.name as position_name,`a`.`is_create_item`,`a`.`is_create_task` FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 ORDER BY `s`.`id` DESC LIMIT 0,10 [ RunTime:0.000756s ] --------------------------------------------------------------- [2020-01-12T15:28:44+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000853s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023736s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 [ RunTime:0.000773s ] [ sql ] [ SQL ] SELECT `s`.*,se.name as sector_name,p.name as position_name,`a`.`is_create_item`,`a`.`is_create_task` FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 ORDER BY `s`.`id` DESC LIMIT 10,10 [ RunTime:0.000806s ] --------------------------------------------------------------- [2020-01-12T15:29:31+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.011273s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024982s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15357531308' LIMIT 1 [ RunTime:0.000552s ] --------------------------------------------------------------- [2020-01-12T15:30:33+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.005053s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023954s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15357531308' LIMIT 1 [ RunTime:0.000547s ] --------------------------------------------------------------- [2020-01-12T15:30:41+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.008547s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029234s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15357531308' LIMIT 1 [ RunTime:0.000654s ] --------------------------------------------------------------- [2020-01-12T15:39:52+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000864s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024392s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15357531308' LIMIT 1 [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.021755s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('15357531308' , 0 , 927171 , 1578814792 , '2020-01-12 15:39:52') [ RunTime:0.004189s ] --------------------------------------------------------------- [2020-01-12T15:42:28+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000769s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025124s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15357531308' LIMIT 1 [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.020195s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('15357531308' , 0 , 112483 , 1578814948 , '2020-01-12 15:42:28') [ RunTime:0.003466s ] --------------------------------------------------------------- [2020-01-12T15:42:53+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000765s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.021708s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '15357531308' AND `phone_code` = '112483' LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.015493s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0019' , 1 , 0 , 0 , 1578814973 , '2020-01-12 15:42:53') [ RunTime:0.003710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017505s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('15357531308' , 'cd48cc70f2b45da4747a9f18a32648da' , '0019' , 0 , 0 , 1578814973 , '2020-01-12 15:42:53' , 1578814973 , 28) [ RunTime:0.002408s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017657s ] [ 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 , 1578814973 , '2020-01-12 15:42:53' , 1 , 1 , 36) [ RunTime:0.003390s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025508s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1578814973 , '2020-01-12 15:42:53' , 36) [ RunTime:0.002994s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '36|4ca85fa9ccc0ab838b9588b6ffd1e463' WHERE `id` = 36 [ RunTime:0.002121s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 10 [ RunTime:0.002202s ] --------------------------------------------------------------- [2020-01-12T15:52:59+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.009231s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026958s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15357531308' LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.018742s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('15357531308' , 0 , 218656 , 1578815579 , '2020-01-12 15:52:59') [ RunTime:0.003458s ] --------------------------------------------------------------- [2020-01-12T15:53:31+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.009996s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.025621s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '15357531308' AND `phone_code` = '218656' LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.016340s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0020' , 1 , 0 , 0 , 1578815611 , '2020-01-12 15:53:31') [ RunTime:0.005681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020331s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('15357531308' , 'cd48cc70f2b45da4747a9f18a32648da' , '0020' , 0 , 0 , 1578815611 , '2020-01-12 15:53:31' , 1578815611 , 29) [ RunTime:0.005262s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019295s ] [ 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 , 1578815611 , '2020-01-12 15:53:31' , 1 , 1 , 37) [ RunTime:0.003501s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025700s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1578815611 , '2020-01-12 15:53:31' , 37) [ RunTime:0.002610s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '37|f251dfab5b123f80886df0bb54f521e7' WHERE `id` = 37 [ RunTime:0.001842s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 11 [ RunTime:0.002437s ] --------------------------------------------------------------- [2020-01-12T15:55:02+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000989s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023839s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '37|f251dfab5b123f80886df0bb54f521e7' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = 'Liukaixiang' , `sex` = 2 WHERE `id` = 37 [ RunTime:0.000489s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017536s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 37 [ RunTime:0.000509s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.015718s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 37,1,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,2,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,3,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,4,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,5,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,6,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,7,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,8,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,9,0,1578815702,'2020-01-12 15:55:02' ) , ( 37,10,0,1578815702,'2020-01-12 15:55:02' ) [ RunTime:0.001073s ] --------------------------------------------------------------- [2020-01-12T15:55:03+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001203s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030323s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '37|f251dfab5b123f80886df0bb54f521e7' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001105s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029454s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 37 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000656s ] --------------------------------------------------------------- [2020-01-12T15:55:03+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.014189s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043070s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '37|f251dfab5b123f80886df0bb54f521e7' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030314s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 37 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017858s ] [ 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) [ RunTime:0.000854s ] --------------------------------------------------------------- [2020-01-12T15:55:15+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.007182s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042361s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '37|f251dfab5b123f80886df0bb54f521e7' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030277s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 37 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.029828s ] [ 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.001069s ] [ 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.000886s ] --------------------------------------------------------------- [2020-01-12T15:55:15+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.013887s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028819s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '37|f251dfab5b123f80886df0bb54f521e7' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031719s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 37 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001348s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.031076s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025702s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000521s ] --------------------------------------------------------------- [2020-01-12T15:55:18+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000937s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029439s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '37|f251dfab5b123f80886df0bb54f521e7' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000732s ] [ 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` = 37 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.034370s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 37 LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [2020-01-12T15:55:18+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000703s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033125s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '37|f251dfab5b123f80886df0bb54f521e7' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.033814s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 37 AND `status` = 0 [ RunTime:0.000537s ]