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
