Home  >  Maps  >  Agents  >  SOUTH AFRICA  > 
SOUTH AFRICA
Your registered contact is:
Castlet S.A. (Pty) Ltd
AGENT NAME Dennis Strydom
ADDRESS 10 Angus Crescent, Longmeadow East, Longmeadow Business Estate, Johannesburg 1609, South Africa
TELEPHONE +27 11 372 8900
FAX +27 11 608 3741
WEBSITE www.castletsa.com
[profiler]
Memory usage: real: 24903680, emalloc: 24421808
Code ProfilerTimeCntEmallocRealMem
Executed 448 queries in 0.665872812271 seconds
Average query length: 0.00148632324168 seconds
Queries per second: 672.801159236
Longest query length: 0.00877690315247
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` = '36') 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` = '36') AND (`at_is_active`.`store_id` = 1) 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` = '61') 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` = '61') AND (`at_include_in_menu`.`store_id` = 1) 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.product_id IS NULL AND core_url_rewrite.store_id='1' AND id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('53', '64', '153', '65', '66', '67', '68', '69', '70', '71', '72', '155', '52', '55', '57', '58', '138', '133', '134', '135', '136', '137', '60', '62', '59', '61', '56', '63', '143', '158', '160', '161', '162', '163', '164', '165', '166', '167', '168', '54', '73', '74', '75', '76', '77', '78', '79', '80', '142', '140', '81', '139', '141', '157', '154')) AND (`e`.`entity_id` NOT IN('154', '155', '158', '160', '161', '162', '163', '164', '165', '166', '167', '168')) 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')