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 (
    83850, 83851, 83872, 83873, 83874, 83875, 
    83876, 83877, 83878, 83879, 83880, 
    83881, 83882, 83883, 83884, 83885, 
    83886, 83887, 83888, 83889, 83890, 
    83891, 83892, 83893, 83894, 84125, 
    84126, 84127, 84128, 84150, 84151, 
    84152, 84217, 84218, 84407, 84408, 
    84409, 84410, 84411, 84412
  )

Query time 0.00050

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
83850 S
83851 S
83872 S
83873 S
83874 S
83875 S
83876 S
83877 S
83878 S
83879 S
83880 S
83881 S
83882 S
83883 S
83884 S
83885 S
83886 S
83887 S
83888 S
83889 S
83890 S
83891 S
83892 S
83893 S
83894 S
84125 S
84126 S
84127 S
84128 S
84150 S
84151 S
84152 S
84217 S
84218 S
84407 S
84408 S
84409 S
84410 S
84411 S
84412 S