High CPU consumption because of Woocommerce

Hello,

How are you? Since the past few weeks I’m having serious problems with high CPU consumption on the website. Because of the high CPU consumption, the webshop has been very slow. I did some test, like deactivating all plugins and changing from theme, but only when I activated woocommerce again I get the problem again of high CPU consumption and a slow webshop. We’ve also optimised the webshop, leaving only the plugins that are really essential but the problem continues. Most images in woocommerce are not bigger than 100 kb. The requirements of woocommerce and WordPress are also updated, so we updated the php to 8.1, we set memory limit to 512 etc. All this still did not work. We are using WP Rocket for cache.

We added the Woocommerce report. We really hope that the woocommerce experts can help me, because we don’t know what else to do. Thanks!

 WordPress Environment

WordPress address (URL): https://www.botanicaelgranpoder.nl<br>Site address (URL): https://www.botanicaelgranpoder.nl<br>WC Version: 8.4.0<br>REST API Version: ? 8.4.0<br>WC Blocks Version: ? 11.6.2<br>Action Scheduler Version: ? 3.7.0<br>Log Directory Writable: ?<br>WP Version: 6.4.2<br>WP Multisite: –<br>WP Memory Limit: 256 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: nl_NL<br>External object cache: – Server Environment

Server Info: Apache/2<br>PHP Version: 8.1.24<br>PHP Post Max Size: 32 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 1000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w

SUHOSIN Installed: –<br>MySQL Version: 10.4.27-MariaDB-cll-lve<br>Max Upload Size: 32 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database

WC Database Version: 8.4.0<br>WC Database Prefix: wp_<br>Totale database grootte: 244.99MB<br>Database gegevens grootte: 195.03MB<br>Database index grootte: 49.96MB<br>wp_woocommerce_sessions: Data: 15.02MB + Index: 0.17MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 1.52MB + Index: 0.22MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 5.52MB + Index: 6.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>smackuci_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>smackuci_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_actionscheduler_actions: Data: 2.02MB + Index: 0.92MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 1.05MB + Index: 0.41MB + Engine InnoDB<br>wp_aws_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_aws_index: Data: 10.14MB + Index: 8.13MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 1.52MB + Index: 0.84MB + Engine InnoDB<br>wp_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_duplicator_pro_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_frmt_form_entry: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_frmt_form_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_frmt_form_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_frmt_form_views: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_layerslider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_layerslider_drafts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 105.50MB + Index: 2.63MB + Engine InnoDB<br>wp_postmeta: Data: 35.56MB + Index: 20.06MB + Engine InnoDB<br>wp_posts: Data: 4.52MB + Index: 3.58MB + Engine InnoDB<br>wp_ssa_appointments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_ssa_appointment_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ssa_appointment_types: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_ssa_appointment_type_labels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_ssa_async_actions: Data: 0.41MB + Index: 0.11MB + Engine InnoDB<br>wp_ssa_availability: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wp_ssa_availability_external: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wp_ssa_revisions: Data: 0.05MB + Index: 0.14MB + Engine InnoDB<br>wp_ssa_revision_meta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>wp_termmeta: Data: 1.52MB + Index: 0.11MB + Engine InnoDB<br>wp_terms: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.45MB + Index: 0.25MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.13MB + Index: 0.06MB + Engine InnoDB<br>wp_UPCP_Catalogues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Catalogue_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Custom_Fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Fields_Meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Item_Images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_SubCategories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Tagged_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Tag_Groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_UPCP_Videos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_usermeta: Data: 0.30MB + Index: 0.28MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.50MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.14MB + Index: 0.14MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.48MB + Index: 0.83MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_extra_flat_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woof_query_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpr_rocket_cache: Data: 1.52MB + Index: 1.80MB + Engine InnoDB<br>wp_wpr_rucss_used_css: Data: 4.42MB + Index: 0.98MB + Engine InnoDB Post Type Counts

amn_mi-lite: 1<br>aoc_popup: 1<br>attachment: 6797<br>bne_flyout: 1<br>client-logo: 1<br>custom_css: 4<br>elementor_library: 1<br>forminator_forms: 1<br>kwlogos: 9<br>ml-slide: 5<br>ml-slider: 3<br>nav_menu_item: 62<br>op-set: 1<br>page: 23<br>polylang_mo: 3<br>popup: 9<br>popup_theme: 8<br>portfolio: 1<br>product: 3747<br>sa_slider: 2<br>shipping_validation: 1<br>shop_order: 2048<br>shop_order_refund: 12<br>sidebar: 1<br>sln_attendant: 2<br>sln_service: 3<br>spucpt: 1<br>tcpc: 4<br>thegem_qf_item: 3<br>thegem_templates: 1<br>wp_global_styles: 2<br>wp_navigation: 1<br>wp_template: 2 Security

Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (17)

Advanced Woo Search: door ILLID – 2.95<br>Click to Chat: door HoliThemes – 3.31<br>Elementor: door Elementor.com – 3.18.3<br>Forminator: door WPMU DEV – 1.28.1<br>Google Analytics for WordPress by MonsterInsights: door MonsterInsights – 8.23.1<br>GTranslate: door Translate AI Multilingual Solutions – 3.0.5<br>Mollie Payments for WooCommerce: door Mollie – 7.4.1<br>Piotnet Addons For Elementor: door Piotnet – 2.4.25<br>Really Simple SSL: door Really Simple Plugins – 7.2.1<br>Shortcode in Menus: door Gagan Deep Singh – 3.5.1<br>Simply Schedule Appointments: door N Squared – 1.6.6.1<br>TheGem Theme Elements (for WPBakery): door Codex Themes – 5.9.3<br>Woo Additional Terms: door MyPreview – 1.6.4<br>PDF Invoices & Packing Slips for WooCommerce: door WP Overnight – 3.7.5<br>Woocommerce Products Per Page: door Jeroen Sormani – 1.2.7<br>WooCommerce: door Automattic – 8.4.0<br>WP Rocket: door WP Media – 3.15.6 Inactive Plugins (0) Dropin Plugins (1)

