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 (
    41930, 41953, 42020, 42041, 42045, 42046, 
    42052, 42053, 42055, 42057, 42115, 
    42128, 42129, 42154, 42155, 42156, 
    42157, 42158, 42159, 42160, 42161, 
    42162, 42171, 42172, 42173, 42174, 
    42175, 42176, 42177, 42178, 42179, 
    42180, 42191, 42200, 42204, 42205, 
    42208, 42210, 42246, 42247, 42248, 
    42249, 42251, 42253, 42254, 42263, 
    42264, 42265, 42266, 42267, 42268, 
    42269, 42270, 42306, 42341, 42342, 
    42343, 42344, 42345, 42346, 42347, 
    42348, 42349, 42350, 42351, 42352, 
    42353, 42354, 42355, 42356, 42357, 
    42358, 42359, 42360, 42361, 42362, 
    42363, 42364, 42365, 45704
  )

Query time 0.00052

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 80 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
41930 S
41953 S
42020 S
42041 S
42045 S
42046 S
42052 S
42053 S
42055 S
42057 S
42115 S
42128 S
42129 S
42154 S
42155 S
42156 S
42157 S
42158 S
42159 S
42160 S
42161 S
42162 S
42171 S
42172 S
42173 S
42174 S
42175 S
42176 S
42177 S
42178 S
42179 S
42180 S
42191 S
42200 S
42204 S
42205 S
42208 S
42210 S
42246 S
42247 S
42248 S
42249 S
42251 S
42253 S
42254 S
42263 S
42264 S
42265 S
42266 S
42267 S
42268 S
42269 S
42270 S
42306 S
42341 S
42342 S
42343 S
42344 S
42345 S
42346 S
42347 S
42348 S
42349 S
42350 S
42351 S
42352 S
42353 S
42354 S
42355 S
42356 S
42357 S
42358 S
42359 S
42360 S
42361 S
42362 S
42363 S
42364 S
42365 S
45704 S