Help to see how this MySQL statement is optimized

Help to see how this MySQL statement is optimized
Explain select Sql_calc_found_rows D.id,d.goodlevel,d.ismainfield,d.lirun,d.introduce,d.shen,d.city,d.mainfield, D.charges,d.type,m.indentity,m.nick as Name,m.username,d.cxt_num,v.vnum
From Tab1 as D left join TAB2 as M in D.id=m.uid left join Tab3 as V on D.id=v.uid order by D.goodlevel Desc,d.cxt_num des C,v.vnum desc LIMIT 10,10

------Solution--------------------
Do not know your business, bad change. The above mentioned index, in fact, you now this statement is not indexed also the same


From Tab1 as D left join

==========================
D is the left table, which is definitely a full-scale sweep. Do you consider whether your actual situation needs to tab1 the whole table data.

