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 (
    415299, 415298, 427777, 185446, 185442, 
    185439, 185433, 185435, 185438, 185441, 
    185456, 185443, 185436, 185448, 185447, 
    185452, 185449, 185434, 185437, 185445, 
    185440, 185450, 185454, 185451, 185455, 
    185444, 185453
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00116

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.86"
    },
    "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": 27,
      "rows_produced_per_join": 27,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "32.46",
        "eval_cost": "5.40",
        "prefix_cost": "37.86",
        "data_read_per_join": "184K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (415299,415298,427777,185446,185442,185439,185433,185435,185438,185441,185456,185443,185436,185448,185447,185452,185449,185434,185437,185445,185440,185450,185454,185451,185455,185444,185453)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
185433 Uyku Arkadaşım Uzun Kulak Peluş Tavşan 45 Cm
185434 Uyku Arkadaşım Uzun Kulak Peluş Tavşan 45 Cm
185435 Peluş Yatan Ayıcık Uyku Arkadaşım 77 Cm
185436 Canım Aşkım Balonlu Sevimli Peluş Ayı 23 Cm
185437 Kalp Hediye Eden Sevimli Uzun Kulak Peluş Tavşan 45 Cm
185438 Canım Annem Nakışlı Kalp Yastık
185439 Bu Kalp Senin Mesajlı Balonlu Ayı 50 Cm
185440 Kalp Tutan Sevimli Peluş Ayı 23 Cm
185441 Kalp Tutan Sevimli Peluş Ayı 23 Cm
185442 Canım Annem Mesajlı Balonlu Ayı 50 Cm
185443 Canım Aşkım Mesajlı Balonlu Ayı 50 Cm
185444 Her Şey Seninle Güzel Mesajlı Balonlu Ayı 50 Cm
185445 İyi ki Doğdun Mesajlı Balonlu Ayı 50 Cm
185446 İyi ki Varsın Mesajlı Balonlu Ayı 50 Cm
185447 İyi ki Varsın Balonlu Sevimli Peluş Ayı 23 Cm
185448 İyi ki Doğdun Mesajlı Balonlu Sevimli Ayı 23 Cm
185449 Mutlu Yıllar Mesajlı Balonlu Ayı 50 Cm
185450 Seni Seviyorum Balonlu Sevimli Peluş Ayı 23 Cm
185451 Şirin Peluş Ayı ve Kokulu Taş Aranjmanı 23 Cm
185452 Şirin Peluş Ayı ve Kokulu Taş Aranjmanı 23 Cm
185453 Şirin Peluş Ayı ve Kokulu Taş Aranjmanı 23 Cm
185454 Kalp Tutan Sevimli Peluş Ayı 23 Cm
185455 Kalp Hediye Eden Sevimli Uzun Kulak Peluş Tavşan 45 Cm
185456 Uyku Arkadaşım Uzun Kulak Peluş Tavşan 45 Cm
415298 <p>The HUGE TRANSFORMERS car with large dimensions of 37X15X7.5cm!!</p> <p>Interactive Glorious AKU Robot, with Remote Control, Bump and Go action LED Sounds + Specific lights</p> <p>Children can follow and coordinate the AKU Robot Car from a distance! It has the function of moving forward, backward and rotating 360 degrees on any flat surface. If it crashes into a wall or an object, it automatically changes its direction of contact.<br />High quality product. Offering durability and long-lasting use, this toy is expertly crafted using a durable plastic construction to withstand hitting walls and endless hours of play.<br />Toy car with remote control, 2 in 1, ABS, Blue</p><p></p>
415299 <p>TRANSFORMERS HUGE car 37X15X7.5cm Interactive Glorious AKU Robot, with Remote Control, Bump and Go action LED Sounds + Specific Lights</p> <p>The HUGE TRANSFORMERS car with large dimensions of 37X15X7.5cm!!</p> <p>Interactive Glorious AKU Robot, with Remote Control, Bump and Go action LED Sounds + Specific lights</p> <p>Children can follow and coordinate the AKU Robot Car from a distance! It has the function of moving forward, backward and rotating 360 degrees on any flat surface. If it crashes into a wall or an object, it automatically changes its direction of contact.<br />High quality product. Offering durability and long-lasting use, this toy is expertly crafted using a durable plastic construction to withstand hitting walls and endless hours of play.</p><p></p>
427777 <font style="vertical-align:inherit;"><font style="vertical-align:inherit;">Pusculita</font></font>