Slow Query SQL_CALC_FOUND_ROWS

Hi @raniafathy651,

Let’s see if there is an error on the WooCommerce Logs. Kindly provide us the following:

• System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
• Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

Thanks!

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you’re still having the issue

Hello,
i still have slow query issue
And this is system status report

### WordPress Environment ###

WC Version: 5.6.0
REST API Version: ? 5.6.0
WC Blocks Version: ? 5.5.1
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.5.1
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 512 ????????
WP Debug Mode: –
WP Cron: ?
Language: ar
External object cache: ?

### Server Environment ###

Server Info: Apache/2.4.29 (Ubuntu)
PHP Version: 7.4.16
PHP Post Max Size: 100 ????????
PHP Time Limit: 3600
PHP Max Input Vars: 3000
cURL Version: 7.58.0
OpenSSL/1.1.1

SUHOSIN Installed: –
MySQL Version: 8.0.23
Max Upload Size: 50 ????????
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.6.0
WC Database Prefix: bzb_
?????? ??? ????? ????????: 1577.44MB
??? ?????? ????? ????????: 938.42MB
??? ???? ????? ????????: 639.02MB
bzb_woocommerce_sessions: ????????: 30.05 ?.?. + ??????: 1.02 ?.?. + ?????? InnoDB
bzb_woocommerce_api_keys: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_woocommerce_attribute_taxonomies: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_woocommerce_downloadable_product_permissions: ????????: 0.02 ?.?. + ??????: 0.06 ?.?. + ?????? InnoDB
bzb_woocommerce_order_items: ????????: 13.50 ?.?. + ??????: 3.52 ?.?. + ?????? InnoDB
bzb_woocommerce_order_itemmeta: ????????: 89.63 ?.?. + ??????: 68.17 ?.?. + ?????? InnoDB
bzb_woocommerce_tax_rates: ????????: 0.02 ?.?. + ??????: 0.06 ?.?. + ?????? InnoDB
bzb_woocommerce_tax_rate_locations: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_woocommerce_shipping_zones: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_woocommerce_shipping_zone_locations: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_woocommerce_shipping_zone_methods: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_woocommerce_payment_tokens: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_woocommerce_payment_tokenmeta: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_woocommerce_log: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_actionscheduler_actions: ????????: 27.08 ?.?. + ??????: 34.13 ?.?. + ?????? InnoDB
bzb_actionscheduler_claims: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_actionscheduler_groups: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_actionscheduler_logs: ????????: 25.08 ?.?. + ??????: 14.03 ?.?. + ?????? InnoDB
bzb_amazon_settings: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_commentmeta: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_comments: ????????: 48.58 ?.?. + ??????: 33.09 ?.?. + ?????? InnoDB
bzb_email_log: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_icl_content_status: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_icl_core_status: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_icl_flags: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_icl_languages: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_icl_languages_translations: ????????: 0.20 ?.?. + ??????: 0.17 ?.?. + ?????? InnoDB
bzb_icl_locale_map: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_icl_message_status: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_icl_mo_files_domains: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_icl_node: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_icl_reminders: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_icl_string_batches: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_icl_string_packages: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_icl_string_pages: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_icl_string_positions: ????????: 0.44 ?.?. + ??????: 0.17 ?.?. + ?????? InnoDB
bzb_icl_string_status: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_icl_string_translations: ????????: 1.52 ?.?. + ??????: 0.41 ?.?. + ?????? InnoDB
bzb_icl_string_urls: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_icl_strings: ????????: 2.48 ?.?. + ??????: 4.44 ?.?. + ?????? InnoDB
bzb_icl_translate: ????????: 14.39 ?.?. + ??????: 0.11 ?.?. + ?????? InnoDB
bzb_icl_translate_job: ????????: 0.05 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_icl_translation_batches: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_icl_translation_downloads: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_icl_translation_status: ????????: 22.25 ?.?. + ??????: 0.05 ?.?. + ?????? InnoDB
bzb_icl_translations: ????????: 0.28 ?.?. + ??????: 0.64 ?.?. + ?????? InnoDB
bzb_imagify_files: ????????: 0.02 ?.?. + ??????: 0.08 ?.?. + ?????? InnoDB
bzb_imagify_folders: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_links: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_loginizer_logs: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_monsterinsights_pageinsights_cache: ????????: 0.09 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_options: ????????: 7.09 ?.?. + ??????: 0.16 ?.?. + ?????? InnoDB
bzb_postmeta: ????????: 447.94 ?.?. + ??????: 368.53 ?.?. + ?????? InnoDB
bzb_posts: ????????: 82.52 ?.?. + ??????: 23.03 ?.?. + ?????? InnoDB
bzb_term_relationships: ????????: 0.23 ?.?. + ??????: 0.16 ?.?. + ?????? InnoDB
bzb_term_taxonomy: ????????: 0.05 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_termmeta: ????????: 0.06 ?.?. + ??????: 0.06 ?.?. + ?????? InnoDB
bzb_terms: ????????: 0.05 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_usermeta: ????????: 99.61 ?.?. + ??????: 77.14 ?.?. + ?????? InnoDB
bzb_users: ????????: 4.52 ?.?. + ??????: 4.55 ?.?. + ?????? InnoDB
bzb_wc_admin_note_actions: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_wc_admin_notes: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wc_category_lookup: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wc_customer_lookup: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_wc_download_log: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_wc_order_coupon_lookup: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_wc_order_product_lookup: ????????: 0.02 ?.?. + ??????: 0.06 ?.?. + ?????? InnoDB
bzb_wc_order_stats: ????????: 0.02 ?.?. + ??????: 0.05 ?.?. + ?????? InnoDB
bzb_wc_order_tax_lookup: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB
bzb_wc_product_meta_lookup: ????????: 0.17 ?.?. + ??????: 0.31 ?.?. + ?????? InnoDB
bzb_wc_reserved_stock: ????????: 0.14 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wc_tax_rate_classes: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_wc_webhooks: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_wfblockediplog: ????????: 0.09 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wfblocks7: ????????: 0.02 ?.?. + ??????: 0.05 ?.?. + ?????? InnoDB
bzb_wfconfig: ????????: 2.30 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wfcrawlers: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wffilechanges: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wffilemods: ????????: 3.52 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wfhits: ????????: 1.02 ?.?. + ??????: 1.17 ?.?. + ?????? InnoDB
bzb_wfhoover: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_wfissues: ????????: 0.06 ?.?. + ??????: 0.06 ?.?. + ?????? InnoDB
bzb_wfknownfilelist: ????????: 2.52 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wflivetraffichuman: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_wflocs: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wflogins: ????????: 1.02 ?.?. + ??????: 0.16 ?.?. + ?????? InnoDB
bzb_wfls_2fa_secrets: ????????: 0.02 ?.?. + ??????: 0.02 ?.?. + ?????? InnoDB
bzb_wfls_settings: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wfnotifications: ????????: 0.05 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wfpendingissues: ????????: 0.02 ?.?. + ??????: 0.06 ?.?. + ?????? InnoDB
bzb_wfreversecache: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wfsnipcache: ????????: 0.05 ?.?. + ??????: 0.05 ?.?. + ?????? InnoDB
bzb_wfstatus: ????????: 0.13 ?.?. + ??????: 0.09 ?.?. + ?????? InnoDB
bzb_wftrafficrates: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpfront_ure_content_shortcodes: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpfront_ure_login_redirect: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpfront_ure_menu_editor: ????????: 0.11 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpfront_ure_options: ????????: 0.03 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpfront_ure_post_type_permissions: ????????: 0.06 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpgeofence_polygon: ????????: 0.08 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpmailsmtp_debug_events: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpmailsmtp_emails_log: ????????: 8.02 ?.?. + ??????: 2.14 ?.?. + ?????? InnoDB
bzb_wpmailsmtp_tasks_meta: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpr_rucss_resources: ????????: 0.02 ?.?. + ??????: 0.06 ?.?. + ?????? InnoDB
bzb_wpr_rucss_used_css: ????????: 0.02 ?.?. + ??????: 0.05 ?.?. + ?????? InnoDB
bzb_wpvivid_scan_result: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wpvivid_unused_uploads_files: ????????: 0.02 ?.?. + ??????: 0.00 ?.?. + ?????? InnoDB
bzb_wrc_caches: ????????: 0.02 ?.?. + ??????: 0.05 ?.?. + ?????? InnoDB
bzb_wrc_relations: ????????: 0.02 ?.?. + ??????: 0.03 ?.?. + ?????? InnoDB

