title: MySQL left Join taking too much time
body: <p>I am trying to understand why this mysql statement is taking so long to load.. basically i have 3 tables, each have column VIN as unique and each VIN exist in all the 3</p>
  
  <pre><code>SELECT * FROM vehicle_information i 
   LEFT JOIN vehicle_extra e on i.vin = e.vin 
  LEFT JOIN Images im on i.vin = im.vin
  </code></pre>
  
  <p>I have about 4000 vins that should populate and its taking about 10 seconds.. I have tried to search for a specific row using the same query and adding Where clause at the end, it takes 0.05 sec
  What am I missing here ?</p>
  
  <p>Attached Explain
  <a href="https://i.stack.imgur.com/RzhSN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RzhSN.png" alt="enter image description here"></a></p>