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 (
    98187, 98188, 98189, 98190, 98191, 98200, 
    98201, 98202, 98203, 98204, 98205, 
    98206, 98207, 98391, 98392, 98393, 
    98394, 98395, 98396, 98397, 98398, 
    98399, 98400, 98401, 98402, 98403, 
    98404, 98405, 98406, 98411, 98412, 
    98413, 98422, 98427, 98429, 98433, 
    98435, 98439, 98440, 98441, 98443, 
    98447, 98451, 98453, 98456, 98476, 
    98477, 98478, 98479, 98480, 98481, 
    98483, 98484, 98490, 98492, 98759, 
    98769, 98770, 98771, 98772, 98831, 
    98832, 98833, 98834, 98835, 98836, 
    98837, 98838, 98839, 98840, 98841, 
    98842, 98843, 98844, 98845, 98846, 
    98847, 98848, 98849, 98850, 98897, 
    98914, 98915, 98916, 98917, 98918, 
    98919, 98920, 98921, 98922, 98923, 
    98924, 98925, 98926, 98927, 98928
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00187

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 (98187,98188,98189,98190,98191,98200,98201,98202,98203,98204,98205,98206,98207,98391,98392,98393,98394,98395,98396,98397,98398,98399,98400,98401,98402,98403,98404,98405,98406,98411,98412,98413,98422,98427,98429,98433,98435,98439,98440,98441,98443,98447,98451,98453,98456,98476,98477,98478,98479,98480,98481,98483,98484,98490,98492,98759,98769,98770,98771,98772,98831,98832,98833,98834,98835,98836,98837,98838,98839,98840,98841,98842,98843,98844,98845,98846,98847,98848,98849,98850,98897,98914,98915,98916,98917,98918,98919,98920,98921,98922,98923,98924,98925,98926,98927,98928)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
98187
98188
98189
98190
98191
98200
98201
98202
98203
98204
98205
98206
98207
98391
98392
98393
98394
98395
98396
98397
98398
98399
98400
98401
98402
98403
98404
98405
98406
98411
98412
98413
98422
98427
98429
98433
98435
98439
98440
98441
98443
98447
98451
98453
98456
98476
98477
98478
98479
98480
98481
98483
98484
98490
98492
98759
98769
98770
98771
98772
98831
98832
98833
98834
98835
98836
98837
98838
98839
98840
98841
98842
98843
98844
98845
98846
98847
98848
98849
98850
98897
98914
98915
98916
98917
98918
98919
98920
98921
98922
98923
98924
98925
98926
98927
98928