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 (
    89077, 89078, 89079, 89080, 89081, 89082, 
    89083, 89084, 89085, 89086, 89087, 
    89088, 89089, 89090, 89091, 89092, 
    89093, 89094, 89095, 89096, 89097, 
    89098, 89099, 89100, 89101, 89102, 
    89103, 89104, 89105, 89106, 89107, 
    89108, 89109, 89178, 89336, 89337, 
    89686, 89687, 89688, 89689
  )

Query time 0.00049

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
89077 S
89078 S
89079 S
89080 S
89081 S
89082 S
89083 S
89084 S
89085 S
89086 S
89087 S
89088 S
89089 S
89090 S
89091 S
89092 S
89093 S
89094 S
89095 S
89096 S
89097 S
89098 S
89099 S
89100 S
89101 S
89102 S
89103 S
89104 S
89105 S
89106 S
89107 S
89108 S
89109 S
89178 S
89336 S
89337 S
89686 S
89687 S
89688 S
89689 S