This query is consistently performing slow. Any thoughts from where it's coming and how can I improve the performance? Thanks
# Time: 2021-03-20T20:47:29.558248Z
# User@Host: xxxx[xxxx] @ localhost [] Id: 2551630
# Query_time: 35.480665 Lock_time: 0.000047 Rows_sent: 5 Rows_examined: 2423624
use xxxx;
SET timestamp=1616273249;
/*xxxx::xxxx::IPS\Content\_WidgetComment::render:833*/ SELECT forums_posts.*, forums_topics.* FROM `ipb_forums_posts` AS `forums_posts` STRAIGHT_JOIN `ipb_forums_topics` AS `forums_topics` ON forums_posts.topic_id=forums_topics.tid AND forums_topics.approved=1 AND forums_topics.approved!=-2 AND forums_topics.approved !=-3 LEFT JOIN `ipb_forums_forums` AS `forums_forums` ON forums_topics.forum_id=forums_forums.id AND forums_forums.password IS NULL AND forums_forums.can_view_others=1 AND ( forums_forums.password IS NULL OR ( FIND_IN_SET(2,forums_forums.password_override) ) ) AND forums_forums.min_posts_view<=0 WHERE forums_forums.can_view_others=1 AND queued=0 AND forums_posts.queued!=-2 AND forums_posts.queued !=-3 AND forums_topics.forum_id IN(4,8,11,12,13,24,26,38,42,49,52,53,68,69,75,76,77,81,83,124,125,128,133,134,135,138,143,159,171,172,181,193,195,196,197,198,199,201,202,205,206,207,208,209,210,211,213,218,220,221,224,238,245,246,247,248,249,251,252,254,255,256,257,258,259,260,262,263,266,269,270,275) ORDER BY post_date DESC LIMIT 5;