Duration: 2.88275 ms , Query= select count(*) as t from `product` where state>0 and classid in (581) and price1>='1.99' and price1<='2.99' Duration: 4.928 ms , Query= select * from `product` where state>0 and classid in (581) and price1>='1.99' and price1<='2.99' order by id desc limit 96,12 Duration: 0.21875 ms , Query= select classid as v from product where id=15576 Duration: 0.19175 ms , Query= select classid as v from product where id=15575 Duration: 0.16875 ms , Query= select classid as v from product where id=15574 Duration: 0.15325 ms , Query= select classid as v from product where id=15569 Duration: 0.1475 ms , Query= select classid as v from product where id=15568 Duration: 0.12325 ms , Query= select classid as v from product where id=11316 Duration: 0.147 ms , Query= select classid as v from product where id=10625 Duration: 0.12 ms , Query= select classid as v from product where id=10610 Duration: 0.12 ms , Query= select classid as v from product where id=10545 Duration: 0.12125 ms , Query= select classid as v from product where id=8369 Duration: 0.15725 ms , Query= select * from ptaglist where type>=0 Duration: 0.2765 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(581) group by tid Duration: 0.18675 ms , Query= select content,id from infoclass where id in (0)