[2021-04-13T09:03:55+08:00][sql] CONNECT:[ UseTime:0.031019s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T09:03:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021235s ] [2021-04-13T09:03:55+08:00][DEBUG] [ 2021-04-13T09:03:55+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T09:04:28+08:00][sql] CONNECT:[ UseTime:0.030773s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T09:04:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021320s ] [2021-04-13T09:04:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020872s ] [2021-04-13T09:04:28+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`name`,`t1`.`manage_region_code`,`t1`.`nick_name`,`t1`.`pics`,`t3`.`sex`,`t1`.`phone`,`t1`.`passwd`,`t1`.`is_on`,`t1`.`first_login`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`is_jiwei`,`t2`.`role_id`,`t3`.`peopletype`,`t3`.`political`,`t3`.`cardid`,`t3`.`is_volunteer` FROM `swgk_user` `t1` LEFT JOIN `swgk_user_role` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `swgk_base_ppl` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE `t1`.`phone` = '13867680067' LIMIT 1 [ RunTime:0.024321s ] [2021-04-13T09:04:28+08:00][DEBUG] [ 2021-04-13T09:04:28+08:00 ] rediskey13867680067_signin_verify [2021-04-13T09:04:28+08:00][DEBUG] [ 2021-04-13T09:04:28+08:00 ] session11 [2021-04-13T09:04:28+08:00][WARN] [ 2021-04-13T09:04:28+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-04-13T09:40:01+08:00][sql] CONNECT:[ UseTime:0.035548s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T09:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.024437s ] [2021-04-13T09:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'c49cb677b179406b9ecd0e412837bbf8' , `c_id` = 153 , `ctime` = '2021-04-13 09:39:07' [ RunTime:0.024612s ] [2021-04-13T09:40:01+08:00][DEBUG] [ 2021-04-13T09:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'c49cb677b179406b9ecd0e412837bbf8' , `c_id` = 153 , `ctime` = '2021-04-13 09:39:07' [2021-04-13T09:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'c49cb677b179406b9ecd0e412837bbf8' , `c_id` = 153 , `ctime` = '2021-04-13 09:39:28' [ RunTime:0.023594s ] [2021-04-13T09:40:01+08:00][DEBUG] [ 2021-04-13T09:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'c49cb677b179406b9ecd0e412837bbf8' , `c_id` = 153 , `ctime` = '2021-04-13 09:39:28' [2021-04-13T10:12:08+08:00][sql] CONNECT:[ UseTime:0.034382s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T10:12:08+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.035394s ] [2021-04-13T10:12:08+08:00][DEBUG] [ 2021-04-13T10:12:08+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T11:04:02+08:00][DEBUG] [ 2021-04-13T11:04:02+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T11:06:05+08:00][DEBUG] [ 2021-04-13T11:06:05+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T11:07:32+08:00][DEBUG] [ 2021-04-13T11:07:32+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T11:09:22+08:00][sql] CONNECT:[ UseTime:0.030994s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T11:09:22+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021649s ] [2021-04-13T11:09:22+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` = '13586266096' LIMIT 1 [ RunTime:0.021967s ] [2021-04-13T11:09:22+08:00][DEBUG] [ 2021-04-13T11:09:22+08:00 ] rediskey13586266096_signin_verify [2021-04-13T11:09:57+08:00][sql] CONNECT:[ UseTime:0.031476s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T11:09:57+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022146s ] [2021-04-13T11:09:57+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` = '13586266096' LIMIT 1 [ RunTime:0.023116s ] [2021-04-13T11:09:57+08:00][DEBUG] [ 2021-04-13T11:09:57+08:00 ] rediskey13586266096_signin_verify [2021-04-13T11:09:57+08:00][DEBUG] [ 2021-04-13T11:09:57+08:00 ] session11 [2021-04-13T11:09:57+08:00][WARN] [ 2021-04-13T11:09:57+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2021-04-13T11:11:26+08:00][DEBUG] [ 2021-04-13T11:11:26+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T15:24:36+08:00][DEBUG] [ 2021-04-13T15:24:36+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T15:25:04+08:00][sql] CONNECT:[ UseTime:0.031393s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T15:25:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022034s ] [2021-04-13T15:25:04+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` = '15988903986' LIMIT 1 [ RunTime:0.023001s ] [2021-04-13T15:25:04+08:00][DEBUG] [ 2021-04-13T15:25:03+08:00 ] rediskey15988903986_signin_verify [2021-04-13T15:30:01+08:00][sql] CONNECT:[ UseTime:0.032266s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T15:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.022431s ] [2021-04-13T15:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '627f6bff42c4449785613b605f6868de' , `c_id` = 153 , `ctime` = '2021-04-13 15:27:16' [ RunTime:0.022398s ] [2021-04-13T15:30:01+08:00][DEBUG] [ 2021-04-13T15:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '627f6bff42c4449785613b605f6868de' , `c_id` = 153 , `ctime` = '2021-04-13 15:27:16' [2021-04-13T15:40:01+08:00][sql] CONNECT:[ UseTime:0.031751s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T15:40:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.022220s ] [2021-04-13T15:40:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '627f6bff42c4449785613b605f6868de' , `c_id` = 153 , `ctime` = '2021-04-13 15:34:21' [ RunTime:0.023228s ] [2021-04-13T15:40:01+08:00][DEBUG] [ 2021-04-13T15:40:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '627f6bff42c4449785613b605f6868de' , `c_id` = 153 , `ctime` = '2021-04-13 15:34:21' [2021-04-13T17:38:02+08:00][DEBUG] [ 2021-04-13T17:38:02+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T18:23:56+08:00][sql] CONNECT:[ UseTime:0.031853s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T18:23:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.023710s ] [2021-04-13T18:23:56+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 3604 LIMIT 1 [ RunTime:0.020771s ] [2021-04-13T18:23:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.020894s ] [2021-04-13T18:23:56+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '5bde9c4e54ca47e0bb79c8b7a41dcefa' LIMIT 1 [ RunTime:0.020423s ] [2021-04-13T18:23:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020724s ] [2021-04-13T18:23:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 3604 [ RunTime:0.021207s ] [2021-04-13T18:23:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.020873s ] [2021-04-13T18:23:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 3604 AND `uuid` = 'c962c4ab13214a469fe2a52b5fb3237c' [ RunTime:0.020329s ] [2021-04-13T18:23:56+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.020922s ] [2021-04-13T18:23: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='c962c4ab13214a469fe2a52b5fb3237c' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=3604 ) ORDER BY `c`.`id` DESC [ RunTime:0.020706s ] [2021-04-13T18:23:56+08:00][DEBUG] [ 2021-04-13T18:23: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='c962c4ab13214a469fe2a52b5fb3237c' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=3604 ) ORDER BY `c`.`id` DESC [2021-04-13T18:30:01+08:00][sql] CONNECT:[ UseTime:0.031459s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T18:30:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.021955s ] [2021-04-13T18:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'c962c4ab13214a469fe2a52b5fb3237c' , `c_id` = 153 , `ctime` = '2021-04-13 18:23:46' [ RunTime:0.021888s ] [2021-04-13T18:30:01+08:00][DEBUG] [ 2021-04-13T18:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'c962c4ab13214a469fe2a52b5fb3237c' , `c_id` = 153 , `ctime` = '2021-04-13 18:23:46' [2021-04-13T18:30:01+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'c962c4ab13214a469fe2a52b5fb3237c' , `c_id` = 3604 , `ctime` = '2021-04-13 18:23:56' [ RunTime:0.020980s ] [2021-04-13T18:30:01+08:00][DEBUG] [ 2021-04-13T18:30:01+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'c962c4ab13214a469fe2a52b5fb3237c' , `c_id` = 3604 , `ctime` = '2021-04-13 18:23:56' [2021-04-13T19:07:23+08:00][sql] CONNECT:[ UseTime:0.033754s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T19:07:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.023684s ] [2021-04-13T19:07:23+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 2729 LIMIT 1 [ RunTime:0.022089s ] [2021-04-13T19:07:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.022301s ] [2021-04-13T19:07:23+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '9216e373427841c5aaf1d3dee8b58af3' LIMIT 1 [ RunTime:0.021810s ] [2021-04-13T19:07:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.022096s ] [2021-04-13T19:07:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 2729 [ RunTime:0.022410s ] [2021-04-13T19:07:23+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.022076s ] [2021-04-13T19:07: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.status='上线' AND c.c_id=2729 ) ORDER BY `c`.`id` DESC [ RunTime:0.021862s ] [2021-04-13T19:07:23+08:00][DEBUG] [ 2021-04-13T19:07: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.status='上线' AND c.c_id=2729 ) ORDER BY `c`.`id` DESC [2021-04-13T19:09:45+08:00][sql] CONNECT:[ UseTime:0.031828s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T19:09:45+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022465s ] [2021-04-13T19:09:45+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 2653 LIMIT 1 [ RunTime:0.031927s ] [2021-04-13T19:09:45+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.021699s ] [2021-04-13T19:09:45+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '9216e373427841c5aaf1d3dee8b58af3' LIMIT 1 [ RunTime:0.020398s ] [2021-04-13T19:09:45+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020858s ] [2021-04-13T19:09:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 2653 [ RunTime:0.021931s ] [2021-04-13T19:09:45+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.020935s ] [2021-04-13T19:09:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 2653 AND `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' [ RunTime:0.020433s ] [2021-04-13T19:09:45+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.020836s ] [2021-04-13T19:09:45+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='fe71c5980d404960bf4ca736f77a8bbd' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=2653 ) ORDER BY `c`.`id` DESC [ RunTime:0.020742s ] [2021-04-13T19:09:45+08:00][DEBUG] [ 2021-04-13T19:09:45+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='fe71c5980d404960bf4ca736f77a8bbd' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=2653 ) ORDER BY `c`.`id` DESC [2021-04-13T19:09:49+08:00][sql] CONNECT:[ UseTime:0.032865s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T19:09:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.022436s ] [2021-04-13T19:09:49+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 2652 LIMIT 1 [ RunTime:0.021323s ] [2021-04-13T19:09:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.021103s ] [2021-04-13T19:09:49+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '9216e373427841c5aaf1d3dee8b58af3' LIMIT 1 [ RunTime:0.020257s ] [2021-04-13T19:09:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult` [ RunTime:0.021000s ] [2021-04-13T19:09:49+08:00][sql] SELECT `id`,`name`,`position`,`phone`,`mark`,`pics` FROM `swgk_consult` WHERE `content_id` = 2652 [ RunTime:0.021127s ] [2021-04-13T19:09:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_consult_feedback` [ RunTime:0.020930s ] [2021-04-13T19:09:49+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 2652 AND `consult_id` = 3157 [ RunTime:0.020384s ] [2021-04-13T19:09:49+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 2652 AND `consult_id` = 3158 [ RunTime:0.020566s ] [2021-04-13T19:09:49+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 2652 AND `consult_id` = 3159 [ RunTime:0.020402s ] [2021-04-13T19:09:49+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 2652 AND `consult_id` = 3160 [ RunTime:0.020577s ] [2021-04-13T19:09:49+08:00][sql] SELECT `operator_uuid` FROM `swgk_consult_feedback` WHERE `content_id` = 2652 AND `consult_id` = 3161 [ RunTime:0.020567s ] [2021-04-13T19:09:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020915s ] [2021-04-13T19:09:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 2652 [ RunTime:0.021449s ] [2021-04-13T19:09:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.020731s ] [2021-04-13T19:09:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 2652 AND `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' [ RunTime:0.021511s ] [2021-04-13T19:09:49+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.020979s ] [2021-04-13T19:09:49+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='fe71c5980d404960bf4ca736f77a8bbd' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=2652 ) ORDER BY `c`.`id` DESC [ RunTime:0.021240s ] [2021-04-13T19:09:49+08:00][DEBUG] [ 2021-04-13T19:09:49+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='fe71c5980d404960bf4ca736f77a8bbd' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=2652 ) ORDER BY `c`.`id` DESC [2021-04-13T19:10:02+08:00][sql] CONNECT:[ UseTime:0.032097s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T19:10:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.021541s ] [2021-04-13T19:10:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' , `c_id` = 2729 , `ctime` = '2021-04-13 19:07:23' [ RunTime:0.021427s ] [2021-04-13T19:10:02+08:00][DEBUG] [ 2021-04-13T19:10:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' , `c_id` = 2729 , `ctime` = '2021-04-13 19:07:23' [2021-04-13T19:10:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' , `c_id` = 2653 , `ctime` = '2021-04-13 19:09:45' [ RunTime:0.020741s ] [2021-04-13T19:10:02+08:00][DEBUG] [ 2021-04-13T19:10:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' , `c_id` = 2653 , `ctime` = '2021-04-13 19:09:45' [2021-04-13T19:10:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' , `c_id` = 2652 , `ctime` = '2021-04-13 19:09:49' [ RunTime:0.020109s ] [2021-04-13T19:10:02+08:00][DEBUG] [ 2021-04-13T19:10:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' , `c_id` = 2652 , `ctime` = '2021-04-13 19:09:49' [2021-04-13T19:10:07+08:00][sql] CONNECT:[ UseTime:0.035565s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T19:10:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.024781s ] [2021-04-13T19:10:07+08:00][sql] SELECT `id` FROM `swgk_content` WHERE `node_id` = '153' AND `region_code` = '331081108239' AND `status` = '上线' LIMIT 1 [ RunTime:0.023948s ] [2021-04-13T19:10:07+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 2651 LIMIT 1 [ RunTime:0.022913s ] [2021-04-13T19:10:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.023425s ] [2021-04-13T19:10:07+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '9216e373427841c5aaf1d3dee8b58af3' LIMIT 1 [ RunTime:0.022775s ] [2021-04-13T19:10:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.023109s ] [2021-04-13T19:10:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 2651 [ RunTime:0.024132s ] [2021-04-13T19:10:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.023062s ] [2021-04-13T19:10:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 2651 AND `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' [ RunTime:0.022747s ] [2021-04-13T19:10:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.023117s ] [2021-04-13T19:10: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.creator_uuid='fe71c5980d404960bf4ca736f77a8bbd' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=2651 ) ORDER BY `c`.`id` DESC [ RunTime:0.022973s ] [2021-04-13T19:10:07+08:00][DEBUG] [ 2021-04-13T19:10: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.creator_uuid='fe71c5980d404960bf4ca736f77a8bbd' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=2651 ) ORDER BY `c`.`id` DESC [2021-04-13T19:20:02+08:00][sql] CONNECT:[ UseTime:0.030567s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T19:20:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.022028s ] [2021-04-13T19:20:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' , `c_id` = 153 , `ctime` = '2021-04-13 19:10:07' [ RunTime:0.020772s ] [2021-04-13T19:20:02+08:00][DEBUG] [ 2021-04-13T19:20:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = 'fe71c5980d404960bf4ca736f77a8bbd' , `c_id` = 153 , `ctime` = '2021-04-13 19:10:07' [2021-04-13T20:28:41+08:00][DEBUG] [ 2021-04-13T20:28:41+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2021-04-13T20:29:04+08:00][sql] CONNECT:[ UseTime:0.031692s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022292s ] [2021-04-13T20:29:04+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.021534s ] [2021-04-13T20:29:04+08:00][DEBUG] [ 2021-04-13T20:29:04+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-04-13T20:29:08+08:00][sql] CONNECT:[ UseTime:0.030431s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:08+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021547s ] [2021-04-13T20:29:08+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.019435s ] [2021-04-13T20:29:08+08:00][DEBUG] [ 2021-04-13T20:29:08+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-04-13T20:29:11+08:00][sql] CONNECT:[ UseTime:0.031851s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:11+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022414s ] [2021-04-13T20:29:11+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.020345s ] [2021-04-13T20:29:11+08:00][DEBUG] [ 2021-04-13T20:29:11+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-04-13T20:29:12+08:00][sql] CONNECT:[ UseTime:0.032849s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.034614s ] [2021-04-13T20:29:12+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.021018s ] [2021-04-13T20:29:12+08:00][DEBUG] [ 2021-04-13T20:29:12+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-04-13T20:29:12+08:00][sql] CONNECT:[ UseTime:0.031714s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022391s ] [2021-04-13T20:29:12+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.020353s ] [2021-04-13T20:29:12+08:00][DEBUG] [ 2021-04-13T20:29:12+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-04-13T20:29:12+08:00][sql] CONNECT:[ UseTime:0.030386s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021688s ] [2021-04-13T20:29:12+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.019723s ] [2021-04-13T20:29:12+08:00][DEBUG] [ 2021-04-13T20:29:12+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-04-13T20:29:12+08:00][sql] CONNECT:[ UseTime:0.035280s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.024697s ] [2021-04-13T20:29:12+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.022657s ] [2021-04-13T20:29:12+08:00][DEBUG] [ 2021-04-13T20:29:12+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-04-13T20:29:13+08:00][sql] CONNECT:[ UseTime:0.031209s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022912s ] [2021-04-13T20:29:13+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.019828s ] [2021-04-13T20:29:13+08:00][DEBUG] [ 2021-04-13T20:29:13+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user [2021-04-13T20:29:14+08:00][sql] CONNECT:[ UseTime:0.031874s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2021-04-13T20:29:14+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022201s ] [2021-04-13T20:29:14+08:00][sql] SELECT `uuid` FROM `swgk_user` WHERE ( phone='13566482754' ) LIMIT 1 [ RunTime:0.020074s ] [2021-04-13T20:29:14+08:00][DEBUG] [ 2021-04-13T20:29:14+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone not exists user