title: MySQL In Clause performace in case of list have duplicate elements and not sorted
body: <p>if list of value for <code>IN</code> clause in mysql have duplicate values and not sorted does it affect performance of query. </p>
  
  <p>for example</p>
  
  <pre><code>SELECT * FROM `t1` WHERE `id` IN (2,2,3,1,1);
  </code></pre>
  
  <p>v/s</p>
  
  <pre><code>SELECT * FROM `t1` WHERE `id` IN (1,2,3);
  </code></pre>