--------------------------------------------------------------- [2022-07-28T02:54:33+08:00] 123.145.36.182 CONNECT www.voanews.com:443 [ error ] [8]未定义数组索引: connect --------------------------------------------------------------- [2022-07-28T07:11:14+08:00] 39.144.179.164 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.022087s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030478s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15903725680' LIMIT 1 [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.020078s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('15903725680' , 0 , 771025 , 1658963474 , '2022-07-28 07:11:14') [ RunTime:0.004305s ] --------------------------------------------------------------- [2022-07-28T07:11:28+08:00] 39.144.179.164 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000698s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.027238s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '15903725680' AND `phone_code` = '771025' LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.019734s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0124' , 1 , 0 , 0 , 1658963488 , '2022-07-28 07:11:28') [ RunTime:0.004519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021686s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('15903725680' , 'cd48cc70f2b45da4747a9f18a32648da' , '0124' , 0 , 0 , 1658963488 , '2022-07-28 07:11:28' , 1658963488 , 41) [ RunTime:0.002943s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020463s ] [ 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 , 1658963488 , '2022-07-28 07:11:28' , 1 , 1 , 51) [ RunTime:0.003842s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026659s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1658963488 , '2022-07-28 07:11:28' , 51) [ RunTime:0.001850s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '51|b33918a3863e4e38c5630d6e77443c3d' WHERE `id` = 51 [ RunTime:0.003337s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 22 [ RunTime:0.003224s ] --------------------------------------------------------------- [2022-07-28T07:12:01+08:00] 39.144.179.164 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000691s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027462s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '51|b33918a3863e4e38c5630d6e77443c3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '张艳芬' , `sex` = 2 WHERE `id` = 51 [ RunTime:0.000464s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023593s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 51 [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.020514s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 51,1,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,2,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,3,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,4,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,5,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,6,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,7,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,8,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,9,0,1658963521,'2022-07-28 07:12:01' ) , ( 51,10,0,1658963521,'2022-07-28 07:12:01' ) [ RunTime:0.001073s ] --------------------------------------------------------------- [2022-07-28T07:12:01+08:00] 39.144.179.164 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000892s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030607s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '51|b33918a3863e4e38c5630d6e77443c3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.026180s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 51 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.022380s ] [ 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` = 51 [ RunTime:0.001820s ] --------------------------------------------------------------- [2022-07-28T07:12:02+08:00] 39.144.179.164 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000786s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.053376s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '51|b33918a3863e4e38c5630d6e77443c3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.050956s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 51 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000600s ] --------------------------------------------------------------- [2022-07-28T07:19:30+08:00] 39.144.179.164 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000871s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039186s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '51|b33918a3863e4e38c5630d6e77443c3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000762s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.045013s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 51 AND `status` = 0 [ RunTime:0.000556s ] --------------------------------------------------------------- [2022-07-28T07:19:30+08:00] 39.144.179.164 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000835s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.055536s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '51|b33918a3863e4e38c5630d6e77443c3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000692s ] [ 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` = 51 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001148s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.053813s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 51 LIMIT 1 [ RunTime:0.000635s ] --------------------------------------------------------------- [2022-07-28T07:19:33+08:00] 39.144.179.164 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.000698s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027356s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '51|b33918a3863e4e38c5630d6e77443c3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.022006s ] [ 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` = 51 AND `d`.`is_delete` = 0 [ RunTime:0.000633s ] --------------------------------------------------------------- [2022-07-28T08:28:41+08:00] 42.233.161.195 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000860s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029264s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '51|b33918a3863e4e38c5630d6e77443c3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.025836s ] [ 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` = 51 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000957s ]