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 (
    83143, 83145, 83147, 83171, 83321, 83322, 
    83323, 83352, 83353, 83354, 83355, 
    83356, 83357, 83358, 83359, 83360, 
    83361, 83362, 83363, 83364, 83365, 
    83366, 83367, 83368, 83558, 83561, 
    83562, 83622, 83634, 83635, 83636, 
    83637, 83668, 83669, 83670, 83714, 
    83717, 83718, 83719, 83721
  )

Query time 0.00058

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
83143 S
83145 S
83147 S
83171 S
83321 S
83322 S
83323 S
83352 S
83353 S
83354 S
83355 S
83356 S
83357 S
83358 S
83359 S
83360 S
83361 S
83362 S
83363 S
83364 S
83365 S
83366 S
83367 S
83368 S
83558 S
83561 S
83562 S
83622 S
83634 S
83635 S
83636 S
83637 S
83668 S
83669 S
83670 S
83714 S
83717 S
83718 S
83719 S
83721 S