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 (
    21567, 51083, 22715, 51082, 51085, 51081, 
    51096, 51097, 51098, 51100, 51099, 
    22716, 51123, 51122, 51121, 92, 49, 
    51129, 51128, 51127, 51126, 51125, 
    48, 51176, 51174, 51173, 51172, 91, 
    51221, 137, 51224, 51223, 126, 51343, 
    51342, 51341, 51340, 47, 105, 50989, 
    31, 51366, 51367, 51368, 51369, 46, 
    51370, 51371, 51372, 51373, 51452, 
    51453, 88, 51395, 51396, 51397, 51555, 
    51556, 51496
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00093

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "41.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": 59,
      "rows_produced_per_join": 59,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_descriptions`.`product_id` in (21567,51083,22715,51082,51085,51081,51096,51097,51098,51100,51099,22716,51123,51122,51121,92,49,51129,51128,51127,51126,51125,48,51176,51174,51173,51172,91,51221,137,51224,51223,126,51343,51342,51341,51340,47,105,50989,31,51366,51367,51368,51369,46,51370,51371,51372,51373,51452,51453,88,51395,51396,51397,51555,51556,51496)) and (`test_uchur_k`.`cscart_product_descriptions`.`lang_code` = 'kk'))",
      "cost_info": {
        "read_cost": "35.41",
        "eval_cost": "5.90",
        "prefix_cost": "41.31",
        "data_read_per_join": "269K"
      },
      "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
31
46
47
48
49
88
91
92
105
126
137
21567
22715
22716 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
50989
51081
51082
51083
51085
51096 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
51097 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
51098 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
51099 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
51100 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
51121
51122
51123
51125
51126
51127
51128
51129
51172
51173
51174
51176
51221
51223
51224
51340
51341
51342
51343
51366
51367
51368
51369
51370
51371
51372
51373
51395
51396
51397
51452
51453
51496 панама, panama, uchur, учур, safari, сафари, цв, cv, бежевый, bezhevyy
51555
51556