SELECT * FROM os38h_url_alias WHERE keyword = '162926-promokod-na-500r' LIMIT 1
Array
(
[url_alias_id] => 582050
[query] => product_id=162926
[keyword] => 162926-promokod-na-500r
)
0.019559
SELECT category_id FROM os38h_product_to_category WHERE product_id = '162926' ORDER BY main_category DESC LIMIT 1
Array
(
[category_id] => 240
)
0.002148
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.008959
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 = 162926 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 = '162926' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
Array
(
)
0.002926
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 = '87828'
Array
(
[shop_id] => 87828
[shop_through] => 0
[new_cart] => 0
[isCodeShop] => 1
[is_for_nom] => 0
[id_shop_nom] =>
[shop_tlgrm_id] => -783646479
[telegram_group_url] =>
[shop_viber_id] =>
[shop_percent1] => 10.00
[shop_percent2] => 30.00
[shop_percent3] => 10.00
[shop_percent_scope_for_filter] => 0.00
[pay_points] => 1
[add_points] => 1
[shop_active] => 0
[shop_name] => Магазин Промокодов
[shop_search_sinonims] =>
[shop_remote] => 0
[shop_remote_url] =>
[shop_info] => РОБОТ
[shop_telephone] => 12345678
[shop_phone_list] =>
[shop_email] => fdjhgjhjkhsdfhj@mail.ru
[shop_address] => Минск
[shop_s_desc] => Тут можно приобрести подарочные промокоды!
[shop_f_desc] => Тут можно приобрести подарочные промокоды!
[show_sys_info] => 0
[sys_info] =>
[shop_mail_desc] =>
[shop_min_price] => 0.00
[shop_time_delivery] => 0
[shop_time_delivery_from] => 5
[shop_time_delivery_to] => 10
[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] => 0
[shop_pickup_list] =>
[shop_pickup_sale] => 0
[shop_pickup_price] => 0.00
[shop_custom_from] => 00:00:00
[shop_custom_to] => 00:00:00
[shop_day1_from] => 09:00:00
[shop_day1_to] => 23:00:00
[shop_day2_from] => 09:00:00
[shop_day2_to] => 23:00:00
[shop_day3_from] => 09:00:00
[shop_day3_to] => 23:00:00
[shop_day4_from] => 09:00:00
[shop_day4_to] => 23:00:00
[shop_day5_from] => 09:00:00
[shop_day5_to] => 23:00:00
[shop_day6_from] => 09:00:00
[shop_day6_to] => 23:00:00
[shop_day7_from] => 09:00:00
[shop_day7_to] => 23:00:00
[shop_price_delivery] => 0.00
[shop_min_delivery_cost] => 0.00
[shop_price_sum_delivery] => 0.00
[shop_logo] =>
[shop_city] => 17
[shop_start_time] => 00:00:00
[shop_end_time] => 00:00:00
[shop_kitchen] =>
[shop_empty] => 0
[shop_catering] => 0
[shop_order] => 99999999
[shop_rating] => 5.00
[shop_woters] => 5
[send_order] => 0
[shop_webpay] =>
[shop_openbase] => 0
[shop_showcurier] => 0
[shop_show_sku] => 0
[shop_only_card] => 0
[date_added] => 2021-11-01 18:15:52
[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] =>
[f_bot] => 1
[shop_bot_recall] => 0
[sys_del] => 0
[last_time] => {"shop_day1_from":"09:00","shop_day2_from":"09:00","shop_day3_from":"09:00","shop_day4_from":"09:00","shop_day5_from":"09:00","shop_day6_from":"09:00","shop_day7_from":"09:00","shop_day1_to":"09:00","shop_day2_to":"09:00","shop_day3_to":"09:00","shop_day4_to":"09:00","shop_day5_to":"09:00","shop_day6_to":"09:00","shop_day7_to":"09:00"}
[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] => 1
[is_curier_shop] => 0
[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] => 0
[yandex_address] => Минск, ул. Ленина, 1
[yandex_coordinates] => 27.557088,53.902570
[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] => 0
[shop_site_url] =>
[shop_instagram_url] =>
[shop_instagram_has_our_url] => 0
[shop_note] =>
[order_to_entrance] => 0
[yandex_min_sum_for_free_delivery] => 60.00
[yandex_min_delivery_price] => 3.00
[yandex_sum_to_deduction] => 0.00
[yandex_deduction_sum] => 0.00
[shop_google_ads_id] =>
[alfa_partner_id] =>
[enable_preorder] => 0
[preorder_days_ahead] => 5
[preorder_min_time] => 120
[ssale_id] =>
[ssale_text] =>
)
0.000762
SELECT city_id FROM os38h_shops_city WHERE shop_id = '87828'
Array
(
[city_id] => 17
)
0.000297