Duration: 0.44325 ms , Query= select count(*) as t from `product` where state>0 and classid in (597) and price1>='1.99' and price1<='2.99' Duration: 1.1165 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.1765 ms , Query= select classid as v from product where id=2407 Duration: 0.156 ms , Query= select classid as v from product where id=2406 Duration: 0.1455 ms , Query= select classid as v from product where id=2399 Duration: 0.145 ms , Query= select classid as v from product where id=2382 Duration: 0.15025 ms , Query= select classid as v from product where id=2355 Duration: 0.16125 ms , Query= select classid as v from product where id=2352 Duration: 0.1495 ms , Query= select classid as v from product where id=2318 Duration: 0.13725 ms , Query= select classid as v from product where id=2312 Duration: 0.15775 ms , Query= select classid as v from product where id=2311 Duration: 0.16875 ms , Query= select classid as v from product where id=2310 Duration: 0.21175 ms , Query= select * from ptaglist where type>=0 Duration: 0.4435 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.13725 ms , Query= select content,id from infoclass where id in (0)