Duration: 1.28925 ms , Query= select * from `product` where state>0 and classid in (569) and price1>='9.99' and price1<='19.99' order by id desc limit 0,40 Duration: 0.18975 ms , Query= select classid as v from product where id=20868 Duration: 0.205 ms , Query= select classid as v from product where id=20867 Duration: 0.17525 ms , Query= select classid as v from product where id=20864 Duration: 0.18225 ms , Query= select classid as v from product where id=20863 Duration: 0.23225 ms , Query= select classid as v from product where id=20860 Duration: 0.1695 ms , Query= select classid as v from product where id=20859 Duration: 0.19725 ms , Query= select classid as v from product where id=20858 Duration: 0.1765 ms , Query= select classid as v from product where id=20857 Duration: 0.18775 ms , Query= select classid as v from product where id=20027 Duration: 0.2525 ms , Query= select classid as v from product where id=20026 Duration: 0.164 ms , Query= select classid as v from product where id=20024 Duration: 0.224 ms , Query= select * from ptaglist where type>=0 Duration: 0.36925 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(569) group by tid Duration: 0.17025 ms , Query= select content,id from infoclass where id in (0)