SELECT * FROM os38h_url_alias WHERE keyword = '93223-pepsi-0-5l' LIMIT 1
Array ( [url_alias_id] => 944358 [query] => product_id=93223 [keyword] => 93223-pepsi-0-5l )
0.077212

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
Array ( [category_id] => 181 [category_type] => 0 [category_nom] => [category_nom_original] => [image] => [parent_id] => 0 [top] => 0 [no_featured] => 0 [column] => 1 [sort_order] => 0 [sort_order_nom] => 0 [status] => 1 [date_added] => 2018-07-25 08:56:49 [date_modified] => 2020-03-12 16:45:18 [category_alias] => [language_id] => 1 [name] => Скидки [name2] => Акция [description] => [meta_description] => [meta_keyword] => [seo_title] => [seo_h1] => [city_title] => Доставка еды со скидкой в #CITYS#. Еда по акции с доставкой | just-eat.by [city_h1] => Заказать еду с доставкой на дом по акции #CITYS# [city_meta_description] => Заказать еду со скидкой на дом в Just-eat – хорошие цены, широкий выбор, заказ еды онлайн, скидки. [city_meta_keyword] => доставка, акция, еда, скидка [shop_title] => Доставка еды со скидкой из #SHOP#. [shop_h1] => Скидки от #SHOP# [shop_meta_description] => Быстрый и удобный выбор еды со скидкой и доставкой на дом из #SHOP# на Just-eat.by. Акции, бонусы, скидки все это вы найдете на нашем сайте. [shop_meta_keyword] => еда, акция, скидки, #SHOP#, меню, бесплатная доставка )
0.008695

SELECT * FROM os38h_product_prices WHERE product_id = '93223' AND `active` = 1
Array ( )
0.000515

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 = 93223 AND p.status = 1 AND r.status = 1 AND pd.language_id = '1'
Array ( [total] => 0 )
0.000672

SELECT shop_custom_from, shop_custom_to, shop_day7_from, shop_day7_to, shop_day6_from, shop_day6_to, shop_day1_from, shop_day1_to FROM os38h_shops WHERE shop_id = 45964
Array ( [shop_custom_from] => 00:00:00 [shop_custom_to] => 00:00:00 [shop_day7_from] => 11:00:00 [shop_day7_to] => 21:30:00 [shop_day6_from] => 11:00:00 [shop_day6_to] => 21:30:00 [shop_day1_from] => 11:00:00 [shop_day1_to] => 21:30:00 )
0.000367

SELECT * FROM os38h_product_discount WHERE product_id = 93223 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
Array ( )
0.000596

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 = '93223' AND od.language_id = '1' ORDER BY po.product_option_id ASC, o.sort_order
Array ( )
0.000762

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 = '93223' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
Array ( )
0.000383

SELECT eck, belki, zhiri, ugl, srok_hraneniya, usl_hraneniya FROM os38h_product WHERE product_id = 93223
Array ( [eck] => 190 [belki] => 16.7 [zhiri] => 28.6 [ugl] => 19.5 [srok_hraneniya] => 4 часа [usl_hraneniya] => от +2 до +6 °С )
0.00021

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 = '25' AND p.shop_id = 45964 AND p.active = 1 AND p.product_id <> '93223' GROUP BY p.product_id ORDER BY p.sort_order_list DESC, RAND() ASC, LCASE(pd.name) LIMIT 0,4
Array ( [product_id] => 187677 )
0.001211

SELECT * FROM os38h_product_prices WHERE product_id = '187677' AND `active` = 1
Array ( )
0.000241

SELECT * FROM os38h_product_prices WHERE product_id = '187679' AND `active` = 1
Array ( )
0.000216

SELECT * FROM os38h_product_prices WHERE product_id = '93224' AND `active` = 1
Array ( )
0.000218

SELECT * FROM os38h_product_prices WHERE product_id = '93227' AND `active` = 1
Array ( )
0.000204

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 = 45964 AND p.active = 1 GROUP BY p2c.category_id ORDER BY main_sort, p.sort_order, cd.name
Array ( [total] => 43 [category_id] => 81 [name] => Шаурма [parent_id] => 0 [main_sort] => 4 )
0.002661

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 = 45964 AND s.shop_active = 1
Array ( [shop_id] => 45964 [shop_through] => 0 [new_cart] => 0 [isCodeShop] => 0 [is_for_nom] => 0 [id_shop_nom] => [shop_tlgrm_id] => -470390733 [telegram_group_url] => https://t.me/+8_lYJtMC7dw0ZDA1 [shop_viber_id] => [shop_percent1] => 6.00 [shop_percent2] => 25.00 [shop_percent3] => 6.00 [shop_percent_scope_for_filter] => 0.00 [pay_points] => 1 [add_points] => 1 [shop_active] => 1 [shop_name] => ПИТА БАР [shop_search_sinonims] => питабар pita bar pitabar [shop_remote] => 0 [shop_remote_url] => https://vk.com/pitabarbrest [shop_info] => автоматически в телеграм (ЯНДЕКС) (подтверждаем мы) [shop_telephone] => +375297978234 [shop_phone_list] => +375333435566 [shop_email] => mr.sergej87@mail.ru [shop_address] => Брест, ул. Советская, 128 [shop_s_desc] => Стоимость доставки рассчитывается после указания адреса в корзине. [shop_f_desc] => Стоимость доставки рассчитывается после указания адреса в корзине. Доставка еды осуществляется в течение 60-90 минут. В случае поступления большого количества заказов, а также сложной дорожной обстановки или плохих погодных условий время доставки может быть увеличено. Изготовитель продукции: ИП Потапчук Сергей Валерьевич УНП 291430777 г. Брест, ул. Куйбышева, д. 25, кв. 4 [show_sys_info] => 0 [sys_info] => [shop_mail_desc] => [shop_min_price] => 0.00 [shop_time_delivery] => 0 [shop_time_delivery_from] => 60 [shop_time_delivery_to] => 90 [shop_time_delivery_from_custom] => 0 [shop_time_delivery_to_custom] => 0 [shop_time_delivery_set_custom] => 0000-00-00 00:00:00 [shop_pickup] => 0 [shop_pickup_on] => 1 [shop_pickup_list] => Брест, ул. Советская, 128 [shop_pickup_sale] => 0 [shop_pickup_price] => 0.00 [shop_custom_from] => 00:00:00 [shop_custom_to] => 00:00:00 [shop_day1_from] => 11:00:00 [shop_day1_to] => 21:30:00 [shop_day2_from] => 11:00:00 [shop_day2_to] => 21:30:00 [shop_day3_from] => 11:00:00 [shop_day3_to] => 21:30:00 [shop_day4_from] => 11:00:00 [shop_day4_to] => 21:30:00 [shop_day5_from] => 11:00:00 [shop_day5_to] => 21:30:00 [shop_day6_from] => 11:00:00 [shop_day6_to] => 21:30:00 [shop_day7_from] => 11:00:00 [shop_day7_to] => 21:30:00 [shop_price_delivery] => 0.00 [shop_min_delivery_cost] => 0.00 [shop_price_sum_delivery] => 0.00 [shop_logo] => [shop_city] => 2 [shop_start_time] => 00:00:00 [shop_end_time] => 00:00:00 [shop_kitchen] => 82,232 [shop_empty] => 0 [shop_catering] => 0 [shop_order] => 800000 [shop_rating] => 4.09 [shop_woters] => 23 [send_order] => 0 [shop_webpay] => [shop_openbase] => 0 [shop_showcurier] => 0 [shop_show_sku] => 0 [shop_only_card] => 1 [date_added] => 2020-07-08 17:39:05 [app_gen] => 0 [iiko_enable] => 0 [iiko_login] => [iiko_pass] => [iiko_url] => [iiko_tg] => [iiko_send_time] => [iiko_api_key] => [iiko_organization_id] => [frontpad_token] => [frontpad_point] => 0 [gsheet_id] => https://docs.google.com/spreadsheets/d/1S7edu26hM4cNxuUfkzkW4mjvMY6ncB0cvVdpkX645AU/edit?usp=sharing [f_bot] => 1 [shop_bot_recall] => 0 [sys_del] => 0 [last_time] => {"shop_day1_from":"11:00","shop_day2_from":"11:00","shop_day3_from":"11:00","shop_day4_from":"11:00","shop_day5_from":"11:00","shop_day6_from":"11:00","shop_day7_from":"11:00","shop_day1_to":"22:30","shop_day2_to":"22:30","shop_day3_to":"22:30","shop_day4_to":"22:30","shop_day5_to":"22:30","shop_day6_to":"22:30","shop_day7_to":"22:30"} [shop_remove_find] => 0 [shop_promotion] => 0 [shop_promotion_text] => [shop_in_api] => 1 [shop_integration] => 0 [shop_venezia_id] => 0 [shop_barak_id] => 0 [is_for_tempo] => 0 [is_for_dominos] => 0 [is_for_scope] => 0 [other_shops] => [is_promo_shop] => 0 [is_curier_shop] => 1 [admin_position] => 0 [admin_price] => 0.00 [admin_date_end] => [admin_comment] => [call_client] => 0 [shop_delivery_text] => [shop_minus_percent] => 0 [shop_minus_price] => 0.00 [shop_send_order_count] => 0 [shop_min_order_on] => 0 [shop_pickup_min_price] => 0.00 [bepaid_on] => 0 [bepaid_shop_id] => 0 [bepaid_shop_token] => [bepaid_reccurent] => 0 [is_yandex_delivery] => 1 [yandex_address] => Брест, ул. Советская, 128 [yandex_coordinates] => 23.697360,52.084922 [yandex_curier_not_found_cancel] => 0 [alfa_pay] => 1 [alfa_pay_split_enable] => 0 [alfa_duty] => 0.00 [only_phone_order] => 0 [show_yandex_address] => 0 [yandex_time_send] => 20 [show_in_report] => 1 [tmp_shop_checked] => 1 [shop_site_url] => https://pitabar.by/ [shop_instagram_url] => https://www.instagram.com/pitabar_brest/ [shop_instagram_has_our_url] => 0 [shop_note] => 1 января выходной [order_to_entrance] => 0 [yandex_min_sum_for_free_delivery] => 0.00 [yandex_min_delivery_price] => 0.00 [yandex_sum_to_deduction] => 0.00 [yandex_deduction_sum] => 0.00 [shop_google_ads_id] => 144139194857 [alfa_partner_id] => 407 [enable_preorder] => 0 [preorder_days_ahead] => 5 [preorder_min_time] => 120 [ssale_id] => [ssale_text] => )
0.001154

SELECT city_id FROM os38h_shops_city WHERE shop_id = 45964
Array ( [city_id] => 2 )
0.000246

SELECT shop_custom_from, shop_custom_to, shop_day7_from, shop_day7_to, shop_day6_from, shop_day6_to, shop_day1_from, shop_day1_to FROM os38h_shops WHERE shop_id = 45964
Array ( [shop_custom_from] => 00:00:00 [shop_custom_to] => 00:00:00 [shop_day7_from] => 11:00:00 [shop_day7_to] => 21:30:00 [shop_day6_from] => 11:00:00 [shop_day6_to] => 21:30:00 [shop_day1_from] => 11:00:00 [shop_day1_to] => 21:30:00 )
0.000263

SELECT payment_code FROM os38h_shop_payment WHERE shop_id = 45964
Array ( [payment_code] => begateway )
0.000287

SELECT keyword FROM os38h_url_alias WHERE query = 'cityid=1'
Array ( [keyword] => gomel )
0.041202

Доставка Pepsi 0.5л из ПИТА БАР в Бресте | Just-Eat.by

Pepsi 0.5л

4 р

0.5 л

Заказать

Pepsi.

SELECT parent_id FROM os38h_category WHERE category_id = '25'
Array( [parent_id] => 0)
0.000421

Кока-Кола 0.33л

Кока-Кола.

4 р

0.33 л

Заказать

Кока-Кола 0.33л

Кока-Кола.

4 р

0.33 л

Заказать

Спрайт 0.33л

Спрайт.

4 р

0.33 л

Заказать

Спрайт 0.33л

Спрайт.

4 р

0.33 л

Заказать

Mirinda 0.5л

Mirinda.

4 р

0.5 л

Заказать

Mirinda 0.5л

Mirinda.

4 р

0.5 л

Заказать

Aura газированная 0.5л

Aura газированная.

3 р

0.5 л

Заказать

Aura газированная 0.5л

Aura газированная.

3 р

0.5 л

Заказать

Смотрите также доставка напитков в Гомеле в других заведениях

Just Eat App

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

Позже Скачать

Получай

Поделиться пригласительным кодом

Поделиться

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

Получай

Поделиться промокодом с друзьями могут только зарегистрированные пользователи

Зарегистрироваться

Вводипромокод и получай бонус 3 руб.

Ввести