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 (
    2459, 138, 284, 328, 185, 1140, 285, 2509, 
    186, 187, 1488, 927, 1279, 1479, 118, 
    630, 332, 908, 2188, 1135, 2512, 1452, 
    2420, 934, 495, 286, 1493, 1371, 329, 
    2096, 1368, 1136, 944, 1064, 1138, 1153, 
    1369, 1876, 2513, 791, 1058, 1063, 1116, 
    1159, 406, 1114, 145, 354, 1158, 1160, 
    417, 340, 1137, 1982, 117, 683, 910, 
    915, 921, 924, 932, 1065, 1145, 1276
  ) 
  AND a.product_id = 0 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00123

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}