执行:explain SELECT COUNT(DISTINCT(`ip`)) as `ipnum` FROM `data`.`display` WHERE `uid`='10111' AND `advid` LIKE '%1000%' AND `type`='link' AND `time` BETWEEN '2006-10-09 00:00:00' AND '2006-10-09 00:59:59'
看看,有没有用到索引,还是要全部扫描吧.
看看,有没有用到索引,还是要全部扫描吧.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货