SELECT 
  * 
FROM 
  cscart_bm_locations as l 
  LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id 
  AND d.lang_code = 'tr' 
WHERE 
  l.layout_id = 2 
  AND l.dispatch IN ('product_features.view') 
ORDER BY 
  l.object_ids desc 
LIMIT 
  1

Query time 0.00014

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE l ALL 36 Using where; Using filesort
1 SIMPLE d eq_ref PRIMARY PRIMARY 10 hobilifedt.l.location_id,const 1 Using where