OfficeCo

TP-Link (20)
Satco (1)

Marketing Information

Overview

TP-Link's brand new JetStream gigabit smart switches provide huge upgrade comparing with previous versions. The switches can be managed by Omada SDN Controller, which provides professional and reliable one-step solutions. Integrated L2 and L2+ features such as 802.1Q VLAN, QoS, IGMP Snooping and static routing provide cost-effective networking solutions for small and medium-sized businesses without sacrificing enhanced usability and strong performance.

Omada Solution

Software Defined Networking (SDN) with Cloud Access

Omada Software Defined Networking (SDN) platform integrates network devices, including access points, switches and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network--all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more

Hassle-Free Centralized Cloud Management

100% centralized cloud management of the whole network from different sites--all controlled from a single interface anywhere, anytime.

Zero-Touch Provisioning for Efficient Deplyment

Omada zero-touch provisioning allows remotely deployment and configuration of multi-site networks, so there's no need to send out an engineer for on-site configuration. The Omada Cloud ensures efficient deployment with lower costs.

AI-Driven Technology for Stronger Performance and Easy Network Maintenance

Assign Different Management Roles

Multi-user privilege assignment is available to increase management efficiency and security. Multi-person management, multi-level permissions, and the ability to add admins as needed, enable flexible network operation and maintenance

Easy and Intelligent Network Monitoring

The easy-to-use dashboard makes it easy to see your real-time network status; check network usage and traffic distribution; receive network condition logs, abnormal event warnings, and notifications; or even track key data for better business results. Network topology helps IP admins quickly see and troubleshoot connection at a glance.

Comprehensive Protection for the Whole Network

Multiple Factors Guarantee Higher Reliability

Higher reliability of cloud service is guaranteed with 99.99% SLA availability, 24/7 automated fault detection, geographically isolated backup servers, and reliable product quality. Your network functions even if management traffic is interrupted.

Reliable Connections Even with High-Density Clients

Equipped with enterprise chipsets, dedicated antennas, advanced RF functions, auto channel selection, and power adjustment, Omada Wi-Fi 6 and Wi-Fi 5 APs have high concurrency capacities for remarkable performance in high-density environments.

Switch Product Features

- Gigabit Ethernet connections on all ports provide full speed of data transferring
- L2+ Feature --Static Routing, helps route internal traffic for more efficient use of network resources
- Advanced security features include IP-MAC-Port Binding, ACL, Port Security, DoS Defend, Storm Control, DHCP Snooping, 802.1X and Radius Authentication
- L2/L3/L4 QoS and IGMP Snooping optimize voice and video applications
- Comprehensive IPv6 support for management, QoS and ACL
- Web/CLI managed modes, SNMP, RMON and Dual Image bring abundant management features
(1)
Software Defined Networking (SDN) with Cloud Access

Omada Software Defined Networking (SDN) platform integrates network devices, including access points, switches and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network--all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

Hassle-Free Centralized Cloud Management

100% centralized cloud management of the whole network from different sites--all controlled from a single interface anywhere, anytime.

Zero-Touch Provisioning for Efficient Deplyment

100% centralized cloud management of the whole network from different sites--all controlled from a single interface anywhere, anytime. Omada zero-touch provisioning allows remotely deployment and configuration of multi-site networks, so there's no need to send out an engineer for on-site configuration. The Omada Cloud ensures efficient deployment with lower costs.

AI-Driven Technology for Stronger Performance and Easy Network Maintenance (1)
Software Defined Networking (SDN) with Cloud Access

Omada Software Defined Networking (SDN) platform integrates network devices, including access points, switches and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network--all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

Hassle-Free Centralized Cloud Management

100% centralized cloud management of the whole network from different sites--all controlled from a single interface anywhere, anytime.

Zero-Touch Provisioning for Efficient Deplyment

Omada zero-touch provisioning allows remotely deployment and configuration of multi-site networks, so there's no need to send out an engineer for on-site configuration. The Omada Cloud ensures efficient deployment with lower costs.

AI-Driven Technology for Stronger Performance and Easy Network Maintenance (1)
10G Uplink Managed Switch for a Complete Omada Network

10G Lightning-Fast Uplink Connection

4Ã— 10 Gbps SFP+ Slots for High-Bandwidth Connectivity

Gigabit Connections

24Ã— Gigabit Ethernet Ports Offer Reliable Connections

Centralized Cloud Management

SDN Solutions Integration for a Highly Efficient Network

Advanced L2+ Features

Static Routing, IGMP Snooping, 802.1Q VLAN and More

Enterprise Switch with 10G Uplink

4Ã— 10 Gbps SFP+ slots provide non-blocking switching performance and ultra-low latency, so reliable and lightning-fast connections to server and other switches are easily built.

Software Defined Networking (SDN) with Cloud Access

Omada's Software Defined Networking (SDN) platform integrates network devices, including access points, switches and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network-all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

Hassle-Free Cloud or On-Premises Controllers

Multi-Site Cloud Management

Zero-Touch Provisioning (ZTP)

Intelligent Monitoring

Secure Networking

Security features include IP-MAC-Port-VID Binding, Port Security, Storm Control and DHCP Snooping to defend against a range of network threats. An integrated list of common DoS attacks is available, making it easier than ever to prevent them. In addition, the Access Control Lists (ACL, L2 to L4) feature restricts access to sensitive network resources by denying packets based on source and destination MAC address, IP address, TCP/UDP ports or VLAN ID. Users' network access can be controlled via 802.1X authentication, which works with a RADIUS/Tacacs+ server to grant access only when valid user credentials are provided.

Enterprise Level Features

A complete lineup of L2+ features are supported, including 802.1Q VLAN, Port Mirroring, STP/RSTP/MSTP, Link Aggregation Control Protocol, and 802.3x Flow Control. Advanced IGMP Snooping ensures the switch intelligently forwards multicast streams to only the appropriate subscribers, cutting out unnecessary traffic, while IGMP throttling & filtering restrict each subscriber on a port level to prevent unauthorized multicast access. Static Routing is a simple way of segmenting the network and internally routs traffic through the switch for improved efficiency.

Advanced QoS

Voice and video traffic can be prioritized based on IP address, MAC address, TCP port number, UDP port number, and more. With QoS (Quality of Service), voice and video services remain smooth, even when bandwidth is in short supply.

ISP Features

sFlow, QinQ, L2PT PPPoE ID Insertion and IGMP authentication features are provided, developed with service providers in mind. 802.3ah OAM and Device Link Detection Protocol (DLDP) offer easy monitoring and troubleshooting of Ethernet links.

IPv6 Support

