[2021-05-20T00:00:01+08:00][sql] CONNECT:[ UseTime:0.029796s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T00:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020707s ] [2021-05-20T00:08:17+08:00][sql] CONNECT:[ UseTime:0.033711s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T00:08:17+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023299s ] [2021-05-20T00:08:17+08:00][sql] INSERT INTO `swgk_ua` SET `ua` = 'Mozilla/5.0 (Linux; Android 9; V1913T Build/P00610; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/78.0.3904.62 XWEB/2797 MMWEBSDK/20210302 Mobile Safari/537.36 MMWEBID/743 MicroMessenger/8.0.3.1880(0x28000339) Process/appbrand0 WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android' , `signs` = '7ebf1710f3f5c76eb699188c2694ab15' [ RunTime:0.023016s ] [2021-05-20T00:08:17+08:00][DEBUG] [ 2021-05-20T00:08:17+08:00 ] function | invalidSession | jwt expire! [2021-05-20T00:08:44+08:00][sql] CONNECT:[ UseTime:0.035451s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T00:08:44+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.024891s ] [2021-05-20T00:08:44+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` = '13968619009' LIMIT 1 [ RunTime:0.025966s ] [2021-05-20T00:08:44+08:00][DEBUG] [ 2021-05-20T00:08:44+08:00 ] rediskey13968619009_signin_verify [2021-05-20T00:10:01+08:00][sql] CONNECT:[ UseTime:0.030332s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T00:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021650s ] [2021-05-20T00:20:01+08:00][sql] CONNECT:[ UseTime:0.031655s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T00:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021994s ] [2021-05-20T00:30:01+08:00][sql] CONNECT:[ UseTime:0.032172s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T00:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022528s ] [2021-05-20T00:40:01+08:00][sql] CONNECT:[ UseTime:0.030731s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T00:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021270s ] [2021-05-20T00:50:02+08:00][sql] CONNECT:[ UseTime:0.029192s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T00:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020216s ] [2021-05-20T01:00:02+08:00][sql] CONNECT:[ UseTime:0.031592s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T01:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021916s ] [2021-05-20T01:10:02+08:00][sql] CONNECT:[ UseTime:0.029004s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T01:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020418s ] [2021-05-20T01:20:01+08:00][sql] CONNECT:[ UseTime:0.031860s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T01:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022183s ] [2021-05-20T01:30:01+08:00][sql] CONNECT:[ UseTime:0.033166s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T01:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023197s ] [2021-05-20T01:40:01+08:00][sql] CONNECT:[ UseTime:0.035983s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T01:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.036923s ] [2021-05-20T01:50:01+08:00][sql] CONNECT:[ UseTime:0.030770s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T01:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021344s ] [2021-05-20T02:00:01+08:00][sql] CONNECT:[ UseTime:0.029004s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020347s ] [2021-05-20T02:10:01+08:00][sql] CONNECT:[ UseTime:0.033076s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022939s ] [2021-05-20T02:20:01+08:00][sql] CONNECT:[ UseTime:0.030104s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021246s ] [2021-05-20T02:30:01+08:00][sql] CONNECT:[ UseTime:0.030794s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021361s ] [2021-05-20T02:40:01+08:00][sql] CONNECT:[ UseTime:0.032985s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022924s ] [2021-05-20T02:50:01+08:00][sql] CONNECT:[ UseTime:0.035091s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024741s ] [2021-05-20T02:54:36+08:00][sql] CONNECT:[ UseTime:0.032544s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:54:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022578s ] [2021-05-20T02:54:36+08:00][DEBUG] [ 2021-05-20T02:54:36+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-05-20T02:54:41+08:00][sql] CONNECT:[ UseTime:0.029445s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:54:41+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020433s ] [2021-05-20T02:54:41+08:00][DEBUG] [ 2021-05-20T02:54:41+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone error [2021-05-20T02:54:41+08:00][sql] CONNECT:[ UseTime:0.030211s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:54:41+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020913s ] [2021-05-20T02:54:41+08:00][DEBUG] [ 2021-05-20T02:54:41+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone error [2021-05-20T02:54:42+08:00][sql] CONNECT:[ UseTime:0.028318s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T02:54:42+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019455s ] [2021-05-20T02:54:42+08:00][DEBUG] [ 2021-05-20T02:54:42+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone error [2021-05-20T03:00:02+08:00][sql] CONNECT:[ UseTime:0.030778s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T03:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022060s ] [2021-05-20T03:10:02+08:00][sql] CONNECT:[ UseTime:0.029972s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T03:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020654s ] [2021-05-20T03:20:02+08:00][sql] CONNECT:[ UseTime:0.033772s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T03:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023369s ] [2021-05-20T03:30:01+08:00][sql] CONNECT:[ UseTime:0.031678s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T03:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022363s ] [2021-05-20T03:40:01+08:00][sql] CONNECT:[ UseTime:0.029535s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T03:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020570s ] [2021-05-20T03:50:01+08:00][sql] CONNECT:[ UseTime:0.032960s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T03:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023023s ] [2021-05-20T04:00:01+08:00][sql] CONNECT:[ UseTime:0.028752s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T04:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020010s ] [2021-05-20T04:10:01+08:00][sql] CONNECT:[ UseTime:0.029760s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T04:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020654s ] [2021-05-20T04:20:01+08:00][sql] CONNECT:[ UseTime:0.029410s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T04:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020479s ] [2021-05-20T04:30:02+08:00][sql] CONNECT:[ UseTime:0.029952s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T04:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020876s ] [2021-05-20T04:40:02+08:00][sql] CONNECT:[ UseTime:0.032077s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T04:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022575s ] [2021-05-20T04:50:01+08:00][sql] CONNECT:[ UseTime:0.033891s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T04:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023405s ] [2021-05-20T05:00:01+08:00][sql] CONNECT:[ UseTime:0.032066s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T05:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022197s ] [2021-05-20T05:10:01+08:00][sql] CONNECT:[ UseTime:0.029422s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T05:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020707s ] [2021-05-20T05:20:01+08:00][sql] CONNECT:[ UseTime:0.033883s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T05:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023451s ] [2021-05-20T05:30:01+08:00][sql] CONNECT:[ UseTime:0.029939s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T05:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020602s ] [2021-05-20T05:40:01+08:00][sql] CONNECT:[ UseTime:0.029359s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T05:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022181s ] [2021-05-20T05:50:02+08:00][sql] CONNECT:[ UseTime:0.035609s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T05:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024539s ] [2021-05-20T06:00:02+08:00][sql] CONNECT:[ UseTime:0.034634s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T06:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024092s ] [2021-05-20T06:10:02+08:00][sql] CONNECT:[ UseTime:0.030707s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T06:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021527s ] [2021-05-20T06:20:02+08:00][sql] CONNECT:[ UseTime:0.032187s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T06:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022228s ] [2021-05-20T06:30:01+08:00][sql] CONNECT:[ UseTime:0.029779s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T06:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020861s ] [2021-05-20T06:40:01+08:00][sql] CONNECT:[ UseTime:0.031081s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T06:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021768s ] [2021-05-20T06:50:01+08:00][sql] CONNECT:[ UseTime:0.034019s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T06:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023067s ] [2021-05-20T07:00:01+08:00][sql] CONNECT:[ UseTime:0.032167s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T07:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022380s ] [2021-05-20T07:10:01+08:00][sql] CONNECT:[ UseTime:0.031339s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T07:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021887s ] [2021-05-20T07:20:01+08:00][sql] CONNECT:[ UseTime:0.030763s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T07:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021671s ] [2021-05-20T07:30:02+08:00][sql] CONNECT:[ UseTime:0.032505s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T07:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022471s ] [2021-05-20T07:40:02+08:00][sql] CONNECT:[ UseTime:0.031267s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T07:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022797s ] [2021-05-20T07:50:01+08:00][sql] CONNECT:[ UseTime:0.030556s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T07:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021142s ] [2021-05-20T08:00:01+08:00][sql] CONNECT:[ UseTime:0.034103s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T08:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023584s ] [2021-05-20T08:10:01+08:00][sql] CONNECT:[ UseTime:0.032048s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T08:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021642s ] [2021-05-20T08:20:01+08:00][sql] CONNECT:[ UseTime:0.030877s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T08:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021450s ] [2021-05-20T08:30:01+08:00][sql] CONNECT:[ UseTime:0.030014s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T08:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021765s ] [2021-05-20T08:40:01+08:00][sql] CONNECT:[ UseTime:0.030813s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T08:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021660s ] [2021-05-20T08:50:01+08:00][sql] CONNECT:[ UseTime:0.034899s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T08:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024119s ] [2021-05-20T09:00:01+08:00][sql] CONNECT:[ UseTime:0.031216s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021823s ] [2021-05-20T09:10:01+08:00][sql] CONNECT:[ UseTime:0.029835s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020583s ] [2021-05-20T09:20:01+08:00][sql] CONNECT:[ UseTime:0.031581s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021787s ] [2021-05-20T09:21:54+08:00][DEBUG] [ 2021-05-20T09:21:54+08:00 ] function | invalidSession | jwt expire! [2021-05-20T09:21:57+08:00][DEBUG] [ 2021-05-20T09:21:57+08:00 ] function | invalidSession | jwt expire! [2021-05-20T09:22:01+08:00][DEBUG] [ 2021-05-20T09:22:01+08:00 ] function | invalidSession | jwt expire! [2021-05-20T09:22:42+08:00][DEBUG] [ 2021-05-20T09:22:42+08:00 ] function | invalidSession | jwt expire! [2021-05-20T09:23:14+08:00][sql] CONNECT:[ UseTime:0.033383s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:23:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.023595s ] [2021-05-20T09:23:14+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` = '13566478358' LIMIT 1 [ RunTime:0.026503s ] [2021-05-20T09:23:14+08:00][DEBUG] [ 2021-05-20T09:23:14+08:00 ] rediskey13566478358_signin_verify [2021-05-20T09:30:01+08:00][sql] CONNECT:[ UseTime:0.035928s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024561s ] [2021-05-20T09:40:02+08:00][sql] CONNECT:[ UseTime:0.032236s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022460s ] [2021-05-20T09:45:58+08:00][sql] CONNECT:[ UseTime:0.029671s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:45:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020921s ] [2021-05-20T09:45:58+08:00][DEBUG] [ 2021-05-20T09:45:58+08:00 ] function | invalidSession | jwt expire! [2021-05-20T09:46:16+08:00][sql] CONNECT:[ UseTime:0.030651s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:46:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021656s ] [2021-05-20T09:46:16+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` = '13454232222' LIMIT 1 [ RunTime:0.022438s ] [2021-05-20T09:46:16+08:00][DEBUG] [ 2021-05-20T09:46:16+08:00 ] rediskey13454232222_signin_verify [2021-05-20T09:50:02+08:00][sql] CONNECT:[ UseTime:0.036990s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T09:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.025638s ] [2021-05-20T10:00:02+08:00][sql] CONNECT:[ UseTime:0.035780s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T10:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.025771s ] [2021-05-20T10:10:02+08:00][sql] CONNECT:[ UseTime:0.035302s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T10:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023919s ] [2021-05-20T10:20:02+08:00][sql] CONNECT:[ UseTime:0.030736s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T10:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021446s ] [2021-05-20T10:30:02+08:00][sql] CONNECT:[ UseTime:0.034818s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T10:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024279s ] [2021-05-20T10:40:01+08:00][sql] CONNECT:[ UseTime:0.029155s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T10:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022689s ] [2021-05-20T10:50:01+08:00][sql] CONNECT:[ UseTime:0.031936s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T10:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021269s ] [2021-05-20T11:00:01+08:00][sql] CONNECT:[ UseTime:0.033136s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022986s ] [2021-05-20T11:00:02+08:00][sql] CONNECT:[ UseTime:0.032185s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022203s ] [2021-05-20T11:00:02+08:00][DEBUG] [ 2021-05-20T11:00:02+08:00 ] function | invalidSession | jwt expire! [2021-05-20T11:00:17+08:00][sql] CONNECT:[ UseTime:0.029152s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:00:17+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020394s ] [2021-05-20T11:00:17+08:00][DEBUG] [ 2021-05-20T11:00:17+08:00 ] function | invalidSession | jwt expire! [2021-05-20T11:01:00+08:00][DEBUG] [ 2021-05-20T11:01:00+08:00 ] function | invalidSession | jwt expire! [2021-05-20T11:01:02+08:00][sql] CONNECT:[ UseTime:0.031311s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:01:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021938s ] [2021-05-20T11:01:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021496s ] [2021-05-20T11:01:02+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` = '13858615789' LIMIT 1 [ RunTime:0.024182s ] [2021-05-20T11:01:02+08:00][DEBUG] [ 2021-05-20T11:01:02+08:00 ] rediskey13858615789_signin_verify [2021-05-20T11:01:33+08:00][sql] CONNECT:[ UseTime:0.032873s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:01:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021285s ] [2021-05-20T11:01:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020930s ] [2021-05-20T11:01:33+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` = '13858615789' LIMIT 1 [ RunTime:0.022464s ] [2021-05-20T11:01:33+08:00][DEBUG] [ 2021-05-20T11:01:33+08:00 ] rediskey13858615789_signin_verify [2021-05-20T11:01:33+08:00][DEBUG] [ 2021-05-20T11:01:33+08:00 ] session11 [2021-05-20T11:01:33+08:00][WARN] [ 2021-05-20T11:01:33+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-05-20T11:01:33+08:00][sql] CONNECT:[ UseTime:0.030392s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:01:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021787s ] [2021-05-20T11:01:33+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` = '13758651018' LIMIT 1 [ RunTime:0.022707s ] [2021-05-20T11:01:33+08:00][DEBUG] [ 2021-05-20T11:01:33+08:00 ] rediskey13758651018_signin_verify [2021-05-20T11:10:01+08:00][sql] CONNECT:[ UseTime:0.032035s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022153s ] [2021-05-20T11:20:01+08:00][sql] CONNECT:[ UseTime:0.035857s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024676s ] [2021-05-20T11:30:01+08:00][sql] CONNECT:[ UseTime:0.030507s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021428s ] [2021-05-20T11:40:02+08:00][sql] CONNECT:[ UseTime:0.031342s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021809s ] [2021-05-20T11:50:02+08:00][sql] CONNECT:[ UseTime:0.031278s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T11:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022351s ] [2021-05-20T12:00:02+08:00][sql] CONNECT:[ UseTime:0.036571s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T12:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022988s ] [2021-05-20T12:10:02+08:00][sql] CONNECT:[ UseTime:0.033987s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T12:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024911s ] [2021-05-20T12:20:02+08:00][sql] CONNECT:[ UseTime:0.030709s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T12:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024799s ] [2021-05-20T12:30:02+08:00][sql] CONNECT:[ UseTime:0.032897s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T12:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022991s ] [2021-05-20T12:40:02+08:00][sql] CONNECT:[ UseTime:0.034054s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T12:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023623s ] [2021-05-20T12:50:02+08:00][sql] CONNECT:[ UseTime:0.033003s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T12:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022678s ] [2021-05-20T13:00:01+08:00][sql] CONNECT:[ UseTime:0.031236s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021445s ] [2021-05-20T13:10:01+08:00][sql] CONNECT:[ UseTime:0.029991s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021521s ] [2021-05-20T13:20:01+08:00][sql] CONNECT:[ UseTime:0.033418s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022830s ] [2021-05-20T13:20:56+08:00][sql] CONNECT:[ UseTime:0.030032s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:20:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023251s ] [2021-05-20T13:20:56+08:00][DEBUG] [ 2021-05-20T13:20:56+08:00 ] function | invalidSession | jwt expire! [2021-05-20T13:20:59+08:00][sql] CONNECT:[ UseTime:0.032822s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:20:59+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023044s ] [2021-05-20T13:20:59+08:00][DEBUG] [ 2021-05-20T13:20:59+08:00 ] function | invalidSession | jwt expire! [2021-05-20T13:21:00+08:00][sql] CONNECT:[ UseTime:0.029880s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:21:00+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021021s ] [2021-05-20T13:21:00+08:00][DEBUG] [ 2021-05-20T13:21:00+08:00 ] function | invalidSession | jwt expire! [2021-05-20T13:21:01+08:00][sql] CONNECT:[ UseTime:0.030198s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:21:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021177s ] [2021-05-20T13:21:01+08:00][DEBUG] [ 2021-05-20T13:21:01+08:00 ] function | invalidSession | jwt expire! [2021-05-20T13:26:33+08:00][sql] CONNECT:[ UseTime:0.032770s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:26:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023565s ] [2021-05-20T13:26:33+08:00][DEBUG] [ 2021-05-20T13:26:33+08:00 ] function | invalidSession | jwt expire! [2021-05-20T13:26:33+08:00][sql] CONNECT:[ UseTime:0.031118s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:26:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021723s ] [2021-05-20T13:26:33+08:00][DEBUG] [ 2021-05-20T13:26:33+08:00 ] function | invalidSession | jwt expire! [2021-05-20T13:26:35+08:00][sql] CONNECT:[ UseTime:0.030725s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:26:35+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021231s ] [2021-05-20T13:26:35+08:00][DEBUG] [ 2021-05-20T13:26:35+08:00 ] function | invalidSession | jwt expire! [2021-05-20T13:26:36+08:00][sql] CONNECT:[ UseTime:0.032212s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:26:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022318s ] [2021-05-20T13:26:36+08:00][DEBUG] [ 2021-05-20T13:26:36+08:00 ] function | invalidSession | jwt expire! [2021-05-20T13:26:49+08:00][sql] CONNECT:[ UseTime:0.031354s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:26:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021363s ] [2021-05-20T13:26:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021058s ] [2021-05-20T13:26:49+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` = '13738665238' LIMIT 1 [ RunTime:0.022711s ] [2021-05-20T13:26:49+08:00][DEBUG] [ 2021-05-20T13:26:49+08:00 ] rediskey13738665238_signin_verify [2021-05-20T13:27:13+08:00][sql] CONNECT:[ UseTime:0.030782s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:27:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020585s ] [2021-05-20T13:27:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021434s ] [2021-05-20T13:27:13+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081100023' AND `status` = '上线' LIMIT 1 [ RunTime:0.025257s ] [2021-05-20T13:27:13+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 4882 LIMIT 1 [ RunTime:0.020548s ] [2021-05-20T13:27:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.020087s ] [2021-05-20T13:27:13+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '3b685d4aab964bfc866650da2b4fe091' LIMIT 1 [ RunTime:0.021006s ] [2021-05-20T13:27:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.021632s ] [2021-05-20T13:27:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 4882 [ RunTime:0.020513s ] [2021-05-20T13:27:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019321s ] [2021-05-20T13:27:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 4882 AND `uuid` = 'e90bb95db183432081aac1401bdf4d10' [ RunTime:0.019111s ] [2021-05-20T13:27:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019473s ] [2021-05-20T13:27:13+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='e90bb95db183432081aac1401bdf4d10' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=4882 ) ORDER BY `c`.`id` DESC [ RunTime:0.021719s ] [2021-05-20T13:27:13+08:00][DEBUG] [ 2021-05-20T13:27:13+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='e90bb95db183432081aac1401bdf4d10' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=4882 ) ORDER BY `c`.`id` DESC [2021-05-20T13:27:20+08:00][sql] CONNECT:[ UseTime:0.032407s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:27:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022498s ] [2021-05-20T13:27:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022232s ] [2021-05-20T13:27:20+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 4914 LIMIT 1 [ RunTime:0.021572s ] [2021-05-20T13:27:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.021815s ] [2021-05-20T13:27:20+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '3b685d4aab964bfc866650da2b4fe091' LIMIT 1 [ RunTime:0.021262s ] [2021-05-20T13:27:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.021727s ] [2021-05-20T13:27:20+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 4914 [ RunTime:0.237466s ] [2021-05-20T13:27:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.055849s ] [2021-05-20T13:27:20+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 4914 AND `consult_id` = 5154 [ RunTime:0.021370s ] [2021-05-20T13:27:20+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 4914 AND `consult_id` = 5155 [ RunTime:0.021276s ] [2021-05-20T13:27:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.021741s ] [2021-05-20T13:27:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 4914 [ RunTime:0.022312s ] [2021-05-20T13:27:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.021927s ] [2021-05-20T13:27:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 4914 AND `uuid` = 'e90bb95db183432081aac1401bdf4d10' [ RunTime:0.021264s ] [2021-05-20T13:27:20+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.021662s ] [2021-05-20T13:27:20+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='e90bb95db183432081aac1401bdf4d10' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=4914 ) ORDER BY `c`.`id` DESC [ RunTime:0.021649s ] [2021-05-20T13:27:20+08:00][DEBUG] [ 2021-05-20T13:27:20+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='e90bb95db183432081aac1401bdf4d10' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=4914 ) ORDER BY `c`.`id` DESC [2021-05-20T13:30:01+08:00][sql] CONNECT:[ UseTime:0.032925s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022912s ] [2021-05-20T13:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.022347s ] [2021-05-20T13:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'e90bb95db183432081aac1401bdf4d10' , `c_id` = 153 , `ctime` = '2021-05-20 13:27:13' [ RunTime:0.022479s ] [2021-05-20T13:30:01+08:00][DEBUG] [ 2021-05-20T13:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'e90bb95db183432081aac1401bdf4d10' , `c_id` = 153 , `ctime` = '2021-05-20 13:27:13' [2021-05-20T13:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'e90bb95db183432081aac1401bdf4d10' , `c_id` = 4914 , `ctime` = '2021-05-20 13:27:20' [ RunTime:0.021359s ] [2021-05-20T13:30:01+08:00][DEBUG] [ 2021-05-20T13:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'e90bb95db183432081aac1401bdf4d10' , `c_id` = 4914 , `ctime` = '2021-05-20 13:27:20' [2021-05-20T13:40:01+08:00][sql] CONNECT:[ UseTime:0.030735s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021406s ] [2021-05-20T13:50:01+08:00][sql] CONNECT:[ UseTime:0.029800s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020671s ] [2021-05-20T13:50:54+08:00][sql] CONNECT:[ UseTime:0.030914s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:50:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022337s ] [2021-05-20T13:50:54+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 12082 LIMIT 1 [ RunTime:0.019897s ] [2021-05-20T13:50:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.020311s ] [2021-05-20T13:50:54+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '21b6da80a087406f8b740a28851a49f5' LIMIT 1 [ RunTime:0.020060s ] [2021-05-20T13:50:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.020200s ] [2021-05-20T13:50:54+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 12082 [ RunTime:0.024430s ] [2021-05-20T13:50:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.020219s ] [2021-05-20T13:50:54+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12082 AND `consult_id` = 13369 [ RunTime:0.019862s ] [2021-05-20T13:50:54+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12082 AND `consult_id` = 13370 [ RunTime:0.019928s ] [2021-05-20T13:50:54+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12082 AND `consult_id` = 13371 [ RunTime:0.020276s ] [2021-05-20T13:50:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020249s ] [2021-05-20T13:50:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 12082 [ RunTime:0.020989s ] [2021-05-20T13:50:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.020101s ] [2021-05-20T13:50:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 12082 AND `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' [ RunTime:0.019856s ] [2021-05-20T13:50:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.020199s ] [2021-05-20T13:50:54+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12082 ) ORDER BY `c`.`id` DESC [ RunTime:0.020852s ] [2021-05-20T13:50:54+08:00][DEBUG] [ 2021-05-20T13:50:54+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12082 ) ORDER BY `c`.`id` DESC [2021-05-20T13:51:11+08:00][sql] CONNECT:[ UseTime:0.029464s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:51:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021231s ] [2021-05-20T13:51:11+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 12080 LIMIT 1 [ RunTime:0.019005s ] [2021-05-20T13:51:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019206s ] [2021-05-20T13:51:11+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '21b6da80a087406f8b740a28851a49f5' LIMIT 1 [ RunTime:0.021747s ] [2021-05-20T13:51:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.019137s ] [2021-05-20T13:51:11+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 12080 [ RunTime:0.023357s ] [2021-05-20T13:51:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.019202s ] [2021-05-20T13:51:11+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12080 AND `consult_id` = 12628 [ RunTime:0.018853s ] [2021-05-20T13:51:11+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12080 AND `consult_id` = 12629 [ RunTime:0.018764s ] [2021-05-20T13:51:11+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12080 AND `consult_id` = 12630 [ RunTime:0.018810s ] [2021-05-20T13:51:11+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12080 AND `consult_id` = 12631 [ RunTime:0.018932s ] [2021-05-20T13:51:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019018s ] [2021-05-20T13:51:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 12080 [ RunTime:0.019925s ] [2021-05-20T13:51:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019091s ] [2021-05-20T13:51:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 12080 AND `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' [ RunTime:0.018726s ] [2021-05-20T13:51:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019133s ] [2021-05-20T13:51:11+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12080 ) ORDER BY `c`.`id` DESC [ RunTime:0.018951s ] [2021-05-20T13:51:11+08:00][DEBUG] [ 2021-05-20T13:51:11+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12080 ) ORDER BY `c`.`id` DESC [2021-05-20T13:51:23+08:00][sql] CONNECT:[ UseTime:0.030803s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:51:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022023s ] [2021-05-20T13:51:23+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 12076 LIMIT 1 [ RunTime:0.020149s ] [2021-05-20T13:51:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.021177s ] [2021-05-20T13:51:23+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '21b6da80a087406f8b740a28851a49f5' LIMIT 1 [ RunTime:0.019740s ] [2021-05-20T13:51:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.020260s ] [2021-05-20T13:51:23+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 12076 [ RunTime:0.024920s ] [2021-05-20T13:51:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.020356s ] [2021-05-20T13:51:23+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12076 AND `consult_id` = 12600 [ RunTime:0.019887s ] [2021-05-20T13:51:23+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12076 AND `consult_id` = 12601 [ RunTime:0.019849s ] [2021-05-20T13:51:23+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 12076 AND `consult_id` = 12602 [ RunTime:0.019929s ] [2021-05-20T13:51:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020164s ] [2021-05-20T13:51:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 12076 [ RunTime:0.020993s ] [2021-05-20T13:51:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.020192s ] [2021-05-20T13:51:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 12076 AND `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' [ RunTime:0.019875s ] [2021-05-20T13:51:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.020290s ] [2021-05-20T13:51:23+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12076 ) ORDER BY `c`.`id` DESC [ RunTime:0.020127s ] [2021-05-20T13:51:23+08:00][DEBUG] [ 2021-05-20T13:51:23+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12076 ) ORDER BY `c`.`id` DESC [2021-05-20T13:51:37+08:00][sql] CONNECT:[ UseTime:0.029558s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:51:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020949s ] [2021-05-20T13:51:37+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 12084 LIMIT 1 [ RunTime:0.019087s ] [2021-05-20T13:51:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019647s ] [2021-05-20T13:51:37+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '21b6da80a087406f8b740a28851a49f5' LIMIT 1 [ RunTime:0.018921s ] [2021-05-20T13:51:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020863s ] [2021-05-20T13:51:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 12084 [ RunTime:0.021237s ] [2021-05-20T13:51:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019237s ] [2021-05-20T13:51:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 12084 AND `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' [ RunTime:0.018978s ] [2021-05-20T13:51:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019423s ] [2021-05-20T13:51:37+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12084 ) ORDER BY `c`.`id` DESC [ RunTime:0.019476s ] [2021-05-20T13:51:37+08:00][DEBUG] [ 2021-05-20T13:51:37+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12084 ) ORDER BY `c`.`id` DESC [2021-05-20T13:51:52+08:00][sql] CONNECT:[ UseTime:0.028553s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T13:51:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020752s ] [2021-05-20T13:51:52+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 12083 LIMIT 1 [ RunTime:0.018921s ] [2021-05-20T13:51:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019160s ] [2021-05-20T13:51:52+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '21b6da80a087406f8b740a28851a49f5' LIMIT 1 [ RunTime:0.018607s ] [2021-05-20T13:51:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018823s ] [2021-05-20T13:51:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 12083 [ RunTime:0.019751s ] [2021-05-20T13:51:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018967s ] [2021-05-20T13:51:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 12083 AND `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' [ RunTime:0.018519s ] [2021-05-20T13:51:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019033s ] [2021-05-20T13:51:52+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12083 ) ORDER BY `c`.`id` DESC [ RunTime:0.018826s ] [2021-05-20T13:51:52+08:00][DEBUG] [ 2021-05-20T13:51:52+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='fd2c7e1fc9a0403aabab8dd735ada933' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=12083 ) ORDER BY `c`.`id` DESC [2021-05-20T14:00:01+08:00][sql] CONNECT:[ UseTime:0.030408s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021165s ] [2021-05-20T14:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020525s ] [2021-05-20T14:00:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12082 , `ctime` = '2021-05-20 13:50:54' [ RunTime:0.020101s ] [2021-05-20T14:00:01+08:00][DEBUG] [ 2021-05-20T14:00:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12082 , `ctime` = '2021-05-20 13:50:54' [2021-05-20T14:00:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12080 , `ctime` = '2021-05-20 13:51:11' [ RunTime:0.019802s ] [2021-05-20T14:00:01+08:00][DEBUG] [ 2021-05-20T14:00:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12080 , `ctime` = '2021-05-20 13:51:11' [2021-05-20T14:00:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12076 , `ctime` = '2021-05-20 13:51:23' [ RunTime:0.019808s ] [2021-05-20T14:00:01+08:00][DEBUG] [ 2021-05-20T14:00:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12076 , `ctime` = '2021-05-20 13:51:23' [2021-05-20T14:00:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12084 , `ctime` = '2021-05-20 13:51:36' [ RunTime:0.019885s ] [2021-05-20T14:00:01+08:00][DEBUG] [ 2021-05-20T14:00:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12084 , `ctime` = '2021-05-20 13:51:36' [2021-05-20T14:00:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12083 , `ctime` = '2021-05-20 13:51:51' [ RunTime:0.020086s ] [2021-05-20T14:00:01+08:00][DEBUG] [ 2021-05-20T14:00:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12083 , `ctime` = '2021-05-20 13:51:51' [2021-05-20T14:08:57+08:00][sql] CONNECT:[ UseTime:0.031866s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:08:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021811s ] [2021-05-20T14:08:57+08:00][DEBUG] [ 2021-05-20T14:08:57+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:09:01+08:00][DEBUG] [ 2021-05-20T14:09:01+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:09:06+08:00][DEBUG] [ 2021-05-20T14:09:06+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:09:24+08:00][DEBUG] [ 2021-05-20T14:09:24+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:10:01+08:00][sql] CONNECT:[ UseTime:0.031747s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021496s ] [2021-05-20T14:11:07+08:00][DEBUG] [ 2021-05-20T14:11:07+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:11:11+08:00][DEBUG] [ 2021-05-20T14:11:11+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:11:12+08:00][DEBUG] [ 2021-05-20T14:11:12+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:11:14+08:00][DEBUG] [ 2021-05-20T14:11:14+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:11:16+08:00][DEBUG] [ 2021-05-20T14:11:16+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:11:17+08:00][DEBUG] [ 2021-05-20T14:11:17+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:12:57+08:00][DEBUG] [ 2021-05-20T14:12:57+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:14:11+08:00][sql] CONNECT:[ UseTime:0.031313s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:14:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022057s ] [2021-05-20T14:14:11+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` = '15757554068' LIMIT 1 [ RunTime:0.023070s ] [2021-05-20T14:14:11+08:00][DEBUG] [ 2021-05-20T14:14:11+08:00 ] rediskey15757554068_signin_verify [2021-05-20T14:15:34+08:00][sql] CONNECT:[ UseTime:0.034316s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:15:34+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.035796s ] [2021-05-20T14:15: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` = '15757554068' LIMIT 1 [ RunTime:0.024773s ] [2021-05-20T14:15:34+08:00][DEBUG] [ 2021-05-20T14:15:34+08:00 ] rediskey15757554068_signin_verify [2021-05-20T14:15:34+08:00][DEBUG] [ 2021-05-20T14:15:34+08:00 ] session11 [2021-05-20T14:15:34+08:00][WARN] [ 2021-05-20T14:15:34+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-05-20T14:16:07+08:00][sql] CONNECT:[ UseTime:0.030395s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:16:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021654s ] [2021-05-20T14:16:07+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` = '15757554068' LIMIT 1 [ RunTime:0.019716s ] [2021-05-20T14:16:07+08:00][DEBUG] [ 2021-05-20T14:16:07+08:00 ] rediskey15757554068_signin_verify [2021-05-20T14:20:01+08:00][sql] CONNECT:[ UseTime:0.034379s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023732s ] [2021-05-20T14:24:25+08:00][DEBUG] [ 2021-05-20T14:24:25+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-05-20T14:24:35+08:00][DEBUG] [ 2021-05-20T14:24:35+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-05-20T14:30:01+08:00][sql] CONNECT:[ UseTime:0.031937s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021831s ] [2021-05-20T14:31:37+08:00][sql] CONNECT:[ UseTime:0.030133s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:31:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020945s ] [2021-05-20T14:31:37+08:00][DEBUG] [ 2021-05-20T14:31:37+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:32:35+08:00][sql] CONNECT:[ UseTime:0.032682s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:32:35+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.023150s ] [2021-05-20T14:32:35+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` = '13906866793' LIMIT 1 [ RunTime:0.024014s ] [2021-05-20T14:32:35+08:00][DEBUG] [ 2021-05-20T14:32:35+08:00 ] rediskey13906866793_signin_verify [2021-05-20T14:33:08+08:00][sql] CONNECT:[ UseTime:0.035638s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:33:08+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.024977s ] [2021-05-20T14:33:08+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` = '13906866793' LIMIT 1 [ RunTime:0.025478s ] [2021-05-20T14:33:08+08:00][DEBUG] [ 2021-05-20T14:33:08+08:00 ] rediskey13906866793_signin_verify [2021-05-20T14:33:08+08:00][DEBUG] [ 2021-05-20T14:33:08+08:00 ] session11 [2021-05-20T14:33:08+08:00][WARN] [ 2021-05-20T14:33:08+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-05-20T14:40:01+08:00][sql] CONNECT:[ UseTime:0.031056s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021502s ] [2021-05-20T14:50:02+08:00][sql] CONNECT:[ UseTime:0.029336s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020213s ] [2021-05-20T14:58:10+08:00][sql] CONNECT:[ UseTime:0.029937s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:58:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023581s ] [2021-05-20T14:58:10+08:00][DEBUG] [ 2021-05-20T14:58:10+08:00 ] function | invalidSession | jwt expire! [2021-05-20T14:59:34+08:00][sql] CONNECT:[ UseTime:0.029903s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T14:59:34+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021163s ] [2021-05-20T14:59: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` = '13858685865' LIMIT 1 [ RunTime:0.021697s ] [2021-05-20T14:59:34+08:00][DEBUG] [ 2021-05-20T14:59:34+08:00 ] rediskey13858685865_signin_verify [2021-05-20T15:00:02+08:00][sql] CONNECT:[ UseTime:0.031807s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021758s ] [2021-05-20T15:02:57+08:00][sql] CONNECT:[ UseTime:0.032925s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:02:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021002s ] [2021-05-20T15:02:57+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` = '13858685865' LIMIT 1 [ RunTime:0.022130s ] [2021-05-20T15:02:57+08:00][DEBUG] [ 2021-05-20T15:02:57+08:00 ] rediskey13858685865_signin_verify [2021-05-20T15:02:57+08:00][DEBUG] [ 2021-05-20T15:02:57+08:00 ] session11 [2021-05-20T15:02:57+08:00][WARN] [ 2021-05-20T15:02:57+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-05-20T15:07:43+08:00][DEBUG] [ 2021-05-20T15:07:43+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-05-20T15:08:21+08:00][DEBUG] [ 2021-05-20T15:08:21+08:00 ] Controller : MiniProgramInterface | findPassword | newPwd weak [2021-05-20T15:08:42+08:00][DEBUG] [ 2021-05-20T15:08:42+08:00 ] rediskey13805861888_id_verify [2021-05-20T15:08:42+08:00][DEBUG] [ 2021-05-20T15:08:42+08:00 ] session11 [2021-05-20T15:08:42+08:00][DEBUG] [ 2021-05-20T15:08:42+08:00 ] Controller : MiniProgramInterface | findPassword | code error [2021-05-20T15:09:01+08:00][sql] CONNECT:[ UseTime:0.029728s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.032696s ] [2021-05-20T15:09:01+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.020818s ] [2021-05-20T15:09:01+08:00][DEBUG] [ 2021-05-20T15:09:01+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:06+08:00][sql] CONNECT:[ UseTime:0.031051s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:06+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022154s ] [2021-05-20T15:09:06+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.019794s ] [2021-05-20T15:09:06+08:00][DEBUG] [ 2021-05-20T15:09:06+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:08+08:00][sql] CONNECT:[ UseTime:0.030848s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:08+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021624s ] [2021-05-20T15:09:08+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.019360s ] [2021-05-20T15:09:08+08:00][DEBUG] [ 2021-05-20T15:09:08+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:09+08:00][sql] CONNECT:[ UseTime:0.030119s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021286s ] [2021-05-20T15:09:09+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.019343s ] [2021-05-20T15:09:09+08:00][DEBUG] [ 2021-05-20T15:09:09+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:09+08:00][sql] CONNECT:[ UseTime:0.029282s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020532s ] [2021-05-20T15:09:09+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.018420s ] [2021-05-20T15:09:09+08:00][DEBUG] [ 2021-05-20T15:09:09+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:22+08:00][sql] CONNECT:[ UseTime:0.033577s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:22+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.023725s ] [2021-05-20T15:09:22+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.021792s ] [2021-05-20T15:09:22+08:00][DEBUG] [ 2021-05-20T15:09:22+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:27+08:00][DEBUG] [ 2021-05-20T15:09:27+08:00 ] rediskey13805861888_id_verify [2021-05-20T15:09:27+08:00][DEBUG] [ 2021-05-20T15:09:27+08:00 ] session11 [2021-05-20T15:09:27+08:00][DEBUG] [ 2021-05-20T15:09:27+08:00 ] Controller : MiniProgramInterface | findPassword | code error [2021-05-20T15:09:29+08:00][sql] CONNECT:[ UseTime:0.031374s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:29+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022393s ] [2021-05-20T15:09:29+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.020132s ] [2021-05-20T15:09:29+08:00][DEBUG] [ 2021-05-20T15:09:29+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:30+08:00][sql] CONNECT:[ UseTime:0.046925s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.024694s ] [2021-05-20T15:09:30+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.022563s ] [2021-05-20T15:09:30+08:00][DEBUG] [ 2021-05-20T15:09:30+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:31+08:00][sql] CONNECT:[ UseTime:0.030134s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:31+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021231s ] [2021-05-20T15:09:31+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.019198s ] [2021-05-20T15:09:31+08:00][DEBUG] [ 2021-05-20T15:09:31+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:31+08:00][sql] CONNECT:[ UseTime:0.030885s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:31+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021668s ] [2021-05-20T15:09:31+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.019767s ] [2021-05-20T15:09:31+08:00][DEBUG] [ 2021-05-20T15:09:31+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:36+08:00][sql] CONNECT:[ UseTime:0.032322s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022792s ] [2021-05-20T15:09:36+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.020673s ] [2021-05-20T15:09:36+08:00][DEBUG] [ 2021-05-20T15:09:36+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:37+08:00][sql] CONNECT:[ UseTime:0.035430s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.025010s ] [2021-05-20T15:09:37+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.022826s ] [2021-05-20T15:09:37+08:00][DEBUG] [ 2021-05-20T15:09:37+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:37+08:00][sql] CONNECT:[ UseTime:0.029836s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021477s ] [2021-05-20T15:09:37+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.019216s ] [2021-05-20T15:09:37+08:00][DEBUG] [ 2021-05-20T15:09:37+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:37+08:00][sql] CONNECT:[ UseTime:0.033154s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021846s ] [2021-05-20T15:09:37+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.019851s ] [2021-05-20T15:09:37+08:00][DEBUG] [ 2021-05-20T15:09:37+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:37+08:00][sql] CONNECT:[ UseTime:0.035006s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.024605s ] [2021-05-20T15:09:37+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.022541s ] [2021-05-20T15:09:37+08:00][DEBUG] [ 2021-05-20T15:09:37+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:38+08:00][sql] CONNECT:[ UseTime:0.035326s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:38+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.024552s ] [2021-05-20T15:09:38+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.022558s ] [2021-05-20T15:09:38+08:00][DEBUG] [ 2021-05-20T15:09:38+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-05-20T15:09:45+08:00][sql] CONNECT:[ UseTime:0.036902s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:45+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.024123s ] [2021-05-20T15:09:45+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13805861888' ) LIMIT 1 [ RunTime:0.022181s ] [2021-05-20T15:09:45+08:00][DEBUG] [ 2021-05-20T15:09:45+08:00 ] Event: SendMessage | sendSMS | ret code = isv.BUSINESS_LIMIT_CONTROL | msg = 触发分钟级流控Permits:1 [2021-05-20T15:09:56+08:00][sql] CONNECT:[ UseTime:0.029527s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:09:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021350s ] [2021-05-20T15:09:56+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` = '13805861888' LIMIT 1 [ RunTime:0.021200s ] [2021-05-20T15:09:56+08:00][DEBUG] [ 2021-05-20T15:09:56+08:00 ] rediskey13805861888_signin_verify [2021-05-20T15:10:02+08:00][sql] CONNECT:[ UseTime:0.033830s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023493s ] [2021-05-20T15:10:22+08:00][sql] CONNECT:[ UseTime:0.029318s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:10:22+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020937s ] [2021-05-20T15:10:22+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` = '13805861888' LIMIT 1 [ RunTime:0.022260s ] [2021-05-20T15:10:22+08:00][DEBUG] [ 2021-05-20T15:10:22+08:00 ] rediskey13805861888_signin_verify [2021-05-20T15:10:22+08:00][DEBUG] [ 2021-05-20T15:10:22+08:00 ] session11 [2021-05-20T15:10:22+08:00][WARN] [ 2021-05-20T15:10:22+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-05-20T15:11:18+08:00][DEBUG] [ 2021-05-20T15:11:18+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-05-20T15:11:58+08:00][sql] CONNECT:[ UseTime:0.029405s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:11:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020728s ] [2021-05-20T15:11:58+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` = '13867644148' LIMIT 1 [ RunTime:0.021795s ] [2021-05-20T15:11:58+08:00][DEBUG] [ 2021-05-20T15:11:58+08:00 ] rediskey13867644148_signin_verify [2021-05-20T15:15:00+08:00][DEBUG] [ 2021-05-20T15:15:00+08:00 ] rediskey13805861888_id_verify [2021-05-20T15:16:03+08:00][DEBUG] [ 2021-05-20T15:16:03+08:00 ] rediskey13805861888_id_verify [2021-05-20T15:16:03+08:00][DEBUG] [ 2021-05-20T15:16:03+08:00 ] session11 [2021-05-20T15:16:03+08:00][DEBUG] [ 2021-05-20T15:16:03+08:00 ] Controller : MiniProgramInterface | findPassword | code error [2021-05-20T15:19:35+08:00][sql] CONNECT:[ UseTime:0.033927s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:19:35+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024329s ] [2021-05-20T15:19:35+08:00][DEBUG] [ 2021-05-20T15:19:35+08:00 ] function | invalidSession | jwt expire! [2021-05-20T15:19:38+08:00][DEBUG] [ 2021-05-20T15:19:38+08:00 ] function | invalidSession | jwt expire! [2021-05-20T15:19:51+08:00][DEBUG] [ 2021-05-20T15:19:51+08:00 ] function | invalidSession | jwt expire! [2021-05-20T15:19:52+08:00][DEBUG] [ 2021-05-20T15:19:52+08:00 ] function | invalidSession | jwt expire! [2021-05-20T15:19:54+08:00][DEBUG] [ 2021-05-20T15:19:54+08:00 ] function | invalidSession | jwt expire! [2021-05-20T15:20:01+08:00][DEBUG] [ 2021-05-20T15:20:01+08:00 ] function | invalidSession | jwt expire! [2021-05-20T15:20:02+08:00][sql] CONNECT:[ UseTime:0.031426s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022695s ] [2021-05-20T15:20:07+08:00][DEBUG] [ 2021-05-20T15:20:07+08:00 ] function | invalidSession | jwt expire! [2021-05-20T15:21:01+08:00][sql] CONNECT:[ UseTime:0.031070s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:21:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022218s ] [2021-05-20T15:21:01+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` = '13606678521' LIMIT 1 [ RunTime:0.024565s ] [2021-05-20T15:21:01+08:00][DEBUG] [ 2021-05-20T15:21:01+08:00 ] rediskey13606678521_signin_verify [2021-05-20T15:30:01+08:00][sql] CONNECT:[ UseTime:0.032805s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022939s ] [2021-05-20T15:40:01+08:00][sql] CONNECT:[ UseTime:0.035463s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024243s ] [2021-05-20T15:50:01+08:00][sql] CONNECT:[ UseTime:0.033965s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T15:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023651s ] [2021-05-20T16:00:01+08:00][sql] CONNECT:[ UseTime:0.030916s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T16:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021175s ] [2021-05-20T16:10:01+08:00][sql] CONNECT:[ UseTime:0.030795s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T16:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021418s ] [2021-05-20T16:20:01+08:00][sql] CONNECT:[ UseTime:0.034079s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T16:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023532s ] [2021-05-20T16:30:01+08:00][sql] CONNECT:[ UseTime:0.033679s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T16:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022469s ] [2021-05-20T16:40:01+08:00][sql] CONNECT:[ UseTime:0.031677s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T16:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021955s ] [2021-05-20T16:50:02+08:00][sql] CONNECT:[ UseTime:0.030501s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T16:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021451s ] [2021-05-20T17:00:02+08:00][sql] CONNECT:[ UseTime:0.029626s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T17:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020616s ] [2021-05-20T17:10:02+08:00][sql] CONNECT:[ UseTime:0.029961s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T17:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020759s ] [2021-05-20T17:20:02+08:00][sql] CONNECT:[ UseTime:0.030448s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T17:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021271s ] [2021-05-20T17:30:01+08:00][sql] CONNECT:[ UseTime:0.032191s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T17:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022618s ] [2021-05-20T17:40:01+08:00][sql] CONNECT:[ UseTime:0.030042s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T17:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020856s ] [2021-05-20T17:50:01+08:00][sql] CONNECT:[ UseTime:0.035234s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T17:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024162s ] [2021-05-20T18:00:01+08:00][sql] CONNECT:[ UseTime:0.032113s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T18:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021993s ] [2021-05-20T18:10:01+08:00][sql] CONNECT:[ UseTime:0.029949s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T18:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020675s ] [2021-05-20T18:20:01+08:00][sql] CONNECT:[ UseTime:0.032853s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T18:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022851s ] [2021-05-20T18:30:02+08:00][sql] CONNECT:[ UseTime:0.030113s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T18:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020821s ] [2021-05-20T18:40:02+08:00][sql] CONNECT:[ UseTime:0.034170s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T18:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023862s ] [2021-05-20T18:50:02+08:00][sql] CONNECT:[ UseTime:0.032346s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T18:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022318s ] [2021-05-20T19:00:01+08:00][sql] CONNECT:[ UseTime:0.031935s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021265s ] [2021-05-20T19:02:38+08:00][DEBUG] [ 2021-05-20T19:02:38+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-05-20T19:03:39+08:00][sql] CONNECT:[ UseTime:0.031194s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:03:39+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.023253s ] [2021-05-20T19:03:39+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` = '13957687041' LIMIT 1 [ RunTime:0.022763s ] [2021-05-20T19:03:39+08:00][DEBUG] [ 2021-05-20T19:03:39+08:00 ] rediskey13957687041_signin_verify [2021-05-20T19:10:01+08:00][sql] CONNECT:[ UseTime:0.030821s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021310s ] [2021-05-20T19:20:01+08:00][sql] CONNECT:[ UseTime:0.032480s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022490s ] [2021-05-20T19:25:12+08:00][DEBUG] [ 2021-05-20T19:25:12+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-05-20T19:25:42+08:00][DEBUG] [ 2021-05-20T19:25:42+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-05-20T19:26:13+08:00][sql] CONNECT:[ UseTime:0.031525s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:26:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022528s ] [2021-05-20T19:26:13+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` = '13958649789' LIMIT 1 [ RunTime:0.023612s ] [2021-05-20T19:26:13+08:00][DEBUG] [ 2021-05-20T19:26:13+08:00 ] rediskey13958649789_signin_verify [2021-05-20T19:30:01+08:00][sql] CONNECT:[ UseTime:0.030134s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020715s ] [2021-05-20T19:40:01+08:00][sql] CONNECT:[ UseTime:0.031305s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021265s ] [2021-05-20T19:40:57+08:00][sql] CONNECT:[ UseTime:0.030335s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:40:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020877s ] [2021-05-20T19:40:57+08:00][sql] INSERT INTO `swgk_ua` SET `ua` = 'Mozilla/5.0 (Linux; Android 10; PBCM10 Build/QKQ1.191224.003; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/78.0.3904.62 XWEB/2796 MMWEBSDK/20210302 Mobile Safari/537.36 MMWEBID/3637 MicroMessenger/8.0.3.1880(0x28000338) Process/appbrand0 WeChat/arm32 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android' , `signs` = '3ead770171a56e4b19b9213ac07bba15' [ RunTime:0.021234s ] [2021-05-20T19:40:57+08:00][DEBUG] [ 2021-05-20T19:40:57+08:00 ] function | invalidSession | jwt expire! [2021-05-20T19:41:08+08:00][DEBUG] [ 2021-05-20T19:41:08+08:00 ] function | invalidSession | jwt expire! [2021-05-20T19:41:55+08:00][sql] CONNECT:[ UseTime:0.029995s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:41:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021123s ] [2021-05-20T19:41:55+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='17757652566' ) LIMIT 1 [ RunTime:0.019413s ] [2021-05-20T19:41:55+08:00][DEBUG] [ 2021-05-20T19:41:55+08:00 ] Event: SendMessage | sendSMS | ret code = isv.BUSINESS_LIMIT_CONTROL | msg = 触发分钟级流控Permits:1 [2021-05-20T19:41:57+08:00][sql] CONNECT:[ UseTime:0.030781s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:41:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022202s ] [2021-05-20T19:41:57+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` = '17757652566' LIMIT 1 [ RunTime:0.023531s ] [2021-05-20T19:41:57+08:00][DEBUG] [ 2021-05-20T19:41:57+08:00 ] rediskey17757652566_signin_verify [2021-05-20T19:42:06+08:00][sql] CONNECT:[ UseTime:0.031669s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:42:06+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022692s ] [2021-05-20T19:42:06+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` = '17757652566' LIMIT 1 [ RunTime:0.023478s ] [2021-05-20T19:42:06+08:00][DEBUG] [ 2021-05-20T19:42:06+08:00 ] rediskey17757652566_signin_verify [2021-05-20T19:42:06+08:00][DEBUG] [ 2021-05-20T19:42:06+08:00 ] session11 [2021-05-20T19:42:06+08:00][WARN] [ 2021-05-20T19:42:06+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-05-20T19:42:14+08:00][sql] CONNECT:[ UseTime:0.030759s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:42:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021014s ] [2021-05-20T19:42:14+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='17757652566' ) LIMIT 1 [ RunTime:0.019119s ] [2021-05-20T19:42:14+08:00][DEBUG] [ 2021-05-20T19:42:14+08:00 ] Event: SendMessage | sendSMS | ret code = isv.BUSINESS_LIMIT_CONTROL | msg = 触发分钟级流控Permits:1 [2021-05-20T19:42:17+08:00][sql] CONNECT:[ UseTime:0.028734s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:42:17+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020325s ] [2021-05-20T19:42: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` = '17757652566' LIMIT 1 [ RunTime:0.018657s ] [2021-05-20T19:42:17+08:00][DEBUG] [ 2021-05-20T19:42:17+08:00 ] rediskey17757652566_signin_verify [2021-05-20T19:42:17+08:00][DEBUG] [ 2021-05-20T19:42:17+08:00 ] Event: SMS | checkSMSCode | APP_SMS_CODE_EXPIRE error = |1621510933| [2021-05-20T19:42:17+08:00][WARN] [ 2021-05-20T19:42:17+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-05-20T19:50:01+08:00][sql] CONNECT:[ UseTime:0.031042s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T19:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021564s ] [2021-05-20T20:00:02+08:00][sql] CONNECT:[ UseTime:0.031145s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T20:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021489s ] [2021-05-20T20:10:02+08:00][sql] CONNECT:[ UseTime:0.030546s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T20:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020848s ] [2021-05-20T20:20:02+08:00][sql] CONNECT:[ UseTime:0.030304s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T20:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021191s ] [2021-05-20T20:30:01+08:00][sql] CONNECT:[ UseTime:0.032833s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T20:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021625s ] [2021-05-20T20:40:01+08:00][sql] CONNECT:[ UseTime:0.034237s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T20:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023553s ] [2021-05-20T20:50:01+08:00][sql] CONNECT:[ UseTime:0.032202s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T20:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021855s ] [2021-05-20T21:00:01+08:00][sql] CONNECT:[ UseTime:0.033962s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T21:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023324s ] [2021-05-20T21:10:01+08:00][sql] CONNECT:[ UseTime:0.032968s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T21:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022907s ] [2021-05-20T21:20:01+08:00][sql] CONNECT:[ UseTime:0.033708s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T21:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023261s ] [2021-05-20T21:30:02+08:00][sql] CONNECT:[ UseTime:0.035911s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T21:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024520s ] [2021-05-20T21:40:02+08:00][sql] CONNECT:[ UseTime:0.032634s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T21:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022139s ] [2021-05-20T21:50:02+08:00][sql] CONNECT:[ UseTime:0.032753s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T21:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021977s ] [2021-05-20T22:00:01+08:00][sql] CONNECT:[ UseTime:0.031205s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021315s ] [2021-05-20T22:10:01+08:00][sql] CONNECT:[ UseTime:0.030674s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020883s ] [2021-05-20T22:20:01+08:00][sql] CONNECT:[ UseTime:0.031129s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021653s ] [2021-05-20T22:26:09+08:00][sql] CONNECT:[ UseTime:0.034747s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:26:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.027953s ] [2021-05-20T22:26:09+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 334 LIMIT 1 [ RunTime:0.033562s ] [2021-05-20T22:26:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.023166s ] [2021-05-20T22:26:09+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.022859s ] [2021-05-20T22:26:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.022996s ] [2021-05-20T22:26:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 334 [ RunTime:0.023753s ] [2021-05-20T22:26:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.023200s ] [2021-05-20T22:26:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 334 AND `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' [ RunTime:0.022463s ] [2021-05-20T22:26:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.023472s ] [2021-05-20T22:26:09+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=334 ) ORDER BY `c`.`id` DESC [ RunTime:0.022712s ] [2021-05-20T22:26:09+08:00][DEBUG] [ 2021-05-20T22:26:09+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=334 ) ORDER BY `c`.`id` DESC [2021-05-20T22:26:43+08:00][sql] CONNECT:[ UseTime:0.029744s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:26:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021419s ] [2021-05-20T22:26:43+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 123 LIMIT 1 [ RunTime:0.019684s ] [2021-05-20T22:26:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019779s ] [2021-05-20T22:26:43+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019806s ] [2021-05-20T22:26:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019625s ] [2021-05-20T22:26:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 123 [ RunTime:0.021084s ] [2021-05-20T22:26:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019870s ] [2021-05-20T22:26:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 123 AND `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' [ RunTime:0.021435s ] [2021-05-20T22:26:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019796s ] [2021-05-20T22:26:43+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=123 ) ORDER BY `c`.`id` DESC [ RunTime:0.021529s ] [2021-05-20T22:26:43+08:00][DEBUG] [ 2021-05-20T22:26:43+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=123 ) ORDER BY `c`.`id` DESC [2021-05-20T22:27:05+08:00][sql] CONNECT:[ UseTime:0.030665s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:27:05+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021633s ] [2021-05-20T22:27:05+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 346 LIMIT 1 [ RunTime:0.019725s ] [2021-05-20T22:27:05+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.020046s ] [2021-05-20T22:27:05+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019470s ] [2021-05-20T22:27:05+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.020534s ] [2021-05-20T22:27:05+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 346 [ RunTime:0.024094s ] [2021-05-20T22:27:05+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.020024s ] [2021-05-20T22:27:05+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 346 AND `consult_id` = 838 [ RunTime:0.019878s ] [2021-05-20T22:27:05+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 346 AND `consult_id` = 839 [ RunTime:0.019598s ] [2021-05-20T22:27:05+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019882s ] [2021-05-20T22:27:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 346 [ RunTime:0.021100s ] [2021-05-20T22:27:05+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.020108s ] [2021-05-20T22:27:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 346 AND `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' [ RunTime:0.020471s ] [2021-05-20T22:27:05+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019963s ] [2021-05-20T22:27:05+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=346 ) ORDER BY `c`.`id` DESC [ RunTime:0.019891s ] [2021-05-20T22:27:05+08:00][DEBUG] [ 2021-05-20T22:27:05+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=346 ) ORDER BY `c`.`id` DESC [2021-05-20T22:27:32+08:00][sql] CONNECT:[ UseTime:0.035089s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:27:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.024716s ] [2021-05-20T22:27:32+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 126 LIMIT 1 [ RunTime:0.023339s ] [2021-05-20T22:27:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.023700s ] [2021-05-20T22:27:32+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.022546s ] [2021-05-20T22:27:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.022978s ] [2021-05-20T22:27:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 126 [ RunTime:0.023885s ] [2021-05-20T22:27:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.023055s ] [2021-05-20T22:27:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 126 AND `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' [ RunTime:0.023442s ] [2021-05-20T22:27:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.024093s ] [2021-05-20T22:27:32+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=126 ) ORDER BY `c`.`id` DESC [ RunTime:0.022908s ] [2021-05-20T22:27:32+08:00][DEBUG] [ 2021-05-20T22:27:32+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=126 ) ORDER BY `c`.`id` DESC [2021-05-20T22:29:16+08:00][sql] CONNECT:[ UseTime:0.028830s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:29:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020524s ] [2021-05-20T22:29:16+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 121 LIMIT 1 [ RunTime:0.018591s ] [2021-05-20T22:29:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018843s ] [2021-05-20T22:29:16+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.018311s ] [2021-05-20T22:29:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.018685s ] [2021-05-20T22:29:16+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 121 [ RunTime:0.023294s ] [2021-05-20T22:29:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.018838s ] [2021-05-20T22:29:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 121 AND `consult_id` = 2773 [ RunTime:0.018466s ] [2021-05-20T22:29:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 121 AND `consult_id` = 2774 [ RunTime:0.018309s ] [2021-05-20T22:29:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 121 AND `consult_id` = 2775 [ RunTime:0.018516s ] [2021-05-20T22:29:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 121 AND `consult_id` = 2776 [ RunTime:0.018488s ] [2021-05-20T22:29:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 121 AND `consult_id` = 2777 [ RunTime:0.018620s ] [2021-05-20T22:29:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018706s ] [2021-05-20T22:29:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 121 [ RunTime:0.020268s ] [2021-05-20T22:29:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018673s ] [2021-05-20T22:29:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 121 AND `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' [ RunTime:0.018247s ] [2021-05-20T22:29:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018716s ] [2021-05-20T22:29:16+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=121 ) ORDER BY `c`.`id` DESC [ RunTime:0.018662s ] [2021-05-20T22:29:16+08:00][DEBUG] [ 2021-05-20T22:29:16+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=121 ) ORDER BY `c`.`id` DESC [2021-05-20T22:30:01+08:00][sql] CONNECT:[ UseTime:0.034025s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023438s ] [2021-05-20T22:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.023778s ] [2021-05-20T22:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 334 , `ctime` = '2021-05-20 22:26:08' [ RunTime:0.023198s ] [2021-05-20T22:30:01+08:00][DEBUG] [ 2021-05-20T22:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 334 , `ctime` = '2021-05-20 22:26:08' [2021-05-20T22:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 123 , `ctime` = '2021-05-20 22:26:42' [ RunTime:0.022001s ] [2021-05-20T22:30:01+08:00][DEBUG] [ 2021-05-20T22:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 123 , `ctime` = '2021-05-20 22:26:42' [2021-05-20T22:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 346 , `ctime` = '2021-05-20 22:27:05' [ RunTime:0.022147s ] [2021-05-20T22:30:01+08:00][DEBUG] [ 2021-05-20T22:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 346 , `ctime` = '2021-05-20 22:27:05' [2021-05-20T22:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 126 , `ctime` = '2021-05-20 22:27:31' [ RunTime:0.025059s ] [2021-05-20T22:30:01+08:00][DEBUG] [ 2021-05-20T22:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 126 , `ctime` = '2021-05-20 22:27:31' [2021-05-20T22:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 121 , `ctime` = '2021-05-20 22:29:15' [ RunTime:0.022032s ] [2021-05-20T22:30:01+08:00][DEBUG] [ 2021-05-20T22:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 121 , `ctime` = '2021-05-20 22:29:15' [2021-05-20T22:30:16+08:00][sql] CONNECT:[ UseTime:0.032377s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:30:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021104s ] [2021-05-20T22:30:16+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 2647 LIMIT 1 [ RunTime:0.019822s ] [2021-05-20T22:30:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019602s ] [2021-05-20T22:30:16+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019129s ] [2021-05-20T22:30:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.021387s ] [2021-05-20T22:30:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 2647 [ RunTime:0.020899s ] [2021-05-20T22:30:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019527s ] [2021-05-20T22:30:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 2647 AND `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' [ RunTime:0.019213s ] [2021-05-20T22:30:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019768s ] [2021-05-20T22:30:16+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=2647 ) ORDER BY `c`.`id` DESC [ RunTime:0.019558s ] [2021-05-20T22:30:16+08:00][DEBUG] [ 2021-05-20T22:30:16+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='12ae6fff9b70455fb4eccb98cf0872a6' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=2647 ) ORDER BY `c`.`id` DESC [2021-05-20T22:40:01+08:00][sql] CONNECT:[ UseTime:0.033794s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022458s ] [2021-05-20T22:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.021957s ] [2021-05-20T22:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 2647 , `ctime` = '2021-05-20 22:30:16' [ RunTime:0.021551s ] [2021-05-20T22:40:01+08:00][DEBUG] [ 2021-05-20T22:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '12ae6fff9b70455fb4eccb98cf0872a6' , `c_id` = 2647 , `ctime` = '2021-05-20 22:30:16' [2021-05-20T22:50:01+08:00][sql] CONNECT:[ UseTime:0.029445s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T22:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020307s ] [2021-05-20T23:00:01+08:00][sql] CONNECT:[ UseTime:0.031268s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T23:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020777s ] [2021-05-20T23:10:01+08:00][sql] CONNECT:[ UseTime:0.032494s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T23:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022285s ] [2021-05-20T23:20:01+08:00][sql] CONNECT:[ UseTime:0.031026s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T23:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020531s ] [2021-05-20T23:30:01+08:00][sql] CONNECT:[ UseTime:0.030853s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T23:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022548s ] [2021-05-20T23:40:01+08:00][sql] CONNECT:[ UseTime:0.031651s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021741s ] [2021-05-20T23:50:02+08:00][sql] CONNECT:[ UseTime:0.030122s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-05-20T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020811s ]