--------------------------------------------------------------- [2023-10-30T08:11:31+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.007356s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040206s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '18256988808' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.029820s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('18256988808' , 0 , 217545 , 1698624691 , '2023-10-30 08:11:31') [ RunTime:0.005405s ] --------------------------------------------------------------- [2023-10-30T08:11:43+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000816s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.040992s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '18256988808' AND `phone_code` = '217545' LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.029884s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0136' , 1 , 0 , 0 , 1698624703 , '2023-10-30 08:11:43') [ RunTime:0.003699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029457s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('18256988808' , '6fabdb7c202987bb5b59c2eba72e59ff' , '0136' , 0 , 0 , 1698624703 , '2023-10-30 08:11:43' , 1698624703 , 53) [ RunTime:0.003913s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031950s ] [ 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 , 1698624703 , '2023-10-30 08:11:43' , 1 , 1 , 63) [ RunTime:0.004483s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.037876s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1698624703 , '2023-10-30 08:11:43' , 63) [ RunTime:0.004015s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' WHERE `id` = 63 [ RunTime:0.003455s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 36 [ RunTime:0.003562s ] --------------------------------------------------------------- [2023-10-30T08:12:05+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.014995s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038806s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000751s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = 'MrJiiao' , `sex` = 1 WHERE `id` = 63 [ RunTime:0.000503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030734s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 63 [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.030003s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 63,1,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,2,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,3,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,4,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,5,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,6,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,7,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,8,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,9,0,1698624725,'2023-10-30 08:12:05' ) , ( 63,10,0,1698624725,'2023-10-30 08:12:05' ) [ RunTime:0.001241s ] --------------------------------------------------------------- [2023-10-30T08:12:05+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001061s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036164s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.035286s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 63 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000564s ] --------------------------------------------------------------- [2023-10-30T08:12:06+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.031445s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048097s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028378s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 63 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.039178s ] [ 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` = 63 [ RunTime:0.001172s ] --------------------------------------------------------------- [2023-10-30T08:12:09+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001176s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050988s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.040307s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 63 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003489s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.053692s ] [ 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.000717s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.062044s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000580s ] --------------------------------------------------------------- [2023-10-30T08:12:09+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.016177s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.058374s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003716s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.052693s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 63 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.038769s ] [ 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.000879s ] [ 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.000756s ] --------------------------------------------------------------- [2023-10-30T08:12:13+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.011901s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042244s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000780s ] [ 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` = 63 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.053278s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 63 LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [2023-10-30T08:12:13+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000893s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.082299s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.074646s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 63 AND `status` = 0 [ RunTime:0.000610s ] --------------------------------------------------------------- [2023-10-30T08:12:27+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.009437s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045815s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.035542s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`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 `t`.`staff_id` = 63 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000960s ] --------------------------------------------------------------- [2023-10-30T08:12:30+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.000780s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043655s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000793s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.046477s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 63 AND `d`.`is_delete` = 0 [ RunTime:0.000752s ] --------------------------------------------------------------- [2023-10-30T08:12:32+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.005153s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041460s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000760s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.032391s ] [ 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 `staff_id` = 63 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000809s ] --------------------------------------------------------------- [2023-10-30T08:12:34+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.002247s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041821s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.033195s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`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 `t`.`create_staff_id` = 63 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000866s ] --------------------------------------------------------------- [2023-10-30T08:12:36+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000764s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040963s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000751s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.031415s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`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 `t`.`create_staff_id` = 63 AND `t`.`staff_id` > 0 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000881s ] --------------------------------------------------------------- [2023-10-30T08:13:23+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Hospital/hospitalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000833s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043229s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000776s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.035841s ] [ 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` = 1 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031378s ] [ 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 `hospital_id` = 1 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC [ RunTime:0.000849s ] --------------------------------------------------------------- [2023-10-30T08:13:30+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Hospital/hospitalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003129s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042025s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.035283s ] [ 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` = 1 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000689s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.035716s ] [ 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 `hospital_id` = 1 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC [ RunTime:0.000779s ] --------------------------------------------------------------- [2023-10-30T08:13:42+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.015119s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041246s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.034013s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 63 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.031618s ] [ 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.000747s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.032004s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000580s ] --------------------------------------------------------------- [2023-10-30T08:13:44+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Item/cityInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.011782s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041935s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030771s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 63 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.032861s ] [ 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.000796s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.032247s ] [ 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.000600s ] --------------------------------------------------------------- [2023-10-30T08:13:45+08:00] 101.80.88.42 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.001324s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040737s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '63|866a7a83c7c9b5e0076538f9b898e0dd' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033822s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 63 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.029589s ] [ 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.000814s ] [ 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.000798s ] --------------------------------------------------------------- [2023-10-30T22:59:52+08:00] 39.106.39.30 CONNECT yuanzijiasu.com:443yuanzijiasu.com:443 [ error ] [8]未定义数组索引: connect --------------------------------------------------------------- [2023-10-30T22:59:53+08:00] 39.106.39.30 CONNECT yuanzijiasu.com:443yuanzijiasu.com:443 [ error ] [8]未定义数组索引: connect