long query

Hi

I've been using your plugin for quite a while without any problems, but now in a particular website I am having a long query everytime when accessing products list or editing a product:

SELECT t.term_id
FROM XXXXX_terms AS t
INNER JOIN XXXXX_term_taxonomy AS tt
ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('pwb-brand')
ORDER BY t.name ASC

Caller: WP_Term_Query->get_terms()

Component: WordPress Core

Rows: 170472

and also this one:

SELECT t., tt.
FROM rNCsP_terms AS t
INNER JOIN rNCsP_term_taxonomy AS tt
ON t.term_id = tt.term_id
WHERE t.term_id IN (18949,18948,4633,96850,3588,4634,59586,59585,4627,18952,18950,4635,70711,3662,4546,4629,4636,109506,4637,18951,4638,2299,3760,4415,18945,2555,18946,4428,3947,18953,794,4632,18954,4430,3679,18955,4404,332,2216,18956,4639,4640,3928,4641,4029,4176,4642,18957,18958,4643,18959,4569,4570,4568,18943,3836,74058,4623,18960,18944,880

Caller: _prime_term_caches()

Component: WordPress Core

Rows: 170472

I've tried to rollback your plugin but the long query is still there.

If I disable the plugin the long query disappears.

Here's the website status: WordPress Environment

WordPress address (URL):
Site address (URL):
WC Version: 9.3.3
Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
Action Scheduler Version: ✔ 3.8.1
Log Directory Writable: ✔
WP Version: 6.6.2
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ✔
Language: pt_PT
External object cache: ✔ Server Environment

Server Info: Apache
PHP Version: 8.2.24
PHP Post Max Size: 1 GB
PHP Time Limit: 600
PHP Max Input Vars: 10000
cURL Version: 8.9.1
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 10.6.19-MariaDB
Max Upload Size: 128 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:
Tamanho total da base de dados: 3403.88MB
Tamanho dos dados da base de dados: 1892.64MB
Tamanho do índice da base de dados: 1511.24MB
rNCsP_woocommerce_sessions: Dados: 0.05MB + Índice: 0.02MB + Engine InnoDB
rNCsP_woocommerce_api_keys: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_woocommerce_attribute_taxonomies: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_woocommerce_downloadable_product_permissions: Dados: 0.02MB + Índice: 0.06MB + Engine InnoDB
rNCsP_woocommerce_order_items: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_woocommerce_order_itemmeta: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_woocommerce_tax_rates: Dados: 0.02MB + Índice: 0.06MB + Engine InnoDB
rNCsP_woocommerce_tax_rate_locations: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_woocommerce_shipping_zones: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_woocommerce_shipping_zone_locations: Dados: 0.02MB + Índice: 0.05MB + Engine InnoDB
rNCsP_woocommerce_shipping_zone_methods: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_woocommerce_payment_tokens: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_woocommerce_payment_tokenmeta: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_woocommerce_log: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
cerber_acl: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
cerber_blocks: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
cerber_countries: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
cerber_lab: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
cerber_lab_ip: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
cerber_lab_net: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
cerber_log: Dados: 0.36MB + Índice: 0.25MB + Engine InnoDB
cerber_qmem: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
cerber_traffic: Dados: 0.38MB + Índice: 0.05MB + Engine InnoDB
rNCsP_actionscheduler_actions: Dados: 0.08MB + Índice: 0.11MB + Engine InnoDB
rNCsP_actionscheduler_claims: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_actionscheduler_groups: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_actionscheduler_logs: Dados: 0.13MB + Índice: 0.11MB + Engine InnoDB
rNCsP_cartflows_ca_cart_abandonment: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_cartflows_ca_email_history: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_cartflows_ca_email_templates: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_cartflows_ca_email_templates_meta: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_cerber_files: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_cerber_sets: Dados: 1.52MB + Índice: 0.00MB + Engine InnoDB
rNCsP_cerber_uss: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_commentmeta: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_comments: Dados: 0.02MB + Índice: 0.09MB + Engine InnoDB
rNCsP_e_events: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_e_notes: Dados: 0.02MB + Índice: 0.17MB + Engine InnoDB
rNCsP_e_notes_users_relations: Dados: 0.02MB + Índice: 0.05MB + Engine InnoDB
rNCsP_e_submissions: Dados: 0.02MB + Índice: 0.27MB + Engine InnoDB
rNCsP_e_submissions_actions_log: Dados: 0.02MB + Índice: 0.11MB + Engine InnoDB
rNCsP_e_submissions_values: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_links: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_options: Dados: 3.41MB + Índice: 0.09MB + Engine InnoDB
rNCsP_postmeta: Dados: 1142.00MB + Índice: 992.00MB + Engine InnoDB
rNCsP_posts: Dados: 247.78MB + Índice: 138.55MB + Engine InnoDB
rNCsP_snippets: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_termmeta: Dados: 7.52MB + Índice: 8.03MB + Engine InnoDB
rNCsP_terms: Dados: 4.52MB + Índice: 6.03MB + Engine InnoDB
rNCsP_term_relationships: Dados: 73.64MB + Índice: 46.61MB + Engine InnoDB
rNCsP_term_taxonomy: Dados: 7.52MB + Índice: 7.03MB + Engine InnoDB
rNCsP_usermeta: Dados: 1.52MB + Índice: 0.78MB + Engine InnoDB
rNCsP_users: Dados: 0.08MB + Índice: 0.05MB + Engine InnoDB
rNCsP_wc_admin_notes: Dados: 0.06MB + Índice: 0.00MB + Engine InnoDB
rNCsP_wc_admin_note_actions: Dados: 0.05MB + Índice: 0.02MB + Engine InnoDB
rNCsP_wc_category_lookup: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_wc_customer_lookup: Dados: 0.06MB + Índice: 0.03MB + Engine InnoDB
rNCsP_wc_download_log: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_wc_orders: Dados: 0.02MB + Índice: 0.11MB + Engine InnoDB
rNCsP_wc_orders_meta: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_wc_order_addresses: Dados: 0.02MB + Índice: 0.06MB + Engine InnoDB
rNCsP_wc_order_coupon_lookup: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_wc_order_operational_data: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_wc_order_product_lookup: Dados: 0.02MB + Índice: 0.06MB + Engine InnoDB
rNCsP_wc_order_stats: Dados: 0.02MB + Índice: 0.05MB + Engine InnoDB
rNCsP_wc_order_tax_lookup: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_wc_product_attributes_lookup: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_wc_product_download_directories: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_wc_product_meta_lookup: Dados: 75.63MB + Índice: 136.84MB + Engine InnoDB
rNCsP_wc_rate_limits: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_wc_reserved_stock: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_wc_tax_rate_classes: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_wc_webhooks: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_woodmart_wishlists: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_woodmart_wishlist_products: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_wpmailsmtp_debug_events: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_wpmailsmtp_tasks_meta: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_wpml_mails: Dados: 1.52MB + Índice: 0.02MB + Engine InnoDB
rNCsP_wt_iew_action_history: Dados: 2.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_wt_iew_cron: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_wt_iew_ftp: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_wt_iew_mapping_template: Dados: 0.02MB + Índice: 0.00MB + Engine InnoDB
rNCsP_yoast_indexable: Dados: 296.91MB + Índice: 144.06MB + Engine InnoDB
rNCsP_yoast_indexable_hierarchy: Dados: 24.56MB + Índice: 28.55MB + Engine InnoDB
rNCsP_yoast_migrations: Dados: 0.02MB + Índice: 0.02MB + Engine InnoDB
rNCsP_yoast_primary_term: Dados: 0.02MB + Índice: 0.03MB + Engine InnoDB
rNCsP_yoast_seo_links: Dados: 0.06MB + Índice: 0.03MB + Engine InnoDB Post Type Counts

acf-field: 8
acf-field-group: 1
attachment: 333374
cms_block: 2
custom_css: 1
elementor_library: 5
nav_menu_item: 37
page: 20
post: 2
product: 526473
revision: 846
woodmart_layout: 7
wp_navigation: 1
wp_template: 2 Security

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔ Active Plugins (26)

Query Monitor: por John Blackbourn – 3.16.4
Secure Custom Fields: por ww.wp.xz.cn – 6.3.10.2
Classic Editor: por WordPress Contributors – 1.6.5
Classic Widgets: por Contribuidores do WordPress – 0.3
Code Snippets: por Code Snippets Pro – 3.6.5.1
Yoast Duplicate Post: por Enrico Battocchi e Team Yoast – 4.5
Elementor Pro: por Elementor.com – 3.24.4
Elementor: por Elementor.com – 3.25.3
Flexible Checkout Fields: por WP Desk – 4.1.14
Loco Translate: por Tim Whitlock – 2.6.11
Perfect Brands WooCommerce: por QuadLayers – 3.4.2
Pontos e recompensas para WooCommerce: por WP Swings – 2.5.1
Redis Object Cache: por Till Krüss – 2.5.4
Advanced Editor Tools: por Automattic – 5.9.2
WooCommerce Weight Based Shipping: por weightbasedshipping.com – 5.11.0
WooCommerce Cart Abandonment Recovery: por CartFlows Inc – 1.3.0
WooCommerce: por Automattic – 9.3.3
Woodmart Core: por – 1.0.43
Yoast SEO: por Team Yoast – 23.7
WP Cerber Security, Anti-spam & Malware Scan: por Cerber Tech Inc. – 9.6.3
WP Crontrol: por John Blackbourn – 1.17.0
WP Fastest Cache: por Emre Vona – 1.3.1
WP Mail Logging: por WP Mail Logging Team – 1.13.1
WP Mail SMTP: por WP Mail SMTP – 4.1.1
Product Import Export for WooCommerce Add-on: por WebToffee – 1.2.6
Import Export for WooCommerce Wrapper: por WebToffee – 1.2.9 Inactive Plugins (0) Dropin Plugins ()

db.php: Query Monitor Database Class (Drop-in)
maintenance.php: maintenance.php
object-cache.php: Redis Object Cache Drop-In Must Use Plugins (1)

aaa-wp-cerber.php: por Cerber Tech Inc. – 1.0 Settings

Legacy API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: left_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: –
Enforce Approved Product Download Directories: ✔
HPOS feature enabled: ✔
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: – Logging

Enabled: ✔
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 dias
Level threshold: –
Log directory size: 5 KB WC Pages

Página da Loja: #88 - /musica/
Carrinho: #89 - /carrinho/ - Contains the woocommerce/cart block
Finalizar compras: #90 - /finalizar-compra-2/ - Contains the woocommerce/checkout block
A minha conta: #54 - /minha-conta/
Termos e condições: #129 - /termos-e-condicoes-de-servico-2/ Theme

Name: Woodmart Child
Version: 1.0.0
Author URL: http://xtemos.com
Child Theme: ✔
Parent Theme Name: Woodmart
Parent Theme Version: 7.6.0
Parent Theme Author URL: http://themeforest.net/user/xtemos
WooCommerce Support: ✔ Templates

Overrides: woodmart/woocommerce/archive-product.php
woodmart/woocommerce/cart/cart-item-data.php
woodmart/woocommerce/cart/cart.php
woodmart/woocommerce/cart/cross-sells.php
woodmart/woocommerce/cart/mini-cart.php
woodmart/woocommerce/checkout/form-checkout.php
/home/musicdstore/public_html/wp-content/plugins/points-and-rewards-for-woocommerce/public/woocommerce/checkout/form-coupon.php
woodmart/woocommerce/checkout/thankyou.php
woodmart/woocommerce/content-product-cat.php
woodmart/woocommerce/content-product.php
woodmart/woocommerce/content-single-product.php
woodmart/woocommerce/content-widget-product.php
woodmart/woocommerce/global/breadcrumb.php
woodmart/woocommerce/global/form-login.php
woodmart/woocommerce/global/quantity-input.php
woodmart/woocommerce/loop/add-to-cart.php
woodmart/woocommerce/loop/loop-end.php
woodmart/woocommerce/loop/loop-start.php
woodmart/woocommerce/loop/no-products-found.php
woodmart/woocommerce/loop/orderby.php
woodmart/woocommerce/loop/pagination.php
woodmart/woocommerce/loop/sale-flash.php
woodmart/woocommerce/myaccount/form-login.php
woodmart/woocommerce/product-searchform.php
woodmart/woocommerce/single-product/add-to-cart/grouped.php
woodmart/woocommerce/single-product/add-to-cart/variable.php
woodmart/woocommerce/single-product/meta.php
woodmart/woocommerce/single-product/product-attributes.php
woodmart/woocommerce/single-product/product-image.php
woodmart/woocommerce/single-product/product-thumbnails.php
woodmart/woocommerce/single-product/rating.php
woodmart/woocommerce/single-product/related.php
woodmart/woocommerce/single-product/sale-flash.php
woodmart/woocommerce/single-product/tabs/description.php
woodmart/woocommerce/single-product/tabs/tabs.php
woodmart/woocommerce/single-product/title.php
woodmart/woocommerce/single-product/up-sells.php
woodmart/woocommerce/single-product-reviews.php
woodmart/woocommerce/single-product.php 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-10-31 19:19:43 +00:00
Options: ✔
Notes: 91
Onboarding: skipped Action Scheduler

Concluída: 136
Oldest: 2024-09-29 22:45:05 +0000
Newest: 2024-10-30 22:06:57 +0000

Falhada: 8
Oldest: 2023-12-16 21:27:49 +0000
Newest: 2024-10-11 18:01:24 +0000

Pendente: 3
Oldest: 2024-10-30 23:00:25 +0000
Newest: 2024-11-04 19:24:05 +0000 Status report information

Generated at: 2024-10-30 22:32:59 +00:00

I hope you can help me with this problem

Best regards

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