Металлические стеллажи

MS Standart (500 кг на секцию)

MS Strong (750 кг на секцию)

Стеллажи SBL (750 КГ на стеллаж)

MS PRO (3000 КГ НА СЕКЦИЮ)

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000038	false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1	1	0.000640	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0.000387	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '8') LIMIT 0, 1	1	0.001597	false
SELECT product_id, category_id FROM catalog_products_alt_categories WHERE category_id='8' ORDER BY product_id ASC	0	0.000385	false
SELECT count(DISTINCT catalog_products.id) FROM catalog_products LEFT JOIN catalog_products_alt_categories ON catalog_products_alt_categories.product_id = catalog_products.id LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id WHERE (catalog_products.category_id = '8') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) OR (catalog_products_alt_categories.category_id = '8') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null)	1	0.005577	false
SELECT catalog_products_alt_categories.category_id as alt_category_id, (select min(price) from catalog_skus where product_id=catalog_products.id) as min_price, (select max(price) from catalog_skus where product_id=catalog_products.id) as max_price, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_products.id and (master_object_class='Catalog_Product' and field='photos')) as photos_calculated, (category_calculated_join.name) as category_calculated, (type_calculated_join.name) as type_calculated, (select group_concat(catalog_skus.name ORDER BY 1 SEPARATOR ', ') from catalog_skus where catalog_skus.product_id = catalog_products.id) as skus_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_products.id) as colours_calculated, (select group_concat(catalog_categories.name ORDER BY 1 SEPARATOR ', ') from catalog_categories, catalog_products_alt_categories where catalog_categories.id=catalog_products_alt_categories.category_id and catalog_products_alt_categories.product_id=catalog_products.id) as alt_categories_calculated, catalog_products.* FROM catalog_products LEFT JOIN catalog_products_alt_categories ON catalog_products_alt_categories.product_id = catalog_products.id LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id WHERE (catalog_products.category_id = '8') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) OR (catalog_products_alt_categories.category_id = '8') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) GROUP BY catalog_products.id ORDER BY CASE WHEN catalog_products.category_id = 8 THEN 0 ELSE 1 END, sort_order asc LIMIT 0, 28	0	0.021413	false
SELECT (select min(price) from catalog_skus where product_id=catalog_products.id) as min_price, (select max(price) from catalog_skus where product_id=catalog_products.id) as max_price, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_products.id and (master_object_class='Catalog_Product' and field='photos')) as photos_calculated, (category_calculated_join.name) as category_calculated, (type_calculated_join.name) as type_calculated, (select group_concat(catalog_skus.name ORDER BY 1 SEPARATOR ', ') from catalog_skus where catalog_skus.product_id = catalog_products.id) as skus_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_products.id) as colours_calculated, (select group_concat(catalog_categories.name ORDER BY 1 SEPARATOR ', ') from catalog_categories, catalog_products_alt_categories where catalog_categories.id=catalog_products_alt_categories.category_id and catalog_products_alt_categories.product_id=catalog_products.id) as alt_categories_calculated, catalog_products.* FROM catalog_products LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id WHERE (catalog_products.sell_out = 1) AND (catalog_products.hidden is null) AND (catalog_products.deleted is null)	6	0.018059	false
SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order	213	0.002594	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '158') LIMIT 0, 1	1	0.002222	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '158') LIMIT 0, 1	1	0.001425	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '158') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	14	0.000621	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '158') LIMIT 0, 1	1	0.001347	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '158') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	14	0.000525	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '158') LIMIT 0, 1	1	0.001277	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '158') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	14	0.000539	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '160') LIMIT 0, 1	1	0.001458	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '160') LIMIT 0, 1	1	0.001490	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '160') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	13	0.000526	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '160') LIMIT 0, 1	1	0.001178	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '160') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	13	0.000453	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '160') LIMIT 0, 1	1	0.001031	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '160') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	13	0.000520	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '235') LIMIT 0, 1	1	0.001285	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '235') LIMIT 0, 1	1	0.000802	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '235') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	3	0.000364	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '235') LIMIT 0, 1	1	0.000739	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '235') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	3	0.000279	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '235') LIMIT 0, 1	1	0.000650	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '235') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	3	0.000270	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '171') LIMIT 0, 1	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '171') LIMIT 0, 1	1	0.001029	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '171') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	6	0.000345	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '171') LIMIT 0, 1	1	0.001884	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '171') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	6	0.000415	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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_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 = '171') LIMIT 0, 1	1	0.001228	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '171') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order	6	0.000426	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.000296	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.code = 'header_wa') LIMIT 0, 1	1	0.000398	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.code = 'header_address') LIMIT 0, 1	1	0.000262	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.code = 'header_tel') LIMIT 0, 1	1	0.000234	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.code = 'header_mail') LIMIT 0, 1	1	0.000249	false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1	1	0.000338	false
SELECT 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	6	0.000399	false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order	25	0.000315	false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1	1	0.000178	false
select count(*) from shop_carts where cart_id = '6d62dfd182257b9d9705c358dd1ac8d3275f3e6344dfd7b582b427eb51708890526e6008f583c00d394ee8a08aadaec4f45224be62d7385a11952361af735ebd'	1	0.000295	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.code = 'header_tel_mobile') LIMIT 0, 1	1	0.000248	false
SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '6d62dfd182257b9d9705c358dd1ac8d3275f3e6344dfd7b582b427eb51708890526e6008f583c00d394ee8a08aadaec4f45224be62d7385a11952361af735ebd') LIMIT 0, 1	0	0.000172	false
select id, is_recommended, name from catalog_categories where parent_id is null and hidden is null order by sort_order asc	13	0.000301	false
select id, is_recommended, name from catalog_categories where parent_id = 1 and hidden is null order by sort_order asc	6	0.000264	false
select id, is_recommended, name from catalog_categories where parent_id = 21 and hidden is null order by sort_order asc	6	0.000180	false
select id, is_recommended, name from catalog_categories where parent_id = 4 and hidden is null order by sort_order asc	9	0.000172	false
select id, is_recommended, name from catalog_categories where parent_id = 22 and hidden is null order by sort_order asc	7	0.000182	false
select id, is_recommended, name from catalog_categories where parent_id = 16 and hidden is null order by sort_order asc	8	0.000175	false
select id, is_recommended, name from catalog_categories where parent_id = 8 and hidden is null order by sort_order asc	4	0.000138	false
select id, is_recommended, name from catalog_categories where parent_id = 135 and hidden is null order by sort_order asc	9	0.000149	false
select id, is_recommended, name from catalog_categories where parent_id = 232 and hidden is null order by sort_order asc	0	0.000114	false
select id, is_recommended, name from catalog_categories where parent_id = 14 and hidden is null order by sort_order asc	0	0.000287	false
select id, is_recommended, name from catalog_categories where parent_id = 63 and hidden is null order by sort_order asc	3	0.000165	false
select id, is_recommended, name from catalog_categories where parent_id = 65 and hidden is null order by sort_order asc	11	0.000176	false
select id, is_recommended, name from catalog_categories where parent_id = 62 and hidden is null order by sort_order asc	0	0.000122	false
select id, is_recommended, name from catalog_categories where parent_id = 203 and hidden is null order by sort_order asc	0	0.000106	false
SELECT * FROM banners_categories WHERE code = 'sidebar_banners'	1	0.000227	false
SELECT max(id) as id FROM banners WHERE category_id = '2' AND enabled = 1 GROUP BY position	1	0.000413	false
SELECT (DATEDIFF(CURRENT_DATE(), date_enabled)) as days_enabled, (category_calculated_join.name) as category_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='image')) as image_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='flash_file')) as flash_file_calculated, banners.* FROM banners LEFT JOIN banners_categories as category_calculated_join ON category_calculated_join.id = banners.category_id WHERE (banners.id IN ('12')) ORDER BY banners.sort_order DESC, banners.id	1	0.000608	false
SELECT (DATEDIFF(CURRENT_DATE(), date_enabled)) as days_enabled, (category_calculated_join.name) as category_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='image')) as image_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='flash_file')) as flash_file_calculated, banners.* FROM banners LEFT JOIN banners_categories as category_calculated_join ON category_calculated_join.id = banners.category_id WHERE (banners.position='12') AND (( exposure_limit_type is NULL or exposure_limit_type = 0 or (exposure_limit_type = 1 and period_start >= CURRENT_DATE() and period_end <= CURRENT_DATE()) or (exposure_limit_type = 2 and hits_left > 0) ))	1	0.000591	false
update banners set impression_number = impression_number+1 where id in ('12')	-	0.000160	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '12') AND (db_files.master_object_class='Banners_Banner' and field='image') ORDER BY id	1	0.000253	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.code = 'footer_address') LIMIT 0, 1	1	0.000258	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.code = 'footer_address') LIMIT 0, 1	1	0.000229	false

