Support light paginate the query. does not support counting total item because counting on large table is expensive update: count total if needed