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 (
    846, 845, 844, 832, 829, 828, 822, 817, 
    816, 662, 814, 806
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.41"
    },
    "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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "index_condition": "((`betaatif_store`.`cscart_product_descriptions`.`product_id` in (846,845,844,832,829,828,822,817,816,662,814,806)) and (`betaatif_store`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "7.21",
        "eval_cost": "1.20",
        "prefix_cost": "8.41",
        "data_read_per_join": "45K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
662 <p><span>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD 6 SASH</span></p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"><strong><span style="text-decoration: underline;"><span class="Y2IQFc" lang="en" style="font-family: arial, helvetica, sans-serif;">SIZES</span></span></strong></pre> <table style="height: 169px;" width="649"> <tbody> <tr> <td style="width: 156.508px;"><strong>UNIT</strong></td> <td style="width: 155.586px;"><strong>WIDTH SIZE</strong></td> <td style="width: 154.289px;"><strong>DEPTH SIZE</strong></td> <td style="width: 154.617px;"><strong>HEIGHT SIZE</strong></td> </tr> <tr> <td style="width: 156.508px;"><strong>Wardrobe</strong></td> <td style="width: 155.586px;"> 240 cm</td> <td style="width: 154.289px;">62 cm</td> <td style="width: 154.617px;">218 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>bed</strong></td> <td style="width: 155.586px;">126 cm</td> <td style="width: 154.289px;">211 cm</td> <td style="width: 154.617px;">138 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>DRESSER</strong></td> <td style="width: 155.586px;">138 cm</td> <td style="width: 154.289px;">42 cm</td> <td style="width: 154.617px;">76 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>COMEDINO</strong></td> <td style="width: 155.586px;">60 cm</td> <td style="width: 154.289px;">42 cm</td> <td style="width: 154.617px;">46 cm</td> </tr> </tbody> </table> <p> </p>
806 <p><span>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD</span></p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"> </pre>
814 <p><strong>Dining table consisting of a dining table + 8 chairs </strong></p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"> </pre>
816 <p> SOFA SET CONTAIN OF 1 THREE SEAT SOFA + <span>1 TWO SEAT SOFA </span>+ 2 CHAIRS </p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"> </pre>
817 <p> SOFA SET CONTAIN OF 1 THREE SEAT SOFA + <span>1 TWO SEAT SOFA </span>+ 2 CHAIRS </p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"> </pre>
822 <p><span>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD 6 SASH + BOF</span></p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"> </pre>
828 <p>Contemporary corner design</p> <p>SIZE 142 cm X 205 cm</p>
829 <p>Contemporary corner design</p> <p>SIZE 142 cm X 205 cm</p>
832 <p>Contemporary corner design</p> <p> </p>
844 <p><strong>طقم طاولات يتكون من عدد 1  </strong><strong>طاولة وسط + عدد 2 طاولة جانبية</strong></p>
845 <strong>طقم طاولات يتكون من عدد 1  </strong><strong>طاولة وسط + عدد 2 طاولة جانبية</strong>
846 <p><strong>طقم كنب يتكون من طقم عدد 1 كنبه ثلاث مقاعد + عدد 1 كنبه مقعدين + عدد 2 كرسى </strong></p>