CPU

Hi @knguyen2011,

Did you try performing a conflict test to help you confirm something unique to your site isn’t causing this? I’m recommending this as we’re not seeing other reports of the extension running too many queries and using that amount of CPU resources.

Please give that a try and if it doesn’t help, share your site’s system status report to help us understand your setup and help further.

You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it into your reply.

I tested them all but nothing helped.

SELECT   wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_wc_gla_visibility' )  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )  LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id AND mt2.meta_key = '_wc_gla_errors' )  LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id )  LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) WHERE 1=1  AND ( 
  ( 
    wp_term_relationships.term_taxonomy_id IN (2,4) 
    OR 
    NOT EXISTS (
				SELECT 1
				FROM wp_term_relationships
				INNER JOIN wp_term_taxonomy
				ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
				WHERE wp_term_taxonomy.taxonomy = 'product_type'
				AND wp_term_relationships.object_id = wp_posts.ID
			)
  )
) AND ( 
  ( 
    wp_postmeta.post_id IS NULL 
    OR 
    ( mt1.meta_key = '_wc_gla_visibility' AND mt1.meta_value != 'dont-sync-and-show' )
  ) 
  AND 
  ( 
    mt2.post_id IS NULL 
    OR 
    ( mt3.meta_key = '_wc_gla_errors' AND mt3.meta_value = '' )
  ) 
  AND 
  ( 
    ( mt4.meta_key = '_wc_gla_synced_at' AND mt4.meta_value < '1655288000' )
  )
) AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID  LIMIT 5300, 100

### WordPress Environment ###

WordPress address (URL): https://domain.com
Site address (URL): https://domain.com
WC Version: 6.6.1
REST API Version: ? 6.6.1
WC Blocks Version: ? 7.6.2
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 5 GB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: –

### Server Environment ###

Server Info: nginx/1.22.0
PHP Version: 7.4.30
PHP Post Max Size: 2 GB
PHP Time Limit: 300000
PHP Max Input Vars: 100000
cURL Version: 7.74.0
OpenSSL/1.1.1n

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.8.3-MariaDB-1:10.8.3+maria~bullseye
Max Upload Size: 2 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.6.1
WC Database Prefix: wp_
Total Database Size: 15964.83MB
Database Data Size: 4102.01MB
Database Index Size: 11862.82MB
wp_woocommerce_sessions: Data: 0.14MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 1.52MB + Index: 0.23MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 8.52MB + Index: 9.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 13.52MB + Index: 15.94MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 6.52MB + Index: 5.00MB + Engine InnoDB
wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_automatewoo_abandoned_carts: Data: 0.38MB + Index: 0.08MB + Engine InnoDB
wp_automatewoo_customers: Data: 0.17MB + Index: 0.41MB + Engine InnoDB
wp_automatewoo_customer_meta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_guests: Data: 0.14MB + Index: 0.22MB + Engine InnoDB
wp_automatewoo_guest_meta: Data: 1.52MB + Index: 0.58MB + Engine InnoDB
wp_automatewoo_logs: Data: 1.52MB + Index: 2.34MB + Engine InnoDB
wp_automatewoo_log_meta: Data: 6.52MB + Index: 8.03MB + Engine InnoDB
wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_aws_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aws_index: Data: 971.00MB + Index: 806.00MB + Engine InnoDB
wp_commentmeta: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
wp_comments: Data: 2.52MB + Index: 3.28MB + Engine InnoDB
wp_ebay_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_auctions: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_ebay_categories: Data: 2.52MB + Index: 3.34MB + Engine InnoDB
wp_ebay_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_ebay_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_orders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_shipping: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_sites: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
wp_ebay_stocks_log: Data: 15.52MB + Index: 0.00MB + Engine InnoDB
wp_ebay_store_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ebay_transactions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_giftvouchers_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_giftvouchers_invoice_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_giftvouchers_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_giftvouchers_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_giftvouchers_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
wp_gla_merchant_issues: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
wp_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_iconic_woo_linked_variations: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nextend2_smartslider3_sliders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_field_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 1309.14MB + Index: 3.75MB + Engine InnoDB
wp_oses_attachments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_oses_clicks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_oses_emails: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_oses_email_attachments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_oses_failures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_oses_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pinterest_automatic: Data: 1.50MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 1398.00MB + Index: 10905.95MB + Engine InnoDB
wp_posts: Data: 37.56MB + Index: 23.64MB + Engine InnoDB
wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_analytics_ga: Data: 0.41MB + Index: 1.52MB + Engine InnoDB
wp_rank_math_analytics_gsc: Data: 24.56MB + Index: 40.27MB + Engine InnoDB
wp_rank_math_analytics_inspections: Data: 4.52MB + Index: 0.66MB + Engine InnoDB
wp_rank_math_analytics_keyword_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_analytics_objects: Data: 1.52MB + Index: 0.17MB + Engine InnoDB
wp_rank_math_internal_links: Data: 0.30MB + Index: 0.09MB + Engine InnoDB
wp_rank_math_internal_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_sbi_instagram_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.16MB + Index: 0.31MB + Engine InnoDB
wp_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_term_relationships: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_term_taxonomy: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
wp_usermeta: Data: 2.52MB + Index: 4.55MB + Engine InnoDB
wp_users: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wp_vi_woo_orders_tracking_track_info: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.19MB + Index: 0.13MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.61MB + Engine InnoDB
wp_wc_order_stats: Data: 0.20MB + Index: 0.19MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 3.52MB + Index: 4.52MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 4.52MB + Index: 10.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_pinterest: Data: 1.52MB + Index: 0.44MB + Engine InnoDB
wp_woocommerce_pinterest_boards_mapping: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_pinterest_google_categories_mapping: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_pinterest_google_product_categories: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_product_tags: Data: 1.52MB + Index: 0.89MB + Engine InnoDB
wp_woocommerce_tags: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmelon_advbedit_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rucss_resources: Data: 267.52MB + Index: 4.64MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 12469
aw_workflow: 34
cpt_iconic_wlv: 282
ct_size_guide: 19
custom_css: 1
elementor_font: 4
elementor_library: 3
nav_menu_item: 50
oembed_cache: 3
page: 32
post: 2
product: 1533
product_variation: 33960
shop_coupon: 1116
shop_order: 1725
shop_order_refund: 39
voucher_template: 1
wcpa_pt_forms: 12
whatsapp-accounts: 2
wpcf7_contact_form: 1
wpgv_voucher_product: 1
yith_wcan_preset: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (31) ###

