Change Query to return by record id desc, then use limit to page through results. Also look at adding search wildcards to all fields making a searchable log.
Using wildcards might allow looking for a location code or specific draft id, or linnworks items id.