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, 
    137, 
    88, 
    126, 
    31, 
    51358, 
    115, 
    80, 
    37, 
    11, 
    140, 
    41, 
    30, 
    90, 
    38, 
    124, 
    81, 
    56, 
    82, 
    116, 
    125, 
    117, 
    106, 
    39, 
    193, 
    40, 
    22710, 
    22711, 
    17, 
    57, 
    122, 
    58, 
    5, 
    22, 
    18, 
    27, 
    119, 
    121, 
    141, 
    23, 
    4, 
    142, 
    120, 
    62, 
    108, 
    107, 
    94, 
    8, 
    86, 
    54, 
    132, 
    10, 
    93, 
    12, 
    32, 
    7, 
    130, 
    35, 
    16, 
    112, 
    3, 
    78, 
    33, 
    89, 
    2, 
    110, 
    114, 
    34, 
    77, 
    147, 
    36, 
    87, 
    128, 
    96, 
    20, 
    52, 
    84, 
    118, 
    109, 
    66, 
    131, 
    19, 
    13, 
    61, 
    146, 
    95, 
    15, 
    9, 
    85, 
    83, 
    22421, 
    111, 
    59, 
    22424, 
    60, 
    144, 
    123
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00197

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "89.61"
    },
    "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": 128,
      "rows_produced_per_join": 128,
      "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,137,88,126,31,51358,115,80,37,11,140,41,30,90,38,124,81,56,82,116,125,117,106,39,193,40,22710,22711,17,57,122,58,5,22,18,27,119,121,141,23,4,142,120,62,108,107,94,8,86,54,132,10,93,12,32,7,130,35,16,112,3,78,33,89,2,110,114,34,77,147,36,87,128,96,20,52,84,118,109,66,131,19,13,61,146,95,15,9,85,83,22421,111,59,22424,60,144,123)) and (`test_uchur_k`.`cscart_product_descriptions`.`lang_code` = 'kk'))",
      "cost_info": {
        "read_cost": "76.81",
        "eval_cost": "12.80",
        "prefix_cost": "89.61",
        "data_read_per_join": "584K"
      },
      "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
2
3
4
5
7
8
9
10
11
12
13
15
16
17
18
19
20
21
22
23
27
30
31
32
33
34
35
36
37
38 куртка, kurtka, uchur, учур, softshell, софцхелл, jacket, йаккет, цв, cv, grey, грей
39
40
41
46
48
49
50
51
52
53
54
56
57
58
59
60
61
62
66
77
78
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
105
106
107
108
109
110
111
112
114
115
116
117
118
119
120
121
122
123
124
125
126
128
129
130
131
132
137
139
140
141
142
144
146
147
193
21567
22421
22424
22710
22711
22712
22713
22714 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, eagle, еагле, цв, cv, черный, chernyy
22715
22716 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
50989
51301
51358
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