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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    92886, 92887, 92888, 92889, 92890, 92891, 
    93078, 93080, 93082, 93084, 93085, 
    93086, 93087, 93089, 93091, 93093, 
    93094, 93095, 93096, 93097, 93098, 
    93099, 93100, 93101, 93102, 93103, 
    93104, 93105, 93106, 93107, 93108, 
    93109, 93110, 93111, 93112, 93113, 
    93114, 93116, 93118, 93120, 93121, 
    93122, 93123, 93124, 93125, 93126, 
    93127, 93128, 93129, 93130, 93131, 
    93132, 93134, 93136, 93138, 93139, 
    93140, 93141, 93142, 93143, 93144, 
    93145, 93146, 93147, 93148, 93149, 
    93160, 93161, 93162, 93163, 93164, 
    93165, 93166, 93167, 93168, 93169, 
    93170, 93171, 93172, 93173, 93174, 
    93175, 93176, 93177, 93178, 93179, 
    93180, 93181, 93182, 93183, 93184, 
    93185, 93186, 93187, 93188, 93189
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00195

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.24"
    },
    "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": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.64",
        "eval_cost": "9.60",
        "prefix_cost": "43.24",
        "data_read_per_join": "366K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (92886,92887,92888,92889,92890,92891,93078,93080,93082,93084,93085,93086,93087,93089,93091,93093,93094,93095,93096,93097,93098,93099,93100,93101,93102,93103,93104,93105,93106,93107,93108,93109,93110,93111,93112,93113,93114,93116,93118,93120,93121,93122,93123,93124,93125,93126,93127,93128,93129,93130,93131,93132,93134,93136,93138,93139,93140,93141,93142,93143,93144,93145,93146,93147,93148,93149,93160,93161,93162,93163,93164,93165,93166,93167,93168,93169,93170,93171,93172,93173,93174,93175,93176,93177,93178,93179,93180,93181,93182,93183,93184,93185,93186,93187,93188,93189)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
92886
92887
92888
92889
92890
92891
93078
93080
93082
93084
93085
93086
93087
93089
93091
93093
93094
93095
93096
93097
93098
93099
93100
93101
93102
93103
93104
93105
93106
93107
93108
93109
93110
93111
93112
93113
93114
93116
93118
93120
93121
93122
93123
93124
93125
93126
93127
93128
93129
93130
93131
93132
93134
93136
93138
93139
93140
93141
93142
93143
93144
93145
93146
93147
93148
93149
93160
93161
93162
93163
93164
93165
93166
93167
93168
93169
93170
93171
93172
93173
93174
93175
93176
93177
93178
93179
93180
93181
93182
93183
93184
93185
93186
93187
93188
93189