49 jili online casino philippines login.Makakuha ng libreng 700pho sa bawat deposito

Resolved

(@cutu234)

Many customers complain that our webshop is very slow. I couldn’t reproduce it until today. Actually, it is the subpage “Addresses” of the “My Account” page that loads very slowly. It can take 20 – 30 seconds, which is not acceptable. We don’t have this issue on our staging server that uses the same database.

I checked the queries and found out that a specific query causes the problem. This query is not excecuted on the staging server. This is the query:

SELECT posts.ID
FROM wp_posts AS posts
LEFT JOIN wp_postmeta AS meta on posts.ID = meta.post_id
WHERE meta.meta_key = '_customer_user'
AND meta.meta_value = '384130'
AND posts.post_type = 'shop_order'
AND posts.post_status IN ( 'wc-pending','wc-processing','wc-on-hold','wc-completed','wc-cancelled','wc-refunded','wc-failed','wc-checkout-draft' )
ORDER BY posts.ID DESC
LIMIT 1

The staging server uses exactly the same theme and plugins. So, this is very unlikely the problem.

Why is the database queried for shop orders on the addresses page? That doesn’t make sense to me.

Any ideas how to fix this? Please see the status report included in this post.

Thank you!


### WordPress Environment ###

WordPress address (URL): https://www.agoshop.de
Site address (URL): https://www.agoshop.de
WC Version: 9.3.3
Legacy REST API Package Version: Auf dieser Website ist das alte REST-API-Plugin nicht installiert.
Action Scheduler Version: ? 3.8.1
Log Directory Writable: ?
WP Version: 6.6.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: de_DE_formal
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.3.8-nmm1
PHP Post Max Size: 768 MB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 10.5.26-MariaDB-ubu2004-log
Max Upload Size: 768 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 9.3.3
WC Database Prefix: wp_
Datenbank-Gesamtgr??e: 3611.42MB
Datenbank-Datengr??e: 2139.73MB
Datenbank-Indexgr??e: 1471.69MB
wp_woocommerce_sessions: Daten: 2.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Daten: 90.61MB + Index: 30.56MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Daten: 796.98MB + Index: 569.86MB + Engine InnoDB
wp_woocommerce_tax_rates: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Daten: 3.36MB + Index: 10.30MB + Engine InnoDB
wp_actionscheduler_claims: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Daten: 6.28MB + Index: 5.13MB + Engine InnoDB
wp_adtribes_my_conversions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_aepc_custom_audiences: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aepc_logs: Daten: 5.52MB + Index: 0.00MB + Engine InnoDB
wp_aws_index: Daten: 1.52MB + Index: 1.13MB + Engine InnoDB
wp_ayssurvey_answers: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_popup_surveys: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_questions: Daten: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_question_categories: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_sections: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_submissions: Daten: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_submissions_questions: Daten: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_surveys: Daten: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_ayssurvey_survey_categories: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_borlabs_cookie_statistics: Daten: 4.03MB + Index: 4.99MB + Engine MyISAM
wp_bounced_email_logs: Daten: 13.52MB + Index: 0.00MB + Engine InnoDB
wp_cmplz_cookiebanners: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cmplz_cookies: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_cmplz_dnsmpd: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cmplz_services: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cmplz_statistics: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Daten: 11.52MB + Index: 10.03MB + Engine InnoDB
wp_comments: Daten: 130.66MB + Index: 89.25MB + Engine InnoDB
wp_cr_local_forms: Daten: 11.55MB + Index: 1.52MB + Engine InnoDB
wp_cr_reminders_log: Daten: 1.52MB + Index: 1.59MB + Engine InnoDB
wp_dgwt_wcas_index: Daten: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_dgwt_wcas_invindex_cache: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dgwt_wcas_invindex_doclist: Daten: 1.20MB + Index: 0.78MB + Engine InnoDB
wp_dgwt_wcas_invindex_wordlist: Daten: 0.41MB + Index: 0.27MB + Engine InnoDB
wp_dgwt_wcas_stats: Daten: 1.02MB + Index: 0.00MB + Engine InnoDB
wp_dgwt_wcas_tax_index: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_dgwt_wcas_var_index: Daten: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_failed_jobs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_fql_logs: Daten: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_iconic_wssv_index: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_itsec_opaque_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg6_database_475011: Daten: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg6_database_570: Daten: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg6_maps: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_mapsvg6_r2o: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_mapsvg6_regions_475011: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg6_regions_570: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg6_schema: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_mapsvg6_settings: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mapsvg_database_475011: Daten: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg_database_570: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg_r2d: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_mapsvg_regions_475011: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg_regions_570: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mapsvg_schema: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_mclean_refs: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mclean_scan: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mlw_qm_audit_trail: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mlw_questions: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mlw_question_terms: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_mlw_quizzes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mlw_quiz_theme_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mlw_results: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mlw_themes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_newsletter: Daten: 1.52MB + Index: 0.17MB + Engine InnoDB
wp_newsletter_emails: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_newsletter_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_newsletter_sent: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_newsletter_stats: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_newsletter_user_logs: Daten: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_newsletter_user_meta: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Daten: 14.23MB + Index: 2.41MB + Engine InnoDB
wp_postmeta: Daten: 700.98MB + Index: 524.80MB + Engine InnoDB
wp_posts: Daten: 115.59MB + Index: 76.83MB + Engine InnoDB
wp_queue: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_redirection_404: Daten: 4.41MB + Index: 0.63MB + Engine MyISAM
wp_redirection_groups: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_redirection_items: Daten: 0.17MB + Index: 0.13MB + Engine MyISAM
wp_redirection_logs: Daten: 0.48MB + Index: 0.08MB + Engine MyISAM
wp_spbc_auth_logs: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_spbc_backuped_files: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_spbc_backups: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_spbc_firewall_data: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_spbc_firewall_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_spbc_scan_frontend: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_spbc_scan_links_logs: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_spbc_scan_results: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_spbc_scan_signatures: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_spbc_traffic_control_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_storeabill_documentmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_storeabill_documents: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_storeabill_document_attachmentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_storeabill_document_attachments: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_storeabill_document_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_storeabill_document_items: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_storeabill_document_noticemeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_storeabill_document_notices: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_storeabill_journals: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sumo_tbl_user_earned_coupon: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Daten: 0.16MB + Index: 0.06MB + Engine InnoDB
wp_terms: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Daten: 0.36MB + Index: 0.20MB + Engine InnoDB
wp_term_taxonomy: Daten: 0.14MB + Index: 0.05MB + Engine InnoDB
wp_updraftcentral_sitemeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_updraftcentral_sites: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_updraftcentral_site_temporary_keys: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_updraftcentral_user_cron: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Daten: 40.56MB + Index: 30.11MB + Engine InnoDB
wp_users: Daten: 3.52MB + Index: 1.22MB + Engine InnoDB
wp_usin_events: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usin_user_data: Daten: 0.31MB + Index: 0.26MB + Engine MyISAM
wp_wccs_conditions: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wccs_condition_meta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_admin_notes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Daten: 25.55MB + Index: 13.06MB + Engine InnoDB
wp_wc_download_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_gpf_render_cache: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_orders: Daten: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_orders_meta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_addresses: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_coupon_lookup: Daten: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_wc_order_operational_data: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Daten: 29.55MB + Index: 21.06MB + Engine InnoDB
wp_wc_order_stats: Daten: 21.55MB + Index: 13.55MB + Engine InnoDB
wp_wc_order_tax_lookup: Daten: 12.55MB + Index: 10.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_download_directories: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_product_meta_lookup: Daten: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_rate_limits: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_reserved_stock: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wdp_orders: Daten: 0.09MB + Index: 0.04MB + Engine MyISAM
wp_wdp_order_items: Daten: 0.06MB + Index: 0.06MB + Engine MyISAM
wp_wdp_persistent_rules_cache: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wdp_rules: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wdr_order_discounts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wdr_order_item_discounts: Daten: 0.09MB + Index: 0.10MB + Engine MyISAM
wp_wdr_rules: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfblockediplog: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfblocks7: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfconfig: Daten: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_wfcrawlers: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilechanges: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilemods: Daten: 0.27MB + Index: 0.00MB + Engine InnoDB
wp_wfhits: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfhoover: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfissues: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfknownfilelist: Daten: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_wflivetraffichuman: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wflocs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflogins: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wfls_2fa_secrets: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfpendingissues: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfreversecache: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsnipcache: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfstatus: Daten: 5.52MB + Index: 3.03MB + Engine InnoDB
wp_wftrafficrates: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_amazon_buyer_index: Daten: 0.04MB + Index: 0.06MB + Engine MyISAM
wp_woocommerce_gpf_google_taxonomy: Daten: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_gzd_dhl_im_products: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_gzd_dhl_im_product_services: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_gzd_dhl_labelmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_gzd_dhl_labels: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_gzd_packaging: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_gzd_packagingmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_gzd_shipmentmeta: Daten: 32.56MB + Index: 12.03MB + Engine InnoDB
wp_woocommerce_gzd_shipments: Daten: 7.52MB + Index: 4.55MB + Engine InnoDB
wp_woocommerce_gzd_shipment_itemmeta: Daten: 16.55MB + Index: 16.03MB + Engine InnoDB
wp_woocommerce_gzd_shipment_items: Daten: 4.52MB + Index: 7.58MB + Engine InnoDB
wp_woocommerce_gzd_shipment_labelmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_gzd_shipment_labels: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_gzd_shipping_provider: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_gzd_shipping_providermeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wt_iew_action_history: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_mapping_template: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_indexable: Daten: 0.19MB + Index: 0.09MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_prominent_words: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_seo_links: Daten: 0.19MB + Index: 0.14MB + Engine InnoDB
wp_yoast_seo_meta: Daten: 3.52MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_bans: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_elements: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_other_answers: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_polls: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_skins: Daten: 0.28MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_subelements: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_templates: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoppoll_votes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
_blacklist: Daten: 2.52MB + Index: 2.52MB + Engine InnoDB

