Thread: Jobroller is slow, My Host Provider asked me to contat you!

# Mon Aug 12 11:05:36 2013
# Query_time: 1.582011  Lock_time: 0.000298 Rows_sent: 2  Rows_examined: 7793
use yesijobc_wor1;
SET timestamp=1376327136;
SELECT SQL_CALC_FOUND_ROWS  wrd_posts.ID FROM wrd_posts  LEFT JOIN wrd_postmeta ON wrd_posts.ID = wrd_postmeta.post_id  WHERE 1=1  AND (((wrd_posts.post_title LIKE '%factory%') OR (wrd_posts.post_content LIKE '%factory%') OR ((wrd_postmeta.meta_key = '_Company') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = 'geo_address') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = '_CompanyURL') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = 'geo_short_address') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = 'geo_country') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = 'geo_short_address_country') AND (wrd_postmeta.meta_value  LIKE '%factory%')))) AND (wrd_posts.post_status = 'publish') AND (wrd_posts.post_type = 'job_listing') GROUP BY  wrd_posts.ID  ORDER BY wrd_posts.post_date DESC LIMIT 0, 10