Slow search results on dedicated server

I have looked through the logs, here’s what we think. These are the slow logs:

# Time: 170718 10:46:28
# User@Host: dbo690621754[dbo690621754] @ localhost [] # Query_time: 0.908832 Lock_time: 0.000093 Rows_sent: 10 Rows_examined: 98046 SET timestamp=1500367588;
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_geodir_gd_place_detail.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_geodir_gd_place_detail ON (wp_geodir_gd_place_detail.post_id = wp_posts.ID) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (3)
) AND wp_posts.post_type = ‘gd_place’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘virtual’) GROUP BY wp_posts.ID ORDER BY wp_geodir_gd_place_detail.geodir_my_custom_sort asc, wp_geodir_gd_place_detail.is_featured asc, wp_posts.post_date desc, wp_posts.post_title LIMIT 10, 10; # Time: 170718 10:46:31 # User@Host: dbo690621754[dbo690621754] @ localhost [] # Query_time: 0.820267 Lock_time: 0.000112 Rows_sent: 10 Rows_examined: 98046 SET timestamp=1500367591;
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_geodir_gd_place_detail.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_geodir_gd_place_detail ON (wp_geodir_gd_place_detail.post_id = wp_posts.ID) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (3)
) AND wp_posts.post_type = ‘gd_place’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘virtual’) GROUP BY wp_posts.ID ORDER BY wp_geodir_gd_place_detail.geodir_my_custom_sort asc, wp_geodir_gd_place_detail.is_featured asc, wp_posts.post_date desc, wp_posts.post_title LIMIT 20, 10; # Time: 170718 10:46:34 # User@Host: dbo690621754[dbo690621754] @ localhost [] # Query_time: 0.797096 Lock_time: 0.000100 Rows_sent: 10 Rows_examined: 98046 SET timestamp=1500367594;
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_geodir_gd_place_detail.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_geodir_gd_place_detail ON (wp_geodir_gd_place_detail.post_id = wp_posts.ID) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (3)
) AND wp_posts.post_type = ‘gd_place’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘virtual’) GROUP BY wp_posts.ID ORDER BY wp_geodir_gd_place_detail.geodir_my_custom_sort asc, wp_geodir_gd_place_detail.is_featured asc, wp_posts.post_date desc, wp_posts.post_title LIMIT 30, 10; # Time: 170718 10:46:38 # User@Host: dbo690621754[dbo690621754] @ localhost [] # Query_time: 0.804067 Lock_time: 0.000094 Rows_sent: 4 Rows_examined: 98046 SET timestamp=1500367598;
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_geodir_gd_place_detail.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_geodir_gd_place_detail ON (wp_geodir_gd_place_detail.post_id = wp_posts.ID) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (3)
) AND wp_posts.post_type = ‘gd_place’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘virtual’) GROUP BY wp_posts.ID ORDER BY wp_geodir_gd_place_detail.geodir_my_custom_sort asc, wp_geodir_gd_place_detail.is_featured asc, wp_posts.post_date desc, wp_posts.post_title LIMIT 16010, 10;