Performance queries con múltiples JOIN.

[quimfv]

Código MySQL:

SELECT auctions_flight.id,
    auctions_flight.`date`,
    origins.code as origin_code,
    origins.name as origin,
    destinations.name as destination,
    destinations.code as destination_code,
    auctions_flight.num_seating,
    auctions_flightprice.Price,
    auctions_flightprice.currency
FROM auctions_flight
        INNER JOIN
    auctions_flightprice ON auctions_flight.price_id = auctions_flightprice.id
        INNER JOIN
    locations_location as destinations ON auctions_flight.destination_location_id = destinations.id
        INNER JOIN
    locations_location as origins ON auctions_flight.origin_location_id = origins.id
        INNER JOIN
    (SELECT origin_location_id,
                destination_location_id,
                `date`,
                MIN(Price) MPrice
        FROM auctions_flightprice
        GROUP BY origin_location_id,
                destination_location_id,
                `date`
    ) Sbc
        ON auctions_flightprice.Price =Sbc.MPrice
            AND Sbc.origin_location_id = auctions_flight.origin_location_id
            AND Sbc.destination_location_id = auctions_flight.destination_location_id
            AND Sbc.`date` = auctions_flight.`date`
WHERE auctions_flight.num_seating >= 3
    AND origins.code = 'MEX'
    AND auctions_flightprice.currency = 'MXN'
ORDER BY auctions_flightprice.`Price`
LIMIT 25;
 

Esto correra mas y creo que debe dar lo mismo....

(Creo)