--------------------------------------------------------------- [2020-01-02T13:41:03+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006574s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037233s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|c342ca2335576c189a3f60d8e7557fea' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000785s ] --------------------------------------------------------------- [2020-01-02T13:41:06+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.001103s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034359s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|c342ca2335576c189a3f60d8e7557fea' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000760s ] --------------------------------------------------------------- [2020-01-02T13:41:16+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Login/staffLogin [ 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.023091s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0010' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' , `last_time` = 1577943676 WHERE `id` = 23 [ RunTime:0.005024s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018293s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000537s ] --------------------------------------------------------------- [2020-01-02T13:41:16+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.001073s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023998s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021273s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000934s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031833s ] [ 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` = 0 [ RunTime:0.001469s ] --------------------------------------------------------------- [2020-01-02T13:41:16+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008170s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022287s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000852s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033178s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000560s ] --------------------------------------------------------------- [2020-01-02T13:41:18+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008186s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037196s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000740s ] [ 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` = 23 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.038023s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 23 LIMIT 1 [ RunTime:0.000772s ] --------------------------------------------------------------- [2020-01-02T13:41:19+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000937s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024865s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021248s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 23 AND `status` = 0 [ RunTime:0.000583s ] --------------------------------------------------------------- [2020-01-02T13:58:17+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.009002s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024704s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020193s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 23 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000837s ] --------------------------------------------------------------- [2020-01-02T13:58:25+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000728s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023749s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018216s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017264s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000516s ] --------------------------------------------------------------- [2020-01-02T13:58:31+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.005934s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025389s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019087s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020245s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000545s ] --------------------------------------------------------------- [2020-01-02T14:00:21+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.001352s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023973s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000848s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038348s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.028987s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000788s ] --------------------------------------------------------------- [2020-01-02T14:00:21+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000943s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048547s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.037115s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030789s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000514s ] --------------------------------------------------------------- [2020-01-02T14:03:13+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000697s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043882s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000896s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030598s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [2020-01-02T14:03:13+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000855s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037396s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000748s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031247s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.025173s ] [ 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` = 0 [ RunTime:0.000852s ] --------------------------------------------------------------- [2020-01-02T14:03:14+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013345s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028740s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000903s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.032182s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [2020-01-02T14:03:14+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.001417s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025268s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031255s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031155s ] [ 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` = 0 [ RunTime:0.000728s ] --------------------------------------------------------------- [2020-01-02T14:03:20+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.004402s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023524s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017670s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000560s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017516s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000572s ] --------------------------------------------------------------- [2020-01-02T14:03:21+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000743s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023322s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018732s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017923s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000573s ] --------------------------------------------------------------- [2020-01-02T14:03:25+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.006585s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034452s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000791s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031349s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.025541s ] [ 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` = 0 [ RunTime:0.000918s ] --------------------------------------------------------------- [2020-01-02T14:03:25+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000970s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016470s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015718s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000580s ] --------------------------------------------------------------- [2020-01-02T14:03:26+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000926s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035048s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000793s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023591s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001007s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.032296s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000635s ] --------------------------------------------------------------- [2020-01-02T14:03:26+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000780s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031008s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.035300s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.015506s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000536s ] --------------------------------------------------------------- [2020-01-02T14:07:33+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000816s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040956s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000923s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031162s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000699s ] --------------------------------------------------------------- [2020-01-02T14:07:33+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.001222s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040484s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.032100s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.026584s ] [ 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` = 0 [ RunTime:0.000676s ] --------------------------------------------------------------- [2020-01-02T14:07:35+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002157s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035291s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028974s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.049999s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001819s ] --------------------------------------------------------------- [2020-01-02T14:07:35+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000597s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042348s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000939s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.034016s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.045372s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000596s ] --------------------------------------------------------------- [2020-01-02T14:08:34+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.002417s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026523s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022058s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017825s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000566s ] --------------------------------------------------------------- [2020-01-02T14:08:37+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000859s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029874s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033926s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [2020-01-02T14:08:37+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000529s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039637s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.037469s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000504s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023023s ] [ 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` = 0 [ RunTime:0.000660s ] --------------------------------------------------------------- [2020-01-02T14:08:38+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ 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.023359s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000893s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028550s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.049328s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000616s ] --------------------------------------------------------------- [2020-01-02T14:08:38+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.013696s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028718s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000893s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.049253s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023875s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000536s ] --------------------------------------------------------------- [2020-01-02T14:08:41+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000959s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033515s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000824s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.046704s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 23 AND `status` = 0 [ RunTime:0.000746s ] --------------------------------------------------------------- [2020-01-02T14:08:41+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000959s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047532s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000746s ] [ 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` = 23 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000928s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.050756s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 23 LIMIT 1 [ RunTime:0.000643s ] --------------------------------------------------------------- [2020-01-02T14:08:42+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.001071s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027215s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023355s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 23 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000798s ] --------------------------------------------------------------- [2020-01-02T14:09:06+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.007231s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029962s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0010' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020763s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000598s ] --------------------------------------------------------------- [2020-01-02T14:09:06+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.012955s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017543s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ] [ 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` = 23 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026808s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 23 LIMIT 1 [ RunTime:0.000630s ] --------------------------------------------------------------- [2020-01-02T14:09:06+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.033880s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029221s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.054853s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [2020-01-02T14:09:06+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ 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.056509s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.042968s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001549s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031533s ] [ 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` = 0 [ RunTime:0.001449s ] --------------------------------------------------------------- [2020-01-02T14:09:07+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008019s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039931s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000840s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030656s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000571s ] --------------------------------------------------------------- [2020-01-02T14:09:08+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.013511s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023894s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018553s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023816s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000741s ] --------------------------------------------------------------- [2020-01-02T14:09:08+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.035030s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000799s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031190s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 23 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000705s ] --------------------------------------------------------------- [2020-01-02T14:09:10+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.001197s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029208s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '23|aa73a547eaa33f656b3f4c1d9b77b363' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023588s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 23 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000978s ] --------------------------------------------------------------- [2020-01-02T14:09:21+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.000962s ] 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` = '0000' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' , `last_time` = 1577945361 WHERE `id` = 20 [ RunTime:0.003555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019179s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000543s ] --------------------------------------------------------------- [2020-01-02T14:09:22+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000724s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025186s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000611s ] [ 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` = 20 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.023866s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 20 LIMIT 1 [ RunTime:0.000638s ] --------------------------------------------------------------- [2020-01-02T14:09:22+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000903s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025065s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031050s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001003s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.051020s ] [ 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` = 0 [ RunTime:0.001198s ] --------------------------------------------------------------- [2020-01-02T14:09:22+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.052779s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.051423s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000729s ] --------------------------------------------------------------- [2020-01-02T14:09:22+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000805s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017683s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015857s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000522s ] --------------------------------------------------------------- [2020-01-02T14:09:23+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.025147s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020025s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000622s ] --------------------------------------------------------------- [2020-01-02T14:09:24+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000880s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023303s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018012s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.022554s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000521s ] --------------------------------------------------------------- [2020-01-02T14:09:28+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.007800s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022762s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019205s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000949s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018588s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000624s ] --------------------------------------------------------------- [2020-01-02T14:09:30+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000755s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023669s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018703s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018648s ] [ 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` = '' AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000569s ] --------------------------------------------------------------- [2020-01-02T14:09:31+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006884s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024811s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029515s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] --------------------------------------------------------------- [2020-01-02T14:09:32+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000790s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024833s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028518s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000749s ] --------------------------------------------------------------- [2020-01-02T14:09:32+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001638s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027077s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015643s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018720s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000547s ] --------------------------------------------------------------- [2020-01-02T14:09:36+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000901s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035030s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.034744s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 20 AND `status` = 0 [ RunTime:0.000649s ] --------------------------------------------------------------- [2020-01-02T14:09:36+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000901s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.049270s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '20|a03534ccef8b1b7c9e5140bf92683ba9' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.036419s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 20 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000543s ] --------------------------------------------------------------- [2020-01-02T14:10:20+08:00] 180.110.209.128 POST 101.132.37.87:9001/admin/Login/index [ sql ] [ DB ] CONNECT:[ UseTime:0.000741s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_admin` [ RunTime:0.023068s ] [ sql ] [ SQL ] SELECT * FROM `v_admin` WHERE `is_delete` = 0 AND `login_name` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [2020-01-02T14:10:22+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Index/info.html?spm=m-1-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000809s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023662s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_hospital` WHERE `status` = 0 [ RunTime:0.005479s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019934s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_item` WHERE `is_delete` = 0 [ RunTime:0.000941s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020799s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `is_delete` = 0 [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018885s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_staff` WHERE `is_delete` = 0 [ RunTime:0.000652s ] --------------------------------------------------------------- [2020-01-02T14:10:25+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/sector/index.html?spm=m-4-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000749s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_sector` [ RunTime:0.024220s ] [ 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.000491s ] --------------------------------------------------------------- [2020-01-02T14:10:26+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000737s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042965s ] [ 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.000726s ] [ 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.000784s ] --------------------------------------------------------------- [2020-01-02T14:10:31+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Task/index.html?spm=m-3-2 [ sql ] [ DB ] CONNECT:[ UseTime:0.000768s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.029425s ] [ 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.000873s ] [ 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.000793s ] --------------------------------------------------------------- [2020-01-02T14:10:33+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1 [ 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.022762s ] [ 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.000711s ] [ 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.000738s ] --------------------------------------------------------------- [2020-01-02T14:10:35+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=2 [ 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.024305s ] [ 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.000718s ] [ sql ] [ SQL ] SELECT `s`.*,se.name as sector_name,p.name as position_name,`a`.`is_create_item`,`a`.`is_create_task` FROM v_staff s LEFT JOIN `v_staff_action` `a` ON `a`.`staff_id`=`s`.`id` LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`status` = 0 AND `s`.`is_delete` = 0 ORDER BY `s`.`id` DESC LIMIT 10,10 [ RunTime:0.000744s ] --------------------------------------------------------------- [2020-01-02T14:10:37+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000775s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029443s ] [ 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.000719s ] [ 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-02T14:10:39+08:00] 180.110.209.128 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ 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_action` [ RunTime:0.024437s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 20 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019292s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.035576s ] --------------------------------------------------------------- [2020-01-02T14:10:47+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000776s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037702s ] [ 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.000757s ] [ 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.000745s ] --------------------------------------------------------------- [2020-01-02T14:10:57+08:00] 180.110.209.128 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.009619s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023659s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 27 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018135s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.035101s ] --------------------------------------------------------------- [2020-01-02T14:11:04+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=1 [ 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.024467s ] [ 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.000749s ] [ 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.000737s ] --------------------------------------------------------------- [2020-01-02T14:11:09+08:00] 180.110.209.128 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000751s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022811s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 28 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.032818s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.034399s ] --------------------------------------------------------------- [2020-01-02T14:11:15+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005137s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024022s ] [ 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.000734s ] [ 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.000737s ] --------------------------------------------------------------- [2020-01-02T14:11:18+08:00] 180.110.209.128 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ 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_action` [ RunTime:0.025385s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 28 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020026s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.034547s ] --------------------------------------------------------------- [2020-01-02T14:11:24+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005890s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024506s ] [ 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.000721s ] [ 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.000751s ] --------------------------------------------------------------- [2020-01-02T14:11:28+08:00] 180.110.209.128 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000774s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023313s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 29 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017615s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.034462s ] --------------------------------------------------------------- [2020-01-02T14:11:34+08:00] 180.110.209.128 GET 101.132.37.87:9001/admin/Staff/index.html?spm=m-4-1&page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000723s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023558s ] [ 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.000713s ] [ 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.000749s ] --------------------------------------------------------------- [2020-01-02T14:11:37+08:00] 180.110.209.128 POST 101.132.37.87:9001/admin/staff/apply.html?spm=m-4-1 [ sql ] [ DB ] CONNECT:[ UseTime:0.000736s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.034347s ] [ sql ] [ SQL ] SELECT `hospital_ids` FROM `v_staff_action` WHERE `staff_id` = 27 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017509s ] [ sql ] [ SQL ] SELECT id as node,name as title,`province_id`,`province`,`city_id`,`city` FROM `v_hospital` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.035414s ] --------------------------------------------------------------- [2020-01-02T14:11:45+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.000925s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037637s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0013' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' , `last_time` = 1577945505 WHERE `id` = 27 [ RunTime:0.002940s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019848s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000566s ] --------------------------------------------------------------- [2020-01-02T14:11:45+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000913s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022768s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000947s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022377s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031112s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (19124,19125,19127,19132,19134,19136,19141,19143) [ RunTime:0.001045s ] --------------------------------------------------------------- [2020-01-02T14:11:46+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002464s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039836s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001335s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033790s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000583s ] --------------------------------------------------------------- [2020-01-02T14:11:48+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000940s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047526s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.034426s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000876s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030146s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('19124','19125','19127','19132','19134','19136','19141','19143') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.001598s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('19124','19125','19127','19132','19134','19136','19141','19143') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000766s ] --------------------------------------------------------------- [2020-01-02T14:11:48+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000556s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030764s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000872s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.034334s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.028946s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (19124,19125,19127,19132,19134,19136,19141,19143) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.001027s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.029731s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 320 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000648s ] --------------------------------------------------------------- [2020-01-02T14:12:41+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000950s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037410s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000689s ] [ 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` = 27 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000834s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.036901s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 27 LIMIT 1 [ RunTime:0.000738s ] --------------------------------------------------------------- [2020-01-02T14:12:41+08:00] 180.110.209.128 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000527s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042540s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.045217s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 27 AND `status` = 0 [ RunTime:0.000584s ]