Duration: 3.83225 ms , Query= select count(*) as t from `product` where state>0 and classid in (530) and price1>='6.99' and price1<='9.99' Duration: 9.321 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.23575 ms , Query= select classid as v from product where id=8150 Duration: 0.16625 ms , Query= select classid as v from product where id=7672 Duration: 0.168 ms , Query= select classid as v from product where id=7671 Duration: 0.14025 ms , Query= select classid as v from product where id=7670 Duration: 0.135 ms , Query= select classid as v from product where id=7669 Duration: 0.1355 ms , Query= select classid as v from product where id=7663 Duration: 0.1685 ms , Query= select classid as v from product where id=7662 Duration: 0.1525 ms , Query= select classid as v from product where id=7661 Duration: 0.16475 ms , Query= select classid as v from product where id=7632 Duration: 0.1785 ms , Query= select classid as v from product where id=7631 Duration: 0.19 ms , Query= select * from ptaglist where type>=0 Duration: 0.341 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.37575 ms , Query= select content,id from infoclass where id in (0)