IPv6 functions such as Dual IPv4/IPv6 Stack, MLD Snooping, IPv6 ACL, DHCPv6 Snooping, IPv6 Interface, Path Maximum Transmission Unit (PMTU) Discovery and IPv6 Neighbor Discover guarantee your network is ready for the Next Generation Network (NGN) without upgrading your hardware.

(1)
Convenient Gigabit Switch for a Complete Omada Network

JetStream 24-Port Gigabit L2 Managed Switch with 4 SFP Slots

TL-SG3428

Reliable Gigabit Connections

24Ã— Gigabit RJ45 Ports and 4Ã— Gigabit SFP Ports

Advanced L2+ Features

L2/L3/L4 QoS, ACL, Static Routing and More

Abundant Secure Strategies

LAN Area Investment Protection

Centralized Cloud Management

SDN Solutions Integration for a Highly Efficient Network

Software Defined Networking (SDN) with Cloud Access

Omada's Software Defined Networking (SDN) platform integrates network devices, including access points, switches and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network-all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

Secure Networking

Security features include IP-MAC-Port-VID Binding, Port Security, Storm Control, and DHCP Snooping to defend against a range of network threats. An integrated list of common DoS attacks is available, making it easier than ever to prevent them. In addition, the Access Control Lists (ACL, L2 to L4) feature restricts access to sensitive network resources by denying packets based on source and destination MAC address, IP address, TCP/UDP ports, or VLAN ID. Users' network access can be controlled via 802.1X authentication, which works with a RADIUS/Tacacs+ server to grant access only when valid user credentials are provided.

Advanced QoS

Voice and video traffic can be prioritized based on IP address, MAC address, TCP port number, UDP port number, and more. With QoS (Quality of Service), voice and video services remain smooth, even when bandwidth is in short supply.

Abundant L2 and L2+ Features

A complete lineup of L2 features are supported including 802.1Q VLAN, Port Mirroring, STP/RSTP/MSTP, Link Aggregation Control Protocol, and 802.3x Flow Control. Advanced IGMP Snooping ensures the switch intelligently forwards multicast streams to only the appropriate subscribers, cutting out unnecessary traffic, while IGMP throttling & filtering restrict each subscriber on a port level to prevent unauthorized multicast access. Static Routing is a simple way of segmenting the network and internally routs traffic through the switch for improved efficiency.

ISP Features

sFlow, QinQ, L2PT PPPoE ID Insertion, and IGMP authentication features are provided, developed with service providers in mind. 802.3ah OAM and Device Link Detection Protocol (DLDP) offer easy monitoring and troubleshooting of Ethernet links.

IPv6 Support

IPv6 functions such as Dual IPv4/IPv6 Stack, MLD Snooping, IPv6 ACL, DHCPv6 Snooping, IPv6 Interface, Path Maximum Transmission Unit (PMTU) Discovery and IPv6 Neighbor Discover guarantee your network is ready for the Next Generation Network (NGN) without upgrading your hardware.

Enterprise Level Management Features

Easy to manage via an intuitive web-based Graphical User Interface (GUI) or an industry-standard Command Line Interface (CLI). For both management methods, traffic is protected through SSL or SSH encryption. SNMP (v1/v2c/v3) and RMON support enables the switch to be polled for valuable status information and to send traps on abnormal events.
(1)
Convenient Gigabit Switch with 24-Port PoE+ for a Complete Omada Network

JetStream 28-Port Gigabit L2 Managed Switch with 24-Port PoE+

TL-SG3428MP

PoE+ Output

24Ã— Gigabit PoE+ Ports with Total 384 W Power Budget

Centralized Cloud Management

SDN Solutions Integration for a Highly Efficient Network

Robust Security Strategies

LAN Area Investment Protection

Advanced L2+ Features

Static Routing, IGMP Snooping 802.1 Q VLAN and More

Dedicated 24 PoE+ Ports (384 W Budget) for Numerous Applications

Features 24Ã— 802.3af/at compliant PoE+ ports, the switch supports up to 384 W total PoE power budget. Designed to use a single Ethernet cable for both data and power transmission, it offers flexible deployment for PoE-supported devices such as wireless access points, IP cameras, and IP phones, lowering infrastructure costs for small businesses.

Software Defined Networking (SDN) with Cloud Access

Omada's Software-Defined Networking (SDN) platform integrates network devices, including access points, switches, and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network- all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

Secure Networking

Security features include IP-MAC-Port-VID Binding, Port Security, Storm Control, and DHCP Snooping to defend against a range of network threats. An integrated list of common DoS attacks is available, making it easier than ever to prevent them. In addition, the Access Control Lists (ACL, L2 to L4) feature restricts access to sensitive network resources by denying packets based on source and destination MAC address, IP address, TCP/UDP ports, or VLAN ID. Users' network access can be controlled via 802.1X authentication, which works with a RADIUS/Tacacs+ server to grant access only when valid user credentials are provided.

Advanced QoS

Voice and video traffic can be prioritized based on IP address, MAC address, TCP port number, UDP port number, and more. With QoS (Quality of Service), voice and video services remain smooth, even when bandwidth is in short supply.

Abundant L2 and L2+ Features

A complete lineup of L2 features are supported including 802.1Q VLAN, Port Mirroring, STP/RSTP/MSTP, Link Aggregation Control Protocol, and 802.3x Flow Control. Advanced IGMP Snooping ensures the switch intelligently forwards multicast streams to only the appropriate subscribers, cutting out unnecessary traffic, while IGMP throttling & filtering restrict each subscriber on a port level to prevent unauthorized multicast access. Static Routing is a simple way of segmenting the network and internally routs traffic through the switch for improved efficiency.

ISP Features

sFlow, QinQ, L2PT PPPoE ID Insertion, and IGMP authentication features are provided, developed with service providers in mind. 802.3ah OAM and Device Link Detection Protocol (DLDP) offer easy monitoring and troubleshooting of Ethernet links.

IPv6 Support

IPv6 functions such as Dual IPv4/IPv6 Stack, MLD Snooping, IPv6 ACL, DHCPv6 Snooping, IPv6 Interface, Path Maximum Transmission Unit (PMTU) Discovery and IPv6 Neighbor Discover guarantee your network is ready for the Next Generation Network (NGN) without upgrading your hardware.
(1)
High-Density Connectivity with 4Ã— Increased Capacity

OFDMA and Uplink & Downlink MU-MIMO increase network capacity by up to 4Ã— versus Wi-Fi 5 (802.11ac) in high-density environments to connect more devices simultaneously. Leverage multi-user capabilities and upgrade your business like never before.
Hospitality
High Quality and Full Coverage Wi-Fi
Restaurant
Full Wi-Fi Coveragein High-Density Environment
Shopping Mall
Social Marketing for O2O
Meeting Room
Wireless and Wired Connections for dense usage
Railway Station
High-Density Wi-F

