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 (
    751, 750, 749, 747, 744, 743, 742, 741, 
    732, 731, 727, 725
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00053

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 (751,750,749,747,744,743,742,741,732,731,727,725)) 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
725 Great corner design
727 <p><span>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD + BOF</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;"> 270 cm</td> <td style="width: 154.289px;">70 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;">202 cm</td> <td style="width: 154.289px;"> </td> <td style="width: 154.617px;">180 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>DRESSER</strong></td> <td style="width: 155.586px;">150 cm</td> <td style="width: 154.289px;">40 cm</td> <td style="width: 154.617px;">175 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>COMEDINO</strong></td> <td style="width: 155.586px;">46 cm</td> <td style="width: 154.289px;">44 cm</td> <td style="width: 154.617px;">40 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>BOF</strong></td> <td style="width: 155.586px;">40 cm</td> <td style="width: 154.289px;">35 cm</td> <td style="width: 154.617px;">35 cm</td> </tr> </tbody> </table> <p> </p>
731 <p> SOFA SET CONTAIN OF 2 THREE SEAT SOFA +  2 CHAIRS + BIG TABLE + 2 SMALL TABLES</p>
732 <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="الترجمة"><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;">THREE SEAT SOFA</td> <td style="width: 155.586px;"> 207 cm</td> <td style="width: 154.289px;">85 cm</td> <td style="width: 154.617px;">76 cm</td> </tr> <tr> <td style="width: 156.508px;"><span> TWO SEAT SOFA</span></td> <td style="width: 155.586px;">147 cm</td> <td style="width: 154.289px;">85 cm</td> <td style="width: 154.617px;">76 cm</td> </tr> <tr> <td style="width: 156.508px;">CHAIRS</td> <td style="width: 155.586px;">87 cm</td> <td style="width: 154.289px;">85 cm</td> <td style="width: 154.617px;">76 cm</td> </tr> </tbody> </table> <p> </p>
741 <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="الترجمة"><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;"> 220 cm</td> <td style="width: 154.289px;">69 cm</td> <td style="width: 154.617px;">215 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>bed</strong></td> <td style="width: 155.586px;">180 cm</td> <td style="width: 154.289px;">210 cm</td> <td style="width: 154.617px;">125 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>DRESSER</strong></td> <td style="width: 155.586px;">120 cm</td> <td style="width: 154.289px;">45 cm</td> <td style="width: 154.617px;">160 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>COMEDINO</strong></td> <td style="width: 155.586px;">65 cm</td> <td style="width: 154.289px;">45 cm</td> <td style="width: 154.617px;">45 cm</td> </tr> </tbody> </table> <p> </p>
742 <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;"> 260 cm</td> <td style="width: 154.289px;">59 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;">185 cm</td> <td style="width: 154.289px;">204 cm</td> <td style="width: 154.617px;">143 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>DRESSER</strong></td> <td style="width: 155.586px;">149 cm</td> <td style="width: 154.289px;">47 cm</td> <td style="width: 154.617px;">192 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>COMEDINO</strong></td> <td style="width: 155.586px;">63 cm</td> <td style="width: 154.289px;">47 cm</td> <td style="width: 154.617px;">48 cm</td> </tr> </tbody> </table> <p> </p>
743 <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="الترجمة"><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;"> 266 cm</td> <td style="width: 154.289px;">65 cm</td> <td style="width: 154.617px;">229 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>bed</strong></td> <td style="width: 155.586px;">185 cm</td> <td style="width: 154.289px;">204 cm</td> <td style="width: 154.617px;">150 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>DRESSER</strong></td> <td style="width: 155.586px;">147 cm</td> <td style="width: 154.289px;">43 cm</td> <td style="width: 154.617px;">179 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>COMEDINO</strong></td> <td style="width: 155.586px;">63 cm</td> <td style="width: 154.289px;">46 cm</td> <td style="width: 154.617px;">62 cm</td> </tr> </tbody> </table> <p> </p>
744 <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="الترجمة"><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;"> 260 cm</td> <td style="width: 154.289px;">58 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;">254 cm</td> <td style="width: 154.289px;">220 cm</td> <td style="width: 154.617px;">135 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>DRESSER</strong></td> <td style="width: 155.586px;">121 cm</td> <td style="width: 154.289px;">43 cm</td> <td style="width: 154.617px;">181 cm</td> </tr> <tr> <td style="width: 156.508px;"><strong>COMEDINO</strong></td> <td style="width: 155.586px;">85 cm</td> <td style="width: 154.289px;">43 cm</td> <td style="width: 154.617px;">48 cm</td> </tr> </tbody> </table> <p> </p>
747 <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="الترجمة"><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;">THREE SEAT SOFA</td> <td style="width: 155.586px;"> 224 cm</td> <td style="width: 154.289px;">60 cm</td> <td style="width: 154.617px;">82 cm</td> </tr> <tr> <td style="width: 156.508px;"><span> TWO SEAT SOFA</span></td> <td style="width: 155.586px;">190 cm</td> <td style="width: 154.289px;">60 cm</td> <td style="width: 154.617px;">82 cm</td> </tr> <tr> <td style="width: 156.508px;">CHAIRS</td> <td style="width: 155.586px;">84 cm</td> <td style="width: 154.289px;">50 cm</td> <td style="width: 154.617px;">103 cm</td> </tr> </tbody> </table> <p> </p>
749 <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>
750 <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="الترجمة"><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;">THREE SEAT SOFA</td> <td style="width: 155.586px;"> 210 cm</td> <td style="width: 154.289px;">75 cm</td> <td style="width: 154.617px;">80 cm</td> </tr> <tr> <td style="width: 156.508px;"><span> TWO SEAT SOFA</span></td> <td style="width: 155.586px;">150 cm</td> <td style="width: 154.289px;">75 cm</td> <td style="width: 154.617px;">80 cm</td> </tr> <tr> <td style="width: 156.508px;">CHAIRS</td> <td style="width: 155.586px;">90 cm</td> <td style="width: 154.289px;">75 cm</td> <td style="width: 154.617px;">80 cm</td> </tr> </tbody> </table> <p> </p>
751 <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>