Comment 1 for bug 1838025

Raw SQL provided in [1] is:

SELECT reservations.id AS reservations_id, reservations.lease_id AS reservations_lease_id, computehost_allocations.compute_host_id AS computehost_allocations_compute_host_id
FROM reservations JOIN leases ON leases.id = reservations.lease_id JOIN computehost_allocations ON reservations.id = computehost_allocations.reservation_id
WHERE computehost_allocations.compute_host_id IN (?, ?) AND leases.end_date >= ? AND leases.start_date <= ?

Raw SQL provided in [2] is:

SELECT reservations.id AS reservations_id, reservations.lease_id AS reservations_lease_id, computehost_allocations.compute_host_id AS computehost_allocations_compute_host_id
FROM reservations JOIN leases ON leases.id = reservations.lease_id JOIN computehost_allocations ON reservations.id = computehost_allocations.reservation_id
WHERE computehost_allocations.compute_host_id IN (?, ?) AND (leases.status = ? OR leases.status = ?) AND (reservations.status = ? OR reservations.status = ?)

[1] https://review.opendev.org/#/c/678755
[2] https://review.opendev.org/#/c/679935

-----

It would be nice to see the difference of the result of the following command in your environment for debugging

mysql> EXPLAIN ANALYZE [the raw sql above]