SELECT * FROM os38h_url_alias WHERE keyword = '194781-roll-kuba-gril-s'
Called by __construct in Position
Called by

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

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 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 = 194781 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 = '194781' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
Called by getProduct in ModelCatalogProduct
Called by index in ControllerProductProduct

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

SELECT COUNT(*) AS total FROM os38h_review r LEFT JOIN os38h_product p ON (r.product_id = p.product_id) LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = 194781 AND p.status = 1 AND r.status = 1 AND pd.language_id = '1'
Called by getTotalReviewsByProductId in ModelCatalogReview
Called by index in ControllerProductProduct

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 = 45109
Called by isOpenShop in Helper
Called by index in ControllerProductProduct

SELECT * FROM os38h_product_discount WHERE product_id = 194781 AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity, priority, price
Called by getProductDiscounts in ModelCatalogProduct
Called by index in ControllerProductProduct

SELECT * FROM os38h_product_option po LEFT JOIN `os38h_option` o ON (po.option_id = o.option_id) LEFT JOIN os38h_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '194781' AND od.language_id = '1' ORDER BY po.product_option_id ASC, o.sort_order
Called by getProductOptions in ModelCatalogProduct
Called by index in ControllerProductProduct

SELECT ag.attribute_group_id, agd.name FROM os38h_product_attribute pa LEFT JOIN os38h_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN os38h_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN os38h_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '194781' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
Called by getProductAttributes in ModelCatalogProduct
Called by index in ControllerProductProduct

SELECT eck, belki, zhiri, ugl, srok_hraneniya, usl_hraneniya FROM os38h_product WHERE product_id = '194781'
Called by index in ControllerProductProduct
Called by call_user_func_array

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 = '97' AND p.shop_id = 45109 AND p.active = 1 AND p.product_id <> '194781' GROUP BY p.product_id ORDER BY p.sort_order_list DESC, RAND() ASC, LCASE(pd.name) LIMIT 0,4
Called by getProducts in ModelCatalogProduct
Called by index in ControllerProductProduct

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 = 194808 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 = '194808' 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 = '194808' AND `active` = 1
Called by getSpecialPrice in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT * FROM os38h_product_time_available WHERE product_id = 194808
Called by getProductTimeAvailable in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT day_id FROM os38h_product_available WHERE product_id = '194808'
Called by getProductDays 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 = 194780 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 = '194780' 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 = '194780' AND `active` = 1
Called by getSpecialPrice in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT * FROM os38h_product_time_available WHERE product_id = 194780
Called by getProductTimeAvailable in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT day_id FROM os38h_product_available WHERE product_id = '194780'
Called by getProductDays 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 = 194786 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 = '194786' 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 = '194786' 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 = 194787 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 = '194787' 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 = '194787' AND `active` = 1
Called by getSpecialPrice in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT * FROM os38h_product_time_available WHERE product_id = 194787
Called by getProductTimeAvailable in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT day_id FROM os38h_product_available WHERE product_id = '194787'
Called by getProductDays in ModelCatalogProduct
Called by getProduct in ModelCatalogProduct

SELECT category_id FROM os38h_product_to_category WHERE product_id = '194808' 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 = '194780' 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 = '194786' 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 = '194787' ORDER BY main_category DESC LIMIT 1
Called by getPathByProduct in ControllerCommonSeoPro
Called by rewrite in ControllerCommonSeoPro

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 = '45109' 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 COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.shop_id = '45109' AND p.active = '1' AND p.price_spec = '1'
Called by getTotalProducts in ModelCatalogProduct
Called by index in ControllerModuleShopMenuFront

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 = 45109 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 = 45109
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 = 45109
Called by isOpenShop in Helper
Called by index in ControllerModuleShopSum

SELECT * FROM os38h_shop_map WHERE shop_id = 45109
Called by getMap in ModelShopCustomer
Called by index in ControllerModuleShopSum

SELECT * FROM os38h_shop_map_area WHERE map_id =''
Called by getMap in ModelShopCustomer
Called by index in ControllerModuleShopSum

SELECT payment_code FROM os38h_shop_payment WHERE shop_id = 45109
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

Доставка Ролл Куба гриль S из Суши Дом - Браслав в Браславе | Just-Eat.by
Заказать Ролл Куба гриль S, Суши Дом - Браслав

Ролл Куба гриль S

9.99 р
200 г
Рис, нори, кальмар, сыр, манго, лён, запечённая сырная шапка.
SELECT parent_id FROM os38h_category WHERE category_id = '97'
Called by require
Called by render in Controller

Ролл Фин гриль M, Суши Дом - Браслав
Рис, нори, тунец, сыр, омлет тамаго, запечённая сырная шапка.
14.99 р
270 г
Ролл Куба гриль M, Суши Дом - Браслав
Рис, нори, кальмар, сыр, манго, лён, запечённая сырная шапка.
14.99 р
270 г
Ролл Медея гриль M, Суши Дом - Браслав
Рис, нори, мидии, сыр, огурец, запечённая сырная шапка.
14.99 р
270 г
Ролл Медея гриль S, Суши Дом - Браслав
Рис, нори, мидии, сыр, огурец, запечённая сырная шапка.
9.99 р
200 г

Just Eat App

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

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