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 (5616, 5246) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00020

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (5616,5246)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
5246		<p>Non IMPRES wired RSM with 2.5mm connector and integrated battery. Kit includes USB-A to Micro USB cable for charging.</p><ul><li>Dimensions (W x L x D): 58mm x 84mm x 24mm (without clip)</li><li>Weight includes RSM and cable: 154g</li><li>Battery life: 22 hours min (5/5/90 duty cycle)</li><li>Charge time: 2 hours typical</li><li>Operating voltage: 3.7V DC</li><li>Acoustic: windporting omni-directional</li><li>Emergency Button: no</li><li>Volume Control: no toggle</li><li>Programmable Button: no</li><li>IP Rating: IP67</li><li>Audio Jack 3.5mm: yes (compatible earpiece is PMLN7560A (Non UL))</li><li>Radio compatibility: MOTOTRBO SL series and WAVE Devices and Radios including, TLK100 and TLK110.</li></ul>			TLK100 speaker mic, TLK110 speaker mic
5616	<p><span data-bind="text: label">Audio Jack</span>: <span data-bind="text: value">3.5MM NON-THREADED</span> </p><p><span data-bind="text: label">Channel Control</span>: <span data-bind="text: value">No</span> </p><p><span data-bind="text: label">Display</span>: <span data-bind="text: value">NO DISPLAY</span> </p><p><span data-bind="text: label">Intrinsic Safety Rating</span>: <span data-bind="text: value">NO RATING</span> </p><p><span data-bind="text: label">IP Rating</span>: <span data-bind="text: value">IP67</span> </p><p><span data-bind="text: label">Microphone Type</span>: <span data-bind="text: value">WINDPORTING</span> </p><p><span data-bind="text: label">Programmable Button</span>: <span data-bind="text: value">ORANGE EMERGENCY AND MULTIPLE PROGRAMMABLE BUTTONS</span> </p><p><span data-bind="text: label">Technology</span>: <span data-bind="text: value">WIRELESS</span> </p><p><span data-bind="text: label">Volume Control</span>: <span data-bind="text: value">Yes</span> </p>				WM500, WM-500, PMMN-4127, PMMN4127A, PMMN-4127A, Bluetooth mic, Bluetooth speaker mic, TLK100 microphone, TLK100 BT mic, TLK100 bluetooth mic, TLK-100 bluetooth mic, TLK 100 bluetooth mic, R7 bluetooth mic, MOTOTRBO R7 bluetooth mic, R7 microphone, TLK110, TLK-110, TLK 110