Forum Shepherd Snowboard Boots Brown

Forum Shepherd Snowboard Boots Brown
Forum Shepherd Snowboard Boots Brown

$ 114.95


The Shepherd is J.P.'s signature boot and a team favorite. It returns this season with a few minor tweaks including our high-performance hybrid liner and a rubberized toe guard for extra protection against rail and snowmobile abuse. The Shepherd's overlasted midsole/outsole creates the ultimate all-mountain freestyle boot for riders who want enhanced terrain feel and board control.
Key Features of the Forum Shepherd Snowboard Boots: LINER: Concentrix Level 3 CUFF LINK: Gold SOLE: Overlasted LACING SYSTEM: Traditional

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-shepherd-snowboard-boots-brown' LIMIT 1110
2UPDATE `shop`.`products` AS `Product` SET `Product`.`views` = Product.views + 1 WHERE `Product`.`id` = (9)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` = 9 ORDER BY `Productmod`.`sku` ASC, `Productmod`.`name` ASC000