假设我有一个漫长而昂贵的查询，里面挤满了条件，搜索了大量的行。我还有一个特殊条件，例如公司ID，它将限制需要大量搜索的行数，将其范围从数十万缩小到几十。

我这样做是否会对MySQL性能产生任何影响：

 SELECT * FROM clients WHERE 
       (firstname LIKE :foo OR lastname LIKE :foo OR phone LIKE :foo) AND 
       (firstname LIKE :bar OR lastname LIKE :bar OR phone LIKE :bar) AND 
       company = :ugh

或这个：

 SELECT * FROM clients WHERE 
       company = :ugh AND
       (firstname LIKE :foo OR lastname LIKE :foo OR phone LIKE :foo) AND 
       (firstname LIKE :bar OR lastname LIKE :bar OR phone LIKE :bar)