Back

Каталог

Во время посещения сайта вы соглашаетесь с тем, что мы обрабатываем ваши персональные данные с использованием Продолжая использовать наш сайт, вы даете согласие на обработку файлов cookie, пользовательских данных (местоположение, сведения о браузере и ОС, тип устройства и разрешение его экрана, язык ОС и браузера, источник откуда пришел на сайт пользователь, ip-адрес) в целях функционирования сайта и проведения исследований. Если вы не хотите, чтобы ваши данные обрабатывались, покиньте сайт.
MySQL статистика (41)
Query Rows Time Cached
SET SESSION sql_mode = '' - 0.000025 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 18 0.001252 false
select count(*) from information_schema.columns where table_schema = database() and table_name = 'seo_settings' and column_name = 'seo_template_city' 1 0.000960 false
show tables 68 0.000551 false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1 1 0.000202 false
update seo_settings set individual_seo_settings = 'a:0:{}' - 0.002988 false
SELECT sale_points.* FROM sale_points WHERE (sale_points.is_active = 1) 3 0.000285 false
SELECT * FROM schedules WHERE object_class = 'Salepoints_Point' AND object_id = '1' 0 0.000170 false
SELECT * FROM schedules WHERE object_class = 'Salepoints_Point' AND object_id = '2' 0 0.000103 false
SELECT * FROM schedules WHERE object_class = 'Salepoints_Point' AND object_id = '3' 0 0.000103 false
SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order asc 65 0.000390 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 = '52') LIMIT 0, 1 1 0.001095 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '52') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.000272 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 = '44') LIMIT 0, 1 1 0.000393 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '44') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.000236 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 = '45') LIMIT 0, 1 1 0.000415 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '45') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.000199 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 = '32') LIMIT 0, 1 1 0.000314 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '32') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.001182 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 = '1') LIMIT 0, 1 1 0.000343 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '1') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.002809 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 = '12') LIMIT 0, 1 1 0.000510 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '12') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.000247 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 = '40') LIMIT 0, 1 1 0.000410 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '40') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.003610 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 = '7') LIMIT 0, 1 1 0.000593 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '7') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.000219 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 = '23') LIMIT 0, 1 1 0.000354 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '23') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.000239 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 = '6') LIMIT 0, 1 1 0.000340 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '6') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.000218 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 = '43') LIMIT 0, 1 1 0.000363 false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '43') AND (db_files.master_object_class='Catalog_Category' and field='image') ORDER BY id 1 0.000201 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.000359 false
SELECT id, parent_id, name FROM catalog_categories as cats WHERE cats.hidden is null AND cats.deleted is null ORDER BY cats.sort_order 44 0.000220 false
SELECT cats.id, cats.name FROM catalog_categories as cats WHERE cats.level = 1 AND cats.hidden is null AND cats.deleted is null ORDER BY cats.sort_order 10 0.000178 false
SELECT admin_module_settings.* FROM admin_module_settings WHERE (admin_module_settings.module_id='shop') AND (admin_module_settings.form_id='default') LIMIT 0, 1 1 0.000139 false
SELECT (select code from shop_order_statuses where id = ( select status_id from shop_ordershistory where order_id = shop_orders.id order by created_at desc limit 1 )) as status, (select name from shop_order_statuses where id = ( select status_id from shop_ordershistory where order_id = shop_orders.id order by created_at desc limit 1 )) as status_name, (select bg_color from shop_order_statuses where id = ( select status_id from shop_ordershistory where order_id = shop_orders.id order by created_at desc limit 1 )) as status_bg_color, (select group_concat(shop_orderitems.id ORDER BY 1 SEPARATOR ', ') from shop_orderitems where shop_orderitems.order_id = shop_orders.id) as items_calculated, (select group_concat(shop_ordershistory.id ORDER BY 1 SEPARATOR ', ') from shop_ordershistory where shop_ordershistory.order_id = shop_orders.id) as history_calculated, shop_orders.* FROM shop_orders WHERE (shop_orders.cart_id = 'f3b7d777b88c723460421b71b8fe16f24cfd9b423bc56a9e9159b5b8ca68eca0f858686064855d1372b096e07eb2743a5c3ed64caeca93e49dcd41f9afb8eae7') ORDER BY created_at DESC LIMIT 0, 1 0 0.000658 false
SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = 'f3b7d777b88c723460421b71b8fe16f24cfd9b423bc56a9e9159b5b8ca68eca0f858686064855d1372b096e07eb2743a5c3ed64caeca93e49dcd41f9afb8eae7') LIMIT 0, 1 0 0.000164 false
SELECT * FROM sale_points WHERE code = 'ys' 1 0.000153 false
SELECT product_id FROM salepoints_catalog_connections WHERE point_id = '1' AND `enable` = 1 332 0.000485 false