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 (
    12498, 15432, 3317, 3314, 3319, 3316, 
    3320, 3318, 3315, 3321, 3322, 3298, 
    3299, 3329, 3330, 3306, 3305, 3304, 
    3325, 3289, 3287, 3283, 3284, 3285, 
    3286, 3292, 3291, 3300, 3301, 3302, 
    3326, 3295, 3294, 3327, 3297, 3307, 
    3309, 3308, 3293, 3288, 3290, 3303, 
    3310, 3324, 3323, 13136, 3922, 15904, 
    3442, 3441, 15431, 4884, 13070, 11475, 
    877, 3500, 3501, 3502, 3504, 3505, 883, 
    884, 3503, 13048, 13038, 3928, 16545, 
    16551, 16528, 15765, 16526, 16547, 
    15767, 16529, 16523, 15764, 16544, 
    16539, 16548, 16527, 16530, 16533, 
    16550, 16538, 16531, 16532, 16546, 
    16520, 16189, 16537, 15876, 16543, 
    15759, 15760, 16534, 15763
  ) 
  AND a.product_id = 0 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00087

JSON explain

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