Duration: 18.45875 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: 213.98325 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.2315 ms , Query= select classid as v from product where id=54780 Duration: 0.213 ms , Query= select classid as v from product where id=54779 Duration: 0.181 ms , Query= select classid as v from product where id=54778 Duration: 0.13575 ms , Query= select classid as v from product where id=54777 Duration: 0.15675 ms , Query= select classid as v from product where id=54776 Duration: 0.1445 ms , Query= select classid as v from product where id=54775 Duration: 0.1455 ms , Query= select classid as v from product where id=54774 Duration: 0.1535 ms , Query= select classid as v from product where id=54773 Duration: 0.13 ms , Query= select classid as v from product where id=54772 Duration: 0.12275 ms , Query= select classid as v from product where id=54771 Duration: 0.22425 ms , Query= select * from ptaglist where type>=0 Duration: 0.37675 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.18575 ms , Query= select content,id from infoclass where id in (0)