mysql 查询时间交集

CREATE INDEX idx_start_time ON events(start_time);
CREATE INDEX idx_end_time ON events(end_time);

EXPLAIN SELECT * FROM events e1, events e2 WHERE e1.start_time < e2.end_time AND e1.end_time > e2.start_time;

CREATE TABLE events (
  id INT PRIMARY KEY,
  start_time DATETIME,
  end_time DATETIME
);

INSERT INTO events (id, start_time, end_time) VALUES
(1, '2023-10-01 10:00:00', '2023-10-01 12:00:00'),
(2, '2023-10-01 11:00:00', '2023-10-01 13:00:00'),
(3, '2023-10-01 14:00:00', '2023-10-01 15:00:00');

SELECT *
FROM events e1, events e2
WHERE e1.id != e2.id
  AND e1.start_time < e2.end_time
  AND e1.end_time > e2.start_time;