OfficeCo

Marketing Information

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!
(3)
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.
(2)
-100% Smart Dimmer

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

Control Lights from Two Locations

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

Control It All, Your Way

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

Custimized Switch Setting

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

Away Mode

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

Group Control

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

Gentle Off

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

(1)
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)
Creating a True Smart Home Experience All in One App.

Kasa Smart WiFi Outdoor Plug

Made for the Outdoors

With an enormous WiFi range and resistance to dust and splashes of water, use this smart outdoor plug to control your outdoor lights for a memorable dinner party or turn on your sprinklers remotely.

Schedule and Timer for Energy Saving

Use the Kasa Smart app to set a schedule or timer for the connected device. Irrigate your lawn automatically at set times with a fixed duration.

(1)
Customize Your Lighting

Control your room's brightness and set the ambiance for any mood or activity using the Kasa Smart app. Dim your lighting and set the the perfect atmosphere for a romantic movie night with that special someone.

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, Dimmer comes with labels, a faceplate and the necessary hardware for your convenience.

Voice Control

Use simple voice commands to control all of your Kasa Smart devices with any Alexa or Google Assistant voice assistant. Have your voice assistant dim your living room lights from the comfort of your sofa for the perfect movie night.

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.

Gentle Off

Fade off your lights with a simple double-click or set up your voice assistant to do it for you. Perfect for slowly dimming the lights as your child drifts to sleep or to give yourself enough time to exit a room.
(1)
FEATURES (1)
Individual Control 3 Smart Outlets

With 3 smart outlets that can be separately managed and 2 always-on USB ports, the Kasa Smart WiFi Power Strip meets your diverse needs like supporting multiple appliances from lamps to humidifiers and more simultaneously or independently.

Surge Protection

ETL certified surge protection shields sensitive electronics and appliances from sudden electrical surges and spikes, including those caused by lightning or short circuits. Keep your devices safe.

Control from Anywhere

Control up to 3 devices individually or collectively with the Kasa Smart app. Remotely turn off/on plugged-in devices such as lamps, fans, heaters and other devices.

Set Schedules and Timers

Create schedules/timers to turn outlets on/off at specific times to improve convenience and efficiency, manage complicated set-ups like high-end fish tanks, and cut down on power consumption.

Voice Control

Compatible with Alexa and Google Assistant. Free up your hands by using voice commands to control plugged in devices.

Space Saving Design

The right-angled flat plug is designed to leave other outlets free and easily fit behind furniture and in tight spaces.

No Hub Required

Connect to any secured 2.4 GHz wireless network to control directly. No need for a separate hub or extra equipment.
(1)
Kasa Smart Light Strip, Multicolor

Stunning Light Effects, Designed Your Way

16.4ft WiFi LED Strip Works with Alexa, Google Home, SmartThings, High Brightness with 50 Color Zones, RGBIC, PU Coating, Grouping, Adjustable Length, Up to 25,000 Hours

(1)
Lite-duty Plug

A lighter version of Kasa Smart's mini plug that can power any lite-duty device under 12 AMPs.

Control From Anywhere

Turn your smart plug on and off, set schedules or scenes from anywhere with your smartphone using the Kasa Smart app.

No Hub Required

The Smart Plug works with a secured 2.4GHz wireless network without the need for a separate hub.

Voice Control

Use simple voice commands with your smart plug and any Alexa, Google Assistant or Microsoft Cortana.

Compact Design

The compact design of the Kasa Smart Wi-Fi Plug Lite is smaller than other smart plugs and allows them to be stacked in the same outlet.

Grouping

Use Grouping to combine your smart plug with other Kasa Smart devices for seamless control with one single tap on your smartphone.

Set Schedules

Schedule any device connected to the Kasa Smart Wi-Fi Plug Mini to automatically switch on or off if you're home or away.

Control from Anywhere

With the Kasa Smart app you can turn lite-duty appliances, up to 12 AMPs, on and off from anywhere. Turn on your bedside lamp while in the living room, set your plug to Away Mode to randomly turn on and off while you're away, even set schedules around your day.

Compact Design

What's better than one smart plug? Two! The compact design of the Kasa Smart Wi-Fi Plug Lite is smaller than other smart plugs and allows two to be stacked in one wall outlet. Leave one outlet completely free for an appliance or another smart plug.

