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 = 'en' 
  LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id 
WHERE 
  c.product_id IN (
    10067, 9851, 3320, 9842, 10104, 10063, 
    407, 8861, 405, 10201, 3319, 9849
  ) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00103

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

Result

cur_product_id 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
405 535 0 1 S Y Y N 0 M A 20 Y FAKRO: rozmiary standardowe not_option Size (FAKRO)
407 535 0 1 S Y Y N 0 M A 20 Y FAKRO: rozmiary standardowe not_option Size (FAKRO)
10104 595 0 1 S Y Y N 0 M A 2009 N not_option Window size <p>Width x Height</p> <table border="1" bordercolor="#00cc99" rules="typ"> <tbody> <tr> <td colspan="2" rowspan="1" style="text-align: center;"><strong>Warning!</strong></td> </tr> <tr> <td style="text-align: justify; width: 312px; height: 142px;">The size of e.g. 78x140 cm applies to roof window&#39;s size! The blind itself is smaller. Window&#39;s size can be found on the nameplate located at the top of the window. There is no need to measeure the window. Just read the size from the nameplate and order accessories in the corresponding size.</td> <td style="text-align: justify; width: 188px; height: 142px;"><img alt="" src="images/products/fakro_nameplate_animated.gif" /></td> </tr> </tbody> </table>
405 621 0 1 S Y Y N 0 M A 2144 N FAKRO kolory prowadnic not_option ARZ Color
407 621 0 1 S Y Y N 0 M A 2144 N FAKRO kolory prowadnic not_option ARZ Color
9842 955 0 1 S Y Y N 0 M A 3020 N VELUX 3 generacje dla roletek z prowadnicami not_option VELUX symbol
9842 1154 0 1 S Y Y N 0 M A 3121 N VELUX DKL, DSL, DML oraz DFD not_option Color of the VELUX blackout blind Depending on the screen setting, there may be color variations between this representation on your computer and the actual material.
9851 1260 0 1 S Y Y N 0 M A 3123 N VELUX FHC, FMC i FSC not_option Color of the VELUX blackout pleated blind Depending on the screen setting, there may be color variations between this representation on your computer and the actual material.
9842 1155 0 1 S Y Y N 0 M A 3129 N VELUX: kolor osprzętu rolet not_option Color of the side channels
9851 1155 0 1 S Y Y N 0 M A 3129 N VELUX: kolor osprzętu rolet not_option Color of the side channels
405 1149 0 1 F N N N jpg,bmp,gif,png,jpeg 0 M A 6000 N Upload tabliczki znamionowej okna not_option Nameplate Please upload a photo of your window nameplate to speed up the ordering process
407 1149 0 1 F N N N jpg,bmp,gif,png,jpeg 0 M A 6000 N Upload tabliczki znamionowej okna not_option Nameplate Please upload a photo of your window nameplate to speed up the ordering process
3319 1149 0 1 F N N N jpg,bmp,gif,png,jpeg 0 M A 6000 N Upload tabliczki znamionowej okna not_option Nameplate Please upload a photo of your window nameplate to speed up the ordering process
9842 1149 0 1 F N N N jpg,bmp,gif,png,jpeg 0 M A 6000 N Upload tabliczki znamionowej okna not_option Nameplate Please upload a photo of your window nameplate to speed up the ordering process
9849 1149 0 1 F N N N jpg,bmp,gif,png,jpeg 0 M A 6000 N Upload tabliczki znamionowej okna not_option Nameplate Please upload a photo of your window nameplate to speed up the ordering process
9851 1149 0 1 F N N N jpg,bmp,gif,png,jpeg 0 M A 6000 N Upload tabliczki znamionowej okna not_option Nameplate Please upload a photo of your window nameplate to speed up the ordering process
10104 1149 0 1 F N N N jpg,bmp,gif,png,jpeg 0 M A 6000 N Upload tabliczki znamionowej okna not_option Nameplate Please upload a photo of your window nameplate to speed up the ordering process