1.mysql优化:
(1)SELECT * FROM PmBrand WHERE updateKey IN(1,3)
查询时间:2.081s 2511条记录
(2)SELECT * FROM PmBrand WHERE updateKey BETWEEN 1 AND 3
查询时间: 0.698s 2801条记录
1.mysql优化:
(1)SELECT * FROM PmBrand WHERE updateKey IN(1,3)
查询时间:2.081s 2511条记录
(2)SELECT * FROM PmBrand WHERE updateKey BETWEEN 1 AND 3
查询时间: 0.698s 2801条记录