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 (
    2781, 2786, 2782, 2785, 2787, 2780, 2784, 
    2783, 7893
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00029

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": 9,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (2781,2786,2782,2785,2787,2780,2784,2783,7893) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
2780		<div> Made by Polyphaser:</div> <div>  </div> <div> Patented coil inductor, dc block, lightning protection, engineered for high</div> <div> power of combined signals operating from 700 MHz to 2.7 GHz band pass</div> <div> configured with N female connectors.</div> <div>  </div> <div> Features</div> <div> • High surge current capability</div> <div> • Low let-through voltage and throughput energy</div> <div> • DC shorted filter design, no dc continuity between center pins</div> <div> • Ideal use for applications where dc is not required on the coaxial cable</div> <div> • Fully weatherized housing</div> <div> • Elongated female connector allows for mounting through</div> <div> a 1/4” bulkhead or grounding bar</div> <div> • Multi-strike capability</div> <div> Standards and Certificates</div> <div> • IEC 60529 IP65</div> <div> • Bellcore # TA-NWT-00487</div> <div> • Procedure 4.11, wind driven</div> <div> • UL 497B</div> <div> • RoHS compliant</div>
2781		<p> Made by Polyphaser: Same as Polyphaser model IS-50NX-C2-MA. </p><div> DC blocked 50 ohm bulkhead mounted surge protector is ideal for two way radio and </div><div> SCADA applications. </div><div> </div><div> Features </div><div> • Ideal for HF, UHF, VHF radios </div><div> • DC blocked gas tube design </div><div> • No DC continuity between center pins </div><div> • Multi-strike capability </div><div> * 50,000A surge rating </div><div> * N type Female on equipment port - N type Male on antenna port </div><div> </div><div> Standards and Certificates </div><div> • RoHS compliant </div>
2782		<div> Made by Polyphaser:</div><div> </div><div> Gas tube lightning protection with excellent VSWR and superior RF </div><div> performance characteristics for equipment operating between DC and 7 GHz </div><div> with up to 90 W RF power configured with N female connectors - bidirectional.</div><div> </div><div> Features</div><div> • High surge current capability</div><div> • High power configurations available (plus over minus symbol here) 60 VDC </div><div> pass configurations available (DT models)</div><div> • Weatherized</div><div> Standards and Certificates</div><div> • IEC 61000-4-5</div>
2783		<div> Made by Polyphaser:</div><div> </div><div> Patented SX radio frequency DC blocked filter protectors are ideal for RF </div><div> coaxial applications where DC is not required.</div><div> </div><div> Features</div><div> • High surge current capability</div><div> • Low let-through voltage and throughput energy</div><div> • DC shorted filter design, no DC continuity between center pins</div><div> • Ideal use for applicaitons where dc is not required on the coaxial cable</div><div> • Fully weatherized housing</div><div> • Elongated female connector allows for mounting through a 1/4” bulkhead </div><div> or grounding bar</div><div> • Multi-strike capability</div><div> Standards and Certificates</div><div> • IEC 60529 IP65</div><div> • Bellcore # TA-NWT-00487</div><div> • Procedure 4.11, wind driven</div><div> • UL 497B</div><div> • RoHS compliant</div>
2784		<div> Made by Polyphaser:</div><div> </div><div> DC block, lightning protection, engineered for high power of combined signal </div><div> operating up to 750 W between 300 MHz and 700 MHz band pass configured </div><div> with N female connectors.</div><div> </div><div> Features</div><div> • High surge current capability with filter design</div><div> • Low let-through voltage and throughput energy</div><div> • No dc continuity between center pins</div><div> • Weatherized housing</div><div> • High powered public safety, TETRA and</div><div> • UHF/VHF radio application</div><div> • Standard N, 7/16 DIN Connectors</div><div> Standards and Certificates</div><div> • IEC 61000-4-5</div>
2785		<div> Made by Polyphaser:</div><div> </div><div> DC block, lightning protection, engineered for high power of combined signal </div><div> operating up to 750 W between 100 MHz to 512 MHz band pass configured with </div><div> N female connectors.</div><div> </div><div> Features</div><div> • High surge current capability with filter design</div><div> • Low let-through voltage and throughput energy</div><div> • No dc continuity between center pin</div><div> • Weatherized housing</div><div> • High powered public safety, TETRA and UHF/VHF radio application </div><div> • Standard N, 7/16 DIN Connectors</div><div> Standards and Certificates</div><div> • IEC 61000-4-5</div>
2786		<div> Made by Polyphaser:</div><div> </div><div> Hybrid, multistage, multi-strike, fast response, high current capacity, ±6 Vdc </div><div> pass coaxial lightning protector configured with N female connectors for RF </div><div> operating between 800 MHz to 2.5 GHz.</div><div> </div><div> Features</div><div> • Patented dual path RF and DC protection</div><div> • Multi-strike capacity</div><div> • Weatherized housing</div><div> • Low throughput energy</div><div> • Wide bandwith</div><div> Standards and Certificates</div><div> • IEC 60529IP67</div><div> • Bellcore #TA-NWT-00487</div><div> • UL 497B</div><div> • RoHS compliant</div>
2787		<div> Made by Polyphaser:</div><div> </div><div> Gas tube lightning protection with excellent VSWR and superior RF </div><div> performance characteristics for equipment operating between DC and 7 GHz </div><div> with up to 90 W RF power configured with N female connectors - bidirectional.</div><div> </div><div> Features</div><div> • High surge current capability</div><div> • High power configurations available (plus over minus symbol here) 60 VDC </div><div> pass configurations available (DT models)</div><div> • Weatherized</div><div> Standards and Certificates</div><div> • IEC 61000-4-5</div>
7893		<p>Tripp Lite Isobar 2 Outlet Surge Protector - direct plug-in with 2 AC power outlets (WHITE)</p>