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 (
    47596, 47595, 47594, 47593, 47592, 47591, 
    47590, 47589, 47588, 47690, 47805, 
    47804, 47803, 47802, 47801, 47800, 
    47799, 47798, 47797, 47796, 47795, 
    47794, 47793, 47792, 47791, 47790, 
    47789, 47788, 47787, 47786, 47785, 
    47784, 47783, 47782, 47781, 47562, 
    47561, 47707, 47706, 47705, 47704, 
    47703, 47702, 47701, 47700, 51279, 
    47691, 47688, 47686, 47685, 47684, 
    47683, 47646, 47548, 47745, 47644, 
    47489, 47485, 47484, 47640, 47478, 
    47636, 47473, 47641, 47451, 47381, 
    47358, 47627, 47615, 47614, 47613, 
    47612, 47611, 47610, 47609, 47608, 
    47607, 47606, 47487, 47477
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00284

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range PRIMARY,c_status c_status 6 80 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
42246 47683 0 S N N N 0 M A 0 Files Type Files Type
42247 47684 0 S N N N 0 M A 0 Files Type Files Type
42248 47685 0 S N N N 0 M A 0 Files Type Files Type
42249 47686 0 S N N N 0 M A 0 Files Type Files Type
42251 47688 1 S N N N 0 M A 0 Files Type Files Type
42253 47690 1 S N N N 0 M A 0 Files Type Files Type
42254 47691 0 S N N N 0 M A 0 Files Type Files Type
42263 47700 0 S N N N 0 M A 0 Files Type Files Type
42264 47701 0 S N N N 0 M A 0 Files Type Files Type
42265 47702 0 S N N N 0 M A 0 Files Type Files Type
42266 47703 0 S N N N 0 M A 0 Files Type Files Type
42267 47704 0 S N N N 0 M A 0 Files Type Files Type
42268 47705 0 S N N N 0 M A 0 Files Type Files Type
42269 47706 0 S N N N 0 M A 0 Files Type Files Type
42270 47707 0 S N N N 0 M A 0 Files Type Files Type
42020 47451 1 S N N N 0 M A 0 Files Type Files Type
42041 47473 1 S N N N 0 M A 0 Files Type Files Type
42045 47477 1 S N N N 0 M A 0 Files Type Files Type
42046 47478 1 S N N N 0 M A 0 Files Type Files Type
42306 47745 0 S N N N 0 M A 0 Files Type Files Type
42052 47484 1 S N N N 0 M A 0 Files Type Files Type
42053 47485 1 S N N N 0 M A 0 Files Type Files Type
42055 47487 0 S N N N 0 M A 0 Files Type Files Type
42057 47489 1 S N N N 0 M A 0 Files Type Files Type
42341 47781 0 S N N N 0 M A 0 Files Type Files Type
42342 47782 0 S N N N 0 M A 0 Files Type Files Type
42343 47783 0 S N N N 0 M A 0 Files Type Files Type
42344 47784 0 S N N N 0 M A 0 Files Type Files Type
42345 47785 0 S N N N 0 M A 0 Files Type Files Type
42346 47786 0 S N N N 0 M A 0 Files Type Files Type
42347 47787 0 S N N N 0 M A 0 Files Type Files Type
42348 47788 0 S N N N 0 M A 0 Files Type Files Type
42349 47789 1 S N N N 0 M A 0 Files Type Files Type
42350 47790 0 S N N N 0 M A 0 Files Type Files Type
42351 47791 0 S N N N 0 M A 0 Files Type Files Type
42352 47792 0 S N N N 0 M A 0 Files Type Files Type
42353 47793 0 S N N N 0 M A 0 Files Type Files Type
42354 47794 0 S N N N 0 M A 0 Files Type Files Type
42355 47795 0 S N N N 0 M A 0 Files Type Files Type
42356 47796 0 S N N N 0 M A 0 Files Type Files Type
42357 47797 0 S N N N 0 M A 0 Files Type Files Type
42358 47798 0 S N N N 0 M A 0 Files Type Files Type
42359 47799 0 S N N N 0 M A 0 Files Type Files Type
42360 47800 0 S N N N 0 M A 0 Files Type Files Type
42361 47801 0 S N N N 0 M A 0 Files Type Files Type
42362 47802 0 S N N N 0 M A 0 Files Type Files Type
42363 47803 0 S N N N 0 M A 0 Files Type Files Type
42364 47804 0 S N N N 0 M A 0 Files Type Files Type
42365 47805 0 S N N N 0 M A 0 Files Type Files Type
42115 47548 1 S N N N 0 M A 0 Files Type Files Type
45704 51279 0 S N N N 0 M A 0 Files Type Files Type
42128 47561 1 S N N N 0 M A 0 Files Type Files Type
42129 47562 1 S N N N 0 M A 0 Files Type Files Type
42154 47588 0 S N N N 0 M A 0 Files Type Files Type
42155 47589 0 S N N N 0 M A 0 Files Type Files Type
42156 47590 0 S N N N 0 M A 0 Files Type Files Type
42157 47591 0 S N N N 0 M A 0 Files Type Files Type
42158 47592 0 S N N N 0 M A 0 Files Type Files Type
42159 47593 0 S N N N 0 M A 0 Files Type Files Type
42160 47594 0 S N N N 0 M A 0 Files Type Files Type
42161 47595 0 S N N N 0 M A 0 Files Type Files Type
42162 47596 0 S N N N 0 M A 0 Files Type Files Type
42171 47606 1 S N N N 0 M A 0 Files Type Files Type
42172 47607 0 S N N N 0 M A 0 Files Type Files Type
42173 47608 0 S N N N 0 M A 0 Files Type Files Type
42174 47609 0 S N N N 0 M A 0 Files Type Files Type
42175 47610 0 S N N N 0 M A 0 Files Type Files Type
42176 47611 0 S N N N 0 M A 0 Files Type Files Type
42177 47612 0 S N N N 0 M A 0 Files Type Files Type
42178 47613 1 S N N N 0 M A 0 Files Type Files Type
42179 47614 0 S N N N 0 M A 0 Files Type Files Type
42180 47615 0 S N N N 0 M A 0 Files Type Files Type
41930 47358 1 S N N N 0 M A 0 Files Type Files Type
42191 47627 0 S N N N 0 M A 0 Files Type Files Type
42200 47636 1 S N N N 0 M A 0 Files Type Files Type
42204 47640 1 S N N N 0 M A 0 Files Type Files Type
42205 47641 1 S N N N 0 M A 0 Files Type Files Type
42208 47644 1 S N N N 0 M A 0 Files Type Files Type
41953 47381 0 S N N N 0 M A 0 Files Type Files Type
42210 47646 1 S N N N 0 M A 0 Files Type Files Type