OfficeCo

TP-Link (22)
StarTech.com (8)
Kasa Smart (7)
Adesso (3)
HP (3)
Club 3D (2)
Targus (2)
3M (1)
Satco (1)
Tapo (1)
Verbatim (1)

Marketing Information

Ink cartridge delivers durable, high-quality text documents and vivid color images. Cartridge design uses proven and proprietary ink technology (pigment-based) for increased durability and reliability. Your documents and marketing materials will stand up to water and resist fading over time. HP 933XL cartridge is designed for use with Hewlett-Packard Officejet 6700 Premium, Officejet 6600 and Officejet 6100 printers. Color cartridge yields approximately 825 pages.

(3)
The Adesso CyberTrack H4 HD desktop webcam features 1080p HD video resolution, allowing you to record and share colorful HD quality video. The webcam offers broad compatibility with today's most popular video conferencing applications. It also includes an integrated microphone that lets your voice be heard loud and clear, whether you are chatting with loved ones or conducting a business video conference. With all these great features, you can easily record and transmit your videos to everyone!
- 1080p HD video
- 2.1 MP CMOS sensor at maximum resolution
- Video conferencing compatibility
- Integrated microphone
(3)
16 Million Colors

Decorate your spaces with vivid colors for any event.

Dimmable

Adjust the brightness from 1% to 100% conveniently with the Kasa Smart app.

Tunable Whites

Tune your lights slowly to a cozy warm white (2500 K) to relax at night or an energetic bright white (6500 K) when you need a boost in the morning.

Set Schedules

Easily create a worry-free schedule for your lights to follow your daily routine.

Control from Anywhere

Control your smart light bulb from anywhere with the free Kasa Smart app. Dim, turn on or off, or change the colors of your light bulb remotely at your fingertips.

Hands-Free Voice Control

Use simple voice commands to set the scene for a party, turn lighting on or off without leaving the couch, or even change colors in your dining room to create the perfect ambiance.

Group Lighting Controls

Group your smart lights for seamless control of brightness, colors, and more. And switch your lights and other devices on or off altogether.

App-Guided Easy Setup

Screw in the smart bulb, follow the setup instructions on the Kasa Smart app, name it, and you're good to go!
(2)
Easily Expand Your Wi-Fi Coverage
Tired of Wi-Fi dead zones in your home? The RE305 Range Extender connects to your Wi-Fi router wirelessly, strengthening and expanding its signal into areas it can't reach on its own, while reducing signal interference to ensure reliable Wi-Fi coverage throughout your home or office.

High-Speed Dual Band Wi-Fi for Better Connections

The RE305 lets you keep more devices connected at the same time with its 2.4GHz 300Mbps and 5GHz 867Mbps dual bands. Use the 2.4GHz band to send email and browse the web, and the 5GHz band for gaming and HD streaming.

Perfect Location at a Glimpse

An Intelligent Signal light helps you quickly find the best location to install the RE305.

Built-in Access Point Mode

RE305 is more than a wireless range extender. Simply plug the Ethernet cable into its Ethernet port to easily turn your wired internet connection into a dual band wireless access point.

Easy Management and Remote Control

The RE305 works with all Wi-Fi routers. You can use TP-Link's free Tether app to set up the range extender from any Android or iOS device in minutes. This feature-rich phone app allows you to enjoy not only hassle-free installation, but also access to advanced network management, all at your fingertips.
(1)
What This Product Does
The TL-SG105E 5-Port Gigabit Easy Smart switch is an ideal upgrade from an unmanaged switch, designed for Small and Medium Business networks that require simple network management. Network administrators can effectively monitor traffic via Port Mirroring, Loop Prevention and Cable Diagnostics features. To optimize traffic on your business network, TL-SG105E offers both port and tag based QoS to keep latency-sensitive traffic moving smoothly and jitter-free. Additionally, port-based, tag-based and MTU VLAN can improve security and meet more network segmentation requirements. Moreover, with its innovative energy-efficient technology, the TL-SG105E can save up to 75% of power consumption, making it an eco-friendly solution for your business network.
(1)
What This Product Does
The TL-SG108E 8-Port Gigabit Easy Smart switch is an ideal upgrade from an unmanaged switch, designed for Small and Medium Business networks that require simple network management. Network administrators can effectively monitor traffic via Port Mirroring, Loop Prevention and Cable Diagnostics features. To optimize traffic on your business network, TL-SG108E offers both port and tag based QoS to keep latency-sensitive traffic moving smoothly and jitter-free. Additionally, port-based, tag-based and MTU VLAN can improve security and meet more network segmentation requirements. Moreover, with its innovative energy-efficient technology, the TL-SG108E can save up to 80% of power consumption, making it an eco-friendly solution for your business network.
(1)
-100% Smart Dimmer

You can control any room's brightness and set the ambiance for any mood activity via the Kasa app.

Control Lights from Two Locations

The Smart Dimmer Switch 3-way gives you smart lighting control experience from two locations ideal for living room, halls and stairways.

Control It All, Your Way

Whether you use your preferred Smart Assistant or the Kasa App, you can control the Kasa Smart Dimmer Switch.

Custimized Switch Setting

Long press or double tap your Smart Dimmer to get the action you set.

Away Mode

Away Mode lets the KS230 Kit turn your devices off and on randomly to make it look like you're home, even when you're away.

Group Control

Combine your smart switch with other Kasa Smart devices for seamless control with a single tap on Kasa app.

Gentle Off

Use ""Gentle Off"" to fade lights as your child falls asleep. It's like making a personalized sunset for your child.

(1)
AC1200 Wi-Fi Router MU-MIMO Gigabit

Archer A6

Smooth Entertainment with AC1200 Dual Band Wi-Fi

The Archer A6 creates a reliable and blazing-fast network powered by 802.11ac Wi-Fi technology. The 2.4GHz band delivers speeds up to 300Mbps, ready for everyday tasks like emailing and web browsing, while the 5GHz band delivers speeds up to 867Mbps, ideal for HD video streaming and lag-free online gaming.

Advanced Security with WPA3

The latest Wi-Fi security protocol, WPA3, brings new capabilities to improve cybersecurity in personal networks. More secure encryption in Wi-Fi password safety and enhanced protection against brute-force attacks combine to safeguard your home Wi-Fi.

Boosted Wi-Fi Coverage Throughout Your Home

Four external antennas send Wi-Fi signals to every corner of your home. Stay connected and enjoy fast Wi-Fi whether you are lounging on the sofa or on the balcony. Beamforming technology detects devices, even if they are far-away or low-powered, and concentrates wireless signal strength towards them.

MU-MIMO Brings More Simultaneous Connections

MU-MIMO lets the Archer A6 serve multiple devices at once. No more bandwidth congestion or latency. All devices get their data faster and Wi-Fi is used more efficiently!

Traditional Router

Stream data to one device at a time

Archer A6

Stream data to multiple devices simultaneously

Gigabit Connectivity, 10Ã— Faster

With one Gigabit WAN port and four Gigabit LAN ports, speeds can be up to 10Ã— faster than standard Ethernet connections. Connect your favorite wired devices to Archer A6 and get impressed!

TP-Link OneMesh™: Flexibly Create a Whole-Home Wi-Fi

OneMesh™ is a simple way to form a Mesh network with a single Wi-Fi name for seamless whole-home coverage. Just connect a OneMeshTM range extender to a OneMesh™ router. No more searching around for a stable connection.
Wi-Fi Dead-Zone Killer
Eliminate weak signal areas with Wi-Fi coverage for the whole house
Smart Roaming
Uninterrupted streaming when moving around your home
One Wi-Fi Name
No more switching Wi-Fi network names
Unified Management
Manage the whole-home Wi-Fi by managing the central node via Tether app/Web UI

It's An Access Point, Too

Switch the working mode of the Archer A6 to Access Point Mode to share your wired network with other wireless devices.

Easy Setup and Management with the Tether APP

The free Tether app is available for both Android and iOS devices, making it easy to set up the Archer A6 and manage your network settings.
(1)
AC1200

Wireless Dual Band PCI Express Adapter

Archer T4E

802.11ac - Dual Band Wi-Fi for Faster Connections

TP-LINK's Archer T4E supports the advanced Wi-Fi standard of IEEE 802.11ac, offering 3 times transferring rates as IEEE 802.11n. You can send emails and browse the web with 2.4GHz network, while keeping the speedy 5GHz band free for gaming, HD streaming and other bandwidth intensive applications.

Greater Coverage with Beamforming

Beamforming technology smartly focuses Wi-Fi signals towards connected devices for stable connections and boosted range.

Heat Sink for Ultimate Stability

A heat sink helps to dissipate the thermal energy generated by the adapter, which in turn improves stability. Additionally, lower temperatures help to extend the product lifespan.

External Antennas for More Targeted signal

Two external antennas utilize the latest wireless technology to achieve stable connections and boosted coverage.

Easy Setup

Simple software installation with the intuitive Utility on the provided CD

