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 (
    89261, 89260, 89259, 89258, 89257, 89256, 
    89255, 89254, 89253, 89252, 89251, 
    89250, 89249, 89248, 89247, 89246, 
    89245, 89244, 89243, 89242, 89241, 
    89240, 89239, 89791, 89790, 89789, 
    89788, 89787, 89786, 89526, 89525, 
    89524, 89502, 89501, 89500, 89499, 
    89218, 89217, 89593, 89592
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00099

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
83850 89217 1 S N N N 0 M A 0 Files Type Files Type
83851 89218 1 S N N N 0 M A 0 Files Type Files Type
84125 89499 1 S N N N 0 M A 0 Files Type Files Type
84126 89500 1 S N N N 0 M A 0 Files Type Files Type
84127 89501 1 S N N N 0 M A 0 Files Type Files Type
83872 89239 1 S N N N 0 M A 0 Files Type Files Type
84128 89502 1 S N N N 0 M A 0 Files Type Files Type
83873 89240 1 S N N N 0 M A 0 Files Type Files Type
83874 89241 1 S N N N 0 M A 0 Files Type Files Type
83875 89242 1 S N N N 0 M A 0 Files Type Files Type
83876 89243 1 S N N N 0 M A 0 Files Type Files Type
83877 89244 1 S N N N 0 M A 0 Files Type Files Type
83878 89245 1 S N N N 0 M A 0 Files Type Files Type
83879 89246 1 S N N N 0 M A 0 Files Type Files Type
83880 89247 1 S N N N 0 M A 0 Files Type Files Type
83881 89248 1 S N N N 0 M A 0 Files Type Files Type
83882 89249 1 S N N N 0 M A 0 Files Type Files Type
83883 89250 1 S N N N 0 M A 0 Files Type Files Type
83884 89251 1 S N N N 0 M A 0 Files Type Files Type
83885 89252 1 S N N N 0 M A 0 Files Type Files Type
83886 89253 1 S N N N 0 M A 0 Files Type Files Type
83887 89254 1 S N N N 0 M A 0 Files Type Files Type
83888 89255 1 S N N N 0 M A 0 Files Type Files Type
83889 89256 1 S N N N 0 M A 0 Files Type Files Type
83890 89257 1 S N N N 0 M A 0 Files Type Files Type
83891 89258 1 S N N N 0 M A 0 Files Type Files Type
83892 89259 1 S N N N 0 M A 0 Files Type Files Type
83893 89260 1 S N N N 0 M A 0 Files Type Files Type
83894 89261 1 S N N N 0 M A 0 Files Type Files Type
84150 89524 1 S N N N 0 M A 0 Files Type Files Type
84151 89525 1 S N N N 0 M A 0 Files Type Files Type
84407 89786 1 S N N N 0 M A 0 Files Type Files Type
84152 89526 1 S N N N 0 M A 0 Files Type Files Type
84408 89787 1 S N N N 0 M A 0 Files Type Files Type
84409 89788 1 S N N N 0 M A 0 Files Type Files Type
84410 89789 1 S N N N 0 M A 0 Files Type Files Type
84411 89790 1 S N N N 0 M A 0 Files Type Files Type
84412 89791 1 S N N N 0 M A 0 Files Type Files Type
84217 89592 1 S N N N 0 M A 0 Files Type Files Type
84218 89593 1 S N N N 0 M A 0 Files Type Files Type