explain extended
select
r.id, r.title, r.pinyin, r.pinyin2, r.tags, r.category_id, r.is_active, r.is_locked, r.inactive_reason,
r.updated_on, r.released_on, r.total_episodes, r.released_episodes, r.lang_id, r.director, r.actors, r.roles,
r.produced_by, r.description, r.duration, r.grade_id, r.thumbnail_id, r.score, rap.priority, rap.ordinal,
rt.thumbnail
from resource r
left join res_alias ral on r.id=ral.res_id
left join res_thumbnail rt on r.thumbnail_id=rt.id
left join res_app rap on r.id=rap.res_id
left join res_area rar on r.id=rar.res_id
left join res_style rs on r.id=rs.res_id
where 1=1 group by r.id, updated order by r.updated_on DESC limit 1, 30以上SQL语句第一次执行完成需要9.898ms。使用explain分析,发现Using temporary
r.updated_on 已经加入索引,请问该如何优化。
select
r.id, r.title, r.pinyin, r.pinyin2, r.tags, r.category_id, r.is_active, r.is_locked, r.inactive_reason,
r.updated_on, r.released_on, r.total_episodes, r.released_episodes, r.lang_id, r.director, r.actors, r.roles,
r.produced_by, r.description, r.duration, r.grade_id, r.thumbnail_id, r.score, rap.priority, rap.ordinal,
rt.thumbnail
from resource r
left join res_alias ral on r.id=ral.res_id
left join res_thumbnail rt on r.thumbnail_id=rt.id
left join res_app rap on r.id=rap.res_id
left join res_area rar on r.id=rar.res_id
left join res_style rs on r.id=rs.res_id
where 1=1 group by r.id, updated order by r.updated_on DESC limit 1, 30以上SQL语句第一次执行完成需要9.898ms。使用explain分析,发现Using temporary
r.updated_on 已经加入索引,请问该如何优化。
create index on resource(id,updated);