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 (
    40629, 79914, 40775, 40774, 40621, 40620, 
    40616, 40948, 40187, 40186, 40185, 
    40779, 40778, 40231, 40174, 79928, 
    40167, 40166, 40165, 40531, 40773, 
    40772, 40157, 40156, 40152, 40151, 
    40150, 40069, 40111, 40110, 40857, 
    40106, 40102, 40101, 40099, 40098, 
    40097, 40096, 40088, 40087, 40081, 
    40092, 40007, 40006, 40005, 39997, 
    39994, 39982, 39980, 39977, 39976, 
    39975, 39974, 39973, 39972, 39971, 
    39970, 39969, 39968, 39967, 39966, 
    39962, 39950, 79918, 40105, 39991, 
    39960, 39923, 39916, 39907, 39906, 
    91051, 91050, 91049, 91048, 91047, 
    91046, 91045, 91044, 91043
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00143

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
35615 40857 1 S N N N 0 M A 0 Files Type Files Type
34849 40069 1 S N N N 0 M A 0 Files Type Files Type
34859 40081 1 S N N N 0 M A 0 Files Type Files Type
34865 40087 1 S N N N 0 M A 0 Files Type Files Type
34866 40088 1 S N N N 0 M A 0 Files Type Files Type
35380 40616 1 S N N N 0 M A 0 Files Type Files Type
34870 40092 0 S N N N 0 M A 0 Files Type Files Type
35384 40620 0 S N N N 0 M A 0 Files Type Files Type
35385 40621 1 S N N N 0 M A 0 Files Type Files Type
34874 40096 0 S N N N 0 M A 0 Files Type Files Type
34875 40097 0 S N N N 0 M A 0 Files Type Files Type
34876 40098 0 S N N N 0 M A 0 Files Type Files Type
34877 40099 0 S N N N 0 M A 0 Files Type Files Type
34879 40101 0 S N N N 0 M A 0 Files Type Files Type
34880 40102 0 S N N N 0 M A 0 Files Type Files Type
35393 40629 1 S N N N 0 M A 0 Files Type Files Type
34883 40105 1 S N N N 0 M A 0 Files Type Files Type
34884 40106 1 S N N N 0 M A 0 Files Type Files Type
34888 40110 0 S N N N 0 M A 0 Files Type Files Type
34889 40111 0 S N N N 0 M A 0 Files Type Files Type
74833 79914 1 S N N N 0 M A 0 Files Type Files Type
74837 79918 1 S N N N 0 M A 0 Files Type Files Type
74847 79928 1 S N N N 0 M A 0 Files Type Files Type
34928 40150 0 S N N N 0 M A 0 Files Type Files Type
34929 40151 0 S N N N 0 M A 0 Files Type Files Type
85618 91043 1 S N N N 0 M A 0 Files Type Files Type
34930 40152 0 S N N N 0 M A 0 Files Type Files Type
85619 91044 1 S N N N 0 M A 0 Files Type Files Type
85620 91045 1 S N N N 0 M A 0 Files Type Files Type
85621 91046 1 S N N N 0 M A 0 Files Type Files Type
85622 91047 1 S N N N 0 M A 0 Files Type Files Type
34934 40156 0 S N N N 0 M A 0 Files Type Files Type
35702 40948 0 S N N N 0 M A 0 Files Type Files Type
85623 91048 1 S N N N 0 M A 0 Files Type Files Type
34935 40157 1 S N N N 0 M A 0 Files Type Files Type
85624 91049 1 S N N N 0 M A 0 Files Type Files Type
85625 91050 1 S N N N 0 M A 0 Files Type Files Type
85626 91051 1 S N N N 0 M A 0 Files Type Files Type
34943 40165 1 S N N N 0 M A 0 Files Type Files Type
34944 40166 1 S N N N 0 M A 0 Files Type Files Type
34689 39906 1 S N N N 0 M A 0 Files Type Files Type
34945 40167 0 S N N N 0 M A 0 Files Type Files Type
34690 39907 0 S N N N 0 M A 0 Files Type Files Type
34952 40174 1 S N N N 0 M A 0 Files Type Files Type
34699 39916 0 S N N N 0 M A 0 Files Type Files Type
34705 39923 1 S N N N 0 M A 0 Files Type Files Type
34963 40185 0 S N N N 0 M A 0 Files Type Files Type
34964 40186 0 S N N N 0 M A 0 Files Type Files Type
34965 40187 1 S N N N 0 M A 0 Files Type Files Type
34731 39950 0 S N N N 0 M A 0 Files Type Files Type
34741 39960 1 S N N N 0 M A 0 Files Type Files Type
34743 39962 1 S N N N 0 M A 0 Files Type Files Type
34747 39966 0 S N N N 0 M A 0 Files Type Files Type
34748 39967 0 S N N N 0 M A 0 Files Type Files Type
34749 39968 0 S N N N 0 M A 0 Files Type Files Type
34750 39969 0 S N N N 0 M A 0 Files Type Files Type
34751 39970 0 S N N N 0 M A 0 Files Type Files Type
35007 40231 1 S N N N 0 M A 0 Files Type Files Type
34752 39971 0 S N N N 0 M A 0 Files Type Files Type
34753 39972 0 S N N N 0 M A 0 Files Type Files Type
34754 39973 0 S N N N 0 M A 0 Files Type Files Type
34755 39974 0 S N N N 0 M A 0 Files Type Files Type
34756 39975 1 S N N N 0 M A 0 Files Type Files Type
34757 39976 0 S N N N 0 M A 0 Files Type Files Type
34758 39977 0 S N N N 0 M A 0 Files Type Files Type
34760 39980 0 S N N N 0 M A 0 Files Type Files Type
34762 39982 0 S N N N 0 M A 0 Files Type Files Type
35532 40772 1 S N N N 0 M A 0 Files Type Files Type
35533 40773 0 S N N N 0 M A 0 Files Type Files Type
35534 40774 1 S N N N 0 M A 0 Files Type Files Type
35535 40775 1 S N N N 0 M A 0 Files Type Files Type
35538 40778 0 S N N N 0 M A 0 Files Type Files Type
34771 39991 0 S N N N 0 M A 0 Files Type Files Type
35539 40779 1 S N N N 0 M A 0 Files Type Files Type
34774 39994 1 S N N N 0 M A 0 Files Type Files Type
34777 39997 0 S N N N 0 M A 0 Files Type Files Type
34785 40005 0 S N N N 0 M A 0 Files Type Files Type
34786 40006 1 S N N N 0 M A 0 Files Type Files Type
35298 40531 0 S N N N 0 M A 0 Files Type Files Type
34787 40007 1 S N N N 0 M A 0 Files Type Files Type