Duration: 1.441 ms , Query= select count(*) as t from `product` where state>0 and classid in (601) and price1>='0.99' and price1<='1.99' Duration: 2.846 ms , Query= select * from `product` where state>0 and classid in (601) and price1>='0.99' and price1<='1.99' order by id desc limit 108,12 Duration: 0.368 ms , Query= select classid as v from product where id=20484 Duration: 0.23325 ms , Query= select classid as v from product where id=19957 Duration: 0.1585 ms , Query= select classid as v from product where id=18536 Duration: 0.143 ms , Query= select classid as v from product where id=3976 Duration: 0.215 ms , Query= select classid as v from product where id=3957 Duration: 0.16275 ms , Query= select classid as v from product where id=3955 Duration: 0.14925 ms , Query= select classid as v from product where id=3943 Duration: 0.13575 ms , Query= select classid as v from product where id=3886 Duration: 0.13325 ms , Query= select classid as v from product where id=3882 Duration: 0.18475 ms , Query= select classid as v from product where id=3881 Duration: 0.1925 ms , Query= select * from ptaglist where type>=0 Duration: 0.35375 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(601) group by tid Duration: 0.1365 ms , Query= select content,id from infoclass where id in (0)