Fix N+1 queries in `/api/v1/bed/`

[sainak]

Sentry Issue: CARE-KA

Transaction Name	/api/v1/bed/
Parent Span	django.view - bed-list
Repeating Spans (0)	db - SELECT facility_facility.id, facility_facility.external_id, facility_facility.created_date, facility_facility.modified_date, facility_facility.deleted, facility_facility.name, facility_facility.is_active, facility_facility.verified, facility_facility.facility_type, facility_facility.kasp_empanelled, facility_facility.features, facility_facility.longitude, facility_facility.latitude, facility_facility.pincode, facility_facility.address, "facility...
	db - SELECT (1) AS a FROM facility_consultationbed WHERE (facility_consultationbed.deleted = %s AND facility_consultationbed.bed_id = %s AND facility_consultationbed.end_date IS NULL) LIMIT 1

[Yash12Bansal]

@sainak please assign this issue to me

[jasonxiexy]

Hi @sainak,

I would like to contribute to the project by addressing the Fix N+1 queries issue (#1338) in the /api/v1/bed/ endpoint. Could I please be assigned to work on this task? I believe I can help optimize the queries and improve performance in this area.

Thank you, Jason Xie

[himanshu-sharmav]

Hi @sainak, I would like to work on this issue.