ALTER TABLE eq_loan ADD INDEX i_active_due (dateReturn, dateDue),ADD INDEX i_active_loan (dateReturn, dateLoan),ADD INDEX i_uid_return (uid, dateReturn),ADD INDEX i_barcode_return (barcode, dateReturn);
ALTER TABLE eq_items ADD INDEX i_barcode_rid_iid (barcode, rid, iid), ADD INDEX i_rid_iid_deleted (rid, iid, deleted);
ALTER TABLE eq_itemFields ADD INDEX i_sfId_value_rid_iid (sfId, sfValue(50), rid, iid);
