OfficeCo

HIGH QUALITY PRODUCT

All of the EcoTone products are remanufactured with only original empty cartridges under the following international quality standards and certifications. Our cartridges are STMC and CGSB certified and go through a rigorous testing process standard to ensure you receive the absolute best printing results. They have been tested and monitored for performance quality and page yield. (4)
A better view from anywhere (1)
HIGH QUALITY PRODUCT

All of the EcoTone products are remanufactured with only original empty cartridges under the following international quality standards and certifications. Our cartridges are STMC and CGSB certified and go through a rigorous testing process standard to ensure you receive the absolute best printing results. They have been tested and monitored for performance quality and page yield. (1)
(1)
Back-UPS Pro

High Performance Computer and Electronics UPS for Premium Power Protection

The Back-UPS Pro family offers guaranteed power protection for high performance computer systems, routers/modems, external storage devices, game consoles and other electronics in your home or business. These UPSs supply electronics with abundant battery backup during outages and stabilize unsafe voltage levels. They also provide power protection from damaging surges and spikes, and allow the use of management software so you get the most out of your UPS. Premium features of this family may include Automatic Voltage Regulation (AVR), an LCD display, Smart Outlets, energy saving functions that reduce electricity use, network manageability, Watchdog, or configurable outlets. Together with the rest of the Back-UPS Pro's standard features, they are the perfect choice to protect your data and keep your system available.

(1)
Features (1)
High Performance Computer and Electronics UPS for Premium Power Protection

The Back-UPS Pro family offers guaranteed power protection for high performance computer systems, routers/modems, external storage devices, game consoles and other electronics in your home or business. These UPSs supply electronics with abundant battery backup during outages and stabilize unsafe voltage levels. They also provide power protection from damaging surges and spikes, and allow the use of management software so you get the most out of your UPS. Premium features of this family may include Automatic Voltage Regulation (AVR), an LCD display, Smart Outlets, energy saving functions that reduce electricity use, network manageability, Watchdog, or configurable outlets. Together with the rest of the Back-UPS Pro's standard features, they are the perfect choice to protect your data and keep your system available.
(1)
Game on the go with Verbatim VGX1000 PCIe NVMe external SSDs.

Part of the Verbatim Gaming Xtreme™ family, these SSDs were designed with gamers in mind. Don't sacrifice space for performance - high capacity drives give you the space you need for your games. The VGX1000 is compatible with a wide variety of devices, including game consoles, PCs, laptops, and more with the included USB-A and USB-C™ cables.

Thanks to the PCIe NVMe interface, you can enjoy blazing fast transfer speeds, with up to 1000MB/s read and 930MB/s write. Verbatim's VGX1000 external SSDs are backed by a 3-year limited warranty or up to the TBW rating.
(1)
Get the most of your workstation with two ultra-high-def monitors. Plug them in with the USB-C Universal DV4K Docking Station with Power, which is Thunderbolt™ 3 compatible and supports both DisplayPort™ and HDMI. It'll help keep your laptop, and your productivity, humming all day long as it delivers integrated power and charging for most USB-C laptops up to 60W. With four USB 3.0 ports (including one that's high-powered for charging devices), plus an Audio In/Out port for speakers, mics, or earphones, it's easy to customize your workstation. Best yet, the dock will help save real estate on your desk, with a wedge design meant to prop up your laptop. This dock combines power with productivity in a compact size.

(1)
This triple-4K dock for Mac, Windows and Chrome USB-C laptops helps you take productivity to a whole new level. With three 4K video connections, 100W Power Delivery, and 5x USB 3.0 ports, the USB-C dock is perfect for your MacBook, Dell XPS, Chromebook or other USB-C laptop requiring additional ports.

You can also connect the dock to your USB 3.0 laptop through a USB-A port, using a USB-C to A cable, such as the USB315AC1M(sold separately). Note: Power Delivery to charge your laptop is not available through USB-A, and only dual display is supported.
Enhance Productivity
The 4K USB-C docking station lets you create a three-monitor Ultra HD workstation. Connect:

