--------------------------------------------------------------- [2023-01-11T01:59:22+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000701s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.072580s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.052119s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 55 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000554s ] --------------------------------------------------------------- [2023-01-11T01:59:22+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000974s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048460s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.060360s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 55 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.049174s ] [ 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` = 55 [ RunTime:0.001553s ] --------------------------------------------------------------- [2023-01-11T01:59:34+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000495s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.071457s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000674s ] [ 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` = 55 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.063135s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 55 LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [2023-01-11T01:59:34+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000919s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051971s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.114628s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 55 AND `status` = 0 [ RunTime:0.000534s ] --------------------------------------------------------------- [2023-01-11T01:59:36+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000760s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045366s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.042287s ] [ 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` = 55 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000936s ] --------------------------------------------------------------- [2023-01-11T01:59:46+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000793s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032558s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.029175s ] [ 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` = 55 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000879s ] --------------------------------------------------------------- [2023-01-11T01:59:52+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/My/myCreateTask [ 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.054077s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.040481s ] [ 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` = 55 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.000814s ] --------------------------------------------------------------- [2023-01-11T02:00:40+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000781s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033842s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.032255s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 55 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.025821s ] [ 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.000783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022307s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000619s ] --------------------------------------------------------------- [2023-01-11T02:00:49+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000787s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032590s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024331s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 55 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.026035s ] [ 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.000812s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022945s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000454s ] --------------------------------------------------------------- [2023-01-11T02:00:50+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/Item/cityInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000811s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045873s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.041968s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 55 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.041224s ] [ 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.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.038291s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 5 AND `parent_id` = 3 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000579s ] --------------------------------------------------------------- [2023-01-11T02:00:52+08:00] 106.44.63.186 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.002485s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035930s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '55|ba613c44175489fa078d5fc7bdb19f60' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000801s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027502s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 55 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.026886s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `city_id` = 5 AND `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000967s ] [ 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 `city_id` = 5 AND `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,100 [ RunTime:0.000737s ]