MySQL статистика (211)
Query Rows Time Cached
SET SESSION sql_mode = '' - 0.000104 false
SHOW TABLES LIKE 'extrafields' 1 0.002086 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = seo_settings.id and (object_class='Admin_SeoParams')) as extrafields_calculated, seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1 1 0.000874 false
SHOW TABLES LIKE 'extrafields' 1 0.002089 false
update seo_settings set individual_seo_settings = 'a:0:{}' - 0.000304 false
SHOW TABLES LIKE 'extrafields' 1 0.002085 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000372 false
SHOW TABLES LIKE 'extrafields' 1 0.001399 false
SELECT items.id, items.parent_id, items.title, items.is_hidden_in_menu, items.sort_order, items.href, menus.code as menu_code, menus.use_code_in_links as menu_code_in_links, blocks.id as block_id, blocks.code as block_code, blocks.description, blocks.content, blocks.template, blocks.block_type, f.id as image_id, f.disk_name as image_path FROM admin_menu_items as items LEFT JOIN admin_menus as menus ON menus.id = items.menu_id LEFT JOIN admin_text_blocks as blocks ON blocks.id = items.text_block_id LEFT JOIN db_files as f ON f.master_object_id = items.id AND f.master_object_class = 'Admin_MenuItem' AND f.field = 'image' WHERE items.is_hidden is null ORDER BY items.parent_id, items.sort_order 7 0.000768 false
SHOW TABLES LIKE 'extrafields' 1 0.001578 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '8') LIMIT 0, 1 1 0.000818 false
SHOW TABLES LIKE 'extrafields' 1 0.001160 false
SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC 49 0.000416 false
SELECT count(*) FROM catalog_products as products WHERE EXISTS (SELECT 1 FROM catalog_skus WHERE catalog_skus.product_id = products.id) AND products.category_id = '8' AND products.hidden is null AND products.deleted is null AND products.category_id in ('6', '2107', '2106', '2105', '2104', '2103', '2102', '2101', '2098', '2097', '2076', '2075', '2074', '5', '7', '19', '8', '9', '10', '11', '12', '2100', '2099', '13', '14', '18', '17', '16', '15', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2085', '2090', '2089', '2088', '2087', '2086', '2084', '2096', '2095', '2094', '2093', '2092', '2091') 1 0.000758 false
SELECT products.* FROM catalog_products as products WHERE EXISTS (SELECT 1 FROM catalog_skus WHERE catalog_skus.product_id = products.id) AND products.category_id = '8' AND products.hidden is null AND products.deleted is null AND products.category_id in ('6', '2107', '2106', '2105', '2104', '2103', '2102', '2101', '2098', '2097', '2076', '2075', '2074', '5', '7', '19', '8', '9', '10', '11', '12', '2100', '2099', '13', '14', '18', '17', '16', '15', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2085', '2090', '2089', '2088', '2087', '2086', '2084', '2096', '2095', '2094', '2093', '2092', '2091') LIMIT 0, 10 10 0.000925 false
SELECT * FROM catalog_skus WHERE product_id in ('21819', '21837', '21842', '21843', '21859', '21860', '21862', '21866', '21869', '21871') 18 0.000458 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('21819', '21837', '21842', '21843', '21859', '21860', '21862', '21866', '21869', '21871') ORDER BY files.sort_order ASC, files.sort_order ASC 31 0.000642 false
SELECT * FROM catalog_attributes as ca LEFT JOIN catalog_attribute_values as cav ON ca.id = cav.attribute_id WHERE cav.product_id in ('21819', '21837', '21842', '21843', '21859', '21860', '21862', '21866', '21869', '21871') 0 0.000372 false
SHOW TABLES LIKE 'extrafields' 1 0.001413 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000330 false
SELECT * FROM extrafields WHERE object_class = 'Catalog_Product' AND object_id in ('21819', '21837', '21842', '21843', '21859', '21860', '21862', '21866', '21869', '21871') 0 0.000297 false
SHOW TABLES LIKE 'extrafields' 1 0.001334 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000315 false
SHOW TABLES LIKE 'extrafields' 1 0.001303 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '8' AND products.hidden is null AND products.deleted is null AND products.category_id in ('6', '2107', '2106', '2105', '2104', '2103', '2102', '2101', '2098', '2097', '2076', '2075', '2074', '5', '7', '19', '8', '9', '10', '11', '12', '2100', '2099', '13', '14', '18', '17', '16', '15', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2085', '2090', '2089', '2088', '2087', '2086', '2084', '2096', '2095', '2094', '2093', '2092', '2091') 1 0.000537 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '8' AND products.hidden is null AND products.deleted is null AND products.category_id in ('6', '2107', '2106', '2105', '2104', '2103', '2102', '2101', '2098', '2097', '2076', '2075', '2074', '5', '7', '19', '8', '9', '10', '11', '12', '2100', '2099', '13', '14', '18', '17', '16', '15', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2085', '2090', '2089', '2088', '2087', '2086', '2084', '2096', '2095', '2094', '2093', '2092', '2091') LIMIT 0, 42 42 0.000900 false
SELECT * FROM catalog_skus WHERE product_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 18 0.000679 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 90 0.000824 false
SELECT * FROM catalog_attributes as ca LEFT JOIN catalog_attribute_values as cav ON ca.id = cav.attribute_id WHERE cav.product_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 0 0.000414 false
SHOW TABLES LIKE 'extrafields' 1 0.001164 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000246 false
SELECT * FROM extrafields WHERE object_class = 'Catalog_Product' AND object_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 0 0.000321 false
SHOW TABLES LIKE 'extrafields' 1 0.001102 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000247 false
SHOW TABLES LIKE 'extrafields' 1 0.001133 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '8' AND products.hidden is null AND products.deleted is null AND products.category_id in ('6', '2107', '2106', '2105', '2104', '2103', '2102', '2101', '2098', '2097', '2076', '2075', '2074', '5', '7', '19', '8', '9', '10', '11', '12', '2100', '2099', '13', '14', '18', '17', '16', '15', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2085', '2090', '2089', '2088', '2087', '2086', '2084', '2096', '2095', '2094', '2093', '2092', '2091') 1 0.000464 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '8' AND products.hidden is null AND products.deleted is null AND products.category_id in ('6', '2107', '2106', '2105', '2104', '2103', '2102', '2101', '2098', '2097', '2076', '2075', '2074', '5', '7', '19', '8', '9', '10', '11', '12', '2100', '2099', '13', '14', '18', '17', '16', '15', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2085', '2090', '2089', '2088', '2087', '2086', '2084', '2096', '2095', '2094', '2093', '2092', '2091') LIMIT 0, 42 42 0.000774 false
SELECT * FROM catalog_skus WHERE product_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 18 0.000505 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 90 0.000871 false
SELECT * FROM catalog_attributes as ca LEFT JOIN catalog_attribute_values as cav ON ca.id = cav.attribute_id WHERE cav.product_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 0 0.000374 false
SHOW TABLES LIKE 'extrafields' 1 0.001172 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000293 false
SELECT * FROM extrafields WHERE object_class = 'Catalog_Product' AND object_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 0 0.000254 false
SHOW TABLES LIKE 'extrafields' 1 0.001280 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000264 false
SHOW TABLES LIKE 'extrafields' 1 0.001032 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '8' AND products.hidden is null AND products.deleted is null AND products.category_id in ('6', '2107', '2106', '2105', '2104', '2103', '2102', '2101', '2098', '2097', '2076', '2075', '2074', '5', '7', '19', '8', '9', '10', '11', '12', '2100', '2099', '13', '14', '18', '17', '16', '15', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2085', '2090', '2089', '2088', '2087', '2086', '2084', '2096', '2095', '2094', '2093', '2092', '2091') 1 0.000524 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '8' AND products.hidden is null AND products.deleted is null AND products.category_id in ('6', '2107', '2106', '2105', '2104', '2103', '2102', '2101', '2098', '2097', '2076', '2075', '2074', '5', '7', '19', '8', '9', '10', '11', '12', '2100', '2099', '13', '14', '18', '17', '16', '15', '2077', '2078', '2079', '2080', '2081', '2082', '2083', '2085', '2090', '2089', '2088', '2087', '2086', '2084', '2096', '2095', '2094', '2093', '2092', '2091') LIMIT 0, 42 42 0.000867 false
SELECT * FROM catalog_skus WHERE product_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 18 0.000511 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 90 0.000754 false
SELECT * FROM catalog_attributes as ca LEFT JOIN catalog_attribute_values as cav ON ca.id = cav.attribute_id WHERE cav.product_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 0 0.000368 false
SHOW TABLES LIKE 'extrafields' 1 0.001127 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000248 false
SELECT * FROM extrafields WHERE object_class = 'Catalog_Product' AND object_id in ('21815', '21817', '21819', '21822', '21823', '21824', '21825', '21826', '21827', '21828', '21829', '21830', '21831', '21832', '21833', '21834', '21835', '21836', '21837', '21838', '21839', '21840', '21841', '21842', '21843', '21844', '21856', '21857', '21858', '21859', '21860', '21861', '21862', '21863', '21864', '21865', '21866', '21867', '21868', '21869', '21870', '21871') 0 0.000244 false
SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order asc 49 0.000389 false
SHOW TABLES LIKE 'extrafields' 1 0.001157 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '61935') LIMIT 0, 1 1 0.000416 false
SHOW TABLES LIKE 'extrafields' 1 0.001076 false
SHOW TABLES LIKE 'extrafields' 1 0.001836 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '61956') LIMIT 0, 1 1 0.000601 false
SHOW TABLES LIKE 'extrafields' 1 0.001564 false
SHOW TABLES LIKE 'extrafields' 1 0.001731 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '61961') LIMIT 0, 1 1 0.000548 false
SHOW TABLES LIKE 'extrafields' 1 0.001688 false
SHOW TABLES LIKE 'extrafields' 1 0.001992 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '61962') LIMIT 0, 1 1 0.000628 false
SHOW TABLES LIKE 'extrafields' 1 0.001682 false
SHOW TABLES LIKE 'extrafields' 1 0.001685 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '61985') LIMIT 0, 1 1 0.000652 false
SHOW TABLES LIKE 'extrafields' 1 0.001792 false
SHOW TABLES LIKE 'extrafields' 1 0.001760 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '61989') LIMIT 0, 1 1 0.000598 false
SHOW TABLES LIKE 'extrafields' 1 0.001809 false
SHOW TABLES LIKE 'extrafields' 1 0.001849 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '61997') LIMIT 0, 1 1 0.000582 false
SHOW TABLES LIKE 'extrafields' 1 0.001627 false
SHOW TABLES LIKE 'extrafields' 1 0.001738 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '62010') LIMIT 0, 1 1 0.000539 false
SHOW TABLES LIKE 'extrafields' 1 0.001856 false
SHOW TABLES LIKE 'extrafields' 1 0.001671 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '62022') LIMIT 0, 1 1 0.000553 false
SHOW TABLES LIKE 'extrafields' 1 0.001598 false
SHOW TABLES LIKE 'extrafields' 1 0.001884 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.* FROM db_files WHERE (db_files.id = '62030') LIMIT 0, 1 1 0.000642 false
SHOW TABLES LIKE 'extrafields' 1 0.001591 false
SHOW TABLES LIKE 'extrafields' 1 0.001627 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_module_settings.id and (object_class='Admin_ModuleSettings')) as extrafields_calculated, admin_module_settings.* FROM admin_module_settings WHERE (admin_module_settings.module_id='admin') AND (admin_module_settings.form_id='default') LIMIT 0, 1 1 0.000542 false
SHOW TABLES LIKE 'extrafields' 1 0.001433 false
SHOW TABLES LIKE 'extrafields' 1 0.002070 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = shop_carts.id and (object_class='Shop_Cart')) as extrafields_calculated, shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '0549625aed967e18a6d8a656f13c015e1bd9aa7e040ee1b9efab1b981c8444601033698da04b0fa2f075264826de3048478896c7131eb43377c3030422da2731') LIMIT 0, 1 0 0.000338 false
SHOW TABLES LIKE 'extrafields' 1 0.001403 false
SHOW TABLES LIKE 'extrafields' 1 0.001403 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '5') LIMIT 0, 1 1 0.000836 false
SHOW TABLES LIKE 'extrafields' 1 0.002099 false
SHOW TABLES LIKE 'extrafields' 1 0.001480 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '5') AND (catalog_categories.deleted <> 1 or deleted is null) 5 0.001394 false
SHOW TABLES LIKE 'extrafields' 1 0.001503 false
SHOW TABLES LIKE 'extrafields' 1 0.001085 false
SHOW TABLES LIKE 'extrafields' 1 0.001084 false
SHOW TABLES LIKE 'extrafields' 1 0.001121 false
SHOW TABLES LIKE 'extrafields' 1 0.001702 false
SHOW TABLES LIKE 'extrafields' 1 0.001240 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '6') LIMIT 0, 1 1 0.000667 false
SHOW TABLES LIKE 'extrafields' 1 0.001075 false
SHOW TABLES LIKE 'extrafields' 1 0.001152 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '6') AND (catalog_categories.deleted <> 1 or deleted is null) 4 0.000867 false
SHOW TABLES LIKE 'extrafields' 1 0.001034 false
SHOW TABLES LIKE 'extrafields' 1 0.001575 false
SHOW TABLES LIKE 'extrafields' 1 0.001578 false
SHOW TABLES LIKE 'extrafields' 1 0.001613 false
SHOW TABLES LIKE 'extrafields' 1 0.001465 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '7') LIMIT 0, 1 1 0.000919 false
SHOW TABLES LIKE 'extrafields' 1 0.001618 false
SHOW TABLES LIKE 'extrafields' 1 0.001426 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '7') AND (catalog_categories.deleted <> 1 or deleted is null) 3 0.001231 false
SHOW TABLES LIKE 'extrafields' 1 0.001629 false
SHOW TABLES LIKE 'extrafields' 1 0.001556 false
SHOW TABLES LIKE 'extrafields' 1 0.001470 false
SHOW TABLES LIKE 'extrafields' 1 0.001862 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2074') LIMIT 0, 1 1 0.001047 false
SHOW TABLES LIKE 'extrafields' 1 0.001883 false
SHOW TABLES LIKE 'extrafields' 1 0.002198 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2074') AND (catalog_categories.deleted <> 1 or deleted is null) 5 0.002085 false
SHOW TABLES LIKE 'extrafields' 1 0.001731 false
SHOW TABLES LIKE 'extrafields' 1 0.001396 false
SHOW TABLES LIKE 'extrafields' 1 0.001396 false
SHOW TABLES LIKE 'extrafields' 1 0.001384 false
SHOW TABLES LIKE 'extrafields' 1 0.001553 false
SHOW TABLES LIKE 'extrafields' 1 0.001522 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2075') LIMIT 0, 1 1 0.001217 false
SHOW TABLES LIKE 'extrafields' 1 0.002343 false
SHOW TABLES LIKE 'extrafields' 1 0.001689 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2075') AND (catalog_categories.deleted <> 1 or deleted is null) 1 0.001192 false
SHOW TABLES LIKE 'extrafields' 1 0.001657 false
SHOW TABLES LIKE 'extrafields' 1 0.001664 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2076') LIMIT 0, 1 1 0.001040 false
SHOW TABLES LIKE 'extrafields' 1 0.001380 false
SHOW TABLES LIKE 'extrafields' 1 0.001366 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2076') AND (catalog_categories.deleted <> 1 or deleted is null) 1 0.000867 false
SHOW TABLES LIKE 'extrafields' 1 0.001202 false
SHOW TABLES LIKE 'extrafields' 1 0.002029 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2097') LIMIT 0, 1 1 0.000983 false
SHOW TABLES LIKE 'extrafields' 1 0.001875 false
SHOW TABLES LIKE 'extrafields' 1 0.002168 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2097') AND (catalog_categories.deleted <> 1 or deleted is null) 2 0.001597 false
SHOW TABLES LIKE 'extrafields' 1 0.001989 false
SHOW TABLES LIKE 'extrafields' 1 0.001783 false
SHOW TABLES LIKE 'extrafields' 1 0.001703 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2098') LIMIT 0, 1 1 0.000890 false
SHOW TABLES LIKE 'extrafields' 1 0.002392 false
SHOW TABLES LIKE 'extrafields' 1 0.002152 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2098') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.001086 false
SHOW TABLES LIKE 'extrafields' 1 0.001856 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2101') LIMIT 0, 1 1 0.001063 false
SHOW TABLES LIKE 'extrafields' 1 0.001781 false
SHOW TABLES LIKE 'extrafields' 1 0.002427 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2101') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.001258 false
SHOW TABLES LIKE 'extrafields' 1 0.001822 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2102') LIMIT 0, 1 1 0.001139 false
SHOW TABLES LIKE 'extrafields' 1 0.001840 false
SHOW TABLES LIKE 'extrafields' 1 0.002038 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2102') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.001073 false
SHOW TABLES LIKE 'extrafields' 1 0.001999 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2103') LIMIT 0, 1 1 0.000879 false
SHOW TABLES LIKE 'extrafields' 1 0.001687 false
SHOW TABLES LIKE 'extrafields' 1 0.001731 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2103') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.000906 false
SHOW TABLES LIKE 'extrafields' 1 0.001563 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2104') LIMIT 0, 1 1 0.001159 false
SHOW TABLES LIKE 'extrafields' 1 0.001976 false
SHOW TABLES LIKE 'extrafields' 1 0.002313 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2104') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.001137 false
SHOW TABLES LIKE 'extrafields' 1 0.001980 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2105') LIMIT 0, 1 1 0.000992 false
SHOW TABLES LIKE 'extrafields' 1 0.001541 false
SHOW TABLES LIKE 'extrafields' 1 0.002639 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2105') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.001199 false
SHOW TABLES LIKE 'extrafields' 1 0.001767 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2106') LIMIT 0, 1 1 0.001214 false
SHOW TABLES LIKE 'extrafields' 1 0.001436 false
SHOW TABLES LIKE 'extrafields' 1 0.001519 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2106') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.000771 false
SHOW TABLES LIKE 'extrafields' 1 0.001466 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '2107') LIMIT 0, 1 1 0.001063 false
SHOW TABLES LIKE 'extrafields' 1 0.001683 false
SHOW TABLES LIKE 'extrafields' 1 0.001533 false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where catalog_attributes.id=catalog_category_filters.attribute_id and catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = catalog_categories.id and (object_class='Catalog_Category')) as extrafields_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.parent_id = '2107') AND (catalog_categories.deleted <> 1 or deleted is null) 0 0.000676 false
SHOW TABLES LIKE 'extrafields' 1 0.001962 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'second_menu') LIMIT 0, 1 1 0.000788 false
SHOW TABLES LIKE 'extrafields' 1 0.001881 false
SHOW TABLES LIKE 'extrafields' 1 0.001351 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '4') AND (admin_menu_items.parent_id is null and (admin_menu_items.is_hidden is null or admin_menu_items.is_hidden=0) and (admin_menu_items.is_hidden_in_menu is null or admin_menu_items.is_hidden_in_menu=0)) ORDER BY group_name, sort_order 5 0.000686 false
SHOW TABLES LIKE 'extrafields' 1 0.001178 false
SHOW TABLES LIKE 'extrafields' 1 0.001072 false
SHOW TABLES LIKE 'extrafields' 1 0.001226 false
SHOW TABLES LIKE 'extrafields' 1 0.001410 false
SHOW TABLES LIKE 'extrafields' 1 0.001564 false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order 7 0.000406 false
SHOW TABLES LIKE 'extrafields' 1 0.001750 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.id = '4') LIMIT 0, 1 1 0.000588 false
SHOW TABLES LIKE 'extrafields' 1 0.001982 false
SHOW TABLES LIKE 'extrafields' 1 0.001947 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'second_menu') LIMIT 0, 1 1 0.000742 false
SHOW TABLES LIKE 'extrafields' 1 0.001642 false
SHOW TABLES LIKE 'extrafields' 1 0.001660 false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '4') AND (admin_menu_items.parent_id is null and (admin_menu_items.is_hidden is null or admin_menu_items.is_hidden=0) and (admin_menu_items.is_hidden_in_menu is null or admin_menu_items.is_hidden_in_menu=0)) ORDER BY group_name, sort_order 5 0.000959 false
SHOW TABLES LIKE 'extrafields' 1 0.001642 false
SHOW TABLES LIKE 'extrafields' 1 0.001910 false
SHOW TABLES LIKE 'extrafields' 1 0.001619 false
SHOW TABLES LIKE 'extrafields' 1 0.001449 false
SHOW TABLES LIKE 'extrafields' 1 0.001465 false