--------------------------------------------------------------- [2023-10-15T19:42:32+08:00] 42.48.201.64 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.002161s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.066235s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '13974003356' LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.055908s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('13974003356' , 0 , 142679 , 1697370152 , '2023-10-15 19:42:32') [ RunTime:0.006094s ] --------------------------------------------------------------- [2023-10-15T19:42:48+08:00] 42.48.201.64 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.002549s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.051632s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '13974003356' AND `phone_code` = '142679' LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.046426s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0134' , 1 , 0 , 0 , 1697370168 , '2023-10-15 19:42:48') [ RunTime:0.004227s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.058347s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('13974003356' , 'b204e23593201c18b097842955600ae0' , '0134' , 0 , 0 , 1697370168 , '2023-10-15 19:42:48' , 1697370168 , 51) [ RunTime:0.003578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.043411s ] [ sql ] [ SQL ] INSERT INTO `v_staff_action` (`status` , `is_delete` , `create_time` , `create_date` , `is_create_item` , `is_create_task` , `staff_id`) VALUES (0 , 0 , 1697370168 , '2023-10-15 19:42:48' , 1 , 1 , 61) [ RunTime:0.006073s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.052430s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1697370168 , '2023-10-15 19:42:48' , 61) [ RunTime:0.002849s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '61|cabcbafac6c842f1f456ef0fdd7ab07b' WHERE `id` = 61 [ RunTime:0.007317s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 33 [ RunTime:0.003532s ] --------------------------------------------------------------- [2023-10-15T19:43:15+08:00] 42.48.201.64 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001199s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045422s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '61|cabcbafac6c842f1f456ef0fdd7ab07b' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '万二龙' , `sex` = 1 WHERE `id` = 61 [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039102s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 61 [ RunTime:0.001016s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.039765s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 61,1,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,2,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,3,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,4,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,5,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,6,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,7,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,8,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,9,0,1697370194,'2023-10-15 19:43:14' ) , ( 61,10,0,1697370194,'2023-10-15 19:43:14' ) [ RunTime:0.001215s ] --------------------------------------------------------------- [2023-10-15T19:43:15+08:00] 42.48.201.64 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002372s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.072969s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '61|cabcbafac6c842f1f456ef0fdd7ab07b' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.079504s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 61 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001275s ] --------------------------------------------------------------- [2023-10-15T19:43:15+08:00] 42.48.201.64 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.006243s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.073493s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '61|cabcbafac6c842f1f456ef0fdd7ab07b' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.070634s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 61 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001197s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.055967s ] [ 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` = 61 [ RunTime:0.001917s ]