If you can't comment the function how you did you stopped the query from running? We have 30 agents so query runs on staff activity and every 3 mins from cron running for email fetching.This is from slow queries report
collapse;width">Total
Avg
Max
count
query
02.0
02.0
02.0
1
SELECT A1.* FROM `ost_file` A1 LEFT
JOIN `ost_attachment` A2 ON (A1.`id` = A2.`file_id`) WHERE (A2.`object_id` IS
NULL AND A1.`ft` = ? AND A1.`created` < NOW() - INTERVAL ? DAY) LIMIT ?, ?
01.0
01.0
01.0
1
SELECT SQL_CALC_FOUND_ROWS A1.*
FROM `ost_file` A1 LEFT JOIN `ost_attachment` A2 ON (A1.`id` = A2.`file_id`)
WHERE (A2.`object_id` IS NULL AND A1.`ft` = ? AND A1.`created` < NOW() -
INTERVAL ? DAY) LIMIT ?
17.0
01.0
02.0
10
SELECT A1.* FROM `ost_file` A1 LEFT
JOIN `ost_attachment` A2 ON (A1.`id` = A2.`file_id`) WHERE (A2.`object_id` IS
NULL AND A1.`ft` = ? AND A1.`created` < NOW() - INTERVAL ? DAY)