[2022-09-16T09:19:30+08:00][debug] middleware/Authorise: handle | request path = user.UserLogin/login [2022-09-16T09:19:30+08:00][sql] CONNECT:[ UseTime:0.000604s ] mysql:host=127.0.0.1;port=3306;dbname=qionglai;charset=utf8mb4 [2022-09-16T09:19: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`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid` FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` WHERE ( t1.account='18999999999' ) LIMIT 1 [ RunTime:0.013055s ] [2022-09-16T09:19:30+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.006484s ] [2022-09-16T09:19:30+08:00][sql] SELECT `region_code` FROM `yl_user_region` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.005135s ] [2022-09-16T09:19:30+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942011386 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='1' ) [ RunTime:0.000878s ] [2022-09-16T09:19:30+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '4c8f125cd4334b248dceed93ee330685' , `sign_ip` = 1942011386 , `ua` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.013266s ] [2022-09-16T09:19:31+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2022-09-16T09:19:31+08:00][sql] CONNECT:[ UseTime:0.000469s ] mysql:host=127.0.0.1;port=3306;dbname=qionglai;charset=utf8mb4 [2022-09-16T09:19:31+08:00][sql] SELECT concat_ws("/", t1.role_id, t2.routing) as role, t1.status FROM `yl_role_access_function` `t1` LEFT JOIN `yl_node_function` `t2` ON `t2`.`routing`=`t1`.`routing` [ RunTime:0.004133s ] [2022-09-16T09:19:31+08:00][sql] SELECT `a`.`id`,`a`.`pid`,`a`.`title`,`a`.`type`,`a`.`routing` FROM `yl_node_column` `a` WHERE `a`.`is_content` = 'on' ORDER BY `a`.`sort` ASC [ RunTime:0.004492s ] [2022-09-16T09:19:31+08:00][sql] SELECT `id`,`node_column_id` FROM `yl_user_favorite_node` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.003753s ] [2022-09-16T09:19:31+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2022-09-16T09:19:31+08:00][sql] CONNECT:[ UseTime:0.000424s ] mysql:host=127.0.0.1;port=3306;dbname=qionglai;charset=utf8mb4 [2022-09-16T09:19:31+08:00][sql] SELECT concat_ws("/", t1.role_id, t2.routing) as role, t1.status FROM `yl_role_access_function` `t1` LEFT JOIN `yl_node_function` `t2` ON `t2`.`routing`=`t1`.`routing` [ RunTime:0.000541s ] [2022-09-16T09:19:31+08:00][sql] SELECT `a`.`id`,`a`.`pid`,`a`.`title`,`a`.`type`,`a`.`routing` FROM `yl_node_column` `a` WHERE `a`.`is_content` = 'on' ORDER BY `a`.`sort` ASC [ RunTime:0.000591s ] [2022-09-16T09:19:31+08:00][sql] SELECT `id`,`node_column_id` FROM `yl_user_favorite_node` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000435s ]