2x 4K DisplayPort (DisplayLink) at 4096 x 2160 resolution @ 60Hz / 3840 x 2160 @ 60Hz and

1x 4K HDMI (DP Alt Mode) at 4096 x 2160 resolution @ 24Hz / 3840 x 2160 @ 30Hz

For high-resolution applications, you can connect the dock to a 5K display at 60Hz, using the two DisplayPort ports.
100W Power Delivery
Using a single cable, the USB-C dock will power and charge power-hungry laptops, with up to 100W Power Delivery, and power your peripherals with its 150W power adapter.
Powerful Connections
This triple-monitor docking station lets you transform your laptop into a full-sized workstation. It gives you five USB 3.0 ports (1x USB Type-C and 4x USB Type-A incl. 1x Fast-Charge port), a Gigabit Ethernet port, headset jack, and separate 3.5 mm audio and microphone ports.
Connected Device Transparency with the StarTech.com MAC Address Changer Utility
The DK30CH2DEP, includes a free Windows® application that enables you to better manage your enterprise network security. When you connect to your network through the ethernet port of the dock, the computer's MAC address is typically not broadcast to the network, as your network only sees the MAC address of the docking station. However, the StarTech.com MAC Address Changer or Cloning software enables the USB-C dock to use MAC address spoofing of the connected Windows laptop rather than the MAC address of the dock itself. This ensures your network administrators have full visibility of each device on the network and can monitor and limit activity accordingly. To request access to our MAC Address Changer utility, please contact our Technical Support Department by phone, live chat, or e-mail.

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

(1)
ADS-4300N Professional Desktop Scanner provides easy integration with existing workflows. It delivers fast, two-sided scanning up to 40 ppm. Automatic document feeder quickly scans up to 80 pages at a time and up to 6,000 pages daily. Scanning features include continuous scanning, scan preview, ADF automatic deskewing and blank page skipping. Triple-layer security limits document and device access and protects against network intrusions. Bundled software creates, edits and coverts scanned documents into a wide variety of file formats. Scan using plain paper, receipts, photos (carry sheet required), business cards or plastic/laminated cards. Duplex scanning speed in black and color is 80 ipm and has an interpolated scan resolution up to 1200 x 1200 dpi. It has an optical scan resolution of 600 x 600 dpi. Scan Driver OS is compatible with Windows, MAC OS and Linux. Connect to power using AC Adapter (included) and network using Ethernet or SuperSpeed USB 3.0 (included). (1)
Designed to boost productivity and maximize output, the ViewSonic^® VG2456a is a 24"" docking monitor that transforms your desktop into a streamlined and efficient workspace. Enjoy reliable and flexible network connectivity with the integrated gigabit Ethernet port, while the latest USB-C connectivity makes dual-monitor setup a breeze and provides up to 90W power delivery to your laptop. That's not all, the integrated USB hub also provides single-cable simplicity for connecting and charging your peripherals and accessories. A best-in-class ergonomic design features 40-degree tilt and bi-directional pivot so your screen and workspace are as comfortable as you need. In addition, the included vDisplay software gives you quick and easy OSD control, as well as customized screen templates for easy multi-tasking. This monitor is also shipped in eco-friendly biodegradable packaging, along with an easy-to-install quick release stand that makes for quick deployment and a lower total cost of ownership. (1)
Expand your workstation and connect to virtually any laptop with the Universal USB-C® DV4K Docking Station with 100W Power with Legacy Host Power Kit. Designed to support and power a wide variety of laptops and operating systems, including Windows®, macOS®, Android™, Chrome OS™, and Ubuntu®, this dock packs all of the ports and power you need, whether you have a USB-C or USB-A host device.

Enjoy sharp 4K video while supporting a connection up to two monitors with its two HDMI and two DisplayPort™ connections. Plus connect all your favorite accessories - like a mouse, keyboard, hard drive, and more - with a combination of USB-A (4x USB 3.2 Gen 1 Type-A ports) and USB-C (1x 3.2 Gen 2 Type-C), plus Ethernet and audio ports.

