SELECT hdt.id_ticket, hdt.id_last_msg, hdt.id_member_started, hdt.id_member_updated, hdt.id_member_assigned,
hdt.subject, hdt.status, hdt.num_replies, hdt.private, hdt.urgency, hdtr_first.poster_name AS ticket_opener, hdtr_last.poster_time,
IFNULL(hdlr.id_msg, 0) AS log_read
FROM smf_helpdesk_tickets AS hdt
INNER JOIN smf_helpdesk_ticket_replies AS hdtr_first ON (hdt.id_first_msg = hdtr_first.id_msg)
INNER JOIN smf_helpdesk_ticket_replies AS hdtr_last ON (hdt.id_last_msg = hdtr_last.id_msg)
LEFT JOIN smf_helpdesk_log_read AS hdlr ON (hdt.id_ticket = hdlr.id_ticket AND hdlr.id_member = 1)
WHERE 1=1
AND status NOT IN(3, 6)
ORDER BY hdtr_last.poster_time
LIMIT 213310, 10
in .../Sources/SimpleDesk.php line 314, which took 10.973104 seconds at 0.13512111 into request.