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 (
    1233012, 1067180, 696234, 591722, 589214, 
    1067678, 1033163, 992088, 1730410, 
    614833, 600286, 588439, 588446, 589740, 
    697903, 1067318, 1025367, 695078, 
    1233020, 599887, 1067521, 588910, 
    612038, 991897, 590755, 1025365, 622101, 
    1120163, 697332, 697155, 1073044, 
    591218, 1070391, 593887, 697609, 991976
  ) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00344

JSON explain

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