For 2016 Promotion, buy 7 Small Skull Bracelet with Lobster Clasp b003470 can have 5% OFF, so the unit price can be lower from previous price of US$4.40 to current promotion price US$4.18....
Duration: 45.4665 ms , Query= select count(*) as t from `product` where state>0 and classid<>542 and price1>='3.99' and price1<='4.99' Duration: 91.9605 ms , Query= select * from `product` where state>0 and classid<>542 and price1>='3.99' and price1<='4.99' order by id desc limit 2040,12 Duration: 0.29525 ms , Query= select classid as v from product where id=24813 Duration: 0.293 ms , Query= select classid as v from product where id=24809 Duration: 0.21425 ms , Query= select classid as v from product where id=24797 Duration: 0.20275 ms , Query= select classid as v from product where id=24785 Duration: 0.19425 ms , Query= select classid as v from product where id=24783 Duration: 0.1925 ms , Query= select classid as v from product where id=24782 Duration: 0.17825 ms , Query= select classid as v from product where id=24781 Duration: 0.20775 ms , Query= select classid as v from product where id=24773 Duration: 0.16175 ms , Query= select classid as v from product where id=24749 Duration: 0.14725 ms , Query= select classid as v from product where id=24663 Duration: 0.204 ms , Query= select classid as v from product where id=24662 Duration: 0.18575 ms , Query= select classid as v from product where id=24661 Duration: 0.18575 ms , Query= select content,id from infoclass where id in (0)