sys-error.log

01:30:22.987 [schedule-pool-1] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 22974 millis. select
      a.id agent_id, a.site_code, cast(a.id as char) agent_code, a.name agent_name,
      p.id parent_agent_id, p.name parent_agent_name, cast(p.id as char) parent_agent_code,
      case when a.agent_level is not null and a.agent_level > 0 then '多层级代理'
           when a.star_level is not null and a.star_level > 0 then '星级代理' else '代理' end agent_type,
      a.agent_status, a.reg_time agent_reg_time, m.id member_id,
      coalesce((select sum(coalesce(r.actual_amount, r.amount_cny, r.amount, 0))
        from member_account_record r where r.member_id = m.id and r.transaction_type = 1 and r.status = 3
          and r.create_time   >=   a.reg_time), 0) deposit_amount,
      coalesce((select sum(coalesce(b.valid_bet_amount, 0)) from bet_records b
        where b.member_id = m.id and b.bet_at   >=   a.reg_time), 0) valid_bet_amount,
      coalesce((select sum(coalesce(rr.rebate_amount, 0)) from member_user_rebate_record rr
        where rr.member_user_id = m.id and rr.stat_date   >=   date(a.reg_time)), 0) rebate_amount,
      (select min(r.create_time) from member_account_record r where r.member_id = m.id
        and r.transaction_type = 1 and r.status = 3 and r.create_time   >=   a.reg_time) first_deposit_time,
      case when exists(
        select 1 from member_login_log own join member_login_log other on other.ipaddr = own.ipaddr
          and other.member_id != own.member_id and other.login_time   >=   date_sub(now(), interval 3 month)
        where own.member_id = m.id and own.ipaddr is not null and own.ipaddr != ''
          and own.login_time   >=   date_sub(now(), interval 3 month)
      ) then 1 else 0 end shared_ip,
      case when exists(
        select 1 from member_login_log own join member_login_log other on other.device_fingerprint = own.device_fingerprint
          and other.member_id != own.member_id and other.login_time   >=   date_sub(now(), interval 3 month)
        where own.member_id = m.id and own.device_fingerprint is not null and own.device_fingerprint != ''
          and own.login_time   >=   date_sub(now(), interval 3 month)
      ) then 1 else 0 end shared_device,
      case when exists(
        select 1 from member_coin_address own join member_coin_address other on other.address = own.address
          and other.member_user_id != own.member_user_id and other.create_time   >=   date_sub(now(), interval 3 month)
        where own.member_user_id = m.id and own.status = 1 and other.status = 1
          and own.address is not null and own.address != '' and own.create_time   >=   date_sub(now(), interval 3 month)
      ) then 1 else 0 end shared_coin_address
    from member_user a
    left join member_user p on p.id = a.agent_code
    left join member_user m on m.agent_code = a.id
      and coalesce(m.user_type, 0) != 1 and coalesce(m.is_agent, 0) != 1
    where (coalesce(a.user_type, 0) = 1 or coalesce(a.is_agent, 0) = 1)
      and a.reg_time   <   date_sub(now(), interval 7 day)
      and a.reg_time   >=   date_sub(now(), interval 31 day) []