Query Monitor: by John Blackbourn – 3.9.0
WooCommerce Linked Variations by Iconic: by Iconic  – 1.3.0
Contact Form 7: by Takayuki Miyoshi – 5.6
createIT Size Guide Plugin: by createIT – 3.8
Elementor Pro: by Elementor.com – 3.7.0
Elementor: by Elementor.com – 3.6.7
Instant Indexing: by Rank Math – 1.1.16
Stuff for Gecko Theme: by Kevin – 1.0
Google Listings and Ads: by WooCommerce – 2.0.0
Goya Core: by Everthemes – 1.0.6.3
Index WP MySQL For Speed: by Oliver Jones
Rick James – 1.4.4

Kirki Customizer Framework: by David Vongries – 4.0.24
Meta Box: by MetaBox.io – 5.6.4
PixelYourSite PRO: by PixelYourSite – 9.1.1
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Rank Math SEO: by Rank Math – 1.0.92.1
Woocommerce Custom Product Addons: by Acowebs – 4.1.8
Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.3
WooCommerce Stripe Gateway: by WooCommerce – 6.4.3
Advanced Order Export For WooCommerce (Pro): by AlgolPlus – 3.3.1
WooCommerce Orders Tracking Premium: by VillaTheme – 1.0.13
WooCommerce Photo Reviews Premium: by VillaTheme – 1.3.1
Pinterest for WooCommerce: by premmerce – 2.4.3
WOOF - WooCommerce Products Filter: by realmag777 – 2.2.6.4
WooCommerce Table Rate Shipping: by Bolder Elements – 4.2.1
WooCommerce: by Automattic – 6.6.1
WordPress Importer: by wordpressdotorg – 0.7
WP Offload SES: by Delicious Brains – 1.5.6
Related Products for WooCommerce: by WebToffee – 1.4.4
Custom Product Tabs for WooCommerce: by YIKES
Inc. – 1.7.9

YITH WooCommerce Wishlist: by YITH – 3.10.0

