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 (
    489, 3654, 3655, 3664, 3657, 467, 3663, 
    491, 490, 459, 506, 468, 488, 6024, 505, 
    504, 492, 4978, 3739, 4979, 4981, 5916, 
    5921, 5917
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (489,3654,3655,3664,3657,467,3663,491,490,459,506,468,488,6024,505,504,492,4978,3739,4979,4981,5916,5921,5917)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
459	<p> 138 - 174 MHz Mosaic 3 dB gain antenna with spring.  The 49" whip antenna is a vibration resistant collinear antenna with a black UV stabilized base that will resist chalking and provide long lasting operation.  The unique DURA-FLEX elastomer spring eliminates duplex system noise that is found with traditional metal coil springs.  Order NMO mounting kit separately.</p>
467	<p> <span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;"><span style="background-color:#ffffff;">PCTEL (Maxrad) 760-870 MHz 3dB MAX base collinear open coil roof mount antenna in black.</span></span></p>	BMAX7603, BMAX-7603S, BMAX-7603
468	<p> <span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;"><span style="background-color:#ffffff;">PCTEL (Maxrad) 760-870 MHz 3dB MAX base collinear closed coil roof mount antenna in black.</span></span></p>
488	<p> <span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;"><span style="background-color:#ffffff;">The PCTEL MHB5800 5/8 wave antenna operates within the VHF frequency range, 144-174 MHz. This VHF mobile antenna is field-tunable and features a 3 dB gain with or without a ground plane. Maximum power input is 200 watts. </span></span><br style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px; background-color: rgb(245, 245, 245);" /> <br style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px; background-color: rgb(245, 245, 245);" /> <span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;"><span style="background-color:#ffffff;">The 58 inch whip antenna utilizes a chrome coil design with the enhancements of a heavy-duty tapered rod for maximum durability in harsh environments. The two-way antenna is able to maintain desired resonant frequency through heavy shock vibrations. </span></span><br style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px; background-color: rgb(245, 245, 245);" /> <br style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px; background-color: rgb(245, 245, 245);" /> <span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;"><span style="background-color:#ffffff;">The PCTEL heavy-duty whip-style antenna is designed for mobile two-way communication within the 144-174 MHz VHF frequency band.</span></span></p>
489	<p>144-174 MHz, 3DB, chrome 5/8 wave antenna with spring. </p>	MHB-5800, MHB-5800S, B1443S, B-1443S, B1443-S
490	<p> <span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;"><span style="background-color:#ffffff;">PCTEL (Maxrad) 144-174 MHz 1/2 wave, no ground plane antenna. 200 watts. 2.4dB gain.</span></span> </p>
491	<p> <span style="color: rgb(51, 51, 51); font-family: "Century Gothic", "Trebuchet MS", Verdana, Geneva, Arial, Helvetica; font-size: 13.3333px; background-color: rgb(255, 255, 255);">Features</span> </p><li style="font-family: "Century Gothic", "Trebuchet MS", Verdana, Geneva, Arial, Helvetica; color: rgb(51, 51, 51); font-size: 13.3333px; background-color: rgb(255, 255, 255);"> No ground plane required</li><ul> <li style="font-family: "Century Gothic", "Trebuchet MS", Verdana, Geneva, Arial, Helvetica; color: rgb(51, 51, 51); font-size: 13.3333px; background-color: rgb(255, 255, 255);"> Rugged construction; optional heavy-duty shock spring</li> <li style="font-family: "Century Gothic", "Trebuchet MS", Verdana, Geneva, Arial, Helvetica; color: rgb(51, 51, 51); font-size: 13.3333px; background-color: rgb(255, 255, 255);"> Sleek, sturdy, sealed phasing coil design</li> <li style="font-family: "Century Gothic", "Trebuchet MS", Verdana, Geneva, Arial, Helvetica; color: rgb(51, 51, 51); font-size: 13.3333px; background-color: rgb(255, 255, 255);"> Mates with all 1-1/8"-18 thread mounts, including 3/4" mounts</li> </ul>
492	<p>PCTEL - 144-174 MHz, 3db gain, DC ground chrome antenna (cable not included).</p>	MHBDC-5800, MHB-5800, MHB-DC5800
504	<p> <span style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 15px;"><span style="background-color:#ffffff;">PCTEL (Maxrad) 450-470 MHz 200 watt, 5dB gain gain collinear antenna</span></span> </p>
505	<p> 450 - 470 MHz 3 dB gain no ground plane antenna. Suitable for fiberglass surfaces. 200W max. Order NMO mounting kit separately. </p>
506	<p>PCTEL - 450-470 MHz, 5db gain, chrome antenna with spring (cable not included).</p>
3654	<p> Laird Technologies (now TE Connectivity) B1443 antenna features a 5/8 wave whip operating in the 144-174 MHz range. 3 dB gain stainless finish.</p>
3655	<p> Laird Technologies B1442N antenna is a 1/2 wave stainless 2.4 dB gain whip operating in the 144-174 MHz range.  No ground plane required.  </p>
3657	<p> Laird Technologies B8065C closed collinear antenna with a tuneable center load. 5 dB gain stainless.</p>
3663	<p> Laird Technologies B4505CS is a 5 dB gain chrome antenna with spring operating in the 450-470 MHz range.</p>
3664	<p> Laird Technologies B4505C chrome finish antenna features 5 dB gain and operates in the 450-470 MHz range. </p>
3739	<p> Laird Technologies - 5/8 wave 806-896 MHz flexible antenna with a black finish.  Antenna rated for 3dB gain with a coiled center.</p>
4978	<p>PCTEL 450-470 MHz 3db gain chrome antenna (cable not included).</p>
4979	<p>PCTEL 450-470 MHz, 3db gain chrome antenna with spring included. Cable not included. </p>
4981	<p>PCTEL - Wideband UHF 440-480 MHz chrome coil with spring (cable not included).</p>
5916	<p>Laird Technologies (now TE Connectivity) VHF 144-174 MHz, 3db gain chrome antenna with spring. Image shown does not include spring, but the B1443S comes with a spring.</p>	B1443S, B-1443, B-1443S
5917	<p>Laird Technologies - UHF 450-470 MHz, 1/2 wave chrome antenna. No ground plane required. </p>	B-4502N, B4502-N, B4502, B4502NGP
5921	<p>Laird Technologies - 6 pack of rubber O-rings for brass nut.</p>	BCORING, BC-ORING, ORING, O-RING
6024	<p>Radiall/Larsen NMO3E800B base loaded mobile antenna with 3.2 db gain, closed coil, black stainless. 13.5" whip length. </p><p>25 in stock </p>