SELECT * FROM os38h_url_alias WHERE keyword = 'salaty'
Called by __construct in Position
Called by

SELECT LOWER(keyword) as keyword, query FROM os38h_url_alias
Called by __construct in ControllerCommonSeoPro
Called by execute in Front

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
Called by getCategories in ModelCatalogCategory
Called by getCategory in ModelCatalogCategory

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 (17) AND p.shop_id = '4335' AND p.active = '1'
Called by getTotalProducts in ModelCatalogProduct
Called by index in ControllerProductCategory

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 (17) AND p.shop_id = 4335 AND p.active = 1 GROUP BY p.product_id ORDER BY p.sort_available, p.sort_order ASC, LCASE(pd.name) LIMIT 0,24
Called by getProducts in ModelCatalogProduct
Called by index in ControllerProductCategory

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM os38h_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 43331 AND ptc.main_category = '1') AS main_category, p.sort_order FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '43331' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
Called by getProduct in ModelCatalogProduct
Called by getProducts in ModelCatalogProduct

SELECT * FROM os38h_product_prices WHERE product_id = '43331' AND `active` = 1
Called by getSpecialPrice in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM os38h_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 43332 AND ptc.main_category = '1') AS main_category, p.sort_order FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '43332' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
Called by getProduct in ModelCatalogProduct
Called by getProducts in ModelCatalogProduct

SELECT * FROM os38h_product_prices WHERE product_id = '43332' AND `active` = 1
Called by getSpecialPrice in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT shop_custom_from, shop_custom_to, shop_day3_from, shop_day3_to, shop_day2_from, shop_day2_to, shop_day4_from, shop_day4_to FROM os38h_shops WHERE shop_id = 4335
Called by isOpenShop in Helper
Called by index in ControllerProductCategory

SELECT category_id FROM os38h_product_to_category WHERE product_id = '43331' ORDER BY main_category DESC LIMIT 1
Called by getPathByProduct in ControllerCommonSeoPro
Called by rewrite in ControllerCommonSeoPro

SELECT category_id FROM os38h_product_to_category WHERE product_id = '43332' ORDER BY main_category DESC LIMIT 1
Called by getPathByProduct in ControllerCommonSeoPro
Called by rewrite in ControllerCommonSeoPro

SELECT * FROM os38h_category_to_layout WHERE category_id = '17' AND store_id = '0'
Called by getCategoryLayoutId in ModelCatalogCategory
Called by index in ControllerCommonColumnLeft

SELECT COUNT(DISTINCT p.product_id) AS total, p2c.category_id, cd.name, c.parent_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) 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) 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 = '4335' AND p.active = '1' GROUP BY p2c.category_id ORDER BY c.sort_order, cd.name
Called by index in ControllerModuleShopMenuFront
Called by getChild in Controller

SELECT * FROM os38h_category_to_layout WHERE category_id = '17' AND store_id = '0'
Called by getCategoryLayoutId in ModelCatalogCategory
Called by index in ControllerCommonColumnRight

SELECT * FROM os38h_category_to_layout WHERE category_id = '17' AND store_id = '0'
Called by getCategoryLayoutId in ModelCatalogCategory
Called by index in ControllerCommonContentTop

SELECT * FROM os38h_category_to_layout WHERE category_id = '17' AND store_id = '0'
Called by getCategoryLayoutId in ModelCatalogCategory
Called by index in ControllerCommonContentBottom

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 = 4335 AND s.shop_active = 1
Called by getShopFront in ModelShopCustomer
Called by index in ControllerModuleShopSum

SELECT city_id FROM os38h_shops_city WHERE shop_id = 4335
Called by getShopFront in ModelShopCustomer
Called by index in ControllerModuleShopSum

SELECT shop_custom_from, shop_custom_to, shop_day3_from, shop_day3_to, shop_day2_from, shop_day2_to, shop_day4_from, shop_day4_to FROM os38h_shops WHERE shop_id = 4335
Called by isOpenShop in Helper
Called by index in ControllerModuleShopSum

SELECT payment_code FROM os38h_shop_payment WHERE shop_id = 4335
Called by getShopPayment in ModelShopCustomer
Called by index in ControllerModuleShopSum

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' AND c.top = 1 ORDER BY c.parent_id, c.sort_order, cd.name LIMIT 11
Called by index in ControllerCommonHeader
Called by getChild in Controller

SELECT keyword FROM os38h_url_alias WHERE query = 'cityid=1'
Called by index in ControllerCommonHeader
Called by getChild in Controller

Доставка из Бургер Люкс (на Привокзальной), категория салаты. Меню заведения Бургер Люкс (на Привокзальной), акции, скидки.
Не нашли то, что искали? Попробуйте заказать доставку салатов в Гомеле в других заведениях.

Салаты от Бургер Люкс (на Привокзальной)

Сортировать по::
Салат с креветками, Бургер Люкс (на Привокзальной)
Капуста пекинская, томаты, яйцо, мясо креветок, соус чесночный, сыр Пармезан, крутоны.
BYN
8
8 р
180 г
Салат Цезарь, Бургер Люкс (на Привокзальной)
Капуста пекинская, томаты, яйца, грудка отварная, заправка Цезарь, крутоны, сыр Пармезан.
BYN
6
6 р
180 г

Just Eat App

Заказывай через мобильное приложение и получай в 2 раза больше баллов!

Получай
Поделиться пригласительным кодом
Ты тоже можешь поделиться промокодом с друзьями и подарить им бонус 3 руб. для заказа в нашем приложении! И как только они сделают свой первый заказ, мы начислим дополнительный бонус 3 руб. и тебе!
Получай
Поделиться
Поделиться промокодом с друзьями могут только зарегистрированные пользователи
Зарегистрироваться
Вводипромокод и получай бонус 3 руб.
Ввести
Ты тоже можешь поделиться промокодом с друзьями и подарить им бонус 3 руб. для заказа в нашем приложении! И как только они сделают свой первый заказ, мы начислим дополнительный бонус 3 руб. и тебе!