Blazing Fast Speed with 8 Spatial Streams

The Omada Wi-Fi 6 Access Point features the latest 802.11ax technologies like 1024 QAM and Long OFDM Symbol, which allows the EAP to boost overall speeds up to 3550 Mbps (2402 Mbps on a 5 GHz band and 1148 Mbps on a 2.4 GHz band). With 8 spatial streams, multi-user throughput is incredibly increased to drive more applications.

Omada SDN-Smarter Cloud Solution for Business Networking

Omada Software Defined Networking (SDN) platform integrates network devices including access points, switches and gateways, guaranteeing powerful business network with higher efficiency, higher security, and higher reliability.

Hassle-Free Centralized Cloud Management:

100% centralized cloud management of whole network from different sites-all controlled from a single interface anywhere, anytime.

Optimized Wired Performance with 2.5 GE PoE+ Port

Armed with a 2.5 Gigabit Ethernet Port, the EAP660 HD delivers exceptional multi-gigabit performance to support the insatiable demand for better and faster Wi-Fi. Compatibility with standard 802.3at PoE+ is ideal for flexible deployment.

Seamless Roaming

802.11k/v roaming switches clients automatically to the AP with the optimal signal with a seamless transition when moving.This allows sensitive applications like VoIP and video conferences to go uninterrupted.

Boost Network Efficiency in All Aspects With Rich Advanced Features
Band Steering
Automatically moves dual band devices onto the wider 5GHz band for faster connections.
Load Balance
ensures large numbers of users have smooth network experiences in high-density business networks
Airtime Fairness
Increases average network throughput in heavily congested environments

Easy to Mount with Refined Industrial Design

push up

simply rotate to lock

Secure Guest Network with Facebook Wi-Fi and SMS Login

Guest Network provides elevated secure access to guests sharing your Wi-Fi network, with captive portal helping maintain only authorized guests to use the network. The addition of SMS and Facebook authentication simplifies the captive portal even further to simplify connectivity and power up your business.
(1)
High-Density Connectivity with 4Ã— Increased Capacity

OFDMA and Uplink & Downlink MU-MIMO increase network capacity by up to 4Ã— versus Wi-Fi 5 (802.11ac) in high-density environments to connect more devices simultaneously. Leverage multi-user capabilities and upgrade your business like never before.

Hospitality

High Quality and Full Coverage Wi-Fi

Restaurant

Full Wi-Fi Coverage in High-Density Environment

Shopping Mall

Social Marketing for O2O

Meeting Room

Wireless and Wired Connections for dense usage

Railway Station

High-Density Wi-F

Advanced Wi-Fi Speed with 4 Spatial Streams

The Omada Wi-Fi 6 Access Point features the latest 802.11ax technologies like 1024 QAM and Long OFDM Symbol, which allows the EAP to boost overall speeds up to 1775 Mbps (1201 Mbps on a 5 GHz band and 574 Mbps on a 2.4 GHz band). With 8 spatial streams, multi-user throughput is incredibly increased to drive more applications.

Omada SDN-Smarter Cloud Solution for Business Networking

Omada Software Defined Networking (SDN) platform integrates network devices including access points, switches and gateways, guaranteeing powerful business network with higher efficiency, higher security, and higher reliability.

Hassle-Free Centralized Cloud Management:

100% centralized cloud management of whole network from different sites-all controlled from a single interface anywhere, anytime.

Seamless Roaming

802.11k/v roaming switches clients automatically to the AP with the optimal signal with a seamless transition when moving. This allows sensitive applications like VoIP and video conferences to go uninterrupted.

Boost Network Efficiency in All Aspects With Rich Advanced Features

Band Steering

Automatically moves dual band devices onto the wider 5GHz band for faster connections.

Load Balance

ensures large numbers of users have smooth network experiences in high-density business networks

Airtime Fairness

Increases average network throughput in heavily congested environments

Easy to Mount with Refined Industrial Design

push up

simply rotate to lock

Secure Guest Network with Facebook Wi-Fi and SMS Login

Guest Network provides elevated secure access to guests sharing your Wi-Fi network, with captive portal helping maintain only authorized guests to use the network. The addition of SMS and Facebook authentication simplifies the captive portal even further to simplify connectivity and power up your business.
(1)
Professional, Secure, and Reliable Gigabit VPN Router

ER605

Centralized Management
Omada App
Gigabit Ports
Up to 4 WAN Ports
Load Balance
IPSec/OpenVPN/ PPTP/L2TP
Powerful Firewall
VLAN

Omada SDN-The Smarter Cloud Solution for Business Networking

As the gateway that seamlessly integrates into the Omada Software Defined Networking (SDN) platform, ER605 allows for remote and centralized management, anywhere, anytime. Standalone management via the Web UI or app is also available to maximize convenience.

Hassle-Free Centralized Cloud Management:

100% centralized cloud management of whole network from different sites-all controlled from a single interface anywhere, anytime.

Up to Four WAN Gigabit Ports to Optimize Bandwidth Usage

Three freely interchangeable ports that can be set to either WAN or LAN allow the router to support up to four WAN ports to satisfy various internet access requirements through one device. The multi-WAN Load Balancing function distributes data streams according to the bandwidth proportion of every WAN port to raise the utilization rate of multi-line broadband.

Highly Secure VPN

ER605 supports IPSec/PPTP/L2TP VPN over IPSec/SSL protocols. With a powerful hardware design, the router supports and manages up to 20Ã— LAN-to-LAN IPSec, 16Ã— OpenVPN, 16Ã— L2TP, and 16Ã— PPTP VPN connections. One-click auto IPSec VPN* greatly simplifies VPN configuration and facilitates network management and deployment while also securing and encrypting private site-to-site data communications traveling over the internet.

Abundant Security Features (1)
Realize More Possibilities with Omada

JetStream 10-Port Gigabit Smart Switch with 8-Port PoE+

TL-SG2210MP

Centralized Cloud Management

Omada SDN Platform Integration

Advanced L2 Features

L2/L3/L4 QoS, ACL, IGMP Snooping and More

Abundant Security Strategies

LAN Area Investment Protection

PoE+ Output

8 PoE+ Ports with Total 150 W Power Budget

Software Defined Networking (SDN) with Cloud Access

Omada's Software Defined Networking (SDN) platform integrates network devices, including access points, switches and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network-all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

(1)
Realize More Possibilities with Omada

JetStream 28-Port Gigabit Smart Switch with 24-Port PoE+

TL-SG2428P

Centralized Cloud Management

Omada SDN Platform Integration

Advanced L2+ Features

L2/L3/L4 QoS, ACL, Static Routing and More

