解决mybatis-plus 查询耗时慢的问题

EntityWrapper ew = new EntityWrapper<>();

  ew.in(TableFieldConstant.F_AUTH_RESULT_ID, ids);

protected String formatSqlIfNeed( boolean need, String sqlStr, Object... params) {

        if (need && !StringUtils.isEmpty(sqlStr)) {

            if (ArrayUtils.isNotEmpty(params)) {

                for ( int i = 0 ; i < params.length; ++i) {

                    String genParamName = "MPGENVAL" + this .paramNameSeq.incrementAndGet();

                    sqlStr = sqlStr.replace(String.format( "{%s}" , i), String.format( "#{%s.paramNameValuePairs.%s}" , this .getParamAlias(), genParamName));

                    this .paramNameValuePairs.put(genParamName, params[i]);

                }

            }

            return sqlStr;

        } else {

            return null ;

        }

    }

sqlStr = sqlStr.replace(String.format( "{%s}" , i), String.format( "#{%s.paramNameValuePairs.%s}" , this .getParamAlias(), genParamName));

// 第一步判断更新或添加

  String[] splitUserId = userGroup.getUserId().split( "," );

  String[] spiltUserName = userGroup.getUserName().split( "," );

  if (StringUtils.isBlank(userGroup.getId())) {

   userGroup.setNum(spiltUserName.length);

   userGroupMapper.insert(userGroup);

  } else {

   userGroup.setNum(spiltUserName.length);

   userGroupMapper.updateById(userGroup);

  }

  /* 第二部删除中间表信息，字段冗余 */

  Map<String, Object> columnMap = new HashMap<String, Object>();

  columnMap.put("USER_GROUP_ID", userGroup.getId());

  groupUsersService.removeByMap(columnMap);

  /* 第三步，批量保存中间表 */

  if (splitUserId.length != 0 ) {

   List<GroupUsers> groupUsersList = Lists.newArrayList();

   for ( int i = 0 ; i < splitUserId.length; i++) {

    GroupUsers gu = new GroupUsers();

    gu.setUserId(splitUserId[i]);

    gu.setUserName(spiltUserName[i]);

    gu.setUserGroupId(userGroup.getId());

    groupUsersList.add(gu);

   }

   groupUsersService.saveBatch(groupUsersList);

  }