SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    128, 51118, 51117, 51116, 51115, 51114, 
    51113, 51165, 51164, 51163, 51162, 
    51161, 52, 51183, 20, 51188, 51187, 
    51186, 51185, 51184, 51201, 51200, 
    51199, 51198, 51197, 51196, 51195, 
    131, 51231, 51230, 51229, 51228, 51227, 
    51226, 51225, 109, 51243, 51242, 51241, 
    51240, 51239, 36, 51253, 51252, 51251, 
    51250, 51249, 34, 51265, 51264, 51263, 
    51262, 51261, 51260, 51259, 110, 51273, 
    147, 51277, 51276, 51275, 51274, 51346, 
    118, 114, 84, 51352, 51351, 96
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00113

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "48.31"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 69,
      "rows_produced_per_join": 69,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_descriptions`.`product_id` in (128,51118,51117,51116,51115,51114,51113,51165,51164,51163,51162,51161,52,51183,20,51188,51187,51186,51185,51184,51201,51200,51199,51198,51197,51196,51195,131,51231,51230,51229,51228,51227,51226,51225,109,51243,51242,51241,51240,51239,36,51253,51252,51251,51250,51249,34,51265,51264,51263,51262,51261,51260,51259,110,51273,147,51277,51276,51275,51274,51346,118,114,84,51352,51351,96)) and (`test_uchur_k`.`cscart_product_descriptions`.`lang_code` = 'kk'))",
      "cost_info": {
        "read_cost": "41.41",
        "eval_cost": "6.90",
        "prefix_cost": "48.31",
        "data_read_per_join": "314K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ]
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
20
34
36
52
84
96
109
110
114
118
128
131
147
51113
51114
51115
51116
51117
51118
51161
51162
51163
51164
51165
51183
51184
51185
51186
51187
51188
51195
51196
51197
51198
51199
51200
51201
51225
51226
51227
51228
51229
51230
51231
51239
51240
51241
51242
51243
51249
51250
51251
51252
51253
51259
51260
51261
51262
51263
51264
51265
51273
51274
51275
51276
51277
51346
51351
51352