Sandbox

SELECT 
  c.product_id AS cur_product_id, 
  a.*, 
  b.option_name, 
  b.internal_option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  cscart_product_options as a 
  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'en' 
  LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id 
WHERE 
  c.product_id IN (
    4343, 2380, 11140, 2424, 2426, 2428, 
    2429, 2430, 2431, 16509, 2432, 2438, 
    17194, 2439, 2440, 15941, 2441, 13684, 
    17173, 13827, 2443, 12952, 2447, 2434, 
    2446, 2445, 16235, 2444, 13492, 4340, 
    2364, 13765, 13826, 12953, 13822, 4378, 
    16952, 15899, 15900, 15792, 15784, 
    12955, 12954, 2451, 2453, 11894, 11893, 
    2457, 2458, 2460, 17184, 2459, 2461, 
    11138, 2365, 16580, 2360, 16138, 4337, 
    2366, 4342, 16222
  ) 
  AND a.product_id = 0 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00047

JSON explain

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