Designed for the modern workstation, the dock comes equipped with a VESA® bracket mounting provision, which allows for use of the Targus VESA Mount Bracket (ACX003GLZ - sold separately) to hold your dock behind your display for even greater space savings.
(1)
Expand your workstation and connect to virtually any laptop with the Universal USB-C® DV4K Docking Station with 100W Power. Designed to support and power a wide variety of USB-C laptops and operating systems, including Windows®, macOS®, Android™, Chrome OS™, and Ubuntu®, this patented dock packs all of the ports and power you need.

Enjoy sharp 4K video while supporting a connection up to two monitors with its two HDMI and two DisplayPort™ connections. Plus connect all your favorite accessories - like a mouse, keyboard, hard drive, and more - with a combination of USB-A (4x USB 3.2 Gen 1 Type-A ports) and USB-C (1x 3.2 Gen 2 Type-C), plus Ethernet and audio ports.

Designed for the modern workstation, the dock comes equipped with a VESA® bracket mounting provision, which allows for use of the Targus VESA Mount Bracket (ACX003GLZ - sold separately) to hold your dock behind your display for even greater space savings.
(1)
Micro-cut shredder features a 100 percent Jam Proof system that automatically detects and powers through jams so you don't have to. P-4 security level shreds up to 12 sheets per pass into small micro-cut particles for enhanced protection. SafeSense technology automatically monitors and immediately stops shredding when hands or pets are too close. Work for up to 10 minutes so your shred jobs can be completed in one sitting. SilentShred offers ultra-quiet performance to minimize noise in shared work spaces. The 6-gallon, pullout waste bin keeps shredded particles contained so your work space re (1)
Micro-cut shredder features a 100 percent Jam Proof system that automatically detects and powers through jams so you don't have to. P-4 security level shreds up to 16 sheets per pass into small micro-cut particles for enhanced protection. SafeSense technology automatically monitors and immediately stops shredding when hands or pets are too close. Work for up to 20 minutes so your shred jobs can be completed in one sitting. SilentShred offers ultra-quiet performance to minimize noise in shared work spaces. The 7-gallon, pullout waste bin keeps shredded particles contained so your work space remains clean.
(1)
Micro-cut shredder features a 100 percent Jam Proof system that automatically detects and powers through jams so you don't have to. P-4 security level shreds up to 20 sheets per pass into small micro-cut particles for enhanced protection. SafeSense technology automatically monitors and immediately stops shredding when hands or pets are too close. Work for up to 20 minutes so your shred jobs can be completed in one sitting. SilentShred offers ultra-quiet performance to minimize noise in shared work spaces. The 8-gallon, pullout waste bin keeps shredded particles contained so your work space remains clean.
(1)
Nowadays, ISPs in many areas have started offering Multi-Gig internet access, and the wireless world moves fast into the WiFi 6 and 5G era. Additionally, the faster 10G is also coming to home electronic equipment like storage devices and PCS, device with the speed of 2.5G/5G/10G will gradually become the mainstream products in the small office and home scenarios in the near future.

10G, short for 10 Gigabit Ethernet, is a group of technologies for an ultra-fast wired network that transmits data frames at a rate of 10 billion bits per second. For the last decade or so, we have witnessed advanced computers and drivers that read files at 10 Gbps speed; however, we are still stuck with 1G or 0.1G networks, which can easily feel like a bottleneck between devices. When inter-devices transferring quickly reach the limits of your network, 10G is the answer.

As the flagship 10G product, TP-Link's TL-SX1008 and TL-SX105 are the newest 10G unmanaged switches with 8Ã— 10GE and 5Ã— 10GE ports, respectively, aiming to provide powerful and lightning-fast wired connections. Auto-negotiation 5-speed (100Mbps/1G/2.5G/5G/10G) connections sense the link speeds and intelligently adjust for compatibility and optimal performance for all the devices, including 10G NAS, 10G server, workstation, 10G PCIe Adapter/ NIC, gaming computer, 2.5G/5G/10G WiFi 6 AP, 8K video, desktop, and more. The revolutionary fanless design of TL-SX105 and intelligent fan speed adjustment of TL-SX1008 ensure quiet operation, ideal for any home or business.

