Duration: 2.50825 ms , Query= select count(*) as t from `product` where state>0 and classid in (528) and price1>='3.99' and price1<='4.99' Duration: 6.072 ms , Query= select * from `product` where state>0 and classid in (528) and price1>='3.99' and price1<='4.99' order by id desc limit 80,80 Duration: 0.2315 ms , Query= select classid as v from product where id=19367 Duration: 0.145 ms , Query= select classid as v from product where id=19164 Duration: 0.1505 ms , Query= select classid as v from product where id=19163 Duration: 0.20625 ms , Query= select classid as v from product where id=19162 Duration: 0.13375 ms , Query= select classid as v from product where id=18043 Duration: 0.1275 ms , Query= select classid as v from product where id=18040 Duration: 0.1405 ms , Query= select classid as v from product where id=18039 Duration: 0.127 ms , Query= select classid as v from product where id=18038 Duration: 0.16725 ms , Query= select classid as v from product where id=8195 Duration: 0.13175 ms , Query= select classid as v from product where id=6619 Duration: 0.16275 ms , Query= select * from ptaglist where type>=0 Duration: 0.27525 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(528) group by tid Duration: 0.14075 ms , Query= select content,id from infoclass where id in (0)