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, 4137, 4142, 4139, 4140, 4138, 6201
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00028

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": 7,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4135,4137,4142,4139,4140,4138,6201)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	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
4137	<p>This compact microphone has a revolutionary windporting feature that helps lessen background noise from high winds and other severe weather conditions. Audio can pass through the speaker grill even when the microphone port is blocked by water. The coiled cord allows talking and listening without removal from belt or case. Includes Push-to-talk switch, swivel clip and quick disconnect latch. </p>	CP110 Speaker Mic, CP185 Speaker Mic, CP200 Speaker Mic, CP200d Speaker Mic, CP200XLS Speaker Microphones
4138	<p>The Remote Speaker Microphone is a water-resistant compact unit that allows talking and listening without removing the radio from the belt or case. It has a coiled cord, Push-to-Talk switch. Clothing clip on microphone back clips securely onto shirt or collar. </p>	CP185 Speaker Mic, CP200 Speaker Mic, CP200XLS Speaker Microphones
4139	<p>These Remote Speaker Microphones include a six foot coiled cord assembly, swivel clip and quick disconnect latch. The windporting feature dramatically lessens background noise from high winds and other severe weather conditions. The IP57 submersible model was tested at one meter for 30 minutes. Intrinsically Safe when used with the PR400. </p><p>Alternative to the PMMN4013A.</p>	CP110 Speaker Mic, CP185 Speaker Mic, CP200 Speaker Mic, CP200d Speaker Mic, CP200XLS Speaker Microphones, CP200, CP200d, CP100, CP100d, CP185, CP200XLS, CP110, CP-200, CP-200d, CP-100, CP-100d
4140	<p>Motorola PMMN4077 – Remote Speaker Microphone - Mag One </p>	BPR20 Speaker Mic, BPR40 Speaker Microphones, PMMN-4077, PMMN-4077A, PMMN4077-A, BPR40d, BPR40d speaker mic, BPR40d mic, BPR40 mic, BPR 40, BPR 40 speaker mic, BPR 40 mic, CP100d speaker mic, CP100d RSM, CP100d mic, CP100d compact mic, CP185 speaker mic, CP185 compact mic, CP185 RSM
4142	<p>An earphone jack located on the remote speaker microphone allows the user to receive audio more discreetly when using this earpiece. This lightweight earpiece flexes to fit the ear contour for hours of comfortable wear. </p>	WADN4190A, BPR20 Speaker Mic, CP200XLS Speaker Mic, CP200d Speaker Mic, CP200 Speaker Mic, CP185 Speaker Mic, BPR40 Speaker Mic, XPR2500 Speaker Mic, XPR4350 Speaker Mic, XPR4550 Speaker Mic, XPR5350 Speaker Mic, XPR5550 Speaker Mic, XPR4380 Speaker Mic, XPR4580 Speaker Mic, XPR5380 Speaker Mic, XPR5580 Speaker Microphones
6201	<p>Replacement microphone cable for the PMMN4013 and PMMN4014 remote speaker mics </p>	PMMN4013, PMMN-4014, RLN-5925, speaker mic cord, microphone cord, speaker mic cable, replacement cable, replacement cord, speaker mic replacement cord, speaker mic replacement cable