--------------------------------------------------------------- [2024-01-08T07:40:35+08:00] 185.224.128.17 CONNECT example.com:80example.com:80 [ error ] [8]未定义数组索引: connect --------------------------------------------------------------- [2024-01-08T14:55:34+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.001014s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018205s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '13203601125' LIMIT 1 [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.020792s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('13203601125' , 0 , 961413 , 1704696934 , '2024-01-08 14:55:34') [ RunTime:0.005332s ] --------------------------------------------------------------- [2024-01-08T14:55:41+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.009746s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.014484s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '13203601125' AND `phone_code` = '961413' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.017217s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0138' , 1 , 0 , 0 , 1704696941 , '2024-01-08 14:55:41') [ RunTime:0.002682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016759s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('13203601125' , 'c19cb2c923e312b4bbe0cc510fba406b' , '0138' , 0 , 0 , 1704696941 , '2024-01-08 14:55:41' , 1704696941 , 55) [ RunTime:0.003857s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015139s ] [ 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 , 1704696941 , '2024-01-08 14:55:41' , 1 , 1 , 65) [ RunTime:0.003922s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.017291s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1704696941 , '2024-01-08 14:55:41' , 65) [ RunTime:0.003741s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '65|fc5ade2523007a8149e3224136e9bc6d' WHERE `id` = 65 [ RunTime:0.003691s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 39 [ RunTime:0.003455s ] --------------------------------------------------------------- [2024-01-08T14:55:49+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000959s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020610s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000831s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '潮萍' , `sex` = 2 WHERE `id` = 65 [ RunTime:0.000568s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.014318s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 65 [ RunTime:0.001538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.024496s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 65,1,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,2,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,3,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,4,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,5,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,6,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,7,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,8,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,9,0,1704696949,'2024-01-08 14:55:49' ) , ( 65,10,0,1704696949,'2024-01-08 14:55:49' ) [ RunTime:0.001043s ] --------------------------------------------------------------- [2024-01-08T14:55:50+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000795s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021849s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000873s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024091s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 65 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000915s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.024775s ] [ 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` = 65 [ RunTime:0.001350s ] --------------------------------------------------------------- [2024-01-08T14:55:50+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013206s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.014313s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.016099s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 65 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000580s ] --------------------------------------------------------------- [2024-01-08T14:55:53+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.003298s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022368s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.029891s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 65 AND `status` = 0 [ RunTime:0.000772s ] --------------------------------------------------------------- [2024-01-08T14:55:53+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002594s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016054s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000674s ] [ 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` = 65 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005401s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.016142s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 65 LIMIT 1 [ RunTime:0.000590s ] --------------------------------------------------------------- [2024-01-08T14:56:02+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/Hospital/myHospital [ 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.023343s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000854s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039228s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 65 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.028479s ] [ 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.004562s ] [ 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.001106s ] --------------------------------------------------------------- [2024-01-08T14:56:02+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000865s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024673s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001805s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027088s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 65 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002069s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018243s ] [ 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.001030s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.015707s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000568s ] --------------------------------------------------------------- [2024-01-08T15:28:05+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/Hospital/hospitalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.013200s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018743s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001026s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.015707s ] [ 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` = 8 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.014566s ] [ 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` = 8 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC [ RunTime:0.000777s ] --------------------------------------------------------------- [2024-01-08T15:28:16+08:00] 220.202.152.77 POST 101.132.37.87:9001/api/My/myCreateTask [ sql ] [ DB ] CONNECT:[ UseTime:0.001034s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024657s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '65|fc5ade2523007a8149e3224136e9bc6d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000837s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.025279s ] [ 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` = 65 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.004883s ]