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 (
    88194, 88192, 88190, 88189, 88188, 88186, 
    88185, 88137, 88136, 88135, 88054, 
    88053, 88052, 88051, 88050, 87782, 
    87781, 87697, 87696, 87695, 87694, 
    87581, 88552, 88551, 88550, 88549, 
    88548, 88547, 88080, 87985, 88796, 
    88795, 88083, 87879, 87704, 87693, 
    87690, 87587, 87586, 87669
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00104

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
83200 88549 1 S N N N 0 M A 0 Files Type Files Type
83201 88550 1 S N N N 0 M A 0 Files Type Files Type
83202 88551 1 S N N N 0 M A 0 Files Type Files Type
83203 88552 1 S N N N 0 M A 0 Files Type Files Type
82457 87781 1 S N N N 0 M A 0 Files Type Files Type
82458 87782 1 S N N N 0 M A 0 Files Type Files Type
82720 88050 1 S N N N 0 M A 0 Files Type Files Type
82721 88051 1 S N N N 0 M A 0 Files Type Files Type
82722 88052 1 S N N N 0 M A 0 Files Type Files Type
82723 88053 1 S N N N 0 M A 0 Files Type Files Type
82724 88054 1 S N N N 0 M A 0 Files Type Files Type
82749 88080 1 S N N N 0 M A 0 Files Type Files Type
82752 88083 1 S N N N 0 M A 0 Files Type Files Type
82261 87581 1 S N N N 0 M A 0 Files Type Files Type
82266 87586 1 S N N N 0 M A 0 Files Type Files Type
82267 87587 1 S N N N 0 M A 0 Files Type Files Type
82802 88135 1 S N N N 0 M A 0 Files Type Files Type
82803 88136 1 S N N N 0 M A 0 Files Type Files Type
82804 88137 1 S N N N 0 M A 0 Files Type Files Type
82553 87879 1 S N N N 0 M A 0 Files Type Files Type
82848 88185 1 S N N N 0 M A 0 Files Type Files Type
82849 88186 1 S N N N 0 M A 0 Files Type Files Type
82851 88188 1 S N N N 0 M A 0 Files Type Files Type
82852 88189 1 S N N N 0 M A 0 Files Type Files Type
82853 88190 1 S N N N 0 M A 0 Files Type Files Type
82855 88192 1 S N N N 0 M A 0 Files Type Files Type
82857 88194 1 S N N N 0 M A 0 Files Type Files Type
82347 87669 1 S N N N 0 M A 0 Files Type Files Type
82368 87690 1 S N N N 0 M A 0 Files Type Files Type
82371 87693 1 S N N N 0 M A 0 Files Type Files Type
82372 87694 1 S N N N 0 M A 0 Files Type Files Type
82373 87695 1 S N N N 0 M A 0 Files Type Files Type
82374 87696 1 S N N N 0 M A 0 Files Type Files Type
82375 87697 1 S N N N 0 M A 0 Files Type Files Type
82382 87704 1 S N N N 0 M A 0 Files Type Files Type
82656 87985 1 S N N N 0 M A 0 Files Type Files Type
83440 88795 1 S N N N 0 M A 0 Files Type Files Type
83441 88796 1 S N N N 0 M A 0 Files Type Files Type
83198 88547 1 S N N N 0 M A 0 Files Type Files Type
83199 88548 1 S N N N 0 M A 0 Files Type Files Type