Sandbox

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, 
    51565, 
    51564, 
    139, 
    129, 
    51566, 
    51301, 
    51, 
    50, 
    51497, 
    51498, 
    53, 
    22713, 
    21, 
    22714, 
    22712, 
    46, 
    22715, 
    22716, 
    51496, 
    21567, 
    91, 
    50989, 
    47, 
    105, 
    48, 
    49, 
    92, 
    137, 
    88, 
    126, 
    31, 
    51358, 
    115, 
    37, 
    11, 
    140, 
    41, 
    30, 
    90, 
    38, 
    124, 
    81, 
    56, 
    135, 
    82, 
    116, 
    117, 
    125, 
    106, 
    39, 
    193, 
    65, 
    40, 
    22710, 
    22711, 
    17, 
    57, 
    122, 
    58, 
    5, 
    22, 
    18, 
    27, 
    121, 
    119, 
    141, 
    23, 
    4, 
    142, 
    120, 
    62, 
    108, 
    107, 
    94, 
    8, 
    86, 
    54, 
    10, 
    93, 
    12, 
    32, 
    7, 
    130, 
    35, 
    16, 
    33, 
    110, 
    34, 
    89, 
    147, 
    114, 
    36, 
    128, 
    20, 
    52, 
    84, 
    109, 
    118, 
    19, 
    131, 
    146, 
    13, 
    61, 
    95, 
    15, 
    9, 
    85, 
    59, 
    111, 
    144, 
    60, 
    123, 
    145, 
    113, 
    6, 
    14, 
    63, 
    136, 
    50984, 
    127, 
    134, 
    42, 
    50985, 
    50986, 
    50988, 
    50993, 
    50992
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00260

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,51565,51564,139,129,51566,51301,51,50,51497,51498,53,22713,21,22714,22712,46,22715,22716,51496,21567,91,50989,47,105,48,49,92,137,88,126,31,51358,115,37,11,140,41,30,90,38,124,81,56,135,82,116,117,125,106,39,193,65,40,22710,22711,17,57,122,58,5,22,18,27,121,119,141,23,4,142,120,62,108,107,94,8,86,54,10,93,12,32,7,130,35,16,33,110,34,89,147,114,36,128,20,52,84,109,118,19,131,146,13,61,95,15,9,85,59,111,144,60,123,145,113,6,14,63,136,50984,127,134,42,50985,50986,50988,50993,50992)) 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
4
5
6
7
8
9
10
11
12
13
14
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
42
46
47
48
49
50
51
52
53
54
56
57
58
59
60
61
62
63
65
81
82
84
85
86
88
89
90
91
92
93
94
95
105
106
107
108
109
110
111
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
134
135
136
137
139
140
141
142
144
145
146
147
193
21567
22710
22711
22712
22713
22714					футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, eagle, еагле, цв, cv, черный, chernyy
22715
22716					футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
50984
50985
50986
50988
50989
50992
50993
51301
51358
51496					панама, panama, uchur, учур, safari, сафари, цв, cv, бежевый, bezhevyy
51497					панама, panama, uchur, учур, safari, сафари, цв, cv, черный, chernyy
51498					панама, panama, uchur, учур, safari, сафари, цв, cv, серый, seryy
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