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 (
    1587, 1589, 1577, 1591, 1590, 1579, 1578, 
    1573, 1572, 1574, 1592, 1576, 1593, 
    1571, 1575, 1588, 5250, 4752, 5919, 
    5817, 5837, 5253, 5814, 5251, 5831, 
    5751, 5740, 5839, 5813, 5825, 5838, 
    5738, 4755, 5252
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00110

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "24.08"
    },
    "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": 34,
      "rows_produced_per_join": 34,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`product_id` in (1587,1589,1577,1591,1590,1579,1578,1573,1572,1574,1592,1576,1593,1571,1575,1588,5250,4752,5919,5817,5837,5253,5814,5251,5831,5751,5740,5839,5813,5825,5838,5738,4755,5252)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "20.68",
        "eval_cost": "3.40",
        "prefix_cost": "24.08",
        "data_read_per_join": "155K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description unit_name
1571 <p>The Huawei eKitEngine S220S-24P4JX Switch is a full-featured Layer 2+ access switch tailored for enterprise networks requiring high performance and PoE support. It includes 24 × 10/100/1000BASE-T PoE+ ports, capable of powering networked devices like IP phones, wireless access points, and surveillance systems directly through Ethernet cabling. The switch also features 4 × 10GE SFP+ uplink ports for high-speed data transmission and reliable core connectivity. Designed for versatile deployment, it supports rack, desktop, and wall mounting. With a built-in AC power supply and support for PoE+ (IEEE 802.3af/at), it simplifies power and network infrastructure. Supporting up to 1000 users and delivering a switching capacity of 128 Gbps, the S220S-24P4JX is ideal for medium to large-scale networking environments.</p>
1572 <p>The Huawei eKitEngine S220-24P4X Switch is a high-performance switch designed for medium to large enterprise networks. It supports flexible mounting options, including rack, desk, and wall setups, to fit a variety of installation environments. Equipped with 24 × 10/100/1000BASE-T LAN ports and 4 × 10GE SFP+ ports, the switch ensures reliable and high-speed connectivity. Its PoE (IEEE 802.3af/at) capabilities allow it to power devices like IP phones, wireless access points, and cameras directly through Ethernet cables, simplifying deployment. With a built-in AC power supply (100–240V AC, 50/60 Hz), it delivers stable and efficient power. Supporting up to 800 users and offering a maximum device rate of 128 Gbps, this switch is ideal for high-demand networks that require both performance and flexibility.</p>
1573 <p>The Huawei eKitEngine S220-48P4S Switch is a powerful and scalable solution ideal for enterprise and campus networks. It features 48 × 10/100/1000BASE-T LAN ports for robust connectivity and 4 × GE SFP ports for flexible uplink options. With support for PoE (IEEE 802.3af/at), it can directly power PoE-enabled devices such as IP cameras, wireless access points, and VoIP phones, simplifying infrastructure and reducing deployment costs. The switch supports various installation types—rack, desk, and wall mounting—offering flexibility in different environments. Its built-in AC power supply (100–240V AC, 50/60 Hz) ensures consistent and reliable operation. Designed to handle up to 1200 users and delivering a maximum device rate of 104 Gbps, this switch provides high performance and seamless network operations for demanding environments.</p>
1574 <p>The Huawei eKitEngine S220-48P4X Switch is a high-performance Layer 2+ switch engineered for large-scale networks. It provides 48 × 10/100/1000BASE-T LAN ports for comprehensive access connectivity and 4 × 10GE SFP+ uplink ports for high-speed data transfer and backbone integration. The switch supports PoE (IEEE 802.3af/at), allowing it to power network devices such as IP phones, surveillance cameras, and wireless access points without needing separate power sources. With versatile mounting options including rack, desk, and wall mounting, it adapts easily to different deployment environments. Its built-in AC power supply (100–240V AC, 50/60 Hz) offers stable power delivery, and with a user capacity of up to 1200 and a switching capacity of 136 Gbps, this switch ensures scalability, reliability, and speed for enterprise-grade networks.</p>
1575 <p>The Huawei eKitEngine S310S-24P4JX Switch is an advanced Layer 2+ PoE+ switch tailored for smaller-scale enterprise networks. It features 24 × 10/100/1000BASE-T PoE+ ports to deliver both data and power to various network devices such as IP cameras, wireless access points, and VoIP phones, all while reducing cabling complexity. The 4 × GE SFP uplink ports provide high-performance fiber connectivity for uplinks and long-distance data transmission. Supporting PoE+ (IEEE 802.3af/at), the switch allows for seamless integration with PoE-enabled devices, eliminating the need for separate power sources. With a switching capacity of 56 Gbps, it can handle up to 500 users, offering an efficient and reliable solution for medium-sized enterprises and branch offices.</p>
1576 <p>The Huawei eKitEngine S310-24P4X Switch is a high-performance, Layer 2+ managed PoE switch designed for enterprise and campus networks. It offers 24 × 10/100/1000BASE-T PoE+ ports, enabling seamless power and data delivery to IP devices such as surveillance cameras, access points, and VoIP phones. With 4 × 10GE SFP+ uplink ports, it ensures high-speed, reliable uplink connectivity to core networks. Compliant with IEEE 802.3af/at standards, it supports PoE+ for simplified cabling and infrastructure. The switch comes with flexible mounting options including rack, wall, and desk setups. With a robust switching capacity of 128 Gbps and support for up to 1000 users, the S310-24P4X is an ideal solution for scalable, secure, and efficient enterprise networking.</p>
1577 <p>The Huawei eKitEngine S310S-26PN4JX Switch is a versatile Layer 2+ PoE+ switch designed for high-performance environments that require power and data delivery to network devices such as IP phones, access points, and surveillance cameras. It features 24 × 10/100/1000BASE-T PoE+ ports and 4 × GE SFP uplink ports for flexibility in connectivity. Additionally, with 2 × 10GE SFP+ uplink ports, the switch can handle high-bandwidth demands for large-scale deployments. Supporting PoE+ (IEEE 802.3af/at), it simplifies infrastructure by supplying power to connected devices without the need for additional power sources. With a switching capacity of 160 Gbps, it supports up to 500 users, making it a reliable choice for demanding enterprise networks and branch offices.</p>
1578 <p>The Huawei eKitEngine S310-48P4S Switch is a full-featured Layer 2+ PoE switch designed for large enterprise networks and IP-based deployments. It is equipped with 48 × 10/100/1000BASE-T PoE+ ports to provide both power and data transmission to a wide range of network devices such as IP phones, wireless access points, and surveillance cameras. In addition, 4 × GE SFP uplink ports offer flexible fiber connectivity for upstream links. Supporting PoE+ (IEEE 802.3af/at), the switch simplifies infrastructure by eliminating the need for separate power sources. With a strong switching capacity of 104 Gbps and scalable support for up to 1000 users, it is a reliable choice for high-density access environments.</p>
1579 <p>The Huawei eKitEngine S310-48P4X Switch is a powerful Layer 2+ PoE+ switch ideal for high-demand enterprise network environments. It comes with 48 × 10/100/1000BASE-T PoE+ ports, providing both data and power to devices like IP phones, access points, and surveillance cameras, streamlining your network setup. The 4 × 10GE SFP+ uplink ports offer high-speed fiber connectivity for the backbone network, ensuring superior performance and reliability. Supporting PoE+ (IEEE 802.3af/at) and a built-in AC power supply (100–240V AC, 50/60 Hz), it eliminates the need for additional power sources. With a switching capacity of 160 Gbps, it can accommodate up to 1000 users, making it an excellent solution for large-scale deployments in enterprise settings.</p>
1587 <p>The Huawei eKitEngine S620-24T16X8Y2CZ is a high-performance Layer 3 switch designed for small to medium-sized enterprises requiring robust and scalable network solutions. It offers a versatile mix of 1GE, 10GE, 25GE, and 100GE ports, accommodating various network demands. With advanced features like intelligent stacking (iStack), comprehensive security protocols, and flexible management options—including cloud-based and on-premises interfaces—it ensures reliable and efficient network operations. Its modular design supports expansion and redundancy, making it a future-proof choice for growing network infrastructures.</p>
1588 <p>The Huawei eKitEngine S530-48S4XE is a high-performance Layer 3 managed switch designed for enterprise networks requiring robust and scalable solutions. With 48 Gigabit SFP ports and 4 10-Gigabit SFP+ uplink ports, it offers substantial bandwidth for data-intensive applications. The switch supports advanced features such as VLAN segmentation, comprehensive security protocols, and flexible management options, including cloud-based management via the Huawei eKit app. Its modular power supply design and intelligent cooling system ensure reliability and energy efficiency, making it an ideal choice for modern network infrastructures.</p>
1589 <p>The Huawei eKitEngine S530-24ST4XE is a high-performance, fully managed Layer 3 switch designed for enterprise and campus networks. It features 24 GE SFP ports (including 8 dual-purpose ports), 4 10GE SFP+ uplink ports, and 2 10GE stack ports, providing flexible networking options. With advanced routing capabilities, robust security features, and support for intelligent stacking, this switch ensures reliable and scalable network performance. Its dual power supply design and comprehensive management interfaces make it a versatile solution for various networking environments.</p> <p></p>
1590 <p>The Huawei eKitEngine S530-24T4XE is a high-performance, fully managed Layer 3 switch designed for enterprise and campus networks. It features 24 GE RJ45 ports, 4 10GE SFP+ uplink ports, and 2 10GE stack ports, providing flexible networking options. With advanced routing capabilities, robust security features, and support for intelligent stacking, this switch ensures reliable and scalable network performance. Its dual power supply design and comprehensive management interfaces make it a versatile solution for various networking environments.</p>
1591 <p>The Huawei eKitEngine S310-24ST4X is a high-performance, fully managed Layer 2+ switch designed for enterprise and campus networks. It features 24 GE SFP ports (including 8 dual-purpose ports), 4 10GE SFP+ uplink ports, providing flexible networking options. With advanced routing capabilities, robust security features, and support for intelligent stacking, this switch ensures reliable and scalable network performance. Its built-in AC power module and comprehensive management interfaces make it a versatile solution for various networking environments.</p>
1592 <p>The Huawei eKitEngine S310-24PN4X is a high-performance, fully managed Layer 2+ switch designed for enterprise and campus networks. It features 24 × 10/100/1000/2500 Mbps RJ45 ports with PoE+ support, 4 × 10GE SFP+ uplink ports, providing flexible networking options. With advanced routing capabilities, robust security features, and support for intelligent stacking, this switch ensures reliable and scalable network performance. Its built-in AC power module and comprehensive management interfaces make it a versatile solution for various networking environments.</p>
1593 <p>The Huawei eKitEngine S310-48P4X is a high-performance, fully managed Layer 2+ switch designed for enterprise and campus networks. It features 48 × 10/100/1000BASE-T ports with PoE+ support, 4 × 10GE SFP+ uplink ports, providing flexible networking options. With advanced routing capabilities, robust security features, and support for intelligent stacking, this switch ensures reliable and scalable network performance. Its built-in AC power module and comprehensive management interfaces make it a versatile solution for various networking environments.</p>
4752 <p><strong>Ubiquiti EdgeSwitch 24-Port (250 W)</strong>: A rackmountable, managed Layer 2/3 Gigabit PoE switch offering 24 RJ-45 ports, 2 SFP uplinks, and a built-in 250 W power supply capable of delivering up to 26 Gbps non-blocking throughput.</p>
4755 <p>The Ubiquiti EdgeSwitch 48-Port 500W is a <strong>managed Gigabit switch</strong> built for enterprise-grade networks. It features 48 high-speed Ethernet ports with robust switching capacity to handle heavy traffic demands. With a 500W total PoE+ power budget, it can power a wide range of PoE-enabled devices such as access points, IP cameras, and VoIP phones. The switch supports advanced Layer 2 management features and Layer 3 routing for enhanced control and flexibility. Designed for reliability and scalability, it is ideal for professional installations requiring high capacity and centralized power distribution.</p>
5250 <p>The Ubiquiti UniFi Switch Pro 24 PoE (USW-PRO-24-POE-EU) is a high-performance <strong>managed switch</strong> designed for enterprise networks. It features 24 Gigabit Ethernet ports with both 802.3af/at PoE+ and 802.3bt PoE++ support, delivering flexible power for a wide range of devices. Equipped with two 10G SFP+ uplink ports, it ensures high-speed connectivity for demanding applications. The switch offers advanced Layer 2 and Layer 3 features, making it suitable for complex and scalable deployments. Managed through the UniFi Controller, it provides centralized monitoring, configuration, and seamless integration with other UniFi devices.</p>
5251 <p>The Ubiquiti UniFi Switch Pro 48 PoE (USW-PRO-48-POE-EU) is an advanced <strong>managed switch</strong> designed for large-scale enterprise networks. It offers 48 Gigabit Ethernet ports with full 802.3af/at PoE+ and select 802.3bt PoE++ support, enabling reliable power delivery to access points, cameras, and VoIP phones. With four 10G SFP+ uplink ports, it ensures high-speed fiber connectivity and seamless network expansion. The switch supports advanced Layer 2 and Layer 3 features for optimal performance, scalability, and control. Managed through the UniFi Controller, it integrates effortlessly with UniFi systems for centralized configuration and monitoring.</p>
5252 <p>The Ubiquiti UniFi Switch Pro 8 PoE (USW-PRO-8-POE-EU) is a compact yet powerful <strong>managed switch</strong> built for enterprise and professional networks. It features 8 Gigabit Ethernet ports with 802.3af/at PoE+ support, making it ideal for powering access points, IP cameras, and VoIP phones. Equipped with two 10G SFP+ uplink ports, it provides high-speed connectivity and flexible expansion options. The switch delivers advanced Layer 2 and Layer 3 features for robust network management and scalability. Fully managed through the UniFi Controller, it ensures seamless integration and centralized monitoring within UniFi deployments.</p>
5253 <p>The Ubiquiti UniFi Switch Ultra 210W (USW-Ultra-210W) is a sleek and efficient <strong>managed PoE switch</strong> designed for modern networks. It features 8 Gigabit Ethernet ports with 802.3at PoE+ support, delivering a total PoE power budget of 210W to power access points, IP cameras, and VoIP phones. Compact yet powerful, it is ideal for small to medium-sized deployments where space and performance both matter. Managed via the UniFi Network Controller or mobile app, it offers centralized configuration and monitoring. A reliable choice for businesses and advanced home networks needing smart PoE switching in a compact form.</p>
5738 <p>The MikroTik CRS317-1G-16S+RM is a high performance, layer 2 managed network switch designed for demanding professional and data center environments. Its key feature is a robust port configuration of sixteen SFP+ cages, supporting 10 Gigabit Ethernet connections, and one Gigabit Ethernet RJ45 port for management. Housed in a durable 1U rack mountable metal case, it is built for reliability and efficient cooling. Running MikroTik's powerful SwOS software, it offers advanced features like VLANs, link aggregation, port monitoring, and comprehensive traffic management controls. The CRS317 is an ideal, cost effective solution for creating high speed, low latency backbone networks for storage, virtualization, or connecting multiple access points and servers.</p>
5740 <p>The MikroTik CRS328-24P-4S+RM is a powerful, layer 3 capable managed switch designed as an all in one networking solution for small to medium sized businesses. Its standout feature is the integration of 24 Gigabit Ethernet ports with full Power over Ethernet (PoE+) support, capable of delivering power to devices like access points, IP cameras, and VoIP phones, alongside four SFP+ cages for 10 Gigabit fiber or copper uplinks. This combination allows it to act as a central, powered core for a network while providing high speed backbone connectivity. Housed in a 1U rack-mountable format, it runs MikroTik's versatile RouterOS, offering advanced routing, switching, security, and management features, making it exceptionally versatile for building robust, scalable network infrastructure.</p>
5751 <p>The MikroTik CRS328-4C-20S-4S+RM is a high density, layer 3 managed switch engineered for professional core and aggregation networking roles. It features a versatile port configuration aimed at flexibility and high speed connectivity, including four combo Gigabit Ethernet ports (RJ45/SFP), twenty SFP ports for 1 Gigabit fiber connections, and four SFP+ ports for 10 Gigabit uplinks. This design makes it ideal for environments requiring a large number of fiber connections, such as connecting multiple switches, access points, or servers across a building. Housed in a 1U rack mountable chassis and powered by the full featured RouterOS, it provides advanced switching, routing, and management capabilities, offering a cost effective solution for building scalable and reliable high speed network backbones.</p>
5813 <p>The MikroTik CRS326-24G-2S+RM is a versatile and cost effective layer 2 managed gigabit switch, ideal for small to medium sized business networks. It offers 24 Gigabit Ethernet ports for connecting computers, printers, and other devices, plus two SFP slots for adding fiber optic uplinks to connect to other switches or a core network over longer distances. Housed in a sturdy 1U rack mountable metal case, it runs MikroTik's SwOS, providing essential managed features like VLANs for network segmentation, port mirroring for traffic analysis, and STP for loop prevention. Its reliable performance and excellent value make it a fundamental building block for creating efficient and organized wired networks.</p>
5814 <p>The MikroTik CCR2004-16G-2S+ is a high performance cloud core router designed for demanding enterprise and internet service provider environments. Its power comes from a Tilera TILE-Gx ARM-based multicore processor, which is specifically engineered for efficient packet processing, enabling it to handle heavy routing workloads at wire speed. The router features 16 Gigabit Ethernet ports and two SFP+ cages for 10 Gigabit fiber uplinks, providing substantial connectivity in a compact 1U rack-mountable form factor. Running the full version of MikroTik's RouterOS, it offers advanced routing capabilities, firewall filtering, traffic shaping, and VPN services, making it an ideal solution for acting as a high throughput network gateway, core router, or VPN concentrator where processing power is critical.</p>
5817 <p>The MikroTik CCR2116-12G-4S+ is a top tier manageable switch as well as a router, built for the most demanding network environments, such as internet exchange points, data centers, and high capacity service provider backbones. Its exceptional performance is driven by a powerful 16-core Tilera processor, engineered to handle massive packet forwarding rates exceeding 100 Gbps. The chassis offers flexible connectivity with 12 Gigabit Ethernet ports and four SFP28 cages that support high-speed links of 1G, 10G, or 25G, allowing for massive uplink capacity. Running the full-featured RouterOS, it provides advanced BGP routing, stateful firewall, complex traffic engineering, and robust VPN capabilities, establishing it as a formidable and cost-effective solution for the core of high-speed networks.</p>
5825 <p>The MikroTik CRS112-8G-4S-IN is a compact, layer 2 managed switch designed for versatile deployment in small offices or as part of a larger network infrastructure. It features eight Gigabit Ethernet ports for standard device connections and four SFP slots for fiber optic uplinks, allowing for reliable long-distance connections to other network segments. Its key differentiator is that it is an indoor model with a passive cooling design, meaning it operates silently, making it suitable for noise-sensitive environments like offices or classrooms. Running MikroTik's SwOS, it offers essential managed features like VLANs, QoS, and port monitoring, providing a cost-effective and flexible solution for building a robust and scalable wired network.</p>
5831 <p>The MikroTik CRS112-8P-4S-IN is a compact, layer 2 managed switch designed for small to medium sized deployments where Power over Ethernet (PoE) is a key requirement. It features eight Gigabit Ethernet ports with PoE output on all ports, allowing it to directly power devices like wireless access points, IP cameras, and VoIP phones. Additionally, it includes four SFP slots for fiber optic uplinks, enabling reliable long-distance connections back to a core network. As an indoor model with passive cooling, it operates silently, making it ideal for offices or other noise-sensitive environments. Running MikroTik's SwOS, it provides essential management features like VLANs and QoS, creating an all-in-one solution for powering and connecting edge devices efficiently.</p>
5837 <p>The MikroTik CRS309-1G-8S+IN is a compact, high density manageable fiber switch designed for creating fast, reliable network backbones. Its key feature is a configuration of eight SFP+ cages, which support 1G, 10G, or even 25G connections, making it an ideal choice for aggregating multiple high speed links in a data center, office, or as a home lab core switch. It includes one Gigabit Ethernet port for management or a low-speed device connection. Housed in a silent, passively cooled metal case suitable for indoor use, it runs MikroTik's SwOS software, offering essential layer 2 features like VLANs and link aggregation. The CRS309 is renowned for offering exceptional 10G port density in a small, affordable, and power efficient package.</p>
5838 <p>The MikroTik CRS318-16P-2S+OUT is a robust, layer 2 managed switch specifically designed for outdoor or environmentally challenging installations. It features 16 Gigabit Ethernet ports with PoE+ output to power devices like outdoor wireless access points and IP cameras, plus two SFP+ cages for high speed 10 Gigabit fiber uplinks. Built with a hardened, weather resistant case and capable of operating in a wide range of temperatures, it is engineered for reliability in industrial settings or outdoor deployments where a standard indoor switch would not suffice. This model provides the same powerful switching and management capabilities as its indoor counterpart but is built to withstand the elements, making it a critical component for outdoor network infrastructure.</p>
5839 <p>The MikroTik CRS354-48P-4S+2Q+RM is a high density, layer 3 capable manageable switch designed as a powerful all in one solution for the core of medium to large networks. Its standout feature is the massive PoE+ capability, with 48 Gigabit Ethernet ports that can deliver power to a small army of devices like access points, cameras, and phones, supported by a substantial total power budget. For high speed connectivity, it is equipped with four SFP+ 10G ports and two QSFP+ 40G ports, which can be used for high-bandwidth uplinks, aggregation, or backbone connections. Housed in a 1U rack-mountable chassis with active cooling, it runs the full featured RouterOS, offering advanced routing, switching, and management features. This switch consolidates power, port density, and high-speed throughput into a single unit, making it ideal for campuses, large offices, or as a central distribution point in a robust network infrastructure.</p>
5919 <p>The MikroTik CRS106-1C-5S is a compact and basic five-port managed switch, ideal for simple networking needs or as an entry-level device for learning RouterOS. Its port configuration consists of one combo port (RJ45 and SFP) and four additional 100 Mbps Ethernet ports, making it suitable for connecting older or lower-bandwidth devices. Housed in a small, passively cooled metal case, it operates silently and is powered by an external adapter. Running the full MikroTik RouterOS (not the simplified SwOS), it provides extensive configuration options for routing, bridging, VLANs, and firewall rules, offering a high degree of flexibility for its size and port speed. While its 100 Mbps ports limit its use in modern gigabit networks, it remains a useful tool for specific low-bandwidth applications or educational purposes.</p>