Super Users are experiencing slowdowns

Hello–

Some of our super users have purchased near 1000 of our 7000+ designs. These super-users are experiencing a severe slow down on the site.

The SQL entries that are bogging down the server are:

2133 | bowsandc_admin | localhost | bowsandc_new-wp-site-2015 | Query   | 1    | Sorting result | SELECT * FROM wp_woocommerce_downloadable_product_permissions as permissions WHERE user_id = 354 | 0.000    |
2266 | bowsandc_admin | localhost | bowsandc_new-wp-site-2015 | Query   | 2    | Sorting result | SELECT * FROM wp_woocommerce_downloadable_product_permissions as permissions WHERE user_id = 402 | 0.000

### WordPress Environment ###

Home URL: https://bowsandclothes.com
Site URL: https://bowsandclothes.com
WC Version: 3.4.6
Log Directory Writable: ?
WP Version: 4.9.8
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: ?

### Server Environment ###

Server Info: nginx/1.10.3
PHP Version: 7.0.32-0ubuntu0.16.04.1 – We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 1 GB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 7.47.0
OpenSSL/1.0.2g

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.0.36-MariaDB-0ubuntu0.16.04.1
Max Upload Size: 1 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.4.6
WC Database Prefix: wp_
MaxMind GeoIP Database: ?
Total Database Size: 6086.98MB
Database Data Size: 4091.59MB
Database Index Size: 1995.39MB
wp_woocommerce_sessions: Data: 159.09MB + Index: 3.02MB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_downloadable_product_permissions: Data: 123.67MB + Index: 268.56MB
wp_woocommerce_order_items: Data: 72.61MB + Index: 31.58MB
wp_woocommerce_order_itemmeta: Data: 1883.00MB + Index: 436.84MB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
crypto_files: Data: 0.02MB + Index: 0.33MB
crypto_membership: Data: 0.02MB + Index: 0.09MB
crypto_payments: Data: 0.02MB + Index: 0.31MB
crypto_products: Data: 0.02MB + Index: 0.25MB
wp_cb_contact_form: Data: 0.02MB + Index: 0.00MB
wp_cb_create_control_form: Data: 0.02MB + Index: 0.00MB
wp_cb_dynamic_settings: Data: 0.02MB + Index: 0.00MB
wp_cb_email_template_admin: Data: 0.02MB + Index: 0.00MB
wp_cb_form_settings_table: Data: 0.02MB + Index: 0.00MB
wp_cb_frontend_data_table: Data: 0.14MB + Index: 0.00MB
wp_cb_frontend_forms_table: Data: 0.02MB + Index: 0.00MB
wp_cb_layout_settings_table: Data: 0.02MB + Index: 0.00MB
wp_cb_licensing: Data: 0.02MB + Index: 0.00MB
wp_cb_roles_capability: Data: 0.02MB + Index: 0.00MB
wp_commentmeta: Data: 1.52MB + Index: 1.92MB
wp_comments: Data: 43.58MB + Index: 37.09MB
wp_cptch_images: Data: 0.02MB + Index: 0.00MB
wp_cptch_packages: Data: 0.02MB + Index: 0.00MB
wp_cptch_whitelist: Data: 0.02MB + Index: 0.02MB
wp_cp_feeds: Data: 0.02MB + Index: 0.00MB
wp_csp3_subscribers: Data: 0.02MB + Index: 0.00MB
wp_cspv5_pages: Data: 0.02MB + Index: 0.00MB
wp_cup_cp_profiles: Data: 0.02MB + Index: 0.00MB
wp_ewwwio_images: Data: 39.56MB + Index: 48.50MB
wp_huge_itslider_images: Data: 0.02MB + Index: 0.02MB
wp_huge_itslider_params: Data: 0.02MB + Index: 0.00MB
wp_huge_itslider_sliders: Data: 0.02MB + Index: 0.02MB
wp_huge_it_catalogs: Data: 0.02MB + Index: 0.02MB
wp_huge_it_catalog_albums: Data: 0.02MB + Index: 0.00MB
wp_huge_it_catalog_album_catalog_contact: Data: 0.02MB + Index: 0.00MB
wp_huge_it_catalog_asc_seller: Data: 0.02MB + Index: 0.00MB
wp_huge_it_catalog_products: Data: 0.02MB + Index: 0.02MB
wp_huge_it_catalog_rating: Data: 0.02MB + Index: 0.00MB
wp_huge_it_catalog_reviews: Data: 0.02MB + Index: 0.00MB
wp_layerslider: Data: 0.02MB + Index: 0.00MB
wp_links: Data: 0.02MB + Index: 0.02MB
wp_masterslider_options: Data: 0.02MB + Index: 0.02MB
wp_options: Data: 603.61MB + Index: 11.53MB
wp_pmxe_posts: Data: 0.17MB + Index: 0.00MB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB
wp_pmxi_posts: Data: 1.52MB + Index: 0.00MB
wp_pmxi_templates: Data: 0.13MB + Index: 0.00MB
wp_postmeta: Data: 880.00MB + Index: 899.98MB
wp_posts: Data: 123.66MB + Index: 73.28MB
wp_pwebcontact_forms: Data: 0.02MB + Index: 0.00MB
wp_rg_form: Data: 0.02MB + Index: 0.00MB
wp_rg_form_meta: Data: 0.02MB + Index: 0.00MB
wp_rg_form_view: Data: 0.02MB + Index: 0.02MB
wp_rg_lead: Data: 0.02MB + Index: 0.03MB
wp_rg_lead_detail: Data: 0.02MB + Index: 0.05MB
wp_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB
wp_rg_lead_meta: Data: 0.02MB + Index: 0.05MB
wp_rg_lead_notes: Data: 0.02MB + Index: 0.03MB
wp_say_what_strings: Data: 0.02MB + Index: 0.00MB
wp_simple_login_log: Data: 17.52MB + Index: 3.52MB
wp_termmeta: Data: 0.22MB + Index: 0.27MB
wp_terms: Data: 0.31MB + Index: 0.44MB
wp_term_relationships: Data: 1.52MB + Index: 1.52MB
wp_term_taxonomy: Data: 0.20MB + Index: 0.22MB
wp_usermeta: Data: 77.61MB + Index: 65.20MB
wp_users: Data: 6.52MB + Index: 7.55MB
wp_vtcrt_purchase_log: Data: 0.02MB + Index: 0.02MB
wp_vtcrt_purchase_log_product: Data: 0.02MB + Index: 0.02MB
wp_vtcrt_purchase_log_product_rule: Data: 0.02MB + Index: 0.02MB
wp_vtprd_purchase_log: Data: 0.02MB + Index: 0.02MB
wp_vtprd_purchase_log_product: Data: 7.52MB + Index: 3.52MB
wp_vtprd_purchase_log_product_rule: Data: 6.52MB + Index: 3.52MB
wp_wblm: Data: 0.02MB + Index: 0.00MB
wp_wblm_log: Data: 0.02MB + Index: 0.00MB
wp_wcs_selection_data: Data: 0.02MB + Index: 0.00MB
wp_wc_download_log: Data: 13.52MB + Index: 12.03MB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_customer_order_index: Data: 24.55MB + Index: 66.20MB
wp_wpmelon_advbedit_temp: Data: 0.17MB + Index: 0.00MB
wp_yith_wcwl: Data: 1.52MB + Index: 0.84MB
wp_yith_wcwl_lists: Data: 0.39MB + Index: 16.58MB