Besides, reliable connections and the lowest possible latency make it ideal for business and home offices, LAN parties, home entertainment, workstations, gaming, and more.

Highlight (1)

Height

3.70"" (93.98 mm) (3)
1.25"" (31.75 mm) (2)
10.24"" (260 mm) (2)
20.8"" (2)
1.30"" (33.02 mm) (1)
1.50"" (38.10 mm) (1)
1.73"" (44 mm) (1)
11.61"" (295 mm) (1)
12.50"" (317.50 mm) (1)
12.60"" (320 mm) (1)
13.39"" (340 mm) (1)
22.83"" (580 mm) (1)
23"" (1)
7.50"" (190.50 mm) (1)

Weight (Approximate)

748.4 g (3)
344.7 g (2)
1.61 kg (1)
11.70 kg (1)
12.50 kg (1)
12.70 kg (1)
16.28 kg (1)
2.77 kg (1)
2.88 kg (1)
3 kg (1)
3.40 kg (1)
3.81 kg (1)
367.4 g (1)
385.6 g (1)
9 kg (1)
9.21 kg (1)

Width

3.50"" (88.90 mm) (3)
14"" (2)
3.25"" (82.55 mm) (2)
3.94"" (100 mm) (2)
11.5"" (1)
11.57"" (294 mm) (1)
11.70"" (297.18 mm) (1)
21.20"" (538.48 mm) (1)
21.22"" (539 mm) (1)
3.20"" (81.28 mm) (1)
3.60"" (91.44 mm) (1)
7.17"" (182 mm) (1)
7.28"" (185 mm) (1)
9.06"" (230 mm) (1)

Depth

18.70"" (474.98 mm) (3)
1.25"" (31.75 mm) (2)
14.49"" (368 mm) (2)
10.60"" (269.24 mm) (1)
13.66"" (347 mm) (1)
15.55"" (395 mm) (1)
2.05"" (52 mm) (1)
2.10"" (53.34 mm) (1)
3.60"" (91.44 mm) (1)
7.09"" (180 mm) (1)
9.06"" (230 mm) (1)

Quantity

1 Each (12)
1 (2)

Country of Origin

China (5)
Taiwan (5)
Canada (2)
Philippines (2)

Product Model

ADS-4300N (1)
BR1350MS (1)
DOCK180USZ (1)
DOCK182USZ (1)
DOCK192USZ (1)
N-300 (1)
P2422H (1)
P2422HE (1)
SD2400T (1)
TL-SX1008 (1)
VG2456a (1)
VGX1000 (1)

Package Contents

Back UPS PRO 1500VA Line Interactive Tower UPS
Coaxial cable
USB cable
User manual
(1)
Back-UPS Pro BR BR1350MS 1350VA Tower UPS
Coaxial cable
USB cable
User manual
(1)
Graphic VG VG2456a LED Monitor
Power Cable
DisplayPort Cable
USB Type C Cable
USB A/B Cable
Quick Start Guide
(1)

10G Multi-Gigabit Unmanaged Switch

Power Cord

Installation Guide

Rackmount Kit

Rubber Feet

(1)

DOCK192USZ Docking Station

Quick Start Guide

Tip Storage Bar

Power Tips

Adapter, AC to DC, output: 19V, 7.89A, 150W

AC Power Cord, C5 Connector, US plug 3P, 1.8M

USB C/M to C/M Cable, Black; 1m, 5A, 10Gbps, E-marked, screw-in

DC cable to power 3 tip, 1M

(1)

P2422H LCD Monitor

1 x DisplayPort cable - DisplayPort to DisplayPort - 6 ft

1 x USB 3.2 Gen 1 upstream cable

(1)

Triple-Monitor 4K USB-C Dock with 5x USB 3.0 Ports - 100W PD

1 x USB-C Cable

1 x Universal Power Adapter (NA/JP, ANZ)

1 x Instruction Manual

(1)

USB-C Universal DV4K Docking Station with 100W Power Delivery

USB C/M to C/M Cable, Black; 1m, 5A, 10Gbps, E-marked, screw-in

