Forum Aura Snowboard Boots Chocolate

Forum Aura Snowboard Boots Chocolate
Forum Aura Snowboard Boots Chocolate

$ 68.95

Product Options:

Had a little work done and now she's better than ever. The Aura is a perennial favorite that offers style and performance at a great price. For 2008, it received the most significant makeover of all our carryover boots. Its refined court shoe-inspired outer with metal lace hooks is packed with our new 4D-molded tongue, innovative hybrid liner with 3/4 footbed and ankle supports, stabilizing internal cuff, and our rugged high-traction cupsole with self-cleaning tread.
Key Features of The Forum Aura Women's Snowboard Boots: Concentrix Level 1 Liner - Basic yet supportive, this no frills option features a molded EVA footbed, new anatomical PE supports, and adjustable calf straps for enhanced fit Silver Cuff Link - This option has a new custom lace look and provides much of the same comfort and hold as Forum's Gold Cuff line, except it comes in a stream lined configuration with an internal cage Cup Sole Traditional Lacing System Flex - 4

Brand: Forum
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` = 'forum-aura-snowboard-boots-chocolate' LIMIT 1110
2UPDATE `shop`.`products` AS `Product` SET `Product`.`views` = Product.views + 1 WHERE `Product`.`id` = (19)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` = 19 ORDER BY `Productmod`.`sku` ASC, `Productmod`.`name` ASC330