### Post Type Counts ###

acf: 5
acf-field: 18
acf-field-group: 5
attachment: 14922
custom_css: 2
faq: 5
gift_card: 21
jetpack_migration: 2
jp_img_sitemap: 10
jp_img_sitemap_index: 2
jp_sitemap: 2
jp_sitemap_master: 2
membership_plan: 2
nav_menu_item: 84
page: 17
post: 5
product: 6521
revision: 20
safecss: 1
shop_coupon: 16
shop_order: 353138
shop_order_refund: 13
slide: 2
slider: 3
vtcrt-rule: 1
vtprd-rule: 2
wishlist: 5
woo_product_tab: 1
wp_email_images: 1
wpcf7_contact_form: 1
ywtm_tab: 1

### Security ###

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

### Active Plugins (25) ###

Advanced Custom Fields: by Elliot Condon – 5.7.7
Captcha: by simplywordpress – 4.4.5
Coming Soon Page & Maintenance Mode by SeedProd: by SeedProd – 5.0.22
Disable Downloadable Repeat Purchase – WooCommerce + WPML: by MCPat.com – 1.2.2 – Not tested with the active version of WooCommerce
Free Downloads WooCommerce: by Square One Media – 3.1.1
EWWW Image Optimizer: by Shane Bishop – 4.4.2
Fusion Builder: by ThemeFusion – 1.1.6
Fusion Core: by ThemeFusion – 3.1.6
GoUrl Bitcoin Payment Gateway & Paid Downloads & Membership: by GoUrl.io – 1.4.14
GoUrl WooCommerce – Bitcoin Altcoin Payment Gateway Addon. White Label Solution: by GoUrl.io – 1.2.4
Jetpack by WordPress.com: by Automattic – 6.6.1
Jilt for WooCommerce: by Jilt – 1.5.5
Simple Image Widget: by Cedaro – 4.4.2
Simple Login Log: by Max Chirkov – 1.1.3
SMTP Mailer: by naa986 – 1.0.5
W3 Total Cache: by Frederick Townes – 0.9.7
Widget CSS Classes: by C.M. Kendrick – 1.5.2.1
WooCommerce Ajax add to cart: by WooCommerce Ajax add to cart – 1.0.2 – Not tested with the active version of WooCommerce
Booster for WooCommerce: by Algoritmika Ltd – 4.0.1
WooCommerce Membership: by RightPress – 2.2.4
WooCommerce Volume Discount Coupons: by itthinx – 1.4.0 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.4.6 – 3.5.1 is available
YITH WooCommerce Ajax Search: by YITH – 1.6.1
YITH WooCommerce Gift Cards Premium: by YITHEMES – 1.7.11 – Not tested with the active version of WooCommerce
YITH WooCommerce Wishlist: by YITH – 2.2.5

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
gift-card (gift-card)
grouped (grouped)
simple (simple)
variable (variable)

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

