SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    3715, 3716, 3717, 3718, 3719, 3720, 3721, 
    3722, 3723, 3724, 3725, 3726, 3727, 
    3728, 3729, 3730, 3731, 3732, 3733, 
    3734, 3735, 3737, 3738, 3740, 3741, 
    3742, 3743, 3747, 3748, 3749
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00071

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.01"
    },
    "table": {
      "table_name": "q_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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (3715,3716,3717,3718,3719,3720,3721,3722,3723,3724,3725,3726,3727,3728,3729,3730,3731,3732,3733,3734,3735,3737,3738,3740,3741,3742,3743,3747,3748,3749)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "66.01",
        "eval_cost": "6.00",
        "prefix_cost": "72.01",
        "data_read_per_join": "114K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
3715 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Bottle body is made of durable stainless steel for long-lasting use</li><li class="jsx-1889249662">Spout and lid are made of 100% food-grade plastic</li><li class="jsx-1889249662">Ergonomically designed for a firm and comfortable grip</li></ul>
3716 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Bottle body is made of durable stainless steel for long-lasting use</li><li class="jsx-1889249662">Spout and lid are made of 100% food-grade plastic</li><li class="jsx-1889249662">Ergonomically designed for a firm and comfortable grip</li></ul>
3717 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Bottle body is made of durable stainless steel for long-lasting use</li><li class="jsx-1889249662">Spout and lid are made of 100% food-grade plastic</li><li class="jsx-1889249662">Ergonomically designed for a firm and comfortable grip</li></ul>
3718 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Bottle body is made of durable stainless steel for long-lasting use</li><li class="jsx-1889249662">Spout and lid are made of 100% food-grade plastic</li><li class="jsx-1889249662">Ergonomically designed for a firm and comfortable grip</li></ul>
3719 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3720 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3721 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3722 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3723 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3724 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3725 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3726 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Bottle body is made of durable stainless steel for long-lasting use</li><li class="jsx-1889249662">Spout and lid are made of 100% food-grade plastic</li><li class="jsx-1889249662">Ergonomically designed for a firm and comfortable grip</li></ul>
3727 <p>ideal for fruits, vegetable storage and much more / airtight container / the nestable system of Lock & Lock Salad Bowl helps to minimize space during storage / very convenient to go from refrigerator to tabletop with clean and attractive bowl type design / microwave OK / save food / save space / save money / microwave and freezer safe / liquid tight / dishwasher safe</p>
3728 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3729 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Large locking hinges for easy open and close movement</li><li class="jsx-1889249662">Made of borosilicate glass which withstands high heat and sudden cooling</li></ul>
3730 <ul><li>100% airtight / water proof / dust proof / insect proof / odor proof / excellence in durability / re-usable</li></ul>
3731 <ul><li>100% airtight / water proof / dust proof / insect proof / odor proof / excellence in durability / re-usable </li></ul>
3732 <p>100% airtight / water proof / dust proof / insect proof / odor proof / excellence in durability / re-usable</p>
3733 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Made from food safe borosilicate glass material</li><li class="jsx-1889249662">Airtight lids to keep your food fresh</li><li class="jsx-1889249662">Heat-resistant glass can withstand sudden change in temperature</li></ul>
3734 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Made from food safe borosilicate glass material</li><li class="jsx-1889249662">Airtight lids to keep your food fresh</li><li class="jsx-1889249662">Heat-resistant glass can withstand sudden change in temperature</li></ul>
3735 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Made from food safe borosilicate glass material</li><li class="jsx-1889249662">Airtight lids to keep your food fresh</li><li class="jsx-1889249662">Heat-resistant glass can withstand sudden change in temperature</li></ul>
3737 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Equipped with a zippered closure that allows you to keep your things securely</li><li class="jsx-1889249662">Contains a strap that allows you to comfortably carry it around</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3738 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Equipped with a zippered closure that allows you to keep your things securely</li><li class="jsx-1889249662">Contains a strap that allows you to comfortably carry it around</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3740 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Equipped with a zippered closure that allows you to keep your things securely</li><li class="jsx-1889249662">Contains a strap that allows you to comfortably carry it around</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3741
3742 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Equipped with a zippered closure that allows you to keep your things securely</li><li class="jsx-1889249662">Contains a strap that allows you to comfortably carry it around</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3743 <p>Excellent insulation and insulation effect using high-grade insulation material / You can extend cool and warm time much more if you put the ice pack into the bag / Stylish toddler style / Stain-resistant silver lining material</p>
3747 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li></ul>
3748 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3749 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>