Mysql:select 查询执行计划出现了 Using filesort 该如何优化

[lyzy]

sql 语句如下，该如何优化，请 V 友提供一些思路

SELECT
	*
FROM
	(
		SELECT
			mp.id,
			mp.mp_name,
			mp.weixinname,
			mp.biz,
			ifnull(mp.head_img_url, '') AS head_img_url,
			ifnull(mp.qr_code_url, '') AS qr_code_url,
			mp.introduce,
			mp.company_name,
			mp.first_average_num,
			mp.average_num,
			mp.souce_mp,
			mp.souce_article,
			mp.is_auth,
			mp.push_num,
			ifnull(mp.update_time, '') AS update_time,
			ifnull(mp.create_time, '') AS create_time,

		IF (mal.biz <> 'null', 1, 0) AS is_storage,
		max(ifnull(mal.create_time, '')) AS import_time,
		any_value (ifnull(art.read_num, 0)) AS read_num,
		any_value (ifnull(art.like_num, 0)) AS like_num
	FROM
		`wd_mp_library` mp
	LEFT JOIN wd_mp_library_formal mal ON mp.biz = mal.biz
	LEFT JOIN wd_mp_library_about_articles art ON mp.biz = art.biz
	WHERE
		mp.isdel = 0
	GROUP BY
		mp.id
	) a
LIMIT 25,
 20;