我有一个查询，它需要11秒来获取记录，因为数据库很大，大约有150mb(编辑：抱歉这不是很大，人们让我意识到我：d）
如何优化此查询？

select id, post_title,featured, location, application_deadline, post_name, post_content, post_date as d, logo FROM wp_posts
  LEFT JOIN wp_term_relationships ON wp_posts.id = wp_term_relationships.object_id
  LEFT JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
  LEFT JOIN wp_terms ON wp_term_taxonomy.term_id = wp_terms.term_id
  WHERE wp_posts.post_status='publish' 
        AND wp_posts.post_type='post' 
        AND wp_term_taxonomy.taxonomy = 'category'
        AND wp_terms.post_type='news' 
        order by post_date desc limit 0, 9