SELECT 
  c.product_id AS cur_product_id, 
  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' 
  LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id 
  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 
  c.product_id IN (
    10071, 
    10067, 
    10051, 
    10060, 
    10055, 
    10043, 
    10068, 
    10065, 
    10061, 
    10050, 
    10056, 
    10044, 
    10069, 
    10066, 
    12671, 
    12672, 
    15779, 
    12673, 
    12674, 
    12675, 
    12676, 
    12677, 
    12678, 
    12679, 
    9687, 
    10024, 
    10025, 
    10026, 
    10027, 
    10028, 
    10029, 
    10030, 
    10031, 
    10032, 
    10033, 
    10034, 
    10035, 
    10036, 
    10037, 
    10038, 
    10039, 
    10040, 
    10756, 
    10757, 
    10758, 
    10397, 
    10398, 
    10399, 
    10400, 
    10401, 
    10402, 
    12700, 
    12546, 
    12633, 
    12573, 
    12548, 
    12580, 
    12576, 
    12565, 
    12567, 
    12549, 
    12581, 
    12557, 
    12558, 
    12570, 
    12578, 
    12568, 
    12547, 
    12569, 
    12584, 
    12592, 
    12575, 
    12574, 
    12550, 
    12544, 
    12564, 
    12577, 
    12579, 
    12555, 
    12560, 
    12556, 
    12561, 
    12572, 
    12583, 
    12591, 
    12582, 
    12590, 
    12571, 
    12632, 
    12559, 
    12631, 
    10596, 
    10597, 
    10598, 
    10599, 
    10600, 
    10521, 
    10520, 
    10519, 
    10518, 
    10517, 
    10516, 
    10515, 
    10514, 
    10513, 
    10512, 
    10511, 
    10510, 
    10509, 
    10508, 
    10507, 
    10506, 
    10505, 
    10504, 
    10503, 
    10502, 
    10501, 
    10500, 
    10499, 
    10498, 
    10497, 
    9839, 
    12702, 
    9841, 
    9848, 
    9840, 
    9844, 
    9843
  ) 
  AND a.product_id = 0 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00096

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": 71.42857361,
          "attached_condition": "a.product_id = 0 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": "c",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["option_id"],
      "ref": ["noframes_angrybeaver.a.option_id"],
      "rows": 1,
      "filtered": 91.42857361,
      "attached_condition": "c.product_id in (10071,10067,10051,10060,10055,10043,10068,10065,10061,10050,10056,10044,10069,10066,12671,12672,15779,12673,12674,12675,12676,12677,12678,12679,9687,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10039,10040,10756,10757,10758,10397,10398,10399,10400,10401,10402,12700,12546,12633,12573,12548,12580,12576,12565,12567,12549,12581,12557,12558,12570,12578,12568,12547,12569,12584,12592,12575,12574,12550,12544,12564,12577,12579,12555,12560,12556,12561,12572,12583,12591,12582,12590,12571,12632,12559,12631,10596,10597,10598,10599,10600,10521,10520,10519,10518,10517,10516,10515,10514,10513,10512,10511,10510,10509,10508,10507,10506,10505,10504,10503,10502,10501,10500,10499,10498,10497,9839,12702,9841,9848,9840,9844,9843)",
      "using_index": true
    },
    "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
    }
  }
}