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 (
    89607, 89606, 89605, 89604, 89603, 89602, 
    89601, 89600, 90393, 90163, 90070, 
    90069, 90068, 89588, 89587, 89535, 
    89534, 90287, 89533, 90328, 90327, 
    89543, 89530, 89529, 89528, 89517, 
    89487, 89486, 90303, 90302, 90301, 
    90300, 90299, 90298, 90297, 90296, 
    90295, 90294, 90293, 90292
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00069

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
84225 89600 1 S N N N 0 M A 0 Files Type Files Type
84993 90393 1 S N N N 0 M A 0 Files Type Files Type
84226 89601 1 S N N N 0 M A 0 Files Type Files Type
84227 89602 1 S N N N 0 M A 0 Files Type Files Type
84228 89603 1 S N N N 0 M A 0 Files Type Files Type
84229 89604 1 S N N N 0 M A 0 Files Type Files Type
84230 89605 1 S N N N 0 M A 0 Files Type Files Type
84231 89606 1 S N N N 0 M A 0 Files Type Files Type
84232 89607 1 S N N N 0 M A 0 Files Type Files Type
84771 90163 1 S N N N 0 M A 0 Files Type Files Type
84112 89486 1 S N N N 0 M A 0 Files Type Files Type
84113 89487 1 S N N N 0 M A 0 Files Type Files Type
84890 90287 1 S N N N 0 M A 0 Files Type Files Type
84895 90292 1 S N N N 0 M A 0 Files Type Files Type
84896 90293 1 S N N N 0 M A 0 Files Type Files Type
84897 90294 1 S N N N 0 M A 0 Files Type Files Type
84898 90295 1 S N N N 0 M A 0 Files Type Files Type
84899 90296 1 S N N N 0 M A 0 Files Type Files Type
84900 90297 1 S N N N 0 M A 0 Files Type Files Type
84901 90298 1 S N N N 0 M A 0 Files Type Files Type
84902 90299 1 S N N N 0 M A 0 Files Type Files Type
84903 90300 1 S N N N 0 M A 0 Files Type Files Type
84904 90301 1 S N N N 0 M A 0 Files Type Files Type
84905 90302 1 S N N N 0 M A 0 Files Type Files Type
84906 90303 1 S N N N 0 M A 0 Files Type Files Type
84143 89517 1 S N N N 0 M A 0 Files Type Files Type
84154 89528 1 S N N N 0 M A 0 Files Type Files Type
84155 89529 1 S N N N 0 M A 0 Files Type Files Type
84156 89530 1 S N N N 0 M A 0 Files Type Files Type
84159 89533 1 S N N N 0 M A 0 Files Type Files Type
84160 89534 1 S N N N 0 M A 0 Files Type Files Type
84928 90327 1 S N N N 0 M A 0 Files Type Files Type
84161 89535 1 S N N N 0 M A 0 Files Type Files Type
84929 90328 1 S N N N 0 M A 0 Files Type Files Type
84679 90068 1 S N N N 0 M A 0 Files Type Files Type
84680 90069 1 S N N N 0 M A 0 Files Type Files Type
84169 89543 1 S N N N 0 M A 0 Files Type Files Type
84681 90070 1 S N N N 0 M A 0 Files Type Files Type
84212 89587 1 S N N N 0 M A 0 Files Type Files Type
84213 89588 1 S N N N 0 M A 0 Files Type Files Type