[2020-09-28T09:36:24+08:00][sql] CONNECT:[ UseTime:0.027485s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T09:36:24+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019225s ] [2020-09-28T09:36:24+08:00][DEBUG] [ 2020-09-28T09:36:24+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T10:16:21+08:00][DEBUG] [ 2020-09-28T10:16:21+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T10:17:37+08:00][DEBUG] [ 2020-09-28T10:17:37+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T10:19:01+08:00][sql] CONNECT:[ UseTime:0.029344s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:19:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020811s ] [2020-09-28T10:19:01+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` = '18357747058' LIMIT 1 [ RunTime:0.019799s ] [2020-09-28T10:19:01+08:00][DEBUG] [ 2020-09-28T10:19:01+08:00 ] rediskey18357747058_signin_verify [2020-09-28T10:21:51+08:00][sql] CONNECT:[ UseTime:0.028019s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:21:51+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.018908s ] [2020-09-28T10:21:51+08:00][DEBUG] [ 2020-09-28T10:21:51+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T10:24:12+08:00][DEBUG] [ 2020-09-28T10:24:12+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T10:24:34+08:00][DEBUG] [ 2020-09-28T10:24:34+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T10:31:35+08:00][sql] CONNECT:[ UseTime:0.030879s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:31:35+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.022973s ] [2020-09-28T10:31:35+08:00][DEBUG] [ 2020-09-28T10:31:35+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T10:42:36+08:00][sql] CONNECT:[ UseTime:0.027753s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:42:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019297s ] [2020-09-28T10:42:36+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.018845s ] [2020-09-28T10:42:36+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` = '13867624989' LIMIT 1 [ RunTime:0.018622s ] [2020-09-28T10:42:36+08:00][DEBUG] [ 2020-09-28T10:42:36+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:42:36+08:00][DEBUG] [ 2020-09-28T10:42:36+08:00 ] session11 [2020-09-28T10:42:36+08:00][WARN] [ 2020-09-28T10:42:36+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:42:50+08:00][sql] CONNECT:[ UseTime:0.026672s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:42:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.018473s ] [2020-09-28T10:42:50+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.018359s ] [2020-09-28T10:42:50+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` = '13867624989' LIMIT 1 [ RunTime:0.017790s ] [2020-09-28T10:42:50+08:00][DEBUG] [ 2020-09-28T10:42:50+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:42:50+08:00][DEBUG] [ 2020-09-28T10:42:50+08:00 ] session11 [2020-09-28T10:42:50+08:00][WARN] [ 2020-09-28T10:42:50+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:43:12+08:00][sql] CONNECT:[ UseTime:0.026956s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:43:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.018684s ] [2020-09-28T10:43:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.018365s ] [2020-09-28T10:43:12+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` = '13867624989' LIMIT 1 [ RunTime:0.017797s ] [2020-09-28T10:43:12+08:00][DEBUG] [ 2020-09-28T10:43:12+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:43:12+08:00][DEBUG] [ 2020-09-28T10:43:12+08:00 ] session11 [2020-09-28T10:43:12+08:00][WARN] [ 2020-09-28T10:43:12+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:44:12+08:00][sql] CONNECT:[ UseTime:0.028165s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:44:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019543s ] [2020-09-28T10:44:12+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.019232s ] [2020-09-28T10:44:12+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` = '13867624989' LIMIT 1 [ RunTime:0.018310s ] [2020-09-28T10:44:12+08:00][DEBUG] [ 2020-09-28T10:44:12+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:44:12+08:00][DEBUG] [ 2020-09-28T10:44:12+08:00 ] session11 [2020-09-28T10:44:12+08:00][WARN] [ 2020-09-28T10:44:12+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:44:55+08:00][sql] CONNECT:[ UseTime:0.027809s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:44:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019226s ] [2020-09-28T10:44:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.018830s ] [2020-09-28T10:44:55+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` = '13867624989' LIMIT 1 [ RunTime:0.017887s ] [2020-09-28T10:44:55+08:00][DEBUG] [ 2020-09-28T10:44:55+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:44:55+08:00][DEBUG] [ 2020-09-28T10:44:55+08:00 ] session11 [2020-09-28T10:44:55+08:00][WARN] [ 2020-09-28T10:44:55+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:44:55+08:00][sql] UPDATE `swgk_user` SET `is_on` = 'no' , `errtime` = 0 , `errtimes` = 0 , `imei` = '' , `sign_ip` = 1942071652 , `seriesnumber` = '' WHERE ( phone='13867624989' ) [ RunTime:0.018155s ] [2020-09-28T10:44:55+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`.`uuid` = 'adbf546b51f34eef8a044736a4366f19' LIMIT 1 [ RunTime:0.018433s ] [2020-09-28T10:44:55+08:00][sql] SHOW FULL COLUMNS FROM `swgk_bind_region` [ RunTime:0.017942s ] [2020-09-28T10:44:55+08:00][sql] SELECT `region_code` FROM `swgk_bind_region` WHERE `uuid` = 'adbf546b51f34eef8a044736a4366f19' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.018867s ] [2020-09-28T10:44:55+08:00][DEBUG] [ 2020-09-28T10:44:55+08:00 ] Array ( [pic] => [uuid] => adbf546b51f34eef8a044736a4366f19 [name] => 黄玉琴 [nick_name] => [phone] => 13867624989 [sex] => 0 [weakPwd] => y [firstLogin] => y [peopletype] => 01 [region_code] => [region_name] => [is_jiwei] => n [role_id] => 22 [manage_region_code] => 331081003207 [testFlag] => n ) [2020-09-28T10:45:13+08:00][sql] CONNECT:[ UseTime:0.027295s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:45:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.018891s ] [2020-09-28T10:45:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.019011s ] [2020-09-28T10:45:13+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` = '13867624989' LIMIT 1 [ RunTime:0.017993s ] [2020-09-28T10:45:13+08:00][DEBUG] [ 2020-09-28T10:45:13+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:45:13+08:00][DEBUG] [ 2020-09-28T10:45:13+08:00 ] session11 [2020-09-28T10:45:13+08:00][WARN] [ 2020-09-28T10:45:13+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:45:13+08:00][sql] UPDATE `swgk_user` SET `is_on` = 'no' , `errtime` = 0 , `errtimes` = 0 , `imei` = '' , `sign_ip` = 1942071652 , `seriesnumber` = '' WHERE ( phone='13867624989' ) [ RunTime:0.017817s ] [2020-09-28T10:45:13+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`.`uuid` = 'adbf546b51f34eef8a044736a4366f19' LIMIT 1 [ RunTime:0.017860s ] [2020-09-28T10:45:13+08:00][sql] SHOW FULL COLUMNS FROM `swgk_bind_region` [ RunTime:0.017799s ] [2020-09-28T10:45:13+08:00][sql] SELECT `region_code` FROM `swgk_bind_region` WHERE `uuid` = 'adbf546b51f34eef8a044736a4366f19' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.017385s ] [2020-09-28T10:45:13+08:00][DEBUG] [ 2020-09-28T10:45:13+08:00 ] Array ( [pic] => [uuid] => adbf546b51f34eef8a044736a4366f19 [name] => 黄玉琴 [nick_name] => [phone] => 13867624989 [sex] => 0 [weakPwd] => n [firstLogin] => y [peopletype] => 01 [region_code] => [region_name] => [is_jiwei] => n [role_id] => 22 [manage_region_code] => 331081003207 [testFlag] => n ) [2020-09-28T10:46:00+08:00][sql] CONNECT:[ UseTime:0.035960s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:46:00+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019858s ] [2020-09-28T10:46:00+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.019553s ] [2020-09-28T10:46:00+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` = '13867624989' LIMIT 1 [ RunTime:0.019237s ] [2020-09-28T10:46:00+08:00][DEBUG] [ 2020-09-28T10:46:00+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:46:00+08:00][DEBUG] [ 2020-09-28T10:46:00+08:00 ] session11 [2020-09-28T10:46:00+08:00][WARN] [ 2020-09-28T10:46:00+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:46:01+08:00][sql] UPDATE `swgk_user` SET `is_on` = 'no' , `errtime` = 0 , `errtimes` = 0 , `imei` = '' , `sign_ip` = 1942071652 , `seriesnumber` = '' WHERE ( phone='13867624989' ) [ RunTime:0.018825s ] [2020-09-28T10:46:01+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`.`uuid` = 'adbf546b51f34eef8a044736a4366f19' LIMIT 1 [ RunTime:0.018799s ] [2020-09-28T10:46:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_bind_region` [ RunTime:0.018733s ] [2020-09-28T10:46:01+08:00][sql] SELECT `region_code` FROM `swgk_bind_region` WHERE `uuid` = 'adbf546b51f34eef8a044736a4366f19' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.018243s ] [2020-09-28T10:46:01+08:00][DEBUG] [ 2020-09-28T10:46:01+08:00 ] Array ( [pic] => [uuid] => adbf546b51f34eef8a044736a4366f19 [name] => 黄玉琴 [nick_name] => [phone] => 13867624989 [sex] => 0 [weakPwd] => n [firstLogin] => y [peopletype] => 01 [region_code] => [region_name] => [is_jiwei] => n [role_id] => 22 [manage_region_code] => 331081003207 [testFlag] => n ) [2020-09-28T10:46:52+08:00][sql] CONNECT:[ UseTime:0.029217s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:46:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.020157s ] [2020-09-28T10:46:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.019893s ] [2020-09-28T10:46: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` = '13867624989' LIMIT 1 [ RunTime:0.019370s ] [2020-09-28T10:46:52+08:00][DEBUG] [ 2020-09-28T10:46:52+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:46:52+08:00][DEBUG] [ 2020-09-28T10:46:52+08:00 ] session11 [2020-09-28T10:46:52+08:00][WARN] [ 2020-09-28T10:46:52+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:46:52+08:00][sql] UPDATE `swgk_user` SET `is_on` = 'no' , `errtime` = 0 , `errtimes` = 0 , `imei` = '' , `sign_ip` = 1942071652 , `seriesnumber` = '' WHERE ( phone='13867624989' ) [ RunTime:0.019197s ] [2020-09-28T10:46: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`.`uuid` = 'adbf546b51f34eef8a044736a4366f19' LIMIT 1 [ RunTime:0.019418s ] [2020-09-28T10:46:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_bind_region` [ RunTime:0.019019s ] [2020-09-28T10:46:52+08:00][sql] SELECT `region_code` FROM `swgk_bind_region` WHERE `uuid` = 'adbf546b51f34eef8a044736a4366f19' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.018856s ] [2020-09-28T10:46:52+08:00][DEBUG] [ 2020-09-28T10:46:52+08:00 ] Array ( [pic] => [uuid] => adbf546b51f34eef8a044736a4366f19 [name] => 黄玉琴 [nick_name] => [phone] => 13867624989 [sex] => 0 [weakPwd] => n [firstLogin] => y [peopletype] => 01 [region_code] => [region_name] => [is_jiwei] => n [role_id] => 22 [manage_region_code] => 331081003207 [testFlag] => n ) [2020-09-28T10:47:06+08:00][sql] CONNECT:[ UseTime:0.030677s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:47:06+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021068s ] [2020-09-28T10:47:06+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020942s ] [2020-09-28T10:47:06+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` = '13867624989' LIMIT 1 [ RunTime:0.020558s ] [2020-09-28T10:47:06+08:00][DEBUG] [ 2020-09-28T10:47:06+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:47:06+08:00][DEBUG] [ 2020-09-28T10:47:06+08:00 ] session11 [2020-09-28T10:47:06+08:00][WARN] [ 2020-09-28T10:47:06+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:47:06+08:00][sql] UPDATE `swgk_user` SET `is_on` = 'no' , `errtime` = 0 , `errtimes` = 0 , `imei` = '' , `sign_ip` = 1942071652 , `seriesnumber` = '' WHERE ( phone='13867624989' ) [ RunTime:0.020172s ] [2020-09-28T10:47:06+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`.`uuid` = 'adbf546b51f34eef8a044736a4366f19' LIMIT 1 [ RunTime:0.020218s ] [2020-09-28T10:47:06+08:00][sql] SHOW FULL COLUMNS FROM `swgk_bind_region` [ RunTime:0.020030s ] [2020-09-28T10:47:06+08:00][sql] SELECT `region_code` FROM `swgk_bind_region` WHERE `uuid` = 'adbf546b51f34eef8a044736a4366f19' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.019685s ] [2020-09-28T10:47:06+08:00][DEBUG] [ 2020-09-28T10:47:06+08:00 ] Array ( [pic] => [uuid] => adbf546b51f34eef8a044736a4366f19 [name] => 黄玉琴 [nick_name] => [phone] => 13867624989 [sex] => 0 [weakPwd] => y [firstLogin] => y [peopletype] => 01 [region_code] => [region_name] => [is_jiwei] => n [role_id] => 22 [manage_region_code] => 331081003207 [testFlag] => n ) [2020-09-28T10:47:30+08:00][sql] CONNECT:[ UseTime:0.031045s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:47:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021694s ] [2020-09-28T10:47:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021095s ] [2020-09-28T10:47:30+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` = '13867624989' LIMIT 1 [ RunTime:0.020247s ] [2020-09-28T10:47:30+08:00][DEBUG] [ 2020-09-28T10:47:30+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:47:30+08:00][DEBUG] [ 2020-09-28T10:47:30+08:00 ] session11 [2020-09-28T10:47:30+08:00][WARN] [ 2020-09-28T10:47:30+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:47:40+08:00][sql] CONNECT:[ UseTime:0.027461s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:47:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019420s ] [2020-09-28T10:47:40+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.018439s ] [2020-09-28T10:47:40+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` = '13867624989' LIMIT 1 [ RunTime:0.017572s ] [2020-09-28T10:47:40+08:00][DEBUG] [ 2020-09-28T10:47:40+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:47:40+08:00][DEBUG] [ 2020-09-28T10:47:40+08:00 ] session11 [2020-09-28T10:47:40+08:00][WARN] [ 2020-09-28T10:47:40+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T10:58:54+08:00][sql] CONNECT:[ UseTime:0.027422s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T10:58:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.018859s ] [2020-09-28T10:58:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.018730s ] [2020-09-28T10:58:54+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` = '13867624989' LIMIT 1 [ RunTime:0.017721s ] [2020-09-28T10:58:54+08:00][DEBUG] [ 2020-09-28T10:58:54+08:00 ] rediskey13867624989_signin_verify [2020-09-28T10:58:54+08:00][DEBUG] [ 2020-09-28T10:58:54+08:00 ] session11 [2020-09-28T10:58:54+08:00][WARN] [ 2020-09-28T10:58:54+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T11:03:48+08:00][sql] CONNECT:[ UseTime:0.030720s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:03:48+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021461s ] [2020-09-28T11:03:48+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.021090s ] [2020-09-28T11:03:48+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` = '13867624989' LIMIT 1 [ RunTime:0.020053s ] [2020-09-28T11:03:48+08:00][DEBUG] [ 2020-09-28T11:03:48+08:00 ] rediskey13867624989_signin_verify [2020-09-28T11:03:48+08:00][DEBUG] [ 2020-09-28T11:03:48+08:00 ] session11 [2020-09-28T11:03:48+08:00][WARN] [ 2020-09-28T11:03:48+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T11:04:04+08:00][sql] CONNECT:[ UseTime:0.026599s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:04:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.018679s ] [2020-09-28T11:04:04+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.018375s ] [2020-09-28T11:04: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` = '18267839955' LIMIT 1 [ RunTime:0.017652s ] [2020-09-28T11:04:04+08:00][DEBUG] [ 2020-09-28T11:04:04+08:00 ] rediskey18267839955_signin_verify [2020-09-28T11:04:04+08:00][DEBUG] [ 2020-09-28T11:04:04+08:00 ] session11 [2020-09-28T11:04:04+08:00][WARN] [ 2020-09-28T11:04:04+08:00 ] Controller : MiniProgramInterface | login | smsCode error [2020-09-28T11:05:07+08:00][sql] CONNECT:[ UseTime:0.027296s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:05:07+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.018527s ] [2020-09-28T11:05:07+08:00][DEBUG] [ 2020-09-28T11:05:07+08:00 ] Controller : MiniProgramInterface | findUpdatePassword | newPwd weak [2020-09-28T11:05:27+08:00][DEBUG] [ 2020-09-28T11:05:27+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:05:34+08:00][DEBUG] [ 2020-09-28T11:05:34+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:05:42+08:00][DEBUG] [ 2020-09-28T11:05:42+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:06:28+08:00][sql] CONNECT:[ UseTime:0.028601s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:06:28+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.020238s ] [2020-09-28T11:06: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` = '15068882217' LIMIT 1 [ RunTime:0.019135s ] [2020-09-28T11:06:28+08:00][DEBUG] [ 2020-09-28T11:06:28+08:00 ] rediskey15068882217_signin_verify [2020-09-28T11:09:06+08:00][DEBUG] [ 2020-09-28T11:09:06+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:11:02+08:00][DEBUG] [ 2020-09-28T11:11:02+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:11:27+08:00][DEBUG] [ 2020-09-28T11:11:27+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:12:34+08:00][DEBUG] [ 2020-09-28T11:12:34+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:12:39+08:00][DEBUG] [ 2020-09-28T11:12:39+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:13:04+08:00][DEBUG] [ 2020-09-28T11:13:04+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:13:18+08:00][DEBUG] [ 2020-09-28T11:13:18+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:13:49+08:00][DEBUG] [ 2020-09-28T11:13:49+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:13:52+08:00][sql] CONNECT:[ UseTime:0.027518s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:13:52+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.019391s ] [2020-09-28T11:13: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` = '15068882217' LIMIT 1 [ RunTime:0.018511s ] [2020-09-28T11:13:52+08:00][DEBUG] [ 2020-09-28T11:13:52+08:00 ] rediskey15068882217_signin_verify [2020-09-28T11:15:29+08:00][DEBUG] [ 2020-09-28T11:15:29+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:15:56+08:00][DEBUG] [ 2020-09-28T11:15:56+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:16:38+08:00][DEBUG] [ 2020-09-28T11:16:38+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:16:41+08:00][DEBUG] [ 2020-09-28T11:16:41+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:17:25+08:00][DEBUG] [ 2020-09-28T11:17:25+08:00 ] Controller : MiniProgramInterface | getSMSCode | phone error [2020-09-28T11:21:01+08:00][sql] CONNECT:[ UseTime:0.027394s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:21:01+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.018909s ] [2020-09-28T11:21:01+08:00][DEBUG] [ 2020-09-28T11:21:01+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:24:41+08:00][sql] CONNECT:[ UseTime:0.028213s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:24:41+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019471s ] [2020-09-28T11:24:41+08:00][DEBUG] [ 2020-09-28T11:24:41+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:27:30+08:00][sql] CONNECT:[ UseTime:0.028237s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:27:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.019763s ] [2020-09-28T11:27:30+08:00][DEBUG] [ 2020-09-28T11:27:30+08:00 ] rediskey13083981897_id_verify [2020-09-28T11:27:46+08:00][sql] CONNECT:[ UseTime:0.032550s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:27:46+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.021893s ] [2020-09-28T11:27:46+08:00][DEBUG] [ 2020-09-28T11:27:46+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:29:47+08:00][DEBUG] [ 2020-09-28T11:29:47+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:32:54+08:00][sql] CONNECT:[ UseTime:0.031689s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:32:54+08:00][sql] SHOW FULL COLUMNS FROM `swgk_user` [ RunTime:0.022304s ] [2020-09-28T11:32:54+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` = '18357747058' LIMIT 1 [ RunTime:0.021728s ] [2020-09-28T11:32:54+08:00][DEBUG] [ 2020-09-28T11:32:54+08:00 ] rediskey18357747058_signin_verify [2020-09-28T11:38:59+08:00][DEBUG] [ 2020-09-28T11:38:59+08:00 ] rediskey18357747058_id_verify [2020-09-28T11:39:39+08:00][DEBUG] [ 2020-09-28T11:39:39+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:39:42+08:00][DEBUG] [ 2020-09-28T11:39:42+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:39:45+08:00][DEBUG] [ 2020-09-28T11:39:45+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:39:51+08:00][DEBUG] [ 2020-09-28T11:39:51+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:42:34+08:00][DEBUG] [ 2020-09-28T11:42:34+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:47:21+08:00][DEBUG] [ 2020-09-28T11:47:21+08:00 ] function | invalidSession | jwt header HTTP_AUTHORIZATION empty! [2020-09-28T11:51:30+08:00][sql] CONNECT:[ UseTime:0.028655s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T11:51:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.020313s ] [2020-09-28T11:51:30+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 994 LIMIT 1 [ RunTime:0.018845s ] [2020-09-28T11:51:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018816s ] [2020-09-28T11:51:30+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.018264s ] [2020-09-28T11:51:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.018712s ] [2020-09-28T11:51:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 994 [ RunTime:0.018803s ] [2020-09-28T11:51:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_con_collection` [ RunTime:0.018606s ] [2020-09-28T11:51:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_con_collection` WHERE `c_id` = 994 AND `uuid` = '0603222f07cd47019087d3ab5f74845a' [ RunTime:0.018293s ] [2020-09-28T11:51:30+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018647s ] [2020-09-28T11:51:30+08:00][sql] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='0603222f07cd47019087d3ab5f74845a' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=994 ) ORDER BY `c`.`id` DESC [ RunTime:0.018545s ] [2020-09-28T11:51:30+08:00][DEBUG] [ 2020-09-28T11:51:30+08:00 ] SELECT `c`.`id`,`c`.`content`,`c`.`creator_uuid`,`c`.`status`,`c`.`ctime`,u.nick_name as author,u.pics as face FROM `swgk_comment` `c` LEFT JOIN `swgk_user` `u` ON `u`.`uuid`=`c`.`creator_uuid` WHERE ( ((c.creator_uuid='0603222f07cd47019087d3ab5f74845a' AND c.status IN ('待审核', '已审核')) OR c.status='上线') AND c.c_id=994 ) ORDER BY `c`.`id` DESC [2020-09-28T12:00:02+08:00][sql] CONNECT:[ UseTime:0.029186s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T12:00:02+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.019865s ] [2020-09-28T12:00:02+08:00][sql] INSERT INTO `swgk_browsing_record` SET `uuid` = '0603222f07cd47019087d3ab5f74845a' , `c_id` = 994 , `ctime` = '2020-09-28 11:51:30' [ RunTime:0.020443s ] [2020-09-28T12:00:02+08:00][DEBUG] [ 2020-09-28T12:00:02+08:00 ] Controller: MiniProgramInterface | browsingDataPersists | 插入成功 | INSERT INTO `swgk_browsing_record` SET `uuid` = '0603222f07cd47019087d3ab5f74845a' , `c_id` = 994 , `ctime` = '2020-09-28 11:51:30' [2020-09-28T19:25:46+08:00][sql] CONNECT:[ UseTime:0.028762s ] mysql:host=221.12.101.166;port=3306;dbname=swgk_wl;charset=utf8 [2020-09-28T19:25:46+08:00][sql] SHOW FULL COLUMNS FROM `swgk_ua` [ RunTime:0.032128s ] [2020-09-28T19:25:46+08:00][sql] INSERT INTO `swgk_ua` SET `ua` = 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.2(0x17000222) NetType/4G Language/zh_CN' , `signs` = '2cef9bc20d5488e7b93cf52f8a37f252' [ RunTime:0.019695s ] [2020-09-28T19:25:46+08:00][sql] SHOW FULL COLUMNS FROM `swgk_content` [ RunTime:0.019910s ] [2020-09-28T19:25:46+08:00][sql] SELECT `id`,`title`,`contents`,`type`,`pics`,`creator_uuid`,`ctime`,`vid` FROM `swgk_content` WHERE `id` = 831 LIMIT 1 [ RunTime:0.021902s ] [2020-09-28T19:25:46+08:00][sql] SHOW FULL COLUMNS FROM `swgk_base_ppl` [ RunTime:0.018952s ] [2020-09-28T19:25:46+08:00][sql] SELECT `name` FROM `swgk_base_ppl` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' LIMIT 1 [ RunTime:0.019249s ] [2020-09-28T19:25:46+08:00][sql] SHOW FULL COLUMNS FROM `swgk_browsing_record` [ RunTime:0.020038s ] [2020-09-28T19:25:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `swgk_browsing_record` WHERE `c_id` = 831 [ RunTime:0.018926s ] [2020-09-28T19:25:46+08:00][sql] SHOW FULL COLUMNS FROM `swgk_comment` [ RunTime:0.018857s ] [2020-09-28T19:25:46+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=831 ) ORDER BY `c`.`id` DESC [ RunTime:0.018695s ] [2020-09-28T19:25:46+08:00][DEBUG] [ 2020-09-28T19:25:46+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=831 ) ORDER BY `c`.`id` DESC