Duration: 1.70275 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,40 Duration: 0.2355 ms , Query= select classid as v from product where id=31885 Duration: 0.1895 ms , Query= select classid as v from product where id=31691 Duration: 0.18775 ms , Query= select classid as v from product where id=30254 Duration: 0.17725 ms , Query= select classid as v from product where id=17962 Duration: 0.1835 ms , Query= select classid as v from product where id=17961 Duration: 0.16225 ms , Query= select classid as v from product where id=17960 Duration: 0.17775 ms , Query= select classid as v from product where id=17938 Duration: 0.179 ms , Query= select classid as v from product where id=17937 Duration: 0.1775 ms , Query= select classid as v from product where id=9143 Duration: 0.1605 ms , Query= select classid as v from product where id=8412 Duration: 0.1725 ms , Query= select classid as v from product where id=8411 Duration: 0.291 ms , Query= select * from ptaglist where type>=0 Duration: 0.40725 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.16 ms , Query= select content,id from infoclass where id in (0)