### Inactive Plugins (71) ###

Address Autocomplete: by HighAddons – 1.0.3
Advanced Database Cleaner PRO: by Younes JFR. – 3.1.6
Advanced Woo Search PRO: by ILLID – 2.53
AutomateWoo: by WooCommerce – 5.5.9
AutomateWoo - Birthdays Add-on: by WooCommerce – 1.3.4
Classic Editor: by WordPress Contributors – 1.6.2
Customcat Personalization: by Kevin – 1.0
Customizer Export/Import: by The Beaver Builder Team – 0.9.4
Disable Recaptcha - CF7: by Faiyaz Vaid – 1.2
DISABLE WP-Bakery: by Kevin – 1.0
Envato Market: by Envato – 2.0.6
Gift Cards Pro: by codemenschen – 4.1.6
Google Authenticator: by Ivan Kruchkoff – 0.53
Hello Dolly: by Matt Mullenweg – 1.7.2
JanStudio Addons: by JanStudio – 1.3.1
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.7
MetaSlider: by MetaSlider – 3.27.5
Microsoft Clarity: by Microsoft – 0.7.5
Move Email to Top of WooCommerce Checkout: by Caitlin Chou – 1.0
Ninja Forms: by Saturday Drive – 3.6.10
PayPal for WooCommerce: by Angell EYE – 3.0.14
PayPal for WooCommerce: by Angell EYE – 3.0.3
Pin Maker: by WPAddon – 1.0.9
Pinterest for WooCommerce: by WooCommerce – 1.1.0 (update to version 1.2.1 is available)
PixelYourSite Microsoft UET (Bing): by PixelYourSite – 3.0.0
PixelYourSite Pinterest: by PixelYourSite – 4.0.0
PixelYourSite Super Pack: by PixelYourSite – 2.1.7
Prereview: by Elegant Themes – 1.0
Product Catalog Feed Pro by PixelYourSite: by PixelYourSite – 5.2.4
Product Feed PRO for WooCommerce: by AdTribes.io – 11.6.3
Rank Math SEO PRO: by Rank Math – 3.0.15.1
Redis Object Cache: by Till Krüss – 2.0.25
Sale Count: by Kevin – 1.0
SalesGen - Hide Paypal & Stripe: by salesgen.io – 0.3
SalesGen - Upsell Blast for Woocommerce: by salesgen.io – 0.2
Savoy Theme - Content Elements: by NordicMade – 1.5
Savoy Theme - Settings Panel: by NordicMade – 1.0.9
Savoy Theme - Wishlist: by NordicMade – 2.4.2
Sequential Order Numbers for WooCommerce: by WebToffee – 1.4.6
Sequential Order Numbers for WooCommerce Pro: by WebToffee – 1.0.0
Shipping information: by Kevin – 1.0
Shoppable Social Media Galleries by SNPT: by Snapppt – 1.1.11
Smart Slider 3: by Nextend – 3.5.1.7
Smash Balloon Instagram Feed: by Smash Balloon – 6.0.5
Stuff for Claue: by Kevin – 1.0
Tawk.to Live Chat: by Tawkto – 0.7.2
User Role Editor: by Vladimir Garagulya – 4.62
WC Ajax Product Filters: by Shamim Al Mamun – 2.0.3.8
WooCommerce Admin: by WooCommerce – 3.3.2
WooCommerce Advanced Bulk Edit: by George Iron – 5.0.1
WooCommerce API Product Sync with Multiple Stores: by Obtain Infotech – 2.6.1
WooCommerce Custom Indexes: by WooCommerce – 1.0.0
WooCommerce Custom Product Addons (Free): by Acowebs – 2.6.4
WooCommerce Microsoft Ads Conversion Tracking: by Andres de la Garza – 0.1.2
WooCommerce Notification Premium: by Andy Ha (villatheme.com) – 1.4.2.5
WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.14.5
WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.46
WooCommerce Shipment Tracking: by WooCommerce – 1.6.24
WooCommerce TM Extra Product Options: by themeComplete – 5.1
WooCommerce Variation Swatch: by WPAddon – 1.1.6
WooLentor - WooCommerce Elementor Addons + Builder: by HasThemes – 2.3.1
Woo Product Tags: by Kevin Nguyen – 1.5
WPA WooCommerce Product Bundle: by WPAddon – 1.2.6
WPBakery Page Builder: by Michael M - WPBakery.com – 6.9.0
WP Crontrol: by John Blackbourn & crontributors – 1.12.1
WP Rocket: by WP Media – 3.11.2
WP Rocket | Deactivate WooCommerce Refresh Cart Fragments Cache: by WP Rocket Support Team –
WP Rocket | Disable Cache Clearing: by WP Rocket Support Team –
WP Twitter Post: by Qamar Sheeraz – 1.5
YITH WooCommerce Popup: by YITH – 1.16.0
Yoycol: Print on demand: by Yoycol official – 1.2.4

