title: Too much time on optimal path
body: <p>Below query has taken just 0.04 second</p>
  
  <pre><code>SELECT A.* 
  FROM  `TABLE1` 
  JOIN TABLE2 ON ( TABLE1.ID = TABLE2.ID ) 
  WHERE  `COL1` ='1'
  </code></pre>
  
  <p>While next query has taken 4 seconds</p>
  
  <pre><code>SELECT A.* FROM  `TABLE1` 
  JOIN TABLE2 ON ( TABLE1.ID = TABLE2.ID ) 
  WHERE  `COL1` ='1' and col2 not in (....ard 4k integers...P
  </code></pre>
  
  <p>and maximum time is getting spend on statistic (3sec+) which probably mean looking for optimal query path.</p>
  
  <p>I am using MySQL 5.5.25 and just want to know if this is a bug.</p>