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.000166	false
select count(*) from shop_carts where cart_id = '689fbcb9780cac99516b05fd1707b9a2dc680568becd4315a0c3677a0cce48406fe5bebfc8747e572b00e283efbed6c0da5e1ced2a8e7f93cf15ef02a1b025c1'	1	0.000205	false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1	1	0.000061	false
select price_id from pharmacy_clients where eshop = 1 and city = 'ys'	11	0.000040	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 '%%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81%' or lower(s.name) like '%%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81%' or p.`phonetic_name` like '%%' or s.phonetic_name like '%%' or lower(p.manufacturer) like '%%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81%' or lower(p.mnn) like '%%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81%') 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.343947	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 '%%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81%' or lower(s.name) like '%%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81%' or p.`phonetic_name` like '%%' or s.phonetic_name like '%%' or lower(p.manufacturer) like '%%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81%' or lower(p.mnn) like '%%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81%') 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) = '%d1%81%d1%82%d1%80%d0%b5%d0%bf%d1%81%d0%b8%d0%bb%d1%81', 1, 0) desc limit 6760, 40	23	1.600895	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.000144	false
SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '689fbcb9780cac99516b05fd1707b9a2dc680568becd4315a0c3677a0cce48406fe5bebfc8747e572b00e283efbed6c0da5e1ced2a8e7f93cf15ef02a1b025c1') LIMIT 0, 1	0	0.000262	false
select id, name from catalog_categories where parent_id is null order by sort_order asc	2	0.000111	false
select id, name from pharmacy_groups where category_id = 1	70	0.000116	false
select id, name from pharmacy_groups where category_id = 2	0	0.000109	false

Результаты поиска по запросу «%D1%81%D1%82%D1%80%D0%B5%D0%BF%D1%81%D0%B8%D0%BB%D1%81»

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

Ваш город?