在这里显示最新的3条
select a.* from pds_daily_production_report a where 3>(select count(*) from pds_daily_production_report where id=a.id and date > a.date)
and company_id="1"
and
id in ("42497359170000","42367337080000")
order by a.uwi desc, a.date desc
效果如下图: