Duration: 28.29625 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: 233.7585 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,12 Duration: 0.227 ms , Query= select classid as v from product where id=54780 Duration: 0.1695 ms , Query= select classid as v from product where id=54779 Duration: 0.17225 ms , Query= select classid as v from product where id=54778 Duration: 0.21175 ms , Query= select classid as v from product where id=54777 Duration: 0.18325 ms , Query= select classid as v from product where id=54776 Duration: 0.178 ms , Query= select classid as v from product where id=54775 Duration: 0.17025 ms , Query= select classid as v from product where id=54774 Duration: 0.14975 ms , Query= select classid as v from product where id=54773 Duration: 0.138 ms , Query= select classid as v from product where id=54772 Duration: 0.164 ms , Query= select classid as v from product where id=54771 Duration: 0.21925 ms , Query= select * from ptaglist where type>=0 Duration: 0.412 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.21075 ms , Query= select content,id from infoclass where id in (0)