select * from user where A=? and B=? and (E in (?, ?) or F = ?)
LambdaQueryWrapper<FirstUser> queryWrapper = Wrappers.lambdaQuery();
queryWrapper
.and(q -> q.eq(FirstUser::getUserName, "123")
.eq(FirstUser::getUserPassword, "***")
)
.and(q -> q.like(FirstUser::getUserName, "2")
.or()
.like(FirstUser::getUserPassword, "*"))
.last("limit 50");
return list(queryWrapper);