Duration: 0.46 ms , Query= select count(*) as t from `product` where state>0 and classid in (626) and price1>='0.99' and price1<='1.99' Duration: 0.66075 ms , Query= select * from `product` where state>0 and classid in (626) and price1>='0.99' and price1<='1.99' order by id desc limit 40,40 Duration: 0.152 ms , Query= select classid as v from product where id=31947 Duration: 0.13475 ms , Query= select classid as v from product where id=31946 Duration: 0.13025 ms , Query= select classid as v from product where id=31945 Duration: 0.13125 ms , Query= select classid as v from product where id=31944 Duration: 0.13125 ms , Query= select classid as v from product where id=31943 Duration: 0.1285 ms , Query= select classid as v from product where id=31942 Duration: 0.147 ms , Query= select classid as v from product where id=31941 Duration: 0.1385 ms , Query= select classid as v from product where id=31940 Duration: 0.1355 ms , Query= select classid as v from product where id=31939 Duration: 0.184 ms , Query= select classid as v from product where id=31938 Duration: 0.181 ms , Query= select * from ptaglist where type>=0 Duration: 0.30125 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(626) group by tid Duration: 0.13775 ms , Query= select content,id from infoclass where id in (0)