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 (
    875, 874, 868, 853, 732, 729, 728, 727, 
    717, 716, 715, 714, 711
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "31.21"
    },
    "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": 13,
      "rows_produced_per_join": 13,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (875,874,868,853,732,729,728,727,717,716,715,714,711)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "28.61",
        "eval_cost": "2.60",
        "prefix_cost": "31.21",
        "data_read_per_join": "49K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
711 <ul><li>Capacity: 46 Liters</li> <li>Convection function</li> <li>Rotisserie function</li> <li>Durable (4) Stainless Steel heating elements.</li> <li>Adjustable thermostat from 100º to 250 º C</li> <li>60-min. timer to program cooking time</li> <li>Full set of accessories: baking tray , wire rack , tray handle , crumb tray</li> <li>Power indicator.</li> <li>Inner lamp for easy viewing</li> </ul>
714 <p>CAPACITY : 36 Liters </p>POWER : 1600 Watt – 50 Hz.- 220 V<br style="font-family:Arial, sans-serif;" />Heating function selector : Off, Upper heating , Lower heating , and both heating.<br style="font-family:Arial, sans-serif;" />Adjustable thermostat from 100 to 250 °C.<br style="font-family:Arial, sans-serif;" />60 –minute time to program cooking time.<br style="font-family:Arial, sans-serif;" />Power indicator<br style="font-family:Arial, sans-serif;" />Full set of accessories :<br style="font-family:Arial, sans-serif;" />backing tray, wire rack , tray handle .<br style="font-family:Arial, sans-serif;" />Convection function.<br style="font-family:Arial, sans-serif;" />Inner lamp for easy Viewing.<br style="font-family:Arial, sans-serif;" /><p>Rotisserie function. </p>
715 <p>Electrical Speed control</p> • Strong power.<br style="font-family:Arial, sans-serif;" />• Dust capacity bag =4.5 Liter<br style="font-family:Arial, sans-serif;" />• Silence design<br style="font-family:Arial, sans-serif;" />• Reusable cloth dust bag.<br style="font-family:Arial, sans-serif;" />• LED dust full indicator.<br style="font-family:Arial, sans-serif;" />• Spray color.<br style="font-family:Arial, sans-serif;" />• HEPA filter.<br style="font-family:Arial, sans-serif;" />• Metal telescopic tube.<br style="font-family:Arial, sans-serif;" />• Metal base floor brush.<br style="font-family:Arial, sans-serif;" />• Power cord length= 5 meters<br style="font-family:Arial, sans-serif;" />• Power : Min. 1800 Watt<br style="font-family:Arial, sans-serif;" />• Max. 2000 watt<br style="font-family:Arial, sans-serif;" /><p>• Voltage: 220 Volt, 50 Hz.</p>
716 <ul><li>Electrical Speed control</li><li>Strong power.</li><li>Dust capacity bag =4.5 Liter</li><li>Silence design</li><li>Reusable cloth dust bag.</li><li>LED dust full indicator.</li><li>Spray color.</li><li>HEPA filter.</li><li>Metal telescopic tube.</li><li>Metal base floor brush.</li><li>Power cord length= 5 meters</li><li>Power : Min. 1800 Watt</li><li>Max. 2000 watt</li><li>Voltage : 220 Volt , 50 Hz.</li></ul>
717 <ul><li>Capacity: 46 Liters</li><li>Power: 1600 Watt</li><li>Convection function</li><li>Rotisserie function</li><li>Durable (4) Stainless Steel heating elements.</li><li>Adjustable thermostat from 100º to 250 º C</li><li>60-min. timer to program cooking time</li><li>Full set of accessories: baking tray , wire rack , tray handle , crumb tray</li><li>Power indicator.</li><li>Inner lamp for easy viewing</li></ul>
727 <ul><li>Capacity: 46 Liters</li> <li>Power: 1600 Watt</li> <li>Convection function</li> <li>Rotisserie function</li> <li>Durable (4) Stainless Steel heating elements.</li> <li>Adjustable thermostat from 100º to 250 º C</li> <li>60-min. timer to program cooking time</li> <li>Full set of accessories: baking tray , wire rack , tray handle , crumb tray</li> <li>Power indicator.</li> <li>Inner lamp for easy viewing</li> </ul>
728 <ul><li>3 speed control</li> <li>Round base & Deluxe design</li> <li>With timer 2 hours</li> <li>Blade (5) pcs from ABS</li> <li>Power 90 watt</li> <li>220V/ 50Hz</li> <li>Warranty 1 Year</li> </ul>
729 <ul><li>Blade size : 18 Inch</li> <li>motor power: 80 watt</li> <li>Voltage : 220 – 240</li> <li>Frequency: 50 Hz.</li> <li>Speed control: 3</li> </ul>
732 <ul><li>3 speed control</li><li>Round base & Deluxe design</li><li>With timer 2 hours</li><li>Blade (5) pcs from ABS</li><li>Power 90 watt</li><li>220 V / 50 Hz</li></ul>
853 <ul><li>Blade size: 16 Inch.</li><li>motor power: 40 watt</li><li>Voltage: 220 – 240</li><li>Frequency: 50 hz.</li><li>Speed control:3</li><li>With timer : 2 hours</li></ul>
868 <ul><li>Dry Ironing Function</li><li>Spray & Steam Function</li><li>Self-Cleaning Function</li><li>Soft Grip Handle</li><li>Powerful Burst Steam</li><li>Vertical Steam Function</li><li>Adjustable Thermostat Control</li><li>Flexible 360 Degree Swivel Cord Guard</li><li>Overheat Safety Protection</li><li>Indicate Light</li><li>Ceramic Soleplate</li><li>220V / 50Hz / 2200W</li></ul>
874 <ul><li>Corded & Cordless Steam Iron</li><li>Dry, Spray, Steam</li><li>Vertical steam</li><li>Horizontal steam</li><li>Rubberized handle</li><li>Self cleaning</li><li>Salt resistant</li><li>Powerful burst of steam</li><li>Stainless Steel Base</li><li>Corded or Cordless</li><li>Ac 220v – 50Hz- 2200w</li><li>Dry, Steam, Spray iron</li><li>Unbreakable/non-stick coating soleplate</li><li>Automatic cord rewind system on back cover</li></ul>
875 <ul><li>Model Number: AR-302</li><li>Power ( watt) : 2200</li><li>Multiple Stainless Steel Soleplate.</li><li>Dry Ironing function</li><li>Spray & Steam function</li><li>Self-Cleaning function.</li><li>Soft Grip Handle</li><li>Powerful Burst Steam</li><li>Vertical Steam function</li></ul>