--------------------------------------------------------------- [2023-01-20T19:11:43+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.001031s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042193s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '18045361536' LIMIT 1 [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.033698s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('18045361536' , 0 , 190385 , 1674213103 , '2023-01-20 19:11:43') [ RunTime:0.005734s ] --------------------------------------------------------------- [2023-01-20T19:12:04+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000806s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.035166s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '18045361536' AND `phone_code` = '190385' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.039435s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0132' , 1 , 0 , 0 , 1674213124 , '2023-01-20 19:12:04') [ RunTime:0.003655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042417s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('18045361536' , '58576991319065420ea82543541f6d59' , '0132' , 0 , 0 , 1674213124 , '2023-01-20 19:12:04' , 1674213124 , 49) [ RunTime:0.003932s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.032679s ] [ 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 , 1674213124 , '2023-01-20 19:12:04' , 1 , 1 , 59) [ RunTime:0.002834s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.050495s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1674213124 , '2023-01-20 19:12:04' , 59) [ RunTime:0.004506s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '59|1316be3dc82ef50737ddee2d996f94de' WHERE `id` = 59 [ RunTime:0.002807s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 31 [ RunTime:0.003262s ] --------------------------------------------------------------- [2023-01-20T19:12:15+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/My/completeInfo [ 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.033428s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '嗯' , `sex` = 1 WHERE `id` = 59 [ RunTime:0.000572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.025926s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 59 [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.025138s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 59,1,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,2,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,3,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,4,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,5,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,6,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,7,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,8,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,9,0,1674213135,'2023-01-20 19:12:15' ) , ( 59,10,0,1674213135,'2023-01-20 19:12:15' ) [ RunTime:0.001097s ] --------------------------------------------------------------- [2023-01-20T19:12:16+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000846s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037546s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000800s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.082874s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000600s ] --------------------------------------------------------------- [2023-01-20T19:12:16+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000752s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.153348s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.081748s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.035901s ] [ 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` = 59 [ RunTime:0.001879s ] --------------------------------------------------------------- [2023-01-20T19:12:18+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.001003s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.085250s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001107s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.070858s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.041897s ] [ 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 ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000836s ] [ 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 ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000891s ] --------------------------------------------------------------- [2023-01-20T19:12:18+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.038597s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.062412s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000760s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.072382s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.091190s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000744s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.063546s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000599s ] --------------------------------------------------------------- [2023-01-20T19:12:32+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000876s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040006s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.044456s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.037771s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.041969s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000626s ] --------------------------------------------------------------- [2023-01-20T19:12:33+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/cityInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000858s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046013s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029057s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000733s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.027801s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000746s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.025870s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 5 AND `parent_id` = 3 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000581s ] --------------------------------------------------------------- [2023-01-20T19:12:34+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.015294s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043022s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039909s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.060628s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `city_id` = 5 AND `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000853s ] [ 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 `city_id` = 5 AND `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,100 [ RunTime:0.000714s ] --------------------------------------------------------------- [2023-01-20T19:12:37+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/departmentList [ sql ] [ DB ] CONNECT:[ UseTime:0.005117s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034397s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.031120s ] [ sql ] [ SQL ] SELECT `id`,`name`,`letter` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000665s ] --------------------------------------------------------------- [2023-01-20T19:12:49+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/itemAdd [ sql ] [ DB ] CONNECT:[ UseTime:0.001053s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042524s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028660s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.025320s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff_hospital` WHERE `staff_id` = 59 AND `hospital_id` = 2 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.098253s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.029366s ] [ sql ] [ SQL ] INSERT INTO `v_item` (`name` , `hospital_id` , `department_id` , `item_introduce` , `item_content` , `remark` , `staff_id` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('哦6' , 2 , 3 , '1' , '1' , NULL , 59 , 0 , 0 , 1674213169 , '2023-01-20 19:12:49') [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.037210s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `create_item_num` = `create_item_num` + 1 WHERE `staff_id` = 59 [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.031391s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1674213169 , '2023-01-20 19:12:49' , 43 , 59 , '创建了项目' , 1) [ RunTime:0.000544s ] --------------------------------------------------------------- [2023-01-20T19:12:49+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.001631s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027360s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.035611s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.034318s ] [ 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` = 59 [ RunTime:0.000947s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` 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` = 59 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000849s ] --------------------------------------------------------------- [2023-01-20T19:12:52+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.004175s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036988s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000741s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.028793s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 43 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000810s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.031026s ] [ 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 `item_id` = 43 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000979s ] --------------------------------------------------------------- [2023-01-20T19:12:56+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/itemDisable [ sql ] [ DB ] CONNECT:[ UseTime:0.001589s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042829s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.046613s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 43 AND `staff_id` = 59 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.058644s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `item_id` = 43 AND `status` IN (0,1,2) LIMIT 1 [ RunTime:0.001137s ] [ sql ] [ SQL ] UPDATE `v_item` SET `status` = 3 , `is_delete` = 1 WHERE `id` = 43 [ RunTime:0.000457s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.047011s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `create_item_num` = `create_item_num` - 1 WHERE `staff_id` = 59 [ RunTime:0.000554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.045485s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1674213176 , '2023-01-20 19:12:56' , 43 , 59 , '作废了项目' , 1) [ RunTime:0.000556s ] --------------------------------------------------------------- [2023-01-20T19:12:56+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.006523s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032896s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.045137s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 59 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.043179s ] [ 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` = 59 [ RunTime:0.000945s ] --------------------------------------------------------------- [2023-01-20T19:12:59+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.058526s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059330s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000696s ] [ 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` = 59 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.092617s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 59 LIMIT 1 [ RunTime:0.000639s ] --------------------------------------------------------------- [2023-01-20T19:12:59+08:00] 1.189.110.52 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.001042s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.086014s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '59|1316be3dc82ef50737ddee2d996f94de' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000752s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.100912s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 59 AND `status` = 0 [ RunTime:0.000599s ]