Spyder Men Comp GS Race Suit - Red Black

Product Code: 1573 600 W07
Spyder Men Comp GS Race Suit - Red Black

Be the first to review this product

Excl. Tax: €332.50 Incl. Tax: €399.00
Spyder

Spyder size information: Men | Women | Boys | Girls

Description

Details

Padded GS race suit from Spyder.
Additional Information

Additional Information

SKU 1573 600 W07
Manufacturer Spyder
Reviews
Tags

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.

teamskiwear.com is an wintersport racegear shop based in the Austrian Alps and offers the qualtiy skiwear from brands like Spyder, Phenix, Bogner, Kappa Goldwin and many more. [profiler]
Memory usage: real: 46137344, emalloc: 44974840
Code ProfilerTimeCntEmallocRealMem
Executed 2609 queries in 1.1080157756805 seconds
Average query length: 0.0004246898335303 seconds
Queries per second: 2354.6596152005
Longest query length: 0.12091302871704
Longest query:
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '32') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '32') AND (`at_is_active`.`store_id` = 9) INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '498') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '498') AND (`at_include_in_menu`.`store_id` = 9) LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='9' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('327', '330', '331', '332', '393', '333', '334', '335', '336', '328', '337', '338', '339', '394', '340', '342', '343', '329', '344', '345', '346', '395', '347', '348', '388', '349', '350', '280', '285', '288', '289', '290', '291', '351', '286', '292', '293', '294', '295', '287', '296', '297', '299', '298', '381', '177', '178', '179', '180', '182', '185', '183', '184', '186', '187', '383', '188', '262', '191', '193', '195', '181', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '231', '230', '270', '232', '213', '243', '244', '246', '245', '278', '321', '324', '247', '248', '249', '250', '279', '325', '251', '320', '253', '252', '323', '322', '281', '282', '300', '301', '302', '303', '283', '304', '305', '306', '307', '284', '308', '309', '310', '311', '212', '233', '234', '236', '235', '237', '380', '238', '397', '266', '239', '382', '240', '241', '267', '242', '214', '254', '255', '257', '256', '258', '259', '260', '261', '268', '352', '354', '357', '358', '359', '360', '361', '355', '362', '363', '364', '365', '366', '356', '367', '368', '369', '353', '370', '371', '372', '373', '374', '379', '375', '376', '377', '378', '384', '385', '386', '387', '271', '277', '272', '274', '396', '273', '275')) AND (`e`.`entity_id` NOT IN('292', '293', '295', '308', '309', '311', '362', '363', '365', '366', '367', '369')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')