### Post Type Counts ###

acf-field: 11
acf-field-group: 3
adt_product_feed: 4
attachment: 2051
ays-survey-maker: 8
blocks: 12
boxzilla-box: 1
br_notice: 2
custom_css: 2
customerstory: 1
document_template: 11
eos_dyn_content: 1
gp_elements: 9
invoice: 2
jetpack_migration: 2
kundenstory: 79
mailpoet_page: 1
mapsvg: 2
mc4wp-form: 1
ml-slide: 23
ml-slider: 8
nab_experiment: 7
nav_menu_item: 74
oembed_cache: 25
page: 57
post: 3
product: 91
product_variation: 63
qsm_quiz: 1
revision: 38
schema: 4
shop_coupon: 331
shop_order: 211005
shop_order_refund: 3628
wafs: 1
was: 15
wll_records: 1708
wp-rest-api-log: 2315
wpcf7_contact_form: 3
wpsl_stores: 76
ywrfd-discount: 1

### Security ###

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

### Active Plugins (35) ###

Query Monitor: von John Blackbourn – 3.16.4
Advanced Custom Fields PRO: von WP Engine – 6.3.6
FiboSearch - AJAX Search for WooCommerce (Pro): von FiboSearch Team – 1.28.1
Complianz Privacy Suite (GDPR/CCPA) premium: von Really Simple Plugins – 7.1.4
Confetti: von WP Sunshine – 1.3.7
Contact Form 7: von Takayuki Miyoshi – 5.9.8
Customer Reviews for WooCommerce: von CusRev – 5.60.1
GTM4WP - A Google Tag Manager (GTM) plugin for WordPress: von Thomas Geiger – 1.20.2
GP Premium: von Tom Usborne – 2.5.0
Rechtstexte-Schnittstelle der IT-Recht Kanzlei: von IT-Recht Kanzlei – 1.0.8
Min and Max Quantity for WooCommerce: von BeRocket – 1.3.6
Newsletter: von Stefano Lissa & Das Newsletter Team  – 8.5.2
Permalink Manager for WooCommerce: von BeRocket – 1.0.8.2
Payment Plugins for PayPal WooCommerce: von Payment Plugins
[email protected] – 1.0.52

