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 = 'ru' 
  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 (
    13018, 
    13017, 
    13016, 
    13015, 
    13014, 
    13013, 
    13012, 
    13011, 
    13010, 
    13009, 
    13008, 
    13007, 
    13006, 
    13005, 
    13004, 
    13003, 
    13002, 
    13001, 
    13000, 
    12999, 
    10812, 
    10811, 
    10810, 
    10809, 
    10808, 
    10807, 
    10806, 
    10805, 
    10804, 
    10803, 
    10802, 
    10801, 
    10800, 
    10799, 
    10798, 
    10797, 
    10796, 
    10795, 
    10794, 
    10793, 
    10792, 
    10791, 
    10790, 
    10789, 
    10788, 
    10787, 
    10786, 
    10785, 
    10784, 
    10783, 
    10782, 
    10781, 
    10780, 
    10779, 
    10778, 
    10777, 
    10776, 
    10775, 
    10774, 
    10773, 
    10772, 
    10771, 
    10770, 
    10769, 
    10768, 
    10767, 
    10766, 
    10765, 
    10764, 
    10763, 
    10762, 
    10761, 
    10760, 
    10759, 
    10758, 
    10757, 
    10756, 
    10755, 
    10754, 
    10753, 
    10752, 
    10751, 
    10750, 
    10749, 
    10748, 
    10747, 
    15736, 
    15737, 
    15738, 
    15739, 
    15740, 
    15741, 
    15742, 
    15743, 
    15745, 
    15746, 
    15744, 
    12632, 
    12633, 
    10179, 
    10180, 
    10523, 
    10073, 
    10077, 
    10076, 
    10086, 
    10085, 
    10084, 
    10083, 
    10082, 
    10081, 
    10080, 
    10079, 
    10584, 
    10594, 
    12574, 
    10168, 
    10167, 
    12703, 
    15968, 
    15938, 
    10053, 
    10041, 
    9904, 
    9905, 
    15966, 
    15965, 
    9940
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00159

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "a.position",
        "table": {
          "table_name": "a",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY", "c_status"],
          "rows": 7,
          "filtered": 100,
          "attached_condition": "a.product_id in (13018,13017,13016,13015,13014,13013,13012,13011,13010,13009,13008,13007,13006,13005,13004,13003,13002,13001,13000,12999,10812,10811,10810,10809,10808,10807,10806,10805,10804,10803,10802,10801,10800,10799,10798,10797,10796,10795,10794,10793,10792,10791,10790,10789,10788,10787,10786,10785,10784,10783,10782,10781,10780,10779,10778,10777,10776,10775,10774,10773,10772,10771,10770,10769,10768,10767,10766,10765,10764,10763,10762,10761,10760,10759,10758,10757,10756,10755,10754,10753,10752,10751,10750,10749,10748,10747,15736,15737,15738,15739,15740,15741,15742,15743,15745,15746,15744,12632,12633,10179,10180,10523,10073,10077,10076,10086,10085,10084,10083,10082,10081,10080,10079,10584,10594,12574,10168,10167,12703,15968,15938,10053,10041,9904,9905,15966,15965,9940) and a.`status` = 'A'"
        }
      }
    },
    "table": {
      "table_name": "b",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["option_id", "lang_code"],
      "ref": ["noframes_angrybeaver.a.option_id", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(b.lang_code = 'ru')"
    },
    "table": {
      "table_name": "cscart_ult_objects_sharing",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "159",
      "used_key_parts": [
        "share_object_id",
        "share_company_id",
        "share_object_type"
      ],
      "ref": ["noframes_angrybeaver.a.option_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "cscart_ult_objects_sharing.share_object_id = a.option_id and cscart_ult_objects_sharing.share_object_type = 'product_options'",
      "using_index": true
    }
  }
}