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 (
    814, 798, 797, 795, 765, 764, 763, 762, 
    809, 810, 715, 709
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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 (814,798,797,795,765,764,763,762,809,810,715,709)) 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
709 <p><strong>Dining table consisting of a dining table + 6 regular chairs + 2 armchairs + buffet</strong></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 style="height: 27px;"> <td style="width: 156.508px; height: 27px;"><strong>UNIT</strong></td> <td style="width: 155.586px; height: 27px;"><strong>WIDTH SIZE</strong></td> <td style="width: 154.289px; height: 27px;"><strong>DEPTH SIZE</strong></td> <td style="width: 154.617px; height: 27px;"><strong>HEIGHT SIZE</strong></td> </tr> <tr style="height: 27px;"> <td style="width: 156.508px; height: 27px;"><strong>table</strong></td> <td style="width: 155.586px; height: 27px;"> 220 cm</td> <td style="width: 154.289px; height: 27px;">106 cm</td> <td style="width: 154.617px; height: 27px;">74 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 156.508px; height: 27px;"><strong>chair</strong></td> <td style="width: 155.586px; height: 27px;">52 cm</td> <td style="width: 154.289px; height: 27px;">60 cm</td> <td style="width: 154.617px; height: 27px;">100 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 156.508px; height: 27px;"><strong>buffet</strong></td> <td style="width: 155.586px; height: 27px;">160 cm</td> <td style="width: 154.289px; height: 27px;">45 cm</td> <td style="width: 154.617px; height: 27px;">90 cm</td> </tr> <tr style="height: 0.390625px;"> <td style="width: 156.508px; height: 0.390625px;"> <strong>chair 2</strong></td> <td style="width: 155.586px; height: 0.390625px;"> 62</td> <td style="width: 154.289px; height: 0.390625px;"> 45</td> <td style="width: 154.617px; height: 0.390625px;"> 100</td> </tr> </tbody> </table> <p><span style="font-size: 8pt;">Volumes may increase or decrease slightly</span></p>
715 <p><strong>Dining table consisting of a dining table + 6 regular chairs + 2 armchairs + buffet</strong></p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"> </pre>
762 <p><strong>DINING TABLE CONTAIN OF TABLE + 6 CHAIRS + BUFFET</strong></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: 120px;" width="647"> <tbody> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>UNIT</strong></td> <td style="width: 155.094px; height: 27px;"><strong>WIDTH SIZE</strong></td> <td style="width: 153.781px; height: 27px;"><strong>DEPTH SIZE</strong></td> <td style="width: 154.156px; height: 27px;"><strong>HEIGHT SIZE</strong></td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>table</strong></td> <td style="width: 155.094px; height: 27px;"> 164 cm</td> <td style="width: 153.781px; height: 27px;">98 cm</td> <td style="width: 154.156px; height: 27px;">75 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>buffet</strong></td> <td style="width: 155.094px; height: 27px;">200 cm</td> <td style="width: 153.781px; height: 27px;">46 cm</td> <td style="width: 154.156px; height: 27px;">75 cm</td> </tr> </tbody> </table> <p> </p>
763 <p><strong>DINING TABLE CONTAIN OF TABLE + 12 CHAIRS + BUFFET</strong></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: 138px;" width="646"> <tbody> <tr style="height: 27px;"> <td style="width: 155.695px; height: 27px;"><strong>UNIT</strong></td> <td style="width: 154.844px; height: 27px;"><strong>WIDTH SIZE</strong></td> <td style="width: 153.523px; height: 27px;"><strong>DEPTH SIZE</strong></td> <td style="width: 153.938px; height: 27px;"><strong>HEIGHT SIZE</strong></td> </tr> <tr style="height: 27px;"> <td style="width: 155.695px; height: 27px;"><strong>table</strong></td> <td style="width: 154.844px; height: 27px;"> 360 cm</td> <td style="width: 153.523px; height: 27px;">115 cm</td> <td style="width: 153.938px; height: 27px;">78 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.695px; height: 27px;"><strong>chair</strong></td> <td style="width: 154.844px; height: 27px;">85 cm</td> <td style="width: 153.523px; height: 27px;">61 cm</td> <td style="width: 153.938px; height: 27px;">118 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.695px; height: 27px;"><strong>buffet</strong></td> <td style="width: 154.844px; height: 27px;">182 cm</td> <td style="width: 153.523px; height: 27px;">40 cm</td> <td style="width: 153.938px; height: 27px;">90 cm</td> </tr> </tbody> </table> <p><span style="font-size: 8pt;">Volumes may increase or decrease slightly</span></p>
764 <p><strong>DINING TABLE CONTAIN OF TABLE + 12 CHAIRS + BUFFET</strong></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: 142px;" width="647"> <tbody> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>UNIT</strong></td> <td style="width: 155.094px; height: 27px;"><strong>WIDTH SIZE</strong></td> <td style="width: 153.781px; height: 27px;"><strong>DEPTH SIZE</strong></td> <td style="width: 154.156px; height: 27px;"><strong>HEIGHT SIZE</strong></td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>table</strong></td> <td style="width: 155.094px; height: 27px;"> 328 cm</td> <td style="width: 153.781px; height: 27px;">120 cm</td> <td style="width: 154.156px; height: 27px;">78 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>chair</strong></td> <td style="width: 155.094px; height: 27px;">85 cm</td> <td style="width: 153.781px; height: 27px;">72 cm</td> <td style="width: 154.156px; height: 27px;">154 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>buffet</strong></td> <td style="width: 155.094px; height: 27px;">180 cm</td> <td style="width: 153.781px; height: 27px;">40 cm</td> <td style="width: 154.156px; height: 27px;">90 cm</td> </tr> </tbody> </table> <p><span style="font-size: 8pt;">Volumes may increase or decrease slightly</span></p>
765 <p><strong>DINING TABLE CONTAIN OF TABLE + 8 CHAIRS + BUFFET</strong></p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"> </pre>
795 <p><strong>Dining table consisting of a dining table + 6 regular chairs + 2 armchairs + buffet</strong></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 style="height: 27px;"> <td style="width: 156.508px; height: 27px;"><strong>UNIT</strong></td> <td style="width: 155.586px; height: 27px;"><strong>WIDTH SIZE</strong></td> <td style="width: 154.289px; height: 27px;"><strong>DEPTH SIZE</strong></td> <td style="width: 154.617px; height: 27px;"><strong>HEIGHT SIZE</strong></td> </tr> <tr style="height: 27px;"> <td style="width: 156.508px; height: 27px;"><strong>table</strong></td> <td style="width: 155.586px; height: 27px;"> 200 cm</td> <td style="width: 154.289px; height: 27px;">100 cm</td> <td style="width: 154.617px; height: 27px;">74 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 156.508px; height: 27px;"><strong>chair</strong></td> <td style="width: 155.586px; height: 27px;">51 cm</td> <td style="width: 154.289px; height: 27px;">56 cm</td> <td style="width: 154.617px; height: 27px;">95 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 156.508px; height: 27px;"><strong>buffet</strong></td> <td style="width: 155.586px; height: 27px;">150 cm</td> <td style="width: 154.289px; height: 27px;">50 cm</td> <td style="width: 154.617px; height: 27px;">90 cm</td> </tr> <tr style="height: 0.390625px;"> <td style="width: 156.508px; height: 0.390625px;"> <strong>chair 2</strong></td> <td style="width: 155.586px; height: 0.390625px;"> 60</td> <td style="width: 154.289px; height: 0.390625px;"> 50</td> <td style="width: 154.617px; height: 0.390625px;"> 90</td> </tr> </tbody> </table> <p><span style="font-size: 8pt;">Volumes may increase or decrease slightly</span></p>
797 <p><strong>DINING TABLE CONTAIN OF TABLE + 12 CHAIRS + BUFFET</strong></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: 142px;" width="647"> <tbody> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>UNIT</strong></td> <td style="width: 155.094px; height: 27px;"><strong>WIDTH SIZE</strong></td> <td style="width: 153.781px; height: 27px;"><strong>DEPTH SIZE</strong></td> <td style="width: 154.156px; height: 27px;"><strong>HEIGHT SIZE</strong></td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>table</strong></td> <td style="width: 155.094px; height: 27px;">315 cm</td> <td style="width: 153.781px; height: 27px;">118 cm</td> <td style="width: 154.156px; height: 27px;">76 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>chair</strong></td> <td style="width: 155.094px; height: 27px;">75 cm</td> <td style="width: 153.781px; height: 27px;">86 cm</td> <td style="width: 154.156px; height: 27px;">126 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>buffet</strong></td> <td style="width: 155.094px; height: 27px;">174 cm</td> <td style="width: 153.781px; height: 27px;">54 cm</td> <td style="width: 154.156px; height: 27px;">90 cm</td> </tr> </tbody> </table> <p><span style="font-size: 8pt;">Volumes may increase or decrease slightly</span></p>
798 <p><strong>DINING TABLE CONTAIN OF TABLE + 12 CHAIRS + BUFFET</strong></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: 142px;" width="647"> <tbody> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>UNIT</strong></td> <td style="width: 155.094px; height: 27px;"><strong>WIDTH SIZE</strong></td> <td style="width: 153.781px; height: 27px;"><strong>DEPTH SIZE</strong></td> <td style="width: 154.156px; height: 27px;"><strong>HEIGHT SIZE</strong></td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>table</strong></td> <td style="width: 155.094px; height: 27px;">315 cm</td> <td style="width: 153.781px; height: 27px;">118 cm</td> <td style="width: 154.156px; height: 27px;">76 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>chair</strong></td> <td style="width: 155.094px; height: 27px;">75 cm</td> <td style="width: 153.781px; height: 27px;">86 cm</td> <td style="width: 154.156px; height: 27px;">126 cm</td> </tr> <tr style="height: 27px;"> <td style="width: 155.969px; height: 27px;"><strong>buffet</strong></td> <td style="width: 155.094px; height: 27px;">174 cm</td> <td style="width: 153.781px; height: 27px;">54 cm</td> <td style="width: 154.156px; height: 27px;">90 cm</td> </tr> </tbody> </table> <p><span style="font-size: 8pt;">Volumes may increase or decrease slightly</span></p>
809 <p><strong>Dining table consisting of a dining table + 10 chairs + buffet</strong></p> <pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="الترجمة"> </pre>
810 <p><strong>Dining table consisting of a dining table + 10 chairs + buffet</strong></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>