Advanced Security

WAP,WPA/WPA2,WPA-PSK/WPA2-PSK encryption standards ensure your data is safe from intruders

Operating System

Supports Windows 10/8.1/8/7/XP(32/64 bit)

Low-Profile Bracket

In addition to the standard bracket, a low-profile bracket is also provided for mini tower computer cases
(1)
Advanced Sensing
- Motion and ambient lighting detection ensure your lights only turn on at night.
Smart Control
- Set different light triggers and brightness levels based on your routine for effortless control.
Customized Dimming
- Experience a full range of brightness before fading them off for bedtime.
Energy Saving
- Turn off the light automatically after you leave the room for a set time.
Scheduling
- Set lights to automatically turn on and off throughout the day or night whether you're home or away.
Hands-free Voice Control
- Set lighting levels using the leading voice assistants such as Amazon Alexa and Google Assistant.
Works With Smartthings
- Control and manage your Kasa devices with SmartThings.
Upgrade Your Light Switch
- Designed to easily replace traditional light switches (single-pole only).
Guide Installation
- Kasa Smart app provides step-by-step instructions for wiring your new Smart Dimmer Switch.
Smart night light hidden in plain sight

Stay steady at night with the motion-activated sensors picking up ambient light and movement.

Your Ambiance, Your Way

Make the vibe as dim or as bright as you want, whether it is via the Kasa Smart app or the Kasa Smart Light Switch.

Your Control, Your Way

Control the Kasa Smart Light Switch using the Kasa Smart App, your preferred smart assistant or the pleasing tactile controls.

Smart Control

Set different light triggers based on your daily routine. Create smart modes that match your life with an easy-to-use app.

Intelligent Green Energy Solution

Save money and the environment by keeping the lights on only when they are needed. The Kasa Smart Light Switch works with in-built motion and ambient light sensors to ensure that light is only on when it is needed.

Fade on and off

Set up this function to fade off your lights.

Perfect for slowly dimming the lights as your child drift to sleep.

Designed for Safety

This switch is UL Certified. UL94-V0 PC flame-retardant materials help minimize burning hazards.

Group

Combine your smart switch with other Kasa Smart devices for seamless control with a single tap on Kasa app.

Schedules

Easily create an automatic schedule for your appliances any day of the week following your daily routine.

Timer

Set a timer to turn off your connected device automatically as needed.
(1)
Boost Whole Home WiFi with Your Existing Router

A single router has limited WiFi coverage and always causes WiFi dead zones. RE315 wirelessly connects to your existing router and expands its WiFi signal into areas it can't reach on its own. Enjoy your stable network experience wherever you are at home.

WiFi keeps Strongest for Unlimited Moving

With TP-Link Mesh Technology, it's easy to form a Mesh network with a single WiFi name for seamless whole home coverage. Just connect RE315 to a OneMesh^TM router. Always enjoy the strongest WiFi when you're walking around with no need to search around for a stable connection.

Smart Roaming

Uninterrupted streaming when moving around your home

One WiFi Name

No more switching WiFi network names

Easy Creation

OneMesh™ Router + OneMesh™ Range Extender

Unified Management

Manage the whole unified network all in one Tether app

Enjoy a Mesh Network with Your Existing Router

Want a Mesh network? Hesitate on whether to replace your existing router and buy a Mesh set?
TP-Link OneMesh™ resolves your dilemma.

Faster Dual Band WiFi up to 1200 Mbps

RE315 delivers dual band (2.4 GHz and 5 GHz) to transmit WiFi signals, doubling the performance of each band. It enables you to keep more devices connected at the same time with its 300 Mbps 2.4 GHz and 867 Mbps 5 GHz dual bands. Use the 2.4 GHz band to send email and browse the web and the 5 GHz band for gaming and HD streaming.

Adaptive Path Selection: Keeps Itself Working at Top Speed

Adaptive Path Selection keeps your network running at optimal speeds by automatically choosing the fastest connection path to the router. Always keep your devices fast and stable-ideal for network environments crowded with many devices and applications.

High Speed Mode: Maximized Speed with Dedicated Backhaul

Uses one dedicated WiFi band as backhaul and another dedicated WiFi band as an access point to maximize the bandwidth on the extended WiFi.

Built-In Access Point Mode

RE315 is more than a wireless range extender. Simply plug an Ethernet cable into its Ethernet port and easily turn your wired internet connection into a 2Ã—2 MIMO dual band wireless access point.

Secure One-Touch Connection for Easy Setup

Step 1: Simply press the WPS button on your router and, within 2 minutes, the WPS button on RE315 will connect to the network.
Step 2: Once connected, place RE315 at the best location-without reconfiguration.

Find the Best Location with the Smart Signal Indicator

The smart signal indicator lets you see signal strength from the existing router at a glance. Easily to find the best place to position your range extender to extend your WiFi.

Control at Your Fingertips

Set up and manage your WiFi through the TP-Link Tether app from your smartphone (Android, iOS), including TP-Link routers and range extenders.
(1)
Boost Your Wi-Fi to hard-to-reach Areas

Place the RE220 between your wireless router and wireless devices, expanding Wi-Fi coverage while eliminating Wi-Fi dead zones. The dual-band Wi-Fi up to 750 Mbps can not only extend to 32,00 sq. ft. (300m²) with the router, but also make good use of your high ISP speed , ideal for HD video streaming, online gaming and other bandwidth-intensive tasks.

Stable Dual Band Connection for More Devices

The RE220's Wireless AC technology creates faster and stronger Wi-Fi connections across your home and extends dual band Wi-Fi up to 750 Mbps. Dual 2.4 GHz and 5 GHz bands provide Wi-Fi connections to up to 32 devices, allowing you to enjoy stable and drop-free experience on all your devices.

Simple Two-Step Setup

Step 1: Press the WPS button on the router and RE220 to easily connect the extender to the network. Or connect the
extender via Tether app or Web UI if your router doesn't support WPS.

Step 2: Relocate the extender to a better location for optimal Wi-Fi coverage with the help of the smart signal indicator light.

An Access Point as well as a Wireless Adapter

The Ethernet port of RE220 can easily turn your wired Internet connection into a wireless access point. And it can also function as a wireless adapter to connect wired devices.

High Speed Mode for Maximized Performance

High Speed Mode uses one dedicated Wi-Fi band as backhaul and another dedicated Wi-Fi band as an access point to maximize the bandwidth on extender Wi-Fi.

Universal Compatibility

The RE220 is compatible with any of your existing Wi-Fi router or access point, making it easy to expand and strengthen your Wi-Fi network.

Smart Management by Tether App

Set up and manage your Wi-Fi through the TP-Link Tether app on you smartphone (Android, iOS).
(1)
Control from Anywhere

Control anything a standard light switch controls, like lights, ceiling fans and other fixtures, from anywhere using the Kasa Smart app. Turn fixtures on and off, set schedules, even group them with other Kasa Smart devices.

Easy Install

No need to understand complex wiring, just follow the step-by-step wiring process in the Kasa Smart app for a guided installation. Your Kasa Smart Wi-Fi Light Switch comes with labels, a faceplate and the necessary hardware for your convenience.

INSTALL TUTORIAL

Your Voice Has Power

Use simple voice commands to control all of your Kasa Smart light switches or light bulbs with any Alexa or Google Assistant smart speaker. Turn on kitchen lights when your hands are full, let your voice assistant know to dim your lights, even turn off hallway lights as you're walking to bed.

A Single Tap Is All It Takes

Use the Grouping feature on the Kasa Smart app to combine your devices together for unified control with one single tap on your smartphone. Combine your living room bulbs, plugs and light switches together for an easier way to turn them on when you get home.
(1)
Easy Wi-Fi Extension Flexible Placement

300Mbps Universal Wi-Fi Range Extender TL-WA850RE

Boost Your Wireless Network

Tired of Wi-Fi ''dead zone''? TP-LINK's range extender connects to your router wirelessly, strengthening and expanding its signal into areas it can't on its own. The device also reduces signal interference to ensure reliable Wi-Fi coverage throughout your home or office.
- Router's Wireless Range
- Extended Wireless Range
- Worked as a Wireless Network Adapter
- Boost Your Wireless Network
Easy Setup and Flexible Placement

Press the WPS button on your router and the Range Extender button on your 850RE within minutes to easily connect to the network. Once connected with an existing router, you can simply unplug and plug the TL-WA850RE back in a location for the best signal quality and coverage in your house, without needing to configure the extender again.

Ethernet Bridge

The TL-WA850RE's single Ethernet port allows the Extender to function as a wireless adapter to connect wired devices like Blu-ray® players, gaming consoles, DVRs and Internet TVs. At the same time, the device can share the wireless network as well.

Smart Signal Indicator Light

5 signal lights show the strength of signal that TL-WA850RE receives from the existing router, which can help to find the right location to place the range extender.
- It's recommended that you choose a location where at least 3 signal light blue in order to guarantee a good performance.
Tether App for Easy Use

