amqamq

Another suggestion:

# Query_time: 3.020646  Lock_time: 0.000067 Rows_sent: 10  Rows_examined: 48686
SET timestamp=1420400812;
SELECT   wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1  AND (
  wp_posts.post_date_gmt > '2014-12-31 11:46:49'
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) AND (
  wp_postmeta.meta_key = 'socialcount_TOTAL'
) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 10;

I am sure this data can be retrieved faster than in 3 seconds.