sys-error.2026-07-19.log

10:20:24.517 [schedule-pool-30] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 3188 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,
            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.last_active_time,
            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.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 = ? [1412]
10:20:27.727 [schedule-pool-30] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 3200 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,
            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.last_active_time,
            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.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 = ? [1412]