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 (
    51272, 51271, 51270, 51269, 51268, 51267, 
    51266, 145, 14, 127, 51325, 63, 50984, 
    51450, 51451, 51329, 51328, 51327, 
    50985, 51331, 51330, 50986, 51332, 
    51339, 51338, 51337, 51336, 50988, 
    113, 6, 51350, 123, 136, 50992, 51374, 
    51375, 42, 51376, 51377, 51378, 51379, 
    51380, 50993, 51381, 51382, 134
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00112

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "32.21"
    },
    "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": 46,
      "rows_produced_per_join": 46,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_descriptions`.`product_id` in (51272,51271,51270,51269,51268,51267,51266,145,14,127,51325,63,50984,51450,51451,51329,51328,51327,50985,51331,51330,50986,51332,51339,51338,51337,51336,50988,113,6,51350,123,136,50992,51374,51375,42,51376,51377,51378,51379,51380,50993,51381,51382,134)) and (`test_uchur_k`.`cscart_product_descriptions`.`lang_code` = 'kk'))",
      "cost_info": {
        "read_cost": "27.61",
        "eval_cost": "4.60",
        "prefix_cost": "32.21",
        "data_read_per_join": "209K"
      },
      "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
6
14
42
63
113
123
127
134
136
145
50984
50985
50986
50988
50992
50993
51266
51267
51268
51269
51270
51271
51272
51325
51327
51328
51329
51330
51331
51332
51336
51337
51338
51339
51350
51374
51375
51376
51377
51378
51379
51380
51381
51382
51450
51451