### WC Pages ###

Shop base: #4 – /shop/
Cart: #5 – /cart/
Checkout: #6 – /checkout/
My account: #7 – /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Avada-bows
Version: 1.0.0
Author URL: https://theme-fusion.com
Child Theme: ?
Parent Theme Name: Avada
Parent Theme Version: 5.1.6
Parent Theme Author URL: https://themeforest.net/user/ThemeFusion
WooCommerce Support: ?

### Templates ###

Overrides: Avada-bows/woocommerce/cart/cart.php
Avada-bows/woocommerce/checkout/form-pay.php
Avada-bows/woocommerce/checkout/review-order.php
Avada/woocommerce/checkout/thankyou.php
Avada-bows/woocommerce/loop/loop-start.php
Avada-bows/woocommerce/single-product/add-to-cart/variable.php
Avada-bows/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
Avada-bows/woocommerce/single-product/short-description.php
Avada/woocommerce/single-product/tabs/additional-information.php
Avada-bows/woocommerce/single-product/tabs/description.php
Avada-bows/woocommerce/single-product/title.php

### Jilt ###

Plugin Version: 1.5.5
Jilt API Version: v2
Jilt API Authentication Method: OAuth
Jilt API Connected: ?
Linked to Jilt: ?
Enabled: ?
WooCommerce API: ?

• This topic was modified 6 years ago by bsteeletx. Reason: I had some misleading text in the original post

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