Duration: 3.5425 ms , Query= select count(*) as t from `product` where state>0 and classid in (611) and price1>='9.99' and price1<='19.99' Duration: 7.97075 ms , Query= select * from `product` where state>0 and classid in (611) and price1>='9.99' and price1<='19.99' order by id desc limit 0,40 Duration: 0.3355 ms , Query= select classid as v from product where id=19585 Duration: 0.22275 ms , Query= select classid as v from product where id=19584 Duration: 0.188 ms , Query= select classid as v from product where id=19583 Duration: 0.14925 ms , Query= select classid as v from product where id=16015 Duration: 0.175 ms , Query= select classid as v from product where id=16014 Duration: 0.178 ms , Query= select classid as v from product where id=16013 Duration: 0.18075 ms , Query= select classid as v from product where id=16012 Duration: 0.17875 ms , Query= select classid as v from product where id=16011 Duration: 0.14075 ms , Query= select classid as v from product where id=16010 Duration: 0.35275 ms , Query= select classid as v from product where id=786 Duration: 0.1915 ms , Query= select * from ptaglist where type>=0 Duration: 0.354 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(611) group by tid Duration: 0.212 ms , Query= select content,id from infoclass where id in (0)