[RSS Feed/News] Query in XF slow in PMA fast

[XenForo]

Exactly this query, once executed in XF and once via phpMyAdmin, results in different times. Anybody got an idea?

Code:

SELECT content_user_id
                                FROM xf_reaction_content AS rc
                                LEFT JOIN xf_post AS post ON (rc.content_id = post.post_id)
                                LEFT JOIN xf_thread USING(thread_id)
                                WHERE  node_id = 42 AND rc.content_type = 'post'
                                AND...

Read more

ادامه مطلب...