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 (8295, 1310, 1311) 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00050

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range c_status c_status 6 9 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
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
1258 1310 1 S Y Y N 0 M A 3810 N ROTO: typy okien pod dodatki not_option Type of the window (Roto)
1256 1311 1 S Y Y N 0 M A 3810 N ROTO: typy okien pod dodatki not_option Type of the window (Roto)
1254 1310 1 S Y Y N 0 M A 3811 N ROTO: rozmiarówka pod dodatki not_option Size (ROTO symbols)
1257 1311 1 S Y Y N 0 M A 3811 N ROTO: rozmiarówka pod dodatki not_option Size (ROTO symbols)
1255 1310 1 S Y Y N 0 M A 3812 N ROTO: paleta kolorów ZRV not_option ZRV color Depending on the screen setting, there may be color variations between this representation on your computer and the actual material.
1259 1310 1 S Y Y N 0 M A 3829 N VELUX: kolor osprzętu rolet not_option Color of the side channels
1350 1311 1 S N Y N 0 M A 65535 N not_option Letter in nameplate
1349 1310 1 S N Y N 0 M A 65535 N not_option Letter in nameplate