### Post Type Counts ###

attachment: 1710
custom_css: 1
customize_changeset: 1
ec_woo_ddb_template: 17
frm_form_actions: 6
frm_styles: 1
geofence-maps: 4
nav_menu_item: 185
oembed_cache: 1
page: 44
pickup-maps: 3
portfolio: 8
post: 5
product: 277
product_variation: 816
revision: 88
shop_coupon: 1
shop_order: 69185
shop_order_refund: 49
single-product-rules: 6
swiper_js_slides: 1
team: 4
wapf_product: 5
wc_order_status: 18
wcpa_pt_forms: 1

### Security ###

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

### Active Plugins (53) ###

Query Monitor: ?????? John Blackbourn – 3.7.1
WPML Multilingual CMS: ?????? OnTheGoSystems – 4.4.12
Admin Notices Manager: ?????? WP White Security – 1.2.0
Advanced Database Cleaner PRO: ?????? Younes JFR. – 3.1.6
Advanced Product Fields Pro for WooCommerce: ?????? StudioWombat – 1.8.0
Booster Plus for WooCommerce: ?????? Pluggabl LLC – 5.4.4
Contact Form 7: ?????? Takayuki Miyoshi – 5.4.2
Disable WooCommerce Bloat: ?????? ospiotr – 2.5.1
Disable WP Notification: ?????? Sourabh Agrawal – 2.1.1
Envato Market: ?????? Envato – 2.0.6
Folders Pro: ?????? Premio – 2.7.4
MonsterInsights - eCommerce Addon: ?????? MonsterInsights Team – 7.5.1
MonsterInsights Pro: ?????? MonsterInsights – 7.18.0
Insert Headers and Footers: ?????? WPBeginner – 1.6.0
?????? ??????? WPBakery: ?????? Michael M - WPBakery.com – 6.7.0
LoftLoader Pro: ?????? Loft.Ocean – 2.3.1
Loginizer Security: ?????? Softaculous – 1.6.7
Loginizer: ?????? Softaculous – 1.6.7
MainWP Child: ?????? MainWP – 4.1.7
Metorik Helper: ?????? Metorik – 1.5.1
MonsterInsights - Ads Addon: ?????? MonsterInsights Team – 1.2.0
MonsterInsights - Dimensions Addon: ?????? MonsterInsights Team – 1.3.3
MonsterInsights - Google Optimize Addon: ?????? MonsterInsights Team – 1.3.2
MonsterInsights - Performance Addon: ?????? MonsterInsights Team – 1.5.0
Savoy Theme - Content Elements: ?????? NordicMade – 1.5.2
Savoy Theme - Settings Panel: ?????? NordicMade – 1.0.9
Savoy Theme - Wishlist: ?????? NordicMade – 2.4.2
Object Cache Pro: ?????? Rhubarb Group – 1.13.3
????? ????????: ?????? John Blackbourn & contributors – 1.5.7
White Label CMS: ?????? www.videousermanuals.com – 2.2.3
WooCommerce Bulk Stock Management: ?????? WooCommerce – 2.2.31
WooCommerce Min/Max Quantities: ?????? WooCommerce – 2.4.20
WooCommerce ????? ??????: ?????? OnTheGoSystems – 4.11.6
WooCommerce Order Status Manager: ?????? SkyVerge – 1.13.0
WooCommerce Print Invoices/Packing Lists: ?????? SkyVerge – 3.10.0
WooCommerce Pre-Orders: ?????? WooCommerce – 1.5.29
WooCommerce Sequential Order Numbers Pro: ?????? SkyVerge – 1.17.0
WooCommerce: ?????? Automattic – 5.6.0
Wordfence Security: ?????? Wordfence – 7.5.5
WordPress Importer ???? ??????? ????????: ?????? wordpressdotorg – 0.7
WP Crontrol: ?????? John Blackbourn & crontributors – 1.10.0
WP Mail SMTP Pro: ?????? WPForms – 3.0.2
WP REST Cache: ?????? Acato – 2021.3.0
WP Rocket | Varnish IP: ?????? WP Rocket Support Team –
WP Rocket: ?????? WP Media – 3.9.2
WPFront User Role Editor Personal Pro: ?????? Syam Mohan – 2.14.5
WPML Media: ?????? OnTheGoSystems – 2.6.5
WPML String Translation: ?????? OnTheGoSystems – 3.1.10
WPML Translation Management: ?????? OnTheGoSystems – 2.10.8
WPvivid Plugins Pro: ?????? wpvivid.com – 2.0.23
WPvivid Backup Plugin: ?????? WPvivid Team – 0.9.59
Amazon Payment Service (APS): ?????? WP Experts – 1.0.0
Zain Order Management System: ?????? wpexperts – 1.0.0

