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 (
    95382, 95381, 95380, 95379, 95378, 95377, 
    95376, 95375, 95374, 95373, 95372, 
    95371, 95370, 94476, 94424, 94423, 
    94422, 94421, 94420, 94419, 94418, 
    94417, 94416, 94415, 94414, 94413, 
    94568, 94567, 94566, 94565, 94350, 
    94349, 94348, 94347, 94346, 94345, 
    94344, 94343, 94342, 94341
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00082

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
88832 94343 1 S N N N 0 M A 0 Files Type Files Type
88833 94344 1 S N N N 0 M A 0 Files Type Files Type
88834 94345 1 S N N N 0 M A 0 Files Type Files Type
88835 94346 1 S N N N 0 M A 0 Files Type Files Type
88836 94347 1 S N N N 0 M A 0 Files Type Files Type
88837 94348 1 S N N N 0 M A 0 Files Type Files Type
88838 94349 1 S N N N 0 M A 0 Files Type Files Type
88839 94350 1 S N N N 0 M A 0 Files Type Files Type
88902 94413 1 S N N N 0 M A 0 Files Type Files Type
88903 94414 1 S N N N 0 M A 0 Files Type Files Type
88904 94415 1 S N N N 0 M A 0 Files Type Files Type
88905 94416 1 S N N N 0 M A 0 Files Type Files Type
88906 94417 1 S N N N 0 M A 0 Files Type Files Type
88907 94418 1 S N N N 0 M A 0 Files Type Files Type
88908 94419 1 S N N N 0 M A 0 Files Type Files Type
88909 94420 1 S N N N 0 M A 0 Files Type Files Type
88910 94421 1 S N N N 0 M A 0 Files Type Files Type
88911 94422 1 S N N N 0 M A 0 Files Type Files Type
88912 94423 1 S N N N 0 M A 0 Files Type Files Type
88913 94424 1 S N N N 0 M A 0 Files Type Files Type
88962 94476 1 S N N N 0 M A 0 Files Type Files Type
89049 94565 1 S N N N 0 M A 0 Files Type Files Type
89050 94566 1 S N N N 0 M A 0 Files Type Files Type
89051 94567 1 S N N N 0 M A 0 Files Type Files Type
89052 94568 1 S N N N 0 M A 0 Files Type Files Type
89834 95370 1 S N N N 0 M A 0 Files Type Files Type
89835 95371 1 S N N N 0 M A 0 Files Type Files Type
89836 95372 1 S N N N 0 M A 0 Files Type Files Type
89837 95373 1 S N N N 0 M A 0 Files Type Files Type
89838 95374 1 S N N N 0 M A 0 Files Type Files Type
89839 95375 1 S N N N 0 M A 0 Files Type Files Type
89840 95376 1 S N N N 0 M A 0 Files Type Files Type
89841 95377 1 S N N N 0 M A 0 Files Type Files Type
89842 95378 1 S N N N 0 M A 0 Files Type Files Type
89843 95379 1 S N N N 0 M A 0 Files Type Files Type
89844 95380 1 S N N N 0 M A 0 Files Type Files Type
89845 95381 1 S N N N 0 M A 0 Files Type Files Type
89846 95382 1 S N N N 0 M A 0 Files Type Files Type
88830 94341 1 S N N N 0 M A 0 Files Type Files Type
88831 94342 1 S N N N 0 M A 0 Files Type Files Type