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 (
    8982, 8983, 8986, 8987, 8991, 8992, 8993, 
    8994, 8995, 8996, 8997, 8998, 8999, 
    9000, 9001, 9002, 9003, 9004, 9005, 
    9006, 9007, 9008, 9009, 9010, 9011, 
    9012, 9013, 9014, 9015, 9016, 9017, 
    9018
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00069

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 (8982,8983,8986,8987,8991,8992,8993,8994,8995,8996,8997,8998,8999,9000,9001,9002,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018)) 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
8982 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Styled in kate spade new york's signature colors and materials</span></li> <li><span class="a-list-item">Holds ID and credit cards</span></li> <li><span class="a-list-item">Featuring kate spade new york's signature gold logo detail</span></li> </ul>
8983 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Perfectly fits Device</span></li> <li><span class="a-list-item">Rigid exterior shell</span></li> <li><span class="a-list-item">Access to ports and controls</span></li> <li><span class="a-list-item">Graphic Print</span></li> </ul>
8986 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Sleek, slim profile perfect for everyday use</span></li> <li><span class="a-list-item">Styled in kate spade new york's signature colors and materials</span></li> <li><span class="a-list-item">Featuring kate spade new york's signature gold logo detail</span></li> </ul>
8987 <ul><li>Shock-absorbing frame offers durable, 360-degree protection.</li> <li>Unique origami folding cover doubles as a stand.</li> <li>Stand supports three viewing angles: typing, reading and browsing.</li> <li>Supports iPad's auto-wake/sleep function.</li> </ul>
8991 <ul><li>Extremely thin (< 1.0 mm) protection for your iPhone</li> <li>Hardened surface treatment for enhanced scratch protection</li> <li>Designed and tested to be "flash-friendly" with a customized flash cut-out</li> <li>All iPhone buttons are easily accessible</li> </ul>
8992 <ul><li>Extremely thin (< 1.0 mm) protection for your iPhone</li> <li>Hardened surface treatment for enhanced scratch protection</li> <li>Designed and tested to be "flash-friendly" with a customized flash cut-out</li> <li>All iPhone buttons are easily accessible</li> </ul>
8993 <ul><li>Extremely thin (< 1.0 mm) protection for your iPhone</li> <li>Hardened surface treatment for enhanced scratch protection</li> <li>Designed and tested to be "flash-friendly" with a customized flash cut-out</li> <li>All iPhone buttons are easily accessible</li> </ul>
8994 <p>Carry your cards, cash, and iPhone in one sleek vegan leather case, which combines a weather-proof and durable exterior with soft Terahedron microfiber lining, reinforced with a shatter-proof frame. All buttons and cameras are fully accessible in the case. Overture turns into a convenient stand to watch videos and browse the web, and includes a washable Neato screen cleaner to keep the touchscreen fingerprint and smudge free.<br /></p><ul><li>Four card slots and a full-length inner pocket for additional storage</li> <li>360-degree protection against scratches and shocks</li> <li>Convenient folding stand design for watching videos</li> <li>Equipped with Neato, a detachable and washable microfiber cleaning pad</li> </ul>
8995 <ul><li>360-degree protection against scratches and shocks</li> <li>Convenient folding stand design for watching videos</li> <li>Three card slots and a full-length inner pocket for additional storage</li> <li>All buttons and cameras remain accessible while inside the case</li> <li>Equipped with Neato, a detachable and washable microfibre cleaning pad</li> <li>Offers military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Wireless charging compatible</li> </ul>
8996 <p>Carry your cards, cash, and iPhone in one sleek vegan leather case, which combines a weather-proof and durable exterior with soft Terahedron microfiber lining, reinforced with a shatter-proof frame. All buttons and cameras are fully accessible in the case. Overture turns into a convenient stand to watch videos and browse the web, and includes a washable Neato screen cleaner to keep the touchscreen fingerprint and smudge free.<br /></p><ul><li>Four card slots and a full-length inner pocket for additional storage</li> <li>360-degree protection against scratches and shocks</li> <li>Convenient folding stand design for watching videos</li> <li>Equipped with Neato, a detachable and washable microfiber cleaning pad</li> </ul>
8997 <p>Carry your cards, cash, and iPhone in one sleek vegan leather case, which combines a weather-proof and durable exterior with soft Terahedron microfiber lining, reinforced with a shatter-proof frame. All buttons and cameras are fully accessible in the case. Overture turns into a convenient stand to watch videos and browse the web, and includes a washable Neato screen cleaner to keep the touchscreen fingerprint and smudge free.<br /></p><ul><li>Four card slots and a full-length inner pocket for additional storage</li> <li>360-degree protection against scratches and shocks</li> <li>Convenient folding stand design for watching videos</li> <li>Equipped with Neato, a detachable and washable microfiber cleaning pad</li> </ul>
8998 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">360 degree protection against scratches and shocks</span></li> <li><span class="a-list-item">Kickstand for convenient viewing in both portrait and landscape modes</span></li> <li><span class="a-list-item">Proprietary hybrid construction with fully encased volume and power buttons</span></li> <li><span class="a-list-item">Specialized surface coating to prevent color fading over time</span></li> <li><span class="a-list-item">Wireless charging compatible</span></li> </ul>
8999 <ul><li>Military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Front cover with magnetic clasp for added screen protection</li> <li>Durable surface coating to resist scratches</li> <li>Raised bezel protects your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>
9000 <ul><li>Military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Front cover with magnetic clasp for added screen protection</li> <li>Durable surface coating to resist scratches</li> <li>Raised bezel protects your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>
9001 <ul><li>Moshi's Vitros for iPhone X is a slim, clear case that provides drop-protection in a minimalist form factor.</li><li>Its shock-absorbing frame uses a proprietary metal-vaporization process to create a high-gloss finish that is subtle and refined.</li><li>Not only stylish, Vitros safeguards your iPhone from drops, scratches, and shocks, while also supporting your device’s built-in wireless charging.</li><li>Created using a durable polymer, the case has been tested to resist abrasion, heat, and bending to ensure it retains its luster over time.</li><li>The case features a raised bevel to protect your touchscreen when laid flat, and all buttons, cameras, and ports are easily accessible.</li><li>Vitros is available in Crystal Clear, Jet Silver, Crimson Red, Orchid Pink, Raven Black, and is backed by our limited lifetime warranty.</li></ul>
9002 <ul><li>Ultra-slim case with military-grade drop protection;</li> <li>Durable polymer to resist abrasion, heat, and bending;</li> <li>Fully encased volume and power buttons;</li> <li>Raised bezel to protect your touchscreen when laid flat;</li> <li>Wireless charging compatible</li> </ul><p><br /></p>
9003 <ul><li>Slim case with military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Premium finishing resists abrasion, heat, and bending</li> <li>Clear backside to showcase your iPhone’s design</li> <li>MicroGrid technology ensures clarity and prevents watermarks</li> <li>Fully-encased volume and power buttons</li> <li>Metallized frame with multiple color options</li> <li>Raised bezel to protect your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>
9004 <ul><li>Slim case with military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Premium finishing resists abrasion, heat, and bending</li> <li>Clear backside to showcase your iPhone's design</li> <li>MicroGrid technology ensures clarity and prevents watermarks</li> <li>Fully-encased volume and power buttons</li> <li>Metallized frame with multiple color options</li> <li>Raised bezel to protect your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>
9005 <ul><li>Slim case with military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Premium finishing resists abrasion, heat, and bending</li> <li>Clear backside to showcase your iPhone’s design</li> <li>MicroGrid technology ensures clarity and prevents watermarks</li> <li>Fully-encased volume and power buttons</li> <li>Metallized frame with multiple color options</li> <li>Raised bezel to protect your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul>
9006 <ul><li>Slim case with military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Premium finishing resists abrasion, heat, and bending</li> <li>Clear backside to showcase your iPhone's design</li> <li>MicroGrid technology ensures clarity and prevents watermarks</li> <li>Fully-encased volume and power buttons</li> <li>Metallized frame with multiple color options</li> <li>Raised bezel to protect your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>
9007 <ul><li>Ultra-slim case with military-grade drop protection;</li> <li>Durable polymer to resist abrasion, heat, and bending;</li> <li>Fully encased volume and power buttons;</li> <li>Raised bezel to protect your touchscreen when laid flat;</li> <li>Wireless charging compatible</li> </ul><p><br /></p>
9008 <ul><li>Slim case with military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Premium finishing resists abrasion, heat, and bending</li> <li>Clear backside to showcase your iPhone’s design</li> <li>MicroGrid technology ensures clarity and prevents watermarks</li> <li>Fully-encased volume and power buttons</li> <li>Metallized frame with multiple color options</li> <li>Raised bezel to protect your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>
9009 <ul><li>Slim case with military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Premium finishing resists abrasion, heat, and bending</li> <li>Clear backside to showcase your iPhone's design</li> <li>MicroGrid technology ensures clarity and prevents watermarks</li> <li>Fully-encased volume and power buttons</li> <li>Metallized frame with multiple color options</li> <li>Raised bezel to protect your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>
9010 <ul><li>Slim case with military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>Premium finishing resists abrasion, heat, and bending</li> <li>Clear backside to showcase your iPhone’s design</li> <li>MicroGrid technology ensures clarity and prevents watermarks</li> <li>Fully-encased volume and power buttons</li> <li>Metallized frame with multiple color options</li> <li>Raised bezel to protect your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul>
9011 <ul><li><span class="a-list-item">Military-grade drop protection</span></li><li><span class="a-list-item">Premium quality Apple iPhone XR case</span></li><li><span class="a-list-item">Our case is Compatible with Apple iPhone XR Model</span></li><li><span class="a-list-item">Color Family of Mobile Case is White</span></li></ul>
9012 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Polymer resists abrasion, heat, and bending</li><li class="jsx-1889249662">Fully encased volume and power buttons</li><li class="jsx-1889249662">Raised bezel to protect your touchscreen when laid flat</li><li class="jsx-1889249662">Ultra-slim design with military-grade drop protection</li><li class="jsx-1889249662">Compatible with wireless charging</li></ul>
9013 <ul><li>Proprietary hybrid construction provides ample shock absorption and scratch resistance</li> <li>Ultra-slim case with military-grade drop-protection</li> <li>Polymer resists abrasion, heat, and bending</li> <li>Fully encased volume and power buttons</li> <li>Slim yet robust protection with fully encased volume and power buttons</li> <li>Raised bezel protects the display when the iPhone is laid flat</li> </ul><p><br /></p>
9014 <ul><li>Ultra-slim case with military-grade drop protection</li> <li>Polymer resists abrasion, heat, and bending</li> <li>Fully encased volume and power buttons</li> <li>Raised bezel to protect your touchscreen when laid flat</li> <li>Wireless charging compatible</li> </ul><p><br /></p>
9015 <ul><li>Proprietary hybrid construction provides ample shock absorption and scratch resistance</li> <li>Ultra-slim case with military-grade drop-protection</li> <li>Polymer resists abrasion, heat, and bending</li> <li>Fully encased volume and power buttons</li> <li>Slim yet robust protection with fully encased volume and power buttons</li> <li>Raised bezel protects the display when the iPhone is laid flat</li> </ul><p><br /></p>
9016 <ul><li>Military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>MultiStrap for a secure grip while taking selfies</li> <li>Kickstand mode for watching videos</li> <li>Raised bezel protects your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul>
9017 <ul><li>Military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>MultiStrap for a secure grip while taking selfies</li> <li>Kickstand mode for watching videos</li> <li>Raised bezel protects your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>
9018 <ul><li>Military-grade drop protection (MIL-STD-810G, SGS-certified)</li> <li>MultiStrap for a secure grip while taking selfies</li> <li>Kickstand mode for watching videos</li> <li>Raised bezel protects your touchscreen when laid flat</li> <li>Compatible with wireless charging</li> </ul><p><br /></p>