Duration: 1.9265 ms , Query= select count(*) as t from `product` where state>0 and classid in (553) and price1>='6.99' and price1<='9.99' Duration: 3.866 ms , Query= select * from `product` where state>0 and classid in (553) and price1>='6.99' and price1<='9.99' order by id desc limit 0,12 Duration: 0.2245 ms , Query= select classid as v from product where id=54252 Duration: 0.17175 ms , Query= select classid as v from product where id=46083 Duration: 0.19625 ms , Query= select classid as v from product where id=36031 Duration: 0.161 ms , Query= select classid as v from product where id=36030 Duration: 0.152 ms , Query= select classid as v from product where id=36029 Duration: 0.166 ms , Query= select classid as v from product where id=36028 Duration: 0.15675 ms , Query= select classid as v from product where id=36027 Duration: 0.1605 ms , Query= select classid as v from product where id=35801 Duration: 0.154 ms , Query= select classid as v from product where id=35800 Duration: 0.155 ms , Query= select classid as v from product where id=33295 Duration: 0.3175 ms , Query= select * from ptaglist where type>=0 Duration: 0.458 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(553) group by tid Duration: 0.199 ms , Query= select content,id from infoclass where id in (0)