SELECT 
  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 = 'en' 
WHERE 
  a.product_id IN (
    3321, 10101, 10172, 8878, 514, 10070, 
    8295, 3315, 7353, 4939, 480, 3318
  ) 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00058

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range c_status c_status 6 16 Using index condition; Using filesort
1 SIMPLE b eq_ref PRIMARY PRIMARY 9 mahm3t_cs443.a.option_id,const 1 Using where

Result

option_id product_id company_id option_type inventory regexp required multiupload allowed_extensions max_file_size missing_variants_handling status position value size_option note google_export_name_option option_name option_text description inner_hint incorrect_message comment
1182 4939 1 S Y Y N 0 M A 20 N FAKRO: rozmiarówka pod rolety z prowadnicami not_option Size (FAKRO symbol) The size of e.g. 78/118 applies to roof window's size! The blind itself is smaller. Window's size can be found on the nameplate located at the top of the window.
1215 3321 1 S Y Y N 0 M A 50 N not_option Type of the window
1214 3321 1 S Y Y N 0 M A 100 N not_option Size (VELUX symbol)
1222 8295 1 S Y Y N 0 M A 100 N not_option Dimension X | inner wall width <p>The insect screen is mounted on the inner lining or on the wall. Thus, the roof cutout (X interior lining) is measured to determine the size of the insect screen. The width of the insect screen depends on the width of the window.<br /> <img alt="How to measure width of the insect screen?" src="/images/products/rooflite/zia/insektenschutz-rollos-montagehinweise.png" /></p> The insect screen is mounted on the inner lining or on the wall
1223 8295 1 S Y Y N 0 M A 200 N not_option Dimension Y | inner wall height <p>The insect screen is mounted on the inner lining or on the wall. Thus, the roof cutout (Y interior lining) is measured to determine the size of the insect screen. The height of the insect screen depends on the height of the window.<br /> <img alt="How to choose height of the insect screen?" src="/images/products/rooflite/zia/insektenschutz-rollos-montagehinweise.png" /></p> The insect screen is mounted on the inner lining or on the wall
727 514 1 S Y Y N 0 M A 1000 N FAKRO ARS/ARP not_option Blind color
1183 4939 1 S Y Y N 0 M A 2142 N FAKRO ARF not_option ARF Color Depending on the screen setting, there may be color variations between this representation on your computer and the actual material.
969 3318 1 S Y Y N 0 M A 3000 N VELUX 3 generacje dla dodatków zewnętrznych not_option Size (DAKEA symbol)
859 480 1 S Y Y N 0 M A 3000 N VELUX 3 generacje dla dodatków zewnętrznych not_option VELUX roof window size
1122 10172 1 S Y Y N 0 M A 3000 Y VELUX V22 not_option Window size V22
1125 8878 1 S Y Y N 0 M A 3000 Y VELUX V22 not_option Window size V22
1216 3321 1 S Y Y N 0 M A 3530 N Paleta DUA not_option Color