{"id":15879833,"date":"2022-08-02T06:35:44","date_gmt":"2022-08-02T06:35:44","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/woocommerce-backend-slow-after-update\/"},"modified":"2022-08-02T06:35:44","modified_gmt":"2022-08-02T06:35:44","slug":"woocommerce-backend-slow-after-update","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/woocommerce-backend-slow-after-update\/","title":{"rendered":"Woocommerce backend slow after update"},"content":{"rendered":"

I updated Woocommerce to the latest version and when I am trying to open any page in the back end of Woocommerce tab it loads really slowly around 15 seconds.<\/p>\n

Everything except Woocommerce loads fine. Even products on the front end load fine.<\/p>\n

I installed Query Monitor
\nand I see that there are 4 repeating slow Queries.<\/p>\n

Query:<\/p>\n

SELECT wp_posts.ID\nFROM wp_posts\nLEFT JOIN wp_term_relationships\nON (wp_posts.ID = wp_term_relationships.object_id)\nINNER JOIN wp_postmeta\nON ( wp_posts.ID = wp_postmeta.post_id )\nWHERE 1=1\nAND ( wp_term_relationships.term_taxonomy_id IN (2,3,4,5) )\nAND ( ( wp_postmeta.meta_key = '_virtual'\nAND wp_postmeta.meta_value = 'no' ) )\nAND wp_posts.post_type = 'product'\nAND ((wp_posts.post_status = 'publish'\nOR wp_posts.post_status = 'draft'\nOR wp_posts.post_status = 'pending'\nOR wp_posts.post_status = 'private'))\nGROUP BY wp_posts.ID\nORDER BY wp_posts.post_date DESC\nLIMIT 0, 1<\/code><\/pre>\n
Caller:<\/p>\n
WP_Query->get_posts()\nwp-includes\/class-wp-query.php:3129\nWP_Query->query()\nwp-includes\/class-wp-query.php:3586\nWP_Query->__construct()\nwp-includes\/class-wp-query.php:3718\nWC_Product_Data_Store_CPT->query()\nwp-content\/plugins\/woocommerce\/includes\/data-stores\/class-wc-product-data-store-cpt.php:2042\nWC_Data_Store->__call()\nwp-content\/plugins\/woocommerce\/includes\/class-wc-data-store.php:207\nWC_Product_Query->get_products()\nwp-content\/plugins\/woocommerce\/includes\/class-wc-product-query.php:76\nwc_get_products()\nwp-content\/plugins\/woocommerce\/includes\/wc-product-functions.php:48\nAutomattic\\W\\A\\F\\O\\T\\Shipping::has_physical_products()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/Tasks\/Shipping.php:114\nAutomattic\\W\\A\\F\\O\\T\\Shipping->can_view()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/Tasks\/Shipping.php:78\nAutomattic\\W\\A\\F\\O\\TaskList->Automattic\\W\\A\\F\\O\\{closure}()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/TaskList.php:299\narray_filter()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/TaskList.php:299\nAutomattic\\W\\A\\F\\O\\TaskList->get_viewable_tasks()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/TaskList.php:300\nAutomattic\\W\\A\\F\\O\\TaskList->is_visible()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/TaskList.php:174\nAutomattic\\W\\A\\F\\O\\TaskLists::Automattic\\W\\A\\F\\O\\{closure}()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/TaskLists.php:414\narray_filter()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/TaskLists.php:414\nAutomattic\\W\\A\\F\\O\\TaskLists::get_visible()\nwp-content\/plugins\/woocommerce\/src\/Admin\/Features\/OnboardingTasks\/TaskLists.php:415\nAutomattic\\W\\I\\A\\O\\OnboardingSetupWizard->component_settings()\nwp-content\/plugins\/woocommerce\/src\/Internal\/Admin\/Onboarding\/OnboardingSetupWizard.php:218\napply_filters('woocommerce_admin_shared_settings')\nwp-includes\/plugin.php:191\nAutomattic\\W\\I\\A\\WCAdminSharedSettings->Automattic\\W\\I\\A\\{closure}()\nwp-content\/plugins\/woocommerce\/src\/Internal\/Admin\/WCAdminSharedSettings.php:61\nAutomattic\\W\\B\\A\\AssetDataRegistry->execute_lazy_data()\nwp-content\/plugins\/woocommerce\/packages\/woocommerce-blocks\/src\/Assets\/AssetDataRegistry.php:258\nAutomattic\\W\\B\\A\\AssetDataRegistry->enqueue_asset_data()\nwp-content\/plugins\/woocommerce\/packages\/woocommerce-blocks\/src\/Assets\/AssetDataRegistry.php:359\ndo_action('admin_print_footer_scripts')\nwp-includes\/plugin.php:476<\/code><\/pre>\n
Component:
\nPlugin: woocommerce<\/p>\n
Time:
\n3.0393<\/p>\n
There are no fatal errors in the logs.<\/p>\n
I tried turning off other plugins that are related to Woocomerce, and also tried to reactivate Woocommerce.<\/p>\n
I need to fix it fast as it prevents my product’s stock from updating.<\/p>\n","protected":false},"template":"","class_list":["post-15879833","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15879833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15879833\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=15879833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}