Burton TWC Smuggler Snowboard Pant Bright White

Burton TWC Smuggler Snowboard Pant Bright White
Burton TWC Smuggler Snowboard Pant Bright White

$ 77.95


That's one big ol' cargo pocket; perfect for pushing ham sandwiches across the border.To give you the most bang for your buck, Shaun hid a ton of tricks inside this waterproof wonder. The not-too-baggy, classic fit leaves room for extra layers, while inner thigh vents let you release excess heat. The mesh lining dries quickly so you're never cold and clammy, and when nature calls, snap up your cuffs with the Leg Lifts to avoid nasty restroom floors.
Key Features of the Burton TWC Smuggler Snowboard Pant: 5,000mm Waterproof 5,000g Breathability DRYRIDE Durashell 2-Layer Coated Fabric [5,000MM, 5,000G] TWC Sig Fit Mesh Lining Mesh-Lined Inner Thigh Vents Fully Taped Seams Cargo Pocket with Velcro Closure Includes White Collection Pant Features Package

Brand: Burton
Category: Main


(default) 3 queries took 1 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-smuggler-snowboard-pant-bright-white' LIMIT 1110
2UPDATE `shop`.`products` AS `Product` SET `Product`.`views` = Product.views + 1 WHERE `Product`.`id` = (1)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` = 1 ORDER BY `Productmod`.`sku` ASC, `Productmod`.`name` ASC000