how to find time gaps and gap length between mysql table records?

My table looks like this:

I have MySQL 8.0.21

always next 3 rows have same time and then beetwen usualy is 5 seconds time gap, how to find all gap longer than 8 second and also count gap time to get something like that:

If you're using MySQL 8+ you can use the LEAD() window function like this:

select * from (
    SELECT id as gap_id, 
        `time` as gap_start_time, 
        timediff( lead(`time`) over W, `time`) as gap_length 
        from `myTable` window w as (order by `time` asc)
    ) T where T.gap_length > 5;

Output:

12, 2021-07-17 17:44:41, 00:00:10
18, 2021-07-17 17:44:56, 00:00:06

Reference: LEAD()