Use any mobile device to easily access and manage various features, including the LED Control function's Night Mode, which allows you to enjoy a more peaceful night's sleep.
(1)
Expand Dual Band WiFi Everywhere (1)
FEATURES (1)
Fast Wi-Fi Travels with You!

AC750 Wireless Travel Router

TL-WR902AC

Portable and compact

The incredibly compact TL-WR902AC is the world's first AC750 travel router. Take it with you to create a personal Wi-Fi spot anywhere internet is available. It fits easily in your pocket, purse or bag and is perfect for use while traveling. Watch movies over private dual-band Wi-Fi at a hotel.

Dual-Band AC for Fast Wi-Fi Speeds

The travel router creates fast AC750 Wi-Fi over dual 2.4 GHz (300 Mbps) and 5 GHz (433 Mbps) bands. Dual bands allow for more devices to be connected to your personal network and provide reliable Wi-Fi access so you can enjoy what you love without interruptions.

Multiple Wi-Fi Modes for Any Situation

Whether you need a private Wi-Fi network while away or something to boost your Wi-Fi at home, the TL-WR902AC has a mode for you.

Multifunctional USB Port for File Sharing and Charging

A The travel router comes with a built-in USB 2.0 sharing port. Connect a USB storage drive to share access to files, download movies and back up recent photos. Connect your smartphone cable and the router doubles as a 5V/1A charging station for one device.
(1)
Find Wired and Wireless Network from Any Outlet with Your Home's Electrical System

300Mbps AV600 Powerline Wi-Fi Extender

Extend Your Network to Any Room Using Existing Powerline

The TL-WPA4220 transforms your home's existing electrical circuit into a high-speed network with no need for new wires or drilling. With advanced HomePlug AV2, TL-WPA4220, an add-on unit, is perfect for further extending the existing powerline network, providing stable and high-speed data transfer rates of up to 600 Mbps on a line length of up to 300 meters and bringing wired and wireless network simultaneously to anywhere there is a power outlet.

Plug & Play, No Configuration Required

Plug the powerline adapter in the wall and connect it to the router with an Ethernet cable. Then plug the TL-WPA4220 in any desired power outlet. There you go! No configuration is required. Just enjoy the seamless, high speed wired and wireless network.

Pair for More Security

Press the ""Pair"" button on both adapters to create a more secure network.

Wi-Fi Auto-Sync for Unified Wi-Fi Network

Pressing the Wi-Fi Clone button instantly copies your network name and password from your router for easy setup. Wi-Fi Move automatically applies any settings changes across the network. Your existing Wi-Fi settings will be synchronized to the new extender automatically.

Two Fast Ethernet Ports for Wired Connections

With two fast Ethernet ports, the TL-WPA4220 can run multiple high-speed and reliable wired connections at the same time for devices like smart TVs, PCs, and game consoles. One Ethernet cable is included in the box.
(1)
Increase the Number of Available Ports

The UH720 is perfect for anyone who has a computer with only one or two USB ports, and wants easier access to additional ports without having to switch between devices.

10x Data Transfer Speed

Equipped with USB 3.0 ports, the UH720 can transfer a 1080p movie under 2 minutes 18 seconds, whereas it takes 7 minutes 36 seconds with an USB Hub equipped with USB 2.0 ports.

Extra 2 Charging Ports for All Your Devices

Extra 2 USB ports supporting 2.4A outputs are specifically designed for ultra fast charging. It charges most USB-charged devices, no matter devices with large battery like tablets and smartphones, or gadgets with tiny battery like smart wearable devices, at full speed.

Exclusive TP-LINK Smart Charging Technology Invented to Charge Fast

TP-LINK Smart Charging technology intelligently identifies the connected devices and automatically delivers the fastest possible charge to your smartphones, tablets or other USB-charged devices to minimize the charging time.

Protect Both Your Devices and Precious Data

UH720 has a sophisticated circuit design with multiple protections for your devices against over-heating, over-current, over-voltage and short circuit. A built-in surge protector keeps both your devices and data safe in the process of transferring data. UH720 support USB ports hot swapping that can be safely connected and disconnected while the computer is powered on and running.

Considerate Design

A dim white LED indicator on the power button helps visulaize the connection status and similarly 7 dim white LED indicators beyond each USB port also indicate whether the devices are properly connected.

(1)
Mini Size, Big performance

AC1300 Mini Wireless MU-MIMO USB Adapter

Archer T3U

High-Speed Dual Band Adapter for Better Connections

Wireless AC technology means Archer T3U delivers connections that are up to 3x faster than with the previous Wireless N standard. High-speed WiFi (up to 867 Mbps over the 5 GHz band and 400 Mbps over the 2.4 GHz band) means Archer T3U is able to support all your online activities, from HD video streaming to lag-free online gaming and web surfing.

Miniature Design - Take With You On the Go

Archer T3U has a smart design that is tinier than most USB adapters. Not only can it be inserted into any USB port but is also easy to carry.

USB 3.0 for Superior Transfer Speeds

Experience blazing-fast data transfers of up to 4.8 Gbps with USB 3.0 - the latest USB connectivity standard. USB 3.0 transfers data up to 10x faster than USB 2.0 and is also backwards compatible with USB 2.0. Combined with 802.11ac Wi-Fi, USB 3.0 makes Archer T3U ideal for HD streaming, online gaming and large file downloads.
Boosted Throughput with MU-MIMO

With MU-MIMO technology, Archer T3U can provide two simultaneous data streams, improving the throughput and efficiency of the entire network when working with a compatible MU-MIMO router.

Easy Setup

A friendly user interface comes on a CD for simple installation.

Advanced Security

WPA/WPA2 encryption standards ensure your wireless connections safety.

Operating System

Supports Windows, Mac OS

(1)
Motion Detection

Receive a notification whenever your camera detects motion and see a video clip of the motion for closer inspection.Also, you can personalize your own experiences by setting the motion detection zones to only capture what happens in the area that you choose.

Night Vision

Don't wake up your little ones when you crack open their doors to check on them. Watch over them from your phone with 30 ft of night vision. You'll have peace of mind, and they'll have a good night's sleep.

High-Definition Video

1080p definition video provides more clarity and sharpness in pictures
due to a higher number of pixels.
This helps with identification and recognition from far away.

Two-Way Audio

Communicate with a loved one through the built-in microphone and speaker.

Protect Your Privacy

Your privacy is ensured with privacy mode and a local storage card.

Alarm System

Not only will the camera send notifications to you when motion is detected, it'll also trigger lights and sounds as an alarm.

Share Memorable Moments

Save the most unforgettable moments and share them with your loved ones. Tapo cameras are always there to help you record every memorable moment.

(1)
Weather-resistant

The IP64 rating and weather-resistant cover ensure protection against dust intrusion and splashes of water.

Cover the socket with the weatherproof cover when not in use.

Voice Control

Use simple voice commands with Alexa or Google Assistant to control your connected devices.

Set Schedules

Switch your outdoor lighting on and off automatically to save energy and effort.

Full-range Brightness

Adjust the brightness of connected lights outdoors to set the perfect ambiance for any activity.

Control From Anywhere

Turn your connected device on and off from anywhere using the Kasa Smart app.

No Hub Required

Works with a secured 2.4 GHz wireless network without needing a hub or a separate device.

Make Your Light Dimmable

Freely adjust the brightness of connected lights outdoors with Kasa Smart App or Smart assistants. Set the ambiance for any mood or activity as you want.

Made for Outdoor

The Kasa Smart Outdoor Plug-in Dimmer is made for outdoor. Its materials ensure that it is suitable for outdoor use.

300 ft Long Range WiFi

Enjoy one of the strongest WiFi signals with the Kasa Smart WiFi Outdoor Plug-in Dimmer. Up to 300 ft coverage means there won't be any dead spots anywhere in your backyard.

Schedule

Schedule your Plug-in Dimmers to turn on/off automatically at specified times or according to Sunrise/Sunset.

Grouping & Scenes

Group your Plug -in Dimmer with other Kasa devices to turn then all on and off with one click or choose a custom preset with.

Away Mode

Away Mode will automatically turn on and off your connected devices, like lights, to make it appear as if you're home.

Countdown Timer

