Search Query Optimization

select hscode.pkid, hscode.hscode, hscode.description, tariff.description, tariff.uom, tariff.hscodenew, dutiestaxes.rate,dutiestaxes.details, dutiestaxes.start_date, specification.specificationreq, exemptions.reference,exemptions.duty_type, exemptions.applicable_rate, exemptions.conditions, ptafta.reference, tradepolicy.policyreq, tradepolicy.details, tradepolicy.legalreference, commodity.description from hscode inner inner inner inner inner inner inner

join join join join join join join

tariff on hscode.hscode = tariff.hscodenew dutiestaxes on hscode.hscode = dutiestaxes.hscodenew specification on hscode.hscode = specification.hscodenew exemptions on hscode.hscode = exemptions.hscodenew ptafta on hscode.hscode = ptafta.hscodenew tradepolicy on hscode.hscode = tradepolicy.hscodenew commodity on hscode.hscode = commodity.hscodenew

where hscode.hscode = $hscode ---------------------------------------select hscode.pkid, hscode.hscode, hscode.description, tariff.description, tariff.uom, tariff.hscodenew from hscode inner join tariff on hscode.hscode = tariff.hscodenew where hscode.hscode = $hscode ---------------------------------------