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)
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)
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)
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 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 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 USBLT1MW 1m White Lightning to USB Cable for iPhone, iPod, and iPad provides a reliable solution for charging and syncing your newer generation Apple® mobile devices with your PC or Mac® computer, through an available USB port.

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

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

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

Astonishing picture quality

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

Hassle-free setup

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

Clutter-free installation

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

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

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

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

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

The Superior Performance of DisplayPort 1.4

This 8K DisplayPort cable supports all DP 1.4 features:
- High Bit Rate 3 (HBR3) Bandwidths of 32.4 Gbps supporting the latest in industry standards
- High Dynamic Range (HDR10) for higher contrast ratio and vivid colors
- Multi-Stream Transport (MST) for daisy-chaining multiple monitors
- Display Stream Compression 1.2 (DSC) for maximum resolution output
- Forward Error Correction to manage data transmission errors
- High-Bandwidth Digital Content Protection (HDCP 2.2) for a secure connection between source and display
- 32 Uncompressed Digital Audio Channels
Cable Key Features

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

Connector Key Features

Die-cast aluminium sub-structure shielding improves signal integrity & prevents signal degradation
Corrosion-free gold-plated connectors ensure premium video quality & enhanced reliability
Tested to withstand 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)
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)

Product Type

Package Contents

Product Model

Device Supported

Width

Height

Features

Depth

Weight (Approximate)

113.4 g (1)
119.1 g (1)
120 g (1)
138.8 g (1)
21 g (1)
26 g (1)

Application Log
Timestamp	Level	Category	Message
21:29:10.276797	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
21:29:10.277079	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
21:29:10.277470	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
21:29:10.277772	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
21:29:10.280400	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
21:29:10.283468	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
21:29:10.284867	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)
21:29:10.285931	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)
21:29:10.286654	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)
21:29:10.286798	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
21:29:10.287358	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
21:29:10.495836	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
21:29:10.495876	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)
21:29:10.496368	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)
21:29:10.498177	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)
21:29:10.498611	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)
21:29:10.498783	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)
21:29:10.499111	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
21:29:10.499130	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)
21:29:10.499469	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)
21:29:10.499583	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)
21:29:10.499816	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
21:29:10.499835	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)
21:29:10.500160	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)
21:29:10.500262	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)
21:29:10.500386	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
21:29:10.503144	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
21:29:10.503376	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
21:29:10.503457	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)
21:29:10.503786	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
21:29:10.503808	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)
21:29:10.504146	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)
21:29:10.504266	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)
21:29:10.504400	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
21:29:10.504416	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)
21:29:10.527590	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.527625	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)
21:29:10.528168	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.528182	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)
21:29:10.528394	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.528407	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)
21:29:10.528640	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.528654	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)
21:29:10.528861	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.528875	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)
21:29:10.529083	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.529095	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=53940 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.529289	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.529301	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)
21:29:10.529493	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.529505	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=53968 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.529700	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.529712	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=54001 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.529905	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.529917	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)
21:29:10.530109	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.530122	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)
21:29:10.530314	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.530327	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=54043 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.530519	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.530531	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)
21:29:10.530724	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.530736	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=54057 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.530929	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
21:29:10.530941	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)
21:29:10.531274	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
21:29:10.531306	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)
21:29:10.531848	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)
21:29:10.532078	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)
21:29:10.532238	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
21:29:10.532269	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)
21:29:10.532414	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
21:29:10.532444	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)
21:29:10.533001	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
21:29:10.533023	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)
21:29:10.533446	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)
21:29:10.533590	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)
21:29:10.561652	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)
21:29:10.562359	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)
21:29:10.563085	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)
21:29:10.563121	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)
21:29:10.574152	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)
21:29:10.574179	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)
21:29:10.585206	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)
21:29:10.585232	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)
21:29:10.585701	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)
21:29:10.585865	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)
21:29:10.586042	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)
21:29:10.586169	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)
21:29:10.586528	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)
21:29:10.586548	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)
21:29:10.586896	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)
21:29:10.587131	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)
21:29:10.587477	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)
21:29:10.587630	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)
21:29:10.588641	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)
21:29:10.588666	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)
21:29:10.588915	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)
21:29:10.588937	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)
21:29:10.589291	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)
21:29:10.589406	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)
21:29:10.590105	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