SELECT * FROM `bill` WHERE (  ( `card_id` = 1 OR `other_card_id` = 1 )  AND `time` >  '2019-01-01 00:00:00' ) AND `bill`.`delete_time` IS NULL ORDER BY `time` ASC LIMIT 0,50