Pants

There are no products matching the selection.

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: 37224448, emalloc: 35947776
Code ProfilerTimeCntEmallocRealMem
Executed 2565 queries in 1.087352514267 seconds
Average query length: 0.00042391910887601 seconds
Queries per second: 2358.9406069743
Longest query length: 0.13697099685669
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')