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 (
    664, 663, 658, 657, 656, 651, 650, 647, 
    645, 644, 641, 639
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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 (664,663,658,657,656,651,650,647,645,644,641,639)) 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
639 <div class="container-fluid-row"> <div class="row-fluid "> <div class="span16 main-content-grid ut2-bottom"> <div class=" cm-warehouse-block-depends-by-location "> <div class="ut2-pb ty-product-block ty-product-detail ut2-big-image "> <div class="ut2-pb__wrapper clearfix"> <div class="ut2-pb__tabs-wrapper"> <div id="tabs_content" class="cm-tabs-content ty-tabs__content clearfix"> <div id="content_description" class="ty-wysiwyg-content content-description" data-ab-smc-tab-hide="N|N|N" data-ab-smc-more="More" data-ab-smc-less="Less" data-ab-smc-height="250" data-ab-smc-tab-override-h="N"> <div> <p>SOFA SET CONTAIN OF 1 THREE SEAT SOFA + 2 TWO SEAT SOFA</p> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="container-fluid-row container-fluid-row-full-width fill--gray"> <div class="row-fluid "> <div class="span16 ut2-top-bottom"> <div class="row-fluid "> <div class="span16 "> <div class="ty-tabs cm-j-tabs cm-j-tabs-disable-convertation clearfix"> </div> </div> </div> </div> </div> </div>
641 <p> SOFA SET CONTAIN OF 1 THREE SEAT SOFA + <span>1 TWO SEAT SOFA </span>+ 1 CHAIRS </p>
644 SOFA SET CONTAIN OF 1 THREE SEAT SOFA + <span>1 TWO SEAT SOFA </span>+ 1 CHAIRS
645 Gorgeous two-piece corner set
647 Gorgeous 6-piece adjustable angle set
650 SOFA SET CONTAIN OF 1 THREE SEAT SOFA + <span>1 TWO SEAT SOFA </span>+ 1 CHAIRS
651 <pre class="tw-data-text tw-text-large tw-ta"><span><strong><span class="Y2IQFc">Bedroom with bed + comedian + desk + 3 wardrobes + mirror</span></strong></span></pre>
656 <div class="container-fluid-row"> <div class="row-fluid "> <div class="span16 main-content-grid ut2-bottom"> <div class=" cm-warehouse-block-depends-by-location "> <div class="ut2-pb ty-product-block ty-product-detail ut2-big-image "> <div class="ut2-pb__wrapper clearfix"> <div class="ut2-pb__tabs-wrapper"> <div id="tabs_content" class="cm-tabs-content ty-tabs__content clearfix"> <div id="content_description" class="ty-wysiwyg-content content-description" data-ab-smc-tab-hide="N|N|N" data-ab-smc-more="More" data-ab-smc-less="Less" data-ab-smc-height="250" data-ab-smc-tab-override-h="N"> <div> <p>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD 6 SASH</p> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="container-fluid-row container-fluid-row-full-width fill--gray"> <div class="row-fluid "> <div class="span16 ut2-top-bottom"> <div class="row-fluid "> <div class="span16 "> <div class="ty-tabs cm-j-tabs cm-j-tabs-disable-convertation clearfix"> </div> </div> </div> </div> </div> </div>
657 <div class="container-fluid-row"> <div class="row-fluid "> <div class="span16 main-content-grid ut2-bottom"> <div class=" cm-warehouse-block-depends-by-location "> <div class="ut2-pb ty-product-block ty-product-detail ut2-big-image "> <div class="ut2-pb__wrapper clearfix"> <div class="ut2-pb__tabs-wrapper"> <div id="tabs_content" class="cm-tabs-content ty-tabs__content clearfix"> <div id="content_description" class="ty-wysiwyg-content content-description" data-ab-smc-tab-hide="N|N|N" data-ab-smc-more="More" data-ab-smc-less="Less" data-ab-smc-height="250" data-ab-smc-tab-override-h="N"> <div> <p>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD 6 SASH</p> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="container-fluid-row container-fluid-row-full-width fill--gray"> <div class="row-fluid "> <div class="span16 ut2-top-bottom"> <div class="row-fluid "> <div class="span16 "> <div class="ty-tabs cm-j-tabs cm-j-tabs-disable-convertation clearfix"> </div> </div> </div> </div> </div> </div>
658 <span>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD 6 SASH</span>
663 <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;">220 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>bed</strong></td> <td style="width: 155.586px;">220 cm</td> <td style="width: 154.289px;">215 cm</td> <td style="width: 154.617px;">136 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>DRESSER</strong></td> <td style="width: 155.586px;">140 cm</td> <td style="width: 154.289px;">40 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;">54 cm</td> <td style="width: 154.289px;">40 cm</td> <td style="width: 154.617px;">50 cm</td> </tr> </tbody> </table> <p> </p>
664 <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="الترجمة"> </pre>