title: How can i check the query execution plan?
body: <p>In the Java application we are developing when loading a page time out exceptions are been thrown. So i am assigned to investigate the issue. there are several database fetches that are happening when loading the page. So i want check which queries are running parallel and the execution plan. Whether there are any unnecessary joints and indexes. The data base is mysql and have used hibernate in the back-end.   </p>
  
  <p>So can anyone left me know how i can get the execution plan and check what queries are being  executed parallel. </p>