Корзина

MySQL статистика (36)

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000027	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.001138	false
select count(*) from information_schema.columns where table_schema = database() and table_name = 'seo_settings' and column_name = 'seo_template_city'	1	0.000422	false
show tables	68	0.000501	false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1	1	0.000178	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0.000110	false
SELECT sale_points.* FROM sale_points WHERE (sale_points.is_active = 1)	3	0.000152	false
SELECT * FROM schedules WHERE object_class = 'Salepoints_Point' AND object_id = '1'	0	0.000108	false
SELECT * FROM schedules WHERE object_class = 'Salepoints_Point' AND object_id = '2'	0	0.000104	false
SELECT * FROM schedules WHERE object_class = 'Salepoints_Point' AND object_id = '3'	0	0.000080	false
SELECT * FROM catalog_categories as cats WHERE cats.hidden is null AND deleted is null ORDER BY parent_id, level	44	0.000306	false
SELECT * FROM sale_points WHERE code = 'kors'	1	0.000119	false
SELECT p.*, sc.point_id, sc.enable FROM catalog_products as p LEFT JOIN salepoints_catalog_connections as sc ON p.id = sc.product_id WHERE p.hidden is null AND category_id = '46' AND sc.point_id = 2 AND sc.enable = 1 ORDER BY p.sort_order	5	0.000441	false
SELECT id, disk_name as `path`, master_object_id as parent_id, field, is_main FROM db_files as f WHERE master_object_class = 'Catalog_Product' AND f.master_object_id in ('365', '251', '172', '173', '174')	5	0.000428	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.000160	false
SELECT COUNT(*) FROM shop_carts WHERE cart_id = 'ca91f5e223898284c4426e996069cda45df7b012f2663cb08c6ac158566bd930e046c47f9c9684b3b89e9561a5cf9cca9c3fac15fef3ba0c6e6217a8e50896e3'	1	0.000689	false
SELECT * FROM sale_points WHERE code = 'kors'	1	0.000162	false
SELECT product_id FROM salepoints_catalog_connections WHERE point_id = '2' AND `enable` = 1	313	0.000532	false
SELECT id, parent_id FROM catalog_categories	65	0.000117	false
SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC	44	0.000174	false
SELECT id, `path`, in_ys, in_kors, in_dol FROM catalog_categories WHERE deleted is null AND id in ('32', '1', '40', '6', '7', '43', '44', '12', '23', '52', '56', '39', '46', '50', '53', '54', '30', '57', '58', '59', '63', '64', '65', '19', '2', '3', '4', '5', '8', '9', '11', '14', '16', '38', '20', '21', '22', '24', '25', '27', '29', '31')	42	0.000246	false
SELECT * FROM catalog_categories WHERE in_kors = 1	65	0.000244	false
SELECT * FROM catalog_categories WHERE deleted is null AND id in ('32', '1', '40', '6', '7', '43', '44', '12', '23', '52', '56', '39', '46', '50', '53', '54', '30', '57', '58', '59', '63', '64', '65', '19', '2', '3', '4', '5', '8', '9', '11', '14', '16', '38', '20', '21', '22', '24', '25', '27', '29', '31') AND id in ('1', '2', '3', '4', '5', '6', '7', '8', '9', '11', '12', '14', '16', '19', '20', '21', '22', '23', '24', '25', '27', '29', '30', '31', '32', '38', '39', '40', '43', '44', '46', '50', '52', '53', '54', '56', '57', '58', '59', '63', '64', '65')	42	0.000453	false
SELECT products.* FROM catalog_products as products WHERE cart_recommend = 1 AND products.category_id in ('1', '2', '3', '4', '5', '6', '7', '8', '9', '11', '12', '14', '16', '19', '20', '21', '22', '23', '24', '25', '27', '29', '30', '31', '32', '38', '39', '40', '43', '44', '46', '50', '52', '53', '54', '56', '57', '58', '59', '63', '64', '65') AND products.hidden is null AND products.deleted is null AND products.category_id in ('32', '1', '40', '6', '7', '43', '44', '12', '23', '52', '56', '39', '46', '50', '53', '54', '30', '57', '58', '59', '63', '64', '65', '19', '2', '3', '4', '5', '8', '9', '11', '14', '16', '38', '20', '21', '22', '24', '25', '27', '29', '31') LIMIT 0, 101	4	0.001674	false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('274', '297', '404', '467')	4	0.000240	false
SELECT * FROM sale_points WHERE code = 'kors'	1	0.000110	false
SELECT product_id FROM salepoints_catalog_connections WHERE point_id = '2' AND `enable` = 1	313	0.000424	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.000162	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 = 'schedule_info') LIMIT 0, 1	1	0.000290	false
SELECT id, `path`, in_ys, in_kors, in_dol FROM catalog_categories WHERE level = '1' AND deleted is null AND id in ('32', '1', '40', '6', '7', '43', '44', '12', '23', '52', '56', '39', '46', '50', '53', '54', '30', '57', '58', '59', '63', '64', '65', '19', '2', '3', '4', '5', '8', '9', '11', '14', '16', '38', '20', '21', '22', '24', '25', '27', '29', '31')	10	0.000528	false
SELECT * FROM catalog_categories WHERE level = '1' AND deleted is null AND id in ('32', '1', '40', '6', '7', '43', '44', '12', '23', '52', '56', '39', '46', '50', '53', '54', '30', '57', '58', '59', '63', '64', '65', '19', '2', '3', '4', '5', '8', '9', '11', '14', '16', '38', '20', '21', '22', '24', '25', '27', '29', '31') AND id in ('1', '6', '7', '12', '23', '32', '40', '43', '44', '52') ORDER BY sort_order ASC	10	0.000361	false
SELECT items.id, items.parent_id, items.title, items.href FROM admin_menu_items as items LEFT JOIN admin_menus as menus ON menus.id = items.menu_id WHERE menus.code = 'main' and items.is_hidden is null and items.is_hidden_in_menu is null ORDER BY parent_id asc, sort_order	6	0.000301	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-promo') LIMIT 0, 1	1	0.000173	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 = 'vk-link') LIMIT 0, 1	1	0.000168	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 = 'android-link') LIMIT 0, 1	1	0.000148	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 = 'appstore-link') LIMIT 0, 1	1	0.000153	false

Like

Выберите город