Duration: 36.52725 ms , Query= select count(*) as t from `product` where state>0 and classid in (545,572,573,574,575,576,577,578,579,605) and price1>='19.99' and price1<='29.99' Duration: 250.5645 ms , Query= select * from `product` where state>0 and classid in (545,572,573,574,575,576,577,578,579,605) and price1>='19.99' and price1<='29.99' order by id desc limit 0,40 Duration: 0.2765 ms , Query= select classid as v from product where id=54780 Duration: 0.36075 ms , Query= select classid as v from product where id=54779 Duration: 0.2505 ms , Query= select classid as v from product where id=54778 Duration: 0.20025 ms , Query= select classid as v from product where id=54777 Duration: 0.1785 ms , Query= select classid as v from product where id=54776 Duration: 0.1615 ms , Query= select classid as v from product where id=54775 Duration: 0.1755 ms , Query= select classid as v from product where id=54774 Duration: 0.164 ms , Query= select classid as v from product where id=54773 Duration: 0.1665 ms , Query= select classid as v from product where id=54772 Duration: 0.17525 ms , Query= select classid as v from product where id=54771 Duration: 0.21275 ms , Query= select * from ptaglist where type>=0 Duration: 0.47525 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(545,572,573,574,575,576,577,578,579,605) group by tid Duration: 0.16825 ms , Query= select content,id from infoclass where id in (0)