Abundant Security Strategies

LAN Area Investment Protection

PoE+ Output

24 PoE+ Ports with Total 250 W Power Budget

Software Defined Networking (SDN) with Cloud Access

Omada's Software Defined Networking (SDN) platform integrates network devices, including access points, switches and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network-all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

(1)
The Smarter Cloud Solution for Business Networking.

JetStream 16-Port 10GE SFP+ L2+ Managed Switch TL-SX3016F

16Ã—Full 10 Gbps SFP+ Slots
Build reliable and lightning-fast connections to the servers and other switches with lightning-fast 10 Gbps slots, featuring high-bandwidth connectivity and ultra-low latency.

Centralized Cloud Management
Easily centrally manage the whole network with Omada SDN integration. Cloud access and the Omada app gives you the most convenient management experience.

(1)
Ultrafast 2.5G PoE+ Managed Switch with 10G Uplink for a Complete Omada Network

2.5G PoE+ Portsfor WiFi 6

8Ã— 2.5 Gbps Ports Unlock the Full Potential of WiFi 6 APs

10G Lightning-Fast Uplink Connection

2Ã— 10 Gbps SFP+ Slots for High-Bandwidth Connectivity

PoE+ Output

8 PoE+ Ports with Total 240 W Power Budget

Centralized Cloud Management

SDN Solutions Integration for a Highly Efficient Network

Centralized Cloud Management

SDN Solutions Integration for a Highly Efficient Network

Unlock the Full Potential of WiFi 6 with Multi-Gigabit PoE+ Ports

Featuring 8Ã— 2.5 Gbps PoE+ ports, the switch is capable of future network expansion and deployment, providing sufficient bandwidth for incoming WiFi 6 APs. Designed to use a single Ethernet cable for both data and power transmission, it supports up to 240 W total PoE power budget and flexible installation to fit in various application scenarios.

Enterprise Switch with 10G Uplink

2Ã— 10 Gbps SFP+ slots provide non-blocking switching performance and ultra-low latency, so reliable and lightning-fast connections to servers and other switches are easily built.

Software-Defined Networking (SDN) with Cloud Access

Omada's Software-Defined Networking (SDN) platform integrates network devices, including access points, switches, and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network-all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

Hassle-Free Cloud or On-Premises Controllers

Multi-Site Cloud Management

Zero-Touch Provisioning (ZTP)

Intelligent Monitoring

Advanced L3 Features

An abundance of L2+ and L3 features are supported to help build a highly scalable and robust network, providing a reliable and efficient solution for enterprises, campuses, and ISPs.

Secure Networking

Security features include IP-MAC-Port-VID Binding, Port Security, Storm Control and DHCP Snooping to defend against a range of network threats. An integrated list of common DoS attacks is available, making it easier than ever to prevent them. In addition, the Access Control Lists (ACL, L2 to L4) feature restricts access to sensitive network resources by denying packets based on source and destination MAC address, IP address, TCP/UDP ports, or VLAN ID. Users' network access can be controlled via 802.1X authentication, which works with a RADIUS/Tacacs+ server to grant access only when valid user credentials are provided.

Enterprise Level Features

A complete lineup of L2+ features are supported, including 802.1Q VLAN, Port Mirroring, STP/RSTP/MSTP, Link Aggregation Control Protocol, and 802.3x Flow Control. Advanced IGMP Snooping ensures the switch intelligently forwards multicast streams to only the appropriate subscribers, cutting out unnecessary traffic, while IGMP throttling & filtering restrict each subscriber on a port level to prevent unauthorized multicast access. Static Routing is a simple way of segmenting the network and internally routs traffic through the switch for improved efficiency.

Advanced QoS

Voice and video traffic can be prioritized based on IP address, MAC address, TCP port number, UDP port number, and more. With QoS (Quality of Service), voice and video services remain smooth, even when bandwidth is in short supply.
(1)
What This Product Does

TL-SF1005P is a 5 10/100Mbps ports unmanaged switch that requires no configuration and provides 4 PoE (Power over Ethernet) ports. It can automatically detect and supply power with all IEEE 802.3af compliant Powered Devices (PDs). In this situation, the electrical power is transmitted along with data in one single cable allowing you to expand your network to where there are no power lines or outlets, where you wish to fix devices such as APs, IP Cameras or IP Phones, etc.

Power over Ethernet

4 of the 5 Auto-Negotiation RJ45 ports (Port 1 to Port 4) of the switch support Power over Ethernet (PoE) function. These PoE ports can automatically detect and supply power with those IEEE 802.3af compliant Powered Devices (PDs).

Overload Arrangement

TL-SF1005P has the priority function which will help protect the system when the system power is overloaded. If all PoE PDs power consumption is >= 58W, a priority will be arranged among the PoE ports, then the system will cut off the power of the lowest-priority port.

Port Priority Function

Priority (port-1=port-2=port-3>port-4): This function will help to ensure the normal operation of the system, it means Port 4 will be cut off when all total PoE PDs power consumption exceed 58W. For an example, Port 1, 2 and 4 is using 15.4W (maximum power for per port is 15.4W); the system power is 46.2W in total. If there is an additional PD inserted to Port 3 with 12W, and then the system will cut off the power of Port 4 because of the overloaded power, this means Port 1, 2 will use 15.4W, and Port3 will use 12W, no power will be supplied to Port 4.

Easy To Use

TL-SF1005P is easy to install and use. It requires no configuration and installation. With desktop design, outstanding performance and quality, the TP-Link's TL-SF1005P 5-Port 10/100Mbps Desktop Switch with 4-Port PoE is an ideal choice for expanding your home or office network.

(1)
What This Product Does

TP-Link JetStream Gigabit L2 managed switch T2600G-52TS provides 48 10/100/1000Mbps ports and 4 Gigabit SFP Slots. The switch provides high performance, powerful L2 and L2+ features like static routing, enterprise-level QoS and other advanced security strategies. The IP-MAC-Port Binding and Access Control List (ACL) functions protect against broadcast storm, ARP and Denial-of-Service (DoS) attacks, etc. Quality of Service (QoS, L2 to L4) provides enhanced traffic management capabilities to move your data smoother and faster. Moreover, the easy-to-use web management interfaces, along with CLI, SNMP, RMON and Dual Image mean faster setup and configuration with less downtime. For workgroup and departments requiring cost-sensitive L2 Switch and gigabit capability, TP-Link JetStream 48-Port Gigabit L2 managed Switch T2600G-52TS provides you the ideal network solution.

Secure Networking

