08:08:45.905 [OkHttp https://bsc-mainnet.core.chainstack.com/...] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 2295 millis. insert ignore into nexus_deposit_tx ( tx_hash, log_index, block_number, from_address, to_address, to_address_lower, amount, confirmations, matched_order_no, match_status, raw_log_json, create_time ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, sysdate() ) ["0x69f1f43aa2e3b0c7e57ab2345236c81a137a06c5643ac46b14c27faa38b83a7c",1166,111376225,"0x661f1ae9f771ac618f1e37ff80aa6c6a3ce8ebac","0xd687b3fec92ddca0ccc3a3d4f7821834465cc6ba","0xd687b3fec92ddca0ccc3a3d4f7821834465cc6ba",149.040497020404262701,1,null,"UNMATCHED","{\"address\":\"0x91e366a00289a4b5d962651ed01b00c0a74d6689\",\"topics\":[\"0xddf252ad1be2c89b69c2b068fc37..."] 16:34:32.746 [schedule-pool-24] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 3548 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] 16:34:36.163 [schedule-pool-24] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 3385 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]