Duration: 5.898 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: 6.161 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.28925 ms , Query= select classid as v from product where id=13585 Duration: 0.17325 ms , Query= select classid as v from product where id=13571 Duration: 0.1245 ms , Query= select classid as v from product where id=13447 Duration: 0.14875 ms , Query= select classid as v from product where id=13415 Duration: 0.14875 ms , Query= select classid as v from product where id=2332 Duration: 0.167 ms , Query= select classid as v from product where id=2331 Duration: 0.12875 ms , Query= select classid as v from product where id=2330 Duration: 0.1435 ms , Query= select classid as v from product where id=2329 Duration: 0.12875 ms , Query= select classid as v from product where id=2328 Duration: 0.14925 ms , Query= select classid as v from product where id=2327 Duration: 0.26925 ms , Query= select * from ptaglist where type>=0 Duration: 0.378 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.174 ms , Query= select content,id from infoclass where id in (0)