Duration: 0.952 ms , Query= select count(*) as t from `product` where state>0 and classid in (541) and price1>='6.99' and price1<='9.99' Duration: 2.594 ms , Query= select * from `product` where state>0 and classid in (541) and price1>='6.99' and price1<='9.99' order by id desc limit 0,40 Duration: 0.1715 ms , Query= select classid as v from product where id=24337 Duration: 0.13375 ms , Query= select classid as v from product where id=24336 Duration: 0.1235 ms , Query= select classid as v from product where id=24335 Duration: 0.13775 ms , Query= select classid as v from product where id=24334 Duration: 0.15125 ms , Query= select classid as v from product where id=24333 Duration: 0.1485 ms , Query= select classid as v from product where id=24332 Duration: 0.15025 ms , Query= select classid as v from product where id=24331 Duration: 0.14625 ms , Query= select classid as v from product where id=24330 Duration: 0.1305 ms , Query= select classid as v from product where id=24329 Duration: 0.1295 ms , Query= select classid as v from product where id=4180 Duration: 0.19525 ms , Query= select * from ptaglist where type>=0 Duration: 0.3085 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(541) group by tid Duration: 0.12675 ms , Query= select content,id from infoclass where id in (0)