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 (
    286711, 286710, 286709, 286708, 286707
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "7.02"
    },
    "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": 5,
      "rows_produced_per_join": 5,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "6.02",
        "eval_cost": "1.00",
        "prefix_cost": "7.02",
        "data_read_per_join": "34K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (286711,286710,286709,286708,286707)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
286707 <h4>Therapy includes root canal treatment by the dentist. Once a scary experience for patients, but now with modern dental techniques, it has become one of the most common practices. Advanced decay, tooth fractures or gum disease can kill the tooth and cause root canal symptoms such as root pain or tooth abscess. Pearl dent, with a long experience in therapy, and through the use of the latest materials and techniques, makes it possible for you not to feel any kind of annoyance or discomfort after the treatment of the tooth.</h4>
286708 <h5>Oral surgery is the branch of dentistry that deals with surgical interventions in the oral cavity. Unfortunately, when a tooth is impossible to save because it may be too damaged and a filling is impossible, it is forced to remove it. The most widespread surgery is the removal of wisdom teeth, the removal of retained teeth. The most frequent interventions performed are biopsies and extractions of the remaining teeth and roots. Tooth extraction is a routine intervention in oral surgery. At Pearl Dent, it becomes possible to calm down and fully heal patients with abscesses and phlegmons of the teeth, with retained (retained) mature molars, which come out with difficulty due to lack of space in the patient's jaw and, as a result, with very strong pain; we fix all types of accidental jaw fractures by reshaping the broken bones to their previous state.</h5>
286709 <h5>The absence of one or more teeth is not only an aesthetic problem, but also a concern in terms of damage to chewing skills. For this reason, their replacement should be done as soon as possible, using alternative methods. Replacement can be done through bridges or plants. In other cases, when the tooth presents extensive crown damage, replacement can be done using a pinlay and case. Tooth replacement alternatives are provided through: Kellefave: metal, metal-porcelain, full-porcelain, zircon; Bridges (when the teeth are on the side of the defect); Inlay, onlay, pinlay implants; Removable partial dentures. At Pearl dent you will find maximum care for your smile..</h5>
286710 <h5> Orthodontics is the special field of dentistry that corrects teeth and jaw alignment problems. It deals with the direction or movement of teeth improving the aesthetics and function of your teeth. Through orthodontic treatment, it becomes possible to straighten the teeth, to improve their aesthetic appearance, but also to facilitate the maintenance of dental hygiene, which is more difficult to maintain when the teeth are crooked. This treatment can be started from childhood, but it is best to wait for the emergence of as many teeth as possible before placement. While recently there are more and more adults who turn to this treatment.</h5>
286711 <h5>We all love beauty and no one would forget a perfect smile. And precisely to give you such a smile, Aesthetic Stonatology was born. In general, it is used to refer to any dental work that improves the appearance of the teeth or gums. Cosmetic dentistry focuses primarily on improving dental aesthetics in color, position, shape, size, alignment and the overall appearance of your smile. It includes dental implants, white fillings, porcelain veneers, crowns and bridges, and whitening.</h5>