Your Voice Has Power

Use simple voice commands to control all of your Kasa Smart devices with any Alexa, Google Assistant or Microsoft Cortana device. Tell your voice assistant to turn on your living room lamp, have it schedule the coffee maker for the morning, even turn on your office fan when it gets too hot.

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)
Smart In-Wall Outlets
Kasa Smart's in-wall outlet lets you control 2 plugged in devices from anywhere at the same time or individually. All the features and benefits of a Kasa Smart plug multiplied.
Install Tutorial
Before you begin installation of your Kasa Smart Wi-Fi Power Outlet, we recommend watching this tutorial. Installation and a neutral wire are required for this product. A step-by-step guide can also be found in the Kasa Smart app.
Voice Control
Use simple voice commands with your in-wall smart outlet and any Alexa, Google Assistant or Microsoft Cortana. You can give each outlet a unique name and use them separately.
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)
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)
Smarter 3-Way Switch

Replace traditional 3-way switches commonly found in living rooms, stairways, and hallways with a smarter 3-way light switch. Turn your living room lights on while you're still at work or have your favorite voice assistant turn on the hallway lights so you don't bump into anything.

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, 3-Way comes with labels, a faceplate and the necessary hardware for your convenience.

No Hub Required

The light switch works with a secured 2.4 GHz wireless network without the need for a separate hub. All you need is your smartphone, the Kasa Smart app and a Wi-Fi connection to start controlling your plug from anywhere.

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)
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)
Long Wifi Range - Works with a secured 2.4 GHz WiFi network without the need for a separate hub and features a built-in power amplifier for long range WiFi, reaching up to 300 ft.

IP64 Rated and Fire Resistant - IP64 rating ensures your plug will be protected against dust intrusion and splashes of water¹. The shell is made of UL94-V0 PC-a material ideal for fire prevention.

Easy Setup - Be up and running with your new smart plug in less than 5 minutes! Plug in the weather-resistant plug, follow the setup instructions on the Kasa Smart app, name your plug, and you're good to go!

ETL Certified - ETL certified with quality and safety standards to provide you peace of mind.

Control from Anywhere - Power your outdoor smart plug on or off and set schedules or scenes from anywhere with your phone using the Kasa Smart app.

Voice Control - Use simple voice commands with your smart plug and Alexa or Google Assistant. Ask your voice assistant to turn your stereo on to get a pool party started.

Individual Control - Control 2 outdoor devices from anywhere together or individually, with one smart plug. Ideal for landscape lighting, swimming pool pumps, holiday lights, or other appliances.

Device Grouping - Group your Kasa Smart light bulbs, plugs, and switches for seamless control. Ideal for controlling all your devices simultaneously with a single tap.

Outdoor Smart Plug with 2 Outlets (1)
With the Smart Wi-Fi Dimmer, you can control any room's brightness and set the ambiance for any mood or activity using the Kasa app.

Convenient Lighting Customized to Your Life

Kasa Lighting SceneControl groups of lights with a single tap from the Kasa app.

Gentle Off

Use ""Gentle Off"" to fade lights as your child falls asleep or allow yourself time to exit a room without bumping into things.
(1)

Country of Origin

China (14)
Vietnam (4)

Virtual Assistant Supported

Alexa
Google Assistant
SmartThings
(6)
Alexa
Google Assistant
(2)
Alexa (2)
Alexa
Google Assistant
Microsoft Cortana
Nest
IFTTT
(1)
Alexa
Google Home
Kasa Smart
(1)
Alexa
Google Home
SmartThings
(1)
Alexa
IFTTT
ZigBee
Google Assistant
Kasa Smart
Microsoft Cortana
(1)
Google Assistant
Alexa
Cortana
(1)
Google Assistant
Microsoft Cortana
Alexa
(1)
Kasa Smart
Alexa
Google Assistant
Microsoft Cortana
SmartThings
(1)

Package Contents

1 Ã— WiFi Light Bulb, Multicolor

1 Ã— Quick Start Guide

(3)

1 x Smart Wi-Fi Light Switch

1 x Face Plate

4 x Wire Nuts

1 x Quick Start Guide

(1)

1 x Wi-Fi Light Switch

1 x Face Plate

4 x Wire Nuts

