sys-error.log

            m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
            m.total_valid_bet_amount,
            m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
            m.remain_level_start_date,
            m.current_remain_level_bet_amount,
            cp.plan_name AS commission_plan_name,
            pu.name AS parent_agent_name,
            pu.agent_level AS parent_agent_level,
            pu.star_level AS parent_agent_star_level,
            m.agent_domain,
            /* 子数量 */
            (SELECT COUNT(*) FROM member_user
            WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
            (SELECT COUNT(*) FROM member_user
            WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
            ,
            (SELECT mar.actual_amount
             FROM member_account_record mar
             WHERE mar.member_id = m.id
               AND mar.transaction_type = 1
               AND mar.status = 3
             ORDER BY mar.id ASC
             LIMIT 1) AS first_deposit_amount
        FROM member_user m
            LEFT JOIN member_team mt ON m.team_code = mt.team_code
            LEFT JOIN site s ON m.site_code = s.code
            LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
            LEFT JOIN member_user pu ON m.agent_code = pu.id
        ) u

     
        where u.id = ? [4417]
02:05:38.356 [http-nio-9080-exec-94] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:39.257 [http-nio-9080-exec-92] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 25200 millis. SELECT u.* FROM (
        SELECT
            m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
            m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
            m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
            m.team_agent_identity, m.referrer_agent_id,
            m.developer_name, m.recruiter_user_id,
            mt.title AS team_name,
            m.site_code, m.agent_code,
            COALESCE(s.name_zn, m.site_code) AS site_name,
            m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
            m.is_site_admin_binding,
            m.commission_plan_id, m.google_key,
            case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
            m.last_active_time, m.last_entry_venue,
            m.user_type, m.agent_level, m.star_level, m.agent_remark,
            m.phone, m.email, m.qq, m.wechat,
            m.promotion_code, m.commission_rate,
            m.bear_all_operation_expense, m.bear_operation_expense_types,
            m.settlement_cycle,
            m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
            m.total_valid_bet_amount,
            m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
            m.remain_level_start_date,
            m.current_remain_level_bet_amount,
            cp.plan_name AS commission_plan_name,
            pu.name AS parent_agent_name,
            pu.agent_level AS parent_agent_level,
            pu.star_level AS parent_agent_star_level,
            m.agent_domain,
            /* 子数量 */
            (SELECT COUNT(*) FROM member_user
            WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
            (SELECT COUNT(*) FROM member_user
            WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
            ,
            (SELECT mar.actual_amount
             FROM member_account_record mar
             WHERE mar.member_id = m.id
               AND mar.transaction_type = 1
               AND mar.status = 3
             ORDER BY mar.id ASC
             LIMIT 1) AS first_deposit_amount
        FROM member_user m
            LEFT JOIN member_team mt ON m.team_code = mt.team_code
            LEFT JOIN site s ON m.site_code = s.code
            LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
            LEFT JOIN member_user pu ON m.agent_code = pu.id
        ) u

     
        where u.id = ? [4396]
02:05:41.490 [http-nio-9080-exec-71] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:41.674 [http-nio-9080-exec-60] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:41.827 [http-nio-9080-exec-32] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:44.019 [http-nio-9080-exec-53] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:44.582 [http-nio-9080-exec-88] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:45.122 [http-nio-9080-exec-62] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:47.982 [http-nio-9080-exec-17] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:48.598 [http-nio-9080-exec-51] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:48.868 [http-nio-9080-exec-31] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:50.045 [http-nio-9080-exec-75] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:50.567 [http-nio-9080-exec-22] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
02:05:53.867 [http-nio-9080-exec-12] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 17579 millis. SELECT u.* FROM (
        SELECT
            m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
            m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
            m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
            m.team_agent_identity, m.referrer_agent_id,
            m.developer_name, m.recruiter_user_id,
            mt.title AS team_name,
            m.site_code, m.agent_code,
            COALESCE(s.name_zn, m.site_code) AS site_name,
            m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
            m.is_site_admin_binding,
            m.commission_plan_id, m.google_key,
            case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
            m.last_active_time, m.last_entry_venue,
            m.user_type, m.agent_level, m.star_level, m.agent_remark,
            m.phone, m.email, m.qq, m.wechat,
            m.promotion_code, m.commission_rate,
            m.bear_all_operation_expense, m.bear_operation_expense_types,
            m.settlement_cycle,
            m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
            m.total_valid_bet_amount,
            m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
            m.remain_level_start_date,
            m.current_remain_level_bet_amount,
            cp.plan_name AS commission_plan_name,
            pu.name AS parent_agent_name,
            pu.agent_level AS parent_agent_level,
            pu.star_level AS parent_agent_star_level,
            m.agent_domain,
            /* 子数量 */
            (SELECT COUNT(*) FROM member_user
            WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
            (SELECT COUNT(*) FROM member_user
            WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
            ,
            (SELECT mar.actual_amount
             FROM member_account_record mar
             WHERE mar.member_id = m.id
               AND mar.transaction_type = 1
               AND mar.status = 3
             ORDER BY mar.id ASC
             LIMIT 1) AS first_deposit_amount
        FROM member_user m
            LEFT JOIN member_team mt ON m.team_code = mt.team_code
            LEFT JOIN site s ON m.site_code = s.code
            LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
            LEFT JOIN member_user pu ON m.agent_code = pu.id
        ) u

     
        where u.id = ? [2939]
02:05:54.477 [http-nio-9080-exec-57] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 17487 millis. SELECT u.* FROM (
        SELECT
            m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
            m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
            m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
            m.team_agent_identity, m.referrer_agent_id,
            m.developer_name, m.recruiter_user_id,
            mt.title AS team_name,
            m.site_code, m.agent_code,
            COALESCE(s.name_zn, m.site_code) AS site_name,
            m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
            m.is_site_admin_binding,
            m.commission_plan_id, m.google_key,
            case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
            m.last_active_time, m.last_entry_venue,
            m.user_type, m.agent_level, m.star_level, m.agent_remark,
            m.phone, m.email, m.qq, m.wechat,
            m.promotion_code, m.commission_rate,
            m.bear_all_operation_expense, m.bear_operation_expense_types,
            m.settlement_cycle,
            m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
            m.total_valid_bet_amount,
            m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
            m.remain_level_start_date,
            m.current_remain_level_bet_amount,
            cp.plan_name AS commission_plan_name,
            pu.name AS parent_agent_name,
            pu.agent_level AS parent_agent_level,
            pu.star_level AS parent_agent_star_level,
            m.agent_domain,
            /* 子数量 */
            (SELECT COUNT(*) FROM member_user
            WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
            (SELECT COUNT(*) FROM member_user
            WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
            ,
            (SELECT mar.actual_amount
             FROM member_account_record mar
             WHERE mar.member_id = m.id
               AND mar.transaction_type = 1
               AND mar.status = 3
             ORDER BY mar.id ASC
             LIMIT 1) AS first_deposit_amount
        FROM member_user m
            LEFT JOIN member_team mt ON m.team_code = mt.team_code
            LEFT JOIN site s ON m.site_code = s.code
            LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
            LEFT JOIN member_user pu ON m.agent_code = pu.id
        ) u

     
        where u.id = ? [2939]