Redirection: von John Godley – 5.5.0
WooCommerce Show Single Variations by Iconic: von Iconic – 1.22.0
Side Cart WooCommerce: von XootiX – 2.5.4
Survey Maker: von Survey Maker team – 4.9.8
Advanced Editor Tools: von Automattic – 5.9.2
vendidero Helper: von vendidero – 2.2.5
Discount Rules PRO 2.0: von Flycart – 2.6.5
Discount Rules Core: von Flycart – 2.6.6
Product Feed PRO for WooCommerce: von AdTribes.io – 13.3.7
Payment Plugins for Stripe WooCommerce: von Payment Plugins
[email protected] – 3.3.75

WooCommerce Advanced Shipping: von Jeroen Sormani – 1.1.3
WooCommerce Color or Image Variation Swatches: von sysbasics – 4.0.0
WooCommerce Amazon Pay: von Amazon Pay – 2.5.3
Germanized für WooCommerce Pro: von vendidero – 4.1.1
Germanized für WooCommerce: von vendidero – 3.18.2
WooCommerce Price Based on Country: von Oscar Gare – 3.4.9
WooCommerce Sponsor a Friend Plugin: von MB Création – 2.3.2
WooCommerce: von Automattic – 9.3.3
Yoast SEO: von Team Yoast – 23.5
WP Fastest Cache: von Emre Vona – 1.3.1
WP Store Locator: von Tijmen Smit – 2.2.241

