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 (
    88461, 88412, 88396, 89357, 89198, 88514, 
    88484, 88483, 88482, 88463, 88462, 
    89197, 89196, 89013, 89012, 89011, 
    88992, 88991, 88990, 88989, 88988, 
    88987, 88986, 88985, 88984, 88983, 
    88982, 88952, 88951, 88950, 88949, 
    88948, 88947, 88946, 88841, 88840, 
    88831, 88830, 88829, 88828
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00117

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
83473 88828 1 S N N N 0 M A 0 Files Type Files Type
83474 88829 1 S N N N 0 M A 0 Files Type Files Type
83475 88830 1 S N N N 0 M A 0 Files Type Files Type
83987 89357 1 S N N N 0 M A 0 Files Type Files Type
83476 88831 1 S N N N 0 M A 0 Files Type Files Type
83485 88840 1 S N N N 0 M A 0 Files Type Files Type
83486 88841 1 S N N N 0 M A 0 Files Type Files Type
83051 88396 1 S N N N 0 M A 0 Files Type Files Type
83830 89196 1 S N N N 0 M A 0 Files Type Files Type
83831 89197 1 S N N N 0 M A 0 Files Type Files Type
83832 89198 1 S N N N 0 M A 0 Files Type Files Type
83067 88412 1 S N N N 0 M A 0 Files Type Files Type
83587 88946 1 S N N N 0 M A 0 Files Type Files Type
83588 88947 1 S N N N 0 M A 0 Files Type Files Type
83589 88948 1 S N N N 0 M A 0 Files Type Files Type
83590 88949 1 S N N N 0 M A 0 Files Type Files Type
83591 88950 1 S N N N 0 M A 0 Files Type Files Type
83592 88951 1 S N N N 0 M A 0 Files Type Files Type
83593 88952 1 S N N N 0 M A 0 Files Type Files Type
83623 88982 1 S N N N 0 M A 0 Files Type Files Type
83624 88983 1 S N N N 0 M A 0 Files Type Files Type
83625 88984 1 S N N N 0 M A 0 Files Type Files Type
83114 88461 1 S N N N 0 M A 0 Files Type Files Type
83626 88985 1 S N N N 0 M A 0 Files Type Files Type
83115 88462 1 S N N N 0 M A 0 Files Type Files Type
83627 88986 1 S N N N 0 M A 0 Files Type Files Type
83116 88463 1 S N N N 0 M A 0 Files Type Files Type
83628 88987 1 S N N N 0 M A 0 Files Type Files Type
83629 88988 1 S N N N 0 M A 0 Files Type Files Type
83630 88989 1 S N N N 0 M A 0 Files Type Files Type
83631 88990 1 S N N N 0 M A 0 Files Type Files Type
83632 88991 1 S N N N 0 M A 0 Files Type Files Type
83633 88992 1 S N N N 0 M A 0 Files Type Files Type
83134 88482 1 S N N N 0 M A 0 Files Type Files Type
83135 88483 1 S N N N 0 M A 0 Files Type Files Type
83136 88484 1 S N N N 0 M A 0 Files Type Files Type
83652 89011 1 S N N N 0 M A 0 Files Type Files Type
83653 89012 1 S N N N 0 M A 0 Files Type Files Type
83654 89013 1 S N N N 0 M A 0 Files Type Files Type
83165 88514 1 S N N N 0 M A 0 Files Type Files Type