Duration: 0.9655 ms , Query= select count(*) as t from `product` where state>0 and classid in (584) and price1>='19.99' and price1<='29.99' Duration: 1.4795 ms , Query= select * from `product` where state>0 and classid in (584) and price1>='19.99' and price1<='29.99' order by id desc limit 0,12 Duration: 0.155 ms , Query= select classid as v from product where id=47303 Duration: 0.186 ms , Query= select classid as v from product where id=32010 Duration: 0.13575 ms , Query= select classid as v from product where id=26832 Duration: 0.1345 ms , Query= select classid as v from product where id=25860 Duration: 0.18325 ms , Query= select classid as v from product where id=25859 Duration: 0.17725 ms , Query= select classid as v from product where id=25858 Duration: 0.378 ms , Query= select classid as v from product where id=24868 Duration: 0.17025 ms , Query= select classid as v from product where id=20280 Duration: 0.131 ms , Query= select classid as v from product where id=20279 Duration: 0.1315 ms , Query= select classid as v from product where id=18450 Duration: 0.161 ms , Query= select * from ptaglist where type>=0 Duration: 0.294 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(584) group by tid Duration: 0.131 ms , Query= select content,id from infoclass where id in (0)