For 2016 Promotion, buy 8 snake bracelet with OT buckle b002765 can have 5% OFF, so the unit price can be lower from previous price of US$6.00 to current promotion price US$5.70.
...
Duration: 152.3305 ms , Query= select count(*) as t from `product` where state>0 and classid<>542 and price1>='4.99' and price1<='6.99' Duration: 392.1195 ms , Query= select * from `product` where state>0 and classid<>542 and price1>='4.99' and price1<='6.99' order by id desc limit 1980,12 Duration: 0.30075 ms , Query= select classid as v from product where id=22464 Duration: 0.21225 ms , Query= select classid as v from product where id=22461 Duration: 0.15225 ms , Query= select classid as v from product where id=22377 Duration: 0.1325 ms , Query= select classid as v from product where id=22376 Duration: 0.1285 ms , Query= select classid as v from product where id=22361 Duration: 0.13225 ms , Query= select classid as v from product where id=22357 Duration: 0.33975 ms , Query= select classid as v from product where id=22355 Duration: 0.2255 ms , Query= select classid as v from product where id=22352 Duration: 0.1375 ms , Query= select classid as v from product where id=22349 Duration: 0.1305 ms , Query= select classid as v from product where id=22346 Duration: 0.16125 ms , Query= select classid as v from product where id=22342 Duration: 0.17075 ms , Query= select classid as v from product where id=22341 Duration: 0.203 ms , Query= select content,id from infoclass where id in (0)