Duration: 3.726 ms , Query= select count(*) as t from `product` where state>0 and classid in (526) and price1>='1.99' and price1<='2.99' Duration: 8.2485 ms , Query= select * from `product` where state>0 and classid in (526) and price1>='1.99' and price1<='2.99' order by id desc limit 40,40 Duration: 0.20225 ms , Query= select classid as v from product where id=38545 Duration: 0.1875 ms , Query= select classid as v from product where id=38544 Duration: 0.17275 ms , Query= select classid as v from product where id=34437 Duration: 0.3505 ms , Query= select classid as v from product where id=33404 Duration: 0.2095 ms , Query= select classid as v from product where id=33401 Duration: 0.15375 ms , Query= select classid as v from product where id=28859 Duration: 0.1955 ms , Query= select classid as v from product where id=28858 Duration: 0.18925 ms , Query= select classid as v from product where id=27465 Duration: 0.184 ms , Query= select classid as v from product where id=27463 Duration: 0.1665 ms , Query= select classid as v from product where id=20001 Duration: 0.2265 ms , Query= select * from ptaglist where type>=0 Duration: 0.3305 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(526) group by tid Duration: 0.14025 ms , Query= select content,id from infoclass where id in (0)