[2021-01-19T17:20:08+08:00][sql] CONNECT:[ UseTime:0.028663s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-01-19T17:20:08+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020149s ] [2021-01-19T17:20:08+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 1629 LIMIT 1 [ RunTime:0.018830s ] [2021-01-19T17:20:08+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018624s ] [2021-01-19T17:20:08+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017969s ] [2021-01-19T17:20:08+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018392s ] [2021-01-19T17:20:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 1629 [ RunTime:0.018607s ] [2021-01-19T17:20:08+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018439s ] [2021-01-19T17:20:08+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=1629 ) ORDER BY `c`.`id` DESC [ RunTime:0.018284s ] [2021-01-19T17:20:08+08:00][DEBUG] [ 2021-01-19T17:20:08+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=1629 ) ORDER BY `c`.`id` DESC [2021-01-19T17:30:01+08:00][sql] CONNECT:[ UseTime:0.028233s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-01-19T17:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019494s ] [2021-01-19T17:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '' , `c_id` = 1629 , `ctime` = '2021-01-19 17:20:08' [ RunTime:0.019187s ] [2021-01-19T17:30:01+08:00][DEBUG] [ 2021-01-19T17:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '' , `c_id` = 1629 , `ctime` = '2021-01-19 17:20:08' [2021-01-19T19:11:56+08:00][DEBUG] [ 2021-01-19T19:11:56+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-01-19T19:12:28+08:00][sql] CONNECT:[ UseTime:0.029496s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-01-19T19:12:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021073s ] [2021-01-19T19:12:28+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` = '17858691272' LIMIT 1 [ RunTime:0.021822s ] [2021-01-19T19:12:28+08:00][DEBUG] [ 2021-01-19T19:12:28+08:00 ] rediskey17858691272_signin_verify [2021-01-19T19:14:32+08:00][sql] CONNECT:[ UseTime:0.030535s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-01-19T19:14:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021223s ] [2021-01-19T19:14:32+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 364 LIMIT 1 [ RunTime:0.019412s ] [2021-01-19T19:14:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019528s ] [2021-01-19T19:14:32+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019004s ] [2021-01-19T19:14:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019602s ] [2021-01-19T19:14:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 364 [ RunTime:0.019554s ] [2021-01-19T19:14:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019404s ] [2021-01-19T19:14:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 364 AND `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' [ RunTime:0.019039s ] [2021-01-19T19:14:32+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019474s ] [2021-01-19T19:14: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='5ebc563b6d094ff78be8ebc9f8119b92' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=364 ) ORDER BY `c`.`id` DESC [ RunTime:0.019618s ] [2021-01-19T19:14:32+08:00][DEBUG] [ 2021-01-19T19:14: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='5ebc563b6d094ff78be8ebc9f8119b92' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=364 ) ORDER BY `c`.`id` DESC [2021-01-19T19:16:36+08:00][sql] CONNECT:[ UseTime:0.030702s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-01-19T19:16:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021526s ] [2021-01-19T19:16:36+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 300 LIMIT 1 [ RunTime:0.019467s ] [2021-01-19T19:16:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019827s ] [2021-01-19T19:16:36+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019289s ] [2021-01-19T19:16:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019557s ] [2021-01-19T19:16:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 300 [ RunTime:0.021381s ] [2021-01-19T19:16:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019552s ] [2021-01-19T19:16:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 300 AND `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' [ RunTime:0.019282s ] [2021-01-19T19:16:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019660s ] [2021-01-19T19:16:36+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='5ebc563b6d094ff78be8ebc9f8119b92' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=300 ) ORDER BY `c`.`id` DESC [ RunTime:0.019499s ] [2021-01-19T19:16:36+08:00][DEBUG] [ 2021-01-19T19:16:36+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='5ebc563b6d094ff78be8ebc9f8119b92' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=300 ) ORDER BY `c`.`id` DESC [2021-01-19T19:16:51+08:00][sql] CONNECT:[ UseTime:0.030606s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-01-19T19:16:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021889s ] [2021-01-19T19:16:51+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 299 LIMIT 1 [ RunTime:0.020029s ] [2021-01-19T19:16:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.020049s ] [2021-01-19T19:16:51+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019445s ] [2021-01-19T19:16:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020495s ] [2021-01-19T19:16:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 299 [ RunTime:0.020032s ] [2021-01-19T19:16:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019755s ] [2021-01-19T19:16:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 299 AND `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' [ RunTime:0.019469s ] [2021-01-19T19:16:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019867s ] [2021-01-19T19:16:51+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='5ebc563b6d094ff78be8ebc9f8119b92' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=299 ) ORDER BY `c`.`id` DESC [ RunTime:0.019761s ] [2021-01-19T19:16:51+08:00][DEBUG] [ 2021-01-19T19:16:51+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='5ebc563b6d094ff78be8ebc9f8119b92' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=299 ) ORDER BY `c`.`id` DESC [2021-01-19T19:20:02+08:00][sql] CONNECT:[ UseTime:0.029464s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-01-19T19:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020409s ] [2021-01-19T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' , `c_id` = 364 , `ctime` = '2021-01-19 19:14:32' [ RunTime:0.020125s ] [2021-01-19T19:20:02+08:00][DEBUG] [ 2021-01-19T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' , `c_id` = 364 , `ctime` = '2021-01-19 19:14:32' [2021-01-19T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' , `c_id` = 300 , `ctime` = '2021-01-19 19:16:35' [ RunTime:0.019517s ] [2021-01-19T19:20:02+08:00][DEBUG] [ 2021-01-19T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' , `c_id` = 300 , `ctime` = '2021-01-19 19:16:35' [2021-01-19T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' , `c_id` = 299 , `ctime` = '2021-01-19 19:16:51' [ RunTime:0.018969s ] [2021-01-19T19:20:02+08:00][DEBUG] [ 2021-01-19T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '5ebc563b6d094ff78be8ebc9f8119b92' , `c_id` = 299 , `ctime` = '2021-01-19 19:16:51'