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 (
    86313, 86329, 86259, 86307, 86297, 86323, 
    86267, 86288, 86302, 86315, 86295, 
    86301, 86314, 86321, 86265, 86286, 
    86293, 86319, 86263, 86284, 95165, 
    95168, 95171, 95173, 95177, 95179, 
    95181, 95187, 95189, 95195, 95197, 
    95201, 95203, 95205, 95213, 95215, 
    95219, 95222, 95224, 95227, 95230, 
    95232, 95234, 95236, 95238, 95240, 
    95242, 95244
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00150

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.63"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.83",
        "eval_cost": "4.80",
        "prefix_cost": "21.63",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (86313,86329,86259,86307,86297,86323,86267,86288,86302,86315,86295,86301,86314,86321,86265,86286,86293,86319,86263,86284,95165,95168,95171,95173,95177,95179,95181,95187,95189,95195,95197,95201,95203,95205,95213,95215,95219,95222,95224,95227,95230,95232,95234,95236,95238,95240,95242,95244)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
86259 nuie Revive With Mirror Single Panel Radiator With Mirror 1800 x 499mm - High Gloss White
86263 nuie Revive Horizontal Single Panel Radiator 600 x 412mm - High Gloss White
86265 nuie Revive Horizontal Single Panel Radiator 600 x 586mm - High Gloss White
86267 nuie Revive Horizontal Single Panel Radiator 600 x 992mm - High Gloss White
86284 nuie Revive Horizontal Single Panel Radiator 600 x 412mm - Anthracite
86286 nuie Revive Horizontal Single Panel Radiator 600 x 586mm - Anthracite
86288 nuie Revive Horizontal Single Panel Radiator 600 x 992mm - Anthracite
86293 nuie Sloane Horizontal Single Panel Radiator 600 x 412mm - Anthracite
86295 nuie Sloane Horizontal Single Panel Radiator 600 x 586mm - Anthracite
86297 nuie Sloane Horizontal Single Panel Radiator 600 x 992mm - Anthracite
86301 nuie Sloane Vertical Single Panel 1500 x 354mm - Anthracite
86302 nuie Sloane Single Panel Designer Radiator 1800 x 354mm - Anthracite
86307 nuie Revive With Mirror Single Panel Designer Radiator 1800 x 499mm - Anthracite
86313 nuie Revive Wave Designer Radiator 1785 x 413mm - Anthracite
86314 nuie Sloane Single Panel Designer Radiator 1500 x 354mm - Satin White
86315 nuie Sloane Single Panel Designer Radiator 1800 x 354mm - Satin White
86319 nuie Sloane Horizontal Single Panel Radiator 600 x 412mm - Satin White
86321 nuie Sloane Horizontal Single Panel Radiator 600 x 586mm - Satin White
86323 nuie Sloane Horizontal Single Panel Radiator 600 x 992mm - Satin White
86329 nuie Revive Wave Designer Radiator 1785 x 413mm - High Gloss White
95165
95168
95171
95173
95177
95179
95181
95187
95189
95195
95197
95201
95203
95205
95213
95215
95219
95222
95224
95227
95230
95232
95234
95236
95238
95240
95242
95244