Query

Rows

Time

Cached

SET SESSION sql_mode = ''

0.000038

false

SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1

0.000640

false

update seo_settings set individual_seo_settings = 'a:0:{}'

0.000387

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(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_calculated, catalog_categories.* FROM catalog_categories LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_categories.id = '8') LIMIT 0, 1

0.001597

false

SELECT product_id, category_id FROM catalog_products_alt_categories WHERE category_id='8' ORDER BY product_id ASC

0.000385

false

SELECT count(DISTINCT catalog_products.id) FROM catalog_products LEFT JOIN catalog_products_alt_categories ON catalog_products_alt_categories.product_id = catalog_products.id LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id WHERE (catalog_products.category_id = '8') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) OR (catalog_products_alt_categories.category_id = '8') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null)

0.005577

false

SELECT catalog_products_alt_categories.category_id as alt_category_id, (select min(price) from catalog_skus where product_id=catalog_products.id) as min_price, (select max(price) from catalog_skus where product_id=catalog_products.id) as max_price, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_products.id and (master_object_class='Catalog_Product' and field='photos')) as photos_calculated, (category_calculated_join.name) as category_calculated, (type_calculated_join.name) as type_calculated, (select group_concat(catalog_skus.name ORDER BY 1 SEPARATOR ', ') from catalog_skus where catalog_skus.product_id = catalog_products.id) as skus_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_products.id) as colours_calculated, (select group_concat(catalog_categories.name ORDER BY 1 SEPARATOR ', ') from catalog_categories, catalog_products_alt_categories where catalog_categories.id=catalog_products_alt_categories.category_id and catalog_products_alt_categories.product_id=catalog_products.id) as alt_categories_calculated, catalog_products.* FROM catalog_products LEFT JOIN catalog_products_alt_categories ON catalog_products_alt_categories.product_id = catalog_products.id LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id WHERE (catalog_products.category_id = '8') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) OR (catalog_products_alt_categories.category_id = '8') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) GROUP BY catalog_products.id ORDER BY CASE WHEN catalog_products.category_id = 8 THEN 0 ELSE 1 END, sort_order asc LIMIT 0, 28

