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 (
    9824, 
    9825, 
    9826, 
    9827, 
    9828, 
    9829, 
    9830, 
    10241, 
    10242, 
    10243, 
    10244, 
    10245, 
    10246, 
    10247, 
    10248, 
    10249, 
    10250, 
    10251, 
    10252, 
    10253, 
    10254, 
    10255, 
    10256, 
    10257, 
    10258, 
    10259, 
    10260, 
    10261, 
    10713, 
    10714, 
    10715, 
    10716, 
    10717, 
    10718, 
    10719, 
    10720, 
    10721, 
    10722, 
    10723, 
    10739, 
    10740, 
    10741, 
    10742, 
    10305, 
    10306, 
    10307, 
    10308, 
    10309, 
    10310, 
    10311, 
    10312, 
    12999, 
    13000, 
    13001, 
    13002, 
    13003, 
    13004, 
    13005, 
    13006, 
    13007, 
    13008, 
    13009, 
    13010, 
    13011, 
    13012, 
    10759, 
    10760, 
    10761, 
    10762, 
    10763, 
    10764, 
    10765, 
    10766, 
    9874, 
    9875, 
    9887, 
    9879, 
    9796, 
    9942, 
    9943, 
    9941, 
    9944, 
    10813, 
    10814, 
    10815, 
    10816, 
    10817, 
    10818, 
    10819, 
    10820, 
    10821, 
    10822, 
    10823, 
    10824, 
    10825, 
    10826, 
    12969, 
    10144, 
    10145, 
    10146, 
    10147, 
    10148, 
    10149, 
    10150, 
    10151, 
    10152, 
    10293, 
    10294, 
    10295, 
    10724, 
    10725, 
    10343, 
    10345, 
    10346, 
    10347, 
    10348, 
    10349, 
    10350, 
    10351, 
    10352, 
    10353, 
    10354, 
    10355, 
    10356, 
    10357, 
    10358, 
    10359, 
    10360
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00098

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 (9824,9825,9826,9827,9828,9829,9830,10241,10242,10243,10244,10245,10246,10247,10248,10249,10250,10251,10252,10253,10254,10255,10256,10257,10258,10259,10260,10261,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10739,10740,10741,10742,10305,10306,10307,10308,10309,10310,10311,10312,12999,13000,13001,13002,13003,13004,13005,13006,13007,13008,13009,13010,13011,13012,10759,10760,10761,10762,10763,10764,10765,10766,9874,9875,9887,9879,9796,9942,9943,9941,9944,10813,10814,10815,10816,10817,10818,10819,10820,10821,10822,10823,10824,10825,10826,12969,10144,10145,10146,10147,10148,10149,10150,10151,10152,10293,10294,10295,10724,10725,10343,10345,10346,10347,10348,10349,10350,10351,10352,10353,10354,10355,10356,10357,10358,10359,10360) 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
    }
  }
}