Away Set a timer for your Plug-in Dimmers to automatically turn off when the time runs out.
(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

TL-SG1005P is a 5 10/100/1000Mbps 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-SG1005P has the priority function which will help protect the system when the system power is overloaded. If all PoE PDs power consumption is >= 56W, 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 56W. 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 10W, 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 10W, no power will be supplied to Port 4.

Easy To Use

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

(1)
LED A19 bulb with a frosted finish features an energy-efficient design to use nearly 85 percent less electricity while providing 800 lumens of warm white light. Solid-State LED lighting offers a 220-degree beam spread to efficiently illuminate your space. Nondimmable, long-life bulb is approved for use in enclosed fixtures and provides up to 15,000 hours of light. 120-volt, 9.5-watt bulb also features a 2,700 Kelvin temperature, 80 CRI and medium base.
(1)
Privacy filter keeps confidential information private. Only persons directly in front of the monitor can see the image on screen while others on either side of them see a darkened screen. It is great for high-traffic areas such as airports, airplanes, commuter trains, coffee shops and other public places. Filter is designed to fit wide-screen laptops. Filter includes your choice of two easy attachment methods. Reversible, matte side reduces glare and reflections. Lightweight, thin, frameless design protects display from dirt, debris and scratches. Clean easily with a soft cloth and water.
(1)
TL-SF1008P is an 8 10/100M 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. TL-SF1008P has the priority function which will help protect the system by cutting off the power of the lowest-priority port when the system power is overloaded.
(1)
TL-SF1016D Fast Ethernet Switch provides 16 10/100Mbps Auto-Negotiation RJ45 ports. All ports support Auto MDI/MDIX function, eliminating the need for crossover cables or Uplink ports. The Switch is Plug-and-Play and each port can be used as general ports or Uplink ports and can be simply plugged into a server.
(1)
The Club 3D CAC-1333 is a HDMI™ to USB-C Adapter which allows you to transmit signal from HDMI™ source (Laptop, tablet, PC etc.) to USB-C display devices(TV, monitor, projector, etc.) through a Type-C M/M Cable. This adapter is Uni-Directional it only works from an HDMI™ Source device to an USB C DP™ 1.2 Alternate mode supported display. This product supports DP™1.2 specification with resolution up to 4096 x 2160@60Hz.
(1)
The HDMM12 High Speed HDMI® cable (12 ft) features 2 gold-plated HDMI (male) connectors and durable high quality construction to provide a dependable HDMI to HDMI connection between devices such as Blu-Ray Disc™ players, HDTVs, DVD Players, stereo receivers, projectors and more.

This high quality HDMI cable fully supports 1080p+ resolutions at up to 120Hz refresh rate, with life-like color. To accommodate the demands of future high definition devices, such as increased resolutions and higher frame rates, this Ultra HD cable supports resolutions up to 4k x 2k.

This HDMI cable comes in a non-standard 12 foot cable length, allowing you to position your HDMI-enabled devices as needed and is backed by StarTech.com's Lifetime Warranty for guaranteed reliability.

About StarTech.com HDMI to HDMI Cables:

StarTech.com High Speed HDMI digital video and audio cables are expertly designed and constructed of only top quality materials to ensure high quality, high definition performance. The HDMI standard combines high bandwidth video and multi-channel digital audio into a single cable, and provides crystal clear image resolution.

(1)
The MC220L is a media converter designed to convert 1000BASE-SX/LX/LH fiber to 1000Base-T copper media or vice versa. Designed under IEEE802.3ab 1000Base-T and IEEE802.3z 1000Base-SX/LX/LH standards, the MC220L is designed for use with multi-mode/single-mode fiber cable utilizing the SC/LC-Type connector. It works at 850nm on both transmitting and receiving data when adopting multi-mode fiber and 1310nm on both transmitting and receiving data when adopting single-mode.
(1)
The PoE Injector TL-POE150S fully complies with IEEE 802.3af standard, and can work with all IEEE 802.3af PoE compliant PDs (Powered Devices) or PoE Receiver Adapters, such as TP-LINK's TL-POE10R, or other equivalent product, to expand your network to where there are no power line or outlet, where you wish to fix device such as AP, IP Camera or IP Phone, etc.
(1)
The PoE+ Injector TL-POE160S fully complies with IEEE 802.3af/at standards, and can work with all IEEE 802.3af/at PoE compliant PDs (Powered Devices) or PoE Receiver Adapters, such as TP-Link's TL-POE10R, or other equivalent product, to expand your network to where there are no power line or outlet, where you wish to fix device such as AP, IP Camera or IP Phone, etc.

(1)
The TL-SG1008D 8-port Gigabit Ethernet Switch provides you with a high-performance, low-cost, easy-to-use, seamless and standard upgrade to improve old network to 1000Mbps network. Increase the speed of your network server and backbone connections, or make Gigabit to the desktop a reality.

(1)
The TP-LINK 8 10/100/1000Mbps Desktop Switch TL-SG108 provides you an easy way to make the transition to gigabit Ethernet. Increase the speed of your network server and backbone connections, or make gigabit to the desktop a reality. Moreover, TL-SG108 adopts lower power consumption design. With the innovative energy-efficient technology, the TL-SG108 can save up to 72% of the power consumption, making it an eco-friendly solution for your home or office network.
Gigabit Switch
Featured with 8 10/100/1000Mbps ports, TL-SG108 greatly expands your network capacity, enabling instant large files transferring. So?power users in the home, office, workgroup, or creative production environment can now move large, bandwidth-intensive files faster. Transfer graphics, CGI, CAD, or multimedia files across the network instantly.
(1)
The Targus Numeric Keypad allows users to type numbers into spreadsheets and other applications quickly and easily. The full-size 19mm keys improve speed and accuracy by making it easier to locate and press the numbers you are looking for. The integrated ergonomic tilt provides added comfort which helps reduce strain after a long work day. The USB cord is 3 feet long to provide additional flexibility in the workspace. Ideal for in office or in home use.

(1)
The Targus Wireless Numeric Keypad allows users to type numbers into spreadsheets and other applications quickly and easily. The full-size 19mm keys improve speed and accuracy by making it easier to locate and press the numbers you are looking for. The integrated ergonomic tilt provides added comfort which helps reduce strain after a long work day.

(1)
The USBLT1MW 1m White Lightning to USB Cable for iPhone, iPod, and iPad provides a reliable solution for charging and syncing your newer generation Apple® mobile devices with your PC or Mac® computer, through an available USB port.

Plus, the reversible 8-pin Lightning connector can be plugged into your iOS-enabled device with either side facing up, meaning there is no wrong way of inserting the cable into the device.

This durable cable is Apple MFi certified and backed by StarTech.com's 2-year Warranty to ensure dependable performance.

(1)
This 6.5-foot (2M) DisplayPort™ to HDMI® adapter cable lets you connect your DisplayPort equipped Ultrabook™; laptop or desktop computer to an HDMI display or projector with no additional adapters or cables required. The passive adapter supports video resolutions up to Ultra HD 4K.

Astonishing picture quality

This adapter cable ensures you can maintain an astonishing picture quality, four times the resolution of 1080p, when converting DisplayPort to HDMI. The adapter is also backward compatible with lower resolution displays and video sources. With support for high-definition resolutions of 1080p and 720p, you can future-proof your existing setup for 4K video.

Hassle-free setup

For the simplest and most discreet installation, this DP to HDMI adapter connects directly from your DisplayPort video source to the HDMI port on your display. It doesn't need a power source, unlike some converter dongles that require active power and separate bulky video cabling.

Clutter-free installation

At 6.5ft (2m) in length, this adapter cable delivers a compact connection that eliminates excess to ensure a tidy, professional installation. For shorter installations, we also offer a 3 ft DP to HDMI cable (DP2HDMM1MB), enabling you to choose the right cable length for your custom installation needs.

The DP2HDMM2MB is backed by a 3-year StarTech.com warranty and free lifetime technical support.

(1)
This DisplayPort 1.4 cable connects your DisplayPort™ laptop or desktop computer to an ultra-high definition 8K monitor, TV or projector. It supports resolutions up to 8K (7680 x 4320) at 60Hz.

The DisplayPort monitor cable provides the essential connection to support the next generation of ultra-high definition video.

This cable is VESA® to ensure full compliance and efficient operation of the higher link rate of HBR3. It has been tested to meet all DP 1.4 specifications to ensure quality and reliability.

The Superior Performance of DisplayPort 1.4

This 8K DisplayPort cable supports all DP 1.4 features:

High Bit Rate 3 (HBR3) Bandwidths of 32.4 Gbps supporting the latest in industry standards

High Dynamic Range (HDR10) for higher contrast ratio and vivid colors

Multi-Stream Transport (MST) for daisy-chaining multiple monitors

Display Stream Compression 1.2 (DSC) for maximum resolution output

Forward Error Correction to manage data transmission errors

High-Bandwidth Digital Content Protection (HDCP 2.2) for a secure connection between source and display

32 Uncompressed Digital Audio Channels

Cable Key Features

Aluminum-mylar foil with braided shielding improve EMI protection
Long lasting flexible TPE jacket & strain relief (TPE is non-toxic & halogen free for environmental sustainability)

Connector Key Features

Die-cast aluminium sub-structure shielding improves signal integrity & prevents signal degradation
Corrosion-free gold-plated connectors ensure premium video quality & enhanced reliability
Tested to withstand 10,000+ insertions

8K: Enabling Business Continuity

8K has a resolution of 7680 x 4320 and is also known as 4320p and Ultra High Definition (UHD). Suitable for digital signage and other commercial displays that require the highest available resolution. This cable is backward compatible with 4K and 5K displays making it the perfect peripheral to start futureproofing your cabling infrastructure.

Comprehensive Product Testing & Expert Technical Support

StarTech.com conducts thorough compatibility and performance testing on all our products to ensure we are meeting or exceeding industry standards and providing high-quality products to our customers. Our local StarTech.com Technical Advisors have a broad product expertise and work directly with StarTech.com Engineers to provide support for our customers both pre and post-sales.

DP14VMM3M is backed by a StarTech.com lifetime warranty.

(1)
This DisplayPort 1.4 cable connects your DisplayPort™ laptop or desktop computer to an ultra-high definition 8K monitor, TV or projector. It supports resolutions up to 8K (7680 x 4320) at 60Hz.

The DisplayPort monitor cable provides the essential connection to support the next generation of ultra-high definition video.

This cable is VESA® to ensure full compliance and efficient operation of the higher link rate of HBR3. It has been tested to meet all DP 1.4 specifications to ensure quality and reliability.

The Superior Performance of DisplayPort 1.4

This 8K DisplayPort cable supports all DP 1.4 features:

High Bit Rate 3 (HBR3) Bandwidths of 32.4 Gbps supporting the latest in industry standards

High Dynamic Range (HDR10) for higher contrast ratio and vivid colors

Multi-Stream Transport (MST) for daisy-chaining multiple monitors

Display Stream Compression 1.2 (DSC) for maximum resolution output

Forward Error Correction to manage data transmission errors

High-Bandwidth Digital Content Protection (HDCP 2.2) for a secure connection between source and display

32 Uncompressed Digital Audio Channels

Cable Key Features

Aluminum-mylar foil with braided shielding improve EMI protection
Long lasting flexible TPE jacket & strain relief (TPE is non-toxic & halogen free for environmental sustainability)

Connector Key Features

Die-cast aluminium sub-structure shielding improves signal integrity & prevents signal degradation
Corrosion-free gold-plated connectors ensure premium video quality & enhanced reliability
Tested to withstand 5000+ insertions

8K: Enabling Business Continuity

8K has a resolution of 7680 x 4320 and is also known as 4320p and Ultra High Definition (UHD). Suitable for digital signage and other commercial displays that require the highest available resolution. This cable is backward compatible with 4K and 5K displays making it the perfect peripheral to start futureproofing your cabling infrastructure.

Comprehensive Product Testing & Expert Technical Support

StarTech.com conducts thorough compatibility and performance testing on all our products to ensure we are meeting or exceeding industry standards and providing high-quality products to our customers. Our local StarTech.com Technical Advisors have a broad product expertise and work directly with StarTech.com Engineers to provide support for our customers both pre and post-sales.

DP14VMM2M is backed by a StarTech.com lifetime warranty.

(1)
This DisplayPort 1.4 cable connects your DisplayPort™ laptop or desktop computer to an ultra-high definition 8K monitor, TV or projector. It supports resolutions up to 8K (7680 x 4320) at 60Hz.

The DisplayPort monitor cable provides the essential connection to support the next generation of ultra-high definition video.

This cable is VESA® to ensure full compliance and efficient operation of the higher link rate of HBR3. It has been tested to meet all DP 1.4 specifications to ensure quality and reliability.

The Superior Performance of DisplayPort 1.4

This 8K DisplayPort cable supports all DP 1.4 features:

High Bit Rate 3 (HBR3) Bandwidths of 32.4 Gbps supporting the latest in industry standards

High Dynamic Range (HDR10) for higher contrast ratio and vivid colors

Multi-Stream Transport (MST) for daisy-chaining multiple monitors

Display Stream Compression 1.2 (DSC) for maximum resolution output

Forward Error Correction to manage data transmission errors

High-Bandwidth Digital Content Protection (HDCP 2.2) for a secure connection between source and display

32 Uncompressed Digital Audio Channels

Cable Key Features

Aluminum-mylar foil with braided shielding improve EMI protection
Long lasting flexible TPE jacket & strain relief (TPE is non-toxic & halogen free for environmental sustainability)

Connector Key Features

Die-cast aluminium sub-structure shielding improves signal integrity & prevents signal degradation
Corrosion-free gold-plated connectors ensure premium video quality & enhanced reliability
Tested to withstand 5000+ insertions

8K: Enabling Business Continuity

8K has a resolution of 7680 x 4320 and is also known as 4320p and Ultra High Definition (UHD). Suitable for digital signage and other commercial displays that require the highest available resolution. This cable is backward compatible with 4K and 5K displays making it the perfect peripheral to start futureproofing your cabling infrastructure.

Comprehensive Product Testing & Expert Technical Support

StarTech.com conducts thorough compatibility and performance testing on all our products to ensure we are meeting or exceeding industry standards and providing high-quality products to our customers. Our local StarTech.com Technical Advisors have a broad product expertise and work directly with StarTech.com Engineers to provide support for our customers both pre and post-sales.

DP14VMMV1M is backed by a StarTech.com lifetime warranty.

(1)
This USB-C™ to USB-C cable lets you charge and sync your USB Type-C™ devices. It's also compatible with Thunderbolt™ 3 ports.

Charge andsync your mobile devices
Connect your newer USB-C mobile devices, such as theSamsung Galaxy S8, S8+, Nexus™ 6P, and 5X phones, to your computer. The cable delivers up to a 3 amp charge, and supports data transfer speeds of up to 480Mbps.

Power your laptop
With up to 3A of power output, this USB Type-C cable can also be used to power a USB-C laptop, such as your Apple MacBook or Chromebook Pixel™.Simply connect your laptop to your USB-C wall charger.

Keep the cable as a spare while you're traveling
Replace the cable that came with your device, or keep one as a spare while you're traveling, so that all of your devices will be ready to use whenever you need them while you're on the road.

Bridge the generation gap
The USB Type-C connector is smaller and easier to use than previous USB connectors. With a reversible design, you can plug it into your devices with either side facing up. Insert the cable the right way every time - no more frustration orport damage.

Provide superior connections with USB-IF certified cables
This USB-C cable has been certified with USB-IF (USB Implementers Forum) in order to meet all USB 2.0 specifications. This includes all environmental, electrical and mechanical standards set by USB compliance. This ensures a high-quality, reliable cable for all your USB-C devices.

The USB2CC1Mfrom StarTech.com is backed by a lifetime warranty for guaranteed reliability.
(1)
Verbatim's Vi550 SATA III 2.5"" Internal SSDs are an ideal choice for transforming the performance of any hard drive-based PC or laptop computer. Featuring the SATA III interface, the Vi550 Internal SSDs boast transfer speeds of up to 520 MB/s read and up to 460 MB/s write. Sequential transfer speeds based on internal testing using ATTO benchmark. Actual performance may vary depending on host computer environment and use conditions. Transfer speeds are capacity dependent - see spec sheet for additional details. With transfer speeds far superior to mechanical hard drives, get ready to experience decreased system boot time, more efficient multi-tasking, and faster system responsiveness. These SSDs utilize cutting-edge 3D NAND flash technology to deliver lightning-fast and reliable SSD performance. Backed by Verbatim's 2-year limited warranty, the Vi550 SATA III 2.5"" Internal SSDs are an ideal choice for upgrading your hard drive-based system.

(1)
Charge your tablet and your phone simultaneously, almost anywhere around the world. Planning an international business trip or vacation? Now you can keep your mobile devices charged while you're away, without having to worry about whether or not the adapter you use at home will work overseas. The versatile travel charger ships with interchangeable power plugs that let you plug in and charge your devices nearly anywhere you go around the world.

Plus, you can charge two of your devices at the same time. This dual-port USB wall charger lets you charge two mobile devices at once, using a single USB wall charger, so you won't have to wait until one of your devices is fully charged before charging another.

International travel - universal power adapter

The wall charger includes a universal power adapter, which lets you plug in to any electrical socket almost anywhere in the world. So, no matter where you are travelling to, you can rest assured that you'll be able to keep your mobile devices charged and ready to use.

Simultaneous charging - dual USB charge ports

With one 1A port for charging your smartphone or iPhone, and a 2.4A port for charging your iPad or other tablet, you'll always have the necessary charging power for your mobile devices. Whether you're charging two phones at the same time or charging a phone and a tablet, you can ensure all of your mobile devices are ready when you need them.

Compact and lightweight - portable design

The portable USB wall charger features a folding North American plug that tucks away nicely to fit inside your laptop bag, purse, backpack or other carrying case, making it the perfect mobile accessory for any carry-on. Plus, you can easily throw in the correct international plug for your destination and you're all set to go.

Once you land you can swap out the plugs and be ready to charge in the airport, in your hotel room or just about anywhere you can find a wall outlet.

The USB2PACWH is backed by our 2-year warranty to ensure dependable performance.

Note: Some mobile devices such as certain Samsung and BlackBerry devices use proprietary power connections which are not compatible with aftermarket chargers. Please consult the manufacturer's documentation to ensure compatibility with the USB2PACWH.
(1)
The Club 3D USB 3.2 Gen1 Type A to RJ45 2.5Gbps Ethernet Adapter. It enables a Fast Ethernet network connection capability for desktops , notebooks or ultrabooks with a standard USB 3.2 Gen 1 Type A port.

This adapter is the best solution for latest devices without an onboard Ethernet port.

Designed with the highest quality casing with smooth finish is the perfect accessory for your travels in addition its USB powered so no need for external power adapter. (1)

Product Model

933XL (3)
CyberTrack H4 (3)
A6 (1)
AKP10US (1)
C100 (1)
CAC-1420 (1)
KP405 (1)
MC220L (1)
PF12.5W9 (1)
RE215 (1)
RE220 (1)
RE305 (1)
RE315 (1)
T3U (1)
T4E (1)
TL-POE150S (1)
TL-SF1005P (1)
TL-SF1008P (1)
TL-SF1016D (1)
TL-SG1005P (1)
TL-SG1008D (1)
TL-SG105E (1)
TL-SG108 (1)
TL-SG108E (1)
TL-WA850RE (1)
TL-WPA4220 (1)
TL-WR902AC (1)
UH720 (1)
Vi550 S3 (1)

Package Contents

1 Ã— WiFi Light Bulb, Multicolor

1 Ã— Quick Start Guide

(2)

1 x Wi-Fi Light Switch

1 x Face Plate

4 x Wire Nuts

1 x Quick Start Guide

(1)

1Ã— Smart Wi-Fi Dimmer Switch

1 Ã— Satellite Dimmer Switch

2 Ã— Wall Plates

3 Ã— Wire Nuts

4 Ã— Screws

Wire Labels

Quick Start Guide

(1)

256GB Vi550 SATA III 2.5"" Internal SSD

Quick Installation Guide

(1)

300Mbps AV500 WiFi Powerline Extender

1 x Ethernet Cable

Quick Installation Guide

(1)

300Mbps Universal Wireless N Range Extender TL-WA850RE

RJ-45 Ethernet Cable

Resource CD

Quick Installation Guide

(1)

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

Power Adapter

User Guide

(1)

5-Port Gigabit Desktop Switch with 4-Port PoE+

Power Adapter

Installation Guide

(1)

5-Port Gigabit Easy Smart Switch

Power Adapter

Installation Guide

Rubber Feet

(1)

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

Power Adapter

Installation Guide

(1)

8-Port Gigabit Easy Smart Switch

Power Adapter

Installation Guide

Rubber Feet

(1)

AC1200 Mesh Wi-Fi Range Extender

Quick Installation Guide

(1)

AC1200 Wi-Fi Range Extender

Quick Installation Guide

(1)

AC1200 Wireless Dual Band PCI Express Adapter

Low-Profile Bracket

Quick Installation Guide

Resource CD

(1)

AC1200 Wireless MU-MIMO Gigabit Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

AC1300 Mini Wireless MU-MIMO USB Adapter

Quick Installation Guide

Resource CD

(1)

AC750 Mesh Wi-Fi Dual Band Range Extender

Quick Installation Guide

(1)

AC750 Wi-Fi Range Extender

Quick Installation Guide

(1)

AC750 Wireless Travel Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

MC220L Gigabit Ethernet Media Converter

Power Adapter

Installation Guide

(1)

Outdoor Plug-In Dimmer

1 x Clamp And Screw

1 x Quick Start Guide

(1)

PF12.5W9 Privacy Filter for Widescreen Laptop 12.5""

Attachment Tabs

(1)

TL-POE150S PoE Injector

Power Adapter

RJ45 Cable

Installation Guide

(1)

Tapo C100 Camera

DC Power Adapter

Quick Start Guide

Mounting Screws

Mounting Template

(1)

USB 3.0 7-Port Hub with 2 Charging Ports

12V/3.3A Power Adapter

1-Meter USB 3.0 Cable

Quick Installation Guide

(1)

USB 3.2 Gen1 Type A To RJ45 2.5Gb Adapter

Installation CD

(1)

Wi-Fi Dimmer Switch, Motion-Activated (1)

Wi-Fi Plug Lite

1 x Quick Start Guide

(1)
8-Port 10/100/1000Mbps Desktop Switch
Power Adapter
User Guide
(1)
AC Adapter
1 x Universal Power Adapter (NA/UK/EU/AUS)
(1)
TL-SF1016D 16-Port 10/100Mbps Desktop Switch
Power Adapter
User Guide
(1)

Height

1"" (25.40 mm) (4)
1.10"" (27.94 mm) (2)
3"" (76.20 mm) (2)
4.41"" (112.01 mm) (2)
0.28"" (7.11 mm) (1)
0.41"" (10.29 mm) (1)
0.59"" (15 mm) (1)
0.70"" (17.78 mm) (1)
0.85"" (21.59 mm) (1)
0.87"" (22.10 mm) (1)
0.94"" (24 mm) (1)
0.98"" (25 mm) (1)
1.20"" (30.48 mm) (1)
1.40"" (35.56 mm) (1)
1.60"" (40.64 mm) (1)
2.62"" (66.55 mm) (1)
2.96"" (75.20 mm) (1)
3.10"" (78.74 mm) (1)
3.70"" (93.98 mm) (1)
3.90"" (99.06 mm) (1)
39.37 mil (1 mm) (1)
4.13"" (105 mm) (1)
4.89"" (124.10 mm) (1)
4.90"" (124.46 mm) (1)
5.06"" (128.52 mm) (1)
6.2"" (1)

Width

2.36"" (59.94 mm) (2)
3.90"" (99.06 mm) (2)
6.20"" (157.48 mm) (2)
1.38"" (35 mm) (1)
1.57"" (39.88 mm) (1)
1.59"" (40.50 mm) (1)
1.71"" (43.50 mm) (1)
10.9"" (1)
2.10"" (53.34 mm) (1)
2.70"" (68.58 mm) (1)
2.75"" (69.85 mm) (1)
2.80"" (71.12 mm) (1)
2.91"" (73.91 mm) (1)
3.10"" (78.74 mm) (1)
3.19"" (81 mm) (1)
3.33"" (84.58 mm) (1)
3.50"" (88.90 mm) (1)
3.50"" (89 mm) (1)
3.70"" (93.98 mm) (1)
3.93"" (99.80 mm) (1)
4.30"" (109.22 mm) (1)
4.33"" (110 mm) (1)
4.80"" (121.92 mm) (1)
4.90"" (124.46 mm) (1)
6.50"" (165.10 mm) (1)
6.70"" (170.18 mm) (1)
7.10"" (180.34 mm) (1)
7.90"" (200.66 mm) (1)
8.50"" (215.90 mm) (1)

Limited Warranty

2 Year (16)
3 Year (6)
Lifetime (5)
1 Year (4)
5 Year (1)

Country of Origin

China (26)
Vietnam (2)
Malaysia (1)
United States (1)

Depth

3.90"" (99.06 mm) (3)
1.50"" (38.10 mm) (2)
2.60"" (66.04 mm) (2)
4"" (101.60 mm) (2)
0.22"" (5.60 mm) (1)
0.78"" (19.72 mm) (1)
1.38"" (35 mm) (1)
1.40"" (35.56 mm) (1)
1.60"" (40.64 mm) (1)
1.74"" (44.21 mm) (1)
1.84"" (46.74 mm) (1)
2.10"" (53.34 mm) (1)
2.13"" (54 mm) (1)
2.30"" (58.42 mm) (1)
2.59"" (65.80 mm) (1)
2.64"" (67.06 mm) (1)
2.90"" (73.66 mm) (1)
3"" (76.20 mm) (1)
3.50"" (88.90 mm) (1)
3.86"" (98 mm) (1)
3.94"" (100.08 mm) (1)
4.50"" (114.30 mm) (1)
4.60"" (116.84 mm) (1)
9.45"" (240 mm) (1)

Quantity

1 (15)
1 Each (5)
1 Pack (1)
2 Pack (1)
20 (1)
3 Pack (1)
4 (1)
4 / Pack (1)
4 Pack (1)

Form Factor

Desktop (7)
External (3)
Portable (3)
Wall Mountable (3)
Desktop
Wall Mountable
(2)
Wall Mount (2)
2.5"" (1)
Desktop
Rack-mountable
(1)
Desktop/Wall Mountable (1)
Internal (1)
Plug-in (1)

Weight (Approximate)

99.8 g (3)
113.4 g (2)
138.8 g (2)
119.1 g (1)
120 g (1)
131.5 g (1)
140 g (1)
149.7 g (1)
21 g (1)
22 g (1)
226 g (1)
258.5 g (1)
26 g (1)
37 g (1)
45 g (1)
480.8 g (1)
56.7 g (1)

Product Color

Black (8)
Black
Gray
(4)
Black
Silver
(3)
White (3)

Device Supported

Audio/Video Device
Monitor
Workstation
Notebook
Desktop Computer
TV
Projector
Digital Signage Player
Graphics Card
(3)
Computer
Smart TV
Notebook
(3)
Blu-ray Player
HDTV
DVD Player
Stereo Receiver
Projector
Audio/Video Device
TV
Digital Video Recorder
Gaming Console
(1)
MacBook
Chromebook
Notebook
Smartphone
Tablet
Wall Charger
Computer
(1)
Notebook
Desktop PC
(1)
Notebook
Monitor
(1)
Notebook
Tablet
PC
TV
Monitor
Projector
Audio/Video Device
(1)
USB Device
Tablet PC
Cellular Phone
iPad
iPhone
(1)
Ultrabook
Projector
Desktop Computer
Notebook
Audio/Video Device
Monitor
Workstation
TV
Docking Station
(1)
iPad
iPhone
iPod
Desktop Computer
MAC
(1)
Computer/Notebook (1)
Desktop Computer (1)
Notebook (1)

Ethernet Technology

Fast Ethernet (7)
Gigabit Ethernet (7)
Ethernet
Fast Ethernet
(2)
Fast Ethernet
Ethernet
(1)

Number of Network (RJ-45) Ports

1 (7)
8 (3)
4 (2)
16 (1)
2 (1)
5 (1)

Power Consumption

2.70 W (2)
9.50 W (2)
1.70 W (1)
1.90 W (1)
2.30 W (1)
3 W (1)
3.20 W (1)
3.30 W (1)
4.30 W (1)
4.60 W (1)
5.60 W (1)
6.50 W (1)
7.30 W (1)

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.
(5)
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.
(3)
Features:
CSMA/CD
TCP/IP
Supports IEEE802.3x flow control for Full Duplex mode and back pressure for Half Duplex mode
Supports MAC address auto-learning and auto-aging
LED indicators for monitoring power, link, activity
(1)
OS Compatibility:

iOS 9.0 or Later

Android 4.1 or Later

(1)
Transfer Method:
Store-and-Forward
(1)
FX Port Supports hot-swappable (LC/SC)
(1)

Delivers Power Up To 100 Meters

Auto-Determine The Necessary Power Requirements

Operating Temperature: 0?~40? (32?~104?)

Storage Temperature: -40?~70? (-40?~158?)

Operating Humidity: 10%~90% non-condensing

Storage Humidity: 5%~90% non-condensing

(1)

Operating Temperature: 0°C to 40°C (32°F to 104°F)

Storage Temperature: -40°C to 70°C (-40°F to 158°F)

Operating Humidity: 10% to 90%RH non-condensing

Storage Humidity: 5% to 90%RH non-condensing

Auto-Sensing Algorithm enables providing power with 802.3af/at PD

Auto-determine the necessary power requirements

Wall-mounting and desktop installation supported

Plug-and-Play

(1)

Rating: 125V~ 60Hz 300 W INC, 150 W LED

Weatherproof Rating: IP64

Power Consumption: Typical (triac On)1.60W

Standby Mode (triac Off): 1.36W

Length Of Power Cable: 224.5mm

Dimmable Led (mlv): 150W Max

Dimming Type: Trailing Edge Dimming / TRIAC Phase Cut

(1)

Features

HDR Support
Multi-Stream Transport (MST) Support
EMI Protection
Latching Connector
Molded
Strain Relief
Stress Resistant
Bendable
Halogen Free
Display Stream Compression (DSC) 1.2
Forward Error Correction (FEC) Support
HDCP 2.2
Flexible
Corrosion-free
Passive
(3)
Wi-Fi
Controllable Light Color
Voice Control
Automatic Temperature Control
Adjustable Temperature
Adjustable Brightness
Remote Controlled
(2)
Anti-reflective
Privacy
Reversible
(1)
Day/Night
SD Card Local Storage
Privacy Protection
Built-in Speaker
Built-in Microphone
Motion Detection
Alarm Triggering
(1)
HDCP 1.4
HDCP 2.2
Hot Plug Detection (HPD)
(1)
Molded
Strain Relief
Corrosion-free
(1)
Motion Detection
Ambient Light Detection (ALD)
Flame Retardant
Timer
(1)
Passive
Latching Connector
HDCP 1.4
DPCP
Flexible
(1)
Reversible
Charging
Damage Resistant
(1)
Charging (1)
LED Indicator (1)

Cable Length

3.3 ft (3)
4.9 ft (3)
6.6 ft (2)
12 ft (1)
8.7"" (1)
9.8 ft (1)

Wireless LAN Standard

IEEE 802.11ac (7)
IEEE 802.11n (2)
IEEE 802.11 a/b/g/n/ac (1)

Compatibility

Radeon Vega Frontier/Pro WX Series Graphic Cards:

2100

3100

5100

7100

W5500

Pro Duo 2000

Nvidia Quadrop Graphic Cards:

GP100

GV100

RTX 4000

Dell XPS 11th Gen Laptops
HP Z2 G8 Tower Workstation (3)
HP OfficeJet 6700 Premium e-All-in-One Printer
(2)
Apple:
iPhone 5
iPod Touch 5th Generation
iPod Nano 7th Generation
iPad 4th Generation
iPad Mini
(1)
Samsung Smartphones:

Galaxy S8

Galaxy S8+

Nexus Smartphones:

6P

5X

(1)
HP Officejet 6700 Premium e-All-in-One Printer
(1)

TP-Link TL-POE10R PoE Splitter

All IEEE 802.3af/at PoE Compliant Powered Devices or PoE Receiver Adapters

(1)
Access Points
IP Cameras
IP Phones
(1)

Input Voltage

120 V AC (6)
120 V AC
230 V AC
(2)
100 V AC
240 V AC
(1)
110 V AC
220 V AC
(1)

Network Technology

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

PoE (RJ-45) Port

No (6)
Yes (3)

Connector Type on First End

DisplayPort 1.4 Digital Audio/Video - Male (3)
HDMI Digital Audio/Video - Male (2)
DisplayPort 1.2 Digital Audio/Video - Male (1)
USB 2.0 Type C - Male (1)
USB Type A - Male (1)

Connector Type on Second End

DisplayPort 1.4 Digital Audio/Video - Male (3)
HDMI 1.4 Digital Audio/Video - Male (1)
HDMI Digital Audio/Video - Male (1)
Lightning - Male (1)
Powered USB Type C - Female (1)
USB 2.0 Type C - Male (1)

Cable Type

DisplayPort (3)
DisplayPort/HDMI (1)
HDMI (1)
HDMI/USB-C (1)
Lightning/USB (1)
USB-C (1)

Connector on First End Details

1 x 20-pin DisplayPort 1.4 Digital Audio/Video - Male (3)
1 x 19-pin HDMI Digital Audio/Video - Male (1)
1 x 20-pin DisplayPort 1.2 Digital Audio/Video - Male (1)
1 x 24-pin USB 2.0 Type C - Male (1)
1 x 4-pin USB Type A - Male (1)
1 x HDMI Digital Audio/Video - Male (1)

Encryption Standard

64-bit WEP
128-bit WEP
152-bit WEP
WPA-PSK
WPA2-PSK
(3)
64-bit WEP
128-bit WEP
WPA-PSK
WPA2-PSK
WPA-PSK2
(1)
64-bit WEP
128-bit WEP
WPA
WPA-PSK2
WPA2-PSK
(1)
WEP
WPA
WPA2
(1)
WPA-PSK
WPA2-PSK
WEP
128-bit WEP
(1)
WPA
WPA2
WPA3
WPA2-ENT
(1)

Virtual Assistant Supported

Alexa
Google Assistant
SmartThings
(4)
Alexa
Google Assistant
(1)
Alexa
Google Assistant
Microsoft Cortana
Nest
IFTTT
(1)
Alexa
Google Home
Kasa Smart
(1)
Google Assistant
Alexa
(1)

Wireless Transmission Speed

1.17 Gbit/s (3)
300 Mbit/s (2)
1.27 Gbit/s (1)
733 Mbit/s (1)
750 Mbit/s (1)

Networking Standards

IEEE 802.3af
IEEE 802.3at
IEEE 802.3x
(2)
IEEE 802.3i
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3x
IEEE 802.1Q
IEEE 802.1p
(2)
IEEE 802.3af
IEEE 802.3at
IEEE 802.3x
IEEE 802.1p
(1)
IEEE 802.3i
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3x
(1)
IEEE 802.3i
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3x
IEEE 802.1p
(1)
IEEE 802.3x (1)

Port/Expansion Slot Details

8 x Gigabit Ethernet Network (3)
16 x Fast Ethernet Network (1)
5 x Gigabit Ethernet Network (1)
1 x Fast Ethernet Network
4 x Fast Ethernet PoE+
(1)
1 x Gigabit Ethernet Network
4 x Gigabit Ethernet PoE+
(1)
4 x Fast Ethernet Network
4 x Fast Ethernet PoE+
(1)

Connector on Second End Details

1 x 20-pin DisplayPort 1.4 Digital Audio/Video - Male (3)
1 x 19-pin HDMI 1.4 Digital Audio/Video - Male (1)
1 x 19-pin HDMI Digital Audio/Video - Male (1)
1 x 24-pin USB 2.0 Type C - Male (1)
1 x 8-pin Lightning - Male (1)
1 x Powered USB Type C - Female (1)

Total Number of Network Ports

8 (4)
5 (3)
16 (1)

Product Material

Metal (5)
Plastic (1)
Polycarbonate (1)
Steel (1)

USB

No (6)
Yes (1)

Connector Plating

Gold (5)
Nickel (2)

Manageable

No (6)
Yes (1)

Host Interface

USB 3.0 (4)
PCI Express (1)
USB 3.0 Micro-B (1)
USB 3.2 (Gen 1) Type A (1)

Total Number of Antennas

2 (5)
3 (1)
4 (1)

American Wire Gauge

28 AWG (2)
34 AWG (2)
22/30 AWG (1)
24/28 AWG (1)

ISM Maximum Frequency

2.40 GHz (5)
2.48 GHz (1)

Jacket Material

Polyvinyl Chloride (PVC) (3)
Thermoplastic Elastomer (TPE) (3)

Data Transfer Rate

32.4 Gbit/s (3)
480 Mbit/s (2)
5.4 Gbit/s (1)

Certifications & Standards

(1)
UL Listed Certification
(1)

FCC

IEEE 802.3af compliant

(1)

IEEE802.3i

IEEE802.3u

IEEE802.3ab

IEEE802.3af

IEEE802.3at

CE

FCC

(1)
CE
FCC
(1)
CE
FCC
IEEE 802.1P
IEEE 802.3
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3x
(1)

UNII Band

Yes (4)
No (2)

Frequency Band

2.40 GHz
5 GHz
(4)
2.48 GHz (2)

System Requirements

Operating Systems:
Microsoft Windows 98SE, NT, 2000, XP, Vista or Windows 7
Mac OS X
NetWare
UNIX
Linux
(1)
Operating Systems:
Windows 2000
Windows XP
Windows 2003
Windows Vista
Windows 7
Windows 8
Mac OS X
Linux
(1)
Operating Systems:
Windows 87/Vista/XP
Mac OS X
Linux
(1)
Operating Systems:
Windows 98SE, NT, 2000, XP, Vista , 7
MAC OS X
NetWare
UNIX
Linux
(1)
Operating Systems:
Windows 98SE
Windows NT
Windows 2000
Windows XP
Windows Vista
Windows 7
Windows 8
Mac OS
NetWare
UNIX
Linux
(1)

Supported Resolution

7680 x 4320 (3)
4096 x 2160 (2)

Product Line

Archer (2)
EasySmart (2)
JetStream (1)

Antenna Form Factor

External (3)
Internal (2)

Number of External Antennas

2 (3)
4 (1)

Application/Usage

Home
Dining Room
(2)
Indoor (2)

Dimmable

Yes (2)
No (1)

PoE Budget

65 W (1)
66 W (1)
67 W (1)

Light Color

Multicolor (2)
Warm White (1)

Maximum Bulb Power

9 W (2)
9.50 W (1)

Maximum Output Power

15.40 W (1)
17 W (1)
30 W (1)

Number of Internal Antennas

2 (2)
3 (1)

Power Rating

150 W
300 W
(2)
600 W (1)

Powerline

No (2)
Yes (1)

Controllable Function

Light Control (2)
Light Control
Volume Control
(1)

Print Color

Cyan (1)
Magenta (1)
Yellow (1)

Color Temperature

4040.3°F (2226.8°C)
11240.3°F (6226.8°C)
(2)
4400.3°F (2426.8°C) (1)

Color Rendering Index

90 (2)
80 (1)

Management

QoS
VLAN
(1)
VLAN
QoS
Easy Smart Configuration Utility
(1)

Platform Supported

PC
Mac
(1)
PC
Mac
Linux
(1)

Length

4.31"" (109.47 mm) (1)
6.89"" (175.01 mm) (1)

Voltage Rating

125 V AC (1)
120 V AC
230 V AC
(1)

Total Wireless Transmission Speed

150 MB/s (1)
93.75 MB/s (1)

Switch Type

3-way (1)
Button (1)

Keyboard/Keypad Width

3.50"" (89 mm) (1)
4.96"" (125.98 mm) (1)

Keyboard/Keypad Height

0.98"" (25 mm) (1)
3.46"" (87.88 mm) (1)

Keyboard/Keypad Depth

1.18"" (29.97 mm) (1)
5"" (127 mm) (1)

Keyboard/Keypad Connectivity Technology

Cable (1)
Wireless (1)

Color Family

Black (1)
Multicolor (1)

Wireless Security

128-bit AES
WEP
WPA
WPA2
WPA-PSK
WPA2-PSK
(1)
64/128/152-bit WEP
WPA-PSK
WPA2-PSK
(1)

Application Log
Timestamp	Level	Category	Message
13:40:11.290570	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
13:40:11.290888	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
13:40:11.291254	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
13:40:11.291507	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
13:40:11.294079	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
13:40:11.295488	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
13:40:11.296552	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)
13:40:11.297610	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)
13:40:11.298131	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)
13:40:11.298265	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
13:40:11.298821	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
13:40:11.345681	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
13:40:11.345711	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
13:40:11.346672	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
13:40:11.348427	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
13:40:11.348964	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
13:40:11.349148	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)
13:40:11.349498	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
13:40:11.349517	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)
13:40:11.350009	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)
13:40:11.350097	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)
13:40:11.350342	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
13:40:11.350361	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)
13:40:11.350842	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)
13:40:11.350919	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)
13:40:11.351008	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
13:40:11.353684	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
13:40:11.353935	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
13:40:11.354016	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)
13:40:11.354324	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
13:40:11.354345	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)
13:40:11.354854	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)
13:40:11.354959	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)
13:40:11.355061	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
13:40:11.355076	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)
13:40:11.379473	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.379511	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=31407 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.380131	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)
13:40:11.380929	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)
13:40:11.381103	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.381119	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=31409 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.381433	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.381448	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=31410 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.381784	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.381800	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=41877 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382021	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382038	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=47388 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382234	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382250	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=49029 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382441	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382456	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=49143 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382632	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382647	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=49145 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382823	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.382838	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=49146 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383017	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383030	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=49398 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383208	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383224	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=51458 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383407	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383421	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=52954 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383601	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383615	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=52955 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383789	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383801	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=52020 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383976	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.383991	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=51491 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.384169	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.384183	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=54019 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.384358	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.384373	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=54029 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.384547	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.384562	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=54030 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.384831	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.384859	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)
13:40:11.385060	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.385070	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=54037 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
13:40:11.385468	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
13:40:11.385504	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)
13:40:11.386200	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)
13:40:11.386326	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)
13:40:11.386421	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
13:40:11.386446	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)
13:40:11.386533	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
13:40:11.386554	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)
13:40:11.386626	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
13:40:11.386647	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)
13:40:11.386712	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
13:40:11.386732	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)
13:40:11.386792	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
13:40:11.386812	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)
13:40:11.387710	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
13:40:11.387732	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)
13:40:11.388266	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)
13:40:11.388364	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)
13:40:11.421339	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)
13:40:11.421474	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)
13:40:11.421940	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)
13:40:11.421967	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)
13:40:11.422827	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)
13:40:11.423054	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)
13:40:11.423537	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)
13:40:11.423667	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)
13:40:11.424690	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)
13:40:11.424715	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=31407 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)
13:40:11.424978	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)
13:40:11.425000	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)
13:40:11.425496	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)
13:40:11.425586	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=31407 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)
13:40:11.425965	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)
13:40:11.426047	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)
13:40:11.426258	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)
13:40:11.426342	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)
13:40:11.427314	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)
13:40:11.427335	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=31409 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)
13:40:11.427457	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)
13:40:11.427474	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=31409 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)
13:40:11.427779	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)
13:40:11.427855	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)
13:40:11.428040	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)
13:40:11.428102	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)
13:40:11.429081	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)
13:40:11.429102	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=31410 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)
13:40:11.429220	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)
13:40:11.429238	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=31410 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)
13:40:11.429426	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)
13:40:11.430113	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)
13:40:11.430999	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)
13:40:11.431035	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)
13:40:11.442234	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)
13:40:11.442269	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)
13:40:11.453457	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)
13:40:11.453497	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)
13:40:11.453687	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)
13:40:11.453804	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)
13:40:11.454027	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)
13:40:11.454106	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)
13:40:11.455086	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)
13:40:11.455106	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)
13:40:11.455230	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)
13:40:11.455251	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)
13:40:11.455564	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)

Products

HP 933XL Ink Cartridge - Single Pack

HEWCN055AN140

HP 933XL Ink Cartridge - Single Pack

HEWCN056AN140

HP 933XL Ink Cartridge - Single Pack

HEWCN054AN140

Are you sure