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 (
    4, 
    7, 
    8, 
    9, 
    10, 
    12, 
    13, 
    15, 
    16, 
    18, 
    19, 
    20, 
    22, 
    23, 
    27, 
    32, 
    33, 
    34, 
    35, 
    36, 
    52, 
    54, 
    59, 
    60, 
    61, 
    62, 
    84, 
    85, 
    86, 
    89, 
    93, 
    94, 
    95, 
    96, 
    107, 
    108, 
    109, 
    110, 
    111, 
    114, 
    118, 
    119, 
    120, 
    121, 
    123, 
    128, 
    130, 
    131, 
    141, 
    142, 
    144, 
    146, 
    147, 
    51106, 
    51107, 
    51108, 
    51109, 
    51110, 
    51111, 
    51112, 
    51113, 
    51114, 
    51115, 
    51116, 
    51117, 
    51118, 
    51161, 
    51162, 
    51163, 
    51164, 
    51165, 
    51177, 
    51178, 
    51179, 
    51180, 
    51182, 
    51183, 
    51184, 
    51185, 
    51186, 
    51187, 
    51188, 
    51189, 
    51190, 
    51191, 
    51192, 
    51193, 
    51194, 
    51195, 
    51196, 
    51197, 
    51198, 
    51199, 
    51200, 
    51201, 
    51212, 
    51213, 
    51214, 
    51215, 
    51216, 
    51217, 
    51218, 
    51219, 
    51220, 
    51225, 
    51226, 
    51227, 
    51228, 
    51229, 
    51230, 
    51231, 
    51232, 
    51233, 
    51234, 
    51235, 
    51236, 
    51237, 
    51238, 
    51239, 
    51240, 
    51241, 
    51242, 
    51243, 
    51244, 
    51245, 
    51246, 
    51247, 
    51248, 
    51249, 
    51250, 
    51251, 
    51252, 
    51253, 
    51254, 
    51255, 
    51256, 
    51259, 
    51260, 
    51261, 
    51262, 
    51263, 
    51264, 
    51265, 
    51273, 
    51274, 
    51275, 
    51276, 
    51277, 
    51278, 
    51279, 
    51280, 
    51281, 
    51282, 
    51283, 
    51284, 
    51285, 
    51286, 
    51287, 
    51288, 
    51289, 
    51290, 
    51291, 
    51293, 
    51294, 
    51310, 
    51311, 
    51312, 
    51313, 
    51314, 
    51344, 
    51345, 
    51346, 
    51347, 
    51348, 
    51350, 
    51351, 
    51352, 
    51390, 
    51391, 
    51392, 
    51393, 
    51394, 
    51444, 
    51445, 
    51446, 
    51447, 
    51448, 
    51449
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00217

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "131.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": 188,
      "rows_produced_per_join": 188,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_descriptions`.`product_id` in (4,7,8,9,10,12,13,15,16,18,19,20,22,23,27,32,33,34,35,36,52,54,59,60,61,62,84,85,86,89,93,94,95,96,107,108,109,110,111,114,118,119,120,121,123,128,130,131,141,142,144,146,147,51106,51107,51108,51109,51110,51111,51112,51113,51114,51115,51116,51117,51118,51161,51162,51163,51164,51165,51177,51178,51179,51180,51182,51183,51184,51185,51186,51187,51188,51189,51190,51191,51192,51193,51194,51195,51196,51197,51198,51199,51200,51201,51212,51213,51214,51215,51216,51217,51218,51219,51220,51225,51226,51227,51228,51229,51230,51231,51232,51233,51234,51235,51236,51237,51238,51239,51240,51241,51242,51243,51244,51245,51246,51247,51248,51249,51250,51251,51252,51253,51254,51255,51256,51259,51260,51261,51262,51263,51264,51265,51273,51274,51275,51276,51277,51278,51279,51280,51281,51282,51283,51284,51285,51286,51287,51288,51289,51290,51291,51293,51294,51310,51311,51312,51313,51314,51344,51345,51346,51347,51348,51350,51351,51352,51390,51391,51392,51393,51394,51444,51445,51446,51447,51448,51449)) and (`test_uchur_k`.`cscart_product_descriptions`.`lang_code` = 'kk'))",
      "cost_info": {
        "read_cost": "112.81",
        "eval_cost": "18.80",
        "prefix_cost": "131.61",
        "data_read_per_join": "857K"
      },
      "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
4
7
8
9
10
12
13
15
16
18
19
20
22
23
27
32
33
34
35
36
52
54
59
60
61
62
84
85
86
89
93
94
95
96
107
108
109
110
111
114
118
119
120
121
123
128
130
131
141
142
144
146
147
51106
51107
51108
51109
51110
51111
51112
51113
51114
51115
51116
51117
51118
51161
51162
51163
51164
51165
51177
51178
51179
51180
51182
51183
51184
51185
51186
51187
51188
51189
51190
51191
51192
51193
51194
51195
51196
51197
51198
51199
51200
51201
51212
51213
51214
51215
51216
51217
51218
51219
51220
51225
51226
51227
51228
51229
51230
51231
51232
51233
51234
51235
51236
51237
51238
51239
51240
51241
51242
51243
51244
51245
51246
51247
51248
51249
51250
51251
51252
51253
51254
51255
51256
51259
51260
51261
51262
51263
51264
51265
51273
51274
51275
51276
51277
51278
51279
51280
51281
51282
51283
51284
51285
51286
51287
51288
51289
51290
51291
51293
51294
51310
51311
51312
51313
51314
51344
51345
51346
51347
51348
51350
51351
51352
51390
51391
51392
51393
51394
51444
51445
51446
51447
51448
51449