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

[2024-09-10T14:27:50+08:00] 36.45.227.121 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.001081s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023109s ]
[ 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.000703s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017825s ]
[ 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.000552s ]
---------------------------------------------------------------

[2024-09-10T14:27:50+08:00] 36.45.227.121 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000666s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.015859s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE  `token` = '55|ba613c44175489fa078d5fc7bdb19f60'  AND `status` = 0  AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000597s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017336s ]
[ 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.000468s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.012310s ]
[ 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.002671s ]