0 - 1 of 1 tags for tune

dear all, below is my query and the explain.

any suggestion on how to tune the query..thx for your time.

-----------------------------------------------------------------------------------------