MySQL Query Optimization for two tables where ID does not exits in 2nd table
<p>We have this below MySQL query. while the query runs smoothly in localhost with huge data, it takes a lot of time in live server. i tried to optimize it but to no wain. can this code be written in more simpler term?
help will be really appreciated.    </p>

<pre><code>SELECT id, Request_By, Org_Name, Branch_Name, SALES_PERSON, Is_Consignee, Is_Shipper, EmailId, Telephone, Credit_LimitRS, IE_Code_No,
    PAN_No, Credit_limitDAYS, GL_Link 
    FROM mst_ship_con_newcust
    WHERE ( not EXISTS ( SELECT * FROM mst_branch_info b where b.id = mst_ship_con_newcust.id) ) 
    ORDER BY id desc
</code></pre>