SELECT 
  option_id, 
  option_type 
FROM 
  cscart_product_options 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_product_options.option_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_options'
  ) 
WHERE 
  option_id IN (
    84112, 84113, 84143, 84154, 84155, 84156, 
    84159, 84160, 84161, 84169, 84212, 
    84213, 84225, 84226, 84227, 84228, 
    84229, 84230, 84231, 84232, 84679, 
    84680, 84681, 84771, 84890, 84895, 
    84896, 84897, 84898, 84899, 84900, 
    84901, 84902, 84903, 84904, 84905, 
    84906, 84928, 84929, 84993
  )

Query time 0.00042

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 40 Using where
1 SIMPLE cscart_ult_objects_sharing eq_ref PRIMARY PRIMARY 159 toolboxdigitalshop_dev.cscart_product_options.option_id,const,const 1 Using where; Using index

Result

option_id option_type
84112 S
84113 S
84143 S
84154 S
84155 S
84156 S
84159 S
84160 S
84161 S
84169 S
84212 S
84213 S
84225 S
84226 S
84227 S
84228 S
84229 S
84230 S
84231 S
84232 S
84679 S
84680 S
84681 S
84771 S
84890 S
84895 S
84896 S
84897 S
84898 S
84899 S
84900 S
84901 S
84902 S
84903 S
84904 S
84905 S
84906 S
84928 S
84929 S
84993 S