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, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (286) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.01037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

product_id short_description full_description unit_name
286 <p></p><h1><span class="a-size-large product-title-word-break">&nbsp;مقاومة للماء للعمل والسفر والجامعة للنساء والرجال لون اسود ورمادي وازرق واحمر من جرينغلوب</span></h1> <p><a href="https://www.amazon.eg/s/ref=bl_dp_s_web_0?ie=UTF8&search-alias=aps&field-keywords=%D8%AC%D8%B1%D9%8A%D9%86%D8%BA%D9%84%D9%88%D8%A8" id="bylineInfo" class="a-link-normal">العلامة التجارية: جرينغلوب</a></p> <p><span class="a-declarative" data-action="acrStarsLink-click-metrics" data-acrstarslink-click-metrics="{}"><span class="reviewCountTextLinkedHistogram noUnderline" title="3.4 من 5 نجوم"><span class="a-declarative" data-action="a-popover" data-a-popover="{&quot;max-width&quot;:&quot;700&quot;,&quot;closeButton&quot;:&quot;true&quot;,&quot;closeButtonLabel&quot;:&quot;إغلاق&quot;,&quot;position&quot;:&quot;triggerBottom&quot;,&quot;popoverLabel&quot;:&quot;ملخص تقييمات مراجعات المستخدمين&quot;,&quot;url&quot;:&quot;/gp/customer-reviews/widgets/average-customer-review/popover/ref=dpx_acr_pop_?contextId=dpx&asin=B08Z3N91V8&quot;}"><span class="a-size-small a-color-base">3.4&nbsp;</span><i class="a-icon a-icon-star-mini a-star-mini-3-5 mvt-cm-cr-review-stars-mini"><span class="a-icon-alt">3.4 من 5 نجوم</span></i>&nbsp;<i class="a-icon a-icon-popover"></i>&nbsp;</span></span></span><span class="a-letter-space"></span>&nbsp;<span class="a-declarative" data-action="acrLink-click-metrics" data-acrlink-click-metrics="{}"><a href="https://www.amazon.eg/%D9%85%D9%82%D8%A7%D9%88%D9%85%D8%A9-%D9%88%D8%A7%D9%84%D8%B3%D9%81%D8%B1-%D9%88%D8%A7%D9%84%D8%AC%D8%A7%D9%85%D8%B9%D8%A9-%D9%88%D8%A7%D9%84%D8%B1%D8%AC%D8%A7%D9%84-%D8%AC%D8%B1%D9%8A%D9%86%D8%BA%D9%84%D9%88%D8%A8/dp/B08Z3N91V8/ref=sr_1_19?adgrpid=190660480051&dib=eyJ2IjoiMSJ9.LRFJooNCzzLl7eBoCVxrJqXactXD-G6ksPJQtJx8VcH-zn-gbRfkih-O2AHCFHFFPTsxyyskJxscTLYYtdjPCovBAQHHEMNOqirxx-S5zaoNqEpsk5HQ3xZPOM4ELrJffBl9FFpZ7CNe2eltjNUA7Lk2jY1gPW95JWczP4NYRIdGD4YczweZjBg8iVCfOWOwzej_qol_EwC8fc411llchzwflh1xs58jKzbaVwrUtATvcb2pN9rhX-Xsj99qygtQYD-RBDSlOwlxmATzxeqtQynXBv3pnnnvzl1zMulh9nA.GwXA7JCPeyma7Q2MWneepHKJ8B0AkxBu2RYqPbMaVf0&dib_tag=se&hvadid=772656707212&hvdev=c&hvlocphy=9218366&hvnetw=g&hvqmt=e&hvrand=6892686503718802966&hvtargid=kwd-10573980&hydadcr=28201_2360448&keywords=amazon&mcid=cf678a1eb6c03c73b03e5db2033f993d&qid=1777364533&sr=8-19#averageCustomerReviewsAnchor" id="acrCustomerReviewLink" class="a-link-normal"><span class="a-size-small">(1</span></a></span></p>