Searching objects in the admin seems broken

[superdav42]

At least it's not finding things in all the fields. Example:
Searching PR1QGNYWO9 on the payments list page does not find the payment with this id

Searching sites by site title does not seem to work either.

[superdav42]

Plan to resolve:

• Reproduce across list tables (memberships, payments, customers, sites, products) using the admin search box; note which entities fail to return expected results.
• Inspect the respective Query classes and list table args to ensure search terms are mapped to the right fields (name, email, code, domain) and sanitized.
• Fix the search parameter wiring for each table (e.g., pass s → query args, LIKE patterns, proper joins), and add pagination-safe counts.
• Add unit tests for the affected Query classes to assert search returns the expected items for seeded fixtures.

Question:

• Which list(s) are failing for you specifically? If you have example queries that return nothing but should find known records, please share.