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 (415224, 415238) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00121

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.81"
    },
    "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": 2,
      "rows_produced_per_join": 2,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "2.41",
        "eval_cost": "0.40",
        "prefix_cost": "2.81",
        "data_read_per_join": "13K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (415224,415238)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
415224 <p>Ultrasonic Aromatherapy Humidifier and Diffuser, capacity 300ML, LED 7<br /></p><p>Spraying:<br />1. Click the power button, turn on the continuous spray mode;<br />2. Click again to start intermittent spray mode (3 seconds on, 3 seconds off);<br />3. Click the button a third time to close the spray mode.</p> <p>LED operation<br />1. Press the power button for 2 seconds to turn on the night light - white color;<br />2. Press the button again for 2 seconds to start the gradual change mode of the 7 colors;<br />3. Click the button for 2 seconds to turn off the LEDs.</p> <p>Spray mode and light mode work at the same time:<br />Press the power key to start the continuous spray mode, then press the power key for 2…</p><p></p>
415238 <p>Humidifier, air purifier, diffuser, aromatherapy, ultrasound<br /></p> <p>Operating principle: ultrasonic vaporization. The dry air in the room is sucked in by the fan, is passed through the water tank, transformed into cold vapors by ultrasound technology and then discharged. This operating principle ensures a natural humidification of the air.</p> <p>Aromatherapy Humidifier Benefits:</p> <p>It repels insects while purifying and refreshing the air, helping you get through the hot summer days more easily. It humidifies the air, helping to maintain and beautify the skin, thus preventing the appearance of wrinkles and skin aging. It humidifies the dry air from the heat in the house during the winter and prevents the nasal passages and throat from drying out. It is perfect in…</p>