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

[2023-05-24T13:45:57+08:00] 113.143.220.223 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.001840s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059169s ]
[ 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.000826s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.071206s ]
[ 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.000937s ]
---------------------------------------------------------------

[2023-05-24T13:45:57+08:00] 113.143.220.223 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.001094s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.077504s ]
[ 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.000683s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.075562s ]
[ 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.000619s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.034515s ]
[ 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.001254s ]