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 (
    68835, 69400, 69349, 69324, 69291, 69257, 
    69256, 69255, 69123, 68831, 68697, 
    68696, 68879, 68906, 68576, 69176, 
    69175, 69174, 69033, 67842, 69173, 
    69172, 69100, 69099, 69032, 69022, 
    68905, 68408, 68368, 68367, 68695, 
    68547, 68555, 68904, 68903, 68834, 
    68833, 68725, 68605, 68292
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00145

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
64279 69022 1 S N N N 0 M A 0 Files Type Files Type
64540 69291 1 S N N N 0 M A 0 Files Type Files Type
64289 69032 1 S N N N 0 M A 0 Files Type Files Type
64290 69033 1 S N N N 0 M A 0 Files Type Files Type
64572 69324 1 S N N N 0 M A 0 Files Type Files Type
63818 68547 1 S N N N 0 M A 0 Files Type Files Type
63826 68555 1 S N N N 0 M A 0 Files Type Files Type
63571 68292 1 S N N N 0 M A 0 Files Type Files Type
64596 69349 1 S N N N 0 M A 0 Files Type Files Type
64095 68831 1 S N N N 0 M A 0 Files Type Files Type
64097 68833 1 S N N N 0 M A 0 Files Type Files Type
64098 68834 1 S N N N 0 M A 0 Files Type Files Type
64354 69099 1 S N N N 0 M A 0 Files Type Files Type
64099 68835 1 S N N N 0 M A 0 Files Type Files Type
64355 69100 1 S N N N 0 M A 0 Files Type Files Type
63847 68576 1 S N N N 0 M A 0 Files Type Files Type
64377 69123 1 S N N N 0 M A 0 Files Type Files Type
63876 68605 1 S N N N 0 M A 0 Files Type Files Type
64646 69400 1 S N N N 0 M A 0 Files Type Files Type
64141 68879 1 S N N N 0 M A 0 Files Type Files Type
63133 67842 1 S N N N 0 M A 0 Files Type Files Type
63645 68367 1 S N N N 0 M A 0 Files Type Files Type
63646 68368 1 S N N N 0 M A 0 Files Type Files Type
64164 68903 1 S N N N 0 M A 0 Files Type Files Type
64165 68904 1 S N N N 0 M A 0 Files Type Files Type
64166 68905 1 S N N N 0 M A 0 Files Type Files Type
64167 68906 1 S N N N 0 M A 0 Files Type Files Type
64424 69172 1 S N N N 0 M A 0 Files Type Files Type
64425 69173 1 S N N N 0 M A 0 Files Type Files Type
64426 69174 1 S N N N 0 M A 0 Files Type Files Type
64427 69175 1 S N N N 0 M A 0 Files Type Files Type
64428 69176 1 S N N N 0 M A 0 Files Type Files Type
63685 68408 1 S N N N 0 M A 0 Files Type Files Type
63963 68695 1 S N N N 0 M A 0 Files Type Files Type
63964 68696 1 S N N N 0 M A 0 Files Type Files Type
63965 68697 1 S N N N 0 M A 0 Files Type Files Type
63992 68725 1 S N N N 0 M A 0 Files Type Files Type
64505 69255 1 S N N N 0 M A 0 Files Type Files Type
64506 69256 1 S N N N 0 M A 0 Files Type Files Type
64507 69257 1 S N N N 0 M A 0 Files Type Files Type