Duration: 6.497 ms , Query= select count(*) as t from `product` where state>0 and classid in (556,604,598,594,593,597,595,596) and price1>='3.99' and price1<='4.99' Duration: 7.3135 ms , Query= select * from `product` where state>0 and classid in (556,604,598,594,593,597,595,596) and price1>='3.99' and price1<='4.99' order by id desc limit 0,40 Duration: 0.3385 ms , Query= select classid as v from product where id=13585 Duration: 0.23125 ms , Query= select classid as v from product where id=13571 Duration: 0.21275 ms , Query= select classid as v from product where id=13447 Duration: 0.2185 ms , Query= select classid as v from product where id=13415 Duration: 0.18375 ms , Query= select classid as v from product where id=2332 Duration: 0.16125 ms , Query= select classid as v from product where id=2331 Duration: 0.17525 ms , Query= select classid as v from product where id=2330 Duration: 0.15125 ms , Query= select classid as v from product where id=2329 Duration: 0.19125 ms , Query= select classid as v from product where id=2328 Duration: 0.1515 ms , Query= select classid as v from product where id=2327 Duration: 0.2275 ms , Query= select * from ptaglist where type>=0 Duration: 0.4665 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(556,604,598,594,593,597,595,596) group by tid Duration: 0.18975 ms , Query= select content,id from infoclass where id in (0)