MySQL статистика (156)
Query Rows Time Cached
SET SESSION sql_mode = '' - 0.000093 false
select count(*) from shop_carts where cart_id = '8a666711667d1d12934c3475899610742465dbcdb955d3316a11e990e1b248e28547e4dd5171c1601c4118721f21323ec101701c970934246f9da75c31b702a7' 1 0.000344 false
SHOW TABLES LIKE 'extrafields' 1 0.001538 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.000645 false
SHOW TABLES LIKE 'extrafields' 1 0.001804 false
update seo_settings set individual_seo_settings = 'a:0:{}' - 0.000297 false
SHOW TABLES LIKE 'extrafields' 1 0.001723 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.000782 false
SHOW TABLES LIKE 'extrafields' 1 0.001780 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 = '2089') LIMIT 0, 1 1 0.000928 false
SHOW TABLES LIKE 'extrafields' 1 0.010705 false
SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC 49 0.000913 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 = '2089' 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.000716 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 = '2089' 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.000395 false
SHOW TABLES LIKE 'extrafields' 1 0.001499 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 = '8a666711667d1d12934c3475899610742465dbcdb955d3316a11e990e1b248e28547e4dd5171c1601c4118721f21323ec101701c970934246f9da75c31b702a7') LIMIT 0, 1 0 0.000464 false
SHOW TABLES LIKE 'extrafields' 1 0.001489 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '2089' 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.000473 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '2089' 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.000351 false
SHOW TABLES LIKE 'extrafields' 1 0.005113 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 = '8a666711667d1d12934c3475899610742465dbcdb955d3316a11e990e1b248e28547e4dd5171c1601c4118721f21323ec101701c970934246f9da75c31b702a7') LIMIT 0, 1 0 0.000553 false
SHOW TABLES LIKE 'extrafields' 1 0.001598 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '2089' 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.000510 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '2089' 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.000317 false
SHOW TABLES LIKE 'extrafields' 1 0.001550 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 = '8a666711667d1d12934c3475899610742465dbcdb955d3316a11e990e1b248e28547e4dd5171c1601c4118721f21323ec101701c970934246f9da75c31b702a7') LIMIT 0, 1 0 0.000359 false
SHOW TABLES LIKE 'extrafields' 1 0.001633 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id = '2089' 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.000703 false
SELECT products.* FROM catalog_products as products WHERE products.category_id = '2089' 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.000350 false
SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order 49 0.000501 false
SHOW TABLES LIKE 'extrafields' 1 0.001641 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.000525 false
SHOW TABLES LIKE 'extrafields' 1 0.001484 false
SHOW TABLES LIKE 'extrafields' 1 0.001498 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 = '8a666711667d1d12934c3475899610742465dbcdb955d3316a11e990e1b248e28547e4dd5171c1601c4118721f21323ec101701c970934246f9da75c31b702a7') LIMIT 0, 1 0 0.000346 false
SHOW TABLES LIKE 'extrafields' 1 0.001477 false
SHOW TABLES LIKE 'extrafields' 1 0.001435 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.000862 false
SHOW TABLES LIKE 'extrafields' 1 0.001601 false
SHOW TABLES LIKE 'extrafields' 1 0.001598 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.001329 false
SHOW TABLES LIKE 'extrafields' 1 0.001623 false
SHOW TABLES LIKE 'extrafields' 1 0.001575 false
SHOW TABLES LIKE 'extrafields' 1 0.001517 false
SHOW TABLES LIKE 'extrafields' 1 0.001647 false
SHOW TABLES LIKE 'extrafields' 1 0.001565 false
SHOW TABLES LIKE 'extrafields' 1 0.001498 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.000859 false
SHOW TABLES LIKE 'extrafields' 1 0.001480 false
SHOW TABLES LIKE 'extrafields' 1 0.001429 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.001192 false
SHOW TABLES LIKE 'extrafields' 1 0.001522 false
SHOW TABLES LIKE 'extrafields' 1 0.001476 false
SHOW TABLES LIKE 'extrafields' 1 0.001521 false
SHOW TABLES LIKE 'extrafields' 1 0.001501 false
SHOW TABLES LIKE 'extrafields' 1 0.001482 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.000814 false
SHOW TABLES LIKE 'extrafields' 1 0.001476 false
SHOW TABLES LIKE 'extrafields' 1 0.001622 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.001156 false
SHOW TABLES LIKE 'extrafields' 1 0.001546 false
SHOW TABLES LIKE 'extrafields' 1 0.001566 false
SHOW TABLES LIKE 'extrafields' 1 0.001626 false
SHOW TABLES LIKE 'extrafields' 1 0.001560 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.000911 false
SHOW TABLES LIKE 'extrafields' 1 0.001509 false
SHOW TABLES LIKE 'extrafields' 1 0.001551 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.001327 false
SHOW TABLES LIKE 'extrafields' 1 0.001654 false
SHOW TABLES LIKE 'extrafields' 1 0.001635 false
SHOW TABLES LIKE 'extrafields' 1 0.001621 false
SHOW TABLES LIKE 'extrafields' 1 0.001867 false
SHOW TABLES LIKE 'extrafields' 1 0.001607 false
SHOW TABLES LIKE 'extrafields' 1 0.001503 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.000955 false
SHOW TABLES LIKE 'extrafields' 1 0.001623 false
SHOW TABLES LIKE 'extrafields' 1 0.001389 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.000881 false
SHOW TABLES LIKE 'extrafields' 1 0.001360 false
SHOW TABLES LIKE 'extrafields' 1 0.001385 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.000856 false
SHOW TABLES LIKE 'extrafields' 1 0.002004 false
SHOW TABLES LIKE 'extrafields' 1 0.001638 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.001265 false
SHOW TABLES LIKE 'extrafields' 1 0.001788 false
SHOW TABLES LIKE 'extrafields' 1 0.002025 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.001095 false
SHOW TABLES LIKE 'extrafields' 1 0.001958 false
SHOW TABLES LIKE 'extrafields' 1 0.001617 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.001183 false
SHOW TABLES LIKE 'extrafields' 1 0.001865 false
SHOW TABLES LIKE 'extrafields' 1 0.001808 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 = '2098') LIMIT 0, 1 1 0.001017 false
SHOW TABLES LIKE 'extrafields' 1 0.002041 false
SHOW TABLES LIKE 'extrafields' 1 0.001621 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.001190 false
SHOW TABLES LIKE 'extrafields' 1 0.001861 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.000790 false
SHOW TABLES LIKE 'extrafields' 1 0.001235 false
SHOW TABLES LIKE 'extrafields' 1 0.001610 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.000993 false
SHOW TABLES LIKE 'extrafields' 1 0.001646 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.000970 false
SHOW TABLES LIKE 'extrafields' 1 0.001638 false
SHOW TABLES LIKE 'extrafields' 1 0.001772 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.000926 false
SHOW TABLES LIKE 'extrafields' 1 0.001681 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.001047 false
SHOW TABLES LIKE 'extrafields' 1 0.001620 false
SHOW TABLES LIKE 'extrafields' 1 0.001833 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.000913 false
SHOW TABLES LIKE 'extrafields' 1 0.001786 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.000947 false
SHOW TABLES LIKE 'extrafields' 1 0.001768 false
SHOW TABLES LIKE 'extrafields' 1 0.001801 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.000933 false
SHOW TABLES LIKE 'extrafields' 1 0.001292 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.001045 false
SHOW TABLES LIKE 'extrafields' 1 0.001934 false
SHOW TABLES LIKE 'extrafields' 1 0.002025 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.000952 false
SHOW TABLES LIKE 'extrafields' 1 0.001891 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.001163 false
SHOW TABLES LIKE 'extrafields' 1 0.001916 false
SHOW TABLES LIKE 'extrafields' 1 0.002665 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.001029 false
SHOW TABLES LIKE 'extrafields' 1 0.001565 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.001011 false
SHOW TABLES LIKE 'extrafields' 1 0.001883 false
SHOW TABLES LIKE 'extrafields' 1 0.001947 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.001086 false
SHOW TABLES LIKE 'extrafields' 1 0.001578 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.000699 false
SHOW TABLES LIKE 'extrafields' 1 0.001432 false
SHOW TABLES LIKE 'extrafields' 1 0.001825 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.000843 false
SHOW TABLES LIKE 'extrafields' 1 0.001509 false
SHOW TABLES LIKE 'extrafields' 1 0.001642 false
SHOW TABLES LIKE 'extrafields' 1 0.001453 false
SHOW TABLES LIKE 'extrafields' 1 0.001344 false
SHOW TABLES LIKE 'extrafields' 1 0.001078 false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order 7 0.000325 false
SHOW TABLES LIKE 'extrafields' 1 0.001081 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.000374 false
SHOW TABLES LIKE 'extrafields' 1 0.001201 false
SHOW TABLES LIKE 'extrafields' 1 0.001200 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.000467 false
SHOW TABLES LIKE 'extrafields' 1 0.001063 false
SHOW TABLES LIKE 'extrafields' 1 0.001132 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.000567 false
SHOW TABLES LIKE 'extrafields' 1 0.001133 false
SHOW TABLES LIKE 'extrafields' 1 0.001148 false
SHOW TABLES LIKE 'extrafields' 1 0.001065 false
SHOW TABLES LIKE 'extrafields' 1 0.001022 false
SHOW TABLES LIKE 'extrafields' 1 0.001092 false