[2020-12-15T15:01:03+08:00][sql] CONNECT:[ UseTime:0.029033s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-12-15T15:01:03+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020690s ] [2020-12-15T15:01:03+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081003207' AND `status` = '上线' LIMIT 1 [ RunTime:0.018710s ] [2020-12-15T15:01:03+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 435 LIMIT 1 [ RunTime:0.018643s ] [2020-12-15T15:01:03+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019046s ] [2020-12-15T15:01:03+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.018416s ] [2020-12-15T15:01:03+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018899s ] [2020-12-15T15:01:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 435 [ RunTime:0.019172s ] [2020-12-15T15:01:03+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018931s ] [2020-12-15T15:01:03+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=435 ) ORDER BY `c`.`id` DESC [ RunTime:0.018762s ] [2020-12-15T15:01:03+08:00][DEBUG] [ 2020-12-15T15:01:03+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=435 ) ORDER BY `c`.`id` DESC [2020-12-15T15:01:30+08:00][sql] CONNECT:[ UseTime:0.028354s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-12-15T15:01:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020017s ] [2020-12-15T15:01:30+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 444 LIMIT 1 [ RunTime:0.018251s ] [2020-12-15T15:01:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018578s ] [2020-12-15T15:01:30+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017979s ] [2020-12-15T15:01:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018280s ] [2020-12-15T15:01:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 444 [ RunTime:0.018528s ] [2020-12-15T15:01:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018820s ] [2020-12-15T15:01:30+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=444 ) ORDER BY `c`.`id` DESC [ RunTime:0.018260s ] [2020-12-15T15:01:30+08:00][DEBUG] [ 2020-12-15T15:01:30+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=444 ) ORDER BY `c`.`id` DESC [2020-12-15T15:03:55+08:00][DEBUG] [ 2020-12-15T15:03:55+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-12-15T15:04:18+08:00][sql] CONNECT:[ UseTime:0.031100s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-12-15T15:04:18+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022037s ] [2020-12-15T15:04:18+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` = '18958666618' LIMIT 1 [ RunTime:0.021817s ] [2020-12-15T15:04:18+08:00][DEBUG] [ 2020-12-15T15:04:18+08:00 ] rediskey18958666618_signin_verify [2020-12-15T15:10:01+08:00][sql] CONNECT:[ UseTime:0.026786s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-12-15T15:10:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018886s ] [2020-12-15T15:10:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '' , `c_id` = 153 , `ctime` = '2020-12-15 15:01:02' [ RunTime:0.018469s ] [2020-12-15T15:10:01+08:00][DEBUG] [ 2020-12-15T15:10:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '' , `c_id` = 153 , `ctime` = '2020-12-15 15:01:02' [2020-12-15T15:10:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '' , `c_id` = 444 , `ctime` = '2020-12-15 15:01:30' [ RunTime:0.017726s ] [2020-12-15T15:10:01+08:00][DEBUG] [ 2020-12-15T15:10:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '' , `c_id` = 444 , `ctime` = '2020-12-15 15:01:30'