### Inactive Plugins (3) ###

Imagify: ?????? WP Media – 1.10
MonsterInsights - Page Insights Addon: ?????? MonsterInsights Team – 1.3.3
WP Engine Automated Migration: ?????? WPEngine – 4.62

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
object-cache.php: Object Cache Pro (Drop-in)

### Must Use Plugins (1) ###

WP REST Cache - Must-Use Plugin: ?????? Richard Korthuis - Acato – 2018.2.1

### Settings ###

API Enabled: –
Force SSL: –
Currency: SAR (SAR)
Currency Position: right_space
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: –

### WC Pages ###

??????: #757 - /en/
?????: #17 - /cart/
????? ?????: #18 - /checkout/
?????: #19 - /my-account/
?????? ????????: #4419 - /en/terms-and-conditions/

### Theme ###

Name: Savoy Child
Version: 1.0
Author URL: https://www.nordicmade.com
Child Theme: ?
Parent Theme Name: Savoy
Parent Theme Version: 2.6.2
Parent Theme Author URL: https://www.nordicmade.com
WooCommerce Support: ?

### Templates ###

Overrides: savoy/woocommerce/archive-product.php
savoy/woocommerce/cart/cart-empty.php
savoy/woocommerce/cart/cart-item-data.php
savoy/woocommerce/cart/cart-shipping.php
savoy/woocommerce/cart/cart-totals.php
savoy/woocommerce/cart/cart.php
savoy/woocommerce/cart/cross-sells.php
savoy/woocommerce/cart/mini-cart.php
savoy/woocommerce/cart/proceed-to-checkout-button.php
savoy/woocommerce/cart/shipping-calculator.php
savoy/woocommerce/checkout/cart-errors.php
savoy/woocommerce/checkout/form-billing.php
savoy/woocommerce/checkout/form-checkout.php
savoy/woocommerce/checkout/form-coupon.php
savoy/woocommerce/checkout/form-login.php
savoy/woocommerce/checkout/form-pay.php
savoy/woocommerce/checkout/form-shipping.php
savoy/woocommerce/checkout/payment-method.php
savoy/woocommerce/checkout/payment.php
savoy/woocommerce/checkout/review-order.php
savoy-child/woocommerce/checkout/terms.php
savoy/woocommerce/checkout/thankyou.php
savoy/woocommerce/content-product.php
savoy/woocommerce/content-single-product.php
savoy/woocommerce/content-widget-price-filter.php
savoy/woocommerce/content-widget-product.php
savoy/woocommerce/content-widget-reviews.php
savoy-child/woocommerce/emails/admin-cancelled-order.php
savoy-child/woocommerce/emails/admin-new-order.php
savoy-child/woocommerce/emails/customer-completed-order.php
savoy-child/woocommerce/emails/customer-invoice.php
savoy-child/woocommerce/emails/customer-new-account.php
savoy-child/woocommerce/emails/customer-note.php
savoy-child/woocommerce/emails/customer-on-hold-order.php
savoy-child/woocommerce/emails/customer-processing-order.php
savoy-child/woocommerce/emails/customer-refunded-order.php
savoy-child/woocommerce/emails/customer-reset-password.php
savoy-child/woocommerce/emails/email-addresses.php ??????? 3.9.0 ???? ???? ??????. ??????? ??????? ?????? ?? 5.6.0
savoy-child/woocommerce/emails/email-downloads.php
savoy-child/woocommerce/emails/email-footer.php
savoy-child/woocommerce/emails/email-header.php
savoy-child/woocommerce/emails/email-order-details.php
savoy-child/woocommerce/emails/email-order-items.php
savoy-child/woocommerce/emails/email-styles.php
savoy/woocommerce/global/breadcrumb.php
savoy-child/woocommerce/global/form-login.php
savoy/woocommerce/global/quantity-input.php
savoy/woocommerce/global/sidebar.php
savoy/woocommerce/global/wrapper-end.php
savoy/woocommerce/global/wrapper-start.php
savoy/woocommerce/loop/add-to-cart.php
savoy/woocommerce/loop/loop-end.php
savoy/woocommerce/loop/loop-start.php
savoy/woocommerce/loop/no-products-found.php
savoy/woocommerce/loop/pagination.php
savoy/woocommerce/loop/price.php
savoy/woocommerce/loop/rating.php
savoy/woocommerce/loop/sale-flash.php
savoy/woocommerce/myaccount/dashboard.php
savoy/woocommerce/myaccount/downloads.php
savoy/woocommerce/myaccount/form-add-payment-method.php
savoy/woocommerce/myaccount/form-edit-account.php
savoy/woocommerce/myaccount/form-edit-address.php
savoy/woocommerce/myaccount/form-login.php
savoy/woocommerce/myaccount/form-lost-password.php
savoy/woocommerce/myaccount/form-reset-password.php
savoy/woocommerce/myaccount/lost-password-confirmation.php
savoy/woocommerce/myaccount/my-account.php
savoy/woocommerce/myaccount/my-address.php
savoy/woocommerce/myaccount/navigation.php
savoy/woocommerce/myaccount/orders.php
savoy/woocommerce/myaccount/payment-methods.php
savoy/woocommerce/myaccount/view-order.php
savoy/woocommerce/notices/error.php
savoy/woocommerce/notices/notice.php
savoy/woocommerce/notices/success.php
savoy/woocommerce/order/form-tracking.php
savoy/woocommerce/order/order-again.php
savoy/woocommerce/order/order-details-customer.php
savoy/woocommerce/order/order-details-item.php
savoy/woocommerce/order/order-details.php
savoy/woocommerce/order/tracking.php
savoy/woocommerce/product-searchform.php
savoy/woocommerce/single-product/add-to-cart/external.php
savoy/woocommerce/single-product/add-to-cart/grouped.php
savoy-child/woocommerce/single-product/add-to-cart/simple.php
savoy/woocommerce/single-product/add-to-cart/variable.php
savoy-child/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
savoy/woocommerce/single-product/add-to-cart/variation.php
savoy/woocommerce/single-product/meta.php
savoy/woocommerce/single-product/photoswipe.php
savoy/woocommerce/single-product/price.php
savoy/woocommerce/single-product/product-attributes.php
savoy/woocommerce/single-product/product-image.php
savoy/woocommerce/single-product/product-thumbnails.php
savoy/woocommerce/single-product/rating.php
savoy/woocommerce/single-product/related.php
savoy/woocommerce/single-product/review-meta.php
savoy/woocommerce/single-product/review-rating.php
savoy/woocommerce/single-product/review.php
savoy/woocommerce/single-product/sale-flash.php
savoy/woocommerce/single-product/share.php
savoy/woocommerce/single-product/short-description.php
savoy/woocommerce/single-product/stock.php
savoy/woocommerce/single-product/tabs/additional-information.php
savoy/woocommerce/single-product/tabs/description.php
savoy/woocommerce/single-product/tabs/tabs.php
savoy/woocommerce/single-product/title.php
savoy/woocommerce/single-product/up-sells.php
savoy/woocommerce/single-product-reviews.php
savoy/woocommerce/single-product.php
savoy/woocommerce/taxonomy-product-cat.php
savoy/woocommerce/taxonomy-product-tag.php
savoy/woocommerce/content-product_cat.php

