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 (
    51830, 51829, 59337, 52214, 51828, 51816, 
    51812, 51811, 51786, 51785, 51813, 
    51802, 51801, 51800, 51799, 51798, 
    51797, 51796, 51795, 51794, 51793, 
    51792, 51791, 51790, 51789, 51788, 
    51753, 51752, 51751, 51750, 51782, 
    51735, 91670, 91669, 91668, 51653, 
    51646, 51638, 51637, 51636, 51635, 
    111382, 51609, 51605, 51587, 51581, 
    51580, 51666, 51665, 51664, 51663, 
    51662, 51557, 51555, 51534, 51533, 
    51532, 51531, 51530, 51529, 51520, 
    51437, 51694, 51430, 51425, 51338, 
    51337, 51319, 51768, 51418, 51287, 
    51198, 51127, 51126, 51098, 51097, 
    51096, 51095, 51094, 51093
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00171

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
45828 51418 0 S N N N 0 M A 0 Files Type Files Type
46596 52214 1 S N N N 0 M A 0 Files Type Files Type
45835 51425 0 S N N N 0 M A 0 Files Type Files Type
45840 51430 1 S N N N 0 M A 0 Files Type Files Type
46098 51694 0 S N N N 0 M A 0 Files Type Files Type
45847 51437 1 S N N N 0 M A 0 Files Type Files Type
45626 51198 1 S N N N 0 M A 0 Files Type Files Type
46138 51735 1 S N N N 0 M A 0 Files Type Files Type
46153 51750 1 S N N N 0 M A 0 Files Type Files Type
46154 51751 1 S N N N 0 M A 0 Files Type Files Type
46155 51752 1 S N N N 0 M A 0 Files Type Files Type
46156 51753 1 S N N N 0 M A 0 Files Type Files Type
46171 51768 0 S N N N 0 M A 0 Files Type Files Type
45928 51520 1 S N N N 0 M A 0 Files Type Files Type
46185 51782 1 S N N N 0 M A 0 Files Type Files Type
46188 51785 1 S N N N 0 M A 0 Files Type Files Type
46189 51786 1 S N N N 0 M A 0 Files Type Files Type
46191 51788 0 S N N N 0 M A 0 Files Type Files Type
46192 51789 0 S N N N 0 M A 0 Files Type Files Type
105329 111382 1 S N N N 0 M A 0 Files Type Files Type
45937 51529 0 S N N N 0 M A 0 Files Type Files Type
46193 51790 0 S N N N 0 M A 0 Files Type Files Type
45938 51530 0 S N N N 0 M A 0 Files Type Files Type
46194 51791 0 S N N N 0 M A 0 Files Type Files Type
45939 51531 0 S N N N 0 M A 0 Files Type Files Type
46195 51792 0 S N N N 0 M A 0 Files Type Files Type
45940 51532 0 S N N N 0 M A 0 Files Type Files Type
46196 51793 0 S N N N 0 M A 0 Files Type Files Type
45941 51533 0 S N N N 0 M A 0 Files Type Files Type
46197 51794 0 S N N N 0 M A 0 Files Type Files Type
45942 51534 0 S N N N 0 M A 0 Files Type Files Type
46198 51795 0 S N N N 0 M A 0 Files Type Files Type
46199 51796 0 S N N N 0 M A 0 Files Type Files Type
46200 51797 0 S N N N 0 M A 0 Files Type Files Type
46201 51798 0 S N N N 0 M A 0 Files Type Files Type
46202 51799 0 S N N N 0 M A 0 Files Type Files Type
53370 59337 0 S N N N 0 M A 0 Files Type Files Type
46203 51800 0 S N N N 0 M A 0 Files Type Files Type
46204 51801 0 S N N N 0 M A 0 Files Type Files Type
46205 51802 0 S N N N 0 M A 0 Files Type Files Type
46213 51811 0 S N N N 0 M A 0 Files Type Files Type
46214 51812 0 S N N N 0 M A 0 Files Type Files Type
46215 51813 1 S N N N 0 M A 0 Files Type Files Type
46216 51816 0 S N N N 0 M A 0 Files Type Files Type
45962 51555 1 S N N N 0 M A 0 Files Type Files Type
45964 51557 0 S N N N 0 M A 0 Files Type Files Type
45712 51287 0 S N N N 0 M A 0 Files Type Files Type
46228 51828 0 S N N N 0 M A 0 Files Type Files Type
46229 51829 1 S N N N 0 M A 0 Files Type Files Type
46230 51830 1 S N N N 0 M A 0 Files Type Files Type
45986 51580 0 S N N N 0 M A 0 Files Type Files Type
45987 51581 0 S N N N 0 M A 0 Files Type Files Type
45993 51587 0 S N N N 0 M A 0 Files Type Files Type
45744 51319 0 S N N N 0 M A 0 Files Type Files Type
46011 51605 0 S N N N 0 M A 0 Files Type Files Type
46015 51609 0 S N N N 0 M A 0 Files Type Files Type
45762 51337 0 S N N N 0 M A 0 Files Type Files Type
45763 51338 0 S N N N 0 M A 0 Files Type Files Type
86226 91668 1 S N N N 0 M A 0 Files Type Files Type
86227 91669 1 S N N N 0 M A 0 Files Type Files Type
45523 51093 1 S N N N 0 M A 0 Files Type Files Type
86228 91670 1 S N N N 0 M A 0 Files Type Files Type
45524 51094 1 S N N N 0 M A 0 Files Type Files Type
45525 51095 1 S N N N 0 M A 0 Files Type Files Type
45526 51096 1 S N N N 0 M A 0 Files Type Files Type
45527 51097 0 S N N N 0 M A 0 Files Type Files Type
45528 51098 0 S N N N 0 M A 0 Files Type Files Type
46040 51635 0 S N N N 0 M A 0 Files Type Files Type
46041 51636 0 S N N N 0 M A 0 Files Type Files Type
46042 51637 0 S N N N 0 M A 0 Files Type Files Type
46043 51638 1 S N N N 0 M A 0 Files Type Files Type
46051 51646 0 S N N N 0 M A 0 Files Type Files Type
46058 51653 0 S N N N 0 M A 0 Files Type Files Type
45555 51126 1 S N N N 0 M A 0 Files Type Files Type
46067 51662 0 S N N N 0 M A 0 Files Type Files Type
45556 51127 1 S N N N 0 M A 0 Files Type Files Type
46068 51663 0 S N N N 0 M A 0 Files Type Files Type
46069 51664 0 S N N N 0 M A 0 Files Type Files Type
46070 51665 0 S N N N 0 M A 0 Files Type Files Type
46071 51666 0 S N N N 0 M A 0 Files Type Files Type