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 (
    51083, 
    22715, 
    51082, 
    51085, 
    51081, 
    51088, 
    51087, 
    22713, 
    51086, 
    51089, 
    51090, 
    51092, 
    51093, 
    22714, 
    51091, 
    51095, 
    51096, 
    51097, 
    51098, 
    51100, 
    51099, 
    22716, 
    51103, 
    22712, 
    51105, 
    51102, 
    51101, 
    51205, 
    51204, 
    51203, 
    51202, 
    125, 
    51209, 
    51208, 
    51207, 
    51206, 
    124, 
    111, 
    51212, 
    144, 
    51215, 
    51214, 
    51213, 
    51444, 
    51445, 
    51446, 
    51447, 
    51220, 
    51219, 
    51218, 
    51217, 
    51216, 
    146, 
    51448, 
    51449, 
    51221, 
    137, 
    51224, 
    51223, 
    51231, 
    51230, 
    51229, 
    51228, 
    51227, 
    51226, 
    51225, 
    109, 
    51232, 
    12, 
    51238, 
    51237, 
    51236, 
    51235, 
    51234, 
    51233, 
    51243, 
    51242, 
    51241, 
    51240, 
    51239, 
    36, 
    51246, 
    51245, 
    51244, 
    35, 
    51248, 
    51247, 
    51253, 
    51252, 
    51251, 
    51250, 
    51249, 
    34, 
    51256, 
    51255, 
    51254, 
    33, 
    32, 
    51265, 
    51264, 
    51263, 
    51262, 
    51261, 
    51260, 
    51259, 
    110, 
    51272, 
    51271, 
    51270, 
    51269, 
    51268, 
    51267, 
    51266, 
    145, 
    51273, 
    147, 
    51277, 
    51276, 
    51275, 
    51274, 
    51281, 
    51280, 
    51279, 
    51278, 
    51282, 
    7, 
    51289, 
    51288, 
    51287, 
    51286, 
    51285, 
    51284, 
    51283, 
    8, 
    51294, 
    51293, 
    51291, 
    51290, 
    94
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00162

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "97.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": 139,
      "rows_produced_per_join": 139,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_descriptions`.`product_id` in (51083,22715,51082,51085,51081,51088,51087,22713,51086,51089,51090,51092,51093,22714,51091,51095,51096,51097,51098,51100,51099,22716,51103,22712,51105,51102,51101,51205,51204,51203,51202,125,51209,51208,51207,51206,124,111,51212,144,51215,51214,51213,51444,51445,51446,51447,51220,51219,51218,51217,51216,146,51448,51449,51221,137,51224,51223,51231,51230,51229,51228,51227,51226,51225,109,51232,12,51238,51237,51236,51235,51234,51233,51243,51242,51241,51240,51239,36,51246,51245,51244,35,51248,51247,51253,51252,51251,51250,51249,34,51256,51255,51254,33,32,51265,51264,51263,51262,51261,51260,51259,110,51272,51271,51270,51269,51268,51267,51266,145,51273,147,51277,51276,51275,51274,51281,51280,51279,51278,51282,7,51289,51288,51287,51286,51285,51284,51283,8,51294,51293,51291,51290,94)) and (`test_uchur_k`.`cscart_product_descriptions`.`lang_code` = 'kk'))",
      "cost_info": {
        "read_cost": "83.41",
        "eval_cost": "13.90",
        "prefix_cost": "97.31",
        "data_read_per_join": "634K"
      },
      "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
7
8
12
32
33
34
35
36
94
109
110
111
124
125
137
144
145
146
147
22712
22713
22714 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, eagle, еагле, цв, cv, черный, chernyy
22715
22716 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, raven, равен, цв, cv, черный, chernyy
51081
51082
51083
51085
51086
51087
51088
51089
51090
51091 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, eagle, еагле, цв, cv, черный, chernyy
51092 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, eagle, еагле, цв, cv, черный, chernyy
51093 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, eagle, еагле, цв, cv, черный, chernyy
51095 футболка, futbolka, спортивная, sportivnaya, uchur, учур, totem, тотем, animal, анимал, eagle, еагле, цв, cv, черный, chernyy
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
51101
51102
51103
51105
51202
51203
51204
51205
51206
51207
51208
51209
51212
51213
51214
51215
51216
51217
51218
51219
51220
51221
51223
51224
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
51266
51267
51268
51269
51270
51271
51272
51273
51274
51275
51276
51277
51278
51279
51280
51281
51282
51283
51284
51285
51286
51287
51288
51289
51290
51291
51293
51294
51444
51445
51446
51447
51448
51449