* Renamed "Search Analytics" tab to "Analytics & Caching" to better reflect the caching options it contains
* Added auto-cache for slow searches: caches any search term whose tracked average speed exceeds a configurable threshold (default > 250ms) for a configurable duration (default 20 minutes). Works alongside the existing frequency-based and top-X auto-cache options
* Fixed missing avg speed in Analytics & Caching table - front-end main-query searches were being tracked before the query ran so no speed was recorded (column always showed -). Now stashes the start time in pre_get_posts and records elapsed ms from the_posts filter after the query actually executes. Slow-search auto-cache now has real data to work with.
* Meta Search tab now loads instantly on first page view - only a curated whitelist of commonly-searched meta keys (SKU, MPN, GTIN, ISBN, EAN, UPC, ASIN, brand, manufacturer, model, supplier, supplier code, part number, subtitle, byline, deck, summary, purchase note, variation description, etc.) is queried against wp_postmeta via an indexed IN lookup
* Added "Fetch all meta keys" button on the Meta Search tab (replaces "Refresh Meta Keys List") that runs the exhaustive postmeta scan on demand via AJAX
* Already-selected meta keys are always surfaced on first page load so saved settings remain visible even if not in the whitelist
* Added new sss_meta_keys_whitelist filter so the whitelist can be extended per-site
* Added exclusion for any meta_key containing "post_id" (e.g. foo_post_id_123) from the exhaustive scan - catches plugins that embed post IDs into meta key names
* Added exclusion for meta keys starting with fsp_fb_ from the exhaustive scan
* WP-CLI rebuild now prints each SQL statement BEFORE executing it (previously printed after completion) so users can see which query is currently running in real time
* Added Search Analytics tab - track which terms users search for, view top searches, and configure per-term redirects and caching
* Added search term redirects - admins can redirect popular search terms (e.g. "borisov") to specific URLs (e.g. /tags/borisov/) instead of running a search
* Added search result caching - global cache, per-term cache, and auto-cache for top X searches from last Y hours
* Added search tracking - aggregate search frequency tracking with INSERT ON DUPLICATE KEY UPDATE for minimal performance impact
* Fixed undefined $default_language variable in suggestion builder causing PHP warnings and incorrect language assignment for user-added suggestions
* Fixed collation detection: SSS tables now match the actual wp_posts table collation (detected via SHOW TABLE STATUS) instead of relying on wp-config.php defaults which may differ from existing tables
* Removed hardcoded collate utf8mb4_unicode_ci from suggestions DELETE join - the rebuild now ensures all suggestion tables have matching collations automatically
* Rebuild process now ALTERs persisting suggestion tables (useradded/userremoved) to match the detected collation if they differ
* Readiness check now always shows collation of all SSS and WordPress tables regardless of whether TranslatePress is installed
* TranslatePress collation mismatches now show ALTER SQL for the user to run manually
* Build process now properly aborts on "Duplicate entry" scheduler errors instead of retrying in an infinite loop, with instructions to use wp sss rebuild via CLI
* Build process now properly cancels the queue on SQL errors instead of calling exit which left the queue intact
* Fixed search result caching - cache now works for both full page and AJAX searches via shared code path in sss_pre_get_posts
* Fixed cache storage bug where WordPress's found_posts filter fired before the_posts, clearing pending cache data before IDs could be captured
* Changed cache storage from query vars (which WordPress resets internally) to SSS instance property using spl_object_id for reliable tracking
* Cache now stores found_posts total from FOUND_ROWS() for correct pagination on cache hits
* Frequency-based caching: "Cache searches which happen X times within Y period for Z duration" replaces simple "cache all" toggle
* Settings tabs now retain active tab after saving (hash preserved in form referer)
* Search speed (avg query time in ms) now tracked and displayed in Search Analytics table
* Added Multi-search tab with two-phase search: Phase 1 restricts to recent content for faster results, Phase 2 falls back to unrestricted search if not enough recent results found
* Configurable recent period (days/weeks/months) and "Search older items" button text
* When Phase 1 fills a full page, pagination is replaced with "Search older items" button that shows remaining results excluding the recent ones
* AJAX dropdown search also uses multi-phase: tries recent-only first, falls back to unrestricted if insufficient results
* Multi-phase search works with existing search caching - cached results respect the date restriction
