[2022-01-14T00:00:01+08:00][sql] CONNECT:[ UseTime:0.029948s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T00:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020849s ]
[2022-01-14T00:10:01+08:00][sql] CONNECT:[ UseTime:0.034093s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T00:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023567s ]
[2022-01-14T00:20:01+08:00][sql] CONNECT:[ UseTime:0.030107s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T00:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020745s ]
[2022-01-14T00:30:02+08:00][sql] CONNECT:[ UseTime:0.030745s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T00:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021204s ]
[2022-01-14T00:40:02+08:00][sql] CONNECT:[ UseTime:0.031749s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T00:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021832s ]
[2022-01-14T00:50:02+08:00][sql] CONNECT:[ UseTime:0.035616s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T00:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024658s ]
[2022-01-14T01:00:01+08:00][sql] CONNECT:[ UseTime:0.032695s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T01:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022517s ]
[2022-01-14T01:10:01+08:00][sql] CONNECT:[ UseTime:0.031149s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T01:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021684s ]
[2022-01-14T01:20:01+08:00][sql] CONNECT:[ UseTime:0.030364s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T01:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020896s ]
[2022-01-14T01:30:01+08:00][sql] CONNECT:[ UseTime:0.031348s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T01:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021548s ]
[2022-01-14T01:40:01+08:00][sql] CONNECT:[ UseTime:0.030878s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T01:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021515s ]
[2022-01-14T01:50:02+08:00][sql] CONNECT:[ UseTime:0.033720s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T01:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023202s ]
[2022-01-14T02:00:02+08:00][sql] CONNECT:[ UseTime:0.033537s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T02:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023207s ]
[2022-01-14T02:10:02+08:00][sql] CONNECT:[ UseTime:0.032778s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T02:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022608s ]
[2022-01-14T02:20:01+08:00][sql] CONNECT:[ UseTime:0.031393s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T02:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021715s ]
[2022-01-14T02:30:01+08:00][sql] CONNECT:[ UseTime:0.034546s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T02:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023817s ]
[2022-01-14T02:40:01+08:00][sql] CONNECT:[ UseTime:0.030596s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T02:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021374s ]
[2022-01-14T02:50:01+08:00][sql] CONNECT:[ UseTime:0.029877s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T02:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020626s ]
[2022-01-14T03:00:01+08:00][sql] CONNECT:[ UseTime:0.031520s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T03:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021862s ]
[2022-01-14T03:10:02+08:00][sql] CONNECT:[ UseTime:0.034219s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T03:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023588s ]
[2022-01-14T03:20:02+08:00][sql] CONNECT:[ UseTime:0.033127s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T03:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023172s ]
[2022-01-14T03:30:01+08:00][sql] CONNECT:[ UseTime:0.032396s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T03:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022210s ]
[2022-01-14T03:40:01+08:00][sql] CONNECT:[ UseTime:0.031041s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T03:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021415s ]
[2022-01-14T03:50:01+08:00][sql] CONNECT:[ UseTime:0.029219s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T03:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020469s ]
[2022-01-14T04:00:01+08:00][sql] CONNECT:[ UseTime:0.030988s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T04:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021439s ]
[2022-01-14T04:10:01+08:00][sql] CONNECT:[ UseTime:0.034814s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T04:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023424s ]
[2022-01-14T04:20:02+08:00][sql] CONNECT:[ UseTime:0.031027s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T04:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020768s ]
[2022-01-14T04:30:02+08:00][sql] CONNECT:[ UseTime:0.030889s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T04:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021268s ]
[2022-01-14T04:40:02+08:00][sql] CONNECT:[ UseTime:0.030222s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T04:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020770s ]
[2022-01-14T04:50:01+08:00][sql] CONNECT:[ UseTime:0.031817s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T04:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022120s ]
[2022-01-14T05:00:01+08:00][sql] CONNECT:[ UseTime:0.034371s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T05:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023546s ]
[2022-01-14T05:10:01+08:00][sql] CONNECT:[ UseTime:0.029979s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T05:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020578s ]
[2022-01-14T05:20:01+08:00][sql] CONNECT:[ UseTime:0.029134s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T05:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020331s ]
[2022-01-14T05:30:01+08:00][sql] CONNECT:[ UseTime:0.031778s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T05:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021720s ]
[2022-01-14T05:40:02+08:00][sql] CONNECT:[ UseTime:0.029443s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T05:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020337s ]
[2022-01-14T05:50:02+08:00][sql] CONNECT:[ UseTime:0.031426s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T05:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021566s ]
[2022-01-14T06:00:01+08:00][sql] CONNECT:[ UseTime:0.030022s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T06:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020786s ]
[2022-01-14T06:10:01+08:00][sql] CONNECT:[ UseTime:0.032391s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T06:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022189s ]
[2022-01-14T06:20:01+08:00][sql] CONNECT:[ UseTime:0.034132s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T06:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023680s ]
[2022-01-14T06:30:01+08:00][sql] CONNECT:[ UseTime:0.030510s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T06:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021008s ]
[2022-01-14T06:40:01+08:00][sql] CONNECT:[ UseTime:0.030502s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T06:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021065s ]
[2022-01-14T06:50:01+08:00][sql] CONNECT:[ UseTime:0.033692s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T06:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023521s ]
[2022-01-14T07:00:02+08:00][sql] CONNECT:[ UseTime:0.030754s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T07:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021271s ]
[2022-01-14T07:10:02+08:00][sql] CONNECT:[ UseTime:0.030718s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T07:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021013s ]
[2022-01-14T07:20:02+08:00][sql] CONNECT:[ UseTime:0.030540s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T07:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021000s ]
[2022-01-14T07:30:01+08:00][sql] CONNECT:[ UseTime:0.030373s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T07:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020909s ]
[2022-01-14T07:40:01+08:00][sql] CONNECT:[ UseTime:0.033175s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T07:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022857s ]
[2022-01-14T07:50:01+08:00][sql] CONNECT:[ UseTime:0.033833s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T07:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023021s ]
[2022-01-14T08:00:01+08:00][sql] CONNECT:[ UseTime:0.030383s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T08:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020754s ]
[2022-01-14T08:10:01+08:00][sql] CONNECT:[ UseTime:0.032706s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T08:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022304s ]
[2022-01-14T08:20:01+08:00][sql] CONNECT:[ UseTime:0.033134s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T08:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022785s ]
[2022-01-14T08:30:02+08:00][sql] CONNECT:[ UseTime:0.032301s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T08:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021610s ]
[2022-01-14T08:40:02+08:00][sql] CONNECT:[ UseTime:0.031642s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T08:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021739s ]
[2022-01-14T08:50:02+08:00][sql] CONNECT:[ UseTime:0.029664s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T08:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020435s ]
[2022-01-14T09:00:01+08:00][sql] CONNECT:[ UseTime:0.030421s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T09:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020968s ]
[2022-01-14T09:10:01+08:00][sql] CONNECT:[ UseTime:0.034615s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T09:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023931s ]
[2022-01-14T09:20:01+08:00][sql] CONNECT:[ UseTime:0.030109s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T09:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021254s ]
[2022-01-14T09:30:01+08:00][sql] CONNECT:[ UseTime:0.034847s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T09:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023863s ]
[2022-01-14T09:31:37+08:00][DEBUG] [ 2022-01-14T09:31:37+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty!
[2022-01-14T09:31:55+08:00][sql] CONNECT:[ UseTime:0.032005s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T09:31:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021762s ]
[2022-01-14T09:31:55+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '15381816223' LIMIT 1 [ RunTime:0.022523s ]
[2022-01-14T09:31:55+08:00][DEBUG] [ 2022-01-14T09:31:55+08:00 ] rediskey15381816223_signin_verify
[2022-01-14T09:32:15+08:00][sql] CONNECT:[ UseTime:0.030747s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T09:32:15+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021366s ]
[2022-01-14T09:32:15+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '15381816223' LIMIT 1 [ RunTime:0.022206s ]
[2022-01-14T09:32:15+08:00][DEBUG] [ 2022-01-14T09:32:15+08:00 ] rediskey15381816223_signin_verify
[2022-01-14T09:32:15+08:00][DEBUG] [ 2022-01-14T09:32:15+08:00 ] session11
[2022-01-14T09:32:15+08:00][WARN] [ 2022-01-14T09:32:15+08:00 ] Controller : MiniProgramInterface | login | smsCode error
[2022-01-14T09:40:01+08:00][sql] CONNECT:[ UseTime:0.032125s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T09:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021978s ]
[2022-01-14T09:50:01+08:00][sql] CONNECT:[ UseTime:0.031190s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T09:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021544s ]
[2022-01-14T10:00:01+08:00][sql] CONNECT:[ UseTime:0.030211s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T10:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020663s ]
[2022-01-14T10:10:01+08:00][sql] CONNECT:[ UseTime:0.030775s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T10:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021239s ]
[2022-01-14T10:20:01+08:00][sql] CONNECT:[ UseTime:0.031123s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T10:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021333s ]
[2022-01-14T10:30:01+08:00][sql] CONNECT:[ UseTime:0.031214s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T10:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021647s ]
[2022-01-14T10:39:03+08:00][sql] CONNECT:[ UseTime:0.030481s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T10:39:03+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021182s ]
[2022-01-14T10:39:03+08:00][DEBUG] [ 2022-01-14T10:39:03+08:00 ] function | invalidSession | jwt expire!
[2022-01-14T10:39:42+08:00][sql] CONNECT:[ UseTime:0.031066s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T10:39:42+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022043s ]
[2022-01-14T10:39:42+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '13958623938' LIMIT 1 [ RunTime:0.023613s ]
[2022-01-14T10:39:42+08:00][DEBUG] [ 2022-01-14T10:39:42+08:00 ] rediskey13958623938_signin_verify
[2022-01-14T10:40:01+08:00][sql] CONNECT:[ UseTime:0.030379s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T10:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022463s ]
[2022-01-14T10:50:01+08:00][sql] CONNECT:[ UseTime:0.030029s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T10:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020662s ]
[2022-01-14T11:00:01+08:00][sql] CONNECT:[ UseTime:0.029566s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020500s ]
[2022-01-14T11:10:01+08:00][sql] CONNECT:[ UseTime:0.030349s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021210s ]
[2022-01-14T11:14:10+08:00][sql] CONNECT:[ UseTime:0.033815s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:14:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023209s ]
[2022-01-14T11:14:10+08:00][sql] INSERT INTO `swgk_ua` SET `ua` = 'Mozilla/5.0 (Linux; Android 10; HMA-AL00 Build/HUAWEIHMA-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/3171 MMWEBSDK/20211001 Mobile Safari/537.36 MMWEBID/8334 MicroMessenger/8.0.16.2040(0x2800105F) Process/appbrand0 WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android' , `signs` = '4dc4e4369e00b17bc2497f067ce7c226' [ RunTime:0.023088s ]
[2022-01-14T11:14:10+08:00][DEBUG] [ 2022-01-14T11:14:10+08:00 ] function | invalidSession | jwt expire!
[2022-01-14T11:14:34+08:00][sql] CONNECT:[ UseTime:0.029789s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:14:34+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020983s ]
[2022-01-14T11:14:34+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '13819697978' LIMIT 1 [ RunTime:0.022026s ]
[2022-01-14T11:14:34+08:00][DEBUG] [ 2022-01-14T11:14:34+08:00 ] rediskey13819697978_signin_verify
[2022-01-14T11:15:20+08:00][sql] CONNECT:[ UseTime:0.035981s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:15:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022392s ]
[2022-01-14T11:15:20+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '13819697978' LIMIT 1 [ RunTime:0.023162s ]
[2022-01-14T11:15:20+08:00][DEBUG] [ 2022-01-14T11:15:20+08:00 ] rediskey13819697978_signin_verify
[2022-01-14T11:15:20+08:00][DEBUG] [ 2022-01-14T11:15:20+08:00 ] session11
[2022-01-14T11:15:20+08:00][WARN] [ 2022-01-14T11:15:20+08:00 ] Controller : MiniProgramInterface | login | smsCode error
[2022-01-14T11:20:01+08:00][sql] CONNECT:[ UseTime:0.035448s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023952s ]
[2022-01-14T11:30:01+08:00][sql] CONNECT:[ UseTime:0.034770s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021536s ]
[2022-01-14T11:40:01+08:00][sql] CONNECT:[ UseTime:0.032373s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022298s ]
[2022-01-14T11:50:01+08:00][sql] CONNECT:[ UseTime:0.034566s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T11:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023674s ]
[2022-01-14T12:00:01+08:00][sql] CONNECT:[ UseTime:0.031383s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T12:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021390s ]
[2022-01-14T12:10:01+08:00][sql] CONNECT:[ UseTime:0.030004s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T12:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021059s ]
[2022-01-14T12:20:01+08:00][sql] CONNECT:[ UseTime:0.033341s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T12:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021414s ]
[2022-01-14T12:30:01+08:00][sql] CONNECT:[ UseTime:0.034519s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T12:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023817s ]
[2022-01-14T12:31:38+08:00][DEBUG] [ 2022-01-14T12:31:38+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty!
[2022-01-14T12:40:02+08:00][sql] CONNECT:[ UseTime:0.030409s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T12:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022137s ]
[2022-01-14T12:50:02+08:00][sql] CONNECT:[ UseTime:0.030301s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T12:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020840s ]
[2022-01-14T13:00:02+08:00][sql] CONNECT:[ UseTime:0.030932s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021550s ]
[2022-01-14T13:10:02+08:00][sql] CONNECT:[ UseTime:0.030570s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020916s ]
[2022-01-14T13:20:02+08:00][sql] CONNECT:[ UseTime:0.030994s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021494s ]
[2022-01-14T13:21:20+08:00][sql] CONNECT:[ UseTime:0.033473s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:21:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023148s ]
[2022-01-14T13:21:20+08:00][DEBUG] [ 2022-01-14T13:21:20+08:00 ] function | invalidSession | jwt expire!
[2022-01-14T13:22:17+08:00][sql] CONNECT:[ UseTime:0.030188s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:22:17+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021490s ]
[2022-01-14T13:22:17+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '13867680067' LIMIT 1 [ RunTime:0.022860s ]
[2022-01-14T13:22:17+08:00][DEBUG] [ 2022-01-14T13:22:17+08:00 ] rediskey13867680067_signin_verify
[2022-01-14T13:22:17+08:00][DEBUG] [ 2022-01-14T13:22:17+08:00 ] session11
[2022-01-14T13:22:17+08:00][WARN] [ 2022-01-14T13:22:17+08:00 ] Controller : MiniProgramInterface | login | smsCode error
[2022-01-14T13:22:40+08:00][sql] CONNECT:[ UseTime:0.030086s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:22:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021209s ]
[2022-01-14T13:22:40+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '13867680067' LIMIT 1 [ RunTime:0.019656s ]
[2022-01-14T13:22:40+08:00][DEBUG] [ 2022-01-14T13:22:40+08:00 ] rediskey13867680067_signin_verify
[2022-01-14T13:30:01+08:00][sql] CONNECT:[ UseTime:0.034767s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023861s ]
[2022-01-14T13:40:01+08:00][sql] CONNECT:[ UseTime:0.029918s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020660s ]
[2022-01-14T13:50:01+08:00][sql] CONNECT:[ UseTime:0.029534s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020332s ]
[2022-01-14T13:52:05+08:00][DEBUG] [ 2022-01-14T13:52:05+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty!
[2022-01-14T13:52:26+08:00][sql] CONNECT:[ UseTime:0.032079s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:52:26+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022781s ]
[2022-01-14T13:52:26+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '13705869455' LIMIT 1 [ RunTime:0.023572s ]
[2022-01-14T13:52:26+08:00][DEBUG] [ 2022-01-14T13:52:26+08:00 ] rediskey13705869455_signin_verify
[2022-01-14T13:52:47+08:00][sql] CONNECT:[ UseTime:0.031518s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:52:47+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022189s ]
[2022-01-14T13:52:47+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '13705869455' LIMIT 1 [ RunTime:0.022945s ]
[2022-01-14T13:52:47+08:00][DEBUG] [ 2022-01-14T13:52:47+08:00 ] rediskey13705869455_signin_verify
[2022-01-14T13:52:47+08:00][DEBUG] [ 2022-01-14T13:52:47+08:00 ] session11
[2022-01-14T13:52:47+08:00][WARN] [ 2022-01-14T13:52:47+08:00 ] Controller : MiniProgramInterface | login | smsCode error
[2022-01-14T13:59:04+08:00][DEBUG] [ 2022-01-14T13:59:04+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty!
[2022-01-14T13:59:19+08:00][sql] CONNECT:[ UseTime:0.031246s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T13:59:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021701s ]
[2022-01-14T13:59:19+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '15068691508' LIMIT 1 [ RunTime:0.022409s ]
[2022-01-14T13:59:19+08:00][DEBUG] [ 2022-01-14T13:59:19+08:00 ] rediskey15068691508_signin_verify
[2022-01-14T14:00:01+08:00][sql] CONNECT:[ UseTime:0.033970s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T14:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022530s ]
[2022-01-14T14:10:01+08:00][sql] CONNECT:[ UseTime:0.034179s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T14:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023238s ]
[2022-01-14T14:20:01+08:00][sql] CONNECT:[ UseTime:0.031270s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T14:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021691s ]
[2022-01-14T14:30:01+08:00][sql] CONNECT:[ UseTime:0.030048s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T14:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020790s ]
[2022-01-14T14:40:01+08:00][sql] CONNECT:[ UseTime:0.030924s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T14:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021370s ]
[2022-01-14T14:50:01+08:00][sql] CONNECT:[ UseTime:0.031550s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T14:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021855s ]
[2022-01-14T14:53:00+08:00][DEBUG] [ 2022-01-14T14:53:00+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty!
[2022-01-14T14:53:57+08:00][DEBUG] [ 2022-01-14T14:53:57+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty!
[2022-01-14T14:55:30+08:00][sql] CONNECT:[ UseTime:0.030920s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T14:55:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021629s ]
[2022-01-14T14:55:30+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '15325600711' LIMIT 1 [ RunTime:0.022819s ]
[2022-01-14T14:55:30+08:00][DEBUG] [ 2022-01-14T14:55:30+08:00 ] rediskey15325600711_signin_verify
[2022-01-14T14:55:30+08:00][DEBUG] [ 2022-01-14T14:55:30+08:00 ] Event: SMS | checkSMSCode | APP_SMS_CODE_EXPIRE error = |1642143250|
[2022-01-14T14:55:30+08:00][WARN] [ 2022-01-14T14:55:30+08:00 ] Controller : MiniProgramInterface | login | smsCode error
[2022-01-14T14:55:52+08:00][sql] CONNECT:[ UseTime:0.030073s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T14:55:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021118s ]
[2022-01-14T14:55:52+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `t1`.`phone` = '15325600711' LIMIT 1 [ RunTime:0.020530s ]
[2022-01-14T14:55:52+08:00][DEBUG] [ 2022-01-14T14:55:52+08:00 ] rediskey15325600711_signin_verify
[2022-01-14T15:00:02+08:00][sql] CONNECT:[ UseTime:0.031674s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T15:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022031s ]
[2022-01-14T15:10:02+08:00][sql] CONNECT:[ UseTime:0.033780s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T15:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024867s ]
[2022-01-14T15:20:02+08:00][sql] CONNECT:[ UseTime:0.030640s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T15:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021247s ]
[2022-01-14T15:30:02+08:00][sql] CONNECT:[ UseTime:0.030363s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T15:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020757s ]
[2022-01-14T15:40:02+08:00][sql] CONNECT:[ UseTime:0.030561s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T15:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022046s ]
[2022-01-14T15:50:01+08:00][sql] CONNECT:[ UseTime:0.030218s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T15:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020846s ]
[2022-01-14T16:00:01+08:00][sql] CONNECT:[ UseTime:0.031158s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T16:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021879s ]
[2022-01-14T16:10:01+08:00][sql] CONNECT:[ UseTime:0.031218s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T16:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021465s ]
[2022-01-14T16:20:01+08:00][sql] CONNECT:[ UseTime:0.033419s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T16:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023112s ]
[2022-01-14T16:30:01+08:00][sql] CONNECT:[ UseTime:0.032005s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T16:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021638s ]
[2022-01-14T16:40:01+08:00][sql] CONNECT:[ UseTime:0.031999s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T16:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021999s ]
[2022-01-14T16:50:01+08:00][sql] CONNECT:[ UseTime:0.034652s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T16:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023969s ]
[2022-01-14T17:00:01+08:00][sql] CONNECT:[ UseTime:0.031001s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T17:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021432s ]
[2022-01-14T17:10:01+08:00][sql] CONNECT:[ UseTime:0.032941s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T17:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022732s ]
[2022-01-14T17:20:01+08:00][sql] CONNECT:[ UseTime:0.030015s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T17:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020847s ]
[2022-01-14T17:30:01+08:00][sql] CONNECT:[ UseTime:0.032832s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T17:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022462s ]
[2022-01-14T17:40:02+08:00][sql] CONNECT:[ UseTime:0.031579s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T17:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021652s ]
[2022-01-14T17:50:02+08:00][sql] CONNECT:[ UseTime:0.032370s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T17:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022038s ]
[2022-01-14T18:00:02+08:00][sql] CONNECT:[ UseTime:0.034408s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T18:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023717s ]
[2022-01-14T18:10:02+08:00][sql] CONNECT:[ UseTime:0.029424s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T18:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020345s ]
[2022-01-14T18:20:01+08:00][sql] CONNECT:[ UseTime:0.029742s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T18:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020633s ]
[2022-01-14T18:30:01+08:00][sql] CONNECT:[ UseTime:0.034347s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T18:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023441s ]
[2022-01-14T18:40:01+08:00][sql] CONNECT:[ UseTime:0.030719s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T18:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021233s ]
[2022-01-14T18:50:01+08:00][sql] CONNECT:[ UseTime:0.031145s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T18:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022483s ]
[2022-01-14T19:00:01+08:00][sql] CONNECT:[ UseTime:0.030195s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T19:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020719s ]
[2022-01-14T19:10:01+08:00][sql] CONNECT:[ UseTime:0.035475s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T19:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022544s ]
[2022-01-14T19:20:01+08:00][sql] CONNECT:[ UseTime:0.029655s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T19:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021275s ]
[2022-01-14T19:30:02+08:00][sql] CONNECT:[ UseTime:0.030168s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T19:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020701s ]
[2022-01-14T19:40:02+08:00][sql] CONNECT:[ UseTime:0.030806s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T19:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021120s ]
[2022-01-14T19:50:02+08:00][sql] CONNECT:[ UseTime:0.033374s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T19:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022440s ]
[2022-01-14T20:00:01+08:00][sql] CONNECT:[ UseTime:0.030721s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T20:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020715s ]
[2022-01-14T20:10:01+08:00][sql] CONNECT:[ UseTime:0.031335s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T20:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021687s ]
[2022-01-14T20:20:01+08:00][sql] CONNECT:[ UseTime:0.029846s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T20:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020514s ]
[2022-01-14T20:30:01+08:00][sql] CONNECT:[ UseTime:0.031087s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T20:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021571s ]
[2022-01-14T20:40:01+08:00][sql] CONNECT:[ UseTime:0.029389s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T20:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.031944s ]
[2022-01-14T20:50:01+08:00][sql] CONNECT:[ UseTime:0.035232s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T20:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024178s ]
[2022-01-14T21:00:01+08:00][sql] CONNECT:[ UseTime:0.032226s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T21:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022286s ]
[2022-01-14T21:10:01+08:00][sql] CONNECT:[ UseTime:0.035789s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T21:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023207s ]
[2022-01-14T21:20:01+08:00][sql] CONNECT:[ UseTime:0.031557s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T21:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021751s ]
[2022-01-14T21:30:02+08:00][sql] CONNECT:[ UseTime:0.033398s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T21:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022854s ]
[2022-01-14T21:40:02+08:00][sql] CONNECT:[ UseTime:0.033804s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T21:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023244s ]
[2022-01-14T21:50:02+08:00][sql] CONNECT:[ UseTime:0.032996s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T21:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022550s ]
[2022-01-14T22:00:01+08:00][sql] CONNECT:[ UseTime:0.029162s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T22:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020204s ]
[2022-01-14T22:10:01+08:00][sql] CONNECT:[ UseTime:0.033081s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T22:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022610s ]
[2022-01-14T22:20:01+08:00][sql] CONNECT:[ UseTime:0.030820s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T22:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021340s ]
[2022-01-14T22:30:01+08:00][sql] CONNECT:[ UseTime:0.030727s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T22:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021115s ]
[2022-01-14T22:40:01+08:00][sql] CONNECT:[ UseTime:0.031344s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T22:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021604s ]
[2022-01-14T22:50:01+08:00][sql] CONNECT:[ UseTime:0.035863s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T22:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024639s ]
[2022-01-14T23:00:02+08:00][sql] CONNECT:[ UseTime:0.029806s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T23:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020595s ]
[2022-01-14T23:10:02+08:00][sql] CONNECT:[ UseTime:0.030439s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T23:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021189s ]
[2022-01-14T23:20:02+08:00][sql] CONNECT:[ UseTime:0.030187s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T23:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020875s ]
[2022-01-14T23:30:01+08:00][sql] CONNECT:[ UseTime:0.030028s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T23:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020704s ]
[2022-01-14T23:40:01+08:00][sql] CONNECT:[ UseTime:0.034084s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023270s ]
[2022-01-14T23:50:01+08:00][sql] CONNECT:[ UseTime:0.030654s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8
[2022-01-14T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.032898s ]