---------------------------------------------------------------

[2024-01-05T05:22:40+08:00] 113.141.230.48 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.004652s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029559s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '55|ba613c44175489fa078d5fc7bdb19f60'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002123s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.026068s ]
[ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE  `staff_id` = 55  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000551s ]
---------------------------------------------------------------

[2024-01-05T05:22:40+08:00] 113.141.230.48 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.004620s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030883s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '55|ba613c44175489fa078d5fc7bdb19f60'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000830s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029342s ]
[ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE  `staff_id` = 55  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000522s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.014857s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item  i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE  `i`.`is_delete` = 0  AND `i`.`status` IN (0,1)  AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10)  AND `i`.`staff_id` = 55 [ RunTime:0.001376s ]