0.021413

false

SELECT (select min(price) from catalog_skus where product_id=catalog_products.id) as min_price, (select max(price) from catalog_skus where product_id=catalog_products.id) as max_price, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = catalog_products.id and (master_object_class='Catalog_Product' and field='photos')) as photos_calculated, (category_calculated_join.name) as category_calculated, (type_calculated_join.name) as type_calculated, (select group_concat(catalog_skus.name ORDER BY 1 SEPARATOR ', ') from catalog_skus where catalog_skus.product_id = catalog_products.id) as skus_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where mebel_relations.object_id = catalog_products.id) as colours_calculated, (select group_concat(catalog_categories.name ORDER BY 1 SEPARATOR ', ') from catalog_categories, catalog_products_alt_categories where catalog_categories.id=catalog_products_alt_categories.category_id and catalog_products_alt_categories.product_id=catalog_products.id) as alt_categories_calculated, catalog_products.* FROM catalog_products LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id WHERE (catalog_products.sell_out = 1) AND (catalog_products.hidden is null) AND (catalog_products.deleted is null)

0.018059

false

SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order

213

0.002594

false

0.002222

false

0.001425

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '158') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000621

false

0.001347

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '158') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000525

false

0.001277

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '158') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000539

false

0.001458

false

0.001490

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '160') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000526

false

0.001178

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '160') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000453

false

0.001031

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '160') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000520

false

0.001285

false

0.000802

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '235') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000364

false

0.000739

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '235') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000279

false

0.000650

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '235') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000270

false

0.001786

false

