OfficeCo

Marketing Information

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)
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!
(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)
Add on, Leave on

150Mbps Wireless N Nano USB Adapter

TL-WN725N

Great Surfing Experience with Nano USB Adapter

As a Wireless N Nano USB adapter, TL-WN725N allows users to connect a desktop or notebook computer to a wireless network at speed of up to 150Mbps, which is ideal for smooth video streaming, voice streaming and online gaming.

Miniature Design Brings Infinite Convenience

TL-WN725N is designed to be as convenient as possible. With its miniature size and sleek design, users can connect the nano adapter to any USB port and leave it there, no matter when they are traveling or at home.

Easy Setup

A friendly user interface on a CD for simple installation

Advanced Security

WPA/WPA2 encryption standards ensure wireless connection's safety.

Operating System

Supports Windows, Mac OS, Linux

(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 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)
Every Gamer's Best Friend

Simply by plugging in the USB 3.0 interface, UE306 helps connect your Nintendo Switch to a wired network system, a much faster and more stable network environment than a WiFi connection. Enjoy super-fast and high-quality downloading on your Nintendo Switch.

Give Wired Internet Connections to USB Devices

Give your laptop, computer, and other USB web devices access to wired network connections by connecting to the modem, router, or network switch. It's built for most of today's devices to enjoy powerful, instant wired network connections-ideal for those without a built-in RJ45 Ethernet port.

Gigabit Networking for Fast, Stable Data Transfers

Equipped with a USB 3.0 port and Gigabit Ethernet port, it supports network speeds up to 1000 Mbps for faster large file transfers and downloads, seamless streaming, immersive gaming, and more.

Foldable, Lightweight Design

Weight: 20g / 0.71 Oz
Size: 2.8 x 1.0 x 0.6 in. (71 x 26 x 16.2 mm)

