OfficeCo

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

Manufacturer

TP-LINK Technologies Co., Ltd (10)
StarTech.com (3)

Package Contents

Width

Height

Limited Warranty

2 Year (6)
Lifetime (2)
3 Year (1)

Depth

Country of Origin

China (6)
Vietnam (2)

Product Model

C100 (1)
KP405 (1)
RE220 (1)
T4E (1)
TL-POE150S (1)
TL-SF1016D (1)
TL-SG105E (1)
TL-WA850RE (1)

Application Log
Timestamp	Level	Category	Message
15:28:44.522453	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
15:28:44.522721	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
15:28:44.523082	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
15:28:44.523511	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
15:28:44.526026	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
15:28:44.527626	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
15:28:44.528860	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)
15:28:44.529772	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)
15:28:44.530333	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)
15:28:44.530497	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
15:28:44.531232	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
15:28:45.699708	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
15:28:45.699748	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)
15:28:45.700335	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)
15:28:45.702229	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)
15:28:45.702644	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)
15:28:45.702816	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)
15:28:45.703159	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
15:28:45.703177	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)
15:28:45.703710	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)
15:28:45.703887	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)
15:28:45.704194	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
15:28:45.704212	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)
15:28:45.704576	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)
15:28:45.704694	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)
15:28:45.704827	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
15:28:45.707532	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
15:28:45.707768	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
15:28:45.707854	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)
15:28:45.708229	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
15:28:45.708250	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)
15:28:45.708687	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)
15:28:45.708833	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)
15:28:45.708987	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
15:28:45.709006	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)
15:28:45.724790	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.724817	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)
15:28:45.725178	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.725189	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=54002 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.725440	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.725452	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=54016 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.725681	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.725692	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=54029 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.725915	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.725928	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=54039 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.726150	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.726164	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=54055 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.726366	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.726378	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)
15:28:45.726582	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.726594	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=53960 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.726799	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.726811	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=55116 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.727016	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.727030	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=55125 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.727231	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.727245	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=55127 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.727447	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.727461	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=55130 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.727668	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.727680	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=56019 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
15:28:45.728010	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
15:28:45.728041	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)
15:28:45.728497	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)
15:28:45.728698	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)
15:28:45.728844	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
15:28:45.728876	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)
15:28:45.729413	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
15:28:45.729434	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)
15:28:45.729830	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)
15:28:45.729968	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)
15:28:45.758876	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)
15:28:45.759515	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)
15:28:45.760241	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)
15:28:45.760277	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)
15:28:45.772728	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)
15:28:45.772756	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)
15:28:45.785036	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)
15:28:45.785058	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)
15:28:45.785721	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)
15:28:45.786088	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)
15:28:45.786330	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)
15:28:45.786436	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)
15:28:45.786772	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)
15:28:45.786792	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)
15:28:45.787153	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)
15:28:45.787462	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)
15:28:45.787874	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)
15:28:45.788089	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)
15:28:45.789249	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)
15:28:45.789273	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)
15:28:45.789774	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)
15:28:45.789803	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)
15:28:45.790188	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)
15:28:45.790337	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)
15:28:45.790874	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