Duration: 19.829 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: 192.9095 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.264 ms , Query= select classid as v from product where id=54780 Duration: 0.17925 ms , Query= select classid as v from product where id=54779 Duration: 0.21625 ms , Query= select classid as v from product where id=54778 Duration: 0.1355 ms , Query= select classid as v from product where id=54777 Duration: 0.15 ms , Query= select classid as v from product where id=54776 Duration: 0.1685 ms , Query= select classid as v from product where id=54775 Duration: 0.1625 ms , Query= select classid as v from product where id=54774 Duration: 0.1365 ms , Query= select classid as v from product where id=54773 Duration: 0.134 ms , Query= select classid as v from product where id=54772 Duration: 0.1315 ms , Query= select classid as v from product where id=54771 Duration: 0.20425 ms , Query= select * from ptaglist where type>=0 Duration: 0.34875 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.13275 ms , Query= select content,id from infoclass where id in (0)