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 (
    10556, 
    10101, 
    10558, 
    10142, 
    10134, 
    10141, 
    10053, 
    10138, 
    10130, 
    9934, 
    10563, 
    10569, 
    10572, 
    10602, 
    10603, 
    10137, 
    12517, 
    12531, 
    12526, 
    12509, 
    10226, 
    10551, 
    10550, 
    10193, 
    10659, 
    10664, 
    10666, 
    10661, 
    10663, 
    10190, 
    10657, 
    10658, 
    10194, 
    10692, 
    12530, 
    12516, 
    12496, 
    12519, 
    12510, 
    10087, 
    10100, 
    10698, 
    10478, 
    9883, 
    9901, 
    10493, 
    10485, 
    10476, 
    10479, 
    10494, 
    10492, 
    10468, 
    9903, 
    10487, 
    9899, 
    10473, 
    10486, 
    9881, 
    9896, 
    9892, 
    10481, 
    9876, 
    10474, 
    10491, 
    10489, 
    10471, 
    9880, 
    10472, 
    9885, 
    10488, 
    9897, 
    9895, 
    10467, 
    9900, 
    10470, 
    10466, 
    10477, 
    9889, 
    10475, 
    9890, 
    10483, 
    10495, 
    10490, 
    10469, 
    9877, 
    9894, 
    9891, 
    10480, 
    9893, 
    9878, 
    9886, 
    9882, 
    9888, 
    10482, 
    13091, 
    12551, 
    12638, 
    12634, 
    12636, 
    12635, 
    12599, 
    12627, 
    12600, 
    12639, 
    15800, 
    12595, 
    12587, 
    12593, 
    12620, 
    12623, 
    12619, 
    12585, 
    12616, 
    12601, 
    12628, 
    12602, 
    12640, 
    12647, 
    12588, 
    12605, 
    12606, 
    12637, 
    12612, 
    12613, 
    12641, 
    12554, 
    12552, 
    12642
  ) 
  AND a.product_id = 0 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00123

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 (10556,10101,10558,10142,10134,10141,10053,10138,10130,9934,10563,10569,10572,10602,10603,10137,12517,12531,12526,12509,10226,10551,10550,10193,10659,10664,10666,10661,10663,10190,10657,10658,10194,10692,12530,12516,12496,12519,12510,10087,10100,10698,10478,9883,9901,10493,10485,10476,10479,10494,10492,10468,9903,10487,9899,10473,10486,9881,9896,9892,10481,9876,10474,10491,10489,10471,9880,10472,9885,10488,9897,9895,10467,9900,10470,10466,10477,9889,10475,9890,10483,10495,10490,10469,9877,9894,9891,10480,9893,9878,9886,9882,9888,10482,13091,12551,12638,12634,12636,12635,12599,12627,12600,12639,15800,12595,12587,12593,12620,12623,12619,12585,12616,12601,12628,12602,12640,12647,12588,12605,12606,12637,12612,12613,12641,12554,12552,12642)",
      "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
    }
  }
}