00:06:30.072 [http-nio-8080-exec-3] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 1571 millis. SELECT count(0) FROM biz_member_info o LEFT JOIN (SELECT member_id, sum(duration) AS duration FROM biz_study_record_info WHERE del_flag = '0' GROUP BY member_id) t ON o.id = t.member_id LEFT JOIN (SELECT member_id, count(1) AS model_count FROM biz_read_model_info WHERE del_flag = '0' GROUP BY member_id) t1 ON o.id = t1.member_id LEFT JOIN (SELECT member_id, count(1) AS invite_count FROM biz_invite_record WHERE invite_type = 0 AND del_flag = '0' GROUP BY member_id) t2 ON o.id = t2.member_id WHERE o.del_flag = '0' AND o.user_type = 1[]
00:06:31.569 [http-nio-8080-exec-3] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 1494 millis. select o.*,  ROUND(t.duration / 60.0, 1) as duration,t.duration as durationMin, t1.model_count , t2.invite_count
        from biz_member_info o
        left join (select member_id, sum(duration) as duration from biz_study_record_info where del_flag='0' group by member_id) t on o.id = t.member_id
        left join (select member_id, count(1) as model_count from biz_read_model_info where del_flag='0' group by member_id) t1 on o.id = t1.member_id
        left join (select member_id, count(1) as invite_count from biz_invite_record where invite_type=0 and del_flag='0' group by member_id) t2 on o.id = t2.member_id
         WHERE o.del_flag='0' and o.user_type=1
 LIMIT ? [10]
00:06:35.004 [http-nio-8080-exec-19] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 1458 millis. SELECT count(0) FROM biz_member_info o LEFT JOIN (SELECT member_id, sum(duration) AS duration FROM biz_study_record_info WHERE del_flag = '0' GROUP BY member_id) t ON o.id = t.member_id LEFT JOIN (SELECT member_id, count(1) AS model_count FROM biz_read_model_info WHERE del_flag = '0' GROUP BY member_id) t1 ON o.id = t1.member_id LEFT JOIN (SELECT member_id, count(1) AS invite_count FROM biz_invite_record WHERE invite_type = 0 AND del_flag = '0' GROUP BY member_id) t2 ON o.id = t2.member_id WHERE o.del_flag = '0' AND o.user_type = 1[]
00:06:36.522 [http-nio-8080-exec-19] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,504] - slow sql 1516 millis. select o.*,  ROUND(t.duration / 60.0, 1) as duration,t.duration as durationMin, t1.model_count , t2.invite_count
        from biz_member_info o
        left join (select member_id, sum(duration) as duration from biz_study_record_info where del_flag='0' group by member_id) t on o.id = t.member_id
        left join (select member_id, count(1) as model_count from biz_read_model_info where del_flag='0' group by member_id) t1 on o.id = t1.member_id
        left join (select member_id, count(1) as invite_count from biz_invite_record where invite_type=0 and del_flag='0' group by member_id) t2 on o.id = t2.member_id
         WHERE o.del_flag='0' and o.user_type=1
 LIMIT ?, ? [1850,10]