Compact and Portable on the Go (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
The TL-SF1005D 5-Port 10/100Mbps desktop switch provides an easy way to expand your wired network. All 5 ports support auto-MDI/MDIX, eliminating the need to worry about the type of cable to use. Featuring full duplex mode, the TL-SF1005D can process data at a rate of up to 200Mbps making it an ideal choice for expanding your high performance wired network. Moreover, with innovative energy-efficient technology, the TL-SF1005D can save up to 60% of power consumption, making it an eco-friendly solution for your home or office network.

(1)
Combining the already impressive Class 10 specification with the performance boost of UHS-I, Transcend's Class 10 SDHC Ultra High Speed memory cards help your camera unleash its full potential. When paired with UHS-I compatible devices, these cards offer blazing-fast transfer speeds, perfect for high-speed consecutive shooting and smooth full HD video recording.
(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)
LED MR16 bulb with a silver back finish produces 500 lumens of warm, white light for up to 25,000 hours. 6.5-watt, dimmable bulb offers a 40-degree beam spread to directly illuminate specific locations. 12-volt, dimmable bulb also features a 3,000 Kelvin temperature, 80 CRI and GU5.3 base.
(1)
Lightning USB 6 ft cable, long enough to use in a car or at home for charging or transferring data. Braided for an extra layer of durability and tangle free. Compatible with all USB devices.

Extra durable, braided design resistant to wear and tear.

6-foot range black cord. Perfect length to meet your daily use.

Works with all USB car and wall chargers

USB 2.0 for fast synchronization

(1)
Lightning USB 6 ft cable, long enough to use in a car or at home for charging or transferring data. Braided for an extra layer of durability and tangle free. Compatible with all USB devices.

Extra durable, braided design resistant to wear and tear.

6-foot range white cord. Perfect length to meet your daily use.

Works with all USB car and wall chargers

USB 2.0 for fast synchronization

(1)
Make Fast Ethernet network connections using this high quality Cat5e Cable, with Power-over-Ethernet capability. The RJ45PATCH7 Cat5e Patch Cable (7 ft) meets or exceeds all Cat 5e specifications to ensure reliable Ethernet network connections, and features a durable blue PVC jacket that enables you to color code your network cable runs as needed.
To ensure long-lasting performance, this high quality Cat5e patch cable features a snagless design that protects the RJ45 connector clips from damage and makes the cable less prone to snagging during installation. The cable also features molded PVC strain relief that prevents the RJ45 connector termination points from bending at sharp angles - reducing the risk of cable damage, which could decrease network performance.
Constructed of only top quality materials, this Cat5e Patch Cord delivers reliable performance and is backed by our Lifetime Warranty.
100% Copper - a better value
StarTech.com Cat5e cables are manufactured using high-quality copper conductors. While many cable manufacturers offer a ""cheaper"" cable, based on a copper-coated aluminum core, we make no compromises on quality to ensure you receive top value and performance for your network cable investment.
24 AWG Wire
This Cat 5e cable is constructed with 24 gauge copper wire, to support a broad range of Ethernet applications such as Power over Ethernet (PoE). Because we use a high quality copper wire, our cables easily sustain the power required for Power over Ethernet applications, whereas the inferior quality offered by copper-coated aluminum cables may be subject to insufficient power delivery, heat buildup, equipment damage and potentially, fire.
50-micron Gold Connectors
This RJ45 patch cable offers high quality connectors comprised of 50-micron gold, to deliver optimum conductivity while eliminating signal loss due to oxidation or corrosion.
(1)
Pro Fit Full-Size Mouse USB features an ergonomic, right-handed shape with a soft rubber grip for all-day comfort. High-definition optical sensor has a pointer speed quick-select button for enhanced productivity. Plug-and-play technology offers the reliability of a wired USB connection. Mouse is built to last and is compatible with PCs (Windows 8) and Macs.
(1)
Scotch® Barricade Tape 301 is a 2-mil thick, polyethylene film backing, barricade tape that is printed with a warning message. It is great for alerting pedestrians of danger in both small and large areas.

Printed with a ""CAUTION"" message

Resists accidental tearing with polyethylene film backing

Great for notifying pedestrians of restricted access to hazardous areas

Tape measures 3 in x 300 ft x 2 mil

Comes in yellow color

Withstands a temperature range of 0 to 120 degrees F (0 to 49 degrees C)

RoHS 2011/65/EU Compliant

16 rolls/case

(1)
TG-3468 Gigabit Network Adapter is a highly integrated and cost-effective adapter which is fully compliant with IEEE 802.3, IEEE 802.3u and IEEE 802.3ab specifications. This adapter keep low cost and eliminates usage barrier. It is the easiest way to upgrade a network from 10/100Mbps to 1000 Mbps.

(1)
TL-SF1005D Fast Ethernet Switch provides 8 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, a hub or a switch.

(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-1302 is an active HDMI™ 1.4 to VGA signal converter. It allows you to convert digital HDMI™ signal into analog VGA signal and extracts audio signal from HDMI™ signal through the R/L audio port.
Besides, if the HDMI™ source display can't supply enough power, you can connect a power adapter or computer to the Micro USB female port to supply power for the adapter.
(1)
The Club 3D CAC-2013 is an active DisplayPort™ to VGA signal converter. It enables you to connect your analog VGA Televisions, Monitors or Projectors to your Desktop or Laptop with DisplayPort™ output. The adapter offers hassle free plug and play functionality, so no Driver installation needed and it is powered by the DisplayPort™ output.
The DisplayPort™ interface in the adapter consists of two main lanes for DP data, AUX channel, HPD signal and power. The VGA output is compliant to VSIS standard and supports up to WUXGA RB timings. Supports resolutions up to WUXGA 1920x1200p @ 60Hz.The adapter works with AMD, Nvidia and Intel Graphic Solutions.

Please use one of our Extension/Adapter cables to connect to your devices:
In case you need assistance to choose the correct cable, please visit our website www.club-3d.com or feel free to mail us at support@club-3d.com and it will be our pleasure to assist you.
(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 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 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 5-Port 10/100/1000Mbps Desktop Switch 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-SG105 adopts lower power consumption design. With the innovative energy-efficient technology, the TL-SG105 can save up to 65% of the power consumption, making it an eco-friendly solution for your home or office network.

Go Green With Your Ethernet
You now have the choice to go green when upgrading to a gigabit network! This new generation TL-SG105 5-Port 10/100/1000Mbps Desktop Switch features the latest innovative energy-efficient technologies that can greatly expand your network capacity with much less power. It automatically adjusts power consumption according to the link status and cable length to limit the carbon footprint of your network.
(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 USB2AA2M 2-meter USB 2.0 cable features two USB 'A' male connectors, delivering a dependable way to connect your PC to a USB hub, or connect USB 2.0 peripherals to a USB hub.

Fully rated to USB 2.0 performance specifications, this high quality USB cable is backed by StarTech.com's Lifetime Warranty.
(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)
The passive PoE adapter TL-POE2412G/TL-POE4824G can be used to simultaneously supply power and transmit data to a passive PoE device, such as TP-Link's EAP245 3.0, EAP225 3.0, CPE610. TL-POE2412G offers a convenient wall-mounting brackets to be easily installed on a wall.
(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 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)
Type-C USB 6 ft cable, long enough to use in a car or at home for charging or transferring data. Braided for an extra layer of durability and tangle free. Compatible with all USB devices.

Extra durable, braided design resistant to wear and tear.

6-foot range black cord. Perfect length to meet your daily use.

Works with all USB car and wall chargers

USB 2.0 for fast synchronization

(1)
USB-C to Lightning 4 ft cable, long enough to use in a car or at home for charging or transferring data. Compatible with all USB-C and Lightning devices.

Extra durable

4-foot range black cord

Works with all USB-C car and wall chargers

USB 2.0 for fast synchronization

(1)
USB-C to Lightning 6 ft cable, long enough to use in a car or at home for charging or transferring data. Compatible with all USB-C and Lightning devices.

Extra durable

6-foot range black cord

Works with all USB-C car and wall chargers

USB 2.0 for fast synchronization

(1)
USB-C to USB-C 10 ft cable, long enough to use in a car or at home for charging or transferring data. Compatible with all USB-C devices.

Extra durable

10-foot range, black cord

Works with all USB-C car and wall chargers

USB 2.0 for fast synchronization

(1)
USB-C to USB-C 4 ft cable, long enough to use in a car or at home for charging or transferring data. Compatible with all USB-C devices.

Extra durable

4-foot range black cord

Works with all USB-C car and wall chargers

USB 2.0 for fast synchronization

(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)
This self-ballasted, fluorescent spiral bulb uses a smaller T2-size bulb that's designed to fit in most lamps. Using just 13 watts, this spiral bulb produces a warm white light at 2,700 Kelvin. Nondimmable spiral bulb features a medium base and produces 900 lumens for 12,000 hours. 120-volt spiral bulb is perfect for lighting areas where harsh, white light is not desired. Energy Star qualified and RoHS compliant. (1)

Limited Warranty

2 Year (14)
1 Year (8)
3 Year (7)
Lifetime (7)
5 Year (1)

Country of Origin

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

Product Color

Black (15)
White (7)
Black
Gray
(2)
Blue (1)

Features

Charging (5)
Charging
Tangle-free
Wear Resistant
Tear Resistant
(3)
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
(2)
Active
Plug & Play
Eyefinity Technology
Automatic Sink Detection
(1)
Day/Night
SD Card Local Storage
Privacy Protection
Built-in Speaker
Built-in Microphone
Motion Detection
Alarm Triggering
(1)
ECC Support
Write Protection Switch
(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)
Wi-Fi
Controllable Light Color
Voice Control
Automatic Temperature Control
Adjustable Temperature
Adjustable Brightness
Remote Controlled
(1)
Dimmable (1)
Energy Saver (1)
HDCP (1)
Light Timer (1)
Plug and Play (1)

Width

3.90"" (99.06 mm) (2)
4.30"" (109.22 mm) (2)
0.73"" (18.54 mm) (1)
0.94"" (24 mm) (1)
1"" (25.40 mm) (1)
1.59"" (40.50 mm) (1)
2.36"" (59.94 mm) (1)
2.70"" (68.58 mm) (1)
2.80"" (71.12 mm) (1)
3"" (76.20 mm) (1)
3.19"" (81 mm) (1)
3.33"" (84.58 mm) (1)
4.10"" (104.14 mm) (1)
4.33"" (110 mm) (1)
4.65"" (118.11 mm) (1)
4.76"" (120.80 mm) (1)
4.80"" (121.92 mm) (1)
5.30"" (134.62 mm) (1)
6.20"" (157.48 mm) (1)
7.10"" (180.34 mm) (1)
7.90"" (200.66 mm) (1)

Product Model

AKP10US (1)
C100 (1)
HS200 (1)
K72369US (1)
KP405 (1)
RE220 (1)
T3U (1)
T4E (1)
TG-3468 (1)
TL-POE150S (1)
TL-POE4824G (1)
TL-SF1005D (1)
TL-SF1008D (1)
TL-SF1016D (1)
TL-SG1008D (1)
TL-SG105 (1)
TL-SG105E (1)
TL-SG108 (1)
TL-WA850RE (1)
TL-WN725N (1)
UE306 (1)
fx-991MS (1)

Package Contents

1 x Smart Wi-Fi Light Switch

1 x Face Plate

4 x Wire Nuts

1 x Quick Start Guide

(1)

1 Ã— WiFi Light Bulb, Multicolor

1 Ã— Quick Start Guide

(1)

150Mbps Wireless N Nano USB Adapter

Resource CD

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

Power Adapter

Installation Guide

(1)

5-Port Gigabit Easy Smart Switch

Power Adapter

Installation Guide

Rubber Feet

(1)

8-Port 10/100Mbps Desktop Switch

Power Adapter

User Guide

(1)

AC1200 Wireless Dual Band PCI Express Adapter

Low-Profile Bracket

Quick Installation Guide

Resource CD

(1)

AC1300 Mini Wireless MU-MIMO USB Adapter

Quick Installation Guide

Resource CD

(1)

AC750 Wi-Fi Range Extender

Quick Installation Guide

(1)

Gigabit 48VDC Passive PoE Adapter

Power Cord

Wall Mounting Kits

(1)

Outdoor Plug-In Dimmer

1 x Clamp And Screw

1 x Quick Start Guide

(1)

TG-3468 32-bit Gigabit PCIe Network Adapter

Resource CD

Quick Installation Guide

(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 to Gigabit Ethernet Network Adapter

Quick Installation Guide

(1)

Wi-Fi Dimmer Switch, Motion-Activated (1)
CAC-1302 HDMI™ 1.4 to VGA Adapter with Audio (Jack 0.35cm / 0.14inch)
USB Power Cable (± 50cm / 19.9inch)
(1)
5-Port 10/100/1000Mbps Desktop Switch
Power Adapter
User 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)
0.90"" (22.86 mm) (2)
0.28"" (7.11 mm) (1)
0.41"" (10.29 mm) (1)
0.85"" (21.50 mm) (1)
0.85"" (21.59 mm) (1)
0.94"" (24 mm) (1)
1.50"" (38.10 mm) (1)
1.60"" (40.64 mm) (1)
2.56"" (65.02 mm) (1)
2.80"" (71.12 mm) (1)
2.96"" (75.20 mm) (1)
3"" (76.20 mm) (1)
3.10"" (78.74 mm) (1)
3.90"" (99.06 mm) (1)
4.41"" (112.01 mm) (1)
5.06"" (128.52 mm) (1)

Device Supported

Car Charger
Wall Charger
USB Device
(4)
Car Charger
Wall Charger
USB Device
iPhone
iPad
iPod
(3)
Audio/Video Device
Monitor
Workstation
Notebook
Desktop Computer
TV
Projector
Digital Signage Player
Graphics Card
(2)
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)
USB Device
Tablet PC
Cellular Phone
iPad
iPhone
(1)
USB Hub
Peripheral Device
Computer
(1)
Ultrabook
Projector
Desktop Computer
Notebook
Audio/Video Device
Monitor
Workstation
TV
Docking Station
(1)
Video Device
Monitor
Projector
HDTV
TV
Desktop Computer
Notebook
(1)
iPad
iPhone
iPod
Desktop Computer
MAC
(1)
Desktop Computer (1)
Desktop Computer/Notebook (1)
Notebook (1)
Notebook/Modem/Router/Switch/Gaming Console/Computer (1)
PC (1)

Quantity

1 (11)
1 Each (4)
1 Pack (1)
2 Pack (1)
30 Pack (1)
4 / Box (1)
4 / Pack (1)

Depth

3.90"" (99.06 mm) (2)
0.22"" (5.60 mm) (1)
0.59"" (14.99 mm) (1)
0.60"" (15.24 mm) (1)
0.78"" (19.72 mm) (1)
1.50"" (38.10 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.60"" (66.04 mm) (1)
2.80"" (71.12 mm) (1)
3.09"" (78.50 mm) (1)
3.10"" (78.74 mm) (1)
3.50"" (88.90 mm) (1)
4"" (101.60 mm) (1)
4.50"" (114.30 mm) (1)
6.73"" (170.94 mm) (1)

Connector Type on Second End

USB 2.0 Type C - Male (5)
DisplayPort 1.4 Digital Audio/Video - Male (2)
USB 2.0 Type A - Male (2)
HD-15 - Female (1)
HD-15 VGA - Female (1)
HDMI 1.4 Digital Audio/Video - Male (1)
HDMI Digital Audio/Video - Male (1)
Lightning - Male (1)
RJ-45 - Male (1)
USB 2.0 Type A (1)
USB 2.0 Type C (1)

Connector on First End Details

1 x Lightning - Male (3)
1 x 20-pin DisplayPort 1.4 Digital Audio/Video - Male (2)
1 x USB 2.0 Type C - Male (2)
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 2.0 Type A - Male (1)
1 x 4-pin USB Type A - Male (1)
1 x DisplayPort 1.2 Digital Audio/Video - Male (1)
1 x HDMI 1.4 Type A Digital Audio/Video - Male (1)
1 x Lightning (1)
1 x RJ-45 - Male (1)
1 x USB 2.0 Type C (1)

Form Factor

Desktop
Wall Mountable
(4)
Desktop (3)
Wall Mountable (3)
External (2)
Internal (1)
Plug-in Card (1)
Portable (1)
SDHC (1)
Wall Mount (1)

Cable Length

6 ft (4)
3.3 ft (3)
6.6 ft (3)
4 ft (2)
1.6 ft (1)
10 ft (1)
12 ft (1)
7 ft (1)
9"" (1)

Connector on Second End Details

1 x USB 2.0 Type C - Male (4)
1 x 20-pin DisplayPort 1.4 Digital Audio/Video - Male (2)
1 x 15-pin HD-15 VGA - Female (1)
1 x 15-pin HD-15 - Female (1)
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 4-pin USB 2.0 Type A - Male (1)
1 x 8-pin Lightning - Male (1)
1 x RJ-45 - Male (1)
1 x USB 2.0 Type A (1)
1 x USB 2.0 Type A - Male (1)
1 x USB 2.0 Type C (1)

Connector Type on First End

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

Cable Type

USB-C (4)
Lightning/USB (3)
DisplayPort (2)
Lightning/USB-C (2)
Category 5e (1)
DisplayPort/HDMI (1)
DisplayPort/VGA (1)
HDMI (1)
USB (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)
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
(3)
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.
(2)
Transfer Method:
Store-and-Forward
(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?~40? (32?~104?)

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

Operating Humidity: 10%~90% non-condensing

Storage Humidity: 5%~90% non-condensing

(1)

Protocol IEEE 802.11b/g/n

Wireless Type 2.4GHz, 1T1R

System Requirements Android 4.1 or higher, iOS 8 or higher

Supported OS: Windows 10

Buttons Power button, Restart Button, Reset Button

(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)
50-micron gold connectors ensure optimum conductivity while eliminating network signal loss due to oxidation or corrosion
Backed by StarTech.com lifetime warranty
RJ45 connector clip protectors help keep the plugs from snagging while routing the cable, for easier Cat5e cable runs
(1)

Weight (Approximate)

2 g (2)
258.5 g (2)
26 g (2)
113.4 g (1)
119.1 g (1)
120 g (1)
138.8 g (1)
20 g (1)
21 g (1)
226 g (1)
76 g (1)
76.5 g (1)

Number of Network (RJ-45) Ports

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

Certifications & Standards

(1)
FCC
(1)
UL Listed Certification
(1)

EAC

FCC

UL

(1)

FCC

CE

(1)

FCC

IEEE 802.3af compliant

(1)
CE
FCC
(1)
CE
FCC
IEEE 802.1P
IEEE 802.3
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3x
(1)
FCC
CE
IC
(1)
IEEE 802.3
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3x
IEEE 802.1p
CE
FCC
(1)
EU Compliant (1)

Power Consumption

1.90 W (1)
2 W (1)
2.30 W (1)
2.70 W (1)
3 W (1)
3.20 W (1)
3.30 W (1)
4.60 W (1)
6.50 W (1)

Ethernet Technology

Fast Ethernet (4)
Gigabit Ethernet (4)
Ethernet
Fast Ethernet
(1)

Network Technology

10/100/1000Base-T (6)
10/100Base-TX (3)

Connector Gender on Second End

Male (8)
Female (1)

Input Voltage

120 V AC (5)
120 V AC
230 V AC
(2)
100 V AC
240 V AC
(1)
12 V AC
12 V DC
(1)

Data Transfer Rate

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

Power Source

Power Adapter (6)
Battery/Solar (1)
Power Supply (1)

System Requirements

Operating Systems:
Microsoft Windows 8/7/Vista/XP
MAC OS X
NetWare
UNIX
Linux
(1)
Operating Systems:
Microsoft Windows 98SE, NT, 2000, XP, Vista or Windows 7
Mac OS X
NetWare
UNIX
Linux
(1)
Operating Systems:
Windows 98SE, NT, 2000, XP, Vista , 7
MAC OS X
NetWare
UNIX
Linux
(1)
Operating Systems:
Windows Vista
Windows 7
Windows 8
Windows XP
(1)
Operating Systems:
Windows 98SE
Windows Me
Windows 2000/2000 Server
Windows XP (32/64-bit)
Windows 2003 Server
Windows Vista (32/64-bit)
Windows 7 (32/64-bit)
Windows 8
Novel NetWare Server 5.x/ 6.x
Linux Kernel 2.4.x/ 2.6.x
(1)
Operating Systems:
Windows 98SE
Windows NT
Windows 2000
Windows XP
Windows Vista
Windows 7
Windows 8
Mac OS
NetWare
UNIX
Linux
(1)
Operating Systems:
Windows XP (32/64-bit)
Windows Vista (32/64-bit)
Windows 7 (32/64-bit)
Windows 8 (32/64-bit)
(1)

Networking Standards

IEEE 802.3i
IEEE 802.3u
IEEE 802.3ab
IEEE 802.3x
IEEE 802.1p
(2)
IEEE 802.3x (2)
IEEE 802.3
IEEE 802.3u
IEEE 802.3x
(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.1Q
IEEE 802.1p
(1)

Port/Expansion Slot Details

5 x Gigabit Ethernet Network (2)
8 x Gigabit Ethernet Network (2)
16 x Fast Ethernet Network (1)
5 x Fast Ethernet Network (1)
8 x Fast Ethernet Network (1)

Total Number of Network Ports

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

Length

0.73"" (18.54 mm) (1)
1.26"" (32 mm) (1)
1.78"" (45.21 mm) (1)
3.15"" (80 mm) (1)
4.13"" (104.90 mm) (1)
4.31"" (109.47 mm) (1)
6.89"" (175.01 mm) (1)

American Wire Gauge

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

Jacket Material

Polyvinyl Chloride (PVC) (4)
Thermoplastic Elastomer (TPE) (2)

Product Material

Plastic (3)
Metal (2)
Steel (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 (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)

TP-LINK Pharos CPE610 Wireless Access Point

TP-LINK Omada Wireless Access Points:

EAP245 3.0

EAP225 3.0

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

Host Interface

USB 3.0 (2)
PCI Express (1)
PCI Express x1 (1)
USB 2.0 (1)

Virtual Assistant Supported

Alexa
Google Assistant
SmartThings
(2)
Alexa
Google Home
Kasa Smart
(1)
Google Assistant
Alexa
(1)
Alexa (1)

Wireless Transmission Speed

1.17 Gbit/s (1)
1.27 Gbit/s (1)
150 Mbit/s (1)
300 Mbit/s (1)
750 Mbit/s (1)

Wireless LAN Standard

IEEE 802.11ac (3)
IEEE 802.11n (2)

Connector Plating

Gold (3)
Nickel (2)

Color Details

Black - Cord (4)
White - Cord (1)

Bulb Size Standard

A19 (2)
MR16 (1)
T2 (1)

Supported Resolution

7680 x 4320 (2)
1920 x 1200 (1)
4096 x 2160 (1)

ISM Maximum Frequency

2.40 GHz (3)
2.48 GHz (1)

Manageable

No (3)
Yes (1)

Platform Supported

PC (2)
Mac
PC
(1)
PC
Mac
(1)

Base

E26 (3)
GU5.3 (1)

Maximum Bulb Power

13 W (1)
6.50 W (1)
9 W (1)
9.50 W (1)

Luminous Flux

800 lm (2)
500 lm (1)
900 lm (1)

Light Color

Warm White (2)
Multicolor (1)
White (1)

Dimmable

No (2)
Yes (2)

Color Temperature

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

Color Rendering Index

80 (2)
82 (1)
90 (1)

Product Line

Archer (1)
EasySmart (1)
Pro Fit (1)

Diameter

1.81"" (45.97 mm) (1)
2"" (50.80 mm) (1)
2.38"" (60.45 mm) (1)

Maximum Output Power

15.40 W (1)
17 W (1)
24 W (1)

Wi-Fi Generation

Wi-Fi 5 (2)
Wi-Fi 4 (1)

Maximum Bulb Life

12000 Hour (1)
15000 Hour (1)
25000 Hour (1)

Beam Angle

220° (2)
40° (1)

UNII Band

Yes (2)
No (1)

Incandescent Equivalent Wattage

60 W (2)
50 W (1)

Power Rating

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

Frequency Band

2.48 GHz (1)
2.40 GHz
5 GHz
(1)

Operating System Compatibility

Windows 10
Windows 8.1
Windows 8
Windows 7
Windows Vista
Windows XP
Windows 2000
Mac OS X 10.11 El Capitan
Mac OS X 10.14 Mojave
ChromeOS
(1)
Windows 8
Windows 11
Windows Vista
Windows 7
Windows 10
Mac OS X 10.10 Yosemite
ChromeOS
Mac OS X 10.9 Mavericks
(1)

Number of Internal Antennas

2 (1)
3 (1)

Controllable Function

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

Wireless Security

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

Application/Usage

Home
Dining Room
(1)
Lamp (1)

Total Number of Antennas

2 (1)
3 (1)

Thickness

2 mil (0.05 mm) (1)
82.68 mil (2.10 mm) (1)

Application Log
Timestamp	Level	Category	Message
02:45:16.476691	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
02:45:16.477054	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
02:45:16.477535	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
02:45:16.477842	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
02:45:16.481245	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
02:45:16.483077	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
02:45:16.484600	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)
02:45:16.485285	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)
02:45:16.485975	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)
02:45:16.486116	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
02:45:16.486886	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
02:45:16.544002	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
02:45:16.544040	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)
02:45:16.544594	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)
02:45:16.546681	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)
02:45:16.547167	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)
02:45:16.547344	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)
02:45:16.547693	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
02:45:16.547713	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)
02:45:16.548110	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)
02:45:16.548232	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)
02:45:16.548481	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
02:45:16.548500	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)
02:45:16.548901	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)
02:45:16.549020	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)
02:45:16.549168	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
02:45:16.552066	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
02:45:16.552304	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
02:45:16.552395	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)
02:45:16.552755	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
02:45:16.552778	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)
02:45:16.553711	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)
02:45:16.553886	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)
02:45:16.554042	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
02:45:16.554066	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)
02:45:16.575967	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.575997	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=18182 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.576503	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)
02:45:16.577202	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)
02:45:16.577368	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.577380	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=29031 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.577801	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.577814	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=37714 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.578166	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.578177	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)
02:45:16.578401	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.578413	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=44175 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.578629	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.578641	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=46169 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.578856	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.578869	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)
02:45:16.579087	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.579098	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)
02:45:16.579313	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.579325	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)
02:45:16.579530	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.579544	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=47324 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.579755	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.579766	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=52959 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580001	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580013	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=52865 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580219	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580231	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=52866 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580439	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580451	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=52867 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580676	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580687	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=52874 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580895	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.580909	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=52875 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.581115	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.581129	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=52877 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.581335	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.581346	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=52878 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.581552	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.581564	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=53937 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.581769	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.581782	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=53938 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
02:45:16.582120	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.582144	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)
02:45:16.582526	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)
02:45:16.582690	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)
02:45:16.582832	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.582861	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)
02:45:16.583003	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.583033	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)
02:45:16.583185	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.583237	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)
02:45:16.583374	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.583404	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)
02:45:16.583523	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.583553	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)
02:45:16.583673	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.583703	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)
02:45:16.583821	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.583849	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)
02:45:16.583970	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.583998	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)
02:45:16.584238	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
02:45:16.584300	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)
02:45:16.585464	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
02:45:16.585506	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)
02:45:16.586313	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)
02:45:16.586468	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)
02:45:16.621624	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)
02:45:16.621758	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)
02:45:16.622181	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)
02:45:16.622210	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)
02:45:16.622632	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)
02:45:16.622883	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)
02:45:16.623323	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)
02:45:16.623502	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)
02:45:16.624640	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)
02:45:16.624666	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=18182 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)
02:45:16.624927	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)
02:45:16.624948	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)
02:45:16.625767	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)
02:45:16.625880	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=18182 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)
02:45:16.626318	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)
02:45:16.626405	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)
02:45:16.626760	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)
02:45:16.626830	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)
02:45:16.628428	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)
02:45:16.628474	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=29031 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)
02:45:16.628657	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)
02:45:16.628681	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=29031 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)
02:45:16.629200	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)
02:45:16.629319	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)
02:45:16.629591	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)
02:45:16.629676	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)
02:45:16.631243	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)
02:45:16.631264	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=37714 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
02:45:16.631436	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)
02:45:16.631457	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=37714 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
02:45:16.631700	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)
02:45:16.632636	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)
02:45:16.633671	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)
02:45:16.633708	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)
02:45:16.650262	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)
02:45:16.650329	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)
02:45:16.667939	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)
02:45:16.667999	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)
02:45:16.668189	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)
02:45:16.668351	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)
02:45:16.668638	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)
02:45:16.668718	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)
02:45:16.669787	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)
02:45:16.669835	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)
02:45:16.670125	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)
02:45:16.670176	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)
02:45:16.670591	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)

Products

Kensington Pro-Fit Full-size Wired Mouse

KMW72369

Satco 13-watt Fluorescent T2 Spiral CFL Bulb

SDNS6235

Satco LED MR16 Warm 500 Lumens Light Bulb

SDNS9496

Are you sure