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

Query time 0.00097

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 (415307,427821)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
415307 <p>Electronic Piggy Bank MRG M-6688-19, Police Car, With PIN, Black<br /></p><p>Description:<br />Encourage children to develop the habit of saving and to know the value of money. This piggy bank has the shape of an armored police car, in which all coins and banknotes will be protected by the security password (default password 0000).<br />This piggy bank contains a PIN keypad, fingerprint recognition, flashing lights, a coin slot, a banknote slot and a large enough storage space.<br />The back door opens automatically when the password is entered correctly. Otherwise, the car will emit an acoustic signal and warning lights.<br />To change the password, enter the initial password 0000 to open the back door, then hold down the "*" key. The beacon will start working, at which point you must enter the new password and press the "#" key until the beacon goes off. If you forget the password, it can be reset to the default value by removing the batteries.</p> <p>Specifications:<br />Brand: MRG<br />Model: 6688-19<br />Version: M<br />Color: Black<br />Material: Plastic<br />Dimensions: 270 x 115 x 130 mm<br />Box unlock mode: PIN<br />Number of LEDs: 4<br />Number of keys: 12<br />Power: 3x Batteries<br />Battery type: 1.5V AA (Not included)<br />Age: 3+<br />The package contains:<br />1x Car-type electronic piggy bank<br />1x Toys that can be attached to the car<br />1x Box/Presentation packaging</p><p></p>
427821 <p></p><p>Senzori universali parcare cu display digital. Simplu de montat.</p> <p>Sistemul de parcare este dotat cu 4 senzori performanti ce detecteaza obstacolele din zona in care sunt directionati. Numarul de 4 senzori de parcare permite o acoperire foarte buna a partii din spatele masinii la mersul inapoi, eliminand astfel riscul de a lovi autovehiculul.</p> <p>Caracteristici sistem de asistenta parcare: </p> <p>display digital cu led-uri si patru senzori de parcare<br />3 culori, 7 linii luminoase pentru determinarea distantei pana la obstacol<br />indicatorul luminos directioneaza stanga, centru si dreapta<br />alarma ascendenta pentru evitarea coliziunii<br />in marsarier senzorii detecteaza automat obstacolele<br />distanta de detectare 0.35 - 2.5 metri<br />Cum se monteaza</p> <p>usor de montat, produsul venind cu kit complet de instalare.<br />senzorii se fixeaza in bara din spate a masini conform specificatiilor din manualul produsului, gaurind bara cu ajutorul capului special pentru bormasina inclus in kit.<br />unitatea centrala se fixeaza in portbagaj intr-un loc ferit de umezeala.<br />display-ul se fixeaza oriunde pe bordul masinii cu o banda dublu adeziva.<br />Parametri Tehnici </p> <p>Voltaj 9-27V<br />Intrare 4w-max<br />Beeper 90-105Db<br />Temperatura -30*C+85*C<br />Frecventa 40KHz<br />Dimensiune afisaj: 10 x 2 cm<br />Diametru senzori: 22 mm<br />Acest produs nu este recomandat pentru autovehicule cu bara metalica.</p> <p>Senzorii nu trebuie montati prea strans sau prea lejer.<br />Bara de metal poate afecta performantele sisemului.</p>