oap-server/server-storage-plugin/storage-jdbc-hikaricp-plugin/src/main/java/org/apache/skywalking/oap/server/storage/plugin/jdbc/common/dao/JDBCEventQueryDAO.java [67:99]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
        final var events = new ArrayList<org.apache.skywalking.oap.server.core.query.type.event.Event>();

        for (String table : tables) {
            String sql = "select * from " + table + whereClause;
            if (Order.DES.equals(queryOrder)) {
                sql += " order by " + Event.START_TIME + " desc";
            } else {
                sql += " order by " + Event.START_TIME + " asc";
            }
            sql += " limit " + (page.getLimit() + page.getFrom());
            if (log.isDebugEnabled()) {
                log.debug("Query SQL: {}, parameters: {}", sql, parameters);
            }

            jdbcClient.executeQuery(sql, resultSet -> {
                while (resultSet.next()) {
                    events.add(parseResultSet(resultSet));
                }
                return null;
            }, parameters);
        }

        final var comparator = Order.DES.equals(queryOrder) ?
            comparing(org.apache.skywalking.oap.server.core.query.type.event.Event::getStartTime).reversed() :
            comparing(org.apache.skywalking.oap.server.core.query.type.event.Event::getStartTime);
        return new Events(
            events
                .stream()
                .sorted(comparator)
                .skip(page.getFrom())
                .limit(page.getLimit())
                .collect(toList())
        );
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



oap-server/server-storage-plugin/storage-jdbc-hikaricp-plugin/src/main/java/org/apache/skywalking/oap/server/storage/plugin/jdbc/common/dao/JDBCEventQueryDAO.java [121:153]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
        final var events = new ArrayList<org.apache.skywalking.oap.server.core.query.type.event.Event>();

        for (String table : tables) {
            String sql = "select * from " + table + whereClause;
            if (Order.DES.equals(queryOrder)) {
                sql += " order by " + Event.START_TIME + " desc";
            } else {
                sql += " order by " + Event.START_TIME + " asc";
            }
            sql += " limit " + (page.getLimit() + page.getFrom());
            if (log.isDebugEnabled()) {
                log.debug("Query SQL: {}, parameters: {}", sql, parameters);
            }
            jdbcClient.executeQuery(sql, resultSet -> {
                while (resultSet.next()) {
                    events.add(parseResultSet(resultSet));
                }

                return null;
            }, parameters);
        }

        final var comparator = Order.DES.equals(queryOrder) ?
            comparing(org.apache.skywalking.oap.server.core.query.type.event.Event::getStartTime).reversed() :
            comparing(org.apache.skywalking.oap.server.core.query.type.event.Event::getStartTime);
        return new Events(
            events
                .stream()
                .sorted(comparator)
                .skip(page.getFrom())
                .limit(page.getLimit())
                .collect(toList())
        );
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -