SELECT 
  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' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = a.option_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_options'
  ) 
WHERE 
  a.product_id IN (
    65260, 65340, 65210, 64553, 65258, 65257, 
    65256, 65255, 65254, 65253, 65252, 
    65251, 65250, 65249, 65248, 65247, 
    65246, 65245, 65244, 65243, 65242, 
    65241, 65240, 65239, 65238, 65237, 
    65236, 65235, 65234, 65233, 65232, 
    65231, 65230, 65229, 65163, 65162, 
    65161, 65160, 65159, 65114
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00089

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

Result

option_id product_id company_id option_type inventory regexp required multiupload allowed_extensions max_file_size missing_variants_handling status position value option_name internal_option_name option_text description inner_hint incorrect_message comment
58885 65114 1 S N N N 0 M A 0 Files Type Files Type
58929 65159 1 S N N N 0 M A 0 Files Type Files Type
58930 65160 1 S N N N 0 M A 0 Files Type Files Type
58931 65161 1 S N N N 0 M A 0 Files Type Files Type
58932 65162 1 S N N N 0 M A 0 Files Type Files Type
58933 65163 1 S N N N 0 M A 0 Files Type Files Type
58976 65210 1 S N N N 0 M A 0 Files Type Files Type
58995 65229 1 S N N N 0 M A 0 Files Type Files Type
58996 65230 1 S N N N 0 M A 0 Files Type Files Type
58997 65231 1 S N N N 0 M A 0 Files Type Files Type
58998 65232 1 S N N N 0 M A 0 Files Type Files Type
58999 65233 1 S N N N 0 M A 0 Files Type Files Type
59000 65234 1 S N N N 0 M A 0 Files Type Files Type
59001 65235 1 S N N N 0 M A 0 Files Type Files Type
59002 65236 1 S N N N 0 M A 0 Files Type Files Type
59003 65237 1 S N N N 0 M A 0 Files Type Files Type
59004 65238 1 S N N N 0 M A 0 Files Type Files Type
59005 65239 1 S N N N 0 M A 0 Files Type Files Type
59006 65240 1 S N N N 0 M A 0 Files Type Files Type
59007 65241 1 S N N N 0 M A 0 Files Type Files Type
59008 65242 1 S N N N 0 M A 0 Files Type Files Type
59009 65243 1 S N N N 0 M A 0 Files Type Files Type
59010 65244 1 S N N N 0 M A 0 Files Type Files Type
59011 65245 1 S N N N 0 M A 0 Files Type Files Type
59012 65246 1 S N N N 0 M A 0 Files Type Files Type
59013 65247 1 S N N N 0 M A 0 Files Type Files Type
59014 65248 1 S N N N 0 M A 0 Files Type Files Type
59015 65249 1 S N N N 0 M A 0 Files Type Files Type
59016 65250 1 S N N N 0 M A 0 Files Type Files Type
59017 65251 1 S N N N 0 M A 0 Files Type Files Type
59018 65252 1 S N N N 0 M A 0 Files Type Files Type
59019 65253 1 S N N N 0 M A 0 Files Type Files Type
59020 65254 1 S N N N 0 M A 0 Files Type Files Type
59021 65255 1 S N N N 0 M A 0 Files Type Files Type
59022 65256 1 S N N N 0 M A 0 Files Type Files Type
59023 65257 1 S N N N 0 M A 0 Files Type Files Type
59024 65258 1 S N N N 0 M A 0 Files Type Files Type
59025 65260 1 S N N N 0 M A 0 Files Type Files Type
59102 65340 1 S N N N 0 M A 0 Files Type Files Type
58356 64553 1 S N N N 0 M A 0 Files Type Files Type