Duration: 2.5975 ms , Query= select count(*) as t from `product` where state>0 and classid in (526) and price1>='1.99' and price1<='2.99' Duration: 5.61925 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.2105 ms , Query= select classid as v from product where id=38545 Duration: 0.13925 ms , Query= select classid as v from product where id=38544 Duration: 0.12675 ms , Query= select classid as v from product where id=34437 Duration: 0.12425 ms , Query= select classid as v from product where id=33404 Duration: 0.12925 ms , Query= select classid as v from product where id=33401 Duration: 0.1285 ms , Query= select classid as v from product where id=28859 Duration: 0.1575 ms , Query= select classid as v from product where id=28858 Duration: 0.1485 ms , Query= select classid as v from product where id=27465 Duration: 0.15725 ms , Query= select classid as v from product where id=27463 Duration: 0.1405 ms , Query= select classid as v from product where id=20001 Duration: 0.177 ms , Query= select * from ptaglist where type>=0 Duration: 0.2965 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.13175 ms , Query= select content,id from infoclass where id in (0)