1 x Quick Start Guide

(1)

1Ã— Smart Wi-Fi Dimmer Switch

1 Ã— Satellite Dimmer Switch

2 Ã— Wall Plates

3 Ã— Wire Nuts

4 Ã— Screws

Wire Labels

Quick Start Guide

(1)

2 x Smart Light Switch, 3-Way Smart Switches

2 x Wall Plate

4 x Wire Nuts

1 x Quick Start Guide

(1)

Kasa Smart Wi-Fi Light Switch, Dimmer

1 x Wall Plate

2 x Wire Nuts

Quick Installation Guide

Wiring labels

(1)

Kasa Smart Wi-Fi Plug Lite

1 x Quick Start Guide

(1)

Outdoor Plug-In Dimmer

1 x Clamp And Screw

1 x Quick Start Guide

(1)

Outdoor Plug

1 x Socket Cover

1 x Clamp and Screw

1 x Quick Start Guide

(1)

Smart Wi-Fi Power Outlet, 2-Sockets

1 x Wall Plate

3 x Wire Nuts

1 x Quick Start Guide

(1)

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

Wi-Fi Light Switch, Dimmer

1 x Wall Plate

2 x Wire Nuts

1 x Quick Start Guide

(1)

Wi-Fi Plug Lite

1 x Quick Start Guide

(1)

Wi-Fi Power Strip, 3-Outlets

1 x Quick Start Guide

(1)

Width

2.36"" (59.94 mm) (3)
1.57"" (39.88 mm) (2)
1.71"" (43.50 mm) (2)
1.73"" (43.94 mm) (1)
10.20"" (259.08 mm) (1)
10.38 ft (3164.84 mm) (1)
2.80"" (71.12 mm) (1)
3.33"" (84.58 mm) (1)
3.35"" (85.09 mm) (1)
4.65"" (118.11 mm) (1)
5.12"" (130.05 mm) (1)

Height

4.41"" (112.01 mm) (3)
2.62"" (66.55 mm) (2)
4.13"" (105 mm) (2)
0.20"" (5.11 mm) (1)
1.50"" (38.10 mm) (1)
2.29"" (58.17 mm) (1)
2.56"" (65.02 mm) (1)
2.76"" (70.10 mm) (1)
3.10"" (78.74 mm) (1)
5.04"" (128.02 mm) (1)
5.06"" (128.52 mm) (1)

Weight (Approximate)

138.8 g (3)
113.4 g (2)
149.7 g (2)
150 g (1)
181 g (1)
258.5 g (1)
290.3 g (1)
421.8 g (1)
489.9 g (1)

Quantity

1 (3)
1 Pack (2)
3 Pack (2)
2 Pack (1)
24 Pack (1)
30 Pack (1)
4 (1)
4 Pack (1)

Depth

1.50"" (38.10 mm) (3)
1.74"" (44.21 mm) (2)
1.77"" (44.96 mm) (1)
1.84"" (46.74 mm) (1)
2.38"" (60.45 mm) (1)
2.50"" (63.50 mm) (1)
3.33"" (84.58 mm) (1)
6.30"" (160.02 mm) (1)
6.73"" (170.94 mm) (1)

Input Voltage

120 V AC (10)
120 V AC
230 V AC
(1)

Application/Usage

Home
Dining Room
(3)
Indoor (3)
Home Appliance (1)
Multipurpose (1)

Features

Wi-Fi
Controllable Light Color
Voice Control
Automatic Temperature Control
Adjustable Temperature
Adjustable Brightness
Remote Controlled
(3)
LED Indicator (2)
Motion Detection
Ambient Light Detection (ALD)
Flame Retardant
Timer
(1)
Motion Detection
Passive Infrared Sensor
Ambient Light Detection (ALD)
LED Indicator
(1)
Light Timer (1)

Controllable Function

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

Product Color

White (5)
Multicolor (2)

Power Rating

150 W
300 W
(3)
600 W (2)
1.88 kW (1)
300 W (1)

Current Rating

15 A (6)
12 A (1)

Additional Information

Communication:

Wi-Fi Protocol: IEEE 802.11 b/g/n

Wi-Fi Frequency: 2.4 GHz

Kasa App System Requirement: Secured home Wi-Fi connection required

Wi-Fi Requirements: iOS 10 or Android 5.0 or higher

