请问有什么优化的建议么

@Override
    public List<VideoDataList> getVideoList(Integer checkStatus, Date beginDate, Date endDate, String name, PageInfo pageInfo,
                                            long userId) {
        String sqlStr = "SELECT sdkorder.conf, sdkorder.createTime, idFront.name, other.name, sdkorder.customerOrderId," +
                "sdkorder.orderId,  sdkorder.checkStatus, sdkorder.checkPerson, sdkorder.id FROM $orderTable sdkorder LEFT JOIN " +
                "$otherCardTable other ON sdkorder.stOrderId = other.stOrderId left join $frontTable idFront ON sdkorder.stOrderId = " +
                "idFront.stOrderId $condition ORDER BY sdkorder.createTime DESC";
        Sql sql = Sqls.create(sqlStr);
        sql.vars().set("orderTable", dao.getEntity(VideoSdkOrder.class).getTableName());
        sql.vars().set("otherCardTable", dao.getEntity(Video2OtherCardRecord.class).getTableName());
        sql.vars().set("frontTable", dao.getEntity(Video2IdCardFrontRecord.class).getTableName());

        Cnd cnd = Cnd.where("sdkorder.orderStatus", "=", true);
        cnd.and(Cnd.exps(Cnd.exps("other.valid", "is", null)
                .or("other.valid", "=", true)).and(Cnd.exps("idFront.valid", "is", null)
                .or("idFront.valid", "=", true)).and("sdkorder.companyId", "=", userId));
        queryParams(checkStatus, beginDate, endDate, name, cnd);
        sql.setCondition(cnd);
        sql.setPager(dao.createPager(pageInfo.getPage(), pageInfo.getMaxNumPerPage()));
        sql.setCallback(CallbackConstants.VIDEO_SDK_WEB_LIST);
        dao.execute(sql);
        return sql.getObject(List.class);
    }