SELECT * FROM os38h_url_alias WHERE keyword = 'yaponskiy-garnir' LIMIT 1
0.010805
SELECT * FROM os38h_category c LEFT JOIN os38h_category_description cd ON (c.category_id = cd.category_id) WHERE cd.language_id = 1 AND c.status = 1 ORDER BY c.parent_id, c.sort_order, cd.name
0.01006
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (71) AND p.shop_id = 221923 AND p.active = 1
0.002572
SELECT p.product_id FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = 1 AND p.status = 1 AND p2c.category_id IN (71) AND p.shop_id = 221923 AND p.active = 1 GROUP BY p.product_id ORDER BY p.sort_available, p.sort_order ASC, LCASE(pd.name) LIMIT 0,24
0.001853
SELECT * FROM os38h_product_prices WHERE product_id = '262189' AND `active` = 1
0.000323
SELECT * FROM os38h_product_prices WHERE product_id = '262190' AND `active` = 1
0.00028
SELECT * FROM os38h_product_prices WHERE product_id = '262209' AND `active` = 1
0.000243
SELECT * FROM os38h_product_prices WHERE product_id = '262210' AND `active` = 1
0.000222
SELECT * FROM os38h_product_prices WHERE product_id = '262220' AND `active` = 1
0.000217
SELECT * FROM os38h_product_prices WHERE product_id = '262230' AND `active` = 1
0.00021
SELECT * FROM os38h_product_prices WHERE product_id = '262428' AND `active` = 1
0.00023
SELECT * FROM os38h_product_prices WHERE product_id = '262429' AND `active` = 1
0.000221
SELECT * FROM os38h_product_prices WHERE product_id = '262431' AND `active` = 1
0.000226
SELECT * FROM os38h_product_prices WHERE product_id = '262432' AND `active` = 1
0.000213
SELECT * FROM os38h_product_prices WHERE product_id = '262433' AND `active` = 1
0.000217
SELECT * FROM os38h_product_prices WHERE product_id = '262435' AND `active` = 1
0.000197
SELECT * FROM os38h_product_prices WHERE product_id = '262436' AND `active` = 1
0.000198
SELECT * FROM os38h_product_prices WHERE product_id = '262438' AND `active` = 1
0.000193
SELECT shop_custom_from, shop_custom_to, shop_day4_from, shop_day4_to, shop_day3_from, shop_day3_to, shop_day5_from, shop_day5_to FROM os38h_shops WHERE shop_id = 221923
0.000251
SELECT * FROM os38h_category_to_layout WHERE category_id = '71' AND store_id = '0'
0.000294
SELECT COUNT(DISTINCT p.product_id) AS total, p2c.category_id, cd.name, c.parent_id, IF(c.parent_id IS NOT NULL AND c.parent_id != 0, cp.sort_order, c.sort_order) AS main_sort
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN os38h_category c ON (c.category_id = p2c.category_id)
LEFT JOIN os38h_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN os38h_category cp ON c.parent_id = cp.category_id
WHERE pd.language_id = 1 AND p.status = 1 AND p2c.category_id IN (SELECT c.category_id FROM os38h_category c LEFT JOIN os38h_category_description cd ON (c.category_id = cd.category_id) WHERE cd.language_id = 1 AND c.status = 1) AND p.shop_id = 221923 AND p.active = 1 GROUP BY p2c.category_id ORDER BY main_sort, p.sort_order, cd.name
0.007752
SELECT * FROM os38h_category_to_layout WHERE category_id = '71' AND store_id = '0'
0.000294
SELECT * FROM os38h_category_to_layout WHERE category_id = '71' AND store_id = '0'
0.00045
SELECT * FROM os38h_category_to_layout WHERE category_id = '71' AND store_id = '0'
0.000197
SELECT *, s.shop_id as shop_id FROM os38h_shops as s LEFT JOIN os38h_shop_sales as ss ON (s.shop_id = ss.shop_id) WHERE s.shop_id = 221923 AND s.shop_active = 1
0.000699
SELECT city_id FROM os38h_shops_city WHERE shop_id = 221923
0.000295
SELECT shop_custom_from, shop_custom_to, shop_day4_from, shop_day4_to, shop_day3_from, shop_day3_to, shop_day5_from, shop_day5_to FROM os38h_shops WHERE shop_id = 221923
0.000314
SELECT payment_code FROM os38h_shop_payment WHERE shop_id = 221923
0.000305
SELECT keyword FROM os38h_url_alias WHERE query = 'cityid=1'
0.046001
Заказывай через мобильное приложение и получай баллы за каждый заказ!