sql1 数据量14

select t1.orderId,count(1) from xishiqu.xsq_order t1
join xishiqu.xsq_event t2 on t1.eventId=t2.eventId
where date(t1.pubTime)='2017-12-18'
group by t1.orderId
order by 2 desc

sql2 数据量1138806

select t1.orderId,count(1) from xishiqu.xsq_order t1
join xishiqu.xsq_event t2 on using(eventId)
where date(t1.pubTime)='2017-12-18'
group by t1.orderId
order by 2 desc

我一定是用了假的mysql