### Inactive Plugins (1) ###

Nelio A/B Testing: von Nelio Software – 7.1.0

### Dropin Plugins () ###

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

### Settings ###

Legacy API Enabled: –
Force SSL: ?
Currency: EUR (€)
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-filtered (exclude-from-filtered)
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: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### Logging ###

Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 Tage
Level threshold: –
Log directory size: 88 MB

### WC Pages ###

Shop-Basis: #503048 - /alle-ago-produkte/
Warenkorb: #72 - /warenkorb/ -  Contains the [woocommerce_cart] shortcode
Kasse: #12 - /kasse/ -  Contains the [woocommerce_checkout] shortcode
Ihr Konto: #70 - /mein-konto/
Allgemeine Gesch?ftsbedingungen: #688 - /allgemeine_geschaeftsbedingungen/

### Theme ###

Name: GeneratePress Child Theme
Version: 1.0
Author URL: https://my-blog-shop.de
Child Theme: ?
Parent Theme Name: GeneratePress
Parent Theme Version: 3.5.1
Parent Theme Author URL: https://tomusborne.com
WooCommerce Support: ?

### Templates ###

Overrides: generatepress_child/woocommerce/cart/cart.php
generatepress_child/woocommerce/emails/customer-note.php
generatepress_child/woocommerce/emails/customer-processing-order.php
generatepress_child/woocommerce/single-product/add-to-cart/variation.php

### Geolocation debug info ###

Default customer location: geolocation
MaxMind GeoIP database: ?
MaxMind GeoIP license: ?
MM_COUNTRY_CODE: ?
GEOIP_COUNTRY_CODE: ?
HTTP_CF_IPCOUNTRY: ?
HTTP_X_COUNTRY_CODE: ?
HTTP_X_REAL_IP: ?
HTTP_X_FORWARDED_FOR: ?
REMOTE_ADDR: 46.223.162.17
Real external IP: 2a02:8071:67e1:9220:490:b127:b96c:16df
WCPBC_USE_REMOTE_ADDR: –
Geolocation Test: ?

### PBC Settings ###

Version: 3.4.9
Base location: DE:DE-NW
Base currency: EUR
Price Based On: shipping
Shipping: –
Test mode: –
Test country: –
Load products price in background: –
Prices entered with tax: ?
Calculate tax based on: shipping
Display prices in the shop: incl

### Zone Pricing Drittl?nder ###

zone_id: drittlaender
enabled: yes
name: Drittl?nder
countries: CH
currency: EUR
exchange_rate: 0.840336134454
auto_exchange_rate: no
disable_tax_adjustment: no
order: 9999

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store

Disabled Features: experimental-blocks
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings

Daily Cron: ? Next scheduled: 2024-09-27 10:42:20 +02:00
Options: ?
Notes: 6
Onboarding: completed

### Action Scheduler ###

Abgeschlossen: 8.429
Oldest: 2024-08-27 10:08:30 +0200
Newest: 2024-09-27 09:36:42 +0200

Fehlgeschlagen: 852
Oldest: 2022-04-02 14:42:30 +0200
Newest: 2024-05-19 13:04:37 +0200

Ausstehend: 5
Oldest: 2024-09-27 14:36:48 +0200
Newest: 2024-09-28 07:22:11 +0200

