The Closed ticket queue seems to be unusable. Everytime I click on the tab, it times out or takes forever to load.

Specs:
osTicket: 1.16.3
MariaDB: 10.4.8
Storage Engine: InnoDB
4 CPUs
16GB RAM

Here is the query that seems to be causing the issue when running SHOW FULL PROCESSLIST:
SELECT A1.numberASnumber, A1.ticket_idASticket_id, A1.sourceASsource, A1.closedASclosed, B2.subjectAScdatasubject, A1.isoverdueASisoverdue, B3.nameASusername, B4.firstnameASstafffirstname, B4.lastnameASstafflastname, B5.nameASteamname, A1.team_idASteam_id, A1.dept_idASdept_id, B6.nameASdeptname, A1.isanswered= '0' AS2GkBZxz, (SELECT COUNT(R0.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_entryR0 ON (Q7.id= R0.thread_id) WHERE Q8.ticket_id= A1.ticket_idAND NOT R0.flags& 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_entryR0 ON (Q7.id= R0.thread_id) LEFT JOINost_attachmentR1 ON (R1.type= 'H' AND R0.id= R1.object_id) WHERE Q8.ticket_id= A1.ticket_idAND R1.inline= 0) AS _att_count, B7.expire> NOW() AND NOT B7.staff_id= 1 AS_locked, (SELECT COUNT(R0.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_collaboratorR0 ON (Q7.id= R0.thread_id) WHERE Q8.ticket_id= A1.ticket_id) AS _collabs, COALESCE(B4.firstname, B4.lastname, B5.name, 'zzz') ASassigneeFROMost_ticketA1 JOINost_ticket_statusA2 ON (A1.status_id= A2.id) LEFT JOINost_threadA3 ON (A3.object_type= 'T' AND A1.ticket_id= A3.object_id) LEFT JOINost_thread_referralA4 ON (A3.id= A4.thread_id) LEFT JOINost_staffA5 ON (A4.object_type= 'S' AND A4.object_id= A5.staff_id) LEFT JOINost_threadA6 ON (A1.ticket_id= A6.object_idAND A6.object_type= 'C') LEFT JOINost_thread_referralA7 ON (A6.id= A7.thread_id) LEFT JOINost_staffA8 ON (A7.object_type= 'S' AND A7.object_id= A8.staff_id) LEFT JOINost_departmentB0 ON (A4.object_type= 'D' AND A4.object_id= B0.id) LEFT JOINost_departmentB1 ON (A7.object_type= 'D' AND A7.object_id= B1.id) LEFT JOINost_ticket__cdataB2 ON (A1.ticket_id= B2.ticket_id) LEFT JOINost_userB3 ON (A1.user_id= B3.id) LEFT JOINost_staffB4 ON (A1.staff_id= B4.staff_id) LEFT JOINost_teamB5 ON (A1.team_id= B5.team_id) LEFT JOINost_departmentB6 ON (A1.dept_id= B6.id) LEFT JOINost_lockB7 ON (A1.lock_id= B7.lock_id) WHERE A2.state= 'closed' AND ((A2.state= 'open' AND (A1.staff_id= 1 OR A5.staff_id= 1 OR A6.object_type= 'C' AND A8.staff_id= 1)) OR A1.dept_idIN (1, 5, 10, 11, 12) OR B0.idIN (1, 5, 10, 11, 12) OR A6.object_type= 'C' AND B1.idIN (1, 5, 10, 11, 12)) AND (A1.ticket_pidIS NULL OR A1.flags& 8 != 0) GROUP BY A1.ticket_idORDER BY A1.closedDESC LIMIT 50