SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    551, 549, 532, 531, 535, 537, 543, 553, 
    540, 547, 538
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.96"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 11,
      "rows_produced_per_join": 11,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "3.86",
        "eval_cost": "1.10",
        "prefix_cost": "4.96",
        "data_read_per_join": "50K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ],
      "attached_condition": "((`aomnia_com`.`cscart_product_descriptions`.`product_id` in (551,549,532,531,535,537,543,553,540,547,538)) and (`aomnia_com`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description unit_name
531 <ul class="a-unordered-list a-vertical a-spacing-mini"> <li><span class="a-list-item">Convenient front-mount USB 3.0 ports (2), with 20-pin header connector</span></li> <li><span class="a-list-item">Provides 2 SuperSpeed USB 3.0 ports by connecting directly to motherboard; uses legacy 3.5" floppy drive bay</span></li> <li><span class="a-list-item">Supports data transfer rates up to 5 Gbps; backwards compatible with earlier USB versions</span></li> <li><span class="a-list-item">Sturdy, fully enclosed metal housing gives maximum durability and ensures long-term use</span></li> <li><span class="a-list-item">Plug and play; hot-swappable Windows and Mac compatible; no drivers required</span></li> </ul>
532 <h2>PCI Express balances cost, performance, compatibility and advanced features for computing platforms</h2> <p>The Manhattan Serial PCI Express Card quickly and easily adds two DB9 ports to PCI Express-enabled desktop systems to connect and communicate with serial peripheral devices.</p> <h3>Fast Data Transfer</h3> <p>The Manhattan Serial PCI Express Card can be configured to achieve baud rates of up to 230,400 bps to take advantage of PCI Express data transfer speeds of up to 2.5 Gbps. Compliance with PCI Express 1.1 specifications ensures that most PCI Express Card-equipped desktop computers and devices can operate at peak performance.</p> <h3>Simple Installation</h3> <p>The Manhattan Serial PCI Express Card fits PCI Express x1, x4, x8 and x16 lane buses, and configurable COM port settings provide a flexible way to customize its use to various needs.</p> <p> </p> <ul> <li>Easily adds two configurable serial ports to a desktop computer</li> <li>Fits PCI Express x1, x4, x8 and x16 lane buses</li> <li>Fits standard and low-profile PCI slots</li> <li>Plug-and-play installation; hot-swappable; Windows compatible</li> </ul>
535 <p>Manhattan SVGA Cables easily connect a monitor with a desktop or notebook computer. Ideal for use with video splitters, KVM switches and any HD15-equipped display, computer or device, Manhattan SVGA Cables are engineered and constructed of quality materials to deliver dependable transmissions in video applications. Full foil and braided shielding help minimize EMI interference and mini-coax (RGB) with paired video wire construction combine to provide maximum conductivity and clear, crisp images with reduced distortion over extended distances. </p> <ul> <li>HD15 male to HD15 male</li> <li>Connects SVGA source to SVGA display</li> <li>Fully shielded to reduce EMI interference for improved video transmission</li> <li>Molded PVC boot with strain relief</li> </ul>
537
538 <span>Kit Contents:</span><br /><span>1x VGA/DVI/S-Video Dual Bracket</span><br /><span>1x VGA Port Cable</span><br /><span>1x DVI/S-Video Single Bracket</span><br /><span>1x VGA/S-Video Single Bracket</span>
540 <span>Easily distribute a single VGA signal to multiple displays.The Manhattan Professional Video Splitter with built-in booster streams a single VGA signal from a personal computer or other VGA-equipped source to up to four displays. Ideal for trade shows, classrooms, video conferencing and presentations and retail applications, the Manhattan Professional Video Splitter is a good choice for splitting and distributing a signal to multiple displays when source equipment is remotely stored in a secured room or cabinet. Cascade multiple units up to three levels to output VGA signals to additional displays in widely distributed applications. The gold-plated contacts and fully shielded metal case ensure reliable signal transmission with less degradation.</span>  <ul> <li>Duplicates a single VGA signal for up to four VGA outputs</li> <li>Supports VGA bandwidths up to 350 MHz and resolutions up to 1920 x 1680 with effective transmission distance up to 65 m (210 ft.)</li> <li>Delivers a clear, sharp signal from a PC to VGA, SVGA and MultiSync displays, projectors and more</li> <li>Cascade up to three levels to expand signal distribution to more displays</li> <li>Automatic power save helps conserve power until VGA signal is restored</li> <li>Easy to install: requires no configuration</li> </ul> <p> </p> <ul> <ul>Standards and Certifications</ul> </ul> <br /> <ul> <li>FCC</li> <li>CE</li> <li>ISO 9002<br /><br />General</li> <li>LED indicator: Power (green)</li> <li>Cable length, maximum: 65 m (210 ft.)</li> <li>Connector input: HD15 male; output: HD15 female (4)</li> <li>Power adapter: 9 VAC, 300 mA<br /><br />Signal</li> <li>Signal bandwidth: 350 MHz</li> <li>Signal type: VGA, SVGA, multi-sync</li> <li>Input voltage, minimum: 0.5 V p-p</li> <li>Input voltage, maximum: 1.0 V p-p</li> <li>I/O impedance: 75 Ω</li> <li>Computer-to-video splitter range: 7.5 m (25 ft.)</li> <li>Video splitter-to-monitor range: 65 m (210 ft.)<br /><br />Resolution</li> <li>Resolution: 1920 x 1680</li> <li>Horizontal frequency: 30 – 120 kHz</li> <li>Vertical frequency: 40 – 120 Hz<br /><br />Ports</li> <li>HD15 male</li> <li>HD15 female (4)</li> <li>Power port: 9 V, 1000 mA<br /><br />Physical</li> <li>Enclosure: metal</li> <li>Dimensions: 133 x 94 x 42 mm (5.2 x 3.7 x 1.65 in.)</li> <li>Weight: 396 g (14 oz.)<br /><br />Package Contents</li> <li>Professional Video Splitter</li> <li>Instructions</li> </ul>
543 <div class="main-content"> <div class="container"> <section class="content"> <article class="editor clearfix"> <ul> <li><span>Provide your computer with two additional USB Type C ports</span></li> <li> <span>Two times faster than USB 3.0, USB3.0 Super Speed up to 10 Gbps</span></li> <li><span><strong> </strong>PCIe USB 3.1 Card Type C 2 ports</span></li> <li><span> up to 10GB/s High speed 480 Mbps</span></li> <li><span> Provides your computer with two additional USB Type C ports</span></li> </ul> <br /><span><strong>Specification</strong></span> <ul> <li><span>Supports data transfer rates of 10 Gbps, 5 Gbps, 480 Mbps, 12 Mbps, and 1.5 Mbps</span></li> <li><span>5 V/900 mA at each port</span></li> <li><span>SATA 15 connector for additional power supply from the mainboard</span></li> <li><span>For PCIe interfaces with dual link only</span></li> <li><span>Overvoltage protection</span></li> <li><span>Windows Vista/7/8/8.1/10</span></li> </ul> <br /><span><strong>Package content</strong></span> <ul> <li><span>1 * PCIe USB 3.1 Card Type C</span></li> <li><span>1 * Driver CD</span></li> <li><span>1 *manual</span></li> </ul> </article> </section> </div> </div> <footer class="site-footer"> <div class="footer-top"> <div class="container"> <div class="col col1"> </div> </div> </div> </footer>
547 <ul> <li><strong>Type:</strong><span> </span>High-speed charging and data transfer cable</li> <li><strong>Connector type:</strong><span> </span>Type-C male to micro-USB 2.0 A male</li> <li><strong>Transfer speeds:</strong><span> </span>Supports speeds of up to 480Mbps</li> <li><strong>Wire gauge:</strong><span> </span>32 AWG</li> <li><strong>Outer diameter:</strong><span> </span>0.118in</li> <li><strong>Conductor material:</strong><span> </span>Bare copper</li> <li><strong>Jacket :</strong><span> </span>PVC </li> <li><strong>Color:</strong><span> </span>Black</li> <li><strong>Length:</strong><span> </span>6ft</li> <li><strong>Weight:</strong><span> </span>1.305oz</li> </ul>
549 <span>Standards</span><br /> <ul> <li>IEEE 802.3af (Power over Ethernet)</li> <li>IEEE 802.3at (High-Power PoE+ Power over Ethernet)</li> <li>IEEE 802.3 (10Base-T Ethernet)</li> <li>IEEE 802.3ab (Gigabit Ethernet)</li> <li>IEEE 802.3u (100Base-TX Fast Ethernet)<br /><br />General</li> <li>Media support:<br />- 100Base-TX Cat5 UTP/STP RJ45, 8 pin<br />- 1000Base-T Cat5e UTP/STP RJ45, 8 pin</li> <li>Ports:<br />- 1 RJ45 1000 Mbps input port<br />- 1 RJ45 1000 Mbps data and power output port<br />- 1 power input connector for external power adapter</li> <li>Protection functions:<br />- Short circuit protection for short GND<br />- Overload protection for currents over 1.8 A<br />- High-voltage protection for output voltage exceeding 58 V</li> <li>Compatibility - general: all IEEE 802.3at- and IEEE 802.3af-compliant PoE devices</li> <li>Supported INTELLINET NETWORK SOLUTIONS products:<br />- Wireless 300N Access Points (524735, 524711, 525251)<br />- IEEE 802.3at PoE+ Splitter (560443)<br />- Network Cameras (550932 NBCC30-IR, 550963 NFC30-IR, 550949 NFC30, 550987 NFD30, 551021 NFC31, 551045 NFC31-IR, 551229 NFD130-IR, 551236 NFD130-IRV)</li> <li>Certifications: FCC Class B Part 15, CE 89/336/EEC<br /><br />RJ45 Output Connector Pinout (Data + Power)</li> <li>Pin 1: Rx+ (data receive) and feeding power [+]</li> <li>Pin 2: Rx- (data receive) and feeding power [+]</li> <li>Pin 3: Tx+ (data transmit) and feeding power [-]</li> <li>Pin 4: NC (not connected)</li> <li>Pin 5: NC (not connected)</li> <li>Pin 6: Tx- (data transmit) and feeding power [-]</li> <li>Pin 7: NC (not connected)</li> <li>Pin 8: NC (not connected)<br /><br />LED</li> <li>PoE, Power<br /><br />Power</li> <li>Input: 100 – 240 V AC, 50 – 60 Hz</li> <li>Power consumption: 42 watts (maximum)<br /><br />Environmental</li> <li>Metal housing</li> <li>Dimensions: 154 (L) x 72 (W) x 35 (H) mm (6.0 x 2.81 x 1.37 in.)</li> <li>Weight: 0.79 kg (1.73 lbs.)</li> <li>Operating temperature: 5 – 45°C (41 – 113°F)</li> <li>Operating humidity: 10 – 90% RH, non-condensing</li> <li>Storage temperature: -20 – 55°C (-4 – 131°F)<br /><br />Package Contents</li> <li>1-Port Gigabit High-Power PoE+ Injector</li> <li>Power cable</li> <li>Installation material (2 screws and drywall anchors)</li> <li>Instructions</li> </ul>
551 <h2>High-speed cables deliver high-definition performance</h2> <p><a title="HDMI Technology Explained" href="https://manhattanproducts.us/pages/hdmi-technology" target="_blank" rel="noopener">HDMI</a><span> </span>has become the standard digital connection, delivering the highest-quality audio and video signal over a single cable. Manhattan High Speed HDMI Cables are designed and carefully constructed to meet the evolving needs of the high-definition marketplace. These Manhattan High Speed HDMI Shielded Cables provide 1080p resolution. These high-quality cables provide high-definition video and multichannel, digital audio with increased performance characteristics, greater accuracy and expanded features. </p> <ul> <li>Supports 1080p resolution and Deep Color</li> <li>Compatible with any HDMI device, such as Blu-ray, game consoles, stereos and PCs</li> <li>Compliant with High Speed HDMI specifications</li> <li>Double shielded to reduce EMI and other interference sources</li> <li>Molded PVC boot</li> </ul>
553 <h1 class="a-size-base-plus a-text-bold">About this item</h1> <ul class="a-unordered-list a-vertical a-spacing-mini"> <li><span class="a-list-item">Simply connects non-PoE IEEE 802.3af/t-compliant devices to a PoE injector or PoE switch</span></li> <li><span class="a-list-item">Easy installation and requires no tools or software</span></li> <li><span class="a-list-item">Can be used to complement any PoE injector unit or midspan switch. Auto-sensing input port automatically detects optimal network speeds</span></li> <li><span class="a-list-item">Volt selector allows you to power any compatible 5 V, 7.5 V, 9 V or 12 V Ethernet-enabled device</span></li> </ul>