Duration: 0.4625 ms , Query= select count(*) as t from `product` where state>0 and classid in (597) and price1>='1.99' and price1<='2.99' Duration: 0.9565 ms , Query= select * from `product` where state>0 and classid in (597) and price1>='1.99' and price1<='2.99' order by id desc limit 40,40 Duration: 0.154 ms , Query= select classid as v from product where id=2407 Duration: 0.142 ms , Query= select classid as v from product where id=2406 Duration: 0.22375 ms , Query= select classid as v from product where id=2399 Duration: 0.162 ms , Query= select classid as v from product where id=2382 Duration: 0.1635 ms , Query= select classid as v from product where id=2355 Duration: 0.15375 ms , Query= select classid as v from product where id=2352 Duration: 0.18875 ms , Query= select classid as v from product where id=2318 Duration: 0.14925 ms , Query= select classid as v from product where id=2312 Duration: 0.16125 ms , Query= select classid as v from product where id=2311 Duration: 0.15475 ms , Query= select classid as v from product where id=2310 Duration: 0.19225 ms , Query= select * from ptaglist where type>=0 Duration: 0.37725 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(597) group by tid Duration: 0.1525 ms , Query= select content,id from infoclass where id in (0)