In MySQL, does the order of the columns in a WHERE clause affect query performance,why?
Maybe because the results from the first "form" of the query are already cached ?
As lyxing said, post the execution plan. It will be interesting to see how the optimizer chooses the execution plan in both cases.