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 (4135, 5111, 5110, 6801, 6802, 6176) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00022

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": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4135,5111,5110,6801,6802,6176)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	search_words
4135		<p>This earpiece is compatible with all Remote Speaker Microphones with a 3.5 mm audio jack on the head of the microphone. </p><p>UL certified TIA 4950 approved when used with a UL certified TIA 4950 approved APX 4000 two knob radio </p>	AARLN4885A, AARLN4885B, BPR20 Speaker Mic, CP200XLS Speaker Mic, CP200d Speaker Mic, CP200 Speaker Mic, CP185 Speaker Mic, BPR40 Speaker Mic, XPR3300 Speaker Mic, XPR3500 Speaker Mic, XPR6100 Speaker Mic, XPR6350 Speaker Mic, XPR6550 Speaker Mic, XPR6380 Speaker Mic, XPR6580 Speaker Mic, XPR7350 Speaker Mic, XPR7380 Speaker Mic, XPR7550 Speaker Mic, XPR7580 Speaker Mic, APX1000 Speaker Mic, APX3000 Speaker Mic, APX4000 Speaker Mic, APX6000 Speaker Mic, APX7000 Speaker Mic, APX600XE Speaker Mic, APX7000XE Speaker Microphones, AARLN-4885, AARLN4885A, AARLN-4885A, AARLN-4885B
5110	<p>Compatible with APX radios, this APX remote speaker microphone is the XE500 high impact green, with no channel knob, includes xtreme temperature cable.</p>
5111	<p>Compatible with APX radios, this APX remote speaker microphone is the XE500 black housing, no channel knob, includes xtreme temperature cable.</p>
6176
6801	<p>IMPRES XVE500, BLACK RSM, WITH CHANNEL KNOB, W/ MULTI MIC NOISE SUPPRESSION, RUGGED SUBMERSIBLE (IP68)</p>		PMMN4132, PMMN-4132, PMMN-4132ABLK, APX NEXT, APX NEXT RSM, APX speaker mic
6802	<p>IMPRES XVE500, HIGH IMPACT GREEN RSM, WITH CHANNEL KNOB, W/ MULTI MIC NOISE SUPPRESSION, RUGGED SUBMERSIBLE (IP68)</p>		PMMN-4132, PMMN-4132A, PMMN 4132, PMMN 4132A, PMMN4132A green, APX NEXT RSM, APX NEXT, APX speaker mic