Step 2: Select a product in "2000 LB Axle Kit - 4-5 lug hubs"

Full Kit - Universal Commercial 2000 LB

Full Kit Components
  • Universal adaptor ring, hard-coat anodized
  • Bushing, stainless steel
  • Super SealTM
  • Air pressure gauge unit cap, hard-coat anodized
  • Fill valve, bronze with nickel plating
  • Bonding agent
Seal Specifications
  • ID 1 1/2
  • Double-lip
  • Specially molded composition
Gauge pressure recommendations
  • 5-10 p.s.i.
Continue: Select Qty Of Kits >>




(default) 4 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`is_active`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`title`, `ParentCategory`.`is_active`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`created`, `ParentCategory`.`modified` FROM `airtighthubs`.`categories` AS `Category` LEFT JOIN `airtighthubs`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`id` = 4 LIMIT 1110
2SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`title`, `ChildCategory`.`is_active`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`created`, `ChildCategory`.`modified` FROM `airtighthubs`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (4)000
3SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`sku`, `Product`.`title`, `Product`.`short_description`, `Product`.`description`, `Product`.`cost`, `Product`.`weight`, `Product`.`lft`, `Product`.`rght`, `Product`.`is_active`, `Product`.`created`, `Product`.`modified` FROM `airtighthubs`.`products` AS `Product` WHERE `Product`.`category_id` = (4)110
4SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`sku`, `Product`.`title`, `Product`.`short_description`, `Product`.`description`, `Product`.`cost`, `Product`.`weight`, `Product`.`lft`, `Product`.`rght`, `Product`.`is_active`, `Product`.`created`, `Product`.`modified`, `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`is_active`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified` FROM `airtighthubs`.`products` AS `Product` LEFT JOIN `airtighthubs`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) WHERE `Product`.`category_id` = 4 AND `Product`.`is_active` = '1'112