select count(t.dvy_sn) num from sup_trade t where t.dvy_reqtime > SUBDATE(now(),INTERVAL 4320 MINUTE) and t.dvy_reqtime < now() and t.dvy_sn ='PD1C160828212940055';