Query	Rows	Time	Cached
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	199	0.000254	false
select count(*) from shop_carts where cart_id = '506b1a86e93957cad2454894d1e3266366b8b07bae3688c462ff272cdb715c8563122c8d8a49814fce5f8d5cac7c64c5f38b6d1c4cb80a85f88535ea59ea1d47'	1	0.000746	false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1	1	0.000135	false
select price_id from pharmacy_clients where eshop = 1 and city = 'ys'	11	0.000085	false
select count(distinct p.id) from catalog_skus as s left join catalog_products p on p.id = s.product_id left join pharmacy_sku_prices sp on sp.sku_guid = s.guid where sp.price_id in ('606', '144', '135', '136', '143', '573', '572', '574', '593', '594', '706') and ((lower(p.name) like '%алерана%' or lower(s.name) like '%алерана%' or p.`phonetic_name` like '%алирана%' or s.phonetic_name like '%алирана%' or lower(p.manufacturer) like '%алерана%' or lower(p.mnn) like '%алерана%') and if('' != '', lower(p.manufacturer) like '%%', true)) and (p.hidden is null or p.hidden <> 1) and (p.exception_1 is null or p.exception_1 <> 1)	1	0.503088	false
select *, min(inner_from.price) as price_min, max(inner_from.price) as price_max, count(distinct inner_from.ps_id) as stories_counter from ( select s.product_id, s.id, s.name, s.leftover, sp.price_id, sp.price, sp.price_2, p.discount, pg.group_id, p.recipe, ps.id as ps_id, df.id as image_id, df.disk_name as image_path from catalog_skus as s left join catalog_products p on p.id = s.product_id left join pharmacy_sku_prices sp on sp.sku_guid = s.guid left join pharmacy_products_groups pg on pg.product_id = p.id left join pharmacy_stores ps on ps.price_id = sp.price_id left join db_files df on df.master_object_id = p.id and df.master_object_class = 'Catalog_Product' and df.field = 'photos' where sp.price_id in ('606', '144', '135', '136', '143', '573', '572', '574', '593', '594', '706') and ps.is_show = 1 and ((lower(p.name) like '%алерана%' or lower(s.name) like '%алерана%' or p.`phonetic_name` like '%алирана%' or s.phonetic_name like '%алирана%' or lower(p.manufacturer) like '%алерана%' or lower(p.mnn) like '%алерана%') and if('' != '', lower(p.manufacturer) like '%%', true)) and (p.hidden is null or p.hidden <> 1) and (p.exception_1 is null or p.exception_1 <> 1) and s.leftover > 0 order by sp.price desc ) as inner_from group by inner_from.product_id, inner_from.name having count(distinct inner_from.ps_id) order by IF(lower(inner_from.name) = 'алерана', 1, 0) desc limit 0, 40	19	0.554190	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.000324	false
SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '506b1a86e93957cad2454894d1e3266366b8b07bae3688c462ff272cdb715c8563122c8d8a49814fce5f8d5cac7c64c5f38b6d1c4cb80a85f88535ea59ea1d47') LIMIT 0, 1	0	0.000428	false
select id, name from catalog_categories where parent_id is null order by sort_order asc	2	0.000162	false
select id, name from pharmacy_groups where category_id = 1	65	0.000160	false
select id, name from pharmacy_groups where category_id = 2	0	0.000098	false

Результаты поиска по запросу «Алерана»

Справочная служба

Ваш город?