--------------------------------------------------------------- [2019-12-21T22:59:14+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008300s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020531s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005639s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.023461s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.005582s ] --------------------------------------------------------------- [2019-12-21T22:59:35+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.004958s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023791s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003465s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003429s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.028544s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003439s ] --------------------------------------------------------------- [2019-12-21T22:59:35+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.004667s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020394s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003187s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003178s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030676s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003182s ] --------------------------------------------------------------- [2019-12-21T23:00:56+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.018169s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026422s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004157s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004101s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025330s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004109s ] --------------------------------------------------------------- [2019-12-21T23:00:57+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007414s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019362s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005017s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005005s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030122s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.005055s ] --------------------------------------------------------------- [2019-12-21T23:02:23+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.013148s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026337s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003672s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026167s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003627s ] --------------------------------------------------------------- [2019-12-21T23:02:23+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007228s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020211s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004780s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.023440s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004729s ] --------------------------------------------------------------- [2019-12-21T23:04:23+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005027s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026828s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003396s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003390s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029618s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003394s ] --------------------------------------------------------------- [2019-12-21T23:04:23+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.019658s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021801s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006522s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006315s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026503s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006398s ] --------------------------------------------------------------- [2019-12-21T23:05:07+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010062s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031351s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006785s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030206s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006831s ] --------------------------------------------------------------- [2019-12-21T23:05:07+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007981s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021228s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005428s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005378s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024823s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.005484s ] --------------------------------------------------------------- [2019-12-21T23:05:21+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005935s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027148s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004077s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003990s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.028759s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004052s ] --------------------------------------------------------------- [2019-12-21T23:05:21+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005677s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018423s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003839s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003810s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.035276s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003845s ] --------------------------------------------------------------- [2019-12-21T23:06:04+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.004910s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026443s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003822s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003832s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025293s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003358s ] --------------------------------------------------------------- [2019-12-21T23:06:05+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.011066s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028227s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007422s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.007444s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029098s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.007471s ] --------------------------------------------------------------- [2019-12-21T23:06:57+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003534s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025545s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002389s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.002312s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026511s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.002382s ] --------------------------------------------------------------- [2019-12-21T23:06:57+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.006637s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021248s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004475s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004470s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.022526s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004525s ] --------------------------------------------------------------- [2019-12-21T23:13:42+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005477s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026660s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003595s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026612s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003592s ] --------------------------------------------------------------- [2019-12-21T23:13:42+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.006990s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026163s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004655s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030121s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004700s ] --------------------------------------------------------------- [2019-12-21T23:17:07+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.014536s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028166s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006304s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006293s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027106s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006263s ] --------------------------------------------------------------- [2019-12-21T23:17:31+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.006651s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025970s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004555s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004499s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026577s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004566s ] --------------------------------------------------------------- [2019-12-21T23:17:32+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005629s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024176s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003813s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003804s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025109s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003759s ] --------------------------------------------------------------- [2019-12-21T23:17:37+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.009160s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026682s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006145s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006185s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.033208s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006266s ] --------------------------------------------------------------- [2019-12-21T23:17:38+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007619s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025583s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005092s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005068s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025782s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.005037s ] --------------------------------------------------------------- [2019-12-21T23:18:51+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.009791s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028266s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006553s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027310s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006491s ] --------------------------------------------------------------- [2019-12-21T23:19:30+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.004840s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026375s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003433s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003323s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024769s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003284s ] --------------------------------------------------------------- [2019-12-21T23:20:11+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.006873s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027019s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004711s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029042s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004692s ] --------------------------------------------------------------- [2019-12-21T23:20:57+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005481s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024176s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003722s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025485s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003696s ] --------------------------------------------------------------- [2019-12-21T23:21:23+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003564s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025698s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002517s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.002465s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024313s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.002453s ] --------------------------------------------------------------- [2019-12-21T23:21:46+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.004807s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023773s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003305s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003277s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.028080s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003267s ] --------------------------------------------------------------- [2019-12-21T23:21:47+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003536s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022864s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002406s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.002386s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.023613s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.002367s ] --------------------------------------------------------------- [2019-12-21T23:23:44+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007087s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023850s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003430s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.003410s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024366s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003368s ] --------------------------------------------------------------- [2019-12-21T23:23:45+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.006549s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.054852s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027705s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004447s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.029547s ] [ 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 (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) [ RunTime:0.006138s ] [ 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 `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.008007s ] --------------------------------------------------------------- [2019-12-21T23:23:45+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008640s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043255s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.026261s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005453s ] --------------------------------------------------------------- [2019-12-21T23:23:45+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.009425s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.053615s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005765s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.025701s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018319s ] [ 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 (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) [ RunTime:0.006595s ] [ 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 `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.007036s ] --------------------------------------------------------------- [2019-12-21T23:23:52+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007400s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026823s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005020s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005015s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.031591s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.005057s ] --------------------------------------------------------------- [2019-12-21T23:23:55+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.005731s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034524s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004023s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.025947s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.004311s ] --------------------------------------------------------------- [2019-12-21T23:23:55+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.006808s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024072s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021033s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.004774s ] --------------------------------------------------------------- [2019-12-21T23:24:33+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010793s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029520s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007252s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.027856s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 10 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.007675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.027020s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 10 AND `remind_date` >= '2019-12-21' [ RunTime:0.007072s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.023906s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 10 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.007062s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.032850s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 10 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.007065s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.022754s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 10 AND `t`.`type` = 2 [ RunTime:0.007117s ] --------------------------------------------------------------- [2019-12-21T23:24:36+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.008320s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036039s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005771s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026468s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.006085s ] --------------------------------------------------------------- [2019-12-21T23:24:36+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.005782s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029874s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003866s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018773s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.004087s ] --------------------------------------------------------------- [2019-12-21T23:24:39+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005275s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.064192s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004024s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.050439s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004466s ] --------------------------------------------------------------- [2019-12-21T23:24:39+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.012690s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044687s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004910s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.040829s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.045877s ] [ 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 (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) [ RunTime:0.006345s ] [ 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 `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.006449s ] --------------------------------------------------------------- [2019-12-21T23:24:41+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.007480s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029256s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004799s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031063s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004769s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.026321s ] [ 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 (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) [ RunTime:0.006095s ] [ 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 `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`id`,`i`.`status` LIMIT 40,20 [ RunTime:0.006571s ] --------------------------------------------------------------- [2019-12-21T23:24:42+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.007443s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040599s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005290s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039612s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004934s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.038699s ] [ 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 ('1063','1817','1860','1864','1870','1872','1875','1877','1878','1879','1880','1881','1882','1883','1884','1886','1887','1890','1893','1895','1904','1906','5879','5881','5882','5884','5887','5890','5891','5892','5896','5897','5898','5901','5909','5910','19119','19121','19124','19125','19126','19127','19128','19131','19132','19134','19135','19141','19143','19144','19152','19154','19164') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.006794s ] [ 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 ('1063','1817','1860','1864','1870','1872','1875','1877','1878','1879','1880','1881','1882','1883','1884','1886','1887','1890','1893','1895','1904','1906','5879','5881','5882','5884','5887','5890','5891','5892','5896','5897','5898','5901','5909','5910','19119','19121','19124','19125','19126','19127','19128','19131','19132','19134','19135','19141','19143','19144','19152','19154','19164') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.006713s ] --------------------------------------------------------------- [2019-12-21T23:24:42+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.008082s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037319s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039243s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.051670s ] [ 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 ('1063','1817','1860','1864','1870','1872','1875','1877','1878','1879','1880','1881','1882','1883','1884','1886','1887','1890','1893','1895','1904','1906','5879','5881','5882','5884','5887','5890','5891','5892','5896','5897','5898','5901','5909','5910','19119','19121','19124','19125','19126','19127','19128','19131','19132','19134','19135','19141','19143','19144','19152','19154','19164') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.006873s ] [ 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 ('1063','1817','1860','1864','1870','1872','1875','1877','1878','1879','1880','1881','1882','1883','1884','1886','1887','1890','1893','1895','1904','1906','5879','5881','5882','5884','5887','5890','5891','5892','5896','5897','5898','5901','5909','5910','19119','19121','19124','19125','19126','19127','19128','19131','19132','19134','19135','19141','19143','19144','19152','19154','19164') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 20,20 [ RunTime:0.008390s ] --------------------------------------------------------------- [2019-12-21T23:24:42+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005939s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.090391s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004228s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.041396s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004072s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.041392s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.005347s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.053017s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (20,47,320) AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.007419s ] --------------------------------------------------------------- [2019-12-21T23:24:44+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.005719s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029448s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003940s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023696s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.004032s ] --------------------------------------------------------------- [2019-12-21T23:24:44+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.007805s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030399s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005086s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.031384s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.005196s ] --------------------------------------------------------------- [2019-12-21T23:24:46+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.005731s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030936s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.028188s ] [ 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` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.003883s ] --------------------------------------------------------------- [2019-12-21T23:24:46+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.005057s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037582s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003779s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.037219s ] [ 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` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.003563s ] --------------------------------------------------------------- [2019-12-21T23:24:49+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.004663s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031043s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003549s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024796s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.003579s ] --------------------------------------------------------------- [2019-12-21T23:24:49+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.011431s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046416s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.030696s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.007954s ] --------------------------------------------------------------- [2019-12-21T23:24:56+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.007018s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033087s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004968s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023293s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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` = 16 AND `i`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.004937s ] --------------------------------------------------------------- [2019-12-21T23:24:56+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.008807s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042833s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006119s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031332s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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` = 16 AND `i`.`is_delete` = 0 LIMIT 20,20 [ RunTime:0.006123s ] --------------------------------------------------------------- [2019-12-21T23:26:32+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007451s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026905s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004878s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004940s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026290s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004901s ] --------------------------------------------------------------- [2019-12-21T23:26:32+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.007138s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019382s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004986s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.029565s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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` = 16 AND `i`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.005302s ] --------------------------------------------------------------- [2019-12-21T23:26:32+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.007102s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019346s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004866s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018684s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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` = 16 AND `i`.`is_delete` = 0 LIMIT 20,20 [ RunTime:0.004886s ] --------------------------------------------------------------- [2019-12-21T23:26:34+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.003538s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027260s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002377s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026494s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.002597s ] --------------------------------------------------------------- [2019-12-21T23:26:34+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.006963s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029699s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004735s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.031064s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.004709s ] --------------------------------------------------------------- [2019-12-21T23:27:35+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010035s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027325s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006787s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006767s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027921s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006840s ] --------------------------------------------------------------- [2019-12-21T23:27:36+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.005557s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023328s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003990s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.036481s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.004602s ] --------------------------------------------------------------- [2019-12-21T23:27:36+08:00] 115.60.54.45 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.005427s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020459s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|46827ff22d1a2e8a66a9440918a13e8e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.017807s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`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 `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.003932s ]