TP-Link JetStream L2 managed switch T2600G-52TS provides IP-MAC-Port Binding, Port Security, Storm control and DHCP Snooping which protect against broadcast storms, ARP attacks, etc. It integrates some typical DoS attacks to select. You can protect these attacks more easily ever than before. In addition, the Access Control Lists (ACL, L2 to L4) feature restricts access to sensitive network resources by denying packets based on source and destination MAC address, IP address, TCP/UDP ports and even VLAN ID. Moreover, the switch supports 802.1X authentication, which is used in conjunction with a RADIUS server to require some authentication information before access to the network is allowed. Guest VLAN function supports to enable the non-802.1X clients to access the specific network resource.

Advanced QoS features

To integrate voice, data and video service on one network, the switch applies rich QoS policies. Administrator can designate the priority of the traffic based on a variety of means including IP or MAC address, TCP or UDP port number, etc, to ensure that voice and video are always clear, smooth and jitter free. In conjunction with the Voice VLAN the switch supporting, the voice applications will operate with much smoother performance.

Abundant L2 and L2+ features

T2600G-52TS supports a complete lineup of L2 features, including 802.1Q tag VLAN, Port Mirroring, STP/RSTP/MSTP, Link Aggregation Control Protocol and 802.3x Flow Control function. Any more, the switch provides advanced features for network maintenance, such as Cable Diagnostics and IGMP Snooping. IGMP snooping ensures the switch intelligently forward the multicast stream only to the appropriate subscribers while IGMP throttling & filtering restrict each subscriber on a port level to prevent unauthorized multicast access. Moreover, T2600G-52TS supports L2+ feature-static routing, which is a simple way to provide segmentation of the network with internal routing through the switch and helps network traffic for more efficient use.

IPv6 Support

T2600G-52TS supports various IPv6 functions such as Dual IPv4/IPv6 Stack, MLD Snooping, IPv6 ACL, DHCPv6 Snooping, IPv6 Interface, Path Maximum Transmission Unit (PMTU) Discovery and IPv6 Neighbor Discovery, which guarantees your network is ready for the Next Generation Network (NGN) without upgrading your network equipment.

OAM

The T2600G-52TS provides 802.3ah OAM and Device Link Detection Protocol (DLDP) functions improving monitor and troubleshoot Ethernet networks, help facilitate network management.
(1)
What This Product Does

TP-Link smart switch T1500-28PCT is equipped with 24 10/100Mbps RJ45 ports, 4 10/100/1000Mbps RJ45 ports and 2 combo Gigabit SFP slots. All of the 24 10/100Mbps RJ45 ports support the 802.3at/af (PoE+) standard with total PoE power budget of 192W and useful PoE power management features. The switch provides high performance, enterprise-level QoS, useful security strategies and rich layer 2 management features.

TP-Link smart switch T1500-28PCT is a cost-effÂective product solution for the small and medium business. T1500-28PCT has useful security features. The Storm Control feature protects against Broadcast, Multicast and Unknown unicast Storm. Quality of Service (QoS, L2 to L4) provides enhanced traffic management capabilities to move your data smoother and faster. Anymore, the easy-to-use web management interfaces, along with SNMP and RMON, mean faster setup and configuration with less downtime. For workgroup and departments requiring cost-sensitive layer 2 switch and gigabit capability, TP-Link smart switch T1500-28PCT provides you the ideal access-edge solution.

IEEE 802.3at/af-compliant Power over Ethernet

The T1500-28PCT supports 24 ports of IEEE 802.3af/at-compliant PoE and has a total power supply of 192W to power any 802.3af/at-compliant power device. It's an efficient and cost-effective choice to work with wireless access points, surveillance cameras, IP phones and other PoE supported devices, while getting rid of cables or power lines running around. Compact and flexible, the T1500-28PCT is ideal to flexibly use PoE to deploy wireless access points or IP-based network surveillance cameras for projects or small business networks.

Advanced QoS features

To integrate voice, data and video service on one network, the switch applies rich QoS policies. Administrator can designate the priority of the traffic based on a variety of means including Port Priority, 802.1P Priority and DSCP Priority, to ensure that voice and video are always clear, smooth and jitter free. In conjunction with the Voice VLAN the switch supports, the voice applications will operate with much smoother performance.

Abundant Layer 2 features

For more application of layer 2 switches, T1500-28PCT supports a complete lineup of layer 2 features, including 802.1Q tag VLAN, Port Isolation, Port Mirroring, STP/RSTP/MSTP, Link Aggregation Group and 802.3x Flow Control function. Any more, the switches provide advanced features for network maintenance such as Loop Back Detection, Cable Diagnostics and IGMP Snooping. IGMP snooping ensures the switch intelligently forward the multicast stream only to the appropriate subscribers while IGMP throttling & filtering restrict each subscriber on a port level to prevent unauthorized multicast access.

Enterprise Level Management Features

T1500-28PCT is easy to use and manage. It supports various user-friendly standard management features, such as intuitive web-based Graphical User Interface (GUI) or industry-standard Command Line Interface (CLI). SNMP (v1/2/3) and RMON support enables the switch to be polled for valuable status information and send traps on abnormal events.
(1)
LED MR16 bulb with a silver back finish produces 500 lumens of warm, white light for up to 25,000 hours. 6.5-watt, dimmable bulb offers a 40-degree beam spread to directly illuminate specific locations. 12-volt, dimmable bulb also features a 3,000 Kelvin temperature, 80 CRI and GU5.3 base.
(1)
Centralized Management: Up to 500 Omada access points, 100 JetStream switches, and 100 Omada routers.

Free Cloud Access: Manage and monitor with the Omada app or Web UI from anywhere, anytime.

On-Premises Management: Locally monitor and manage devices with the ultimate security and stability.

Industry-Leading Hardware Design: A powerful chipset, durable metal casing, USB 3.0 port for auto backup, and two Gigabit ports.

Easy and Intelligent Network Monitoring: The easy-to-use dashboard makes it simple to see the real-time network status and traffic distribution.

Real-Time Network Topology: Helps IT admins quickly see and troubleshoot connections at a glance.

Easier Network Maintenance: WiFi heatmap simulator, visualizable network report, and batch & multi-site management benefit network maintenance.

Hardware Controller (1)
TP-Link's JetStream L2+ managed switches provide high performance, powerful L2 and L2+ features like static routing, enterprise-level QoS, advanced security strategies and a bundle of ISP features. The 10-gigabit ports ensure high-speed data transfer, and their backward compatility with gigabit products reserves room for network upgrades, therefore guarantees stable and long-term usability. The IP-MAC-Port Binding (IMPB) and Access Control List (ACL) functions protect against broadcast storm, ARP and Denial-of-Service (DoS) attacks, etc. Quality of Service (QoS, L2 to L4) provides enhanced traffic management capabilities to move your data smoother and faster. The OAM function helps facilitate network management. Moreover, the easy-to-use web management interfaces, along with CLI, SNMP and Dual Image mean faster setup and configuration with less downtime. TP-Link JetStream L2+ 10-gigabit managed switches provide a reliable, secure solution for enterprise, campus and ISP networks.

