SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    51567, 51480, 51565, 51564, 51479, 139, 
    129, 51566, 51301, 51494, 51, 50, 51497, 
    51498, 51495, 51563, 53, 22713, 21, 
    22714, 22712, 46, 22715, 22716, 51496, 
    21567, 91, 50989, 105, 48, 49, 92
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00074

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "22.41"
    },
    "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": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_descriptions`.`product_id` in (51567,51480,51565,51564,51479,139,129,51566,51301,51494,51,50,51497,51498,51495,51563,53,22713,21,22714,22712,46,22715,22716,51496,21567,91,50989,105,48,49,92)) and (`test_uchur_k`.`cscart_product_descriptions`.`lang_code` = 'kk'))",
      "cost_info": {
        "read_cost": "19.21",
        "eval_cost": "3.20",
        "prefix_cost": "22.41",
        "data_read_per_join": "146K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
21
46
48
49
50
51
53
91
92
105
129
139
21567
22712
22713
22714 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, eagle, еагле, цв, cv, черный, chernyy
22715
22716 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
50989
51301
51479 термокружка, termokruzhka, uchur, учур, terra, терра, цв, cv, черный, chernyy, 400ml, 400мл
51480 термокружка, termokruzhka, uchur, учур, ethno, етхно, v2, в2, цв, cv, черный, chernyy, 620ml, 620мл
51494 шоппер, shopper, uchur, учур, logo, лого, цв, cv, черный, chernyy
51495 шоппер, shopper, uchur, учур, terra, терра, цв, cv, черный, chernyy
51496 панама, panama, uchur, учур, safari, сафари, цв, cv, бежевый, bezhevyy
51497 панама, panama, uchur, учур, safari, сафари, цв, cv, черный, chernyy
51498 панама, panama, uchur, учур, safari, сафари, цв, cv, серый, seryy
51563 календарь, kalendar, uchur, учур, halandaar, халандаар, 2026, год, god
51564 штаны, shtany, утепленные, uteplennye, uchur, учур, expedition, експедитион, цв, cv, черный, chernyy
51565 куртка, kurtka, утепленная, uteplennaya, uchur, учур, expedition, експедитион, цв, cv, черный, chernyy
51566 брюки, bryuki, мужские, muzhskie, утепленные, uteplennye, uchur, учур, arctic, арктик, цв, cv, черный, chernyy
51567 пуховая, puhovaya, куртка, kurtka, uchur, учур, cloud, клоуд, цв, cv, черный, chernyy