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 (
    61885, 61787, 61767, 61766, 61519, 61518, 
    61116, 60266, 59324, 61789, 61788, 
    61217, 59956, 61633, 61112, 61007, 
    61006, 60975, 60963, 60854, 60265, 
    61632, 61613, 61523, 61583, 61565, 
    58785, 61509, 61418, 61407, 61406, 
    61391, 61016, 60853, 60264, 59808, 
    61508, 60867, 61409, 61157
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00131

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
55553 61613 0 S N N N 0 M A 0 Files Type Files Type
55809 61885 0 S N N N 0 M A 0 Files Type Files Type
55571 61632 1 S N N N 0 M A 0 Files Type Files Type
55572 61633 1 S N N N 0 M A 0 Files Type Files Type
55073 61112 0 S N N N 0 M A 0 Files Type Files Type
55077 61116 0 S N N N 0 M A 0 Files Type Files Type
54828 60853 0 S N N N 0 M A 0 Files Type Files Type
55340 61391 1 S N N N 0 M A 0 Files Type Files Type
54829 60854 0 S N N N 0 M A 0 Files Type Files Type
54842 60867 1 S N N N 0 M A 0 Files Type Files Type
55355 61406 1 S N N N 0 M A 0 Files Type Files Type
55356 61407 1 S N N N 0 M A 0 Files Type Files Type
55358 61409 1 S N N N 0 M A 0 Files Type Files Type
53825 59808 0 S N N N 0 M A 0 Files Type Files Type
55366 61418 1 S N N N 0 M A 0 Files Type Files Type
55117 61157 0 S N N N 0 M A 0 Files Type Files Type
53361 59324 0 S N N N 0 M A 0 Files Type Files Type
119410 61583 1 S N N N 0 M A 0 Files Type Files Type
52866 58785 1 S N N N 0 M A 0 Files Type Files Type
55172 61217 0 S N N N 0 M A 0 Files Type Files Type
55693 61766 1 S N N N 0 M A 0 Files Type Files Type
55694 61767 0 S N N N 0 M A 0 Files Type Files Type
54933 60963 0 S N N N 0 M A 0 Files Type Files Type
55451 61508 0 S N N N 0 M A 0 Files Type Files Type
55452 61509 0 S N N N 0 M A 0 Files Type Files Type
54945 60975 0 S N N N 0 M A 0 Files Type Files Type
55714 61787 1 S N N N 0 M A 0 Files Type Files Type
55715 61788 0 S N N N 0 M A 0 Files Type Files Type
55716 61789 0 S N N N 0 M A 0 Files Type Files Type
55461 61518 0 S N N N 0 M A 0 Files Type Files Type
55462 61519 0 S N N N 0 M A 0 Files Type Files Type
55466 61523 1 S N N N 0 M A 0 Files Type Files Type
54973 61006 1 S N N N 0 M A 0 Files Type Files Type
54974 61007 1 S N N N 0 M A 0 Files Type Files Type
54983 61016 0 S N N N 0 M A 0 Files Type Files Type
53968 59956 0 S N N N 0 M A 0 Files Type Files Type
55507 61565 0 S N N N 0 M A 0 Files Type Files Type
54269 60264 0 S N N N 0 M A 0 Files Type Files Type
54270 60265 0 S N N N 0 M A 0 Files Type Files Type
54271 60266 0 S N N N 0 M A 0 Files Type Files Type