SELECT 
  c.product_id AS cur_product_id, 
  a.*, 
  b.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 = 'ro' 
  LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id 
WHERE 
  c.product_id IN (
    480519, 524885, 697773, 866373, 1118377, 
    697683, 612103, 880671, 1434961, 694679, 
    822677, 614913, 301401, 822659, 613219, 
    613221, 1025388, 822679, 1025367, 
    1025365, 1230911, 1338749, 1731846, 
    1732251, 359020, 1153153, 1153155, 
    1338924, 1231165, 1731742, 1732158, 
    1231166, 1732357, 1153734, 1732013, 
    1663556
  ) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00060

JSON explain

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