Sometimes I will get this slow log. May you fix it. Thanks.
# Time: 2025-01-15T15:50:07.488009Z
# User@Host: root[root] @ localhost [127.0.0.1] Id: 305753
# Query_time: 1.392871 Lock_time: 0.000002 Rows_sent: 1 Rows_examined: 42999
SET timestamp=1736956206;
select * from `fof_upload_files` where exists (select * from `posts` inner join `fof_upload_file_posts` on `posts`.`id` = `fof_upload_file_posts`.`post_id` where `fof_upload_files`.`id` = `fof_upload_file_posts`.`file_id` and `posts`.`id` = 85350 and `type` in ('discussionTagged', 'discussionStickied', 'discussionSuperStickied', 'discussionMerged', 'discussionLocked', 'comment', 'discussionRenamed')) or exists (select 1 from `posts` where `posts`.`id` = 85350 and `posts`.`content` like CONCAT('%', fof_upload_files.url, '%')) order by `fof_upload_files`.`id` asc limit 1000 offset 0;
