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 (
    38067, 38037, 38036, 38034, 38033, 38032, 
    38031, 38030, 38029, 38028, 38027, 
    38026, 38025, 38022, 38021, 38020, 
    38019, 38018, 38017, 38016, 38015, 
    38014, 38013, 38012, 38011, 38010, 
    38009, 38008, 38007, 38006, 38005, 
    38004, 38003, 38002, 38001, 38000, 
    37999, 37998, 37997, 37996, 37995, 
    37994, 37993, 37992, 37991, 37990, 
    37989, 40283, 38872, 38159, 79896, 
    38226, 38078, 38077, 38076, 37988, 
    37987, 37986, 38458, 38423, 38422, 
    38421, 38420, 38419, 38418, 38417, 
    38400, 38399, 38244, 38227, 38172, 
    37985, 40512, 38181, 38180, 40355, 
    38884, 38062, 38043, 38042
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00126

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
33280 38423 0 S N N N 0 M A 0 Files Type Files Type
33036 38172 1 S N N N 0 M A 0 Files Type Files Type
33044 38180 0 S N N N 0 M A 0 Files Type Files Type
33045 38181 0 S N N N 0 M A 0 Files Type Files Type
33313 38458 1 S N N N 0 M A 0 Files Type Files Type
35127 40355 0 S N N N 0 M A 0 Files Type Files Type
74816 79896 1 S N N N 0 M A 0 Files Type Files Type
33089 38226 1 S N N N 0 M A 0 Files Type Files Type
33090 38227 1 S N N N 0 M A 0 Files Type Files Type
33107 38244 1 S N N N 0 M A 0 Files Type Files Type
32854 37985 1 S N N N 0 M A 0 Files Type Files Type
32855 37986 1 S N N N 0 M A 0 Files Type Files Type
32856 37987 1 S N N N 0 M A 0 Files Type Files Type
32857 37988 1 S N N N 0 M A 0 Files Type Files Type
32858 37989 0 S N N N 0 M A 0 Files Type Files Type
32859 37990 0 S N N N 0 M A 0 Files Type Files Type
32860 37991 0 S N N N 0 M A 0 Files Type Files Type
32861 37992 0 S N N N 0 M A 0 Files Type Files Type
32862 37993 0 S N N N 0 M A 0 Files Type Files Type
32863 37994 0 S N N N 0 M A 0 Files Type Files Type
32864 37995 0 S N N N 0 M A 0 Files Type Files Type
32865 37996 0 S N N N 0 M A 0 Files Type Files Type
32866 37997 0 S N N N 0 M A 0 Files Type Files Type
32867 37998 0 S N N N 0 M A 0 Files Type Files Type
32868 37999 0 S N N N 0 M A 0 Files Type Files Type
32869 38000 0 S N N N 0 M A 0 Files Type Files Type
32870 38001 0 S N N N 0 M A 0 Files Type Files Type
32871 38002 0 S N N N 0 M A 0 Files Type Files Type
32872 38003 0 S N N N 0 M A 0 Files Type Files Type
32873 38004 0 S N N N 0 M A 0 Files Type Files Type
32874 38005 0 S N N N 0 M A 0 Files Type Files Type
32875 38006 0 S N N N 0 M A 0 Files Type Files Type
32876 38007 0 S N N N 0 M A 0 Files Type Files Type
32877 38008 0 S N N N 0 M A 0 Files Type Files Type
32878 38009 0 S N N N 0 M A 0 Files Type Files Type
32879 38010 0 S N N N 0 M A 0 Files Type Files Type
32880 38011 0 S N N N 0 M A 0 Files Type Files Type
32881 38012 0 S N N N 0 M A 0 Files Type Files Type
32882 38013 0 S N N N 0 M A 0 Files Type Files Type
32883 38014 0 S N N N 0 M A 0 Files Type Files Type
32884 38015 0 S N N N 0 M A 0 Files Type Files Type
32885 38016 0 S N N N 0 M A 0 Files Type Files Type
32886 38017 0 S N N N 0 M A 0 Files Type Files Type
32887 38018 0 S N N N 0 M A 0 Files Type Files Type
32888 38019 0 S N N N 0 M A 0 Files Type Files Type
32889 38020 0 S N N N 0 M A 0 Files Type Files Type
32890 38021 0 S N N N 0 M A 0 Files Type Files Type
32891 38022 0 S N N N 0 M A 0 Files Type Files Type
32894 38025 0 S N N N 0 M A 0 Files Type Files Type
32895 38026 0 S N N N 0 M A 0 Files Type Files Type
32896 38027 0 S N N N 0 M A 0 Files Type Files Type
32897 38028 0 S N N N 0 M A 0 Files Type Files Type
32898 38029 0 S N N N 0 M A 0 Files Type Files Type
32899 38030 0 S N N N 0 M A 0 Files Type Files Type
32900 38031 0 S N N N 0 M A 0 Files Type Files Type
32901 38032 0 S N N N 0 M A 0 Files Type Files Type
32902 38033 0 S N N N 0 M A 0 Files Type Files Type
32903 38034 0 S N N N 0 M A 0 Files Type Files Type
32905 38036 0 S N N N 0 M A 0 Files Type Files Type
32906 38037 0 S N N N 0 M A 0 Files Type Files Type
32910 38042 0 S N N N 0 M A 0 Files Type Files Type
32911 38043 0 S N N N 0 M A 0 Files Type Files Type
32929 38062 1 S N N N 0 M A 0 Files Type Files Type
32934 38067 1 S N N N 0 M A 0 Files Type Files Type
33708 38872 0 S N N N 0 M A 0 Files Type Files Type
32943 38076 1 S N N N 0 M A 0 Files Type Files Type
32944 38077 0 S N N N 0 M A 0 Files Type Files Type
32945 38078 0 S N N N 0 M A 0 Files Type Files Type
33720 38884 0 S N N N 0 M A 0 Files Type Files Type
35279 40512 0 S N N N 0 M A 0 Files Type Files Type
33256 38399 1 S N N N 0 M A 0 Files Type Files Type
33257 38400 0 S N N N 0 M A 0 Files Type Files Type
35058 40283 0 S N N N 0 M A 0 Files Type Files Type
33274 38417 0 S N N N 0 M A 0 Files Type Files Type
33275 38418 1 S N N N 0 M A 0 Files Type Files Type
33276 38419 1 S N N N 0 M A 0 Files Type Files Type
33277 38420 0 S N N N 0 M A 0 Files Type Files Type
33278 38421 0 S N N N 0 M A 0 Files Type Files Type
33023 38159 1 S N N N 0 M A 0 Files Type Files Type
33279 38422 0 S N N N 0 M A 0 Files Type Files Type