WordPress.DB.SlowDBQuery.slow_db_query_tax_query
slow db query tax query
A query pattern is likely to be slow on larger WordPress sites.
Why It Shows Up
The scan found query arguments such as broad meta queries, tax queries, or unindexed lookups that commonly become expensive as content grows.
Why It Matters
A query that feels fine on a small test site can become a production bottleneck on large stores, membership sites, or publishers.
How to Fix
- Avoid broad `meta_query`, `tax_query`, and unindexed searches on front-end requests when possible.
- Cache expensive results with transients, object cache, or precomputed data.
- Add narrower constraints, pagination, and indexes when custom tables are appropriate.
References
Affected Plugins
| Rank | Plugin | Score | Errors | Warnings | Installs | Added | Updated | Top Issue |
|---|---|---|---|---|---|---|---|---|
| #751 | Quick and Easy FAQs | 71 | 92 | 9 | 10k+ | Non Singular String Literal Domain | ||
| #752 | Amazing Affiliates – Toolkit for Amazon Associates with Amazon Product Blocks and Amazon PAAPI5 / Creators API integration | 72 | 3 | 650 | 600 | Non-prefixed global variable | ||
| #753 | Discontinued Product Stock Status for WooCommerce | 72 | 1 | 51 | 500 | Missing nonce verification | ||
| #754 | Media Library Organizer – Folders, File Manager & Media Categories | 72 | 20 | 130 | 20k+ | Non-prefixed global variable | ||
| #755 | Waymark | 72 | 16 | 32 | 900 | Missing direct file access protection | ||
| #756 | Post Sliders & Post Grids | 73 | 6 | 43 | 1k+ | Request data is not unslashed | ||
| #757 | Post Carousel for DV Builder | 74 | 152 | 9 | 2k+ | Text Domain Mismatch | ||
| #758 | Product Layouts for WooCommerce | 74 | 5 | 75 | 1k+ | Direct Query | ||
| #759 | Easy Accordion – AI-Powered FAQ & Accordion Blocks, Product FAQ | 75 | 306 | 70k+ | Non-prefixed global variable | |||
| #760 | Leo Product Recommendations for WooCommerce | 76 | 3 | 79 | 400 | Short URL found | ||
| #761 | Ocean Posts Slider | 76 | 13 | 14 | 10k+ | Output is not escaped | ||
| #762 | Rearrange Products for WooCommerce | 76 | 1 | 22 | 20k+ | Input is not sanitized | ||
| #763 | RS Template Builder For Elementor – Complete Control Over Headers, Footers & More | 76 | 11 | 56 | 1k+ | Post Not In exclude | ||
| #764 | wpsection | 77 | 131 | 554 | 3k+ | Non-prefixed global variable | ||
| #765 | Related Products Manager for WooCommerce | 79 | 9 | 43 | 1k+ | Non-prefixed global variable | ||
| #766 | ShopEngine Gutenberg WooCommerce Builder Blocks Addon – All in One WooCommerce Solution | 80 | 424 | 735 | 3k+ | Non-prefixed global variable | ||
| #767 | Post Carousel Addons For Elementor | 80 | 9 | 8 | 1k+ | Output is not escaped | ||
| #768 | Random Content | 80 | 10 | 8 | 3k+ | Output is not escaped | ||
| #769 | ElasticPress | 81 | 13 | 655 | 8k+ | Non-prefixed hook name | ||
| #770 | Info Cards – Add Text and Media in Card Layouts | 81 | 7 | 25 | 2k+ | Non-prefixed namespace | ||
| #771 | Timed Content For Beaver Builder | 81 | 29 | 8 | 1k+ | date date | ||
| #772 | Bulk Order Form for WooCommerce | 81 | 8 | 98 | 900 | Non-prefixed hook name | ||
| #773 | ForumWP – Forum & Discussion Board | 82 | 22 | 444 | 800 | Non-prefixed global variable | ||
| #774 | Xpro Theme Builder For Elementor – FREE | 82 | 14 | 28 | 10k+ | Missing direct file access protection | ||
| #775 | WPC AJAX Search for WooCommerce | 83 | 1 | 29 | 1k+ | Nonce verification recommended | ||
| #776 | Aimogen – AI Content Writer, Chatbot, Editor and AI Automation for WordPress | 84 | 12 | 34 | 400 | Not In Footer | ||
| #777 | Better Post & Filter Widgets for Elementor | 84 | 7 | 27 | 3k+ | slow db query tax query | ||
| #778 | Filterable Portfolio | 84 | 3 | 76 | 1k+ | Non-prefixed global variable | ||
| #779 | Logo Slider and Showcase | 84 | 2 | 15 | 7k+ | Missing nonce verification | ||
| #780 | WPC Grouped Product for WooCommerce | 84 | 45 | 3k+ | Nonce verification recommended | |||
| #781 | GazChap's WooCommerce Auto Category Product Thumbnails | 85 | 4 | 8 | 1k+ | trademarked term | ||
| #782 | News Element Elementor Blog Magazine | 85 | 174 | 695 | 400 | Non-prefixed global variable | ||
| #783 | Unlimited Theme Addon For Elementor | 86 | 74 | 68 | 600 | Missing direct file access protection | ||
| #784 | Enable Abilities for MCP | 87 | 48 | 1k+ | Direct Query | |||
| #785 | Variations as Single Product – Display Single Variation for WooCommerce | 87 | 8 | 33 | 1k+ | Direct Query | ||
| #786 | Serious Slider | 88 | 7 | 9 | 20k+ | Non-prefixed global variable | ||
| #787 | Generic Elements | 88 | 1,922 | 140 | 500 | Text Domain Mismatch | ||
| #788 | WPCode – Insert Headers and Footers + Custom Code Snippets – WordPress Code Manager | 88 | 27 | 33 | 3m+ | wp function not compatible with requires wp | ||
| #789 | Piotnet Addons For Elementor | 88 | 744 | 26 | 30k+ | Text Domain Mismatch | ||
| #790 | Smart Blocks – WordPress Gutenberg Blocks | 88 | 10 | 76 | 1k+ | Post Not In post not in | ||
| #791 | WPC Smart Linked Products – Upsells & Cross-sells for WooCommerce | 88 | 29 | 700 | Nonce verification recommended | |||
| #792 | Attachment Taxonomies | 89 | 1 | 8 | 900 | Input is not sanitized | ||
| #793 | Convert to Blocks | 89 | 2 | 11 | 2k+ | Non-prefixed hook name | ||
| #794 | Custom Layouts – Post + Product grids made easy | 89 | 23 | 22 | 4k+ | Missing Translators Comment | ||
| #795 | WPC Smart Notifications for WooCommerce | 89 | 79 | 600 | Non-prefixed global variable | |||
| #796 | Canvas | 90 | 2 | 115 | 10k+ | Non-prefixed global variable | ||
| #797 | External files in Media Library | 90 | 16 | 68 | 400 | Direct Query | ||
| #798 | Bold Page Builder | 91 | 12 | 38 | 40k+ | Not In Footer | ||
| #799 | ERE Similar Properties – Essential Real Estate Add-On | 91 | 4 | 3 | 1k+ | Missing direct file access protection | ||
| #800 | Gutentools | 91 | 17 | 10 | 4k+ | Missing direct file access protection |