    @Test
    public void testVisit() {

        ConditionAddVisitor visitor = createConditionAddVisitor();

        String sql = getSql();

        SQLStatementParser parser = SQLParserUtils.createSQLStatementParser(sql, JdbcConstants.MYSQL);
        SQLSelectStatement stmt = (SQLSelectStatement) parser.parseStatement();
        stmt.accept(visitor);

        Map<String, List<MySqlSelectQueryBlock>> aliasMap = visitor.getBlockMap();
        List<MySqlSelectQueryBlock> lsBlocks = aliasMap.get("ls");
        List<MySqlSelectQueryBlock> esBlocks = aliasMap.get("es");
        if(lsBlocks != null && !lsBlocks.isEmpty()) {
            for (MySqlSelectQueryBlock block : lsBlocks) {
                block.addCondition("ls.id = 0");
            }
        }
        if(esBlocks != null && !esBlocks.isEmpty()) {
            for (MySqlSelectQueryBlock block : esBlocks) {
                block.addCondition("es.id = 0");
            }
        }
        System.out.println(stmt.toString());
    }