--------------------------------------------------------------- [2020-01-09T00:07:16+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.000752s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024396s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0118' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017259s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000541s ] --------------------------------------------------------------- [2020-01-09T00:07:17+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000949s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033292s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000771s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023797s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.030807s ] [ 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` = 17261 [ RunTime:0.000754s ] [ 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` = 17261 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000953s ] --------------------------------------------------------------- [2020-01-09T00:07:17+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002586s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021214s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030583s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000547s ] --------------------------------------------------------------- [2020-01-09T00:07:36+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001098s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033501s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000811s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.032568s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000701s ] --------------------------------------------------------------- [2020-01-09T00:07:36+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000845s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020524s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019080s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000567s ] --------------------------------------------------------------- [2020-01-09T00:08:56+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003004s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027596s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018322s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 31 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018427s ] [ 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 `item_id` = 31 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000682s ] --------------------------------------------------------------- [2020-01-09T00:08:59+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskType [ sql ] [ DB ] CONNECT:[ UseTime:0.000938s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032767s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000947s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.034671s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_task_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000724s ] --------------------------------------------------------------- [2020-01-09T00:08:59+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskNature [ 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.019426s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001168s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.034540s ] [ sql ] [ SQL ] SELECT n.id as nature_id,n.name as nature_name,`task_level_id`,l.name as level_name FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`status` = 0 AND `n`.`is_delete` = 0 [ RunTime:0.000647s ] --------------------------------------------------------------- [2020-01-09T00:09:41+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000758s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024586s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017281s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018198s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000752s ] --------------------------------------------------------------- [2020-01-09T00:09:52+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000745s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027121s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020118s ] [ 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` = 60 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000905s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.030606s ] [ sql ] [ SQL ] SELECT `c`.`name`,`c`.`duty`,`c`.`phone`,`c`.`office_tel`,`c`.`email`,`c`.`remark`,h.name as hospital_name,`h`.`addess` FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 26 LIMIT 0,1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.019629s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 60 AND `remind_date` >= '2020-01-09' [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.018659s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 60 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.027084s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 60 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000565s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 4 WHERE `id` = 60 [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024323s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `overdue_task_num` = `overdue_task_num` + 1 WHERE `staff_id` = 31 [ RunTime:0.000473s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `ongoing_task_num` = `ongoing_task_num` - 1 WHERE `staff_id` = 31 [ RunTime:0.000376s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000423s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000391s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.022874s ] [ 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` = 60 AND `t`.`type` = 2 [ RunTime:0.000638s ] --------------------------------------------------------------- [2020-01-09T00:09:52+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000879s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029896s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000799s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029070s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000760s ] --------------------------------------------------------------- [2020-01-09T00:09:52+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000871s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035051s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018538s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000548s ] --------------------------------------------------------------- [2020-01-09T00:09:54+08:00] 175.157.50.73 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000856s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033833s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000732s ] --------------------------------------------------------------- [2020-01-09T00:09:54+08:00] 175.157.50.73 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000807s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019972s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000604s ] --------------------------------------------------------------- [2020-01-09T00:09:57+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010824s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024664s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019943s ] [ 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` = 58 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000934s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.031127s ] [ sql ] [ SQL ] SELECT `c`.`name`,`c`.`duty`,`c`.`phone`,`c`.`office_tel`,`c`.`email`,`c`.`remark`,h.name as hospital_name,`h`.`addess` FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 26 LIMIT 0,1 [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.019325s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 58 AND `remind_date` >= '2020-01-09' [ RunTime:0.000716s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.018827s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 58 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.027019s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 58 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017212s ] [ 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` = 58 AND `t`.`type` = 2 [ RunTime:0.000640s ] --------------------------------------------------------------- [2020-01-09T00:09:57+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000833s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029846s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000705s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.034569s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [2020-01-09T00:09:57+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000702s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031137s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.041484s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000556s ] --------------------------------------------------------------- [2020-01-09T00:10:15+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.014991s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024897s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018635s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000747s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019826s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000839s ] --------------------------------------------------------------- [2020-01-09T00:10:17+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000802s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023414s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.027954s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 31 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.028198s ] [ 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 `item_id` = 31 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000760s ] --------------------------------------------------------------- [2020-01-09T00:10:18+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000731s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023059s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017200s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018235s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000822s ] --------------------------------------------------------------- [2020-01-09T00:10:23+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000744s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022600s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019597s ] [ 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` = 60 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000893s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.030933s ] [ sql ] [ SQL ] SELECT `c`.`name`,`c`.`duty`,`c`.`phone`,`c`.`office_tel`,`c`.`email`,`c`.`remark`,h.name as hospital_name,`h`.`addess` FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 26 LIMIT 0,1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.018573s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 60 AND `remind_date` >= '2020-01-09' [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.016966s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 60 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000501s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.026258s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 60 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000564s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.019039s ] [ 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` = 60 AND `t`.`type` = 2 [ RunTime:0.000712s ] --------------------------------------------------------------- [2020-01-09T00:10:23+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000986s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023209s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001108s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030915s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [2020-01-09T00:10:23+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000865s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028470s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.016809s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000568s ] --------------------------------------------------------------- [2020-01-09T00:10:25+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000765s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022586s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024849s ] [ 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` = 60 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.029681s ] [ sql ] [ SQL ] SELECT `c`.`name`,`c`.`duty`,`c`.`phone`,`c`.`office_tel`,`c`.`email`,`c`.`remark`,h.name as hospital_name,`h`.`addess` FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 26 LIMIT 0,1 [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.018422s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 60 AND `remind_date` >= '2020-01-09' [ RunTime:0.000569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.018053s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 60 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028086s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 60 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.018141s ] [ 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` = 60 AND `t`.`type` = 2 [ RunTime:0.000629s ] --------------------------------------------------------------- [2020-01-09T00:10:25+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000540s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022457s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000758s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.038582s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000747s ] --------------------------------------------------------------- [2020-01-09T00:10:25+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.001080s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035730s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.042851s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000644s ] --------------------------------------------------------------- [2020-01-09T00:10:35+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000761s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024304s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021011s ] [ 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` = 58 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000970s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.036411s ] [ sql ] [ SQL ] SELECT `c`.`name`,`c`.`duty`,`c`.`phone`,`c`.`office_tel`,`c`.`email`,`c`.`remark`,h.name as hospital_name,`h`.`addess` FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 26 LIMIT 0,1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.025573s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 58 AND `remind_date` >= '2020-01-09' [ RunTime:0.000587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.018016s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 58 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028838s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 58 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.016730s ] [ 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` = 58 AND `t`.`type` = 2 [ RunTime:0.000588s ] --------------------------------------------------------------- [2020-01-09T00:10:35+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001509s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023222s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000817s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.031511s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000822s ] --------------------------------------------------------------- [2020-01-09T00:10:35+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000789s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032195s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018490s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000588s ] --------------------------------------------------------------- [2020-01-09T00:10:38+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000744s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023140s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019391s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000799s ] --------------------------------------------------------------- [2020-01-09T00:13:51+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000812s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024985s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019968s ] [ 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` = 31 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.001037s ] --------------------------------------------------------------- [2020-01-09T00:13:53+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000795s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024242s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019476s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000947s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019849s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000824s ] --------------------------------------------------------------- [2020-01-09T00:13:55+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000739s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023291s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.020225s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 31 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018117s ] [ 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 `item_id` = 31 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000767s ] --------------------------------------------------------------- [2020-01-09T00:14:01+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.006366s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022459s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017891s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018754s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000755s ] --------------------------------------------------------------- [2020-01-09T00:14:09+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskType [ sql ] [ DB ] CONNECT:[ UseTime:0.000848s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030034s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001401s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.029681s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_task_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000894s ] --------------------------------------------------------------- [2020-01-09T00:14:09+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskNature [ sql ] [ DB ] CONNECT:[ UseTime:0.000727s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029511s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.034204s ] [ sql ] [ SQL ] SELECT n.id as nature_id,n.name as nature_name,`task_level_id`,l.name as level_name FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`status` = 0 AND `n`.`is_delete` = 0 [ RunTime:0.000575s ] --------------------------------------------------------------- [2020-01-09T00:14:16+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskNature [ sql ] [ DB ] CONNECT:[ UseTime:0.000578s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023193s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.024902s ] [ sql ] [ SQL ] SELECT n.id as nature_id,n.name as nature_name,`task_level_id`,l.name as level_name FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`status` = 0 AND `n`.`is_delete` = 0 [ RunTime:0.000572s ] --------------------------------------------------------------- [2020-01-09T00:14:16+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskType [ sql ] [ DB ] CONNECT:[ UseTime:0.000912s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046711s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.032692s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_task_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000488s ] --------------------------------------------------------------- [2020-01-09T00:14:30+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskStaff [ sql ] [ DB ] CONNECT:[ UseTime:0.008060s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022695s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019232s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 27 AND `status` = 0 LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.015890s ] [ sql ] [ SQL ] SELECT `staff_id` FROM `v_staff_hospital` WHERE `hospital_id` = 17261 AND `is_delete` = 0 [ RunTime:0.013953s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`name` FROM `v_staff` WHERE `id` IN (19,24,25,31) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000601s ] --------------------------------------------------------------- [2020-01-09T00:14:31+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskStaff [ sql ] [ DB ] CONNECT:[ UseTime:0.000734s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024098s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017865s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 27 AND `status` = 0 LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.016410s ] [ sql ] [ SQL ] SELECT `staff_id` FROM `v_staff_hospital` WHERE `hospital_id` = 17261 AND `is_delete` = 0 [ RunTime:0.013945s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`name` FROM `v_staff` WHERE `id` IN (19,24,25,31) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000580s ] --------------------------------------------------------------- [2020-01-09T00:15:04+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskAdd [ sql ] [ DB ] CONNECT:[ UseTime:0.006985s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022301s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] --------------------------------------------------------------- [2020-01-09T00:15:12+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskAdd [ sql ] [ DB ] CONNECT:[ UseTime:0.004040s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024129s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017818s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018257s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 27 AND `hospital_id` = 17261 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.018120s ] [ sql ] [ SQL ] SELECT `id` FROM `v_task_type` WHERE `id` = 2 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.017470s ] [ sql ] [ SQL ] SELECT `task_level_id` FROM `v_task_nature` WHERE `id` = 4 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019809s ] [ sql ] [ SQL ] SELECT `id` FROM `v_task` WHERE `task_num` = '202001097351' LIMIT 1 [ RunTime:0.000479s ] [ sql ] [ SQL ] INSERT INTO `v_task` (`item_id` , `name` , `task_type_id` , `task_nature_id` , `staff_id` , `start_date` , `start_time` , `end_date` , `end_time` , `task_content` , `status` , `is_delete` , `create_time` , `create_date` , `create_staff_id` , `task_num` , `hospital_id` , `department_id` , `task_level_id`) VALUES (27 , '2020年金坛市人民医院跟台' , 2 , 4 , 31 , '2020-01-09' , '00:15:00' , '2020-01-11' , '00:00:00' , '手术跟台' , 0 , 0 , 1578500112 , '2020-01-09 00:15:12' , 31 , '202001097351' , 17261 , 9 , 3) [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.022996s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `create_task_num` = `create_task_num` + 1 WHERE `staff_id` = 31 [ RunTime:0.000492s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `total_task_num` = `total_task_num` + 1 WHERE `staff_id` = 31 [ RunTime:0.000385s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017598s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578500112 , '2020-01-09 00:15:12' , 64 , 31 , '创建了任务' , 2) [ RunTime:0.000503s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000422s ] --------------------------------------------------------------- [2020-01-09T00:15:13+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000683s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.070327s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000762s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001090s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.054280s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [2020-01-09T00:15:13+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000717s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038234s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.054715s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000613s ] --------------------------------------------------------------- [2020-01-09T00:15:13+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000967s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.074343s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002066s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.054734s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.051083s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000771s ] --------------------------------------------------------------- [2020-01-09T00:15:16+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007317s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023972s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018826s ] [ 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` = 64 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000898s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.018611s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 64 AND `remind_date` >= '2020-01-09' [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.017475s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.026348s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000580s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 1 WHERE `id` = 64 [ RunTime:0.000522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017447s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578500116 , '2020-01-09 00:15:16' , 64 , 31 , '查看了任务' , 2) [ RunTime:0.000533s ] [ 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` = 64 AND `t`.`type` = 2 [ RunTime:0.000596s ] --------------------------------------------------------------- [2020-01-09T00:15:16+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000794s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021378s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000839s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.025798s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000725s ] --------------------------------------------------------------- [2020-01-09T00:15:17+08:00] 175.157.50.73 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.002321s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046874s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000742s ] --------------------------------------------------------------- [2020-01-09T00:15:17+08:00] 175.157.50.73 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000945s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051496s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000794s ] --------------------------------------------------------------- [2020-01-09T00:15:17+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001139s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022599s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000779s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000716s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.039160s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000774s ] --------------------------------------------------------------- [2020-01-09T00:15:17+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/startTask [ sql ] [ DB ] CONNECT:[ UseTime:0.001091s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018804s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019839s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 64 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000799s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.019980s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000561s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 2 WHERE `id` = 64 [ RunTime:0.000464s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `ongoing_task_num` = 1 WHERE `id` = 16 [ RunTime:0.000413s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.020846s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578500117 , '2020-01-09 00:15:17' , 64 , 31 , '开始任务' , 2) [ RunTime:0.000589s ] --------------------------------------------------------------- [2020-01-09T00:15:18+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.012447s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044331s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001058s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.035539s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000987s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.032117s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.001076s ] --------------------------------------------------------------- [2020-01-09T00:15:18+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.015504s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028200s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000876s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.035701s ] [ 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` = 64 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001914s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.030209s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 64 AND `remind_date` >= '2020-01-09' [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.029970s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028955s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.018599s ] [ 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` = 64 AND `t`.`type` = 2 [ RunTime:0.000601s ] --------------------------------------------------------------- [2020-01-09T00:15:18+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.018391s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034628s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002214s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023826s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000632s ] --------------------------------------------------------------- [2020-01-09T00:15:18+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.006328s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022556s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024070s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000599s ] --------------------------------------------------------------- [2020-01-09T00:15:27+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.016067s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024028s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.021498s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019400s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000822s ] --------------------------------------------------------------- [2020-01-09T00:15:28+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.002718s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041156s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017476s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000514s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017873s ] [ 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` = 17261 [ RunTime:0.000674s ] [ 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` = 17261 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000632s ] --------------------------------------------------------------- [2020-01-09T00:15:28+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005823s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016070s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015942s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000524s ] --------------------------------------------------------------- [2020-01-09T00:15:29+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.011783s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022683s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018927s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018549s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000760s ] --------------------------------------------------------------- [2020-01-09T00:15:31+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002759s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023506s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019672s ] [ 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` = 64 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000921s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.019679s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 64 AND `remind_date` >= '2020-01-09' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.017324s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.026867s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017568s ] [ 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` = 64 AND `t`.`type` = 2 [ RunTime:0.000581s ] --------------------------------------------------------------- [2020-01-09T00:15:31+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001154s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022751s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000800s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.041712s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000741s ] --------------------------------------------------------------- [2020-01-09T00:15:32+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.015558s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022771s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019971s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000635s ] --------------------------------------------------------------- [2020-01-09T00:15:33+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001999s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016676s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017862s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022258s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000790s ] --------------------------------------------------------------- [2020-01-09T00:15:36+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/contactsSelect [ sql ] [ DB ] CONNECT:[ UseTime:0.013102s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026861s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021919s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 64 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.029407s ] [ sql ] [ SQL ] SELECT `c`.`id`,`c`.`name`,`sex`,`duty`,`phone`,`office_tel`,`email`,d.name as department_name FROM v_contacts c LEFT JOIN `v_department` `d` ON `d`.`id`=`c`.`department_id` WHERE `hospital_id` = 17261 AND `c`.`status` = 0 AND `c`.`is_delete` = 0 [ RunTime:0.000693s ] --------------------------------------------------------------- [2020-01-09T00:15:37+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskContacts [ sql ] [ DB ] CONNECT:[ UseTime:0.000727s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024706s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019141s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 64 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.028749s ] [ sql ] [ SQL ] SELECT `id` FROM `v_contacts` WHERE `id` = 26 AND `hospital_id` = 17261 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000544s ] [ sql ] [ SQL ] UPDATE `v_task` SET `contacts_id` = 26 WHERE `id` = 64 [ RunTime:0.000476s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017725s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578500137 , '2020-01-09 00:15:37' , 64 , 31 , '添加了联系人' , 2) [ RunTime:0.000585s ] --------------------------------------------------------------- [2020-01-09T00:15:37+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000750s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016264s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018939s ] [ 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` = 64 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.028736s ] [ sql ] [ SQL ] SELECT `c`.`name`,`c`.`duty`,`c`.`phone`,`c`.`office_tel`,`c`.`email`,`c`.`remark`,h.name as hospital_name,`h`.`addess` FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 26 LIMIT 0,1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.018337s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 64 AND `remind_date` >= '2020-01-09' [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.018370s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000504s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.031510s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.013980s ] [ 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` = 64 AND `t`.`type` = 2 [ RunTime:0.000579s ] --------------------------------------------------------------- [2020-01-09T00:15:38+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.012512s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023975s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000731s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.036366s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000785s ] --------------------------------------------------------------- [2020-01-09T00:15:38+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.015915s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017114s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019433s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000569s ] --------------------------------------------------------------- [2020-01-09T00:16:12+08:00] 180.110.211.109 POST 101.132.37.87:9001/admin/Login/index [ sql ] [ DB ] CONNECT:[ UseTime:0.009330s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.025145s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ] --------------------------------------------------------------- [2020-01-09T00:16:14+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.006550s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023177s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.005395s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018262s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000495s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019377s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000556s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017881s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000481s ] --------------------------------------------------------------- [2020-01-09T00:16:15+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Department/index.html?spm=m-2-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.006654s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.025533s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000600s ] [ sql ] [ SQL ] SELECT `id`,`letter`,`name`,`create_time` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 ORDER BY `letter` LIMIT 0,15 [ RunTime:0.000595s ] --------------------------------------------------------------- [2020-01-09T00:16:16+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Item/index.html?spm=m-3-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.011327s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023729s ] [ 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_department` `d` ON `d`.`id`=`i`.`department_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`i`.`staff_id` [ RunTime:0.000600s ] [ sql ] [ SQL ] SELECT `i`.*,d.name as department_name,h.name as hospital_name,s.name as staff_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`i`.`staff_id` ORDER BY `i`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.030770s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000540s ] --------------------------------------------------------------- [2020-01-09T00:16:21+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000748s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023828s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 [ RunTime:0.000828s ] [ sql ] [ SQL ] SELECT `t`.*,i.name as item_name,ty.name as type_name,n.name as narure_name,l.name as level_name,s.name as staff_name,c.name as create_name FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 ORDER BY `t`.`status`,`id` DESC LIMIT 0,5 [ RunTime:0.000978s ] --------------------------------------------------------------- [2020-01-09T00:16:22+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Item/taskLevel.html?spm=m-3-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.005009s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_level` [ RunTime:0.023491s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task_level` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000575s ] [ sql ] [ SQL ] SELECT * FROM `v_task_level` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000502s ] --------------------------------------------------------------- [2020-01-09T00:16:23+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.005451s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.025102s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000578s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000490s ] --------------------------------------------------------------- [2020-01-09T00:16:25+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/sector/position.html?spm=m-4-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.007286s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_position` [ RunTime:0.028056s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_position p LEFT JOIN `v_sector` `s` ON `s`.`id`=`p`.`sector_id` WHERE `p`.`is_delete` = 0 AND `p`.`status` = 0 [ RunTime:0.000666s ] [ sql ] [ SQL ] SELECT `p`.*,s.name as sector_name FROM v_position p LEFT JOIN `v_sector` `s` ON `s`.`id`=`p`.`sector_id` WHERE `p`.`is_delete` = 0 AND `p`.`status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.022907s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000589s ] --------------------------------------------------------------- [2020-01-09T00:16:26+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Dough/index.html?spm=m-4-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.005113s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.024569s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_dough_staff d LEFT JOIN `v_staff` `s` ON `s`.`id`=`d`.`staff_id` LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`is_delete` = 0 [ RunTime:0.000618s ] [ sql ] [ SQL ] SELECT `d`.*,t.name as task_name,s.name as staff_name FROM v_dough_staff d LEFT JOIN `v_staff` `s` ON `s`.`id`=`d`.`staff_id` LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`is_delete` = 0 ORDER BY `is_submit` DESC,`d`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000700s ] --------------------------------------------------------------- [2020-01-09T00:16:30+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Dough/doughType.html?spm=m-4-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.001181s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_type` [ RunTime:0.022786s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_dough_type` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `v_dough_type` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000486s ] --------------------------------------------------------------- [2020-01-09T00:16:31+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Dough/index.html?spm=m-4-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.015445s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.025828s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_dough_staff d LEFT JOIN `v_staff` `s` ON `s`.`id`=`d`.`staff_id` LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`is_delete` = 0 [ RunTime:0.000639s ] [ sql ] [ SQL ] SELECT `d`.*,t.name as task_name,s.name as staff_name FROM v_dough_staff d LEFT JOIN `v_staff` `s` ON `s`.`id`=`d`.`staff_id` LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`is_delete` = 0 ORDER BY `is_submit` DESC,`d`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000718s ] --------------------------------------------------------------- [2020-01-09T00:16:32+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Dough/doughType.html?spm=m-4-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.003844s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_type` [ RunTime:0.033015s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_dough_type` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000600s ] [ sql ] [ SQL ] SELECT * FROM `v_dough_type` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000540s ] --------------------------------------------------------------- [2020-01-09T00:16:33+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Statistics/index.html?spm=m-4-6 [ sql ] [ DB ] CONNECT:[ UseTime:0.000735s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.028214s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 [ RunTime:0.000647s ] [ sql ] [ SQL ] SELECT `t`.*,`s`.`job_num`,`s`.`name`,`s`.`phone` FROM v_staff_total t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 0 AND `t`.`is_delete` = 0 ORDER BY `item_mony` DESC,`finish_task_rate` DESC LIMIT 0,10 [ RunTime:0.000705s ] --------------------------------------------------------------- [2020-01-09T00:16:36+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Statistics/statisTaskList.html?spm=m-4-7 [ sql ] [ DB ] CONNECT:[ UseTime:0.011912s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023053s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM v_task t LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 3 GROUP BY `task_level_id` ) `_group_count_` [ RunTime:0.000792s ] [ sql ] [ SQL ] SELECT count(task_level_id) as num,l.name as level,l.colour FROM v_task t LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`status` = 3 GROUP BY `task_level_id` LIMIT 0,10 [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_level` [ RunTime:0.017176s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_task_level` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017454s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_staff` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000515s ] --------------------------------------------------------------- [2020-01-09T00:16:37+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Staff/jobNum.html?spm=m-4-8 [ sql ] [ DB ] CONNECT:[ UseTime:0.005216s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.021235s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff_job_number` [ RunTime:0.000500s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_job_number` LIMIT 0,10 [ RunTime:0.000433s ] --------------------------------------------------------------- [2020-01-09T00:16:39+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Item/nature.html?spm=m-3-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.000753s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.022866s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`is_delete` = 0 AND `n`.`status` = 0 [ RunTime:0.000608s ] [ sql ] [ SQL ] SELECT `n`.*,l.name as level_name,`l`.`colour` FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`is_delete` = 0 AND `n`.`status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000554s ] --------------------------------------------------------------- [2020-01-09T00:16:39+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Item/taskLevel.html?spm=m-3-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.011174s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_level` [ RunTime:0.022730s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task_level` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `v_task_level` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000475s ] --------------------------------------------------------------- [2020-01-09T00:16:40+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Item/index.html?spm=m-3-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.014807s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023368s ] [ 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_department` `d` ON `d`.`id`=`i`.`department_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`i`.`staff_id` [ RunTime:0.000609s ] [ sql ] [ SQL ] SELECT `i`.*,d.name as department_name,h.name as hospital_name,s.name as staff_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`i`.`staff_id` ORDER BY `i`.`status`,`id` DESC LIMIT 0,10 [ RunTime:0.000744s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.017071s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000604s ] --------------------------------------------------------------- [2020-01-09T00:16:41+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.012798s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024534s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 [ RunTime:0.000792s ] [ sql ] [ SQL ] SELECT `t`.*,i.name as item_name,ty.name as type_name,n.name as narure_name,l.name as level_name,s.name as staff_name,c.name as create_name FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 ORDER BY `t`.`status`,`id` DESC LIMIT 0,5 [ RunTime:0.000920s ] --------------------------------------------------------------- [2020-01-09T00:16:42+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Item/nature.html?spm=m-3-4 [ sql ] [ DB ] CONNECT:[ UseTime:0.013025s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.024451s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`is_delete` = 0 AND `n`.`status` = 0 [ RunTime:0.000640s ] [ sql ] [ SQL ] SELECT `n`.*,l.name as level_name,`l`.`colour` FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`is_delete` = 0 AND `n`.`status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000560s ] --------------------------------------------------------------- [2020-01-09T00:16:42+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Item/taskType.html?spm=m-3-5 [ sql ] [ DB ] CONNECT:[ UseTime:0.003369s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.021687s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task_type` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000565s ] [ sql ] [ SQL ] SELECT * FROM `v_task_type` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000475s ] --------------------------------------------------------------- [2020-01-09T00:16:44+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.014943s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.030722s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000564s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000497s ] --------------------------------------------------------------- [2020-01-09T00:16:44+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.001134s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019667s ] [ 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.000743s ] [ 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.000753s ] --------------------------------------------------------------- [2020-01-09T00:16:51+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/sector/position.html?spm=m-4-3 [ sql ] [ DB ] CONNECT:[ UseTime:0.000728s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_position` [ RunTime:0.029491s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_position p LEFT JOIN `v_sector` `s` ON `s`.`id`=`p`.`sector_id` WHERE `p`.`is_delete` = 0 AND `p`.`status` = 0 [ RunTime:0.000661s ] [ sql ] [ SQL ] SELECT `p`.*,s.name as sector_name FROM v_position p LEFT JOIN `v_sector` `s` ON `s`.`id`=`p`.`sector_id` WHERE `p`.`is_delete` = 0 AND `p`.`status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.019333s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000624s ] --------------------------------------------------------------- [2020-01-09T00:16:53+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.006778s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.024548s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 [ RunTime:0.000616s ] [ sql ] [ SQL ] SELECT * FROM `v_sector` WHERE `is_delete` = 0 AND `status` = 0 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000495s ] --------------------------------------------------------------- [2020-01-09T00:16:56+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000886s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.025011s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 [ RunTime:0.000853s ] [ sql ] [ SQL ] SELECT `t`.*,i.name as item_name,ty.name as type_name,n.name as narure_name,l.name as level_name,s.name as staff_name,c.name as create_name FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 ORDER BY `t`.`status`,`id` DESC LIMIT 0,5 [ RunTime:0.000957s ] --------------------------------------------------------------- [2020-01-09T00:17:01+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2&page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.015718s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024366s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 [ RunTime:0.000806s ] [ sql ] [ SQL ] SELECT `t`.*,i.name as item_name,ty.name as type_name,n.name as narure_name,l.name as level_name,s.name as staff_name,c.name as create_name FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 ORDER BY `t`.`status`,`id` DESC LIMIT 5,5 [ RunTime:0.000984s ] --------------------------------------------------------------- [2020-01-09T00:17:05+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.008369s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.025020s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 [ RunTime:0.000856s ] [ sql ] [ SQL ] SELECT `t`.*,i.name as item_name,ty.name as type_name,n.name as narure_name,l.name as level_name,s.name as staff_name,c.name as create_name FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 ORDER BY `t`.`status`,`id` DESC LIMIT 0,5 [ RunTime:0.000961s ] --------------------------------------------------------------- [2020-01-09T00:17:08+08:00] 180.110.211.109 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2&page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.012179s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024815s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 [ RunTime:0.000823s ] [ sql ] [ SQL ] SELECT `t`.*,i.name as item_name,ty.name as type_name,n.name as narure_name,l.name as level_name,s.name as staff_name,c.name as create_name FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_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` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_staff` `c` ON `c`.`id`=`t`.`create_staff_id` LEFT JOIN `v_contacts` `con` ON `con`.`id`=`t`.`contacts_id` WHERE `t`.`is_delete` = 0 ORDER BY `t`.`status`,`id` DESC LIMIT 10,5 [ RunTime:0.001036s ] --------------------------------------------------------------- [2020-01-09T00:17:20+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskAddess [ sql ] [ DB ] CONNECT:[ UseTime:0.000851s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025312s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018593s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 64 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000799s ] [ sql ] [ SQL ] UPDATE `v_task` SET `addess` = '江苏省金坛市南门大街16号' WHERE `id` = 64 [ RunTime:0.000498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.016659s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578500240 , '2020-01-09 00:17:20' , 64 , 31 , '添加了地址' , 2) [ RunTime:0.000500s ] --------------------------------------------------------------- [2020-01-09T00:17:21+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008270s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022906s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019407s ] [ 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` = 64 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000923s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.030587s ] [ sql ] [ SQL ] SELECT `c`.`name`,`c`.`duty`,`c`.`phone`,`c`.`office_tel`,`c`.`email`,`c`.`remark`,h.name as hospital_name,`h`.`addess` FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 26 LIMIT 0,1 [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.019067s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 64 AND `remind_date` >= '2020-01-09' [ RunTime:0.000516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.017489s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.027023s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000551s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.016433s ] [ 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` = 64 AND `t`.`type` = 2 [ RunTime:0.000716s ] --------------------------------------------------------------- [2020-01-09T00:17:21+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010596s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023006s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000710s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.038553s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [2020-01-09T00:17:21+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.009367s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.015889s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.015990s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000531s ] --------------------------------------------------------------- [2020-01-09T00:17:59+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000756s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023760s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019661s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019955s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000842s ] --------------------------------------------------------------- [2020-01-09T00:21:29+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.000772s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028792s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0118' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019471s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000567s ] --------------------------------------------------------------- [2020-01-09T00:21:29+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.004858s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023772s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000823s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021795s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000747s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031227s ] [ 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` = 17261 [ RunTime:0.000904s ] [ 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` = 17261 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.001009s ] --------------------------------------------------------------- [2020-01-09T00:21:29+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.003102s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033202s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001103s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033239s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000584s ] --------------------------------------------------------------- [2020-01-09T00:21:34+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010672s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023081s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019172s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019987s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000831s ] --------------------------------------------------------------- [2020-01-09T00:21:40+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.004794s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025724s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001078s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.031281s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.001345s ] --------------------------------------------------------------- [2020-01-09T00:21:40+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008494s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028124s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000771s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000767s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.036203s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000626s ] --------------------------------------------------------------- [2020-01-09T00:21:45+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.007585s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036308s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001086s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030724s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.031089s ] [ 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` = '17261' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000731s ] [ 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` = '17261' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000546s ] --------------------------------------------------------------- [2020-01-09T00:21:45+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000713s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029636s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000858s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031547s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.027159s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 17261 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001415s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.030410s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 209 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000532s ] --------------------------------------------------------------- [2020-01-09T00:21:49+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.012240s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024491s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019143s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000780s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019852s ] [ 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 `item_id` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000834s ] --------------------------------------------------------------- [2020-01-09T00:21:53+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.012737s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041953s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018251s ] [ 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` = 64 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_contacts` [ RunTime:0.029311s ] [ sql ] [ SQL ] SELECT `c`.`name`,`c`.`duty`,`c`.`phone`,`c`.`office_tel`,`c`.`email`,`c`.`remark`,h.name as hospital_name,`h`.`addess` FROM v_contacts c LEFT JOIN `v_hospital` `h` ON `h`.`id`=`c`.`hospital_id` WHERE `c`.`id` = 26 LIMIT 0,1 [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.018352s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 64 AND `remind_date` >= '2020-01-09' [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.019127s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.026608s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 64 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.016796s ] [ 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` = 64 AND `t`.`type` = 2 [ RunTime:0.000580s ] --------------------------------------------------------------- [2020-01-09T00:21:53+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.009301s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024481s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000749s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000975s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025722s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000765s ] --------------------------------------------------------------- [2020-01-09T00:21:53+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.015481s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030305s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018309s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000574s ] --------------------------------------------------------------- [2020-01-09T15:35:35+08:00] 17.222.114.48 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.000936s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025035s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0118' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018132s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000546s ] --------------------------------------------------------------- [2020-01-09T15:35:36+08:00] 17.222.114.48 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000758s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022643s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018018s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018414s ] [ 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` = 17261 [ RunTime:0.000885s ] [ 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` = 17261 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000633s ] --------------------------------------------------------------- [2020-01-09T15:35:36+08:00] 17.222.114.48 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000778s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016430s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015180s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000531s ] --------------------------------------------------------------- [2020-01-09T15:36:29+08:00] 17.222.114.48 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000969s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038496s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001060s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024132s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000763s ] --------------------------------------------------------------- [2020-01-09T15:36:29+08:00] 17.222.114.48 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001696s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043715s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027118s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000830s ] --------------------------------------------------------------- [2020-01-09T15:36:34+08:00] 17.222.114.48 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000765s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022841s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019296s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019974s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 17261 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.017039s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 209 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000582s ] --------------------------------------------------------------- [2020-01-09T15:36:35+08:00] 17.222.114.48 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000761s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030481s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018105s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018902s ] [ 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` = '17261' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000693s ] [ 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` = '17261' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000497s ]