• Resolved szaybus

    (@szaybus)


    Hello

    I have a problem with the plugin. On the main page of a woocommerce store the plugin makes ~290 identical queries to wp_options:

    SELECT option_name, option_value
    FROM wp_options
    WHERE autoload = ‘yes’

    Caller list for the query is:

    wp_load_alloptions()
    update_option()
    WP_Object_Cache->_transient_set()
    WP_Object_Cache->set()
    wp_cache_set()
    set_transient()
    WCCS_Product_Price_Cache->get_price()
    WCCS_Product_Price_Replace->replace()
    WCCS_Product_Price_Replace->replace_sale_price()
    WCCS_Product_Price_Replace->get_replaced_sale_price()
    WCCS_Product_Price_Replace->replace_variation_prices()
    apply_filters(‘woocommerce_variation_prices’)
    WC_Product_Variable_Data_Store_CPT->read_price_data()
    WC_Data_Store->__call()
    WC_Product_Variable->get_variation_prices()
    WC_Product_Variable->is_on_sale()

    The problem makes the home page load time jump to 30 seconds…

    This also sometimes happen on category pages but updating the plugin and clearing the cache seems to fix the issue for those pages.

    Please advise

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author AsanaPlugins

    (@asanaplugins)

    Hi @szaybus

    Thank you for using our plugin.

    We apologize for the inconvenience.

    It seems that you are using the plugin pro version. Please use our website support to get support for the plugin pro version and do not use WordPress Forums which is for the free version.

    Please create a support ticket on our website and send us the below information to let us check it.
    – Your license key.
    – A full-page screenshot of your created rule. especially the simple pricing rules on your site.
    – A link to your site to let us test as you are done.
    – Error messages and logs.

    Best Regards

    Thread Starter szaybus

    (@szaybus)

    @asanaplugins

    I tried – your contact form is broken – “There was an error trying to send your message. Please try again later.”

    Plugin Author AsanaPlugins

    (@asanaplugins)

    @szaybus

    If you have an issue with our support form you can contact us via support@asanaplugins.com or asanaplugins@gmail.com and send us the information that we requested in the previous message.

    Best Regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Spamming SQL query’ is closed to new replies.