Omada Solution (1)
TP-Link's brand new JetStream gigabit smart switches provide huge upgrade comparing with previous versions. The switches can be managed by Omada SDN Controller, which provides professional and reliable one-step solutions. Integrated L2 and L2+ features such as 802.1Q VLAN, QoS, IGMP Snooping and static routing provide cost-effective networking solutions for small and medium-sized businesses without sacrificing enhanced usability and strong performance.

Omada Solution

Software Defined Networking (SDN) with Cloud Access Omada Software Defined Networking (SDN) platform integrates network devices, including access points, switches and gateways, providing 100% centralized cloud management. Omada creates a highly scalable network--all controlled from a single interface. Seamless wireless and wired connections are provided, ideal for use in hospitality, education, retail, offices, and more.

Hassle-Free Centralized Cloud Management

100% centralized cloud management of the whole network from different sites--all controlled from a single interface anywhere, anytime.

Zero-Touch Provisioning for Efficient Deplyment

Omada zero-touch provisioning allows remotely deployment and configuration of multi-site networks, so there's no need to send out an engineer for on-site configuration. The Omada Cloud ensures efficient deployment with lower costs.

AI-Driven Technology for Stronger Performance and Easy Network Maintenance

Assign Different Management Roles

Multi-tenant privilege assignment is available to increase management efficiency and security. Multi-person management, multi-level permissions, and the ability to add admins as needed, enable flexible network operation and maintenance.

Easy and Intelligent Network Monitoring

Comprehensive Protection for the Whole Network The easy-to-use dashboard makes it easy to see your real-time network status; check network usage and traffic distribution; receive network condition logs, abnormal event warnings, and notifications; or even track key data for better business results. Network topology helps IP admins quickly see and troubleshoot connection at a glance.

Comprehensive Protection for the Whole Network

Multiple Factors Guarantee Higher Reliability

Reliable Connections Even with High-Density Clients Higher reliability of cloud service is guaranteed with 99.99% SLA availability, 24/7 automated fault detection, geographically isolated backup servers, and reliable product quality. Your network functions even if management traffic is interrupted.

Reliable Connections Even with High-Density Clients

Higher reliability of cloud service is guaranteed with 99.99% SLA availability, 24/7 automated fault detection, geographically isolated backup servers, and reliable product quality. Your network functions even if management traffic is interrupted. Equipped with enterprise chipsets, dedicated antennas, advanced RF functions, auto channel selection, and power adjustment, Omada Wi-Fi 6 and Wi-Fi 5 APs have high concurrency capacities for remarkable performance in high-density environments.
(1)

Width

17.30"" (439.42 mm) (8)
17.32"" (440 mm) (2)
9.60"" (243.84 mm) (2)
11.60"" (294.64 mm) (1)
17.32"" (439.93 mm) (1)
3.93"" (99.80 mm) (1)
5.63"" (143 mm) (1)
6.20"" (157.48 mm) (1)
7.10"" (180.34 mm) (1)
8.20"" (208.28 mm) (1)
9.57"" (243 mm) (1)

Height

1.70"" (43.18 mm) (8)
1"" (25.40 mm) (2)
1.73"" (43.94 mm) (2)
1.73"" (44 mm) (2)
2.50"" (63.50 mm) (2)
0.79"" (20 mm) (1)
0.98"" (25 mm) (1)
11.60"" (294.64 mm) (1)
2.52"" (64 mm) (1)

Package Contents

24-Port 10/100Mbps + 4-Port Gigabit Smart PoE+ Switch

Power Cord

Installation Guide

Rackmount Kit

Rubber Feet

(1)

5-Port 10/100Mbps Desktop Switch with 4-Port PoE+

Power Adapter

User Guide

(1)

AX1800 Wireless Dual Band Ceiling Mount Access Point

Power Adapter

Ceiling/Wall Mounting Kits

Installation Guide

(1)

AX3600 Wireless Dual Band Multi-Gigabit Ceiling Mount Access Point

Power Adapter

Ceiling/Wall Mounting Kits

Installation Guide

(1)

JetStream 10-Port Gigabit Smart Switch with 8-Port PoE+

Power Cord

Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream 16-Port 10GE SFP+ L2+ Managed Switch

2 Ã— Power Cords

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream 24-Port Gigabit L2 Managed Switch with 4 SFP Slots

Power Cord

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream 24-Port Gigabit L2+ Managed Switch with 4 10GE SFP+ Slots

Power Cord

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream 28-Port Gigabit L2 Managed Switch with 24-Port PoE+

Power Cord

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream 28-Port Gigabit Smart Switch with 24-Port PoE+

Power Cord

Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream 48-Port Gigabit L2 Managed Switch with 4 SFP Slots

Power Cord

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream 8-Port 10GE SFP+ L2+ Managed Switch

Power Cord

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream TL-SG2008P Ethernet Switch

Power Adapter

Installation Guide

Rubber Feet

(1)

JetStream TL-SG2218 Ethernet Switch

Power Cord

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream TL-SG3210XHP-M2 Ethernet Switch*

Power Cord

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

JetStream TL-SG3452P Ethernet Switch

Power Cord

Quick Installation Guide

Rackmount Kit

Rubber Feet

(1)

OC300 Infrastructure Management Equipment

Quick Installation Guide

Ethernet Cable

Power Cord

Rackmount Kit

(1)

Omada EAP610 Wireless Access Point

Power Adapter

Ceiling/Wall Mounting Kits

Installation Guide

(1)

Omada EAP615-Wall Wireless Access Point

Installation Guide

Mounting Kits

(1)

Omada Gigabit VPN Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

Depth

7.10"" (180.34 mm) (5)
8.70"" (220.98 mm) (4)
9.60"" (243.84 mm) (2)
1.70"" (43.18 mm) (1)
12.99"" (330 mm) (1)
13"" (330.20 mm) (1)
3.39"" (86 mm) (1)
3.86"" (98 mm) (1)
4"" (101.60 mm) (1)
4.90"" (124.46 mm) (1)
7.09"" (180 mm) (1)
9.57"" (243 mm) (1)

Product Model

