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 (
    93003, 93004, 93005, 93006, 93007, 93008, 
    93009, 93010, 93011, 93012, 93013, 
    93014, 93015, 93282, 93283, 93284, 
    93285, 93286, 93287, 93288, 93289, 
    93290, 93291, 93294, 93338, 93339, 
    93341, 93342, 93343, 93344, 93345, 
    93346, 93347, 93348, 93349, 93350, 
    93351, 93352, 93353, 93354, 93355, 
    93356, 93357, 93358, 93750, 93751, 
    93752, 93753, 93754, 93755, 93756, 
    93757, 93758, 93759, 93760, 93761, 
    93762, 93763, 93764, 93765, 93766, 
    93767, 93768, 93769, 93770, 93771, 
    93772, 93773, 93774, 93775, 93776, 
    93777, 93778, 93779, 93780, 93790, 
    93791, 93825, 93826, 93827, 93828, 
    93829, 93842, 93843, 93844, 93845, 
    93848, 93849, 93868, 93869, 93870, 
    93871, 93886, 93887, 93888, 93889
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00071

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 (93003,93004,93005,93006,93007,93008,93009,93010,93011,93012,93013,93014,93015,93282,93283,93284,93285,93286,93287,93288,93289,93290,93291,93294,93338,93339,93341,93342,93343,93344,93345,93346,93347,93348,93349,93350,93351,93352,93353,93354,93355,93356,93357,93358,93750,93751,93752,93753,93754,93755,93756,93757,93758,93759,93760,93761,93762,93763,93764,93765,93766,93767,93768,93769,93770,93771,93772,93773,93774,93775,93776,93777,93778,93779,93780,93790,93791,93825,93826,93827,93828,93829,93842,93843,93844,93845,93848,93849,93868,93869,93870,93871,93886,93887,93888,93889)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}