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 (
    68280, 68279, 68278, 68277, 68276, 68275, 
    68274, 68575, 68204, 68406, 68375, 
    78288, 78287, 78286, 78285, 78284, 
    78283, 78282, 78281, 78280, 78279, 
    78278, 78277, 78276, 78275, 78274, 
    78273, 78272, 78271, 78270, 78269, 
    78268, 78267, 78266, 78265, 78264, 
    78263, 78262, 68395, 68189
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00120

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
73219 78262 1 S N N N 0 M A 0 Files Type Files Type
73220 78263 1 S N N N 0 M A 0 Files Type Files Type
73221 78264 1 S N N N 0 M A 0 Files Type Files Type
73222 78265 1 S N N N 0 M A 0 Files Type Files Type
73223 78266 1 S N N N 0 M A 0 Files Type Files Type
73224 78267 1 S N N N 0 M A 0 Files Type Files Type
73225 78268 1 S N N N 0 M A 0 Files Type Files Type
73226 78269 1 S N N N 0 M A 0 Files Type Files Type
73227 78270 1 S N N N 0 M A 0 Files Type Files Type
73228 78271 1 S N N N 0 M A 0 Files Type Files Type
73229 78272 1 S N N N 0 M A 0 Files Type Files Type
73230 78273 1 S N N N 0 M A 0 Files Type Files Type
73231 78274 1 S N N N 0 M A 0 Files Type Files Type
73232 78275 1 S N N N 0 M A 0 Files Type Files Type
73233 78276 1 S N N N 0 M A 0 Files Type Files Type
73234 78277 1 S N N N 0 M A 0 Files Type Files Type
73235 78278 1 S N N N 0 M A 0 Files Type Files Type
73236 78279 1 S N N N 0 M A 0 Files Type Files Type
73237 78280 1 S N N N 0 M A 0 Files Type Files Type
73238 78281 1 S N N N 0 M A 0 Files Type Files Type
73239 78282 1 S N N N 0 M A 0 Files Type Files Type
73240 78283 1 S N N N 0 M A 0 Files Type Files Type
73241 78284 1 S N N N 0 M A 0 Files Type Files Type
73242 78285 1 S N N N 0 M A 0 Files Type Files Type
73243 78286 1 S N N N 0 M A 0 Files Type Files Type
73244 78287 1 S N N N 0 M A 0 Files Type Files Type
73245 78288 1 S N N N 0 M A 0 Files Type Files Type
63554 68274 1 S N N N 0 M A 0 Files Type Files Type
63555 68275 1 S N N N 0 M A 0 Files Type Files Type
63556 68276 1 S N N N 0 M A 0 Files Type Files Type
63557 68277 1 S N N N 0 M A 0 Files Type Files Type
63558 68278 1 S N N N 0 M A 0 Files Type Files Type
63559 68279 1 S N N N 0 M A 0 Files Type Files Type
63560 68280 1 S N N N 0 M A 0 Files Type Files Type
63846 68575 1 S N N N 0 M A 0 Files Type Files Type
63653 68375 1 S N N N 0 M A 0 Files Type Files Type
63672 68395 1 S N N N 0 M A 0 Files Type Files Type
63683 68406 1 S N N N 0 M A 0 Files Type Files Type
63472 68189 1 S N N N 0 M A 0 Files Type Files Type
63487 68204 1 S N N N 0 M A 0 Files Type Files Type