假设我有一个长而昂贵的查询，充满了条件，搜索了大量行.我还有一个特殊的条件，比如公司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)