Товары для кондитеров
Товары | Query | Rows | Time | Cached |
|---|---|---|---|
| select count(*) from shop_carts where cart_id = 'eca4ed4ab2cb5b8152c48d1260d1d346d3304cd31d93bf7f2c0bdaa90fa00d16ffe608200826f1c1efeff4ac0ecbf7aa970c248cda68e0bfbf5f31b474bef883' | 1 | 0.000440 | false |
| SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1 | 1 | 0.000462 | false |
| update seo_settings set individual_seo_settings = 'a:0:{}' | - | 0.000129 | 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 | 9 | 0.000994 | false |
| SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = 'eca4ed4ab2cb5b8152c48d1260d1d346d3304cd31d93bf7f2c0bdaa90fa00d16ffe608200826f1c1efeff4ac0ecbf7aa970c248cda68e0bfbf5f31b474bef883') LIMIT 0, 1 | 0 | 0.000157 | false |
| SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC | 20 | 0.000866 | false |
| SELECT * FROM catalog_products as products WHERE id = '27' AND hidden is null AND deleted is null AND category_id in ('3', '4', '5', '6', '7', '8', '9', '2', '23', '21', '20', '19', '18', '1', '14', '15', '13', '12', '11', '10') LIMIT 0, 1 | 1 | 0.000798 | false |
| SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('27') | 0 | 0.000219 | 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 ('27') | 0 | 0.001671 | false |
| SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = 'eca4ed4ab2cb5b8152c48d1260d1d346d3304cd31d93bf7f2c0bdaa90fa00d16ffe608200826f1c1efeff4ac0ecbf7aa970c248cda68e0bfbf5f31b474bef883') LIMIT 0, 1 | 0 | 0.000134 | 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, 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 = '19') LIMIT 0, 1 | 1 | 0.001105 | false |
| SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order | 23 | 0.000355 | false |
| SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = 'eca4ed4ab2cb5b8152c48d1260d1d346d3304cd31d93bf7f2c0bdaa90fa00d16ffe608200826f1c1efeff4ac0ecbf7aa970c248cda68e0bfbf5f31b474bef883') LIMIT 0, 1 | 0 | 0.000168 | false |
| SELECT * FROM catalog_categories WHERE guid = '4aad229a308c11e88673e840f2191f1e' AND name = 'Товар' AND level = '1' AND id = '19' AND deleted is null AND id in ('3', '4', '5', '6', '7', '8', '9', '2', '23', '21', '20', '19', '18', '1', '14', '15', '13', '12', '11', '10') | 1 | 0.000210 | false |
| SELECT * FROM catalog_products as products WHERE category_id in ('19') AND hidden is null AND deleted is null AND category_id in ('3', '4', '5', '6', '7', '8', '9', '2', '23', '21', '20', '19', '18', '1', '14', '15', '13', '12', '11', '10') LIMIT 0, 11 | 11 | 0.000681 | false |
| SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('22', '24', '25', '26', '27', '38', '39', '40', '41', '42', '43') | 6 | 0.000315 | 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 ('22', '24', '25', '26', '27', '38', '39', '40', '41', '42', '43') | 0 | 0.000261 | false |
| SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = 'eca4ed4ab2cb5b8152c48d1260d1d346d3304cd31d93bf7f2c0bdaa90fa00d16ffe608200826f1c1efeff4ac0ecbf7aa970c248cda68e0bfbf5f31b474bef883') LIMIT 0, 1 | 0 | 0.000175 | false |
| SELECT 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.001182 | false |
| SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1 | 1 | 0.000457 | false |
| SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '1') 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 | 3 | 0.001088 | false |
| SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order | 9 | 0.000292 | false |
| SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1 | 1 | 0.000214 | false |
| SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = 'eca4ed4ab2cb5b8152c48d1260d1d346d3304cd31d93bf7f2c0bdaa90fa00d16ffe608200826f1c1efeff4ac0ecbf7aa970c248cda68e0bfbf5f31b474bef883') LIMIT 0, 1 | 0 | 0.000148 | false |
| SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1 | 1 | 0.000222 | false |
| SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '1') 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 | 3 | 0.000649 | false |
Каталог
