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 (
    3672, 3673, 3674, 3676, 3677, 3678, 3679, 
    3680, 3681, 3682, 3683, 3684, 3685, 
    3686, 3687, 3688, 3689, 3690, 3691, 
    3692, 3693, 3694, 3695, 3696, 3697, 
    3698, 3699, 3700, 3701, 3702
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00062

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 (3672,3673,3674,3676,3677,3678,3679,3680,3681,3682,3683,3684,3685,3686,3687,3688,3689,3690,3691,3692,3693,3694,3695,3696,3697,3698,3699,3700,3701,3702)) 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
3672 <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>
3673 <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>
3674 <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>
3676 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Moulded from high-grade material to avoid chipping even through prolonged usage</li><li class="jsx-1889249662">Exudes an exquisite craftsmanship that manifests an accentuating show</li><li class="jsx-1889249662">Fade-proof construction resists catching stains, facilitating easy cleaning</li></ul>
3677 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Allows to keep the food fresh and sealed in a container</li><li class="jsx-1889249662">Resists catching stains, facilitating easy cleaning</li><li class="jsx-1889249662">Incorporates a lid that prevents contamination</li></ul>
3678 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Airtight seal with great elasticity power locks</li><li class="jsx-1889249662">Safe of microwave, freezer and dishwasher</li></ul>
3679 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Airtight seal with great elasticity power locks</li><li class="jsx-1889249662">Safe of microwave, freezer and dishwasher</li></ul>
3680 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3681 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3682 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3683 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3684 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3685 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3686 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3687 <p><del> </del></p><ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul><p><del></del></p>
3688 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3689 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Allows to keep the food fresh and sealed in a container</li><li class="jsx-1889249662">Resists catching stains, facilitating easy cleaning</li><li class="jsx-1889249662">Incorporates a lid that prevents contamination</li></ul>
3690 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3691 <p>absolutely airtight & liquid tight, space saving & multipurpose stackable airtight container, dishwasher & microwave safe, BPA Free</p>
3692 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Airtight seal with great elasticity power locks</li><li class="jsx-1889249662">Safe of microwave, freezer and dishwasher</li></ul>
3693 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Airtight seal with great elasticity power locks</li><li class="jsx-1889249662">Safe of microwave, freezer and dishwasher</li></ul>
3694 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Airtight seal with great elasticity power locks</li><li class="jsx-1889249662">Safe of microwave, freezer and dishwasher</li></ul>
3695 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3696 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Allows to keep the food fresh and sealed in a container</li><li class="jsx-1889249662">Resists catching stains, facilitating easy cleaning</li><li class="jsx-1889249662">Incorporates a lid that prevents contamination</li></ul>
3697 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Spaciously designed to allow storing a generous quantity of food</li><li class="jsx-1889249662">Incorporates an airtight lid that helps keep food fresh for extended period of time</li><li class="jsx-1889249662">Resists catching stains and odours, facilitating hassle-free cleaning</li><li class="jsx-1889249662">Food-grade quality material ensures safety of health</li></ul>
3698 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Moulded from high-grade material to avoid chipping even through prolonged usage</li><li class="jsx-1889249662">Exudes an exquisite craftsmanship that manifests an accentuating show</li><li class="jsx-1889249662">Fade-proof construction resists catching stains, facilitating easy cleaning</li></ul>
3699 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Moulded from high-grade material to avoid chipping even through prolonged usage</li><li class="jsx-1889249662">Exudes an exquisite craftsmanship that manifests an accentuating show</li><li class="jsx-1889249662">Fade-proof construction resists catching stains, facilitating easy cleaning</li></ul>
3700 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Moulded from high-grade material to avoid chipping even through prolonged usage</li><li class="jsx-1889249662">Exudes an exquisite craftsmanship that manifests an accentuating show</li><li class="jsx-1889249662">Fade-proof construction resists catching stains, facilitating easy cleaning</li></ul>
3701 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Moulded from high-grade material to avoid chipping even through prolonged usage</li><li class="jsx-1889249662">Exudes an exquisite craftsmanship that manifests an accentuating show</li><li class="jsx-1889249662">Fade-proof construction resists catching stains, facilitating easy cleaning</li></ul>
3702 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Moulded from high-grade material to avoid chipping even through prolonged usage</li><li class="jsx-1889249662">Exudes an exquisite craftsmanship that manifests an accentuating show</li><li class="jsx-1889249662">Fade-proof construction resists catching stains, facilitating easy cleaning</li></ul>