Performance queries con múltiples JOIN.

[Carlangueitor]

Hola,

Tengo una consulta, no muy grande y hasta donde entiendo no debería ser tan ineficaz. Actualmente tarda ~110s, la tabla no contiene muchos registros (200k), lo que supongo que el problema está en el subquery, ¿alguna sugerencia?

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
WHERE
    auctions_flight.num_seating >= 3
        AND origins.code = 'MEX'
        AND auctions_flightprice.currency = 'MXN'
        AND auctions_flightprice.Price = (SELECT 
            MIN(Price)
        FROM
            auctions_flightprice
        WHERE
            origin_location_id = auctions_flight.origin_location_id
                AND destination_location_id = auctions_flight.destination_location_id
                AND `date` = auctions_flight.`date`)
ORDER BY auctions_flightprice.`Price`
LIMIT 25;
 

Saludos.