### Dropin Plugins (1) ###

db.php: Query Monitor Database Class (Drop-in)

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #9 - /shop/
Cart: #10 - /cart/
Checkout: #11 - /checkout/
My account: #12 - /my-account/
Terms and conditions: #28 - /terms-of-service/

### Theme ###

Name: Goya Child Theme
Version: 1.0
Author URL: 
Child Theme: ?
Parent Theme Name: Goya
Parent Theme Version: 1.0.7.4
Parent Theme Author URL: https://themeforest.net/user/everthemess
WooCommerce Support: ?

### Templates ###

Overrides: goya/woocommerce/archive-product.php
goya/woocommerce/cart/cart-empty.php
goya/woocommerce/cart/cart-shipping.php
goya/woocommerce/cart/cart.php
goya/woocommerce/cart/mini-cart.php
goya/woocommerce/cart/shipping-calculator.php
goya/woocommerce/checkout/form-checkout.php
goya/woocommerce/checkout/form-coupon.php
goya/woocommerce/checkout/form-login.php
goya/woocommerce/checkout/review-order.php
goya/woocommerce/content-product.php
goya/woocommerce/content-single-product.php
goya/woocommerce/global/form-login.php
goya/woocommerce/global/quantity-input.php
goya/woocommerce/global/wrapper-end.php
goya/woocommerce/global/wrapper-start.php
goya/woocommerce/loop/add-to-cart.php
goya/woocommerce/loop/loop-start.php
goya/woocommerce/loop/pagination.php
goya/woocommerce/myaccount/form-login.php
goya/woocommerce/myaccount/navigation.php
goya/woocommerce/order/tracking.php
goya/woocommerce/product-searchform.php
goya/woocommerce/single-product/photoswipe.php
goya/woocommerce/single-product/related.php
goya/woocommerce/single-product/tabs/tabs.php
goya/woocommerce/single-product/up-sells.php
goya/woocommerce/single-product-reviews.php
goya/woocommerce/content-product_cat.php

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-07-11 08:24:29 +00:00
Options: ?
Notes: 71
Onboarding: completed

### Action Scheduler ###

Canceled: 2
Oldest: 2022-06-23 09:04:40 +0000
Newest: 2022-06-23 09:04:46 +0000

Complete: 17,983
Oldest: 2022-06-09 20:10:45 +0000
Newest: 2022-07-10 10:23:04 +0000

Failed: 7,812
Oldest: 2022-04-18 23:34:07 +0000
Newest: 2022-07-10 10:20:12 +0000

Pending: 831
Oldest: 2022-07-10 10:23:11 +0000
Newest: 2022-07-11 09:44:12 +0000

### Status report information ###

Generated at: 2022-07-10 10:23:30 +00:00

Hello @knguyen2011!

Thanks for getting back to us and for sharing the status report!

MySQL Version: 5.5.5-10.8.3-MariaDB-1:10.8.3+maria~bullseye

As a rule of thumb, it is advised to keep your SQL database version up to date per server requirements listed here: https://woocommerce.com/document/server-requirements/

Additionally, please look for and share with us any fatal errors listed under your page WooCommerce→Status→Logs.

We will be waiting for your update!

Thank you. Based on the link you provided.
MariaDB version 10.1 or greater

Mine is 10.8.3+maria~bullseye. It’s latest version

Hi @knguyen2011,

Thanks for looking that up.
Let’s try another approach.

Backup your site.
Afterwards use https://www.ads-software.com/plugins/index-wp-mysql-for-speed/ to generate a database index.

Does that change anything?

Kind regards,