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 (
    9765, 9800, 9801, 10042, 10043, 10044, 
    10066, 10068, 10069, 10070, 10132, 
    10133, 10134, 10295, 10296, 10297, 
    10298, 10299, 10300, 10301, 10302, 
    10303, 10304, 10305, 10308, 10309, 
    11800, 19884, 19885, 26534, 26535, 
    26536, 26537, 26538, 26539, 26540, 
    26541, 26542, 26543, 26544
  )

Query time 0.00074

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
9765 S
9800 S
9801 S
10042 S
10043 S
10044 S
10066 S
10068 S
10069 S
10070 S
10132 S
10133 S
10134 S
10295 S
10296 S
10297 S
10298 S
10299 S
10300 S
10301 S
10302 S
10303 S
10304 S
10305 S
10308 S
10309 S
11800 S
19884 S
19885 S
26534 S
26535 S
26536 S
26537 S
26538 S
26539 S
26540 S
26541 S
26542 S
26543 S
26544 S