[Indrekkor]

Hello,

Been optimizing my bbPress install, have managed to make it blazing fast with switching to MariaDB and configuring indexes.

Now i got rid of the usual slow-queries from my slow-query.log now something appeared that i haven’t seen before.

https://pastebin.com/rhUz90gf

Is this a core bbPress query?

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_parent IN (LONG LIST OF IDs)
AND (
  ( wp_postmeta.meta_key = '_bbp_forum_id' AND CAST(wp_postmeta.meta_value AS SIGNED) NOT IN ('11212874','22','1778309','2273738') )
) AND wp_posts.post_type = 'reply' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC, wp_posts.ID DESC LIMIT 0, 1;

[Robin W]

not directly, but bbpress does call wordpress functions via wp_query, and suspect this is the result of one of those.