add to cart slow problem

  • rebrush2

    (@rebrush2)


    3 years ago

    Hello, thank you for making a WordPress!
    my site is
    https://rebrush.co.kr

    I have an issue.
    Currently, if I press a button such as ‘add to cart’, ‘buy now button’,
    it appears that it takes more than 5 seconds.

    I was wondering how to solve this problem.
    thank you.

    screenshot attached
    https://ibb.co/rm1jyqd

    video attached

    https://vimeo.com/640205630
    https://vimeo.com/640205700

    Plus,
    To see plug-in problems, I’ve attached the delays time table when I turn on the plug-ins one by one.
    https://ibb.co/ccNYP78

    I tried the following methods to fix the problem, but failed.
    1. Test by turning off all plugins one by one – Same issue occurs even after uninstalling other plugins
    2. Request to increase the memory of the server – The same issue occurs even after increasing the memory
    3. Delete plugin to remove unnecessary HTTP/S
    4. Implement caching, image optimization, etc. – using Wprocket, etc.
    5. Remove unnecessary DB – use WP sweep, etc.`

    And the server company responded as follows.
    But I don’t know how to solve this problem.
    Seeking advice from smart developers.

    ———–server company answer———-

    When you click Add to Cart, it takes about 3 to 9 seconds.
There is a part where the CPU usage rate of the ps increases during processing, 
and there is a part where the memory usage rate also increases rapidly.

Separately, I checked where the delay section is on the server, and when requesting a shopping cart

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE t. .object_id IN (2138) ORDER BY t.name ASC

It requests the same query about 1800 times, 
and most of the delay time is wasted in processing the query.


    Taxonomies
    

A state in which response delay occurs in the process of processing related search terms or classification definitions

    —status—

    
### WordPress Environment ###

WordPress address (URL): https://rebrush.co.kr
Site address (URL): https://rebrush.co.kr
WC Version: 5.8.0
REST API Version: ? 5.8.0
WC Blocks Version: ? 5.9.1
Action Scheduler Version: ? 3.3.0
WC Admin Version: ? 2.7.2
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: ko_KR
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.1p1
PHP Post Max Size: 21 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.29.0
NSS/3.19.1 Basic ECC

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

### Database ###

WC Database Version: 5.8.0
WC Database Prefix: wp_
Total Database Size: 96.66MB
Database Data Size: 73.93MB
Database Index Size: 22.73MB
wp_woocommerce_sessions: Data: 0.17MB + 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: 0.30MB + Index: 0.11MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 3.52MB + Index: 3.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: 1.48MB + Index: 1.14MB + 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: 1.52MB + Index: 0.52MB + Engine InnoDB
wp_commentmeta: Data: 0.16MB + Index: 0.17MB + Engine InnoDB
wp_comments: Data: 2.52MB + Index: 1.11MB + Engine InnoDB
wp_cosmosfarm_members_activity_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cosmosfarm_members_login_history: 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_kboard_board_attached: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_kboard_board_content: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_kboard_board_latestview: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_kboard_board_latestview_link: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_kboard_board_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_kboard_board_option: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_kboard_board_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_kboard_comments: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_kboard_comments_option: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_kboard_meida: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_kboard_meida_relationships: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_kboard_order_item: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_kboard_order_item_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_kboard_vote: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mlw_qm_audit_trail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mlw_questions: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_mlw_question_terms: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_mlw_quizzes: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
wp_mlw_quiz_theme_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mlw_results: Data: 28.52MB + Index: 0.00MB + Engine InnoDB
wp_mlw_themes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mshop_ep_log: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 4.50MB + Index: 0.33MB + Engine InnoDB
wp_postmeta: Data: 11.52MB + Index: 8.03MB + Engine InnoDB
wp_posts: Data: 2.52MB + Index: 0.52MB + Engine InnoDB
wp_pum_subscribers: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_rsgiftvoucher: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rspointexpiry: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_rsrecordpoints: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
wp_rs_expiredpoints_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rs_templates_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sumo_reward_encashing_submitted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sumo_reward_send_point_submitted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 4.52MB + Index: 3.03MB + Engine InnoDB
wp_users: Data: 0.16MB + Index: 0.19MB + Engine InnoDB
wp_wcs_payment_retries: Data: 0.05MB + Index: 0.02MB + 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.13MB + Index: 0.13MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.22MB + Index: 0.25MB + Engine InnoDB
wp_wc_order_stats: Data: 0.19MB + Index: 0.19MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + 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_wpr_rucss_resources: Data: 5.52MB + Index: 0.09MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.38MB + Index: 0.05MB + Engine InnoDB
wp_yith_wapo_addons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wapo_blocks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wapo_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wapo_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 1.52MB + Index: 0.56MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.11MB + Index: 0.19MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
wp_zbscrm_api_keys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_admlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_aka: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_zbs_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_zbs_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_zbs_customfields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_zbs_events: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_zbs_event_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_externalsources: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_zbs_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_zbs_invoices: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_zbs_lineitems: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_zbs_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_zbs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_object_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_zbs_quotes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_zbs_quotes_templates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_zbs_security_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_sys_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_zbs_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_tags_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_zbs_tax_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_temphash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_zbs_transactions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB

### Post Type Counts ###

attachment: 688
blocks: 13
custom_css: 1
e-landing-page: 1
elementor_library: 2
featured_item: 8
forum: 1
nav_menu_item: 20
oembed_cache: 7
page: 40
popup: 49
popup_theme: 9
post: 46
product: 42
product_variation: 269
qsm_quiz: 5
reply: 3
shop_coupon: 26
shop_order: 1451
shop_order_refund: 43
shop_subscription: 274
topic: 1
ux_template: 1
wpcdt_countdown: 1

### Security ###

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

### Active Plugins (27) ###

Direct checkout, WooCommerce Single page checkout , WooCommerce One page checkout - PRO: by PI Websolution – 1.3.9.13
Advanced Product Fields Pro for WooCommerce: by StudioWombat – 1.8.3
Channel.io: by  – 0.14
?? ?? ?? By ?????: by ????? - Cosmosfarm – 1.9
Customer Reviews for WooCommerce: by CusRev – 4.27
Facebook for WooCommerce: by Facebook – 2.6.5
Social Login Buttons by Heateor: by Team Heateor – 1.2.10
????? ???? ????(?? ?? PG? ? ??): by SIOT – 2.2.29
Jetpack: by Automattic – 10.2.1
KBoard : Comments: by ????? - Cosmosfarm – 5.0
KBoard : Forum: by ????? - Cosmosfarm – 6.0
?? ???? ?? & ???? ???: by CodeMShop – 5.2.4
?? ?????: by CodeMShop – 2.3.5
Popup Maker: by Popup Maker – 1.16.2
QSM Theme - Ivory: by QSM Team – 1.0.0
Quiz And Survey Master: by ExpressTech – 7.3.4
SUMO Reward Points: by Fantastic Plugins – 26.9
Super Socializer: by Team Heateor – 7.13.26
Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.9
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.3
WooCommerce Subscriptions: by WooCommerce – 3.1.6
WooCommerce: by Automattic – 5.8.0
Yoast SEO: by Team Yoast – 17.4
WP-Members: by Chad Butler – 3.3.9.3
WP Rocket: by WP Media – 3.10.1
WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.5
YITH WooCommerce Order Tracking: by YITH – 1.4.0

### Inactive Plugins (1) ###

Loco Translate: by Tim Whitlock – 2.5.5

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: KRW (?)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
Taxonomies: Product Types: simple (simple)
variable (variable)
variable subscription (variable-subscription)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
rated-5 (rated-5)

Connected to WooCommerce.com: ?

### WC Pages ###

Shop base: #168 - /shop/
Cart: #167 - /cart/
Checkout: #166 - /checkout/
My account: #165 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.14.3
Parent Theme Author URL: https://www.uxthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php

### Subscriptions ###

WCS_DEBUG: ? No
Subscriptions Mode: ? Live
Subscriptions Live URL: https://rebrush.co.kr
Subscription Statuses: wc-active: 215
wc-pending-cancel: 11
wc-pending: 5
wc-on-hold: 22
wc-cancelled: 21

WooCommerce Account Connected: ? Yes
Active Product Key: ? Yes
Custom Retry Rules: ? No
Custom Retry Rule Class: ? No
Custom Raw Retry Rule: ? No
Custom Retry Rule: ? No
Retries Migration Status: ? Completed
Report Cache Enabled: ? Yes
Cache Update Failures: ? 0 failure

### Store Setup ###

Country / State: South Korea

### Subscriptions by Payment Gateway ###

import (kakao pay): wc-active: 208
wc-cancelled: 12
wc-on-hold: 13
wc-pending-cancel: 11

other: wc-active: 2
wc-cancelled: 2
wc-on-hold: 2
wc-pending: 4

### Payment Gateway Support ###

????(?????): products
import (credit card) payments: products
refunds

import (real-time bank transfer): products
refunds

import (deposit only bank account): products
refunds

import (kakao pay): products
refunds
subscriptions
subscription_reactivation
subscription_suspension
subscription_cancellation
subscription_date_changes
subscription_amount_changes
subscription_payment_method_change_customer
multiple_subscriptions

### Action Scheduler ###

Complete: 3,560
Oldest: 2021-09-29 15:54:27 +0900
Newest: 2021-10-30 15:00:07 +0900

Failed: 1
Oldest: –
Newest: –

Pending: 227
Oldest: 2021-10-30 16:41:43 +0900
Newest: 2022-10-29 16:56:32 +0900

### Status report information ###

Generated at: 2021-10-30 15:00:29 +09:00

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

Viewing 5 replies - 1 through 5 (of 5 total)
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘add to cart slow problem’ is closed to new replies.