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 (
    339511, 339515, 339527, 339513, 339519, 
    339510, 339518, 339508, 339713, 339525, 
    339505, 339530, 339514, 339521, 339551, 
    339501, 339499, 339721, 339495, 339494, 
    339503, 339531, 339516, 339637, 339539, 
    339509, 339636, 339538, 339492, 339506, 
    339724, 339635, 339502, 339537, 339491, 
    339540, 339524, 339493, 339536, 339520, 
    339517, 339522, 339526, 339490, 339498, 
    339528, 339497, 339507, 339512, 339523, 
    339504, 339500, 339532, 339535, 339534, 
    339496, 339533, 339529
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00401

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "81.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": 58,
      "rows_produced_per_join": 58,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "69.71",
        "eval_cost": "11.60",
        "prefix_cost": "81.31",
        "data_read_per_join": "396K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (339511,339515,339527,339513,339519,339510,339518,339508,339713,339525,339505,339530,339514,339521,339551,339501,339499,339721,339495,339494,339503,339531,339516,339637,339539,339509,339636,339538,339492,339506,339724,339635,339502,339537,339491,339540,339524,339493,339536,339520,339517,339522,339526,339490,339498,339528,339497,339507,339512,339523,339504,339500,339532,339535,339534,339496,339533,339529)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}