Duration: 1.66025 ms , Query= select * from `product` where state>0 and classid in (586) and price1>='3.99' and price1<='4.99' order by id desc limit 0,80 Duration: 0.203 ms , Query= select classid as v from product where id=31885 Duration: 0.15225 ms , Query= select classid as v from product where id=31691 Duration: 0.1595 ms , Query= select classid as v from product where id=30254 Duration: 0.17475 ms , Query= select classid as v from product where id=17962 Duration: 0.15275 ms , Query= select classid as v from product where id=17961 Duration: 0.1895 ms , Query= select classid as v from product where id=17960 Duration: 0.172 ms , Query= select classid as v from product where id=17938 Duration: 0.17625 ms , Query= select classid as v from product where id=17937 Duration: 0.1735 ms , Query= select classid as v from product where id=9143 Duration: 0.177 ms , Query= select classid as v from product where id=8412 Duration: 0.18625 ms , Query= select classid as v from product where id=8411 Duration: 0.21325 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(586) group by tid Duration: 0.1625 ms , Query= select content,id from infoclass where id in (0)