Adapter, AC to DC, output: 19V, 7.89A, 150W

AC Power Cord, C5 Connector, US plug 3P, 1.8M

(1)

USB-C Universal DV4K Docking Station with Power - TAA Compliant

1-meter USB-C to C host cable (detachable)

(1)
SD2400T Thunderbolt 3 Dual 4K Nano Dock
0.7m Thunderbolt 3 Cable
(1)

Product Color

Black (7)
White (2)
Black
Silver
(1)

Features

100% Jam-Proof System
SafeSense
(1)
100% Jam-Proof System
SafeSense
Silent Shred
Quiet Operation
Pull-out Bin
Auto Reverse Technology
Electronic Auto Start/Stop
(1)
100% Jam-Proof System
SafeSense
Silent Shred
Quiet Operation
Pull-out Bin
Auto Reverse Technology
Mechanical Auto Start/Stop
(1)
Anti-glare
3H Surface Hardness
(1)
Anti-glare
ComfortView Plus
PowerNap
Digital Daisy Chain
On-screen Display (OSD)
Low Blue Light
Wide Viewing Angle
sRGB
Cable Lock Slot
(1)
Humidity Control
Quiet Operation
Timer
Night Mode
Aroma Therapy
Carrying Handle
UV Light
(1)
Plug & Play
Power Delivery Pass-through
(1)
Wide Viewing Angle
sRGB
Cable Lock Slot
(1)
Cable Lock Slot (1)

Environmental Certification

RoHS (3)
Electronic Product Environmental Assessment Tool Gold (EPEAT Gold)
TCO Certified Edge
(2)
Electronic Product Environmental Assessment Tool Silver (EPEAT Silver)
China Environmental United Certification Center (CEC)
(1)
RoHS
WEEE
REACH
(1)
Electronic Product Environmental Assessment Tool Silver (EPEAT Silver) (1)

Compatibility

Xerox - Phaser Series: (3)
Lexmark - MS Series:
MS710dn
MS810de
MS810dn
MS810dtn
MS810n
MS811dn
MS811dtn
MS811n
MS812de
MS812dn
MS812dtn
(1)
Lexmark - T Series: (1)
Xerox Phaser 6280 Series Printer
(1)

Lenovo X1

Lenovo Thinkpad P Series

Dell Latitude Notebooks

Dell Precision Notebooks

Dell XPS 15 Notebooks

HP Spectre Notebooks

HP Zbook Notebooks

Apple MacBook Pro 16

(1)

PCs

Macs

Chromebooks

Android Devices

(1)

Additional Warranty Information

2 Yr Machine, 7 Yr Cutter
(3)
3Y Basic Hardware Service with Advanced Exchange-Disti SnS (2)
3 year repair or replace (1)
3 years repair or replace (1)

(1)

Length

7.06"" (179.32 mm) (2)
10"" (1)
10.60"" (269.24 mm) (1)
11"" (1)
15.3"" (1)
6.75"" (171.45 mm) (1)

Print Color

Black (3)
Cyan (1)
Magenta (1)
Yellow (1)

Typical Print Yield

17200 Pages (3)
25000 Pages (1)
36000 Pages (1)
7000 Pages (1)

Compatible to OEM Brand

Xerox (4)
Lexmark (2)

Certifications & Standards

UL Listed Certification
(3)
ENERGY STAR V2.0 (USA) (2)
cTUVus
FCC-B
ICES003
Energy Star 8.0
EPEAT Silver
CEC
MX-CoC
Mexico Energy
(1)

Host Interface

USB 3.2 (Gen 1) Type C (2)
Thunderbolt 3 (1)
USB 3.0 Type C (1)
USB 3.1 (Gen 2) Type C (1)
USB Type C (1)

Form Factor

Tower (2)
Desktop
Rack-mountable
(1)
Floor Standing (1)
M.2 (1)

Number of DisplayPorts

2 (3)
1 (2)

TAA Compliant

No (3)
Yes (2)

Operating System Supported

