title: sql query to execute multiple condition without UNION
body: <p>I am new to mysql.So basically I perform search with two condition like below</p>
  
  <pre><code>(SELECT * FROM `mytable1` WHERE MATCH(`title`) AGAINST ('cars'  IN BOOLEAN MODE) AND `domain` = 'one' ORDER BY `seed` DESC LIMIT 5)
  union all 
  (SELECT * FROM `mytable1` WHERE MATCH(`title`) AGAINST ('cars' IN BOOLEAN MODE) AND `domain` = 'two' ORDER BY `seed` DESC LIMIT 5)
  </code></pre>
  
  <p>But this query is so slow and my website is crashing after high traffic.Is it possible to rewrite above query for better performance ? </p>
  
  <p>Thank you.</p>