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 (
    9845, 9853, 9843, 478, 3321, 514, 8295, 
    480, 9851, 9842, 9849, 479
  ) 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00066

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range c_status c_status 6 15 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
1366 9853 1 S Y Y N 0 M A 0 N not_option Velux MHL Size
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
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
860 479 1 S Y Y N 0 M A 3000 N VELUX 3 generacje dla dodatków zewnętrznych not_option Size (VELUX symbol)
968 478 1 S Y Y N 0 M A 3000 N VELUX 3 generacje dla dodatków zewnętrznych not_option Size (VELUX symbol)
981 9849 1 S Y Y N 0 M A 3000 N VELUX 3 generacje dla dodatków zewnętrznych not_option Size (VELUX symbol) <img src="/images/products/rooflite/mua/velux_tabliczka.jpg" />
1262 9851 1 S Y Y N 0 M A 3020 N VELUX 3 generacje dla roletek z prowadnicami not_option VELUX symbol
1216 3321 1 S Y Y N 0 M A 3530 N Paleta DUA not_option Color