MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.27


create table mytable (
  id integer,
  start time, 
  end time, 
  interval1 integer, 
  interval2 integer
 );
 
 insert into mytable values (
   1,'12:00:00','16:00:00',55,5
   );
   
 insert into mytable values (
   2,'12:00:00','15:00:00',45,5
 ); 
 
 insert into mytable values (
   3,'12:00:00','15:00:00',65,5
 ); 
create view periods as
select mytable.id, addtime(start,SEC_TO_TIME(a*(interval1 + interval2)*60)) starttime, end, interval1, interval2 from mytable, lateral (
with recursive cte as (
select 0 as a 
union all 
select 1+a from cte where a+1<=time_to_sec(subtime(end,start))/((interval1+interval2)*60))
select * from cte
) b
select * from periods


id
starttime
end
interval1
interval2


1
12:00:00
16:00:00
55
5

1
13:00:00
16:00:00
55
5

1
14:00:00
16:00:00
55
5

1
15:00:00
16:00:00
55
5

1
16:00:00
16:00:00
55
5

2
12:00:00
15:00:00
45
5

2
12:50:00
15:00:00
45
5

2
13:40:00
15:00:00
45
5

2
14:30:00
15:00:00
45
5

3
12:00:00
15:00:00
65
5

3
13:10:00
15:00:00
65
5

3
14:20:00
15:00:00
65
5

id	starttime	end	interval1	interval2
1	12:00:00	16:00:00	55	5
1	13:00:00	16:00:00	55	5
1	14:00:00	16:00:00	55	5
1	15:00:00	16:00:00	55	5
1	16:00:00	16:00:00	55	5
2	12:00:00	15:00:00	45	5
2	12:50:00	15:00:00	45	5
2	13:40:00	15:00:00	45	5
2	14:30:00	15:00:00	45	5
3	12:00:00	15:00:00	65	5
3	13:10:00	15:00:00	65	5
3	14:20:00	15:00:00	65	5