[2021-06-15T00:00:01+08:00][sql] CONNECT:[ UseTime:0.029090s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T00:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020076s ] [2021-06-15T00:10:01+08:00][sql] CONNECT:[ UseTime:0.028224s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T00:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019531s ] [2021-06-15T00:20:01+08:00][sql] CONNECT:[ UseTime:0.029061s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T00:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020076s ] [2021-06-15T00:30:01+08:00][sql] CONNECT:[ UseTime:0.029804s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T00:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020346s ] [2021-06-15T00:40:01+08:00][sql] CONNECT:[ UseTime:0.029741s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T00:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020603s ] [2021-06-15T00:50:01+08:00][sql] CONNECT:[ UseTime:0.033054s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T00:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022777s ] [2021-06-15T01:00:02+08:00][sql] CONNECT:[ UseTime:0.028851s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T01:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020346s ] [2021-06-15T01:10:02+08:00][sql] CONNECT:[ UseTime:0.029961s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T01:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020683s ] [2021-06-15T01:20:02+08:00][sql] CONNECT:[ UseTime:0.028746s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T01:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020091s ] [2021-06-15T01:30:02+08:00][sql] CONNECT:[ UseTime:0.033973s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T01:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023185s ] [2021-06-15T01:40:02+08:00][sql] CONNECT:[ UseTime:0.028147s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T01:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019522s ] [2021-06-15T01:50:01+08:00][sql] CONNECT:[ UseTime:0.029790s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T01:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020647s ] [2021-06-15T02:00:01+08:00][sql] CONNECT:[ UseTime:0.033875s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T02:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023318s ] [2021-06-15T02:10:01+08:00][sql] CONNECT:[ UseTime:0.030152s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T02:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020749s ] [2021-06-15T02:20:01+08:00][sql] CONNECT:[ UseTime:0.028823s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T02:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019944s ] [2021-06-15T02:30:01+08:00][sql] CONNECT:[ UseTime:0.028294s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T02:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019795s ] [2021-06-15T02:40:01+08:00][sql] CONNECT:[ UseTime:0.030548s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T02:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021083s ] [2021-06-15T02:50:01+08:00][sql] CONNECT:[ UseTime:0.030431s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T02:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021087s ] [2021-06-15T03:00:01+08:00][sql] CONNECT:[ UseTime:0.032626s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T03:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022657s ] [2021-06-15T03:10:01+08:00][sql] CONNECT:[ UseTime:0.028777s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T03:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020136s ] [2021-06-15T03:20:01+08:00][sql] CONNECT:[ UseTime:0.037383s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T03:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.030521s ] [2021-06-15T03:30:01+08:00][sql] CONNECT:[ UseTime:0.031536s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T03:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021673s ] [2021-06-15T03:40:01+08:00][sql] CONNECT:[ UseTime:0.031879s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T03:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022011s ] [2021-06-15T03:50:01+08:00][sql] CONNECT:[ UseTime:0.028596s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T03:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019794s ] [2021-06-15T04:00:01+08:00][sql] CONNECT:[ UseTime:0.028239s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T04:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019587s ] [2021-06-15T04:10:01+08:00][sql] CONNECT:[ UseTime:0.033294s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T04:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022985s ] [2021-06-15T04:20:01+08:00][sql] CONNECT:[ UseTime:0.033697s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T04:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023092s ] [2021-06-15T04:30:01+08:00][sql] CONNECT:[ UseTime:0.028575s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T04:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019952s ] [2021-06-15T04:40:02+08:00][sql] CONNECT:[ UseTime:0.029123s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T04:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020376s ] [2021-06-15T04:50:02+08:00][sql] CONNECT:[ UseTime:0.028384s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T04:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020031s ] [2021-06-15T05:00:02+08:00][sql] CONNECT:[ UseTime:0.028422s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T05:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019694s ] [2021-06-15T05:10:02+08:00][sql] CONNECT:[ UseTime:0.028081s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T05:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019739s ] [2021-06-15T05:20:02+08:00][sql] CONNECT:[ UseTime:0.034401s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T05:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024092s ] [2021-06-15T05:30:02+08:00][sql] CONNECT:[ UseTime:0.029422s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T05:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020302s ] [2021-06-15T05:40:01+08:00][sql] CONNECT:[ UseTime:0.028726s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T05:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019904s ] [2021-06-15T05:50:01+08:00][sql] CONNECT:[ UseTime:0.033795s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T05:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023132s ] [2021-06-15T06:00:01+08:00][sql] CONNECT:[ UseTime:0.029805s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T06:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020530s ] [2021-06-15T06:10:01+08:00][sql] CONNECT:[ UseTime:0.028931s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T06:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020183s ] [2021-06-15T06:20:01+08:00][sql] CONNECT:[ UseTime:0.029187s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T06:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020521s ] [2021-06-15T06:30:01+08:00][sql] CONNECT:[ UseTime:0.029169s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T06:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020344s ] [2021-06-15T06:40:01+08:00][sql] CONNECT:[ UseTime:0.028483s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T06:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019647s ] [2021-06-15T06:50:01+08:00][sql] CONNECT:[ UseTime:0.031655s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T06:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021899s ] [2021-06-15T07:00:01+08:00][sql] CONNECT:[ UseTime:0.033803s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T07:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023310s ] [2021-06-15T07:10:01+08:00][sql] CONNECT:[ UseTime:0.034416s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T07:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023938s ] [2021-06-15T07:20:02+08:00][sql] CONNECT:[ UseTime:0.031986s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T07:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022274s ] [2021-06-15T07:30:02+08:00][sql] CONNECT:[ UseTime:0.031141s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T07:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022281s ] [2021-06-15T07:40:02+08:00][sql] CONNECT:[ UseTime:0.029060s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T07:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020152s ] [2021-06-15T07:50:02+08:00][sql] CONNECT:[ UseTime:0.029201s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T07:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020149s ] [2021-06-15T08:00:02+08:00][sql] CONNECT:[ UseTime:0.031685s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T08:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020386s ] [2021-06-15T08:10:01+08:00][sql] CONNECT:[ UseTime:0.028272s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T08:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019531s ] [2021-06-15T08:20:01+08:00][sql] CONNECT:[ UseTime:0.041591s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T08:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020686s ] [2021-06-15T08:30:01+08:00][sql] CONNECT:[ UseTime:0.028502s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T08:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019785s ] [2021-06-15T08:40:01+08:00][sql] CONNECT:[ UseTime:0.032216s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T08:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022137s ] [2021-06-15T08:50:01+08:00][sql] CONNECT:[ UseTime:0.029410s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T08:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019389s ] [2021-06-15T09:00:01+08:00][sql] CONNECT:[ UseTime:0.029531s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T09:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020774s ] [2021-06-15T09:10:01+08:00][sql] CONNECT:[ UseTime:0.034884s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T09:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.024075s ] [2021-06-15T09:14:10+08:00][sql] CONNECT:[ UseTime:0.040312s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T09:14:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.024129s ] [2021-06-15T09:14:10+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 12331 LIMIT 1 [ RunTime:0.022382s ] [2021-06-15T09:14:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.022446s ] [2021-06-15T09:14:10+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '2d7929d074934993a2abcfc604ac0e71' LIMIT 1 [ RunTime:0.021714s ] [2021-06-15T09:14:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.022125s ] [2021-06-15T09:14:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 12331 [ RunTime:0.022975s ] [2021-06-15T09:14:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.022201s ] [2021-06-15T09:14:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 12331 AND `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' [ RunTime:0.021819s ] [2021-06-15T09:14:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.022323s ] [2021-06-15T09:14:10+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=12331 ) ORDER BY `c`.`id` DESC [ RunTime:0.022213s ] [2021-06-15T09:14:10+08:00][DEBUG] [ 2021-06-15T09:14:10+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=12331 ) ORDER BY `c`.`id` DESC [2021-06-15T09:20:02+08:00][sql] CONNECT:[ UseTime:0.030711s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T09:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021644s ] [2021-06-15T09:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020927s ] [2021-06-15T09:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12331 , `ctime` = '2021-06-15 09:14:10' [ RunTime:0.020255s ] [2021-06-15T09:20:02+08:00][DEBUG] [ 2021-06-15T09:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fd2c7e1fc9a0403aabab8dd735ada933' , `c_id` = 12331 , `ctime` = '2021-06-15 09:14:10' [2021-06-15T09:30:02+08:00][sql] CONNECT:[ UseTime:0.032287s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T09:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022463s ] [2021-06-15T09:40:02+08:00][sql] CONNECT:[ UseTime:0.030494s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T09:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021145s ] [2021-06-15T09:50:02+08:00][sql] CONNECT:[ UseTime:0.030356s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T09:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020970s ] [2021-06-15T10:00:02+08:00][sql] CONNECT:[ UseTime:0.033307s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T10:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023014s ] [2021-06-15T10:10:02+08:00][sql] CONNECT:[ UseTime:0.035770s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T10:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022628s ] [2021-06-15T10:20:02+08:00][sql] CONNECT:[ UseTime:0.029026s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T10:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020436s ] [2021-06-15T10:30:02+08:00][sql] CONNECT:[ UseTime:0.029819s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T10:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020668s ] [2021-06-15T10:40:02+08:00][sql] CONNECT:[ UseTime:0.035117s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T10:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023945s ] [2021-06-15T10:50:02+08:00][sql] CONNECT:[ UseTime:0.032496s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T10:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022579s ] [2021-06-15T11:00:02+08:00][sql] CONNECT:[ UseTime:0.030613s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T11:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021224s ] [2021-06-15T11:10:02+08:00][sql] CONNECT:[ UseTime:0.028579s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T11:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020019s ] [2021-06-15T11:20:02+08:00][sql] CONNECT:[ UseTime:0.028683s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T11:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020217s ] [2021-06-15T11:30:01+08:00][sql] CONNECT:[ UseTime:0.033136s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T11:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023117s ] [2021-06-15T11:40:01+08:00][sql] CONNECT:[ UseTime:0.028726s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T11:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021030s ] [2021-06-15T11:50:01+08:00][sql] CONNECT:[ UseTime:0.029606s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T11:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020526s ] [2021-06-15T12:00:01+08:00][sql] CONNECT:[ UseTime:0.028476s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T12:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019743s ] [2021-06-15T12:10:01+08:00][sql] CONNECT:[ UseTime:0.032032s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T12:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022508s ] [2021-06-15T12:20:01+08:00][sql] CONNECT:[ UseTime:0.028116s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T12:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019547s ] [2021-06-15T12:30:01+08:00][sql] CONNECT:[ UseTime:0.030292s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T12:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020826s ] [2021-06-15T12:40:01+08:00][sql] CONNECT:[ UseTime:0.031390s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T12:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021955s ] [2021-06-15T12:50:01+08:00][sql] CONNECT:[ UseTime:0.028280s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T12:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019928s ] [2021-06-15T13:00:02+08:00][sql] CONNECT:[ UseTime:0.030231s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T13:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021403s ] [2021-06-15T13:10:02+08:00][sql] CONNECT:[ UseTime:0.029959s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T13:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023140s ] [2021-06-15T13:20:02+08:00][sql] CONNECT:[ UseTime:0.031818s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T13:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022382s ] [2021-06-15T13:30:02+08:00][sql] CONNECT:[ UseTime:0.028006s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T13:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019782s ] [2021-06-15T13:40:02+08:00][sql] CONNECT:[ UseTime:0.028543s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T13:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019869s ] [2021-06-15T13:50:02+08:00][sql] CONNECT:[ UseTime:0.032519s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T13:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022400s ] [2021-06-15T14:00:02+08:00][sql] CONNECT:[ UseTime:0.031653s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T14:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022095s ] [2021-06-15T14:10:01+08:00][sql] CONNECT:[ UseTime:0.032729s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T14:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022695s ] [2021-06-15T14:20:01+08:00][sql] CONNECT:[ UseTime:0.033134s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T14:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023392s ] [2021-06-15T14:30:01+08:00][sql] CONNECT:[ UseTime:0.030234s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T14:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021304s ] [2021-06-15T14:40:01+08:00][sql] CONNECT:[ UseTime:0.028602s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T14:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019989s ] [2021-06-15T14:50:01+08:00][sql] CONNECT:[ UseTime:0.029657s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T14:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020489s ] [2021-06-15T15:00:01+08:00][sql] CONNECT:[ UseTime:0.028237s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T15:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019736s ] [2021-06-15T15:10:01+08:00][sql] CONNECT:[ UseTime:0.027993s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T15:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019258s ] [2021-06-15T15:20:01+08:00][sql] CONNECT:[ UseTime:0.027985s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T15:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019653s ] [2021-06-15T15:30:01+08:00][sql] CONNECT:[ UseTime:0.032667s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T15:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022716s ] [2021-06-15T15:40:01+08:00][sql] CONNECT:[ UseTime:0.033164s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T15:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022814s ] [2021-06-15T15:50:01+08:00][sql] CONNECT:[ UseTime:0.028059s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T15:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019575s ] [2021-06-15T15:55:58+08:00][sql] CONNECT:[ UseTime:0.032887s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T15:55:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.023195s ] [2021-06-15T15:55:58+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 8952 LIMIT 1 [ RunTime:0.021319s ] [2021-06-15T15:55:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.021716s ] [2021-06-15T15:55:58+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '66693869d93f4c968b6131f938c3c58d' LIMIT 1 [ RunTime:0.021057s ] [2021-06-15T15:55:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.021641s ] [2021-06-15T15:55:58+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 8952 [ RunTime:0.026595s ] [2021-06-15T15:55:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.021540s ] [2021-06-15T15:55:58+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 8952 AND `consult_id` = 9157 [ RunTime:0.021537s ] [2021-06-15T15:55:58+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 8952 AND `consult_id` = 9158 [ RunTime:0.021161s ] [2021-06-15T15:55:58+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 8952 AND `consult_id` = 9159 [ RunTime:0.021119s ] [2021-06-15T15:55:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.021383s ] [2021-06-15T15:55:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 8952 [ RunTime:0.022366s ] [2021-06-15T15:55:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.023164s ] [2021-06-15T15:55:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 8952 AND `uuid` = 'c07fa260c2c449a286203a0f3a1c4956' [ RunTime:0.021402s ] [2021-06-15T15:55:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.021593s ] [2021-06-15T15:55:58+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='c07fa260c2c449a286203a0f3a1c4956' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=8952 ) ORDER BY `c`.`id` DESC [ RunTime:0.021305s ] [2021-06-15T15:55:58+08:00][DEBUG] [ 2021-06-15T15:55:58+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='c07fa260c2c449a286203a0f3a1c4956' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=8952 ) ORDER BY `c`.`id` DESC [2021-06-15T16:00:01+08:00][sql] CONNECT:[ UseTime:0.029297s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T16:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020360s ] [2021-06-15T16:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019840s ] [2021-06-15T16:00:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'c07fa260c2c449a286203a0f3a1c4956' , `c_id` = 8952 , `ctime` = '2021-06-15 15:55:57' [ RunTime:0.018982s ] [2021-06-15T16:00:01+08:00][DEBUG] [ 2021-06-15T16:00:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'c07fa260c2c449a286203a0f3a1c4956' , `c_id` = 8952 , `ctime` = '2021-06-15 15:55:57' [2021-06-15T16:10:01+08:00][sql] CONNECT:[ UseTime:0.030762s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T16:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021238s ] [2021-06-15T16:20:01+08:00][sql] CONNECT:[ UseTime:0.035083s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T16:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023211s ] [2021-06-15T16:30:02+08:00][sql] CONNECT:[ UseTime:0.033111s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T16:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022991s ] [2021-06-15T16:40:02+08:00][sql] CONNECT:[ UseTime:0.029326s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T16:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020344s ] [2021-06-15T16:50:02+08:00][sql] CONNECT:[ UseTime:0.028708s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T16:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020494s ] [2021-06-15T17:00:02+08:00][sql] CONNECT:[ UseTime:0.028356s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T17:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019874s ] [2021-06-15T17:10:02+08:00][sql] CONNECT:[ UseTime:0.032270s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T17:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022596s ] [2021-06-15T17:20:01+08:00][sql] CONNECT:[ UseTime:0.032805s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T17:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022561s ] [2021-06-15T17:30:01+08:00][sql] CONNECT:[ UseTime:0.030437s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T17:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021073s ] [2021-06-15T17:40:01+08:00][sql] CONNECT:[ UseTime:0.029785s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T17:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020545s ] [2021-06-15T17:50:01+08:00][sql] CONNECT:[ UseTime:0.030140s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T17:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021248s ] [2021-06-15T18:00:01+08:00][sql] CONNECT:[ UseTime:0.029911s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020645s ] [2021-06-15T18:10:01+08:00][sql] CONNECT:[ UseTime:0.030570s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020992s ] [2021-06-15T18:11:19+08:00][DEBUG] [ 2021-06-15T18:11:19+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-06-15T18:16:36+08:00][DEBUG] [ 2021-06-15T18:16:36+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-06-15T18:16:41+08:00][DEBUG] [ 2021-06-15T18:16:41+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-06-15T18:17:24+08:00][sql] CONNECT:[ UseTime:0.032255s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:17:24+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022839s ] [2021-06-15T18:17:24+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` = '15968697293' LIMIT 1 [ RunTime:0.024023s ] [2021-06-15T18:17:24+08:00][DEBUG] [ 2021-06-15T18:17:24+08:00 ] rediskey15968697293_signin_verify [2021-06-15T18:20:01+08:00][sql] CONNECT:[ UseTime:0.029569s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021776s ] [2021-06-15T18:25:22+08:00][DEBUG] [ 2021-06-15T18:25:22+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-06-15T18:26:12+08:00][DEBUG] [ 2021-06-15T18:26:12+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-06-15T18:27:31+08:00][DEBUG] [ 2021-06-15T18:27:31+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-06-15T18:27:56+08:00][DEBUG] [ 2021-06-15T18:27:56+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-06-15T18:28:31+08:00][sql] CONNECT:[ UseTime:0.029967s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:28:31+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021157s ] [2021-06-15T18:28:31+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` = '15968697293' LIMIT 1 [ RunTime:0.022464s ] [2021-06-15T18:28:31+08:00][DEBUG] [ 2021-06-15T18:28:31+08:00 ] rediskey15968697293_signin_verify [2021-06-15T18:28:54+08:00][sql] CONNECT:[ UseTime:0.029859s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:28:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022275s ] [2021-06-15T18:28:54+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` = '15968697293' LIMIT 1 [ RunTime:0.019509s ] [2021-06-15T18:28:54+08:00][DEBUG] [ 2021-06-15T18:28:54+08:00 ] rediskey15968697293_signin_verify [2021-06-15T18:28:54+08:00][DEBUG] [ 2021-06-15T18:28:54+08:00 ] session11 [2021-06-15T18:28:54+08:00][WARN] [ 2021-06-15T18:28:54+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-06-15T18:30:01+08:00][sql] CONNECT:[ UseTime:0.033074s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022787s ] [2021-06-15T18:40:01+08:00][sql] CONNECT:[ UseTime:0.031579s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021221s ] [2021-06-15T18:50:01+08:00][sql] CONNECT:[ UseTime:0.028269s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019756s ] [2021-06-15T18:58:12+08:00][sql] CONNECT:[ UseTime:0.028391s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T18:58:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020222s ] [2021-06-15T18:58:12+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 8952 LIMIT 1 [ RunTime:0.018412s ] [2021-06-15T18:58:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018806s ] [2021-06-15T18:58:12+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '66693869d93f4c968b6131f938c3c58d' LIMIT 1 [ RunTime:0.018142s ] [2021-06-15T18:58:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.018678s ] [2021-06-15T18:58:12+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 8952 [ RunTime:0.018199s ] [2021-06-15T18:58:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.018635s ] [2021-06-15T18:58:12+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 8952 AND `consult_id` = 9157 [ RunTime:0.018162s ] [2021-06-15T18:58:12+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 8952 AND `consult_id` = 9158 [ RunTime:0.018128s ] [2021-06-15T18:58:12+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 8952 AND `consult_id` = 9159 [ RunTime:0.018078s ] [2021-06-15T18:58:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018669s ] [2021-06-15T18:58:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 8952 [ RunTime:0.019421s ] [2021-06-15T18:58:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018682s ] [2021-06-15T18:58:12+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.status='上线' AND c.c_id=8952 ) ORDER BY `c`.`id` DESC [ RunTime:0.018417s ] [2021-06-15T18:58:12+08:00][DEBUG] [ 2021-06-15T18:58:12+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.status='上线' AND c.c_id=8952 ) ORDER BY `c`.`id` DESC [2021-06-15T19:00:02+08:00][sql] CONNECT:[ UseTime:0.031875s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T19:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022221s ] [2021-06-15T19:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.021752s ] [2021-06-15T19:00:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '' , `c_id` = 8952 , `ctime` = '2021-06-15 18:58:12' [ RunTime:0.020761s ] [2021-06-15T19:00:02+08:00][DEBUG] [ 2021-06-15T19:00:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '' , `c_id` = 8952 , `ctime` = '2021-06-15 18:58:12' [2021-06-15T19:10:02+08:00][sql] CONNECT:[ UseTime:0.028302s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T19:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019665s ] [2021-06-15T19:20:02+08:00][sql] CONNECT:[ UseTime:0.029210s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T19:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020246s ] [2021-06-15T19:30:02+08:00][sql] CONNECT:[ UseTime:0.030102s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T19:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019899s ] [2021-06-15T19:40:02+08:00][sql] CONNECT:[ UseTime:0.031341s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T19:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021994s ] [2021-06-15T19:50:01+08:00][sql] CONNECT:[ UseTime:0.028877s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T19:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020189s ] [2021-06-15T20:00:01+08:00][sql] CONNECT:[ UseTime:0.028192s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T20:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021033s ] [2021-06-15T20:08:01+08:00][sql] CONNECT:[ UseTime:0.028248s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T20:08:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019673s ] [2021-06-15T20:08:01+08:00][DEBUG] [ 2021-06-15T20:08:01+08:00 ] function | invalidSession | jwt expire! [2021-06-15T20:08:30+08:00][sql] CONNECT:[ UseTime:0.032998s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T20:08:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.023217s ] [2021-06-15T20:08:30+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE `t1`.`phone` = '13586298690' LIMIT 1 [ RunTime:0.024145s ] [2021-06-15T20:08:30+08:00][DEBUG] [ 2021-06-15T20:08:30+08:00 ] rediskey13586298690_signin_verify [2021-06-15T20:10:01+08:00][sql] CONNECT:[ UseTime:0.028331s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T20:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021819s ] [2021-06-15T20:20:01+08:00][sql] CONNECT:[ UseTime:0.032381s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T20:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022400s ] [2021-06-15T20:30:01+08:00][sql] CONNECT:[ UseTime:0.033223s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T20:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023166s ] [2021-06-15T20:40:01+08:00][sql] CONNECT:[ UseTime:0.029307s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T20:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020581s ] [2021-06-15T20:50:01+08:00][sql] CONNECT:[ UseTime:0.028136s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T20:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019677s ] [2021-06-15T21:00:01+08:00][sql] CONNECT:[ UseTime:0.030116s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T21:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020871s ] [2021-06-15T21:10:01+08:00][sql] CONNECT:[ UseTime:0.028922s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T21:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019922s ] [2021-06-15T21:20:02+08:00][sql] CONNECT:[ UseTime:0.029100s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T21:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020364s ] [2021-06-15T21:30:02+08:00][sql] CONNECT:[ UseTime:0.029162s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T21:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020241s ] [2021-06-15T21:40:02+08:00][sql] CONNECT:[ UseTime:0.029345s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T21:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020658s ] [2021-06-15T21:50:02+08:00][sql] CONNECT:[ UseTime:0.029742s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T21:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020751s ] [2021-06-15T22:00:02+08:00][sql] CONNECT:[ UseTime:0.032446s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T22:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022474s ] [2021-06-15T22:10:02+08:00][sql] CONNECT:[ UseTime:0.029008s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T22:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020001s ] [2021-06-15T22:20:01+08:00][sql] CONNECT:[ UseTime:0.033641s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T22:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023202s ] [2021-06-15T22:30:01+08:00][sql] CONNECT:[ UseTime:0.033928s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T22:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023528s ] [2021-06-15T22:40:01+08:00][sql] CONNECT:[ UseTime:0.028439s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T22:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019919s ] [2021-06-15T22:50:01+08:00][sql] CONNECT:[ UseTime:0.030327s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T22:50:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021463s ] [2021-06-15T23:00:01+08:00][sql] CONNECT:[ UseTime:0.029714s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T23:00:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021029s ] [2021-06-15T23:10:01+08:00][sql] CONNECT:[ UseTime:0.030214s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T23:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021263s ] [2021-06-15T23:20:01+08:00][sql] CONNECT:[ UseTime:0.033439s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T23:20:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023595s ] [2021-06-15T23:30:02+08:00][sql] CONNECT:[ UseTime:0.028605s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019893s ] [2021-06-15T23:40:02+08:00][sql] CONNECT:[ UseTime:0.034415s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.023749s ] [2021-06-15T23:50:02+08:00][sql] CONNECT:[ UseTime:0.029978s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-06-15T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020829s ]