Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (5011, 5914, 6795, 6811, 6810, 7853) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00027

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (5011,5914,6795,6811,6810,7853) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	search_words
5011		<h2>Rapid, Reliable Deployment. Use Nationwide On The Wave Wireless Service.</h2><p>Combining the broad coverage of a nationwide cellular network with the ease of two-way radio communications, the WAVE two-way radio TLK 100 gets your team connected fast. </p><p>Keep employees connected and accountable with crisp, clear audio, location tracking and Wi-Fi. Increase efficiency with single-button operations and long battery life. And improve focus without a distracting screen to get in the way. </p><p>Forget building out or maintaining a costly radio infrastructure. Get your team up and running quickly by deploying nationwide push-to-talk in less than 24 hours. You can even use the WAVE two-way radio with your current compatible two-way radio systems and smartphones. There’s no costly or time-consuming FCC or spectrum licensing, or manual programming required. </p><p>As an affordable monthly investment, you can scale your service to match your business needs. And you can reduce or stop your service easily, at any time. </p><p><strong>Key Features: </strong> </p><ul> <li>Over-the-Air Device Management</li> <li>Powerful and Slim Design</li> <li>Wi-Fi Connectivity</li> <li>Location Tracking</li> <li>Battery Lasts Full Shift</li> <li>Loud and Clear Audio</li> <li>Private and Group Push-To-Talk</li> <li>Real-Time Presence</li> </ul>	TLK-100, TLK 100, PoC radio, PoC handheld radio, PTT over cellular radio, HK-2112, HK-2112A, HK2112A, cellular radio, Verizon radio, Verizon PTT, Verizon portable radio, Verizon handheld radio
5914	<p>Price is applicable when the 24 Month Contract is chosen</p>		TLK-150, TLK 150, Verizon mobile radio, Verizon fixed mount radio, PoC radio, PoC mobile radio, PoC fixed mount radio, HK2131, HK2131A, HK-2131, HK-2131A, cellular radio, cellular mobile, cellular fixed mount radio
6795		<h2>A Device Designed For You And Built To Last</h2><p>The TLK 110 combines the flexibility of nationwide push-to-talk communication via broadband with the reliability of a rugged, purpose-built radio. With its effortless device management capabilities, the TLK 110 can be optimized for seamless operations, leaving your business safer, smarter and better connected. </p><p><strong>Key Features: </strong></p><ul> <li>Nationwide push-to-talk via broadband</li> <li>4G network speed</li> <li>Wi-Fi calling over 2.4 + 5 GHz networks</li> <li>Intelligent VOX PTT</li> <li>Ergonomically designed</li> <li>AI-backed noise suppression</li> <li>Wideband Speaker</li> </ul>
6810	<p>Evolve combines the data capabilities of an Android device with the ruggedness and reliability of a business-critical push-to-talk device. A CBRS-ready LTE handheld built for business: it is ready to evolve with your changing network needs.</p>
6811	<p>Communicate and operate confidently with the TLK 25, a wearable WAVE PTX device that expands your capabilities beyond push-to-talk and doesn’t limit your range.</p>
7853	<p>Communicate and operate confidently with the TLK 25, a wearable WAVE PTX device that expands your capabilities beyond push-to-talk and doesn’t limit your range.</p>