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 (
    9188, 9189, 9190, 9191, 9192, 9193, 9204, 
    9205, 9206, 9207, 9208, 9209, 9210, 
    9211, 9212, 9213, 9221, 9222, 9224, 
    9225, 9226, 9227, 9228, 9229, 9230, 
    9231, 9232, 9233, 9234, 9235, 9236, 
    9237
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00076

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 (9188,9189,9190,9191,9192,9193,9204,9205,9206,9207,9208,9209,9210,9211,9212,9213,9221,9222,9224,9225,9226,9227,9228,9229,9230,9231,9232,9233,9234,9235,9236,9237)) 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
9188 <ul><li>Drop proof MIL-STD 810G 9.9ft (3m)*</li> <li>Non-slip Rubber Bumper</li> <li>Proprietary Impact Rubber Polymer</li> <li>Impact Truss Cushioning System</li> <li>Exposed face for direct touchscreen access</li> <li>Signature Rotating Mute Switch Toggle</li> <li>Slim Profile</li> <li>Clear Case Back</li> <li>Easy to Install/Remove</li> <li>Lanyard Attachment</li> <li>Wrist Lanyard Included</li> </ul>
9189 <ul><li>Drop proof MIL-STD 810G 9.9ft (3m)*</li> <li>Non-slip Rubber Bumper</li> <li>Proprietary Impact Rubber Polymer</li> <li>Impact Truss Cushioning System</li> <li>Exposed face for direct touchscreen access</li> <li>Signature Rotating Mute Switch Toggle</li> <li>Slim Profile</li> <li>Clear Case Back</li> <li>Easy to Install/Remove</li> <li>Lanyard Attachment</li> <li>Wrist Lanyard Included</li> </ul>
9190 <ul><li>Drop proof MIL-STD 810G 9.9ft (3m)*</li> <li>Non-slip Rubber Bumper</li> <li>Proprietary Impact Rubber Polymer</li> <li>Impact Truss Cushioning System</li> <li>Exposed face for direct touchscreen access</li> <li>Signature Rotating Mute Switch Toggle</li> <li>Slim Profile</li> <li>Clear Case Back</li> <li>Easy to Install/Remove</li> <li>Lanyard Attachment</li> <li>Wrist Lanyard Included</li> </ul>
9191 <ul><li>Drop proof MIL-STD 810G 9.9ft (3m)*</li> <li>Non-slip Rubber Bumper</li> <li>Proprietary Impact Rubber Polymer</li> <li>Impact Truss Cushioning System</li> <li>Exposed face for direct touchscreen access</li> <li>Signature Rotating Mute Switch Toggle</li> <li>Slim Profile</li> <li>Clear Case Back</li> <li>Easy to Install/Remove</li> <li>Lanyard Attachment</li> <li>Wrist Lanyard Included</li> </ul>
9192 <ul><li>Drop proof MIL-STD 810G 9.9ft (3m)*</li> <li>Non-slip Rubber Bumper</li> <li>Proprietary Impact Rubber Polymer</li> <li>Impact Truss Cushioning System</li> <li>Exposed face for direct touchscreen access</li> <li>Signature Rotating Mute Switch Toggle</li> <li>Slim Profile</li> <li>Clear Case Back</li> <li>Easy to Install/Remove</li> <li>Lanyard Attachment</li> <li>Wrist Lanyard Included</li> </ul>
9193 <ul><li>Drop proof MIL-STD 810G 9.9ft (3m)*</li> <li>Non-slip Rubber Bumper</li> <li>Proprietary Impact Rubber Polymer</li> <li>Impact Truss Cushioning System</li> <li>Exposed face for direct touchscreen access</li> <li>Signature Rotating Mute Switch Toggle</li> <li>Slim Profile</li> <li>Clear Case Back</li> <li>Easy to Install/Remove</li> <li>Lanyard Attachment</li> <li>Wrist Lanyard Included</li> </ul>
9204 <ul><li>The World's first Real Marble case for iPhone</li> <li>Designed for use with Apple iPhone 7 to protect and complement your phone</li> <li>Thermoplastic polyurethane exterior for stylish looks and durability</li> <li>Corner-to-corner design provides full coverage of your phone for complete protection</li> </ul>
9205 <ul><li>Barely-There Protection that lets you show o your iPhone while protecting it from daily bumps and scratches</li> <li>Looks Out for Your Lens A raised ring encircles the protruding camera lens, forming a protective bumper that safeguards against damage</li> <li>Anti-Slip & Anti-Bacterial</li> <li>The textured surface gives you extra grip</li> </ul>
9206 <ul><li>Barely-There Protection that lets you show o your iPhone while protecting it from daily bumps and scratches</li> <li>Looks Out for Your Lens A raised ring encircles the protruding camera lens forming a protective bumper that safeguards against damage</li> <li>Anti-Slip & Anti-Bacterial</li> <li>The textured surface gives you extra grip</li> </ul>
9207 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand: Native Union</span></li><li><span class="a-list-item">Mobile Accessory Type: Cases & Covers</span></li><li><span class="a-list-item">Compatible with: iPhone</span></li><li><span class="a-list-item">Compatible Devices Model: Apple iPhone 7</span></li><li><span class="a-list-item">Color: Marine</span></li><li><span class="a-list-item">Details: Perfect fit</span></li><li><span class="a-list-item">Precision engineered construction fits your iPhone 7 perfectly and gives access to all ports and functions</span></li></ul>
9208 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Automatically ready and charged</span></li> <li><span class="a-list-item">Talk time up to 3 hours</span></li> <li><span class="a-list-item">Trigger Battery status button</span></li> <li><span class="a-list-item">Lightning connector</span></li> </ul>
9209 <ul><li>The World's first Real Marble case for iPhone</li> <li>Designed for use with Apple iPhone 7 to protect and complement your phone</li> <li>Thermoplastic polyurethane exterior for stylish looks and durability</li> <li>Corner-to-corner design provides full coverage of your phone for complete protection</li> </ul>
9210 <ul><li dir="ltr"> Military strength impact protection. </li> <li dir="ltr"> Shock absorbing bumper. </li> <li dir="ltr"> Refined metallic buttons. </li> </ul>
9211 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Lightweight, minimalist folio-style design with a smooth finish.</span></li> <li><span class="a-list-item">Cover folds into a stand with multiple viewing angles.</span></li> <li><span class="a-list-item">Protective interior case securely holds your iPad in place.</span></li> <li><span class="a-list-item">Microfiber lining keeps your display clean a free from scratches.</span></li> </ul>
9212 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Lightweight, minimalist folio-style design with a smooth finish.</span></li> <li><span class="a-list-item">Cover folds into a stand with multiple viewing angles.</span></li> <li><span class="a-list-item">Protective interior case securely holds your iPad in place.</span></li> <li><span class="a-list-item">Microfiber lining keeps your display clean a free from scratches.</span></li> </ul>
9213 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Transparent glitter coated inlay with smooth finish.</span></li> <li><span class="a-list-item">Ultra slim, dual-layer design with protective bumper.</span></li> <li><span class="a-list-item">Enhanced impact resistance and shock dispersion.</span></li> <li><span class="a-list-item">Color-coordinating metal button accents.</span></li> </ul>
9221 <ul><li>Ultra slim dual layer design with protective bumper</li> <li>Enhanced impact resistance and shock dispersion</li> <li>Transparent smooth finish with anti scratch technology</li> <li>Metal button accents for a refined finish</li> </ul>
9222 <ul><li>Ultra slim, dual-layer design with protective bumper.</li> <li>Enhanced impact resistance and shock dispersion.</li> <li>Transparent smooth finish with anti-scratch technology.</li> <li>Metal button accents for a refined finish.</li> </ul>
9224 <ul><li>Ultra slim dual layer design with protective bumper</li> <li>Enhanced impact resistance and shock dispersion</li> <li>Transparent smooth finish with anti scratch technology</li> <li>Metal button accents for a refined finish</li> </ul>
9225 <ul><li>Ultra slim, dual-layer design with protective bumper.</li> <li>Enhanced impact resistance and shock dispersion.</li> <li>Transparent smooth finish with anti-scratch technology.</li> <li>Metal button accents for a refined finish.</li> </ul>
9226 <ul><li>Ultra slim, dual-layer design with protective bumper.</li> <li>Enhanced impact resistance and shock dispersion.</li> <li>Transparent smooth finish with anti-scratch technology.</li> <li>Metal button accents for a refined finish.</li> </ul>
9227 <ul><li>Genuine gold foil highlights inlaid with a translucent finish.</li> <li>Ultra slim, dual-layer design with protective bumper.</li> <li>Color-coordinating metal button accents.</li> </ul>
9228 <ul><li>Jewelry-inspired genuine iridescent crystals.</li> <li>High gloss metallic finish.</li> <li>Dual layer protection with a slim silhouette.</li> <li>Shock absorbing bumper.</li> <li>Refined metallic buttons.</li> </ul>
9229 <ul><li>Jewelry-inspired genuine iridescent crystals.</li> <li>High gloss metallic finish.</li> <li>Dual layer protection with a slim silhouette.</li> <li>Shock absorbing bumper.</li> <li>Refined metallic buttons.</li> </ul>
9230 <ul><li>Genuine leather and finely crafted chain link.</li> <li>Military strength impact protection.</li> <li>Dual layer protection with a slim silhouette.</li> <li>Full shock absorbing layer.</li> <li>Refined metallic buttons.</li> </ul>
9231 <ul><li>Genuine leather and finely crafted chain link.</li> <li>Military strength impact protection.</li> <li>Dual layer protection with a slim silhouette.</li> <li>Full shock absorbing layer.</li> <li>Refined metallic buttons.</li> </ul>
9232 <ul><li>Genuine leather and finely crafted chain link.</li> <li>Military strength impact protection.</li> <li>Dual layer protection with a slim silhouette.</li> <li>Full shock absorbing layer.</li> <li>Refined metallic buttons.</li> </ul>
9233 <ul><li>Ultra Slim Profile.</li> <li>Lay-flat bezel protects the screen of your iPhone 7.</li> <li>Anti-scratch technology.</li> <li>Metal button accents for a refined finish.</li> </ul>
9234 <ul><li>Ultra slim, dual-layer design with protective bumper.</li> <li>Enhanced impact resistance and shock dispersion.</li> <li>Transparent smooth finish with anti-scratch technology.</li> <li>Metal button accents for a refined finish.</li> </ul>
9235 <ul><li>Ultra slim, dual-layer design with protective bumper.</li> <li>Enhanced impact resistance and shock dispersion.</li> <li>Transparent smooth finish with anti-scratch technology.</li> <li>Metal button accents for a refined finish.</li> </ul>
9236 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Metallic rose gold elements</span></li> <li><span class="a-list-item">Military strength impact protection</span></li> <li><span class="a-list-item">Anti scratch technology and refined natural feel metallic buttons</span></li> </ul>
9237 <ul><li>Ultra Slim Profile.</li> <li>Lay-flat bezel protects the screen of your iPhone 7.</li> <li>Anti-scratch technology.</li> <li>Metal button accents for a refined finish.</li> </ul>