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 (
    3628, 3629, 3630, 3631, 3632, 3633, 3634, 
    3635, 3636, 3637, 3638, 3639, 3640, 
    3641, 3642, 3643, 3644, 3645, 3646, 
    3647, 3648, 3649, 3650, 3651, 3652, 
    3653, 3654, 3655, 3656, 3657, 3658, 
    3659
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00081

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.81"
    },
    "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": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,3642,3643,3644,3645,3646,3647,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3658,3659)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "70.41",
        "eval_cost": "6.40",
        "prefix_cost": "76.81",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
3628 <ul><li>Self-breathing valve that automatically exhausts gas </li><li>Easy to see with clear glass body </li><li>Easy to wash with wide opening </li><li> Handle that gices a great mobility </li><li>BPA free / Suit for fermented food storage such as homemade drinks or fermented fruit drinks</li></ul>
3629 <ul><li>Self-breathing valve that automatically exhausts gas </li><li> Easy to see with clear glass body / Easy to wash with wide opening </li><li> Handle that gices a great mobility / BPA free / Suit for fermented food storage such as homemade drinks or fermented fruit drinks</li></ul>
3630 <p>keep food fresh longer via lock&lock air tight technology / flowing shape fits in from to table / eco-friendly PP materials keep you safe / far less prone to breakages / approx 11% lighter than tempered glass / conventional oven and freezer safe</p>
3631 <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>
3632 <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>
3633 <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>
3634 <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>
3635 <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>
3636 <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>
3637 <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>
3638 <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>
3639 <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>
3640 <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>
3641 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">It allows you to use it safely in the oven, microwave and dishwasher</li><li class="jsx-1889249662">Made of up of Highly Durable Material</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3642 <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>
3643 <ul><li>easy to clean </li><li> stackable </li><li> Shapes and size helps for different use according to customer usage and it has transparency to see inside the tray</li></ul>
3644 <p>easy to clean / stackable / Shapes and size helps for different use according to customer usage and it has transparency to see inside the tray</p>
3645 <p>easy to clean / stackable / Shapes and size helps for different use according to customer usage and it has transparency to see inside the tray</p>
3646 <ul><li>storing rice, wheat flour, beans and dry foods etc. </li><li> easy to open & close by flip top lid / BPA Free </li></ul>
3647 <p>absolutely airtight & liquid tight, space saving & multipurpose stackable airtight container, dishwasher & microwave safe, BPA Free</p>
3648 <ul><li>storing cereal, oatmeal, wheat flour, baking ingredients, etc /</li><li>easy pour / flip top lid / BPA Free /</li></ul>
3649 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Lock & Lock</span></li><li><span class="a-list-item">Material : Plastic</span></li><li><span class="a-list-item">Dishwasher proof : No</span></li><li><span class="a-list-item">Type : Water Bottle</span></li><li><span class="a-list-item">Microwave Proof : No</span></li></ul>
3650 <ul><li>slim line design fits conveniently in fridge doors </li><li> made from transparent polypropylene </li><li>great for water and fruit juices</li></ul>
3651 <ul><li>triple layer bag with insulating material </li><li> easy to wash - smooth waterproof lining inside</li></ul>
3652 <ul><li>Triple Layer Bag with Insulating Material </li><li> easy to Wash - Smooth Waterproof Lining Inside</li></ul>
3653 <ul><li>triple layer bag with insulating material </li><li> easy to wash - smooth waterproof lining inside</li></ul>
3654 <ul><li>triple layer bag with insulating material </li><li>easy to wash - smooth waterproof lining inside</li></ul>
3655 <ul><li>triple layer bag with insulating material </li><li>easy to wash - smooth waterproof lining inside</li></ul>
3656 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Confers a lid that effectively prevents food contamination</li><li class="jsx-1889249662">It has a sleek and compact design that makes it easy to carry</li><li class="jsx-1889249662">Large storage capacity ensures comfortable accommodation to your food</li></ul>
3657 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Confers a lid that effectively prevents food contamination</li><li class="jsx-1889249662">It has a sleek and compact design that makes it easy to carry</li><li class="jsx-1889249662">Large storage capacity ensures comfortable accommodation to your food</li></ul>
3658 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Generously designed to allow stacking your tiffin boxes</li><li class="jsx-1889249662">Profound zipper closure warrants added safety and avoid any spillage</li><li class="jsx-1889249662">Topped with an easy grab handle that boosts carrying efficiency</li><li class="jsx-1889249662">Curated from quality-grade material that withstands wear and tear</li></ul>
3659 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Generously designed to allow stacking your tiffin boxes</li><li class="jsx-1889249662">Profound zipper closure warrants added safety and avoid any spillage</li><li class="jsx-1889249662">Topped with an easy grab handle that boosts carrying efficiency</li><li class="jsx-1889249662">Curated from quality-grade material that withstands wear and tear</li></ul>