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: 31.17525 ms , Query= select count(*) as t from `product` where state>0 and classid<>542 and price1>='3.99' and price1<='4.99' Duration: 74.196 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.2535 ms , Query= select classid as v from product where id=24813 Duration: 0.17975 ms , Query= select classid as v from product where id=24809 Duration: 0.13775 ms , Query= select classid as v from product where id=24797 Duration: 0.133 ms , Query= select classid as v from product where id=24785 Duration: 0.137 ms , Query= select classid as v from product where id=24783 Duration: 0.14425 ms , Query= select classid as v from product where id=24782 Duration: 0.12525 ms , Query= select classid as v from product where id=24781 Duration: 0.13775 ms , Query= select classid as v from product where id=24773 Duration: 0.1675 ms , Query= select classid as v from product where id=24749 Duration: 0.1325 ms , Query= select classid as v from product where id=24663 Duration: 0.135 ms , Query= select classid as v from product where id=24662 Duration: 0.1525 ms , Query= select classid as v from product where id=24661 Duration: 0.15675 ms , Query= select content,id from infoclass where id in (0)