General:

Operating Temperature: 0ÂºC ~ 40ÂºC (32° F ~ 104° F )

Operating Humidity: 10%~90% RH, Non-condensing

Environment: Indoors only

Working Status:

Clamping Voltage:1200 V(L-N)

USB: 5 V?2.4 A Total

(1)
OS Compatibility:

iOS 9.0 or Later

Android 4.1 or Later

(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)

Protocol: IEEE 802.11b/g/n

Wireless Type: Wi-Fi communication IEEE 802.11b/g/n

System Requirements: Compatible with Android 4.1 or higher and iOS 9.0 or higher.

(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)

Wi-fi Protocol: IEEE 802.11b/g/n

Wi-fi Frequency: 2.4GHz

Wi-fi Requirements: Secured 2.4GHz home Wi-Fi network

Kasa Smart App System Requirement: iOS 10 or Android 5.0 or higher

Individually controlled outlets

Long range Wi-Fi (up to 300ft line of sight)

No hub required

Utilizes HTTPS with SSL/TLS technology

Operating Temperature: -4°F ~ 122°F( -20ÂºC ~ 50ÂºC)

Operating Humidity: 10%~90%RH, non-condensing

Environment: Outdoor and indoor

(1)

Certifications & Standards

(2)

EAC

FCC

UL

(1)

ETL

FCC

(1)

FCC

ETL

IP64

(1)

IEEE 802.11b/g/n

ETL

FCC

IC

(1)

Voltage Rating

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

Product Model

HS103 (1)
HS200 (1)
KP401 (1)
KP405 (1)
KS220M (1)

Switch Type

Button (2)
3-way (1)
Tap (1)

Plug Detail

1 x AC Power (3)
1 x 3-prong (1)

Plug Type

AC Power (3)
3 Prong (1)

Receptacle Type

AC (1)
AC Power (1)

Compatibility

Compatible Products:

Lamp

Fan

Tv

Radio

Coffee Maker

(1)

Outdoor Lights

Sprinklers

(1)

Application Log
Timestamp	Level	Category	Message
07:27:17.157294	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
07:27:17.157598	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
07:27:17.158014	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
07:27:17.158386	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
07:27:17.161215	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
07:27:17.162698	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
07:27:17.163851	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)
07:27:17.164866	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)
07:27:17.165421	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)
07:27:17.165560	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
07:27:17.166156	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
07:27:17.166625	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
07:27:17.166644	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)
07:27:17.167227	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)
07:27:17.169105	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)
07:27:17.169672	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)
07:27:17.169826	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)
07:27:17.170145	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
07:27:17.170162	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)
07:27:17.170708	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)
07:27:17.170804	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)
07:27:17.171027	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
07:27:17.171046	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)
07:27:17.171534	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)
07:27:17.171618	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)
07:27:17.171715	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
07:27:17.174426	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
07:27:17.174664	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
07:27:17.174755	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)
07:27:17.175084	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
07:27:17.175105	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)
07:27:17.175601	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)
07:27:17.175704	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)
07:27:17.175844	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
07:27:17.175860	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)
07:27:17.184174	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
07:27:17.184196	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)
07:27:17.184819	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)
07:27:17.184948	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)
07:27:17.185379	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
07:27:17.185400	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)
07:27:17.185962	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)
07:27:17.186078	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)
07:27:17.214622	trace	system.CModule	Loading "widgetFactory" application component in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)
07:27:17.215060	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)
07:27:17.215112	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)
07:27:17.226294	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)
07:27:17.226320	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)
07:27:17.237710	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)
07:27:17.237742	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` 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)
07:27:17.238703	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` 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)
07:27:17.238867	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)
07:27:17.239051	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)
07:27:17.239233	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)
07:27:17.239559	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)
07:27:17.239579	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_list_details` 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)
07:27:17.240154	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_list_details` 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)
07:27:17.240418	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_lists` 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)
07:27:17.240916	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_lists` 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)
07:27:17.241044	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)
07:27:17.242014	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)
07:27:17.242038	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)
07:27:17.242285	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)
07:27:17.242306	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `sale_prices` 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)
07:27:17.242840	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `sale_prices` 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)
07:27:17.242935	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)
07:27:17.243211	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)

Products

Are you sure