Duration: 1.49275 ms , Query= select * from `product` where state>0 and classid in (627,628,629) and price1>='2.99' and price1<='3.99' order by id desc limit 40,40 Duration: 0.245 ms , Query= select classid as v from product where id=43933 Duration: 0.2175 ms , Query= select classid as v from product where id=43932 Duration: 0.18875 ms , Query= select classid as v from product where id=43931 Duration: 0.17025 ms , Query= select classid as v from product where id=43930 Duration: 0.228 ms , Query= select classid as v from product where id=43926 Duration: 0.13825 ms , Query= select classid as v from product where id=43925 Duration: 0.1595 ms , Query= select classid as v from product where id=43924 Duration: 0.1475 ms , Query= select classid as v from product where id=43923 Duration: 0.13575 ms , Query= select classid as v from product where id=43922 Duration: 0.17125 ms , Query= select classid as v from product where id=43918 Duration: 0.17025 ms , Query= select classid as v from product where id=43917 Duration: 0.16375 ms , Query= select * from ptaglist where type>=0 Duration: 0.28375 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(627,628,629) group by tid Duration: 0.18925 ms , Query= select content,id from infoclass where id in (0)