Burton TWC Factory Beanie Red

Burton TWC Factory Beanie Red
Burton TWC Factory Beanie Red

$ 12.56


Looking for a great looking beanie to keep your melon warm these winter months. When it comes to getting a beanie, you want to get one that offers a lot of warmth, because it's never fun when your ears are cold. It's also important to get a design you like, so you continue to wear your hat and protect your ears. If you like subtle looks, you will love this Burton TWC Factory Beanie. It's a real simple knitted beanie that offers a ton of warmth to those ears of yours.
Key Features of the Burton TWC Factory Beanie: 100% Acrylic Loose Knit Beanie Convertible Slouched to Skully Fit TWC Embroidery

Brand: Burton
Category: Main


(default) 3 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`brand_id`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`image`, `Product`.`price`, `Product`.`weight`, `Product`.`tags`, `Product`.`views`, `Product`.`active`, `Product`.`created`, `Product`.`modified`, `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`created`, `Category`.`modified`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Brand`.`active`, `Brand`.`created`, `Brand`.`modified` FROM `shop`.`products` AS `Product` LEFT JOIN `shop`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `shop`.`brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Brand`.`active` = 1 AND `Product`.`active` = 1 AND `Product`.`slug` = 'burton-twc-factory-beanie-red' LIMIT 1111
2UPDATE `shop`.`products` AS `Product` SET `Product`.`views` = Product.views + 1 WHERE `Product`.`id` = (6)111
3SELECT `Productmod`.`id`, `Productmod`.`product_id`, `Productmod`.`sku`, `Productmod`.`name`, `Productmod`.`value`, `Productmod`.`price`, `Productmod`.`weight`, `Productmod`.`active`, `Productmod`.`views`, `Productmod`.`created`, `Productmod`.`modified` FROM `shop`.`productmods` AS `Productmod` WHERE `Productmod`.`product_id` = 6 ORDER BY `Productmod`.`sku` ASC, `Productmod`.`name` ASC000