[2020-09-02T11:51:29+08:00][sql] CONNECT:[ UseTime:0.030277s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T11:51:29+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021269s ] [2020-09-02T11:51:29+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081003211' AND `status` = '上线' LIMIT 1 [ RunTime:0.019336s ] [2020-09-02T11:51:29+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 470 LIMIT 1 [ RunTime:0.019599s ] [2020-09-02T11:51:29+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019857s ] [2020-09-02T11:51:29+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019300s ] [2020-09-02T11:51:29+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020420s ] [2020-09-02T11:51:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 470 [ RunTime:0.019211s ] [2020-09-02T11:51:29+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019707s ] [2020-09-02T11:51:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 470 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.019721s ] [2020-09-02T11:51:29+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019746s ] [2020-09-02T11:51:29+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=470 ) ORDER BY `c`.`id` DESC [ RunTime:0.020629s ] [2020-09-02T11:51:29+08:00][DEBUG] [ 2020-09-02T11:51:29+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=470 ) ORDER BY `c`.`id` DESC [2020-09-02T12:00:02+08:00][sql] CONNECT:[ UseTime:0.026755s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T12:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018740s ] [2020-09-02T12:00:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 11:51:29' [ RunTime:0.019914s ] [2020-09-02T12:00:02+08:00][DEBUG] [ 2020-09-02T12:00:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 11:51:29' [2020-09-02T17:36:47+08:00][sql] CONNECT:[ UseTime:0.027546s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T17:36:47+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019457s ] [2020-09-02T17:36:47+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081003003' AND `status` = '上线' LIMIT 1 [ RunTime:0.017716s ] [2020-09-02T17:36:47+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 478 LIMIT 1 [ RunTime:0.017763s ] [2020-09-02T17:36:47+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018122s ] [2020-09-02T17:36:47+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017534s ] [2020-09-02T17:36:47+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017813s ] [2020-09-02T17:36:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 478 [ RunTime:0.017955s ] [2020-09-02T17:36:47+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017870s ] [2020-09-02T17:36:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 478 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017618s ] [2020-09-02T17:36:47+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018034s ] [2020-09-02T17:36:47+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=478 ) ORDER BY `c`.`id` DESC [ RunTime:0.017857s ] [2020-09-02T17:36:47+08:00][DEBUG] [ 2020-09-02T17:36:47+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=478 ) ORDER BY `c`.`id` DESC [2020-09-02T17:36:51+08:00][sql] CONNECT:[ UseTime:0.031506s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T17:36:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022262s ] [2020-09-02T17:36:51+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 479 LIMIT 1 [ RunTime:0.020408s ] [2020-09-02T17:36:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.020764s ] [2020-09-02T17:36:51+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.020100s ] [2020-09-02T17:36:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.020625s ] [2020-09-02T17:36:51+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 479 [ RunTime:0.020251s ] [2020-09-02T17:36:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.020613s ] [2020-09-02T17:36:51+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 479 AND `consult_id` = 1875 [ RunTime:0.020159s ] [2020-09-02T17:36:51+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 479 AND `consult_id` = 1876 [ RunTime:0.020151s ] [2020-09-02T17:36:51+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 479 AND `consult_id` = 1877 [ RunTime:0.020506s ] [2020-09-02T17:36:51+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 479 AND `consult_id` = 1878 [ RunTime:0.020173s ] [2020-09-02T17:36:51+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 479 AND `consult_id` = 1879 [ RunTime:0.020209s ] [2020-09-02T17:36:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020515s ] [2020-09-02T17:36:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 479 [ RunTime:0.020202s ] [2020-09-02T17:36:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.020566s ] [2020-09-02T17:36:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 479 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.020238s ] [2020-09-02T17:36:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.020665s ] [2020-09-02T17:36: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=479 ) ORDER BY `c`.`id` DESC [ RunTime:0.020464s ] [2020-09-02T17:36:51+08:00][DEBUG] [ 2020-09-02T17:36: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=479 ) ORDER BY `c`.`id` DESC [2020-09-02T17:37:16+08:00][sql] CONNECT:[ UseTime:0.026408s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T17:37:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.018695s ] [2020-09-02T17:37:16+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 490 LIMIT 1 [ RunTime:0.016957s ] [2020-09-02T17:37:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017429s ] [2020-09-02T17:37:16+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.016754s ] [2020-09-02T17:37:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.017172s ] [2020-09-02T17:37:16+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 490 [ RunTime:0.016827s ] [2020-09-02T17:37:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.017132s ] [2020-09-02T17:37:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 490 AND `consult_id` = 1644 [ RunTime:0.016890s ] [2020-09-02T17:37:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 490 AND `consult_id` = 1645 [ RunTime:0.016766s ] [2020-09-02T17:37:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 490 AND `consult_id` = 1646 [ RunTime:0.016818s ] [2020-09-02T17:37:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 490 AND `consult_id` = 1647 [ RunTime:0.016959s ] [2020-09-02T17:37:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017149s ] [2020-09-02T17:37:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 490 [ RunTime:0.016934s ] [2020-09-02T17:37:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017102s ] [2020-09-02T17:37:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 490 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.016777s ] [2020-09-02T17:37:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017181s ] [2020-09-02T17:37: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=490 ) ORDER BY `c`.`id` DESC [ RunTime:0.017098s ] [2020-09-02T17:37:16+08:00][DEBUG] [ 2020-09-02T17:37: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=490 ) ORDER BY `c`.`id` DESC [2020-09-02T17:37:23+08:00][sql] CONNECT:[ UseTime:0.029103s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T17:37:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020556s ] [2020-09-02T17:37:23+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 642 LIMIT 1 [ RunTime:0.018816s ] [2020-09-02T17:37:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019836s ] [2020-09-02T17:37:23+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.018501s ] [2020-09-02T17:37:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019062s ] [2020-09-02T17:37:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 642 [ RunTime:0.018479s ] [2020-09-02T17:37:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019075s ] [2020-09-02T17:37:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 642 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.018525s ] [2020-09-02T17:37:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018941s ] [2020-09-02T17:37: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=642 ) ORDER BY `c`.`id` DESC [ RunTime:0.019861s ] [2020-09-02T17:37:23+08:00][DEBUG] [ 2020-09-02T17:37: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=642 ) ORDER BY `c`.`id` DESC [2020-09-02T17:37:42+08:00][sql] CONNECT:[ UseTime:0.026693s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T17:37:42+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019141s ] [2020-09-02T17:37:42+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 95 LIMIT 1 [ RunTime:0.017689s ] [2020-09-02T17:37:42+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018885s ] [2020-09-02T17:37:42+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017217s ] [2020-09-02T17:37:42+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017565s ] [2020-09-02T17:37:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 95 [ RunTime:0.017648s ] [2020-09-02T17:37:42+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017796s ] [2020-09-02T17:37:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 95 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017475s ] [2020-09-02T17:37:42+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018482s ] [2020-09-02T17:37:42+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=95 ) ORDER BY `c`.`id` DESC [ RunTime:0.017693s ] [2020-09-02T17:37:42+08:00][DEBUG] [ 2020-09-02T17:37:42+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=95 ) ORDER BY `c`.`id` DESC [2020-09-02T17:37:50+08:00][sql] CONNECT:[ UseTime:0.026332s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T17:37:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.018906s ] [2020-09-02T17:37:50+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 95 LIMIT 1 [ RunTime:0.017274s ] [2020-09-02T17:37:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017583s ] [2020-09-02T17:37:50+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017090s ] [2020-09-02T17:37:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017272s ] [2020-09-02T17:37:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 95 [ RunTime:0.016958s ] [2020-09-02T17:37:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017373s ] [2020-09-02T17:37:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 95 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.016972s ] [2020-09-02T17:37:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017468s ] [2020-09-02T17:37:50+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=95 ) ORDER BY `c`.`id` DESC [ RunTime:0.017085s ] [2020-09-02T17:37:50+08:00][DEBUG] [ 2020-09-02T17:37:50+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=95 ) ORDER BY `c`.`id` DESC [2020-09-02T17:40:01+08:00][sql] CONNECT:[ UseTime:0.026010s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T17:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018184s ] [2020-09-02T17:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 17:36:46' [ RunTime:0.019389s ] [2020-09-02T17:40:01+08:00][DEBUG] [ 2020-09-02T17:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 17:36:46' [2020-09-02T17:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 479 , `ctime` = '2020-09-02 17:36:51' [ RunTime:0.016943s ] [2020-09-02T17:40:01+08:00][DEBUG] [ 2020-09-02T17:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 479 , `ctime` = '2020-09-02 17:36:51' [2020-09-02T17:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 490 , `ctime` = '2020-09-02 17:37:15' [ RunTime:0.016466s ] [2020-09-02T17:40:01+08:00][DEBUG] [ 2020-09-02T17:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 490 , `ctime` = '2020-09-02 17:37:15' [2020-09-02T17:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 642 , `ctime` = '2020-09-02 17:37:22' [ RunTime:0.016640s ] [2020-09-02T17:40:01+08:00][DEBUG] [ 2020-09-02T17:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 642 , `ctime` = '2020-09-02 17:37:22' [2020-09-02T17:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 95 , `ctime` = '2020-09-02 17:37:42' [ RunTime:0.016408s ] [2020-09-02T17:40:01+08:00][DEBUG] [ 2020-09-02T17:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 95 , `ctime` = '2020-09-02 17:37:42' [2020-09-02T17:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 95 , `ctime` = '2020-09-02 17:37:50' [ RunTime:0.016573s ] [2020-09-02T17:40:01+08:00][DEBUG] [ 2020-09-02T17:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 95 , `ctime` = '2020-09-02 17:37:50' [2020-09-02T18:33:50+08:00][sql] CONNECT:[ UseTime:0.026665s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:33:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019032s ] [2020-09-02T18:33:50+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081003209' AND `status` = '上线' LIMIT 1 [ RunTime:0.017156s ] [2020-09-02T18:33:50+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 463 LIMIT 1 [ RunTime:0.017436s ] [2020-09-02T18:33:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017611s ] [2020-09-02T18:33:50+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017000s ] [2020-09-02T18:33:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017479s ] [2020-09-02T18:33:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 463 [ RunTime:0.018319s ] [2020-09-02T18:33:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017369s ] [2020-09-02T18:33:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 463 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017097s ] [2020-09-02T18:33:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017534s ] [2020-09-02T18:33:50+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=463 ) ORDER BY `c`.`id` DESC [ RunTime:0.017320s ] [2020-09-02T18:33:50+08:00][DEBUG] [ 2020-09-02T18:33:50+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=463 ) ORDER BY `c`.`id` DESC [2020-09-02T18:33:54+08:00][sql] CONNECT:[ UseTime:0.026900s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:33:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019126s ] [2020-09-02T18:33:54+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 800 LIMIT 1 [ RunTime:0.026053s ] [2020-09-02T18:33:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018023s ] [2020-09-02T18:33:54+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017028s ] [2020-09-02T18:33:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017392s ] [2020-09-02T18:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 800 [ RunTime:0.017269s ] [2020-09-02T18:33:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017467s ] [2020-09-02T18:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 800 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017127s ] [2020-09-02T18:33:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017500s ] [2020-09-02T18:33: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=800 ) ORDER BY `c`.`id` DESC [ RunTime:0.017703s ] [2020-09-02T18:33:54+08:00][DEBUG] [ 2020-09-02T18:33: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=800 ) ORDER BY `c`.`id` DESC [2020-09-02T18:33:56+08:00][sql] CONNECT:[ UseTime:0.029759s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:33:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020302s ] [2020-09-02T18:33:56+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 800 LIMIT 1 [ RunTime:0.028001s ] [2020-09-02T18:33:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019134s ] [2020-09-02T18:33:56+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.018484s ] [2020-09-02T18:33:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018825s ] [2020-09-02T18:33:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 800 [ RunTime:0.018515s ] [2020-09-02T18:33:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018814s ] [2020-09-02T18:33:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 800 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.020033s ] [2020-09-02T18:33:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018895s ] [2020-09-02T18:33:56+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=800 ) ORDER BY `c`.`id` DESC [ RunTime:0.018656s ] [2020-09-02T18:33:56+08:00][DEBUG] [ 2020-09-02T18:33:56+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=800 ) ORDER BY `c`.`id` DESC [2020-09-02T18:34:07+08:00][sql] CONNECT:[ UseTime:0.026937s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:34:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019198s ] [2020-09-02T18:34:07+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 798 LIMIT 1 [ RunTime:0.017361s ] [2020-09-02T18:34:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017661s ] [2020-09-02T18:34:07+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017096s ] [2020-09-02T18:34:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017426s ] [2020-09-02T18:34:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 798 [ RunTime:0.017043s ] [2020-09-02T18:34:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017458s ] [2020-09-02T18:34:07+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=798 ) ORDER BY `c`.`id` DESC [ RunTime:0.017486s ] [2020-09-02T18:34:07+08:00][DEBUG] [ 2020-09-02T18:34:07+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=798 ) ORDER BY `c`.`id` DESC [2020-09-02T18:34:16+08:00][sql] CONNECT:[ UseTime:0.028302s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:34:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020133s ] [2020-09-02T18:34:16+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 799 LIMIT 1 [ RunTime:0.018241s ] [2020-09-02T18:34:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018819s ] [2020-09-02T18:34:16+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017985s ] [2020-09-02T18:34:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.018663s ] [2020-09-02T18:34:16+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 799 [ RunTime:0.018019s ] [2020-09-02T18:34:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.018542s ] [2020-09-02T18:34:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2027 [ RunTime:0.018044s ] [2020-09-02T18:34:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2028 [ RunTime:0.017954s ] [2020-09-02T18:34:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2029 [ RunTime:0.017935s ] [2020-09-02T18:34:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2030 [ RunTime:0.018028s ] [2020-09-02T18:34:16+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2031 [ RunTime:0.017936s ] [2020-09-02T18:34:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018324s ] [2020-09-02T18:34:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 799 [ RunTime:0.017940s ] [2020-09-02T18:34:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018304s ] [2020-09-02T18:34:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 799 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.018078s ] [2020-09-02T18:34:16+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018417s ] [2020-09-02T18:34: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=799 ) ORDER BY `c`.`id` DESC [ RunTime:0.018260s ] [2020-09-02T18:34:16+08:00][DEBUG] [ 2020-09-02T18:34: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=799 ) ORDER BY `c`.`id` DESC [2020-09-02T18:34:21+08:00][sql] CONNECT:[ UseTime:0.027565s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:34:21+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019558s ] [2020-09-02T18:34:21+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 798 LIMIT 1 [ RunTime:0.017771s ] [2020-09-02T18:34:21+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018170s ] [2020-09-02T18:34:21+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017593s ] [2020-09-02T18:34:21+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018188s ] [2020-09-02T18:34:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 798 [ RunTime:0.017507s ] [2020-09-02T18:34:21+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017942s ] [2020-09-02T18:34:21+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=798 ) ORDER BY `c`.`id` DESC [ RunTime:0.017649s ] [2020-09-02T18:34:21+08:00][DEBUG] [ 2020-09-02T18:34:21+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=798 ) ORDER BY `c`.`id` DESC [2020-09-02T18:34:28+08:00][sql] CONNECT:[ UseTime:0.027170s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:34:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019248s ] [2020-09-02T18:34:28+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 799 LIMIT 1 [ RunTime:0.017482s ] [2020-09-02T18:34:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017930s ] [2020-09-02T18:34:28+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017234s ] [2020-09-02T18:34:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.017725s ] [2020-09-02T18:34:28+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 799 [ RunTime:0.017333s ] [2020-09-02T18:34:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.017643s ] [2020-09-02T18:34:28+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2027 [ RunTime:0.017334s ] [2020-09-02T18:34:28+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2028 [ RunTime:0.017177s ] [2020-09-02T18:34:28+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2029 [ RunTime:0.017238s ] [2020-09-02T18:34:28+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2030 [ RunTime:0.017192s ] [2020-09-02T18:34:28+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 799 AND `consult_id` = 2031 [ RunTime:0.017219s ] [2020-09-02T18:34:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017606s ] [2020-09-02T18:34:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 799 [ RunTime:0.017211s ] [2020-09-02T18:34:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017613s ] [2020-09-02T18:34:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 799 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017188s ] [2020-09-02T18:34:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017699s ] [2020-09-02T18:34:28+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=799 ) ORDER BY `c`.`id` DESC [ RunTime:0.017385s ] [2020-09-02T18:34:28+08:00][DEBUG] [ 2020-09-02T18:34:28+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=799 ) ORDER BY `c`.`id` DESC [2020-09-02T18:34:40+08:00][sql] CONNECT:[ UseTime:0.026721s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:34:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.018803s ] [2020-09-02T18:34:40+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 613 LIMIT 1 [ RunTime:0.016881s ] [2020-09-02T18:34:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017278s ] [2020-09-02T18:34:40+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.016654s ] [2020-09-02T18:34:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.017106s ] [2020-09-02T18:34:40+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 613 [ RunTime:0.017992s ] [2020-09-02T18:34:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.017062s ] [2020-09-02T18:34:40+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 613 AND `consult_id` = 995 [ RunTime:0.016748s ] [2020-09-02T18:34:40+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 613 AND `consult_id` = 996 [ RunTime:0.016709s ] [2020-09-02T18:34:40+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 613 AND `consult_id` = 997 [ RunTime:0.016672s ] [2020-09-02T18:34:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017567s ] [2020-09-02T18:34:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 613 [ RunTime:0.016642s ] [2020-09-02T18:34:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.016980s ] [2020-09-02T18:34:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 613 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017853s ] [2020-09-02T18:34:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017081s ] [2020-09-02T18:34:40+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=613 ) ORDER BY `c`.`id` DESC [ RunTime:0.016986s ] [2020-09-02T18:34:40+08:00][DEBUG] [ 2020-09-02T18:34:40+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=613 ) ORDER BY `c`.`id` DESC [2020-09-02T18:34:43+08:00][sql] CONNECT:[ UseTime:0.026566s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:34:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.018889s ] [2020-09-02T18:34:43+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 801 LIMIT 1 [ RunTime:0.017098s ] [2020-09-02T18:34:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017489s ] [2020-09-02T18:34:43+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.016842s ] [2020-09-02T18:34:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.017305s ] [2020-09-02T18:34:43+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 801 [ RunTime:0.016954s ] [2020-09-02T18:34:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.017249s ] [2020-09-02T18:34:43+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 801 AND `consult_id` = 2032 [ RunTime:0.016978s ] [2020-09-02T18:34:43+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 801 AND `consult_id` = 2033 [ RunTime:0.016914s ] [2020-09-02T18:34:43+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 801 AND `consult_id` = 2034 [ RunTime:0.016949s ] [2020-09-02T18:34:43+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 801 AND `consult_id` = 2035 [ RunTime:0.016944s ] [2020-09-02T18:34:43+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 801 AND `consult_id` = 2036 [ RunTime:0.016930s ] [2020-09-02T18:34:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017207s ] [2020-09-02T18:34:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 801 [ RunTime:0.016823s ] [2020-09-02T18:34:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018488s ] [2020-09-02T18:34:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 801 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.016925s ] [2020-09-02T18:34:43+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017296s ] [2020-09-02T18:34: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=801 ) ORDER BY `c`.`id` DESC [ RunTime:0.017171s ] [2020-09-02T18:34:43+08:00][DEBUG] [ 2020-09-02T18:34: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=801 ) ORDER BY `c`.`id` DESC [2020-09-02T18:34:50+08:00][sql] CONNECT:[ UseTime:0.025851s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.018916s ] [2020-09-02T18:34:50+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 794 LIMIT 1 [ RunTime:0.016596s ] [2020-09-02T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.016980s ] [2020-09-02T18:34:50+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.016333s ] [2020-09-02T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.016679s ] [2020-09-02T18:34:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 794 [ RunTime:0.016298s ] [2020-09-02T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.016677s ] [2020-09-02T18:34:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 794 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.016424s ] [2020-09-02T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.016759s ] [2020-09-02T18:34:50+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=794 ) ORDER BY `c`.`id` DESC [ RunTime:0.016615s ] [2020-09-02T18:34:50+08:00][DEBUG] [ 2020-09-02T18:34:50+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=794 ) ORDER BY `c`.`id` DESC [2020-09-02T18:34:55+08:00][sql] CONNECT:[ UseTime:0.030998s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:34:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022830s ] [2020-09-02T18:34:55+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 749 LIMIT 1 [ RunTime:0.020252s ] [2020-09-02T18:34:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.020360s ] [2020-09-02T18:34:55+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019798s ] [2020-09-02T18:34:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020505s ] [2020-09-02T18:34:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 749 [ RunTime:0.019746s ] [2020-09-02T18:34:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.020080s ] [2020-09-02T18:34:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 749 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.019895s ] [2020-09-02T18:34:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.020167s ] [2020-09-02T18:34:55+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=749 ) ORDER BY `c`.`id` DESC [ RunTime:0.020086s ] [2020-09-02T18:34:55+08:00][DEBUG] [ 2020-09-02T18:34:55+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=749 ) ORDER BY `c`.`id` DESC [2020-09-02T18:35:00+08:00][sql] CONNECT:[ UseTime:0.029638s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021168s ] [2020-09-02T18:35:00+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 796 LIMIT 1 [ RunTime:0.019577s ] [2020-09-02T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019849s ] [2020-09-02T18:35:00+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019281s ] [2020-09-02T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020353s ] [2020-09-02T18:35:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 796 [ RunTime:0.019684s ] [2020-09-02T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019619s ] [2020-09-02T18:35:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 796 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.019306s ] [2020-09-02T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019667s ] [2020-09-02T18:35:00+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=796 ) ORDER BY `c`.`id` DESC [ RunTime:0.019512s ] [2020-09-02T18:35:00+08:00][DEBUG] [ 2020-09-02T18:35:00+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=796 ) ORDER BY `c`.`id` DESC [2020-09-02T18:35:14+08:00][sql] CONNECT:[ UseTime:0.026355s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:35:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.018901s ] [2020-09-02T18:35:14+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 910 LIMIT 1 [ RunTime:0.025556s ] [2020-09-02T18:35:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017472s ] [2020-09-02T18:35:14+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017854s ] [2020-09-02T18:35:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017267s ] [2020-09-02T18:35:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 910 [ RunTime:0.017229s ] [2020-09-02T18:35:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017249s ] [2020-09-02T18:35:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 910 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.016939s ] [2020-09-02T18:35:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017346s ] [2020-09-02T18:35:14+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=910 ) ORDER BY `c`.`id` DESC [ RunTime:0.017116s ] [2020-09-02T18:35:14+08:00][DEBUG] [ 2020-09-02T18:35:14+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=910 ) ORDER BY `c`.`id` DESC [2020-09-02T18:35:24+08:00][sql] CONNECT:[ UseTime:0.027675s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:35:24+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.018892s ] [2020-09-02T18:35:24+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 910 LIMIT 1 [ RunTime:0.025893s ] [2020-09-02T18:35:24+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018015s ] [2020-09-02T18:35:24+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.016960s ] [2020-09-02T18:35:24+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017333s ] [2020-09-02T18:35:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 910 [ RunTime:0.018348s ] [2020-09-02T18:35:24+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017476s ] [2020-09-02T18:35:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 910 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017032s ] [2020-09-02T18:35:24+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017394s ] [2020-09-02T18:35:24+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=910 ) ORDER BY `c`.`id` DESC [ RunTime:0.017276s ] [2020-09-02T18:35:24+08:00][DEBUG] [ 2020-09-02T18:35:24+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=910 ) ORDER BY `c`.`id` DESC [2020-09-02T18:35:33+08:00][sql] CONNECT:[ UseTime:0.028832s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:35:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022602s ] [2020-09-02T18:35:33+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 945 LIMIT 1 [ RunTime:0.018915s ] [2020-09-02T18:35:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019261s ] [2020-09-02T18:35:33+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.018700s ] [2020-09-02T18:35:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019129s ] [2020-09-02T18:35:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 945 [ RunTime:0.019085s ] [2020-09-02T18:35:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019122s ] [2020-09-02T18:35:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 945 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.018802s ] [2020-09-02T18:35:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019151s ] [2020-09-02T18:35:33+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=945 ) ORDER BY `c`.`id` DESC [ RunTime:0.018979s ] [2020-09-02T18:35:33+08:00][DEBUG] [ 2020-09-02T18:35:33+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=945 ) ORDER BY `c`.`id` DESC [2020-09-02T18:35:36+08:00][sql] CONNECT:[ UseTime:0.029453s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:35:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020444s ] [2020-09-02T18:35:36+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 408 LIMIT 1 [ RunTime:0.018862s ] [2020-09-02T18:35:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019142s ] [2020-09-02T18:35:36+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.018579s ] [2020-09-02T18:35:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018917s ] [2020-09-02T18:35:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 408 [ RunTime:0.018932s ] [2020-09-02T18:35:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018919s ] [2020-09-02T18:35:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 408 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.018647s ] [2020-09-02T18:35:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018984s ] [2020-09-02T18:35: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=408 ) ORDER BY `c`.`id` DESC [ RunTime:0.018952s ] [2020-09-02T18:35:36+08:00][DEBUG] [ 2020-09-02T18:35: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=408 ) ORDER BY `c`.`id` DESC [2020-09-02T18:38:40+08:00][DEBUG] [ 2020-09-02T18:38:40+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-02T18:40:01+08:00][sql] CONNECT:[ UseTime:0.026465s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018282s ] [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 18:33:49' [ RunTime:0.018678s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 18:33:49' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 800 , `ctime` = '2020-09-02 18:33:54' [ RunTime:0.017283s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 800 , `ctime` = '2020-09-02 18:33:54' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 800 , `ctime` = '2020-09-02 18:33:56' [ RunTime:0.016958s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 800 , `ctime` = '2020-09-02 18:33:56' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 798 , `ctime` = '2020-09-02 18:34:07' [ RunTime:0.016871s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 798 , `ctime` = '2020-09-02 18:34:07' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 799 , `ctime` = '2020-09-02 18:34:15' [ RunTime:0.016843s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 799 , `ctime` = '2020-09-02 18:34:15' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 798 , `ctime` = '2020-09-02 18:34:20' [ RunTime:0.016816s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 798 , `ctime` = '2020-09-02 18:34:20' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 799 , `ctime` = '2020-09-02 18:34:27' [ RunTime:0.016817s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 799 , `ctime` = '2020-09-02 18:34:27' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 613 , `ctime` = '2020-09-02 18:34:40' [ RunTime:0.016841s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 613 , `ctime` = '2020-09-02 18:34:40' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 801 , `ctime` = '2020-09-02 18:34:42' [ RunTime:0.016820s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 801 , `ctime` = '2020-09-02 18:34:42' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 794 , `ctime` = '2020-09-02 18:34:50' [ RunTime:0.016778s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 794 , `ctime` = '2020-09-02 18:34:50' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 749 , `ctime` = '2020-09-02 18:34:54' [ RunTime:0.017245s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 749 , `ctime` = '2020-09-02 18:34:54' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 796 , `ctime` = '2020-09-02 18:34:59' [ RunTime:0.016870s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 796 , `ctime` = '2020-09-02 18:34:59' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 910 , `ctime` = '2020-09-02 18:35:14' [ RunTime:0.016907s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 910 , `ctime` = '2020-09-02 18:35:14' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 910 , `ctime` = '2020-09-02 18:35:24' [ RunTime:0.016859s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 910 , `ctime` = '2020-09-02 18:35:24' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 945 , `ctime` = '2020-09-02 18:35:33' [ RunTime:0.016765s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 945 , `ctime` = '2020-09-02 18:35:33' [2020-09-02T18:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 408 , `ctime` = '2020-09-02 18:35:36' [ RunTime:0.016819s ] [2020-09-02T18:40:01+08:00][DEBUG] [ 2020-09-02T18:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 408 , `ctime` = '2020-09-02 18:35:36' [2020-09-02T18:40:52+08:00][sql] CONNECT:[ UseTime:0.026567s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:40:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.018747s ] [2020-09-02T18:40:52+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE `t1`.`phone` = '17858409880' LIMIT 1 [ RunTime:0.017334s ] [2020-09-02T18:40:52+08:00][DEBUG] [ 2020-09-02T18:40:52+08:00 ] rediskey17858409880_signin_verify [2020-09-02T18:41:10+08:00][sql] CONNECT:[ UseTime:0.029828s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:41:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021181s ] [2020-09-02T18:41:10+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081003209' AND `status` = '上线' LIMIT 1 [ RunTime:0.019158s ] [2020-09-02T18:41:10+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 463 LIMIT 1 [ RunTime:0.019321s ] [2020-09-02T18:41:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019779s ] [2020-09-02T18:41:10+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019107s ] [2020-09-02T18:41:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019455s ] [2020-09-02T18:41:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 463 [ RunTime:0.019542s ] [2020-09-02T18:41:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019503s ] [2020-09-02T18:41:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 463 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.019115s ] [2020-09-02T18:41:10+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019552s ] [2020-09-02T18:41: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=463 ) ORDER BY `c`.`id` DESC [ RunTime:0.019433s ] [2020-09-02T18:41:10+08:00][DEBUG] [ 2020-09-02T18:41: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=463 ) ORDER BY `c`.`id` DESC [2020-09-02T18:50:02+08:00][sql] CONNECT:[ UseTime:0.028445s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T18:50:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020158s ] [2020-09-02T18:50:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 18:41:09' [ RunTime:0.019448s ] [2020-09-02T18:50:02+08:00][DEBUG] [ 2020-09-02T18:50:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 18:41:09' [2020-09-02T19:14:57+08:00][sql] CONNECT:[ UseTime:0.027185s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:14:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019131s ] [2020-09-02T19:14:57+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081003207' AND `status` = '上线' LIMIT 1 [ RunTime:0.017482s ] [2020-09-02T19:14:57+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 435 LIMIT 1 [ RunTime:0.017560s ] [2020-09-02T19:14:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017796s ] [2020-09-02T19:14:57+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017189s ] [2020-09-02T19:14:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017605s ] [2020-09-02T19:14:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 435 [ RunTime:0.018023s ] [2020-09-02T19:14:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017597s ] [2020-09-02T19:14:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 435 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017237s ] [2020-09-02T19:14:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017618s ] [2020-09-02T19:14:57+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=435 ) ORDER BY `c`.`id` DESC [ RunTime:0.017477s ] [2020-09-02T19:14:57+08:00][DEBUG] [ 2020-09-02T19:14:57+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=435 ) ORDER BY `c`.`id` DESC [2020-09-02T19:15:04+08:00][sql] CONNECT:[ UseTime:0.030102s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:15:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021084s ] [2020-09-02T19:15:04+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 440 LIMIT 1 [ RunTime:0.019403s ] [2020-09-02T19:15:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.020038s ] [2020-09-02T19:15:04+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019127s ] [2020-09-02T19:15:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.019729s ] [2020-09-02T19:15:04+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 440 [ RunTime:0.019475s ] [2020-09-02T19:15:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.019630s ] [2020-09-02T19:15:04+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 440 AND `consult_id` = 1060 [ RunTime:0.019174s ] [2020-09-02T19:15:04+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 440 AND `consult_id` = 1061 [ RunTime:0.019298s ] [2020-09-02T19:15:04+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 440 AND `consult_id` = 1062 [ RunTime:0.019146s ] [2020-09-02T19:15:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019489s ] [2020-09-02T19:15:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 440 [ RunTime:0.019612s ] [2020-09-02T19:15:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019546s ] [2020-09-02T19:15:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 440 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.019225s ] [2020-09-02T19:15:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019551s ] [2020-09-02T19:15:04+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=440 ) ORDER BY `c`.`id` DESC [ RunTime:0.019488s ] [2020-09-02T19:15:04+08:00][DEBUG] [ 2020-09-02T19:15:04+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=440 ) ORDER BY `c`.`id` DESC [2020-09-02T19:15:09+08:00][sql] CONNECT:[ UseTime:0.029920s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:15:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021011s ] [2020-09-02T19:15:09+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 311 LIMIT 1 [ RunTime:0.019282s ] [2020-09-02T19:15:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019760s ] [2020-09-02T19:15:09+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019033s ] [2020-09-02T19:15:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.019430s ] [2020-09-02T19:15:09+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 311 [ RunTime:0.019471s ] [2020-09-02T19:15:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.019440s ] [2020-09-02T19:15:09+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 311 AND `consult_id` = 1958 [ RunTime:0.019758s ] [2020-09-02T19:15:09+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 311 AND `consult_id` = 1959 [ RunTime:0.019145s ] [2020-09-02T19:15:09+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 311 AND `consult_id` = 1960 [ RunTime:0.019061s ] [2020-09-02T19:15:09+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 311 AND `consult_id` = 1961 [ RunTime:0.019045s ] [2020-09-02T19:15:09+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 311 AND `consult_id` = 1962 [ RunTime:0.019073s ] [2020-09-02T19:15:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019405s ] [2020-09-02T19:15:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 311 [ RunTime:0.019427s ] [2020-09-02T19:15:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019416s ] [2020-09-02T19:15:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 311 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.019478s ] [2020-09-02T19:15:09+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019574s ] [2020-09-02T19:15: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=311 ) ORDER BY `c`.`id` DESC [ RunTime:0.019292s ] [2020-09-02T19:15:09+08:00][DEBUG] [ 2020-09-02T19:15: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=311 ) ORDER BY `c`.`id` DESC [2020-09-02T19:15:14+08:00][sql] CONNECT:[ UseTime:0.029854s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:15:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.021117s ] [2020-09-02T19:15:14+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 443 LIMIT 1 [ RunTime:0.019311s ] [2020-09-02T19:15:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019633s ] [2020-09-02T19:15:14+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019024s ] [2020-09-02T19:15:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019455s ] [2020-09-02T19:15:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 443 [ RunTime:0.019380s ] [2020-09-02T19:15:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019401s ] [2020-09-02T19:15:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 443 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.019066s ] [2020-09-02T19:15:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019453s ] [2020-09-02T19:15:14+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=443 ) ORDER BY `c`.`id` DESC [ RunTime:0.019412s ] [2020-09-02T19:15:14+08:00][DEBUG] [ 2020-09-02T19:15:14+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=443 ) ORDER BY `c`.`id` DESC [2020-09-02T19:15:19+08:00][sql] CONNECT:[ UseTime:0.026088s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:15:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022216s ] [2020-09-02T19:15:19+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 444 LIMIT 1 [ RunTime:0.016880s ] [2020-09-02T19:15:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017243s ] [2020-09-02T19:15:19+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.016464s ] [2020-09-02T19:15:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.016933s ] [2020-09-02T19:15:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 444 [ RunTime:0.016836s ] [2020-09-02T19:15:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.016916s ] [2020-09-02T19:15:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 444 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.016599s ] [2020-09-02T19:15:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.016890s ] [2020-09-02T19:15:19+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=444 ) ORDER BY `c`.`id` DESC [ RunTime:0.016749s ] [2020-09-02T19:15:19+08:00][DEBUG] [ 2020-09-02T19:15:19+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=444 ) ORDER BY `c`.`id` DESC [2020-09-02T19:15:28+08:00][sql] CONNECT:[ UseTime:0.026904s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:15:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019028s ] [2020-09-02T19:15:28+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 921 LIMIT 1 [ RunTime:0.017476s ] [2020-09-02T19:15:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017607s ] [2020-09-02T19:15:28+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017071s ] [2020-09-02T19:15:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017409s ] [2020-09-02T19:15:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 921 [ RunTime:0.017408s ] [2020-09-02T19:15:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017393s ] [2020-09-02T19:15:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 921 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017397s ] [2020-09-02T19:15:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017467s ] [2020-09-02T19:15:28+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=921 ) ORDER BY `c`.`id` DESC [ RunTime:0.017454s ] [2020-09-02T19:15:28+08:00][DEBUG] [ 2020-09-02T19:15:28+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=921 ) ORDER BY `c`.`id` DESC [2020-09-02T19:15:33+08:00][sql] CONNECT:[ UseTime:0.026414s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:15:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.018428s ] [2020-09-02T19:15:33+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 611 LIMIT 1 [ RunTime:0.016888s ] [2020-09-02T19:15:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.017153s ] [2020-09-02T19:15:33+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.016726s ] [2020-09-02T19:15:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.016837s ] [2020-09-02T19:15:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 611 [ RunTime:0.017062s ] [2020-09-02T19:15:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.016912s ] [2020-09-02T19:15:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 611 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.016649s ] [2020-09-02T19:15:33+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.016957s ] [2020-09-02T19:15:33+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=611 ) ORDER BY `c`.`id` DESC [ RunTime:0.016978s ] [2020-09-02T19:15:33+08:00][DEBUG] [ 2020-09-02T19:15:33+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=611 ) ORDER BY `c`.`id` DESC [2020-09-02T19:18:14+08:00][sql] CONNECT:[ UseTime:0.027305s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:18:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019351s ] [2020-09-02T19:18:14+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081003206' AND `status` = '上线' LIMIT 1 [ RunTime:0.018527s ] [2020-09-02T19:18:14+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 468 LIMIT 1 [ RunTime:0.017684s ] [2020-09-02T19:18:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018019s ] [2020-09-02T19:18:14+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017385s ] [2020-09-02T19:18:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017759s ] [2020-09-02T19:18:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 468 [ RunTime:0.018317s ] [2020-09-02T19:18:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017833s ] [2020-09-02T19:18:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 468 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017688s ] [2020-09-02T19:18:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017905s ] [2020-09-02T19:18:14+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=468 ) ORDER BY `c`.`id` DESC [ RunTime:0.017797s ] [2020-09-02T19:18:14+08:00][DEBUG] [ 2020-09-02T19:18:14+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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=468 ) ORDER BY `c`.`id` DESC [2020-09-02T19:20:02+08:00][sql] CONNECT:[ UseTime:0.026463s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018356s ] [2020-09-02T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 19:14:57' [ RunTime:0.019435s ] [2020-09-02T19:20:02+08:00][DEBUG] [ 2020-09-02T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 19:14:57' [2020-09-02T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 440 , `ctime` = '2020-09-02 19:15:04' [ RunTime:0.018435s ] [2020-09-02T19:20:02+08:00][DEBUG] [ 2020-09-02T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 440 , `ctime` = '2020-09-02 19:15:04' [2020-09-02T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 311 , `ctime` = '2020-09-02 19:15:09' [ RunTime:0.020145s ] [2020-09-02T19:20:02+08:00][DEBUG] [ 2020-09-02T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 311 , `ctime` = '2020-09-02 19:15:09' [2020-09-02T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 443 , `ctime` = '2020-09-02 19:15:14' [ RunTime:0.017078s ] [2020-09-02T19:20:02+08:00][DEBUG] [ 2020-09-02T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 443 , `ctime` = '2020-09-02 19:15:14' [2020-09-02T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 444 , `ctime` = '2020-09-02 19:15:19' [ RunTime:0.016807s ] [2020-09-02T19:20:02+08:00][DEBUG] [ 2020-09-02T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 444 , `ctime` = '2020-09-02 19:15:19' [2020-09-02T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 921 , `ctime` = '2020-09-02 19:15:28' [ RunTime:0.016800s ] [2020-09-02T19:20:02+08:00][DEBUG] [ 2020-09-02T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 921 , `ctime` = '2020-09-02 19:15:28' [2020-09-02T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 611 , `ctime` = '2020-09-02 19:15:33' [ RunTime:0.016769s ] [2020-09-02T19:20:02+08:00][DEBUG] [ 2020-09-02T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 611 , `ctime` = '2020-09-02 19:15:33' [2020-09-02T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 19:18:14' [ RunTime:0.016765s ] [2020-09-02T19:20:02+08:00][DEBUG] [ 2020-09-02T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 19:18:14' [2020-09-02T19:26:11+08:00][sql] CONNECT:[ UseTime:0.028012s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:26:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019830s ] [2020-09-02T19:26:11+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081003204' AND `status` = '上线' LIMIT 1 [ RunTime:0.018223s ] [2020-09-02T19:26:11+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 475 LIMIT 1 [ RunTime:0.018162s ] [2020-09-02T19:26:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018442s ] [2020-09-02T19:26:11+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017855s ] [2020-09-02T19:26:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018248s ] [2020-09-02T19:26:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 475 [ RunTime:0.018309s ] [2020-09-02T19:26:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018250s ] [2020-09-02T19:26:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 475 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017971s ] [2020-09-02T19:26:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018301s ] [2020-09-02T19:26: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=475 ) ORDER BY `c`.`id` DESC [ RunTime:0.018204s ] [2020-09-02T19:26:11+08:00][DEBUG] [ 2020-09-02T19:26: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=475 ) ORDER BY `c`.`id` DESC [2020-09-02T19:26:37+08:00][sql] CONNECT:[ UseTime:0.027751s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:26:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019596s ] [2020-09-02T19:26:37+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 95 LIMIT 1 [ RunTime:0.018082s ] [2020-09-02T19:26:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018445s ] [2020-09-02T19:26:37+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017722s ] [2020-09-02T19:26:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018110s ] [2020-09-02T19:26:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 95 [ RunTime:0.018137s ] [2020-09-02T19:26:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018181s ] [2020-09-02T19:26:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 95 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017785s ] [2020-09-02T19:26:37+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018210s ] [2020-09-02T19:26: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=95 ) ORDER BY `c`.`id` DESC [ RunTime:0.018124s ] [2020-09-02T19:26:37+08:00][DEBUG] [ 2020-09-02T19:26: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='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=95 ) ORDER BY `c`.`id` DESC [2020-09-02T19:30:01+08:00][sql] CONNECT:[ UseTime:0.027258s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-02T19:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018646s ] [2020-09-02T19:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 19:26:11' [ RunTime:0.018359s ] [2020-09-02T19:30:01+08:00][DEBUG] [ 2020-09-02T19:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 153 , `ctime` = '2020-09-02 19:26:11' [2020-09-02T19:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 95 , `ctime` = '2020-09-02 19:26:37' [ RunTime:0.017942s ] [2020-09-02T19:30:01+08:00][DEBUG] [ 2020-09-02T19:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 95 , `ctime` = '2020-09-02 19:26:37'