advanced-cache.php: advanced-cache.php Settings

API Enabled: ?<br>Force SSL: –<br>Currency: EUR (€)<br>Currency Position: left<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)

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

Connected to Woo.com: –<br>Enforce Approved Product Download Directories: –<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages

Winkelbasis: #259 - /shop/<br>Winkelwagen: #253 - /winkelmand/<br>Afrekenen: #808 - /checkout/<br>Mijn account: #809 - /my-account/<br>Algemene voorwaarden: #939 - /algemenevoorwaarden/ Theme

Name: TheGem<br>Version: 5.9.3.1<br>Author URL:<br>Child Theme: ? – Als je wijzigingen aanbrengt in WooCommerce of in een hoofdthema dat je niet zelf gebouwd hebt<br>raden we het gebruik van een sub thema aan. Zie: Hoe maak je eensub thema

WooCommerce Support: ? Templates

Archive Template: Je thema heeft een woocommerce.php bestand. Je zult het woocommerce/archive-product.php template niet kunnen overschrijven omdat woocommerce.php prioriteit heeft over archive-product.php. Dit is bedoeld om weergave-problemen te voorkomen.<br>Overrides: thegem/woocommerce/cart/cart-empty.php<br>thegem/woocommerce/cart/cart-shipping.php<br>thegem/woocommerce/cart/cart-totals.php<br>thegem/woocommerce/cart/cart.php<br>thegem/woocommerce/cart/cross-sells.php<br>thegem/woocommerce/cart/mini-cart.php<br>thegem/woocommerce/cart/proceed-to-checkout-button.php<br>thegem/woocommerce/cart/shipping-calculator.php<br>thegem/woocommerce/checkout/form-billing.php<br>thegem/woocommerce/checkout/form-checkout.php<br>thegem/woocommerce/checkout/form-coupon.php<br>thegem/woocommerce/checkout/form-login.php<br>thegem/woocommerce/checkout/form-shipping.php<br>thegem/woocommerce/checkout/payment-method.php<br>thegem/woocommerce/checkout/payment.php<br>thegem/woocommerce/checkout/review-order.php<br>thegem/woocommerce/checkout/terms.php<br>thegem/woocommerce/checkout/thankyou.php<br>thegem/woocommerce/content-product.php<br>thegem/woocommerce/content-single-product.php<br>thegem/woocommerce/content-widget-product.php<br>thegem/woocommerce/global/breadcrumb.php<br>thegem/woocommerce/global/form-login.php<br>thegem/woocommerce/loop/loop-end.php<br>thegem/woocommerce/loop/loop-start.php<br>thegem/woocommerce/loop/orderby.php<br>thegem/woocommerce/loop/pagination.php<br>thegem/woocommerce/loop/price.php<br>thegem/woocommerce/loop/rating.php<br>thegem/woocommerce/loop/result-count.php<br>thegem/woocommerce/loop/sale-flash.php<br>thegem/woocommerce/myaccount/form-edit-account.php<br>thegem/woocommerce/myaccount/form-edit-address.php<br>thegem/woocommerce/myaccount/form-login.php<br>thegem/woocommerce/myaccount/form-lost-password.php<br>thegem/woocommerce/myaccount/form-reset-password.php<br>thegem/woocommerce/myaccount/my-account.php<br>thegem/woocommerce/myaccount/navigation.php<br>thegem/woocommerce/myaccount/orders.php<br>thegem/woocommerce/notices/success.php<br>thegem/woocommerce/order/order-details-customer.php<br>thegem/woocommerce/order/order-details-item.php<br>thegem/woocommerce/order/order-details.php<br>thegem/woocommerce/product-searchform.php<br>thegem/woocommerce/single-product/add-to-cart/external.php<br>thegem/woocommerce/single-product/add-to-cart/grouped.php<br>thegem/woocommerce/single-product/add-to-cart/simple.php<br>thegem/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php<br>thegem/woocommerce/single-product/meta.php<br>thegem/woocommerce/single-product/price.php<br>thegem/woocommerce/single-product/rating.php<br>thegem/woocommerce/single-product/related.php<br>thegem/woocommerce/single-product/review-meta.php<br>thegem/woocommerce/single-product/review.php<br>thegem/woocommerce/single-product/short-description.php<br>thegem/woocommerce/single-product/tabs/description.php<br>thegem/woocommerce/single-product/tabs/tabs.php<br>thegem/woocommerce/single-product/title.php<br>thegem/woocommerce/single-product/up-sells.php<br>thegem/woocommerce/single-product-reviews.php<br>thegem/woocommerce/content-product_cat.php Admin

Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>product-virtual-downloadable<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page

Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-external-affiliate<br>settings<br>async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-12-27 21:03:49 +01:00<br>Options: ?<br>Notes: 196<br>Onboarding: completed Action Scheduler

Afgerond: 2.662<br>Oldest: 2023-11-26 10:22:38 +0100<br>Newest: 2023-12-27 02:01:30 +0100

Mislukt: 6<br>Oldest: 2023-12-20 22:12:38 +0100<br>Newest: 2023-12-23 12:54:18 +0100

In afwachting: 17<br>Oldest: 2023-12-27 02:02:30 +0100<br>Newest: 2023-12-30 13:36:47 +0100 Status report information

Generated at: 2023-12-27 02:01:38 +01:00<br>

The page I need help with: [log in to see the link]