### Status report information ###

Generated at: 2024-09-27 09:59:58 +02:00

This topic was modified 1 month, 3 weeks ago by cutu234.
This topic was modified 1 month, 3 weeks ago by cutu234.

Viewing 7 replies - 1 through 7 (of 7 total)

Thread Starter cutu234
(@cutu234)

1 month, 3 weeks ago

Forgot to copy the function:

WC_Customer_Data_Store->get_last_order()

Thread Starter cutu234
(@cutu234)

1 month, 3 weeks ago

I’ve just found out that we had already switched the test installation to the new high performance mode. Could this be the problem?
Plugin Support Shameem R. a11n
(@shameemreza)

1 month, 3 weeks ago
Hi @cutu234

It could be due to the size of your shop_order post type. Since you have a large number of orders, the query may take a while to execute.

Switching to high performance mode on your test installation could potentially be a problem if all the custom code, theme, or plugins are not compatible with it. High performance mode is designed to improve performance, but if it doesn’t work correctly, it could cause issues.

Additionally, you can install the Fast Woo Order Lookup and Index WP MySQL For Speed plugins, which will help you boost performance.

Furthermore, to troubleshoot the slow query problem, you could try the following:
1. Check your theme and plugins to see where the WC_Customer_Data_Store->get_last_order() function is being used. If possible, try to limit its use on the “Addresses” page.
2. Optimize your database, particularly the shop_order post type. You could use a plugin for this, or consult with a developer if you’re not comfortable doing it yourself.
3. Review your high performance mode settings or try disabling it temporarily to see if it resolves the issue.
Remember to always backup your site before making any changes.

I hope this helps! Let us know if you need further assistance.
Thread Starter cutu234
(@cutu234)

1 month, 3 weeks ago

Hi there,

thank you very much. The Query Monitor screenshot shows that the WC_Customer_Data_Store->get_last_order() is run by Woocommerce. Anyway, it’s not clear to me why this function is executed on the addresses page. There is absolutely no information whatsoever on orders on this page. At 200k orders our shop is not small, but by no means huge. Searching for orders on the order overview page has always been pretty slow. That’s acceptable. However, the addresses page is pretty much the very first page a user sees after creating an account. A loading time of 20 to 30 seconds is therefore a major issue.

We switched to HPOS and will see how it goes.

Plugin Support Shameem R. a11n
(@shameemreza)

1 month, 3 weeks ago

Hi @cutu234

The function WC_Customer_Data_Store->get_last_order() is a part of WooCommerce’s core functions, and it’s used to retrieve the most recent order made by a customer. It’s likely being executed on the Addresses page because some part of your theme or plugins is calling it, even though it might not be necessary on that page.

Even though your shop is not huge, 200k orders are still significant and could potentially slow down the query, as it needs to go through all the orders to find the most recent one.

Switching to High Performance Mode (HPOS) is a good step, but please monitor your website closely as it may cause compatibility issues with certain themes or plugins.

Additionally, I recommend checking your theme and plugins to see where the WC_Customer_Data_Store->get_last_order() function is being used, and if possible, try to limit its use on the Addresses page.

I hope this helps! Please let us know how it goes or if you need further assistance.

Thread Starter cutu234
(@cutu234)

1 month, 3 weeks ago

OK, I checked the theme and all plugins for “get_last_order”. This should find any instances of this function. It is only used by Woocommerce. Anyway, we switched to HPOS, and everything seems to be fine. Performance on the addresses page is back to normal. I’m glad that it worked. However, it’s not the first time that we had really nasty performance issues. I don’t talk about loading times of 2 seconds but rather 20 to 60 seconds that were caused by database queries. I hope, with HPOS this will be a thing of the past. ??

Plugin Support ckadenge (woo-hc)
(@ckadenge)

1 month, 3 weeks ago

Hello @cutu234,

I’m glad to hear that switching to HPOS has resolved your performance issues. WooCommerce is designed to work efficiently with a variety of hosting solutions, and it seems that HPOS is a good fit for your needs.

Also note that WooCommerce is constantly being optimized for better performance. However, it’s important to note that query times can also be affected by your hosting environment, the size of your database, and the configuration of your site.

Please don’t hesitate to reach out if you have any further questions or concerns.

Viewing 7 replies - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.