[2020-08-26T14:36:58+08:00][sql] CONNECT:[ UseTime:0.029544s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-08-26T14:36:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020788s ] [2020-08-26T14:36:58+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 124 LIMIT 1 [ RunTime:0.019130s ] [2020-08-26T14:36:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.019503s ] [2020-08-26T14:36:58+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.018821s ] [2020-08-26T14:36:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.019342s ] [2020-08-26T14:36:58+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 124 [ RunTime:0.018998s ] [2020-08-26T14:36:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.019392s ] [2020-08-26T14:36:58+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 124 AND `consult_id` = 688 [ RunTime:0.018831s ] [2020-08-26T14:36:58+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 124 AND `consult_id` = 689 [ RunTime:0.018840s ] [2020-08-26T14:36:58+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 124 AND `consult_id` = 690 [ RunTime:0.018852s ] [2020-08-26T14:36:58+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 124 AND `consult_id` = 691 [ RunTime:0.018902s ] [2020-08-26T14:36:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019201s ] [2020-08-26T14:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 124 [ RunTime:0.018775s ] [2020-08-26T14:36:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.019152s ] [2020-08-26T14:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 124 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.018950s ] [2020-08-26T14:36:58+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.019309s ] [2020-08-26T14:36:58+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=124 ) ORDER BY `c`.`id` DESC [ RunTime:0.019127s ] [2020-08-26T14:36:58+08:00][DEBUG] [ 2020-08-26T14:36:58+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='796305d1d9d140a68f5c9175c32444ea' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=124 ) ORDER BY `c`.`id` DESC [2020-08-26T14:37:02+08:00][sql] CONNECT:[ UseTime:0.027403s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-08-26T14:37:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019420s ] [2020-08-26T14:37:02+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 124 LIMIT 1 [ RunTime:0.017624s ] [2020-08-26T14:37:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018209s ] [2020-08-26T14:37:02+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017510s ] [2020-08-26T14:37:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.017956s ] [2020-08-26T14:37:02+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 124 [ RunTime:0.018125s ] [2020-08-26T14:37:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.017924s ] [2020-08-26T14:37:02+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 124 AND `consult_id` = 688 [ RunTime:0.017529s ] [2020-08-26T14:37:02+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 124 AND `consult_id` = 689 [ RunTime:0.017578s ] [2020-08-26T14:37:02+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 124 AND `consult_id` = 690 [ RunTime:0.017724s ] [2020-08-26T14:37:02+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 124 AND `consult_id` = 691 [ RunTime:0.017458s ] [2020-08-26T14:37:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017804s ] [2020-08-26T14:37:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 124 [ RunTime:0.017477s ] [2020-08-26T14:37:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017852s ] [2020-08-26T14:37:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 124 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017477s ] [2020-08-26T14:37:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.017923s ] [2020-08-26T14:37:02+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=124 ) ORDER BY `c`.`id` DESC [ RunTime:0.017596s ] [2020-08-26T14:37:02+08:00][DEBUG] [ 2020-08-26T14:37:02+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=124 ) ORDER BY `c`.`id` DESC [2020-08-26T14:37:19+08:00][sql] CONNECT:[ UseTime:0.027792s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-08-26T14:37:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019558s ] [2020-08-26T14:37:19+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 123 LIMIT 1 [ RunTime:0.017876s ] [2020-08-26T14:37:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018280s ] [2020-08-26T14:37:19+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.017647s ] [2020-08-26T14:37:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.018242s ] [2020-08-26T14:37:19+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 123 [ RunTime:0.017636s ] [2020-08-26T14:37:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.018067s ] [2020-08-26T14:37:19+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 123 AND `consult_id` = 692 [ RunTime:0.017700s ] [2020-08-26T14:37:19+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 123 AND `consult_id` = 693 [ RunTime:0.017637s ] [2020-08-26T14:37:19+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 123 AND `consult_id` = 694 [ RunTime:0.017658s ] [2020-08-26T14:37:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.017973s ] [2020-08-26T14:37:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 123 [ RunTime:0.017589s ] [2020-08-26T14:37:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.017967s ] [2020-08-26T14:37:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 123 AND `uuid` = '796305d1d9d140a68f5c9175c32444ea' [ RunTime:0.017730s ] [2020-08-26T14:37:19+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018074s ] [2020-08-26T14:37: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=123 ) ORDER BY `c`.`id` DESC [ RunTime:0.017935s ] [2020-08-26T14:37:19+08:00][DEBUG] [ 2020-08-26T14:37: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=123 ) ORDER BY `c`.`id` DESC [2020-08-26T14:40:02+08:00][sql] CONNECT:[ UseTime:0.027124s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-08-26T14:40:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018948s ] [2020-08-26T14:40:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 124 , `ctime` = '2020-08-26 14:36:58' [ RunTime:0.019035s ] [2020-08-26T14:40:02+08:00][DEBUG] [ 2020-08-26T14:40:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 124 , `ctime` = '2020-08-26 14:36:58' [2020-08-26T14:40:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 124 , `ctime` = '2020-08-26 14:37:01' [ RunTime:0.017770s ] [2020-08-26T14:40:02+08:00][DEBUG] [ 2020-08-26T14:40:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 124 , `ctime` = '2020-08-26 14:37:01' [2020-08-26T14:40:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 123 , `ctime` = '2020-08-26 14:37:19' [ RunTime:0.017319s ] [2020-08-26T14:40:02+08:00][DEBUG] [ 2020-08-26T14:40:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '796305d1d9d140a68f5c9175c32444ea' , `c_id` = 123 , `ctime` = '2020-08-26 14:37:19'