Обычная консультация по запросу SQL - OpenCart 2.1
6 USDДобрый день уважаемые!
Нужна консультация по данном запросу:
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON
(p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE
pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
Данный запрос сильно нагружает систему OpenCart 2.1.0.1, нужна помощь по том как его отключить/исправить/ и что вообще данный запрос делает.
А так же какие манипуляции/действия на сайте его вызывают (по возможности если знаете)
+250 грн будет так же за методы решения данной проблемы, если сможете помочь.
-
А так же какие манипуляции/действия на сайте его вызывают (по возможности если знаете)
Похоже, это подсчет количества всех включенных товаров у которых настало время публикации и статус включено.
-
Current freelance projects in the category Databases & SQL
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 3 hours 40 minutes back ∙ 24 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 7 hours 2 minutes back ∙ 6 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 2 days 4 hours back ∙ 6 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 2 days 19 hours back ∙ 8 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 7 days 19 hours back ∙ 12 proposals |
Kyiv