EAP610 (1)
EAP615-Wall (1)
EAP620 HD (1)
EAP660 HD (1)
ER605 (1)
OC300 (1)
T1500-28PCT (1)
T2600G-52TS (1)
TL-SF1005P (1)
TL-SG2008P (1)
TL-SG2210MP (1)
TL-SG2218 (1)
TL-SG2428P (1)
TL-SG3210XHP-M2 (1)
TL-SG3428 (1)
TL-SG3428MP (1)
TL-SG3428X (1)
TL-SG3452P (1)
TL-SX3008F (1)
TL-SX3016F (1)

Ethernet Technology

Gigabit Ethernet (12)
10 Gigabit Ethernet (2)
2.5 Gigabit Ethernet (1)
2.5 Gigabit Ethernet
10 Gigabit Ethernet
(1)
Fast Ethernet
Gigabit Ethernet
(1)
Gigabit Ethernet
10 Gigabit Ethernet
(1)
Fast Ethernet (1)

Form Factor

Rack-mountable
Desktop
(7)
Desktop
Rack-mountable
(3)
Ceiling Mountable
Wall Mountable
(2)
Desktop (2)
Rack-mountable (2)
Desktop
Wall Mountable
(1)
Wall Mountable
Ceiling Mountable
(1)
Wall Mountable
Wall Plate
(1)

Power Consumption

1.90 W (1)
10 W (1)
10.80 W (1)
12.20 W (1)
12.30 W (1)
13.50 W (1)
15.46 W (1)
17.20 W (1)
18.80 W (1)
19.90 W (1)
21.50 W (1)
23.60 W (1)
32.10 W (1)
32.74 W (1)
32.80 W (1)
34.40 W (1)
52.50 W (1)
7.90 W (1)

Product Line

JetStream (12)
Omada (3)

Networking Standards

IEEE 802.1p
IEEE 802.3ad
IEEE 802.1D
IEEE 802.1w
IEEE 802.1s
IEEE 802.3x
IEEE 802.1Q
IEEE 802.1x
IEEE 802.1ab
(5)
IEEE 802.3af
IEEE 802.3at
IEEE 802.1p
IEEE 802.3ad
IEEE 802.1D
IEEE 802.1w
IEEE 802.1s
IEEE 802.3x
IEEE 802.1Q
IEEE 802.1x
IEEE 802.1ab
(2)
IEEE 802.1p
IEEE 802.3ad
IEEE 802.1D
IEEE 802.1w
IEEE 802.1s
IEEE 802.3x
IEEE 802.1Q
IEEE 802.1x
(1)
IEEE 802.1x
IEEE 802.1p
IEEE 802.3ad
IEEE 802.1D
IEEE 802.1w
IEEE 802.1s
IEEE 802.3x
IEEE 802.1Q
IEEE 802.1ab
(1)
IEEE 802.3af
IEEE 802.3at
IEEE 802.3x
(1)
IEEE 802.3i
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3ad
IEEE 802.3af
IEEE 802.3at
IEEE 802.1x
IEEE 802.1D
IEEE 802.1s
IEEE 802.1w
IEEE 802.1Q
IEEE 802.1p
IEEE 802.3x
(1)
IEEE 802.3i
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3az
IEEE 802.3ad
IEEE 802.3x
IEEE 802.3z
IEEE 802.1D
IEEE 802.1s
IEEE 802.1w
IEEE 802.1Q
IEEE 802.1p
IEEE 802.1x
(1)
IEEE 802.3i
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3z
IEEE 802.3ad
IEEE 802.3x
IEEE 802.3af
IEEE 802.3at
IEEE 802.3az
IEEE 802.1D
IEEE 802.1s
IEEE 802.1w
IEEE 802.1Q
IEEE 802.1x
IEEE 802.1p
(1)
IEEE 802.3i
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3z
IEEE 802.3ad
IEEE 802.3x
IEEE 802.3az
IEEE 802.1D
IEEE 802.1s
IEEE 802.1w
IEEE 802.1Q
IEEE 802.1p
IEEE 802.3af
IEEE 802.3at
(1)

Port/Expansion Slot Details

24 x Gigabit Ethernet PoE+
4 x Gigabit Ethernet Expansion Slot
(2)
16 x 10 Gigabit Ethernet Expansion Slot (1)
8 x 10 Gigabit Ethernet Expansion Slot (1)
1 x Fast Ethernet Network
4 x Fast Ethernet PoE+
(1)
16 x Gigabit Ethernet Network
2 x Gigabit Ethernet Expansion Slot
(1)
24 x Fast Ethernet PoE+
4 x Gigabit Ethernet Network
2 x Gigabit Ethernet TP/SFP Combo
(1)
24 x Gigabit Ethernet Network
4 x 10 Gigabit Ethernet Expansion Slot
(1)
24 x Gigabit Ethernet Network
4 x Gigabit Ethernet Expansion Slot
(1)
4 x Gigabit Ethernet PoE+
4 x Gigabit Ethernet Network
(1)
48 x Gigabit Ethernet Network
4 x Gigabit Ethernet Expansion Slot
(1)
48 x Gigabit Ethernet PoE+
4 x Gigabit Ethernet Expansion Slot
(1)
8 x 2.5 Gigabit Ethernet PoE+
2 x 10 Gigabit Ethernet Expansion Slot
(1)
8 x Gigabit Ethernet PoE+
2 x Gigabit Ethernet Expansion Slot
(1)

Network Technology

10/100/1000Base-T
1000Base-X
(5)
10GBase-X (2)
1000Base-T
1000Base-X
(2)
10/100Base-T (1)
1000Base-T (1)
10/100/1000Base-T
10GBase-X
(1)
10/100Base-T
1000Base-T
1000Base-X
(1)
2.5GBase-T
10GBase-X
(1)

Media Type Supported

Optical Fiber
Twisted Pair
(7)
Twisted Pair
Optical Fiber
(3)
Optical Fiber (2)
Twisted Pair (2)

Power Source

Power Supply (11)
Power Adapter (2)
Power Supply
PoE
(1)

Layer Supported

2 (7)
3 (5)
4 (2)

Manageable

Yes (13)
No (1)

Modular

Yes (12)
No (1)

Number of Total Expansion Slots

4 (6)
2 (4)
16 (1)
8 (1)

Total Number of Network Ports

24 (4)
48 (2)
8 (2)
10 (1)
16 (1)
28 (1)
5 (1)

Expansion Slot Type

SFP (mini-GBIC) (7)
SFP+ (4)
SFP (1)

PoE (RJ-45) Port

Yes (9)
No (1)

Number of SFP Slots

4 (5)
2 (3)

PoE Budget

250 W (2)
384 W (2)
150 W (1)
240 W (1)
62 W (1)
67 W (1)

Number of Network (RJ-45) Ports

1 (3)
4 (2)

Additional Information

