SELECT 
  a.*, 
  b.option_name, 
  b.internal_option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  cscart_product_options as a 
  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'en' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = a.option_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_options'
  ) 
WHERE 
  a.product_id IN (
    38980, 38979, 38978, 38977, 38950, 38949, 
    39126, 38968, 38962, 38961, 38960, 
    38959, 38958, 38957, 38956, 38955, 
    38954, 38953, 38952, 38951, 38930, 
    39545, 39544, 39543, 39542, 39541, 
    39540, 39539, 39538, 39537, 39536, 
    39535, 39534, 39533, 39532, 39531, 
    39530, 39529, 39528, 39527, 39526, 
    39525, 39524, 39523, 39522, 39521, 
    39492, 39491, 39490, 39489, 39488, 
    39487, 39486, 39485, 39484, 39483, 
    39482, 39481, 39480, 39479, 39478, 
    39477, 39476, 39475, 39474, 39473, 
    39357, 39356, 39355, 39354, 39353, 
    39352, 39351, 39350, 39349, 39348, 
    39347, 39346, 39345, 39344
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00174

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range PRIMARY,c_status c_status 6 80 Using index condition; Using filesort
1 SIMPLE b eq_ref PRIMARY PRIMARY 9 toolboxdigitalshop_dev.a.option_id,const 1 Using where
1 SIMPLE cscart_ult_objects_sharing eq_ref PRIMARY PRIMARY 159 toolboxdigitalshop_dev.a.option_id,const,const 1 Using where; Using index

Result

option_id product_id company_id option_type inventory regexp required multiupload allowed_extensions max_file_size missing_variants_handling status position value option_name internal_option_name option_text description inner_hint incorrect_message comment
33792 38961 0 S N N N 0 M A 0 Files Type Files Type
33793 38962 0 S N N N 0 M A 0 Files Type Files Type
33798 38968 0 S N N N 0 M A 0 Files Type Files Type
33807 38977 0 S N N N 0 M A 0 Files Type Files Type
33808 38978 0 S N N N 0 M A 0 Files Type Files Type
33809 38979 0 S N N N 0 M A 0 Files Type Files Type
33810 38980 0 S N N N 0 M A 0 Files Type Files Type
34331 39521 0 S N N N 0 M A 0 Files Type Files Type
34332 39522 0 S N N N 0 M A 0 Files Type Files Type
34333 39523 0 S N N N 0 M A 0 Files Type Files Type
34334 39524 0 S N N N 0 M A 0 Files Type Files Type
34335 39525 0 S N N N 0 M A 0 Files Type Files Type
34336 39526 0 S N N N 0 M A 0 Files Type Files Type
34337 39527 0 S N N N 0 M A 0 Files Type Files Type
34338 39528 0 S N N N 0 M A 0 Files Type Files Type
34339 39529 0 S N N N 0 M A 0 Files Type Files Type
34340 39530 0 S N N N 0 M A 0 Files Type Files Type
34341 39531 0 S N N N 0 M A 0 Files Type Files Type
34342 39532 0 S N N N 0 M A 0 Files Type Files Type
34343 39533 0 S N N N 0 M A 0 Files Type Files Type
34344 39534 0 S N N N 0 M A 0 Files Type Files Type
34345 39535 0 S N N N 0 M A 0 Files Type Files Type
34346 39536 0 S N N N 0 M A 0 Files Type Files Type
34347 39537 0 S N N N 0 M A 0 Files Type Files Type
34348 39538 0 S N N N 0 M A 0 Files Type Files Type
34349 39539 0 S N N N 0 M A 0 Files Type Files Type
34350 39540 0 S N N N 0 M A 0 Files Type Files Type
34351 39541 0 S N N N 0 M A 0 Files Type Files Type
34352 39542 0 S N N N 0 M A 0 Files Type Files Type
34353 39543 0 S N N N 0 M A 0 Files Type Files Type
34354 39544 0 S N N N 0 M A 0 Files Type Files Type
34355 39545 0 S N N N 0 M A 0 Files Type Files Type
34163 39344 0 S N N N 0 M A 0 Files Type Files Type
34164 39345 0 S N N N 0 M A 0 Files Type Files Type
34165 39346 0 S N N N 0 M A 0 Files Type Files Type
34166 39347 0 S N N N 0 M A 0 Files Type Files Type
34167 39348 1 S N N N 0 M A 0 Files Type Files Type
34168 39349 0 S N N N 0 M A 0 Files Type Files Type
34169 39350 0 S N N N 0 M A 0 Files Type Files Type
34170 39351 0 S N N N 0 M A 0 Files Type Files Type
34171 39352 0 S N N N 0 M A 0 Files Type Files Type
34172 39353 0 S N N N 0 M A 0 Files Type Files Type
34173 39354 0 S N N N 0 M A 0 Files Type Files Type
34174 39355 0 S N N N 0 M A 0 Files Type Files Type
34175 39356 1 S N N N 0 M A 0 Files Type Files Type
34176 39357 0 S N N N 0 M A 0 Files Type Files Type
33952 39126 1 S N N N 0 M A 0 Files Type Files Type
33763 38930 1 S N N N 0 M A 0 Files Type Files Type
34284 39473 0 S N N N 0 M A 0 Files Type Files Type
34285 39474 0 S N N N 0 M A 0 Files Type Files Type
34286 39475 0 S N N N 0 M A 0 Files Type Files Type
34287 39476 0 S N N N 0 M A 0 Files Type Files Type
34288 39477 0 S N N N 0 M A 0 Files Type Files Type
34289 39478 0 S N N N 0 M A 0 Files Type Files Type
34290 39479 0 S N N N 0 M A 0 Files Type Files Type
34291 39480 0 S N N N 0 M A 0 Files Type Files Type
33780 38949 1 S N N N 0 M A 0 Files Type Files Type
34292 39481 0 S N N N 0 M A 0 Files Type Files Type
33781 38950 0 S N N N 0 M A 0 Files Type Files Type
34293 39482 0 S N N N 0 M A 0 Files Type Files Type
33782 38951 0 S N N N 0 M A 0 Files Type Files Type
34294 39483 0 S N N N 0 M A 0 Files Type Files Type
33783 38952 0 S N N N 0 M A 0 Files Type Files Type
34295 39484 0 S N N N 0 M A 0 Files Type Files Type
33784 38953 0 S N N N 0 M A 0 Files Type Files Type
34296 39485 0 S N N N 0 M A 0 Files Type Files Type
33785 38954 0 S N N N 0 M A 0 Files Type Files Type
34297 39486 0 S N N N 0 M A 0 Files Type Files Type
33786 38955 0 S N N N 0 M A 0 Files Type Files Type
34298 39487 0 S N N N 0 M A 0 Files Type Files Type
33787 38956 0 S N N N 0 M A 0 Files Type Files Type
34299 39488 0 S N N N 0 M A 0 Files Type Files Type
33788 38957 0 S N N N 0 M A 0 Files Type Files Type
34300 39489 0 S N N N 0 M A 0 Files Type Files Type
33789 38958 0 S N N N 0 M A 0 Files Type Files Type
34301 39490 0 S N N N 0 M A 0 Files Type Files Type
33790 38959 0 S N N N 0 M A 0 Files Type Files Type
34302 39491 0 S N N N 0 M A 0 Files Type Files Type
33791 38960 0 S N N N 0 M A 0 Files Type Files Type
34303 39492 0 S N N N 0 M A 0 Files Type Files Type