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: 48.58425 ms , Query= select count(*) as t from `product` where state>0 and classid<>542 and price1>='3.99' and price1<='4.99' Duration: 90.73075 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.32075 ms , Query= select classid as v from product where id=24813 Duration: 0.228 ms , Query= select classid as v from product where id=24809 Duration: 0.17225 ms , Query= select classid as v from product where id=24797 Duration: 0.25525 ms , Query= select classid as v from product where id=24785 Duration: 0.15375 ms , Query= select classid as v from product where id=24783 Duration: 0.14875 ms , Query= select classid as v from product where id=24782 Duration: 0.16275 ms , Query= select classid as v from product where id=24781 Duration: 0.1465 ms , Query= select classid as v from product where id=24773 Duration: 0.151 ms , Query= select classid as v from product where id=24749 Duration: 0.164 ms , Query= select classid as v from product where id=24663 Duration: 0.15425 ms , Query= select classid as v from product where id=24662 Duration: 0.1445 ms , Query= select classid as v from product where id=24661 Duration: 0.17825 ms , Query= select content,id from infoclass where id in (0)