0.001029

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '171') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000345

false

0.001884

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '171') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000415

false

0.001228

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '171') AND (db_files.master_object_class='Catalog_Category' and field='photos') ORDER BY sort_order

0.000426

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

0.000296

false

SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.code = 'header_wa') LIMIT 0, 1

0.000398

false

0.000262

false

0.000234

false

0.000249

false

SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1

0.000338

false

SELECT 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

0.000399

false

SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order

0.000315

false

SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1

0.000178

false

select count(*) from shop_carts where cart_id = '6d62dfd182257b9d9705c358dd1ac8d3275f3e6344dfd7b582b427eb51708890526e6008f583c00d394ee8a08aadaec4f45224be62d7385a11952361af735ebd'

0.000295

false

0.000248

false

SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '6d62dfd182257b9d9705c358dd1ac8d3275f3e6344dfd7b582b427eb51708890526e6008f583c00d394ee8a08aadaec4f45224be62d7385a11952361af735ebd') LIMIT 0, 1

0.000172

false

select id, is_recommended, name from catalog_categories where parent_id is null and hidden is null order by sort_order asc

0.000301

false

select id, is_recommended, name from catalog_categories where parent_id = 1 and hidden is null order by sort_order asc

0.000264

false

select id, is_recommended, name from catalog_categories where parent_id = 21 and hidden is null order by sort_order asc

0.000180

false

select id, is_recommended, name from catalog_categories where parent_id = 4 and hidden is null order by sort_order asc

0.000172

false

select id, is_recommended, name from catalog_categories where parent_id = 22 and hidden is null order by sort_order asc

0.000182

false

select id, is_recommended, name from catalog_categories where parent_id = 16 and hidden is null order by sort_order asc

0.000175

false

select id, is_recommended, name from catalog_categories where parent_id = 8 and hidden is null order by sort_order asc

0.000138

false

select id, is_recommended, name from catalog_categories where parent_id = 135 and hidden is null order by sort_order asc

0.000149

false

select id, is_recommended, name from catalog_categories where parent_id = 232 and hidden is null order by sort_order asc

0.000114

false

select id, is_recommended, name from catalog_categories where parent_id = 14 and hidden is null order by sort_order asc

0.000287

false

select id, is_recommended, name from catalog_categories where parent_id = 63 and hidden is null order by sort_order asc

0.000165

false

select id, is_recommended, name from catalog_categories where parent_id = 65 and hidden is null order by sort_order asc

0.000176

false

select id, is_recommended, name from catalog_categories where parent_id = 62 and hidden is null order by sort_order asc

0.000122

false

select id, is_recommended, name from catalog_categories where parent_id = 203 and hidden is null order by sort_order asc

0.000106

false

SELECT * FROM banners_categories WHERE code = 'sidebar_banners'

0.000227

false

SELECT max(id) as id FROM banners WHERE category_id = '2' AND enabled = 1 GROUP BY position

0.000413

false

SELECT (DATEDIFF(CURRENT_DATE(), date_enabled)) as days_enabled, (category_calculated_join.name) as category_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='image')) as image_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='flash_file')) as flash_file_calculated, banners.* FROM banners LEFT JOIN banners_categories as category_calculated_join ON category_calculated_join.id = banners.category_id WHERE (banners.id IN ('12')) ORDER BY banners.sort_order DESC, banners.id

0.000608

false

SELECT (DATEDIFF(CURRENT_DATE(), date_enabled)) as days_enabled, (category_calculated_join.name) as category_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='image')) as image_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='flash_file')) as flash_file_calculated, banners.* FROM banners LEFT JOIN banners_categories as category_calculated_join ON category_calculated_join.id = banners.category_id WHERE (banners.position='12') AND (( exposure_limit_type is NULL or exposure_limit_type = 0 or (exposure_limit_type = 1 and period_start >= CURRENT_DATE() and period_end <= CURRENT_DATE()) or (exposure_limit_type = 2 and hits_left > 0) ))

0.000591

false

update banners set impression_number = impression_number+1 where id in ('12')

0.000160

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '12') AND (db_files.master_object_class='Banners_Banner' and field='image') ORDER BY id

0.000253

false

0.000258

false

0.000229

false

Контакты

Контакты