I pushed a fix for this today. There were two issues: a missing index for that query, and the query was being run multiple times.
https://github.com/discourse/discourse/commit/4c0129ccddb9037467133d37e5a93520a5f86f77
2 Mi Piace