0.0030858517 | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
0.0013818741 | SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='asc_jetcache_settings' |
0.0009219646 | DELETE FROM `oc_session` WHERE `expire` < '2025-08-02 10:37:15' |
0.0008971691 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks' |
0.0008020401 | SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google' |
0.0007829666 | SHOW TABLES LIKE 'oc_ocfilter_setting' |
0.0006461143 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_wishlist' |
0.0006048679 | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '46') ORDER BY tr1.priority ASC |
0.0006020069 | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
0.0004889965 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '') |
0.0004680157 | SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0004429817 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_blog' OR route = 'ru-ru') |
0.0004301071 | SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_prostorecat_blog t0 LEFT JOIN oc_prostorecat_blog t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_prostorecat_blog t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_prostorecat_blog t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_prostorecat_blog t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_prostorecat_blog t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_prostorecat_blog t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_prostorecat_blog t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_prostorecat_blog t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_prostorecat_blog t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '16' |
0.0004150867 | SELECT * FROM oc_ocfilter_setting |
0.0004098415 | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '46') ORDER BY tr1.priority ASC |
0.0003950596 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_compare' |
0.0003931522 | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
0.0003890991 | SELECT DISTINCT * FROM oc_prostore_blog i LEFT JOIN oc_prostore_blog_description id ON (i.blog_id = id.blog_id) LEFT JOIN oc_prostore_blog_to_store i2s ON (i.blog_id = i2s.blog_id) WHERE i.blog_id = '1' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0003859997 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
0.0003819466 | SELECT DISTINCT * FROM oc_prostorecat_blog c LEFT JOIN oc_prostorecat_blog_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_prostorecat_blog_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '16' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
0.0003781319 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0003740788 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru') |
0.0003619194 | SELECT `data` FROM `oc_session` WHERE `session_id` = '9dc51d60f0289e1bb794804c28' AND `expire` > '2025-08-02 10:37:15' |
0.0003550053 | SELECT * FROM oc_prostore_blog_to_layout WHERE blog_id = '1' AND store_id = '0' |
0.0003528595 | SELECT r.comment_id, r.author, r.rating, r.text, p.blog_id, pd.title, r.date_added FROM oc_prostore_blog_comment r LEFT JOIN oc_prostore_blog p ON (r.blog_id = p.blog_id) LEFT JOIN oc_prostore_blog_description pd ON (p.blog_id = pd.blog_id) WHERE p.blog_id = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,20 |
0.0003521442 | SELECT * FROM oc_layout_route WHERE 'extension/module/prostore_blog/getblog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0003390312 | SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '14' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0003359318 | SELECT * FROM oc_currency |
0.0003330708 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
0.0003309250 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_blog' |
0.0003280640 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/language' |
0.0003240108 | SELECT * FROM oc_prostore_blog_related_banners brb LEFT JOIN oc_prostore_blog_banner pbb ON (brb.related_id = pbb.banner_id ) WHERE brb.blog_id = '1' AND pbb.status=1 |
0.0003221035 | SELECT COUNT(*) AS total FROM oc_prostore_blog_comment r LEFT JOIN oc_prostore_blog p ON (r.blog_id = p.blog_id) LEFT JOIN oc_prostore_blog_description pd ON (p.blog_id = pd.blog_id) WHERE p.blog_id = '1' AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' |
0.0003199577 | UPDATE oc_prostore_blog SET viewed = (viewed + 1) WHERE blog_id = '1' |
0.0003159046 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search' |
0.0003139973 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0003130436 | SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' |
0.0003130436 | SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0003118515 | SELECT * FROM oc_layout_route WHERE 'extension/module/prostore_blog/getblog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0003089905 | SELECT * FROM oc_layout_route WHERE 'extension/module/prostore_blog/getblog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0003089905 | SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '7' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0003080368 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru') |
0.0003061295 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0003049374 | SELECT * FROM oc_prostore_blog_to_layout WHERE blog_id = '1' AND store_id = '0' |
0.0003049374 | SELECT * FROM oc_prostore_blog_related pr LEFT JOIN oc_prostore_blog p ON (pr.blog_id = p.blog_id) LEFT JOIN oc_prostore_blog_to_store p2s ON (p.blog_id = p2s.blog_id) WHERE pr.blog_id = '1' AND p.status = '1' AND p2s.store_id = '0' |
0.0003039837 | SELECT * FROM oc_prostore_blog_related_prod pr LEFT JOIN oc_prostore_blog p ON (pr.blog_id = p.blog_id) LEFT JOIN oc_prostore_blog_to_store p2s ON (p.blog_id = p2s.blog_id) WHERE pr.blog_id = '1' AND p.status = '1' AND p2s.store_id = '0' |
0.0003039837 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_blog' OR route = 'ru-ru') |
0.0003030300 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru') |
0.0003030300 | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 60 MINUTE) |
0.0003018379 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/cart' |
0.0002989769 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002970695 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002939701 | SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'column_left' ORDER BY sort_order |
0.0002939701 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru') |
0.0002930164 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002920628 | SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' |
0.0002880096 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency' |
0.0002858639 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/prostoresets' OR route = 'ru-ru') |
0.0002858639 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_5' |
0.0002858639 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback' |
0.0002839565 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru') |
0.0002830029 | SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'content_bottom' ORDER BY sort_order |
0.0002799034 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_left' |
0.0002779961 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002779961 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002779961 | SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' |
0.0002770424 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header' |
0.0002770424 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_blog' OR route = 'ru-ru') |
0.0002758503 | SELECT * FROM oc_extension WHERE `type` = 'total' |
0.0002748966 | SELECT * FROM oc_prostore_blog_tag WHERE language_id = '1' AND blog_id = '1' ORDER BY id ASC |
0.0002741814 | SELECT * FROM oc_layout_route WHERE 'extension/module/prostore_blog/getblog' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
0.0002729893 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_nav_cust' |
0.0002708435 | SELECT category_id FROM oc_prostore_blog_to_category WHERE blog_id = '1' ORDER BY main_category DESC LIMIT 1 |
0.0002689362 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru') |
0.0002679825 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_right' |
0.0002620220 | SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'content_top' ORDER BY sort_order |
0.0002610683 | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR) |
0.0002601147 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru') |
0.0002601147 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/prostore_blog' OR route = 'ru-ru') |
0.0002570152 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_nav_v_drop' |
0.0002529621 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru') |
0.0002479553 | SELECT * FROM oc_layout_module WHERE layout_id = '4' AND position = 'column_right' ORDER BY sort_order |
0.0002470016 | SELECT * FROM oc_prostore_blog_to_layout WHERE blog_id = '1' AND store_id = '0' |
0.0002460480 | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://atlantpro24.ru/' |
0.0002448559 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form' |
0.0002410412 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_bottom' |
0.0002388954 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_top' |
0.0002381802 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002379417 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru') |
0.0002360344 | SELECT * FROM oc_prostore_blog_to_layout WHERE blog_id = '1' AND store_id = '0' |
0.0002319813 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002310276 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru') |
0.0002279282 | DELETE FROM oc_ocfilter_cache WHERE `expire` < '1754131035' |
0.0002269745 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002269745 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru') |
0.0002238750 | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
0.0002229214 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002148151 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9dc51d60f0289e1bb794804c28' |
0.0002000332 | SET time_zone = '+00:00' |
0.0001630783 | SET SQL_BIG_SELECTS = 1 |
0.0001609325 | SET time_zone = '+00:00' |
На прошлой неделе мы рассказывали о том, как в реестре npm обнаружили несколько десятков пакетов, которые воруют данные из переменных окружения
В рамках настоящей публикации, являющейся продолжением предыдущих публикаций, планирую кратко проиллюстрировать, тезис о том, что применение в бизнесе R экосистемы прекрасно вписывается в задачу перехода к цифровой экономике.