Optimize extremely slow SQL query
Indexes to add:

Table: candidates
  (job_id, ref_type)

Table: job_views
  (job_id, views)

Table: autopost_jobs
  (job_id, posts)


Then run again the queries and post the updated EXPLAIN