[2021-08-16T11:19:26+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:19:26+08:00][sql] CONNECT:[ UseTime:0.000726s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:19:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.018602s ] [2021-08-16T11:19:26+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.009909s ] [2021-08-16T11:19:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_conf` [ RunTime:0.004841s ] [2021-08-16T11:19:26+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_ip_times' ) LIMIT 1 [ RunTime:0.000474s ] [2021-08-16T11:19:26+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_un_times' ) LIMIT 1 [ RunTime:0.000391s ] [2021-08-16T11:19:26+08:00][sql] UPDATE `yl_user_login` SET `sign_ip` = 1942070678 , `errtime` = 1629083966 , `errtimes` = 1 WHERE ( account='18357747058' ) [ RunTime:0.000660s ] [2021-08-16T11:19:38+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:19:38+08:00][sql] CONNECT:[ UseTime:0.000699s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:19:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001038s ] [2021-08-16T11:19:38+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.016777s ] [2021-08-16T11:19:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001360s ] [2021-08-16T11:19:38+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000274s ] [2021-08-16T11:19:38+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000868s ] [2021-08-16T11:19:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001216s ] [2021-08-16T11:19:38+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.004973s ] [2021-08-16T11:19:48+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:19:48+08:00][sql] CONNECT:[ UseTime:0.000710s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:19:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001171s ] [2021-08-16T11:19:48+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.001188s ] [2021-08-16T11:19:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000860s ] [2021-08-16T11:19:48+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000308s ] [2021-08-16T11:19:48+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000663s ] [2021-08-16T11:19:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000692s ] [2021-08-16T11:19:48+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000480s ] [2021-08-16T11:19:48+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:19:48+08:00][sql] CONNECT:[ UseTime:0.000513s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:19:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000928s ] [2021-08-16T11:19:48+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000824s ] [2021-08-16T11:19:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001074s ] [2021-08-16T11:19:48+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000451s ] [2021-08-16T11:19:48+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000730s ] [2021-08-16T11:19:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000874s ] [2021-08-16T11:19:48+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000556s ] [2021-08-16T11:20:17+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:20:17+08:00][sql] CONNECT:[ UseTime:0.000739s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:20:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001208s ] [2021-08-16T11:20:17+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000622s ] [2021-08-16T11:20:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000976s ] [2021-08-16T11:20:17+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000474s ] [2021-08-16T11:20:17+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000670s ] [2021-08-16T11:20:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000952s ] [2021-08-16T11:20:17+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000389s ] [2021-08-16T11:20:20+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:20:20+08:00][sql] CONNECT:[ UseTime:0.000703s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:20:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000905s ] [2021-08-16T11:20:20+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000664s ] [2021-08-16T11:20:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000991s ] [2021-08-16T11:20:20+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000437s ] [2021-08-16T11:20:20+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000662s ] [2021-08-16T11:20:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000777s ] [2021-08-16T11:20:20+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000545s ] [2021-08-16T11:20:20+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:20:20+08:00][sql] CONNECT:[ UseTime:0.000547s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:20:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000914s ] [2021-08-16T11:20:20+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000837s ] [2021-08-16T11:20:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.002398s ] [2021-08-16T11:20:20+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000304s ] [2021-08-16T11:20:20+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000581s ] [2021-08-16T11:20:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000844s ] [2021-08-16T11:20:20+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000402s ] [2021-08-16T11:20:37+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:20:37+08:00][sql] CONNECT:[ UseTime:0.000711s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:20:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001199s ] [2021-08-16T11:20:37+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000774s ] [2021-08-16T11:20:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000995s ] [2021-08-16T11:20:37+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000316s ] [2021-08-16T11:20:37+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000878s ] [2021-08-16T11:20:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001088s ] [2021-08-16T11:20:37+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000429s ] [2021-08-16T11:20:43+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:20:44+08:00][sql] CONNECT:[ UseTime:0.000736s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:20:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000907s ] [2021-08-16T11:20:44+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000771s ] [2021-08-16T11:20:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001001s ] [2021-08-16T11:20:44+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000324s ] [2021-08-16T11:20:44+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000793s ] [2021-08-16T11:20:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001143s ] [2021-08-16T11:20:44+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000480s ] [2021-08-16T11:20:44+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:20:44+08:00][sql] CONNECT:[ UseTime:0.000670s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:20:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001142s ] [2021-08-16T11:20:44+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000700s ] [2021-08-16T11:20:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001032s ] [2021-08-16T11:20:44+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000638s ] [2021-08-16T11:20:44+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='31' ) [ RunTime:0.000682s ] [2021-08-16T11:20:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000844s ] [2021-08-16T11:20:44+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000425s ] [2021-08-16T11:21:06+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:21:06+08:00][sql] CONNECT:[ UseTime:0.000791s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:21:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001303s ] [2021-08-16T11:21:06+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.001210s ] [2021-08-16T11:21:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_conf` [ RunTime:0.001341s ] [2021-08-16T11:21:06+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_ip_times' ) LIMIT 1 [ RunTime:0.000424s ] [2021-08-16T11:21:06+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_un_times' ) LIMIT 1 [ RunTime:0.000312s ] [2021-08-16T11:21:06+08:00][sql] UPDATE `yl_user_login` SET `sign_ip` = 1942070678 , `errtime` = 1629084066 , `errtimes` = 1 WHERE ( account='13758246442' ) [ RunTime:0.000750s ] [2021-08-16T11:21:18+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:21:19+08:00][sql] CONNECT:[ UseTime:0.000549s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:21:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001050s ] [2021-08-16T11:21:19+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.001092s ] [2021-08-16T11:21:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_conf` [ RunTime:0.000991s ] [2021-08-16T11:21:19+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_ip_times' ) LIMIT 1 [ RunTime:0.000352s ] [2021-08-16T11:21:19+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_un_times' ) LIMIT 1 [ RunTime:0.000300s ] [2021-08-16T11:21:19+08:00][sql] UPDATE `yl_user_login` SET `sign_ip` = 1942070678 , `errtime` = 1629084079 , `errtimes` = 2 WHERE ( account='13758246442' ) [ RunTime:0.000593s ] [2021-08-16T11:21:28+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:21:28+08:00][sql] CONNECT:[ UseTime:0.000760s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:21:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001220s ] [2021-08-16T11:21:28+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.001275s ] [2021-08-16T11:21:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001034s ] [2021-08-16T11:21:28+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.003733s ] [2021-08-16T11:21:28+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000649s ] [2021-08-16T11:21:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001096s ] [2021-08-16T11:21:28+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000442s ] [2021-08-16T11:21:31+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:21:31+08:00][sql] CONNECT:[ UseTime:0.000536s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:21:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001504s ] [2021-08-16T11:21:31+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.001132s ] [2021-08-16T11:21:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001115s ] [2021-08-16T11:21:31+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.000420s ] [2021-08-16T11:21:31+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000512s ] [2021-08-16T11:21:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000697s ] [2021-08-16T11:21:31+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000307s ] [2021-08-16T11:21:31+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:21:31+08:00][sql] CONNECT:[ UseTime:0.000589s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:21:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000831s ] [2021-08-16T11:21:31+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000775s ] [2021-08-16T11:21:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001251s ] [2021-08-16T11:21:31+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.000490s ] [2021-08-16T11:21:31+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000604s ] [2021-08-16T11:21:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000795s ] [2021-08-16T11:21:31+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.001033s ] [2021-08-16T11:21:56+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:21:56+08:00][sql] CONNECT:[ UseTime:0.000514s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000979s ] [2021-08-16T11:21:56+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000598s ] [2021-08-16T11:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001049s ] [2021-08-16T11:21:56+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.000349s ] [2021-08-16T11:21:56+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000610s ] [2021-08-16T11:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000782s ] [2021-08-16T11:21:56+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000505s ] [2021-08-16T11:22:00+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:22:01+08:00][sql] CONNECT:[ UseTime:0.000538s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:22:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000848s ] [2021-08-16T11:22:01+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000516s ] [2021-08-16T11:22:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001298s ] [2021-08-16T11:22:01+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.000384s ] [2021-08-16T11:22:01+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000699s ] [2021-08-16T11:22:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000859s ] [2021-08-16T11:22:01+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000527s ] [2021-08-16T11:22:01+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:22:01+08:00][sql] CONNECT:[ UseTime:0.000648s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:22:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001227s ] [2021-08-16T11:22:01+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.001047s ] [2021-08-16T11:22:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001173s ] [2021-08-16T11:22:01+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.000440s ] [2021-08-16T11:22:01+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000699s ] [2021-08-16T11:22:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000882s ] [2021-08-16T11:22:01+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000368s ] [2021-08-16T11:22:19+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:22:19+08:00][sql] CONNECT:[ UseTime:0.000516s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:22:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000944s ] [2021-08-16T11:22:19+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000435s ] [2021-08-16T11:22:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001165s ] [2021-08-16T11:22:19+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.000476s ] [2021-08-16T11:22:19+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000598s ] [2021-08-16T11:22:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001030s ] [2021-08-16T11:22:19+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000459s ] [2021-08-16T11:22:29+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:22:29+08:00][sql] CONNECT:[ UseTime:0.000521s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:22:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000847s ] [2021-08-16T11:22:29+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000453s ] [2021-08-16T11:22:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000869s ] [2021-08-16T11:22:29+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.000565s ] [2021-08-16T11:22:29+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000549s ] [2021-08-16T11:22:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000679s ] [2021-08-16T11:22:29+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000509s ] [2021-08-16T11:22:29+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:22:29+08:00][sql] CONNECT:[ UseTime:0.000642s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:22:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000913s ] [2021-08-16T11:22:29+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000479s ] [2021-08-16T11:22:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000985s ] [2021-08-16T11:22:29+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.000321s ] [2021-08-16T11:22:29+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000912s ] [2021-08-16T11:22:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001010s ] [2021-08-16T11:22:29+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000425s ] [2021-08-16T11:23:31+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:23:31+08:00][sql] CONNECT:[ UseTime:0.000404s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:23:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000792s ] [2021-08-16T11:23:31+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000697s ] [2021-08-16T11:23:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001061s ] [2021-08-16T11:23:31+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000466s ] [2021-08-16T11:23:31+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000645s ] [2021-08-16T11:23:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001040s ] [2021-08-16T11:23:31+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000430s ] [2021-08-16T11:23:47+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:23:47+08:00][sql] CONNECT:[ UseTime:0.000718s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001156s ] [2021-08-16T11:23:47+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.001177s ] [2021-08-16T11:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000929s ] [2021-08-16T11:23:47+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000250s ] [2021-08-16T11:23:47+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000906s ] [2021-08-16T11:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000971s ] [2021-08-16T11:23:47+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000469s ] [2021-08-16T11:23:47+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:23:47+08:00][sql] CONNECT:[ UseTime:0.000705s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001040s ] [2021-08-16T11:23:47+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000732s ] [2021-08-16T11:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001202s ] [2021-08-16T11:23:47+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000539s ] [2021-08-16T11:23:47+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000769s ] [2021-08-16T11:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000881s ] [2021-08-16T11:23:47+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000375s ] [2021-08-16T11:25:09+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:25:09+08:00][sql] CONNECT:[ UseTime:0.000628s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:25:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001007s ] [2021-08-16T11:25:09+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000864s ] [2021-08-16T11:25:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000972s ] [2021-08-16T11:25:09+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000326s ] [2021-08-16T11:25:09+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000814s ] [2021-08-16T11:25:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000811s ] [2021-08-16T11:25:09+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000355s ] [2021-08-16T11:25:46+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:25:46+08:00][sql] CONNECT:[ UseTime:0.000689s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:25:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000878s ] [2021-08-16T11:25:46+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000638s ] [2021-08-16T11:25:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000873s ] [2021-08-16T11:25:46+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000260s ] [2021-08-16T11:25:46+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000587s ] [2021-08-16T11:25:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000748s ] [2021-08-16T11:25:46+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000333s ] [2021-08-16T11:25:46+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:25:46+08:00][sql] CONNECT:[ UseTime:0.000728s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:25:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001165s ] [2021-08-16T11:25:46+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000586s ] [2021-08-16T11:25:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000978s ] [2021-08-16T11:25:46+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000423s ] [2021-08-16T11:25:46+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000451s ] [2021-08-16T11:25:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001138s ] [2021-08-16T11:25:46+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000418s ] [2021-08-16T11:26:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:26:32+08:00][sql] CONNECT:[ UseTime:0.000525s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:26:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000804s ] [2021-08-16T11:26:32+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000479s ] [2021-08-16T11:26:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001074s ] [2021-08-16T11:26:32+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000310s ] [2021-08-16T11:26:32+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000579s ] [2021-08-16T11:26:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000674s ] [2021-08-16T11:26:32+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000370s ] [2021-08-16T11:26:33+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:26:34+08:00][sql] CONNECT:[ UseTime:0.000693s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000957s ] [2021-08-16T11:26:34+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000571s ] [2021-08-16T11:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001190s ] [2021-08-16T11:26:34+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000320s ] [2021-08-16T11:26:34+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000659s ] [2021-08-16T11:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000833s ] [2021-08-16T11:26:34+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000522s ] [2021-08-16T11:26:34+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:26:34+08:00][sql] CONNECT:[ UseTime:0.000724s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001119s ] [2021-08-16T11:26:34+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000759s ] [2021-08-16T11:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001098s ] [2021-08-16T11:26:34+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000327s ] [2021-08-16T11:26:34+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000674s ] [2021-08-16T11:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000825s ] [2021-08-16T11:26:34+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000406s ] [2021-08-16T11:30:39+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:30:39+08:00][sql] CONNECT:[ UseTime:0.000550s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:30:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000918s ] [2021-08-16T11:30:39+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000440s ] [2021-08-16T11:30:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001067s ] [2021-08-16T11:30:39+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000271s ] [2021-08-16T11:30:39+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000543s ] [2021-08-16T11:30:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000864s ] [2021-08-16T11:30:39+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000468s ] [2021-08-16T11:30:41+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:30:41+08:00][sql] CONNECT:[ UseTime:0.000679s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:30:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000787s ] [2021-08-16T11:30:41+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000713s ] [2021-08-16T11:30:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000934s ] [2021-08-16T11:30:41+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000251s ] [2021-08-16T11:30:41+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000830s ] [2021-08-16T11:30:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000916s ] [2021-08-16T11:30:41+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000424s ] [2021-08-16T11:30:41+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:30:41+08:00][sql] CONNECT:[ UseTime:0.000787s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:30:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001050s ] [2021-08-16T11:30:41+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000595s ] [2021-08-16T11:30:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001270s ] [2021-08-16T11:30:41+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000335s ] [2021-08-16T11:30:41+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000719s ] [2021-08-16T11:30:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000873s ] [2021-08-16T11:30:41+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000630s ] [2021-08-16T11:31:14+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:31:14+08:00][sql] CONNECT:[ UseTime:0.000683s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001003s ] [2021-08-16T11:31:14+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000535s ] [2021-08-16T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000906s ] [2021-08-16T11:31:14+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000314s ] [2021-08-16T11:31:14+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000465s ] [2021-08-16T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001045s ] [2021-08-16T11:31:14+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000597s ] [2021-08-16T11:31:38+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:31:38+08:00][sql] CONNECT:[ UseTime:0.000515s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:31:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000931s ] [2021-08-16T11:31:38+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000582s ] [2021-08-16T11:31:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001455s ] [2021-08-16T11:31:38+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000432s ] [2021-08-16T11:31:38+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000601s ] [2021-08-16T11:31:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000711s ] [2021-08-16T11:31:38+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000348s ] [2021-08-16T11:31:38+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:31:38+08:00][sql] CONNECT:[ UseTime:0.000598s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:31:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000905s ] [2021-08-16T11:31:38+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000619s ] [2021-08-16T11:31:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000957s ] [2021-08-16T11:31:38+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000256s ] [2021-08-16T11:31:38+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000515s ] [2021-08-16T11:31:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000777s ] [2021-08-16T11:31:38+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000455s ] [2021-08-16T11:32:18+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:32:18+08:00][sql] CONNECT:[ UseTime:0.000628s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:32:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000949s ] [2021-08-16T11:32:18+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000610s ] [2021-08-16T11:32:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001377s ] [2021-08-16T11:32:18+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000344s ] [2021-08-16T11:32:18+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000643s ] [2021-08-16T11:32:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000680s ] [2021-08-16T11:32:18+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000355s ] [2021-08-16T11:44:27+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:44:27+08:00][sql] CONNECT:[ UseTime:0.000549s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:44:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000897s ] [2021-08-16T11:44:27+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000631s ] [2021-08-16T11:44:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001069s ] [2021-08-16T11:44:27+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000309s ] [2021-08-16T11:44:27+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.002791s ] [2021-08-16T11:44:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001019s ] [2021-08-16T11:44:27+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000387s ] [2021-08-16T11:44:27+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:44:27+08:00][sql] CONNECT:[ UseTime:0.000609s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:44:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000968s ] [2021-08-16T11:44:27+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000518s ] [2021-08-16T11:44:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001017s ] [2021-08-16T11:44:27+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000254s ] [2021-08-16T11:44:27+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000550s ] [2021-08-16T11:44:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000687s ] [2021-08-16T11:44:27+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000550s ] [2021-08-16T11:44:29+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/out [2021-08-16T11:44:35+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:44:35+08:00][sql] CONNECT:[ UseTime:0.000680s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:44:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000844s ] [2021-08-16T11:44:35+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000430s ] [2021-08-16T11:44:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000964s ] [2021-08-16T11:44:35+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000290s ] [2021-08-16T11:44:35+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000711s ] [2021-08-16T11:44:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000729s ] [2021-08-16T11:44:35+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000436s ] [2021-08-16T11:44:38+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:44:38+08:00][sql] CONNECT:[ UseTime:0.000752s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:44:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001259s ] [2021-08-16T11:44:38+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000526s ] [2021-08-16T11:44:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000832s ] [2021-08-16T11:44:38+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000292s ] [2021-08-16T11:44:38+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000673s ] [2021-08-16T11:44:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000801s ] [2021-08-16T11:44:38+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000594s ] [2021-08-16T11:44:38+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:44:38+08:00][sql] CONNECT:[ UseTime:0.000489s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:44:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000849s ] [2021-08-16T11:44:38+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000778s ] [2021-08-16T11:44:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001045s ] [2021-08-16T11:44:38+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000554s ] [2021-08-16T11:44:38+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000804s ] [2021-08-16T11:44:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001063s ] [2021-08-16T11:44:38+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000369s ] [2021-08-16T11:51:13+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:51:13+08:00][sql] CONNECT:[ UseTime:0.000624s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:51:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000974s ] [2021-08-16T11:51:13+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000714s ] [2021-08-16T11:51:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001011s ] [2021-08-16T11:51:13+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000355s ] [2021-08-16T11:51:13+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000647s ] [2021-08-16T11:51:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000846s ] [2021-08-16T11:51:13+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000488s ] [2021-08-16T11:51:16+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:51:16+08:00][sql] CONNECT:[ UseTime:0.000561s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:51:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001084s ] [2021-08-16T11:51:16+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000566s ] [2021-08-16T11:51:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001017s ] [2021-08-16T11:51:16+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000321s ] [2021-08-16T11:51:16+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000709s ] [2021-08-16T11:51:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000981s ] [2021-08-16T11:51:16+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.008901s ] [2021-08-16T11:51:16+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T11:51:16+08:00][sql] CONNECT:[ UseTime:0.000515s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T11:51:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000927s ] [2021-08-16T11:51:16+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18258188664' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000574s ] [2021-08-16T11:51:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001069s ] [2021-08-16T11:51:16+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '733b8d111a784b79aa18254150b3d6c1' [ RunTime:0.000298s ] [2021-08-16T11:51:16+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='32' ) [ RunTime:0.000570s ] [2021-08-16T11:51:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000930s ] [2021-08-16T11:51:16+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '733b8d111a784b79aa18254150b3d6c1' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B813A62B5CAFE5A68E3837869316DBC085FC92D6' [ RunTime:0.000382s ] [2021-08-16T16:28:29+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-16T16:28:29+08:00][debug] middleware/Authorise: handle | login verify failed | login info = [2021-08-16T16:28:29+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | login verify failed | login info = [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | login verify failed | login info = [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | login verify failed | login info = [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T16:28:30+08:00][sql] CONNECT:[ UseTime:0.000689s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.008612s ] [2021-08-16T16:28:30+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.026101s ] [2021-08-16T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_conf` [ RunTime:0.002495s ] [2021-08-16T16:28:30+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_ip_times' ) LIMIT 1 [ RunTime:0.003799s ] [2021-08-16T16:28:30+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_un_times' ) LIMIT 1 [ RunTime:0.000463s ] [2021-08-16T16:28:30+08:00][sql] UPDATE `yl_user_login` SET `sign_ip` = 1942070678 , `errtime` = 1629102510 , `errtimes` = 1 WHERE ( account='13758246442' ) [ RunTime:0.000645s ] [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T16:28:30+08:00][sql] CONNECT:[ UseTime:0.000416s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000794s ] [2021-08-16T16:28:30+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000934s ] [2021-08-16T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_conf` [ RunTime:0.000987s ] [2021-08-16T16:28:30+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_ip_times' ) LIMIT 1 [ RunTime:0.000355s ] [2021-08-16T16:28:30+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_un_times' ) LIMIT 1 [ RunTime:0.000358s ] [2021-08-16T16:28:30+08:00][sql] UPDATE `yl_user_login` SET `sign_ip` = 1942070678 , `errtime` = 1629102510 , `errtimes` = 2 WHERE ( account='13758246442' ) [ RunTime:0.000614s ] [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | login verify failed | login info = [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T16:28:30+08:00][sql] CONNECT:[ UseTime:0.000557s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000962s ] [2021-08-16T16:28:30+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000860s ] [2021-08-16T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_conf` [ RunTime:0.000944s ] [2021-08-16T16:28:30+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_ip_times' ) LIMIT 1 [ RunTime:0.000364s ] [2021-08-16T16:28:30+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_un_times' ) LIMIT 1 [ RunTime:0.000355s ] [2021-08-16T16:28:30+08:00][sql] UPDATE `yl_user_login` SET `sign_ip` = 1942070678 , `errtime` = 1629102510 , `errtimes` = 3 WHERE ( account='13758246442' ) [ RunTime:0.000491s ] [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | login verify failed | login info = [2021-08-16T16:28:30+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T16:28:30+08:00][sql] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000857s ] [2021-08-16T16:28:30+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000821s ] [2021-08-16T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_conf` [ RunTime:0.001018s ] [2021-08-16T16:28:30+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_ip_times' ) LIMIT 1 [ RunTime:0.000388s ] [2021-08-16T16:28:30+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_un_times' ) LIMIT 1 [ RunTime:0.000667s ] [2021-08-16T16:28:30+08:00][sql] UPDATE `yl_user_login` SET `sign_ip` = 1942070678 , `errtime` = 1629102510 , `errtimes` = 4 WHERE ( account='13758246442' ) [ RunTime:0.000911s ] [2021-08-16T16:28:52+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T16:28:52+08:00][sql] CONNECT:[ UseTime:0.000733s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T16:28:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001109s ] [2021-08-16T16:28:52+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.002131s ] [2021-08-16T16:28:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_conf` [ RunTime:0.001088s ] [2021-08-16T16:28:52+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_ip_times' ) LIMIT 1 [ RunTime:0.000396s ] [2021-08-16T16:28:52+08:00][sql] SELECT `cvalue` FROM `yl_conf` WHERE ( ckey='login_un_times' ) LIMIT 1 [ RunTime:0.000285s ] [2021-08-16T16:28:52+08:00][sql] UPDATE `yl_user_login` SET `sign_ip` = 1942070678 , `errtime` = 1629102532 , `errtimes` = 5 WHERE ( account='13758246442' ) [ RunTime:0.000534s ] [2021-08-16T16:28:58+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in [2021-08-16T16:28:58+08:00][sql] CONNECT:[ UseTime:0.000576s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T16:28:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000855s ] [2021-08-16T16:28:58+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='13758246442' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000977s ] [2021-08-16T16:28:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001205s ] [2021-08-16T16:28:58+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '7ee9331f1b8a4943b008c662197b7400' [ RunTime:0.007561s ] [2021-08-16T16:28:58+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942070678 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='30' ) [ RunTime:0.000715s ] [2021-08-16T16:28:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001210s ] [2021-08-16T16:28:58+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '7ee9331f1b8a4943b008c662197b7400' , `sign_ip` = 115 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = 'B39D32CFE055055DA68858F2CBBFB2C128F048C2' [ RunTime:0.002931s ] [2021-08-16T16:29:00+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-16T16:29:00+08:00][debug] ---$rediskey---app:jwt:QBXzdbTbYjTWXcFToflXSMIhCOGE2Ey7dIPrEMW_-fo [2021-08-16T16:29:00+08:00][sql] CONNECT:[ UseTime:0.000729s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T16:29:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.040477s ] [2021-08-16T16:29:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.009156s ] [2021-08-16T16:29:00+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000921s ] [2021-08-16T16:29:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.004211s ] [2021-08-16T16:29:00+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.014177s ] [2021-08-16T16:29:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000975s ] [2021-08-16T16:29:00+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.001327s ] [2021-08-16T16:29:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.005360s ] [2021-08-16T16:29:00+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (37,36) GROUP BY `content_id` [ RunTime:0.003159s ] [2021-08-16T16:29:00+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-16T16:29:00+08:00][debug] ---$rediskey---app:jwt:QBXzdbTbYjTWXcFToflXSMIhCOGE2Ey7dIPrEMW_-fo [2021-08-16T16:29:00+08:00][sql] CONNECT:[ UseTime:0.000455s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-16T16:29:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001004s ] [2021-08-16T16:29:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000416s ] [2021-08-16T16:29:00+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000923s ] [2021-08-16T16:29:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.001161s ] [2021-08-16T16:29:00+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,62,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000844s ] [2021-08-16T16:29:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000948s ] [2021-08-16T16:29:00+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,62,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000823s ] [2021-08-16T16:29:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.001014s ] [2021-08-16T16:29:00+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,62,60) GROUP BY `content_id` [ RunTime:0.000518s ]