Sandbox

SELECT 
  cscart_cp_speed_optimization_links.* 
FROM 
  cscart_cp_speed_optimization_links 
  LEFT JOIN cscart_cp_speed_optimization_locations ON cscart_cp_speed_optimization_locations.link_id = cscart_cp_speed_optimization_links.link_id 
WHERE 
  cscart_cp_speed_optimization_links.status = 'A' 
  AND cscart_cp_speed_optimization_locations.loc_hash IN (420257053, 991457757) 
ORDER BY 
  cscart_cp_speed_optimization_links.position asc

Query time 0.00153

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}