SQL Server 最大参数2100个，有什么办法循环查询

//获取数据库中的账号
$account = DB::connection('Me_MuOnline'. $_GET['serverCode'] .'')->table('MEMB_INFO')
 ->leftJoin('MEMB_STAT', 'MEMB_INFO.memb___id', '=','MEMB_STAT.memb___id' )
 ->select('MEMB_INFO.memb___id','MEMB_STAT.ConnectStat','MEMB_STAT.IP','MEMB_STAT.ConnectTM','MEMB_STAT.DisConnectTM');

 // -----------
$character = DB::connection('MuOnline')->table('Character')
            ->leftJoin('AccountCharacter', 'Character.AccountID', '=','AccountCharacter.Id' )
            ->select('Character.AccountID', 'Character.Name', 'Character.Class', 'Character.cLevel','Character.mLevel', 'Character.RESETS', 'Character.Strength', 'Character.Dexterity','Character.Vitality', 'Character.Energy', 'Character.Leadership','Character.MapNumber','Character.MapPosX','Character.MapPosY','AccountCharacter.GameIDC')
            //->whereIn('Character.AccountID',array_slice(json_decode($account->pluck('memb___id'),true),@$_GET['page']*50,2000))
            ->whereIn('Character.AccountID',$account->pluck('memb___id'))
            ->whereIn('Character.Class', $classCode)
            ->where(function ($query) {
                $query->orWhere('Name', 'like', '%' . @$_GET['search'] . '%');
            })
            ->orderBy('RESETS', 'desc')
            ->orderBy('mLevel', 'desc')
            ->orderBy('cLevel', 'desc')
            ->paginate(50)
            ->withPath('?serverCode=' . $_GET['serverCode'] . '&type=level&class=' . @$_GET['class'] . '&search=' . @$_GET['search'] . '');

最大参数2100个，有什么办法循环查询不影响分页和查询搜索

// 这个虽然能查询，然后2000个之后的搜索不到，分页总数也有点问题
->whereIn('Character.AccountID',array_slice(json_decode($account->pluck('memb___id'),true),@$_GET['page']*50,2000))