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 (
    15492, 15490, 31006, 31005, 31004, 31003, 
    31002, 31001, 31000, 30999, 30998, 
    30997, 30996, 30995, 30994, 30993, 
    30992, 30991, 30990, 30989, 30988, 
    30987, 30986, 30985, 30984, 30983, 
    30982, 15502, 15457, 15337, 15336, 
    15335, 15334, 15333, 15332, 15331, 
    15330, 15329, 15328, 15327
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00191

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range PRIMARY,c_status c_status 6 40 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
26112 30998 1 S N N N 0 M A 0 Files Type Files Type
26113 30999 1 S N N N 0 M A 0 Files Type Files Type
26114 31000 1 S N N N 0 M A 0 Files Type Files Type
26115 31001 1 S N N N 0 M A 0 Files Type Files Type
26116 31002 1 S N N N 0 M A 0 Files Type Files Type
26117 31003 1 S N N N 0 M A 0 Files Type Files Type
26118 31004 1 S N N N 0 M A 0 Files Type Files Type
26119 31005 1 S N N N 0 M A 0 Files Type Files Type
26120 31006 1 S N N N 0 M A 0 Files Type Files Type
10802 15457 1 S N N N 0 M A 0 Files Type Files Type
10833 15490 1 S N N N 0 M A 0 Files Type Files Type
10835 15492 1 S N N N 0 M A 0 Files Type Files Type
10844 15502 1 S N N N 0 M A 0 Files Type Files Type
10677 15327 1 S N N N 0 M A 0 Files Type Files Type
10678 15328 1 S N N N 0 M A 0 Files Type Files Type
10679 15329 1 S N N N 0 M A 0 Files Type Files Type
10680 15330 1 S N N N 0 M A 0 Files Type Files Type
10681 15331 1 S N N N 0 M A 0 Files Type Files Type
10682 15332 1 S N N N 0 M A 0 Files Type Files Type
10683 15333 1 S N N N 0 M A 0 Files Type Files Type
10684 15334 1 S N N N 0 M A 0 Files Type Files Type
10685 15335 1 S N N N 0 M A 0 Files Type Files Type
10686 15336 1 S N N N 0 M A 0 Files Type Files Type
10687 15337 1 S N N N 0 M A 0 Files Type Files Type
26096 30982 1 S N N N 0 M A 0 Files Type Files Type
26097 30983 1 S N N N 0 M A 0 Files Type Files Type
26098 30984 1 S N N N 0 M A 0 Files Type Files Type
26099 30985 1 S N N N 0 M A 0 Files Type Files Type
26100 30986 1 S N N N 0 M A 0 Files Type Files Type
26101 30987 1 S N N N 0 M A 0 Files Type Files Type
26102 30988 1 S N N N 0 M A 0 Files Type Files Type
26103 30989 1 S N N N 0 M A 0 Files Type Files Type
26104 30990 1 S N N N 0 M A 0 Files Type Files Type
26105 30991 1 S N N N 0 M A 0 Files Type Files Type
26106 30992 1 S N N N 0 M A 0 Files Type Files Type
26107 30993 1 S N N N 0 M A 0 Files Type Files Type
26108 30994 1 S N N N 0 M A 0 Files Type Files Type
26109 30995 1 S N N N 0 M A 0 Files Type Files Type
26110 30996 1 S N N N 0 M A 0 Files Type Files Type
26111 30997 1 S N N N 0 M A 0 Files Type Files Type