Outdated Templates: ?
					
					
						???? ????? ???????

### Action Scheduler ###

(??????): 93?802
Oldest: 2021-08-21 10:41:17 +0000
Newest: 2021-09-21 10:41:05 +0000

???: 1
Oldest: –
Newest: –

?????: 4
Oldest: 2021-09-22 01:53:22 +0000
Newest: 2021-09-27 11:03:22 +0000

### Status report information ###

Generated at: 2021-09-21 13:42:08 +03:00

Best regards

Hi again!

Thank you for the system status record. The shop you are running is counting almost 70 000 orders – shop_order: 69185 to be precise. Your problem seems to be sheer size ;).

At this point I would say this is less a slow query problem and more of a scaling problem and you should consider a dedicated database server (i.e. https://spinupwp.com/scaling-wordpress-dedicated-database-server/) or a more powerful hosting package.

How much are you paying currently for hosting per month?

Kind regards,

Hello,
We already use dedicated Database, check our server DB configuration here:
https://drive.google.com/file/d/13fMHuxLMwOjYyF99-HOp-olRQXBjFhFo/view?usp=sharing

Also Our Server Specs :

RAM: 32 GB
CPU : 3.10GHz
CORE : 8
Storage : 300 GB`

Lind Regards

Hi @raniafathy651,

Thanks for sharing your server specs with us.

For now, I’d suggest updating all your plugins, including WooCommerce and Woocommerce DB to their latest versions. Did you also try conflict testing to figure out if one or more of your plugins may be causing that slow query? If not, please follow our conflict testing guide here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/.

Lastly, as earlier requested, please share any fatal error logs you may find under WooCommerce > System Status > Logs.

Thanks.