Duration: 83.572 ms , Query= select count(*) as t from `product` where state>0 and classid<>542 and price1>='2.99' and price1<='3.99' Duration: 92.57875 ms , Query= select * from `product` where state>0 and classid<>542 and price1>='2.99' and price1<='3.99' order by id desc limit 1548,12 Duration: 0.3045 ms , Query= select classid as v from product where id=42113 Duration: 0.21525 ms , Query= select classid as v from product where id=42104 Duration: 0.1745 ms , Query= select classid as v from product where id=42035 Duration: 0.1675 ms , Query= select classid as v from product where id=42032 Duration: 0.1745 ms , Query= select classid as v from product where id=42031 Duration: 0.1855 ms , Query= select classid as v from product where id=42027 Duration: 0.166 ms , Query= select classid as v from product where id=42025 Duration: 0.16825 ms , Query= select classid as v from product where id=42024 Duration: 0.17325 ms , Query= select classid as v from product where id=42023 Duration: 0.17 ms , Query= select classid as v from product where id=42022 Duration: 0.16425 ms , Query= select classid as v from product where id=42021 Duration: 0.16125 ms , Query= select classid as v from product where id=42020 Duration: 0.18 ms , Query= select content,id from infoclass where id in (0)