Italy

Ski Wear

Shop Now

Spyder

Race Wear

Shop Now!

Austrian

Team Wear

Shop Now!

Helly Hansen

Team Wear

Shop Now!

New Products

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: 40370176, emalloc: 39300312
Code ProfilerTimeCntEmallocRealMem
Executed 2657 queries in 1.0187857151031 seconds
Average query length: 0.00038343459356536 seconds
Queries per second: 2608.0067286092
Longest query length: 0.158775806427
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')