Duration: 3.5325 ms , Query= select count(*) as t from `product` where state>0 and classid in (527) and price1>='1.99' and price1<='2.99' Duration: 7.22875 ms , Query= select * from `product` where state>0 and classid in (527) and price1>='1.99' and price1<='2.99' order by id desc limit 396,12 Duration: 0.44675 ms , Query= select classid as v from product where id=2156 Duration: 0.28425 ms , Query= select classid as v from product where id=1655 Duration: 0.22475 ms , Query= select classid as v from product where id=1654 Duration: 0.207 ms , Query= select classid as v from product where id=1653 Duration: 0.221 ms , Query= select classid as v from product where id=1652 Duration: 0.17925 ms , Query= select classid as v from product where id=1651 Duration: 0.1795 ms , Query= select classid as v from product where id=1650 Duration: 0.18075 ms , Query= select classid as v from product where id=1648 Duration: 0.18725 ms , Query= select classid as v from product where id=1647 Duration: 0.19 ms , Query= select classid as v from product where id=1646 Duration: 0.225 ms , Query= select * from ptaglist where type>=0 Duration: 0.38575 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(527) group by tid Duration: 0.1705 ms , Query= select content,id from infoclass where id in (0)