Duration: 3.06525 ms , Query= select count(*) as t from `product` where state>0 and classid in (530) and price1>='6.99' and price1<='9.99' Duration: 7.165 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,80 Duration: 0.2175 ms , Query= select classid as v from product where id=8150 Duration: 0.1615 ms , Query= select classid as v from product where id=7672 Duration: 0.15225 ms , Query= select classid as v from product where id=7671 Duration: 0.13125 ms , Query= select classid as v from product where id=7670 Duration: 0.1805 ms , Query= select classid as v from product where id=7669 Duration: 0.2515 ms , Query= select classid as v from product where id=7663 Duration: 0.1355 ms , Query= select classid as v from product where id=7662 Duration: 0.11975 ms , Query= select classid as v from product where id=7661 Duration: 0.132 ms , Query= select classid as v from product where id=7632 Duration: 0.12125 ms , Query= select classid as v from product where id=7631 Duration: 0.15675 ms , Query= select * from ptaglist where type>=0 Duration: 0.288 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.18925 ms , Query= select content,id from infoclass where id in (0)