Optimize software/versions endpoint database query

[ksykulev]

Fleet 4.60.0 on Chrome 131.0.6778.86 running on macOS

---

💥  Actual behavior

When loading the https://dogfood.fleetdm.com/software/versions endpoint, the database query and post query processing causes a large amount of memory to be consumed in certain cases. See listSoftwareDB https://github.com/fleetdm/fleet/blob/main/server/datastore/mysql/software.go#L885. The query used joins the software table with software_cve and cve_meta. So despite the UI table only having 20 records, the query can pull hundreds of rows from the database.

🧑‍💻  Steps to reproduce

Find a software version that has many CVEs associated with it. You can use this query to identify which softwares have the most CVEs in your database:

SELECT
  software_id,
  count(1)
FROM software_cve
LEFT JOIN software ON software.id = software_cve.software_id
GROUP BY software_id
ORDER BY count(1) DESC

🕯️ More info (optional)

Split from #23679

TBD