Speed up searches in admin

About the Extension

What the plugin does

Shopware 6's default admin search scans orders, customers and products with LIKE queries across the full table. As your catalogue grows, this gets linearly slower — noticeably so from a few hundred thousand records. This plugin creates MySQL full-text and prefix indexes on the relevant columns and routes the search through them. In benchmarks, the index lookup stays flat at ~0.4 ms from 1,000 to 1,000,000 rows, while the LIKE scan rises to ~0.9 s — up to 2,500× faster at one million rows.

No Elasticsearch required

The plugin works on MySQL- or MariaDB-only setups. No additional search servers, no OpenSearch or Elasticsearch instance needed.

Per-area control

In the plugin settings you enable the acceleration per area: orders, products and customers can be switched on and off independently (kill switch). Everything is off by default.

Index status visible in admin

The plugin settings show per area which indexes exist and which are missing. Missing indexes can be built with a single click via the message queue in the background — the shop stays reachable. Alternatively via console: bin/console coe:admin-search:index --create.

Covered fields

The indexes cover every field you can enable in the search settings: names, numbers, email addresses, tags, tracking codes, document numbers, product search keywords, and a customer's default billing and shipping address including its country.

Automatic fallback

When a search can't be fully answered from the indexes — an unknown custom field or a search term with no indexable word — it automatically falls back to the standard search instead of returning an incomplete result.

List views & filters

The accelerated search also applies in the order, product and customer lists — including when a filter is set or a column is sorted. Previously the acceleration only applied to the global search bar at the top.

Weekly index maintenance

InnoDB full-text indexes accumulate deleted entries when rows are continuously removed (e.g. GDPR erasures or guest cleanup), slowing every query. The plugin maintains the indexes automatically every week via a scheduled task. Manual trigger: bin/console coe:admin-search:index --optimize.

Search preferences in user profile

The search preferences in your user profile show, for every field, how the admin search finds it: via an index (⚡ Fast), via a simple scan (✓ Also searched), or not at all (⚠ Slows the search down). If an index is missing, a notice points this out directly.

Diagnostics mode

An optional diagnostics mode (plugin settings, off by default) logs per search which search path was chosen, why it fell back to the standard search if it did, and how long each step took. Search terms are never logged.