MYSQL之时间戳区间查询的那些坑

直接看SQL：

SELECT
    `a`.*, `gs`.`market_price`,
    `gs`.`shop_price`,
    IF( q.q_id IS NULL, 'false', 'true') message_notify
FROM `lb_goods_activity_details` `a`
LEFT JOIN `lb_goods_sku` `gs` ON `gs`.`sku_id` = `a`.`sku_id`
LEFT JOIN `lb_goods_activity` `ga` ON `ga`.`id` = `a`.`activity_id`
LEFT JOIN `lb_queue` `q` ON `q`.`q_goods_id` = a.goods_id 
    AND q.q_type = 1 
    AND q.q_user_id = 1 
    -- 请关注此处的时间戳
    AND ( q.q_implement_time >= '09:55' AND q.q_implement_time <= '10:00' )
WHERE (`a`.`status` = '1' AND (`a`.`start_time` >= '10' AND `a`.`end_time` < '16'))
OR ( `a`.`unlimited` =