Duration: 4.39725 ms , Query= select count(*) as t from `product` where state>0 and classid in (530) and price1>='6.99' and price1<='9.99' Duration: 10.522 ms , Query= select * from `product` where state>0 and classid in (530) and price1>='6.99' and price1<='9.99' order by id desc limit 240,40 Duration: 0.3545 ms , Query= select classid as v from product where id=8150 Duration: 0.30125 ms , Query= select classid as v from product where id=7672 Duration: 0.216 ms , Query= select classid as v from product where id=7671 Duration: 0.20725 ms , Query= select classid as v from product where id=7670 Duration: 0.1635 ms , Query= select classid as v from product where id=7669 Duration: 0.47625 ms , Query= select classid as v from product where id=7663 Duration: 0.23525 ms , Query= select classid as v from product where id=7662 Duration: 0.163 ms , Query= select classid as v from product where id=7661 Duration: 0.175 ms , Query= select classid as v from product where id=7632 Duration: 0.162 ms , Query= select classid as v from product where id=7631 Duration: 0.20275 ms , Query= select * from ptaglist where type>=0 Duration: 0.344 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(530) group by tid Duration: 0.37875 ms , Query= select content,id from infoclass where id in (0)