Duration: 3.112 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.194 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.3395 ms , Query= select classid as v from product where id=19585 Duration: 0.19 ms , Query= select classid as v from product where id=19584 Duration: 0.1505 ms , Query= select classid as v from product where id=19583 Duration: 0.1415 ms , Query= select classid as v from product where id=16015 Duration: 0.155 ms , Query= select classid as v from product where id=16014 Duration: 0.1795 ms , Query= select classid as v from product where id=16013 Duration: 0.16725 ms , Query= select classid as v from product where id=16012 Duration: 0.18275 ms , Query= select classid as v from product where id=16011 Duration: 0.1375 ms , Query= select classid as v from product where id=16010 Duration: 0.16425 ms , Query= select classid as v from product where id=786 Duration: 0.186 ms , Query= select * from ptaglist where type>=0 Duration: 0.404 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.164 ms , Query= select content,id from infoclass where id in (0)