如何用 SQL 查询统计指定时间内记录数量超过指定值的 item_ID？

+-----+--------+------+
| id  | item_id | time  |
+-----+--------+------+
| 1   | 1       | 1     |
| 2   | 2       | 2     |
| 3   | 2       | 2     |
| 4   | 2       | 3     |
| 5   | 2       | 3     |
| 6   | 1       | 4     |
| 7   | 1       | 7     |
| 8   | 1       | 7     |
| 9   | 1       | 8     |
| 10  | 2       | 8     |
| 11  | 1       | 8     |
| 12  | 1       | 9     |
| 13  | 2       | 11    |
+-----+--------+------+

+--------+
| item_id |
+--------+
| 1       |
+--------+

CREATE DATABASE test;
use test;
CREATE TABLE tableName
(
     ID     varchar(300),
     item_ID     varchar(300),
     time     varchar(255)
);

INSERT INTO tableName ( ID , item_ID , time )
VALUES
    ('1', '1', '1'),
    ('2', '2', '2'),
    ('3', '2', '2'),
    ('4', '2', '3'),
    ('5', '2', '3'),
    ('6', '1', '4'),
    ('7', '1', '7'),
    ('8', '1', '7'),
    ('9', '1', '8'),
    ('10', '2', '8'),
    ('11', '1', '8'),
    ('12', '1', '9'),
    ('13', '2', '11');
SELECT DISTINCT c.item_ID
FROM 
    (SELECT 
        (SELECT b.item_ID
        FROM tableName b
        WHERE b.item_ID = a.item_ID
                AND b.time
            BETWEEN a.time
                AND (a.time + 5)
        GROUP BY  b.item_ID
        HAVING count(b.item_ID) >5 ) item_ID
        FROM tableName a
        ORDER BY  a.time) c
    WHERE c.item_ID is NOT null;