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 (
    88830, 88831, 88832, 88833, 88834, 88835, 
    88836, 88837, 88838, 88839, 88902, 
    88903, 88904, 88905, 88906, 88907, 
    88908, 88909, 88910, 88911, 88912, 
    88913, 88962, 89049, 89050, 89051, 
    89052, 89834, 89835, 89836, 89837, 
    89838, 89839, 89840, 89841, 89842, 
    89843, 89844, 89845, 89846
  )

Query time 0.00041

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
88830 S
88831 S
88832 S
88833 S
88834 S
88835 S
88836 S
88837 S
88838 S
88839 S
88902 S
88903 S
88904 S
88905 S
88906 S
88907 S
88908 S
88909 S
88910 S
88911 S
88912 S
88913 S
88962 S
89049 S
89050 S
89051 S
89052 S
89834 S
89835 S
89836 S
89837 S
89838 S
89839 S
89840 S
89841 S
89842 S
89843 S
89844 S
89845 S
89846 S