add to cart slow problem

Resolved rebrush2
(@rebrush2)

4 years, 8 months ago

Thanks for developing a good plugin.
Currently, when the Facebook plugin is turned on, there is an issue that the add to cart and buy now action is slowed down from 1 second to 3 seconds.

Attached are screenshots and replay videos.
1. Plugin on
screenshot – https://ibb.co/17WGptK
video – https://vimeo.com/640605438
2. Plugin off
screen shot – https://ibb.co/rHmkwVt
video – https://vimeo.com/640605422

In this regard, I have tried the following actions, but the problem still occurs.

1. Test by turning off all plugins one by one – Same issue occurs even after uninstalling other plugins
2. Request to increase memory from server – Same issue occurs even after memory increase
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.
6. Change the theme or change to the default theme – the same issue occurs even after changing

Just in case, I contacted the server hosting company and received the following response in this regard.

—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.
———————-

In addition, to view current plugin issues
With each plug-in turned off, turn it on one by one and check it
is the delay
https://ibb.co/ccNYP78

For reference, here are the current sites and their respective versions.
site : https://rebrush.co.kr

below is wordpress and woocommerce 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.64MB
Database Data Size: 73.93MB
Database Index Size: 22.71MB
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.31MB + 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: http://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 14:54:02 +0900
Newest: 2021-10-30 14:24:59 +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 14:36:32 +09:00
`

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

The topic ‘add to cart slow problem’ is closed to new replies.