Apple iOS
Android
Mac OS
Linux
Windows
(1)
Windows 7
Windows 8
Windows 8.1
Windows 10
Windows 11
Mac OS X 10.12 Sierra
Mac OS X 10.14 Mojave
ChromeOS 55+
Ubuntu 18.04
(1)
Windows
macOS
(1)
Windows
macOS
Android
Linux
ChromeOS
Ubuntu
(1)
Windows
macOS
ChromeOS
Linux
Android
Ubuntu
(1)

USB Type-C Detail

USB 3.2 Gen 2 Type-C (2)
1 x USB-C 3.1 Gen1 port (up to 5Gbps) (1)
2 x USB Type-C (24 pin) USB 3.0 (5Gbps) Female (1)

Device Supported

Notebook (2)
Desktop PC
Gaming Console
Notebook
(1)
Notebook/Tablet PC (1)

Ethernet Technology

Gigabit Ethernet (3)
10 Gigabit Ethernet (1)

Compatible to OEM Model

106R01566 (1)
106R01567 (1)
106R01568 (1)
654X11A (1)

Standard Refresh Rate

75 Hz (2)
60 Hz (1)

HDMI Version

1.4b (2)
1.4 (1)

Height with Stand

19.50"" (495.30 mm) (2)
20.15"" (511.90 mm) (1)

Width with Stand

21.20"" (538.48 mm) (2)
21.22"" (539 mm) (1)

Horizontal Frequency

30 kHz to 83 kHz (2)
15 kHz to 82 kHz (1)

Weight with Stand (Approximate)

5.17 kg (1)
6 kg (1)
6.30 kg (1)

Supported Resolutions

3840 x 2160 (2)
5120 x 2880
3840 x 2160
(1)

Number of USB Type-A Ports

4 (2)
3 (1)

Number of USB Ports

5 (2)
4 (1)

Speakers

No (2)
Yes (1)

Screen Mode Supported

4K (2)
5K
4K @ 60Hz
(1)

Response Time

5 ms GTG (Fast) (2)
5 ms GTG (1)

Recommended Number of Users

1 (2)
1-3 (1)

Sheet Shred Capacity

12 Per Pass (1)
16 Per Pass (1)
20 Per Pass (1)

Product Line

Back-UPS Pro (2)
Graphic (1)

Maximum Run Time

20 Minute (2)
10 Minute (1)

Total Number of USB Ports

4 (1)
5 (1)
6 (1)

Shredding Item

Paper
Credit Card
Paper Clip
Staples
Junk Mail
(2)
Paper
Paper Clip
Credit Card
Staples
Junk Mail
(1)

Product Series

BR (1)
LX (1)
VG (1)

Wastebin Capacity

22.71 L (2)
30.28 L (1)

Backlight Technology

LED (2)
WLED (1)

Depth with Stand

7.10"" (180.34 mm) (2)
7.95"" (202 mm) (1)

Color

Black
Silver
(2)
Black (1)

Receptacle Type

NEMA 5-15R
USB
(1)
NEMA 5-15R (1)

Additional Information

OS Compatibility:

Windows 7

Windows 8

Windows 8.1

Windows 10

macOS Mojave (10.14)

macOS Sierra (10.12)

Mac OS X El Capitan (10.11)

Chrome OS

(1)

Noise Level: 41.0 dB

Timer Settings: 2h/4h/8h/12h

(1)

RoHS Exemption Information

https://download.schneider-electric.com/files?p_enDocType=Declaration+of+Conformity+%28Sustainability%29&p_Doc_Ref=BR1350MS_ROHS_DECLARATION&p_FileName=BR1350MSKIT_ROHS_DECLARATION_US.pdf (1)
https://download.schneider-electric.com/files?p_enDocType=Declaration+of+Conformity+%28Sustainability%29&p_Doc_Ref=BR1500MS2_ROHS_DECLARATION&p_FileName=BR1500MS2KIT_ROHS_DECLARATION_US.pdf (1)

Mount Type

Desk Mountable (1)
Wall Mountable (1)

Number of USB 3.0 Ports

5 (1)
6 (1)

EU RoHS Declaration URL

