This query takes around 2 seconds when the order by is included, without the order it takes less than a tenth of a second. The field that is doing the sorting, qc_products.addedDate, is an index and is a datetime.
What can I do to speed this up other than removing the order by?
SELECT p.productId, vo.Item_Price1,vo.Item_Price2 ,vo.samefldALU, p.visible
FROM
qc_productInCategories as pc,
qc_categories as c,
qc_products as p,
qc_variantOptions AS vo,
qc_variants AS v
WHERE c.name='Coquette'
AND c.categoryId = pc.categoryId
AND pc.productId = p.productId
AND p.productId = v.productId
AND v.variantId = vo.variantId
AND vo.visible=1
AND p.visible=1
GROUP BY vo.samefldALU
ORDER BY p.addedDate DESC