Legal Disclaimer:
Actual network speed may be limited by the rate of the product's Ethernet WAN or LAN port, the rate supported by the network cable, Internet service provider factors and other environmental conditions.
(4)
Cloud Access: Yes
L3 Management: Yes
Multi-site Management: Yes
Operating Temperature: 0-50 ? (32-122 ?)
Storage Temperature: -40-70 ? (-40-158 ?)
Operating Humidity: 10-90% RH non-condensing
Storage Humidity: 5-90% RH non-condensing

Management Features:
Automatic Device Discovery
Batch Configuration
Batch Firmware Upgrading
Intelligent Network Monitoring
Abnormal Event Warnings
Unified Configuration
Reboot Schedule
Captive Portal Configuration

System Requirements:
Windows 10
Windows 8
Windows 7
Windows Vista
Windows XP
MAC OS
NetWare
UNIX
Linux

Legal Disclaimer:
Actual network speed may be limited by the rate of the product's Ethernet WAN or LAN port, the rate supported by the network cable, Internet service provider factors and other environmental conditions.
(1)

Encryption Standard

WEP
WPA-PSK
WPA2-PSK
WPA3-PSK
WPA3-Personal
WPA-ENT
WPA2-ENT
WPA3-ENT
(1)
WPA-PSK
WPA-ENT
WPA2-PSK
WPA2-ENT
WPA3-Personal
WPA3-ENT
(1)
WPA-PSK
WPA2-PSK
WEP
WPA-ENT
WPA2-ENT
WPA3-ENT
WPA3-Personal
(1)
WPA2-ENT
WPA3-ENT
WPA3-Personal
WPA-PSK
WPA2-PSK
WPA-ENT
(1)

Indoor/Outdoor

Indoor (2)
Outdoor (2)

Shared SFP Slot

No (3)
Yes (1)

Uplink Port

No (2)
Yes (2)

Wireless Transmission Speed

1.76 Gbit/s (2)
1.73 Gbit/s (1)
3.52 Gbit/s (1)

Number of SFP+ Slots

16 (1)
2 (1)
4 (1)
8 (1)

Product Color

Black (1)
White (1)

Input Voltage

12 V AC
12 V DC
(1)
120 V AC
230 V AC
(1)

Weight (Approximate)

1.31 kg (1)
4.22 kg (1)

Application Log
Timestamp	Level	Category	Message
19:33:45.984937	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
19:33:45.985269	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
19:33:45.985681	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
19:33:45.986084	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
19:33:45.988554	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
19:33:45.989989	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
19:33:45.991046	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
19:33:45.991801	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
19:33:45.992409	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `portals` `t` WHERE `t`.`domain`=:yp0 LIMIT 1 in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
19:33:45.992566	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
19:33:45.993108	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
19:33:45.993763	trace	system.db.ar.CActiveRecord	User.find() in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
19:33:45.995197	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `users` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
19:33:45.995663	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `users` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
19:33:45.995909	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `accounts` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
19:33:45.996310	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `accounts` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
19:33:45.996484	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (LOWER(username)=?) in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
19:33:45.999186	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
19:33:45.999263	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
19:33:45.999557	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
19:33:45.999577	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
19:33:45.999932	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
19:33:46.000046	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `hidden_products` `t` WHERE (customer_id = 3259 OR group_id=5) AND category_id <> 0 in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
19:33:46.000283	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
19:33:46.000303	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
19:33:46.000653	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
19:33:46.000755	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cust_categories` `t` WHERE group_id=5 in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
19:33:46.000869	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
19:33:46.003484	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
19:33:46.003710	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
19:33:46.003788	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
19:33:46.004122	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
19:33:46.004144	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_exceptions` in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
19:33:46.004498	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_exceptions` in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
19:33:46.004612	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `price_exceptions` `t` WHERE customer_id=3259 in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
19:33:46.004743	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
19:33:46.004760	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `price_exceptions` `t` WHERE customer_id=0 in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
19:33:46.030647	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.030678	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=37714 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.031377	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.031919	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032080	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032095	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54008 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032340	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032350	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54009 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032541	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032552	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54010 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032722	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032732	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54011 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032891	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.032898	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54012 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033056	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033065	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54014 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033220	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033229	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54035 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033382	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033391	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54064 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033545	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033554	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54066 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033709	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033718	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54068 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033871	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.033879	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54069 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034034	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034041	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54070 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034270	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034277	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54071 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034468	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034476	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54072 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034693	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034702	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54073 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034873	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.034882	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54074 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.035083	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.035092	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54078 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.035310	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.035319	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54080 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.035540	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.035547	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54081 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
19:33:46.035865	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.035886	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `categories` in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036324	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `categories` in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036456	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036577	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036602	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036710	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036732	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036844	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036864	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036967	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.036988	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
19:33:46.037483	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
19:33:46.037503	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
19:33:46.037940	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
19:33:46.038070	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cart_items` `t` WHERE `t`.`session_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
19:33:46.068479	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.068588	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.068964	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.068984	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_list_details` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.069400	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_list_details` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.069633	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_lists` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.069966	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_lists` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.070095	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.071069	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.071090	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=37714 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.071307	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.071329	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `sale_prices` in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.071662	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `sale_prices` in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.071753	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=37714 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
19:33:46.071969	trace	system.CModule	Loading "widgetFactory" application component in /home/rose/dev/protected/views/product/list.php (238) in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)
19:33:46.072634	trace	system.CModule	Loading "coreMessages" application component in /home/rose/dev/protected/views/product/list.php (238) in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)
19:33:46.073568	trace	system.db.ar.CActiveRecord	CartItem.count() in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (621)
19:33:46.073602	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `cart_items` `t` WHERE session_id = :sid in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (621)
19:33:46.085052	trace	system.db.ar.CActiveRecord	CartItem.count() in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (118) in /home/rose/dev/protected/controllers/ProductController.php (621)
19:33:46.085083	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `cart_items` `t` WHERE session_id = :sid in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (118) in /home/rose/dev/protected/controllers/ProductController.php (621)
19:33:46.096992	trace	system.db.ar.CActiveRecord	Product.findByPk() in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143) in /home/rose/dev/protected/controllers/ProductController.php (621)
19:33:46.097023	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `products` `t` WHERE `t`.`id`=13228 LIMIT 1 in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143) in /home/rose/dev/protected/controllers/ProductController.php (621)
19:33:46.097188	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (61) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
19:33:46.097278	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (61) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
19:33:46.097476	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (83) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
19:33:46.097543	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (83) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
19:33:46.098527	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (91) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
19:33:46.098553	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=13228 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (91) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
19:33:46.098705	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (109) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
19:33:46.098721	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=13228 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (109) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
19:33:46.098978	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)

Products

Satco LED MR16 Warm 500 Lumens Light Bulb

SDNS9496

Are you sure