https://checkaproduct.se.com/DistantRequestDispatcher.aspx?action=export&pid=465936670&lang=en-us (1)
https://checkaproduct.se.com/DistantRequestDispatcher.aspx?action=export&pid=552168865&lang=en-us (1)

Application/Usage

Computer System
Router
Modem
Storage Device
Gaming Console
Home
Business
Electronic Device
(1)
Desktop Computer
Network
(1)

Total Number of USB Type-C Ports

1 (1)
1.0 (1)

Backup/Run Time (Full Load)

3.30 Minute (1)
4.10 Minute (1)

Vertical Frequency

50 Hz to 75 Hz (1)
56 Hz to 76 Hz (1)

Color Depth

48-bit (1)
6-bit + A-FRC (1)

Compatible to OEM Part Number

106R01395 (1)
52D1H00
521H
MS710
MS810
(1)

REACH Declaration URL

https://checkaproduct.se.com/DistantRequestDispatcher.aspx?action=exportPdfReach&pid=465936670&lang=en-us (1)
https://checkaproduct.se.com/DistantRequestDispatcher.aspx?action=exportPdfReach&pid=552168865&lang=en-us (1)

Transfer Time

10 ms (1)
8 ms (1)

Load Capacity

1.35 kVA/810 W (1)
1.50 kVA/900 W (1)

Application Log
Timestamp	Level	Category	Message
12:40:03.938075	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
12:40:03.938345	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
12:40:03.938711	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
12:40:03.939060	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
12:40:03.941510	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
12:40:03.942941	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
12:40:03.943993	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)
12:40:03.944740	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)
12:40:03.945250	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)
12:40:03.945382	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
12:40:03.945926	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
12:40:03.946356	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
12:40:03.946372	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)
12:40:03.946769	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)
12:40:03.948412	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)
12:40:03.948780	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)
12:40:03.948931	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)
12:40:03.949225	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
12:40:03.949244	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)
12:40:03.949556	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)
12:40:03.949637	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)
12:40:03.949836	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
12:40:03.949852	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)
12:40:03.950153	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)
12:40:03.950222	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)
12:40:03.950305	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
12:40:03.953006	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
12:40:03.953233	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
12:40:03.953315	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)
12:40:03.953614	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
12:40:03.953635	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)
12:40:03.953953	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)
12:40:03.954042	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)
12:40:03.954143	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
12:40:03.954158	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)
12:40:03.974281	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.974320	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=44665 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.974814	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.974838	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=45581 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975043	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975054	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=46010 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975224	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975234	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=46011 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975402	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975410	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=46013 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975595	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975605	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=49148 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975775	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975785	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=50568 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975939	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.975948	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=50313 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976099	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976106	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=50321 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976257	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976264	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=50337 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976412	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976421	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=50338 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976566	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976574	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=50339 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976722	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976730	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=52744 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976875	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.976883	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=54079 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977030	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977037	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=53936 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977185	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977194	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=54311 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977339	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977348	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=54100 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977493	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977502	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=54133 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977647	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977655	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=54147 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977802	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.977811	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=54709 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
12:40:03.978204	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
12:40:03.978235	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)
12:40:03.978646	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)
12:40:03.978782	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)
12:40:03.978924	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
12:40:03.978951	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)
12:40:03.979047	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
12:40:03.979068	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)
12:40:03.979928	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
12:40:03.979948	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)
12:40:03.980294	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)
12:40:03.980395	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)
12:40:04.015168	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)
12:40:04.015893	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)
12:40:04.016772	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)
12:40:04.016835	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)
12:40:04.030749	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)
12:40:04.030822	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)
12:40:04.048198	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)
12:40:04.048259	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)
12:40:04.048809	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)
12:40:04.049052	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)
12:40:04.049259	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)
12:40:04.049387	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)
12:40:04.049808	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)
12:40:04.049829	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)
12:40:04.050209	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)
12:40:04.050453	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)
12:40:04.050807	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)
12:40:04.050956	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)
12:40:04.052011	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)
12:40:04.052042	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)
12:40:04.052371	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)
12:40:04.052393	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)
12:40:04.052761	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)
12:40:04.052869	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)
12:40:04.053186	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