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 (
    47488, 47234, 47232, 51280, 47452, 47248, 
    47058, 51278, 47051, 47046, 47045, 
    47044, 47043, 47042, 47041, 47040, 
    47039, 47038, 47037, 47036, 47035, 
    47034, 47235, 47115, 47113, 47112, 
    47111, 47110, 47109, 47108, 47107, 
    47106, 47105, 47104, 47103, 47102, 
    47101, 46931, 46946, 46945, 46944, 
    47214, 47213, 47212, 47211, 47210, 
    47209, 47208, 47207, 47206, 47205, 
    47204, 47203, 47202, 47201, 47200, 
    47199, 47196, 46936, 46876, 46875, 
    46918, 46785, 46746, 46943, 46942, 
    46941, 46940, 46910, 46703, 47010, 
    47009, 47008, 46935, 46929, 46928, 
    46927, 46926, 46688, 46925
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00166

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
41496 46910 1 S N N N 0 M A 0 Files Type Files Type
41504 46918 0 S N N N 0 M A 0 Files Type Files Type
42021 47452 1 S N N N 0 M A 0 Files Type Files Type
41511 46925 0 S N N N 0 M A 0 Files Type Files Type
41512 46926 0 S N N N 0 M A 0 Files Type Files Type
41513 46927 1 S N N N 0 M A 0 Files Type Files Type
41514 46928 0 S N N N 0 M A 0 Files Type Files Type
41515 46929 0 S N N N 0 M A 0 Files Type Files Type
41517 46931 1 S N N N 0 M A 0 Files Type Files Type
41773 47196 1 S N N N 0 M A 0 Files Type Files Type
41776 47199 0 S N N N 0 M A 0 Files Type Files Type
41521 46935 1 S N N N 0 M A 0 Files Type Files Type
41777 47200 0 S N N N 0 M A 0 Files Type Files Type
41522 46936 1 S N N N 0 M A 0 Files Type Files Type
41778 47201 0 S N N N 0 M A 0 Files Type Files Type
41779 47202 0 S N N N 0 M A 0 Files Type Files Type
41780 47203 0 S N N N 0 M A 0 Files Type Files Type
41781 47204 0 S N N N 0 M A 0 Files Type Files Type
41526 46940 0 S N N N 0 M A 0 Files Type Files Type
41782 47205 0 S N N N 0 M A 0 Files Type Files Type
41527 46941 1 S N N N 0 M A 0 Files Type Files Type
41783 47206 0 S N N N 0 M A 0 Files Type Files Type
41528 46942 0 S N N N 0 M A 0 Files Type Files Type
41784 47207 0 S N N N 0 M A 0 Files Type Files Type
41529 46943 0 S N N N 0 M A 0 Files Type Files Type
41785 47208 0 S N N N 0 M A 0 Files Type Files Type
41530 46944 0 S N N N 0 M A 0 Files Type Files Type
41786 47209 0 S N N N 0 M A 0 Files Type Files Type
41531 46945 0 S N N N 0 M A 0 Files Type Files Type
41787 47210 0 S N N N 0 M A 0 Files Type Files Type
41532 46946 0 S N N N 0 M A 0 Files Type Files Type
41788 47211 0 S N N N 0 M A 0 Files Type Files Type
41789 47212 0 S N N N 0 M A 0 Files Type Files Type
41790 47213 0 S N N N 0 M A 0 Files Type Files Type
41791 47214 0 S N N N 0 M A 0 Files Type Files Type
41282 46688 0 S N N N 0 M A 0 Files Type Files Type
42056 47488 1 S N N N 0 M A 0 Files Type Files Type
41808 47232 1 S N N N 0 M A 0 Files Type Files Type
41297 46703 0 S N N N 0 M A 0 Files Type Files Type
41810 47234 1 S N N N 0 M A 0 Files Type Files Type
41811 47235 1 S N N N 0 M A 0 Files Type Files Type
41824 47248 1 S N N N 0 M A 0 Files Type Files Type
41592 47008 0 S N N N 0 M A 0 Files Type Files Type
41593 47009 0 S N N N 0 M A 0 Files Type Files Type
41594 47010 0 S N N N 0 M A 0 Files Type Files Type
41339 46746 0 S N N N 0 M A 0 Files Type Files Type
45703 51278 0 S N N N 0 M A 0 Files Type Files Type
45705 51280 0 S N N N 0 M A 0 Files Type Files Type
41617 47034 0 S N N N 0 M A 0 Files Type Files Type
41618 47035 0 S N N N 0 M A 0 Files Type Files Type
41619 47036 0 S N N N 0 M A 0 Files Type Files Type
41620 47037 0 S N N N 0 M A 0 Files Type Files Type
41621 47038 0 S N N N 0 M A 0 Files Type Files Type
41622 47039 0 S N N N 0 M A 0 Files Type Files Type
41623 47040 0 S N N N 0 M A 0 Files Type Files Type
41624 47041 0 S N N N 0 M A 0 Files Type Files Type
41625 47042 0 S N N N 0 M A 0 Files Type Files Type
41626 47043 0 S N N N 0 M A 0 Files Type Files Type
41627 47044 0 S N N N 0 M A 0 Files Type Files Type
41628 47045 0 S N N N 0 M A 0 Files Type Files Type
41629 47046 0 S N N N 0 M A 0 Files Type Files Type
41376 46785 0 S N N N 0 M A 0 Files Type Files Type
41633 47051 0 S N N N 0 M A 0 Files Type Files Type
41640 47058 0 S N N N 0 M A 0 Files Type Files Type
41682 47101 0 S N N N 0 M A 0 Files Type Files Type
41683 47102 0 S N N N 0 M A 0 Files Type Files Type
41684 47103 0 S N N N 0 M A 0 Files Type Files Type
41685 47104 0 S N N N 0 M A 0 Files Type Files Type
41686 47105 0 S N N N 0 M A 0 Files Type Files Type
41687 47106 0 S N N N 0 M A 0 Files Type Files Type
41688 47107 0 S N N N 0 M A 0 Files Type Files Type
41689 47108 0 S N N N 0 M A 0 Files Type Files Type
41690 47109 0 S N N N 0 M A 0 Files Type Files Type
41691 47110 0 S N N N 0 M A 0 Files Type Files Type
41692 47111 0 S N N N 0 M A 0 Files Type Files Type
41693 47112 0 S N N N 0 M A 0 Files Type Files Type
41694 47113 0 S N N N 0 M A 0 Files Type Files Type
41696 47115 0 S N N N 0 M A 0 Files Type Files Type
41462 46875 0 S N N N 0 M A 0 Files Type Files Type
41463 46876 0 S N N N 0 M A 0 Files Type Files Type