title: SQL runs very fast in PLSQL but very slow in Mybatis
body: <p>I got a query SQL run very fast in PLSQL , but when running on project it becomes very very slow , almost 5-6 sec.  That makes a very slow response on my page.</p>
  
  <p>in this project we use Mybatis ,and this SQL in mapper file just like others statements, in parameters —> java.lang.Long  ,  resulttype —> xxx.DTO, there’s one
  more thing, this is a large SQL , it includes several   tags, each tag has it own bind parameter —>  #{partyId,TYPE=jdbc.DECIMAL}, but all the same in parameters PartyId.</p>
  
  <p>when i graped SQL in log and put it in PLSQL, it runs very fast, only 0.47s.</p>
  
  <p>I don’t know why.</p>