Duration: 3.5 ms , Query= select count(*) as t from `product` where state>0 and classid in (553) and price1>='6.99' and price1<='9.99' Duration: 6.34325 ms , Query= select * from `product` where state>0 and classid in (553) and price1>='6.99' and price1<='9.99' order by id desc limit 0,12 Duration: 0.357 ms , Query= select classid as v from product where id=54252 Duration: 0.27725 ms , Query= select classid as v from product where id=46083 Duration: 0.25275 ms , Query= select classid as v from product where id=36031 Duration: 0.4225 ms , Query= select classid as v from product where id=36030 Duration: 0.23625 ms , Query= select classid as v from product where id=36029 Duration: 0.21225 ms , Query= select classid as v from product where id=36028 Duration: 0.2095 ms , Query= select classid as v from product where id=36027 Duration: 0.2075 ms , Query= select classid as v from product where id=35801 Duration: 0.212 ms , Query= select classid as v from product where id=35800 Duration: 0.21 ms , Query= select classid as v from product where id=33295 Duration: 0.26725 ms , Query= select * from ptaglist where type>=0 Duration: 0.4335 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(553) group by tid Duration: 0.2295 ms , Query= select content,id from infoclass where id in (0)