PasteBin

      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.