MySQL статистика (175)
Query Rows Time Cached
SET SESSION sql_mode = '' - 0.000104 false
SHOW TABLES LIKE 'extrafields' 1 0.002548 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.000859 false
SHOW TABLES LIKE 'extrafields' 1 0.002082 false
update seo_settings set individual_seo_settings = 'a:0:{}' - 0.000432 false
SHOW TABLES LIKE 'extrafields' 1 0.001637 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 = '14ed088189a877ed53cab76c10cb3a81242af3c5cfb716f01a3ca3211ac2f12340e9814cd1e03381dabe92d7cba94db0ac567a57684895aaace7cafa3d300f2e') LIMIT 0, 1 0 0.000439 false
SHOW TABLES LIKE 'extrafields' 1 0.001498 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.000677 false
SHOW TABLES LIKE 'extrafields' 1 0.001538 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 = '10') LIMIT 0, 1 1 0.000775 false
SHOW TABLES LIKE 'extrafields' 1 0.001349 false
SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC 49 0.000386 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 = '10' 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.000570 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 = '10' 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, 0 0 0.000361 false
SHOW TABLES LIKE 'extrafields' 1 0.001338 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 = '14ed088189a877ed53cab76c10cb3a81242af3c5cfb716f01a3ca3211ac2f12340e9814cd1e03381dabe92d7cba94db0ac567a57684895aaace7cafa3d300f2e') LIMIT 0, 1 0 0.000349 false
SHOW TABLES LIKE 'extrafields' 1 0.001293 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '10' 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.000453 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '10' 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, 3 3 0.000522 false
SELECT * FROM catalog_skus WHERE product_id in ('21812', '21813', '21814') 0 0.000270 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('21812', '21813', '21814') 3 0.000797 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 ('21812', '21813', '21814') 0 0.000451 false
SHOW TABLES LIKE 'extrafields' 1 0.001842 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 = '14ed088189a877ed53cab76c10cb3a81242af3c5cfb716f01a3ca3211ac2f12340e9814cd1e03381dabe92d7cba94db0ac567a57684895aaace7cafa3d300f2e') LIMIT 0, 1 0 0.000657 false
SELECT * FROM extrafields WHERE object_class = 'Catalog_Product' AND object_id in ('21812', '21813', '21814') 0 0.000501 false
SHOW TABLES LIKE 'extrafields' 1 0.001722 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 = '14ed088189a877ed53cab76c10cb3a81242af3c5cfb716f01a3ca3211ac2f12340e9814cd1e03381dabe92d7cba94db0ac567a57684895aaace7cafa3d300f2e') LIMIT 0, 1 0 0.000368 false
SHOW TABLES LIKE 'extrafields' 1 0.001800 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '10' 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.000650 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '10' 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, 3 3 0.000632 false
SELECT * FROM catalog_skus WHERE product_id in ('21812', '21813', '21814') 0 0.000311 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('21812', '21813', '21814') 3 0.000450 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 ('21812', '21813', '21814') 0 0.000368 false
SHOW TABLES LIKE 'extrafields' 1 0.002166 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 = '14ed088189a877ed53cab76c10cb3a81242af3c5cfb716f01a3ca3211ac2f12340e9814cd1e03381dabe92d7cba94db0ac567a57684895aaace7cafa3d300f2e') LIMIT 0, 1 0 0.000426 false
SELECT * FROM extrafields WHERE object_class = 'Catalog_Product' AND object_id in ('21812', '21813', '21814') 0 0.000438 false
SHOW TABLES LIKE 'extrafields' 1 0.002182 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 = '14ed088189a877ed53cab76c10cb3a81242af3c5cfb716f01a3ca3211ac2f12340e9814cd1e03381dabe92d7cba94db0ac567a57684895aaace7cafa3d300f2e') LIMIT 0, 1 0 0.000426 false
SHOW TABLES LIKE 'extrafields' 1 0.001463 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '10' 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.000704 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '10' 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, 3 3 0.000487 false
SELECT * FROM catalog_skus WHERE product_id in ('21812', '21813', '21814') 0 0.000453 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('21812', '21813', '21814') 3 0.000577 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 ('21812', '21813', '21814') 0 0.000491 false
SHOW TABLES LIKE 'extrafields' 1 0.002243 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 = '14ed088189a877ed53cab76c10cb3a81242af3c5cfb716f01a3ca3211ac2f12340e9814cd1e03381dabe92d7cba94db0ac567a57684895aaace7cafa3d300f2e') LIMIT 0, 1 0 0.000309 false
SELECT * FROM extrafields WHERE object_class = 'Catalog_Product' AND object_id in ('21812', '21813', '21814') 0 0.000348 false
SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order asc 49 0.000519 false
SHOW TABLES LIKE 'extrafields' 1 0.001664 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.001779 false
SHOW TABLES LIKE 'extrafields' 1 0.001433 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 = '14ed088189a877ed53cab76c10cb3a81242af3c5cfb716f01a3ca3211ac2f12340e9814cd1e03381dabe92d7cba94db0ac567a57684895aaace7cafa3d300f2e') LIMIT 0, 1 0 0.000443 false
SHOW TABLES LIKE 'extrafields' 1 0.001495 false
SHOW TABLES LIKE 'extrafields' 1 0.001102 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.000774 false
SHOW TABLES LIKE 'extrafields' 1 0.001190 false
SHOW TABLES LIKE 'extrafields' 1 0.001096 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.001214 false
SHOW TABLES LIKE 'extrafields' 1 0.001150 false
SHOW TABLES LIKE 'extrafields' 1 0.001147 false
SHOW TABLES LIKE 'extrafields' 1 0.001363 false
SHOW TABLES LIKE 'extrafields' 1 0.001717 false
SHOW TABLES LIKE 'extrafields' 1 0.001725 false
SHOW TABLES LIKE 'extrafields' 1 0.001428 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.000883 false
SHOW TABLES LIKE 'extrafields' 1 0.001414 false
SHOW TABLES LIKE 'extrafields' 1 0.001427 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.001171 false
SHOW TABLES LIKE 'extrafields' 1 0.001364 false
SHOW TABLES LIKE 'extrafields' 1 0.001399 false
SHOW TABLES LIKE 'extrafields' 1 0.001126 false
SHOW TABLES LIKE 'extrafields' 1 0.001208 false
SHOW TABLES LIKE 'extrafields' 1 0.001128 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.000843 false
SHOW TABLES LIKE 'extrafields' 1 0.001875 false
SHOW TABLES LIKE 'extrafields' 1 0.001555 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.001069 false
SHOW TABLES LIKE 'extrafields' 1 0.001309 false
SHOW TABLES LIKE 'extrafields' 1 0.001422 false
SHOW TABLES LIKE 'extrafields' 1 0.001379 false
SHOW TABLES LIKE 'extrafields' 1 0.001541 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.000809 false
SHOW TABLES LIKE 'extrafields' 1 0.001761 false
SHOW TABLES LIKE 'extrafields' 1 0.001375 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.001094 false
SHOW TABLES LIKE 'extrafields' 1 0.001493 false
SHOW TABLES LIKE 'extrafields' 1 0.001811 false
SHOW TABLES LIKE 'extrafields' 1 0.001702 false
SHOW TABLES LIKE 'extrafields' 1 0.001614 false
SHOW TABLES LIKE 'extrafields' 1 0.001815 false
SHOW TABLES LIKE 'extrafields' 1 0.001168 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.001046 false
SHOW TABLES LIKE 'extrafields' 1 0.001756 false
SHOW TABLES LIKE 'extrafields' 1 0.001516 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.001027 false
SHOW TABLES LIKE 'extrafields' 1 0.001280 false
SHOW TABLES LIKE 'extrafields' 1 0.001109 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.000701 false
SHOW TABLES LIKE 'extrafields' 1 0.001204 false
SHOW TABLES LIKE 'extrafields' 1 0.001122 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.000690 false
SHOW TABLES LIKE 'extrafields' 1 0.001115 false
SHOW TABLES LIKE 'extrafields' 1 0.001124 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.000762 false
SHOW TABLES LIKE 'extrafields' 1 0.001159 false
SHOW TABLES LIKE 'extrafields' 1 0.001102 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.000866 false
SHOW TABLES LIKE 'extrafields' 1 0.001729 false
SHOW TABLES LIKE 'extrafields' 1 0.001743 false
SHOW TABLES LIKE 'extrafields' 1 0.001809 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.000792 false
SHOW TABLES LIKE 'extrafields' 1 0.001103 false
SHOW TABLES LIKE 'extrafields' 1 0.001221 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.000670 false
SHOW TABLES LIKE 'extrafields' 1 0.001057 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.000731 false
SHOW TABLES LIKE 'extrafields' 1 0.001329 false
SHOW TABLES LIKE 'extrafields' 1 0.001163 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.000688 false
SHOW TABLES LIKE 'extrafields' 1 0.001139 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.000719 false
SHOW TABLES LIKE 'extrafields' 1 0.001256 false
SHOW TABLES LIKE 'extrafields' 1 0.001722 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.000886 false
SHOW TABLES LIKE 'extrafields' 1 0.001698 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.000897 false
SHOW TABLES LIKE 'extrafields' 1 0.001754 false
SHOW TABLES LIKE 'extrafields' 1 0.001710 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.000940 false
SHOW TABLES LIKE 'extrafields' 1 0.001730 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.000951 false
SHOW TABLES LIKE 'extrafields' 1 0.001684 false
SHOW TABLES LIKE 'extrafields' 1 0.001733 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.000825 false
SHOW TABLES LIKE 'extrafields' 1 0.001510 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.000827 false
SHOW TABLES LIKE 'extrafields' 1 0.001112 false
SHOW TABLES LIKE 'extrafields' 1 0.000981 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.000523 false
SHOW TABLES LIKE 'extrafields' 1 0.001005 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.000580 false
SHOW TABLES LIKE 'extrafields' 1 0.001031 false
SHOW TABLES LIKE 'extrafields' 1 0.001089 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.000638 false
SHOW TABLES LIKE 'extrafields' 1 0.001107 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.000771 false
SHOW TABLES LIKE 'extrafields' 1 0.001233 false
SHOW TABLES LIKE 'extrafields' 1 0.001265 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.000863 false
SHOW TABLES LIKE 'extrafields' 1 0.001874 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.000830 false
SHOW TABLES LIKE 'extrafields' 1 0.001769 false
SHOW TABLES LIKE 'extrafields' 1 0.001546 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.000815 false
SHOW TABLES LIKE 'extrafields' 1 0.001355 false
SHOW TABLES LIKE 'extrafields' 1 0.001390 false
SHOW TABLES LIKE 'extrafields' 1 0.001241 false
SHOW TABLES LIKE 'extrafields' 1 0.001970 false
SHOW TABLES LIKE 'extrafields' 1 0.001690 false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order 7 0.000403 false
SHOW TABLES LIKE 'extrafields' 1 0.002095 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.000750 false
SHOW TABLES LIKE 'extrafields' 1 0.002086 false
SHOW TABLES LIKE 'extrafields' 1 0.001230 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.000418 false
SHOW TABLES LIKE 'extrafields' 1 0.001583 false
SHOW TABLES LIKE 'extrafields' 1 0.001075 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.000615 false
SHOW TABLES LIKE 'extrafields' 1 0.001086 false
SHOW TABLES LIKE 'extrafields' 1 0.001171 false
SHOW TABLES LIKE 'extrafields' 1 0.001135 false
SHOW TABLES LIKE 'extrafields' 1 0.001240 false
SHOW TABLES LIKE 'extrafields' 1 0.001204 false