sys-error.log
admin-blue · 最近 1000 行 · 已读取 128.0 KiB
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 = ? [4184]
02:05:01.055 [http-nio-9080-exec-26] 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:01.057 [http-nio-9080-exec-47] 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:01.457 [http-nio-9080-exec-50] 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:01.645 [http-nio-9080-exec-45] 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:01.955 [http-nio-9080-exec-1] 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:02.354 [http-nio-9080-exec-99] 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:02.354 [http-nio-9080-exec-46] 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:03.016 [http-nio-9080-exec-83] 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:03.524 [http-nio-9080-exec-6] 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:03.738 [http-nio-9080-exec-59] 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:03.838 [http-nio-9080-exec-40] 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:04.638 [http-nio-9080-exec-52] 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:04.641 [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:04.700 [http-nio-9080-exec-14] 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:04.944 [http-nio-9080-exec-48] 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:05.047 [http-nio-9080-exec-61] 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:05.057 [http-nio-9080-exec-86] 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:05.194 [http-nio-9080-exec-28] 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:05.202 [http-nio-9080-exec-66] 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:07.711 [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:07.717 [http-nio-9080-exec-69] 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:08.831 [http-nio-9080-exec-20] 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:10.497 [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:10.783 [http-nio-9080-exec-82] 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:10.849 [http-nio-9080-exec-79] ERROR c.r.f.w.e.GlobalExceptionHandler - [handleHttpRequestMethodNotSupported,51] - 请求地址'/login',不支持'GET'请求
02:05:11.449 [http-nio-9080-exec-29] 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:11.648 [http-nio-9080-exec-80] 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:11.689 [http-nio-9080-exec-41] 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:11.780 [http-nio-9080-exec-55] 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:11.783 [http-nio-9080-exec-91] 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:11.788 [http-nio-9080-exec-45] 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:12.082 [http-nio-9080-exec-63] 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:12.272 [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:12.274 [http-nio-9080-exec-4] 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:12.373 [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:12.384 [http-nio-9080-exec-19] 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:12.845 [http-nio-9080-exec-18] 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:13.799 [http-nio-9080-exec-12] 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:14.043 [http-nio-9080-exec-92] 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:14.892 [http-nio-9080-exec-64] 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:15.407 [http-nio-9080-exec-14] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 10686 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 = ? [4182]
02:05:15.851 [http-nio-9080-exec-86] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 10781 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:17.612 [http-nio-9080-exec-16] 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:18.311 [http-nio-9080-exec-32] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 10585 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:18.601 [http-nio-9080-exec-98] 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:18.872 [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:20.046 [http-nio-9080-exec-70] 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:20.578 [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:20.626 [http-nio-9080-exec-64] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 4765 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:21.083 [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:22.089 [http-nio-9080-exec-55] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 10297 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:22.222 [http-nio-9080-exec-73] 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:22.721 [http-nio-9080-exec-17] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 10336 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:22.854 [http-nio-9080-exec-11] 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:24.828 [http-nio-9080-exec-97] 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:25.002 [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:25.161 [http-nio-9080-exec-5] 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:25.496 [http-nio-9080-exec-8] 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:25.850 [http-nio-9080-exec-18] 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:25.917 [http-nio-9080-exec-52] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 21267 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:25.996 [http-nio-9080-exec-76] 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:26.768 [http-nio-9080-exec-22] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 22111 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:26.929 [http-nio-9080-exec-39] 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:27.296 [http-nio-9080-exec-79] 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:28.087 [http-nio-9080-exec-28] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 22882 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:29.717 [http-nio-9080-exec-23] 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:31.458 [http-nio-9080-exec-1] 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:31.693 [http-nio-9080-exec-99] 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:31.785 [http-nio-9080-exec-37] 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:32.071 [http-nio-9080-exec-27] 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:32.230 [http-nio-9080-exec-73] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 9997 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:32.826 [http-nio-9080-exec-11] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 9960 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:33.518 [http-nio-9080-exec-6] 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:35.633 [http-nio-9080-exec-100] 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:35.942 [http-nio-9080-exec-76] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 9935 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:35.958 [http-nio-9080-exec-82] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 25160 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:36.273 [http-nio-9080-exec-12] 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:36.811 [http-nio-9080-exec-45] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 25009 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:36.976 [http-nio-9080-exec-57] 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:37.178 [http-nio-9080-exec-79] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 9860 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 = ? [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]