Duration: 3.1225 ms , Query= select * from `product` where state>0 and classid in (568) and price1>='1.99' and price1<='2.99' order by id desc limit 24,12 Duration: 0.346 ms , Query= select classid as v from product where id=19742 Duration: 0.23425 ms , Query= select classid as v from product where id=19740 Duration: 0.19475 ms , Query= select classid as v from product where id=19736 Duration: 0.18875 ms , Query= select classid as v from product where id=19735 Duration: 0.2135 ms , Query= select classid as v from product where id=19733 Duration: 0.2045 ms , Query= select classid as v from product where id=18927 Duration: 0.182 ms , Query= select classid as v from product where id=18634 Duration: 0.20675 ms , Query= select classid as v from product where id=18630 Duration: 0.18 ms , Query= select classid as v from product where id=2862 Duration: 0.17425 ms , Query= select classid as v from product where id=2861 Duration: 0.184 ms , Query= select classid as v from product where id=2860 Duration: 0.2275 ms , Query= select * from ptaglist where type>=0 Duration: 0.40375 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(568) group by tid Duration: 0.143 ms , Query= select content,id from infoclass where id in (0)