The queries are not equivalent, they will give different results, so there is very little gain in comparing their performance.
Query 1 has a condition about carriers
(the table on the right side of the LEFT
join) in the WHERE
clause. That essentially converts the join to an INNER
join.