背景:查询该活动时间范围内是否有存在的活动(交集)
SELECT * FROM activity
WHERE deleteFlag = FALSE AND
(
(beginningTime <= #{startTime} AND closingTime >= #{startTime}) OR
(beginningTime <= #{endTime} AND closingTime >= #{endTime}) OR
(beginningTime >= #{startTime} AND closingTime <= #{endTime})
);