Duration: 71.82425 ms , Query= select count(*) as t from `product` where state>0 and classid<>542 and price1>='1.99' and price1<='2.99' Duration: 82.56075 ms , Query= select * from `product` where state>0 and classid<>542 and price1>='1.99' and price1<='2.99' order by id desc limit 5172,12 Duration: 0.381 ms , Query= select classid as v from product where id=41244 Duration: 0.2895 ms , Query= select classid as v from product where id=41243 Duration: 0.21025 ms , Query= select classid as v from product where id=41232 Duration: 0.2145 ms , Query= select classid as v from product where id=41231 Duration: 0.18775 ms , Query= select classid as v from product where id=41170 Duration: 0.19125 ms , Query= select classid as v from product where id=41169 Duration: 0.20225 ms , Query= select classid as v from product where id=41168 Duration: 0.17875 ms , Query= select classid as v from product where id=41167 Duration: 0.17675 ms , Query= select classid as v from product where id=41165 Duration: 0.1775 ms , Query= select classid as v from product where id=41164 Duration: 0.19875 ms , Query= select classid as v from product where id=41163 Duration: 0.181 ms , Query= select classid as v from product where id=41162 Duration: 0.18825 ms , Query= select content,id from infoclass where id in (0)