OfficeCo

Professional productivity
with Chromecast built-in and HDMI hotplug
Boost productivity. Philips B-Line seamlessly integrates into corporate systems for efficient control. Chromecast built-in ensures presentations run smoothly with instant wireless media sharing from Windows, Apple and Android™ devices.
Smart control features
- Compatible with Extron and Neets systems
- Crestron Connected certified system integration
- Install and manage apps remotely with AppControl
- Operate, monitor and maintain via CMND & Control
- Scheduler for content playback at selected times
- Can tune TV channels, including ATSC, QAM and IPTV
Vibrant and efficient
- Chromecast built-in for wireless content sharing
- HDMI hotplug detection with auto on/off function
- Google Play Store access for apps and media
- Supports Pro:Idiom™ encrypted content
- Superb audio quality without external speakers
- UHD resolution for attention grabbing content
- Android updates provide the latest functionality
(3)
Everyday scanning made easy:

One-button simplicity
The beautifully simple iX1400 will digitize, process, and organize all your documents from one easy device. You don't need to know IT. You just need to press the blue button. With no complex settings to configure, the iX1400 is up and running from the box in record time. Its one-touch scanning turns time-consuming chores into simple tasks at the push of a button. Just scan, save, and share.

Form and function
Designed by the world's leading scanner manufacturer, the iX1400 is compact and stylish enough to fit into most workspaces and can be by your side, wherever work takes you.
Using the ScanSnap Home software, simply and efficiently, create the type of files you want- searchable PDFs, and editable Word, Excel, and PowerPoint files. Extract data from receipts and business cards. Save them all to the places you want. And count on powerful search and retrieval of your scans.

The scanning experience you'll love

Out of the box, ready in minutes
The iX1400 is so easy to set up, anyone can do it. Just unbox, set up in minutes, and press the blue button to start enjoying one-touch scanning. Once setup is done, simply open the lid and the scanner powers up-it's ready to go.

Powerfully fast
Scan up to 50 sheets of single- or double-sided documents at a quick 40 sheets per minute. The two-sided (duplex) scanning feature will have you digitizing paperwork in half the time.

Quick Menu for instant file creation
The Quick Menu function allows you to instantly scan straight into the applications you know and use-and you can add more applications any time. Some other things Quick Menu lets you do:
- Scan images directly to a folder, email, or even a printer.
- Extract data from receipts and business cards into CSV files.
- Export scans to your favorite cloud storage locations.
- Create searchable PDFs, or instantly open your scan as a fully editable file in Word, Excel, or PowerPoint.
Industry-leading reliability
Using professional grade feeding technology and ultrasonic sensors, the iX1400 handles multi-page documents with ease. And you can set an alert to tell you if two or more pages are fed through the scanner at once-to make sure no page gets lost.

Instant, secure connection
No one wants to spend time on installation. The fuss-free USB 3.2 connector plugs straight into your computer

Automated Operation
A host of intelligent image processing functions are automatically done for you, so you can scan confidently without adjusting settings.
(1)
DisplayPort/HDMI KVM Switch For Dual DisplayPort 4K 60Hz

The CSV-7210 is a high performance DisplayPort™ KVM (Keyboard Video and Mouse) switcher. It routes high definition videos up to 4096x2160 at 60Hz resolution and audio from any DisplayPort™ source to any HDMI™ or DisplayPort™ supported display. This DisplayPort™ KVM switcher not only has the key press switching function, but also has an intelligent function as well as hot pluggable function.
(1)
Fast Wi-Fi Travels with You!

AC750 Wireless Travel Router

TL-WR902AC

Portable and compact

The incredibly compact TL-WR902AC is the world's first AC750 travel router. Take it with you to create a personal Wi-Fi spot anywhere internet is available. It fits easily in your pocket, purse or bag and is perfect for use while traveling. Watch movies over private dual-band Wi-Fi at a hotel.

Dual-Band AC for Fast Wi-Fi Speeds

The travel router creates fast AC750 Wi-Fi over dual 2.4 GHz (300 Mbps) and 5 GHz (433 Mbps) bands. Dual bands allow for more devices to be connected to your personal network and provide reliable Wi-Fi access so you can enjoy what you love without interruptions.

Multiple Wi-Fi Modes for Any Situation

Whether you need a private Wi-Fi network while away or something to boost your Wi-Fi at home, the TL-WR902AC has a mode for you.

Multifunctional USB Port for File Sharing and Charging

A The travel router comes with a built-in USB 2.0 sharing port. Connect a USB storage drive to share access to files, download movies and back up recent photos. Connect your smartphone cable and the router doubles as a 5V/1A charging station for one device.
(1)
NEXT LEVEL PERFORMANCE FOR EVERYONE.

AX5400 Dual-Band 6-Stream Gigabit Wi-Fi 6 Router

Archer AX73

Fully Featured Wi-Fi 6

Warp Speeds up to 5400 Mbps

Extensive Wi-Fi Coverage

Up to 4x More Capacity

HomeShield Security

Wi-Fi 6 Upgrades Everything

The latest generation of Wi-Fi technology brings faster speeds, less lag, and higher capacity, enabling more simultaneous connections on your home network.

Warp Speed for Smooth 8K Streaming

Drastically improved speeds enable smoother streaming, faster downloading, and gaming, all at the same time. Need to go faster?
Hop on 5 GHz with full speed-boosting features to stream multiple 8K videos without lagging.

6 Stream Wi-Fi Router 2033 Mbps

Archer AX73 5378 Mbps
164% Faster

HT160
Doubling bandwidth
1024-QAM
25% faster speeds

6-Stream
Simultaneous transmission

Extensive Wi-Fi Coverage with Advanced Technology

Enjoy stable Wi-Fi connections in all rooms, even in the kitchen and bedroom. High-Power FEM, 6Ã— antennas, beamforming, and 4T4R structures combine to adapt Wi-Fi coverage to perfectly fit your home and concentrate signal strength towards your devices.

Connect More Devices

Easily handle dozens of devices streaming and gaming at the same time - OFDMA and MU-MIMO combine to future-proof your home network by providing greater capacity to connect more devices.

OFDMA

Enables different devices to share one transmission stream, increasing efficiency.

MU-MIMO

Transmits data to different devices simultaneously using multiple streams.

Designed to Be Cool

The slant rectangle atop of the scaled armor design provides a contemporary aesthetic. The vent design takes up 167 cm² (25 in²) of its top surface for improved heat dissipation, unleashing the whole machine's full power.

TP-Link HomeShield: Advanced Security for Your Network and Clients

HomeShield protects all connected clients against DDoS, malicious sites, and port intrusion, delivering a safe network environment for your data and privacy.

Enhanced IoT Security

HomeShield identifies IoT devices, including cameras and voice assistants, to block all potential security holes and secure your privacy.

DDoS Attack Prevention

HomeShield will record abnormal incoming traffic, and the device will automatically block requests from enlisted IPs.

Robust Parental Controls

Manage online time and block inappropriate content to keep your family safe online.

Leading Security by Avira®

Avira, an award-winning tech company, relied on by 500 million users, powers HomeShield and continually updates it, ensuring your network stays worry-free.
(1)
PURE GAMING (1)
Professional productivity
with Chromecast built-in and HDMI hotplug
Boost productivity. Philips B-Line seamlessly integrates into corporate systems for efficient control. Chromecast built-in ensures presentations run smoothly with instant wireless media sharing from Windows, Apple and Android™ devices.
Smart control features
Crestron Connected certified system integration
Install and manage apps remotely with AppControl
Operate, monitor and maintain via CMND & Control
Scheduler for content playback at selected times
Can tune TV channels, including ATSC, QAM and IPTV
Compatible with Extron and Neets systems
Vibrant and efficient
Chromecast built-in for wireless content sharing
HDMI hotplug detection with auto on/off function
Google Play Store access for apps and media
Supports Pro:Idiom™ encrypted content
Superb audio quality without external speakers
UHD resolution for attention grabbing content
Android updates provide the latest functionality
(1)
Simplify your connectionswith USB-C docking monitor

B Line

27"" (68.6 cm)

1920 x 1080 (Full HD)

Connect your notebook with one USB-C cable

This Philips display features a USB type-C connector with power delivery. With intelligent and flexible power management, you can power charge your compatible device directly. Its slim, reversible USB-C allows for easy, one-cable connection. You can watch high resolution video and transfer data at a super-speed, while powering up and re-charging your compatible device at the same time.

IPS technology for full colors and wide viewing angles

IPS displays use an advanced technology which gives you extra wide viewing angles of 178/178 degree, making it possible to view the display from almost any angle - even in 90 degree Pivot mode! Unlike standard TN panels, IPS displays gives you remarkably crisp images with vivid colors, making it ideal not only for Photos, movies and web browsing, but also for professional applications which demand color accuracy and consistent brightness at all times.

SmartErgoBase enables people-friendly ergonomic adjustments

The SmartErgoBase is a monitor base that delivers ergonomic display comfort and provides cable management. The base's people-friendly height, swivel, tilt and rotation angle adjustments position the monitor for maximum comfort that can ease the physical strains of a long workday; cable management reduces cable clutter and keeps the workspace neat and professional.

Less eye fatigue with Flicker-free technology

Due to the way brightness is controlled on LED-backlit screens, some users experience flicker on their screen which causes eye fatigue. Philips Flicker-free Technology applies a new solution to regulate brightness and reduce flicker for more comfortable viewing.

LowBlue Mode for easy on-the-eyes productivity

Studies have shown that just as ultra-violet rays can cause eye damage, shortwave length blue light rays from LED displays can cause eye damage and affect vision over time. Developed for wellbeing, Philips LowBlue Mode setting uses a smart software technology to reduce harmful shortwave blue light.

HDMI ensures universal digital connectivity

An HDMI-ready device has all the required hardware to accept High-Definition Multimedia Interface (HDMI) input. A HDMI cable enables high-quality digital video and audio all transmitted over a single cable from a PC or any number of AV sources (including set-top boxes, DVD players, A/V receivers and video cameras).
(1)
The New Era of Home Connectivity

AX3000 Dual-Band Gigabit Wi-Fi 6 Router

Archer AX55

160MHZ Bandwidth 2Ã— bandwidth

512 MB RAM Premium WiFi 6

4 High Power FEM

Gigabit Ports

USB 3.0 Port

HomeShield

OneMesh™

Wi-Fi 6 Upgrades Everything

The latest generation of Wi-Fi technology brings faster speeds, less lag, and higher capacity, enabling more simultaneous connections on your home network.

Incredible Speed

Drastically improved speeds enable streaming, fast downloading, and gaming-all at the same time. 5 GHz with 160 MHz channel support doubles the bandwidth, enabling 8K video without lag.
250% Faster

More Responsive Experiences (1)
A New Generation in Productivity

The next generation iX1600 is the most flexible scanner in the category, allowing users to connect via Wi-Fi or USB. With 33% faster duplex scanning, you can get more done in less time and with ScanSnap Home 2.0 software, documents will be digitized, organized and saved with minimal effort.

Optimized user experience: ScanSnap iX1600 features an intuitive 4.3inch touch screen for complete end to end scanning and data utilization

Customize your preference: The scanner supports up to 30 customizable profiles. Customize the profile on the touch screen based on your scanning needs. Personalize scanning icons using color, icons or letters

Scan anywhere you want whenever you want: Wi-Fi compatibility allows you to directly connect to your smart devices or cloud services without PC, and allows for flexible placement wherever its convenient

Ideal for team sharing: One scanner supports up to 4 user licenses each allowing user profile and icon customizations.

Stress-free usability for any users: Friendly user interface enables even the most technology challenged users to scan and complete their tasks with peace of mind.

Clean, improved images: The iX1600 produces consistent, high quality and clean images. Even if streaks do appear on scanned images, the Streak Reduction function removes them, reducing the hassle of time-consuming rescans. Automatically removes blank pages, deskews and rotates, detects color, grayscale and black and white, detects document size

Scan receipts and much more: Reduce paper preparation even before hitting the scan button. Scan oversized or difficult documents, including envelopes, receipts or business cards.

Experience the best with ScanSnap Home software: The ultimate document management platform which combines all of your favorite functions into one. Easily manage, edit and access data from documents, business cards, receipts and photos with the software.

Connect with ScanScap Cloud without the PC: You can choose to scan data directly from the ScanSnap iX1600 to your favorite cloud service without a computer or mobile device. The software automatically recognizes and organizes your file type by documents, receipts, and business cards, and sends it to the appropriate cloud based on your pre-set profiles.

(1)
APC Back-UPS RS 700 VA Tower UPS offers high performance protection for your business and office computer systems. It provides abundant battery backup power, allowing you to work through medium and extended length power outages. It also safeguards your equipment from damaging surges and spikes that travel along utility, phone and network lines.

(1)
A mini-tower UPS with line interactive topology, the CyberPower Intelligent LCD CP1000AVRLCD provides battery backup (using simulated sine wave output) and surge protection for desktop computers, workstations, networking devices, and home entertainment systems. The CP1000AVRLCD uses Automatic Voltage Regulation (AVR) to correct minor power fluctuations without switching to battery power, which extends battery life. AVR is essential in areas where power fluctuations occur frequently. The CP1000AVRLCD comes with a three-year warranty (including coverage of batteries) and a
350,000 Connected Equipment Guarantee.
Product Features (1)
A mini-tower UPS with line interactive topology, the CyberPower PFC Sinewave CP1500PFCLCD provides battery backup (using sine wave output) and surge protection for desktop computers, workstations, networking devices, and home entertainment systems requiring active PFC power source compatibility.
The CP1500PFCLCD features an advanced multifunction control panel with a color LCD to quickly confirm status and alerts at-a-glance. The screen tilts for easy viewing when the UPS is placed in a low position such as under a desk. Two USB charge ports (one Type-A and one Type-C) power portable devices such as mobile phones and tablets, even during a utility power failure.

The CP1500PFCLCD uses Automatic Voltage Regulation (AVR) to correct minor power fluctuations without switching to battery power, which extends battery life. AVR is essential in areas where power fluctuations occur frequently. The CP1500PFCLCD comes with a three-year warranty (including coverage of batteries) and a
500,000 Connected Equipment Guarantee.

Product Features (1)

Weight (Approximate)

33.50 kg (2)
11.29 kg (1)
15.10 kg (1)
3.20 kg (1)
3.40 kg (1)
370 g (1)
4.59 kg (1)
425 g (1)
56.7 g (1)
6.80 kg (1)
7.15 kg (1)
7.62 kg (1)

Product Model

273B9 (1)
43BFL2214 (1)
58BFL2114 (1)
75BFL2114 (1)
75BFL2214 (1)
AX55 (1)
AX73 (1)
CP1000AVRLCD (1)
CP1500PFCLCD (1)
GX90 (1)
ScanSnap iX1600 (1)
TL-WR902AC (1)
iX1400 (1)

Package Contents

Professional TV

Remote Control

2 x AAA Batteries

Power Cord

(3)
Back-UPS RS 700 VA Tower UPS
USB cable
User manual
(1)

AC750 Wireless Travel Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

AX3000 Dual Band Gigabit Wi-Fi 6 Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

AX5400 Dual-Band Gigabit Wi-Fi 6 Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

AX6600 Tri-Band Wi-Fi 6 Gaming Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

LCD Monitor with USB-C

Stand

HDMI cable

DP cable

USB-C to C/A cable

Power cable

User Documentation

(1)
Professional TV
Remote Control 22AV1905A/12
2 x AAA batteries
Power Cord
(1)

Product Series

B-Line (4)
iX (2)
Intelligent LCD UPS (1)
PFC Sinewave UPS (1)
RS (1)

Input Voltage

120 V AC (5)
120 V AC
230 V AC
(2)
120 V (1)

Product Line

Archer (3)
ScanSnap (2)
B-Line (1)
Back-UPS (1)

Form Factor

Desktop (3)
Mini-tower (2)
Portable (1)
Tower (1)

Limited Warranty

3 Year (3)
2 Year (2)
12 Month (1)

Features

Progressive Scan
Down Firing Speaker
Google Play
Audio Return Channel (ARC)
Auto Power Off
Auto Power On
Chromecast
HTML5 Support
Subtitle
Eco Mode
Pro:Idiom
(3)
Progressive Scan
Down Firing Speaker
Google Play
Audio Return Channel (ARC)
Pro:Idiom
Eco Mode
Auto Power Off
Timer
Wall Mountable
Chromecast
Time Scheduler
(1)
SmartErgoBase
Flicker-free
Low Blue Light
Anti-glare
3H Surface Hardness
SmartImage
sRGB
EasyRead Mode
Sync on Green
PowerSensor
SmartControl
On-screen Display (OSD)
Cable Lock Slot
Plug & Play
Eco Mode
LED Indicator
Intelligent Power Manager (IPM) System
Wide Viewing Angle
Cable Management
Power Management
SmartContrast
(1)

Backlight Technology

LED (4)
WLED (1)

VESA Mount Standard

600 x 400 (2)
100 x 100 (1)
100 x 200 (1)
300 x 200 (1)

Virtual Assistant Supported

Google Assistant (4)
Alexa (1)

Viewable Screen Size

75"" (2)
27"" (1)
43"" (1)
58"" (1)

Additional Information

Legal Disclaimer:
Actual network speed may be limited by the rate of the product's Ethernet WAN or LAN port, the rate supported by the network cable, Internet service provider factors and other environmental conditions.
(4)

Active PFC Compatible : Yes

Replacement Battery Cartridge Quantity : 1

Plug Style : Right Angle - 45° Offset

On Battery Frequency : 60 Hz ± 1%

Automatic Voltage Regulation : Single Boost

On Battery Voltage : 120 VAC ± 5%

USB Charge Port Quantity : 2

USB Charge Port Type COMPUTED : 1 Type A

USB Charge Port Amperage COMPUTED : 3.1 Amps (Shared)

Outlets - Widely Spaced : 2

Overload Protection : Internal Circuitry Limiting

Under/Over-Voltage Correction : +11.5%

Audible Alarms : Battery Mode

HID Compliant USB Port : Yes

LCD : Multifunction LCD

Management Cable : USB Cable

Dry Contacts : Yes

Operating Temperature : 32 - 104 °F (0 - 40 °C)

Operating Relative Humidity : 0 - 95 % (non-condensing)

Operating Elevation : 0 - 10000 ft (0 - 3048 m)

(1)

Standard Refresh Rate

60 Hz (4)
75 Hz (1)

Maximum Resolution

3840 x 2160 (4)
1920 x 1080 (1)

Screen Size Class

75"" (1905 mm) (2)
27"" (1)
43.00"" (1092.20 mm) (1)
58.00"" (1473.20 mm) (1)

Wireless LAN Standard

IEEE 802.11ax (3)
IEEE 802.11ac (1)

Wi-Fi Generation

Wi-Fi 6 (3)
Wi-Fi 5 (1)

Country of Origin

China (2)
Indonesia (2)

Encryption Standard

WPA
WPA2
WPA3
WPA2-ENT
(2)
WEP
WPA
WPA2
(1)
WPA
WPA2
WPA3
WPA-ENT
WPA2-ENT
(1)

Ethernet Technology

Gigabit Ethernet (2)
2.5 Gigabit Ethernet (1)
Fast Ethernet (1)

Operating Power Consumption

260 W (2)
115 W (1)
157 W (1)

Total Number of HDMI Ports

4 (3)
2 (1)

Streaming Service

YouTube
Google Play Movies & TV
Google Play Music
(3)
YouTube
Google Play Movies & TV
(1)

Sound System

DTS HD
Dolby Atmos
Dolby MS12D
Dolby AC-4
DTS StudioSound
(3)
DTS HD
Dolby Atmos
Dolby MS12D
Dolby AC-4
DTS Studio Sound
(1)

Firewall Type

SPI (3)
SPI
NAT
(1)

Network Band

Dual Band (3)
Tri Band (1)

Number of Broadband (RJ-45) Ports

1 (3)
2 (1)

Total Wireless Transmission Speed

375 MB/s (1)
675 MB/s (1)
825 MB/s (1)
93.75 MB/s (1)

Total Number of Antennas

2 (1)
4 (1)
6 (1)
8 (1)

Backup/Run Time (Half Load)

10 Minute (1)
12 Minute (1)
9 Minute (1)

Backup/Run Time (Full Load)

2 Minute (1)
2.50 Minute (1)
3 Minute (1)

Surge Energy Rating

1080 J (1)
1445 J (1)
354 J (1)

Input Voltage Range

5 VDC (1)
88 V AC - 144 V AC (1)
90 V AC - 142 V AC (1)

Number of Battery & Surge Outlets

6 (2)
5 (1)

Load Capacity

1 kVA/600 W (1)
1.50 kVA/1 kW (1)
700 VA/450 W (1)

Waveform Type

Simulated Sine Wave (1)
Sine Wave (1)
Stepped Approximated Sine Wave (1)

Number of External Antennas

4 (1)
6 (1)
8 (1)

Quantity

1 (2)
1 Each (1)

Receptacle Detail

12 x NEMA 5-15R (1)
9 x NEMA 5-15R (1)
3 x NEMA 5-15R
3 x NEMA 5-15R Surge
(1)

Number of Network (RJ-45) Ports

4 (2)
3 (1)

Typical Battery Recharge Time

8 Hour (2)
12 Hour (1)

Input Frequency

63 Hz (2)
60 Hz (1)

Certifications & Standards

UL1778
cUL 107.3
FCC DOC Class B
(1)
NOM (1)

Cord Length

5 ft (1)
6 ft (1)

Dataline Protection

RJ-45
Coax
(1)
RJ-45 (1)

Directly Connected Equipment Guarantee

150000 Lifetime
(1)
500000 Lifetime
(1)

Media Size

Custom Size - 10.98"" (279 mm) x 17.01"" (432 mm)
A3 - 11.69"" (297 mm) x 16.54"" (420 mm)
B4 - 9.84"" (250 mm) x 13.90"" (353 mm)
A8 - 2.13"" (54 mm) x 2.91"" (74 mm)
(1)
Custom Size - 8.50"" (216 mm) x 14.17"" (360 mm)
A8 - 2.05"" (52 mm) x 2.91"" (74 mm)
A4 - 8.27"" (210 mm) x 11.69"" (297 mm)
(1)

Number of Batteries

1.0 (1)
2 (1)

Number of DisplayPorts

1 (1)
3 (1)

Number of Surge-only Outlets

4 (1)
6 (1)

Number of USB Ports

5 (1)
6 (1)

Operating Humidity

0% - 95% (1)
90% (1)

Output Power Factor

0.6 (1)
0.7 (1)

Additional Warranty Information

3 years repair or replace (1)
Connected Equipment Guarantee
Lifetime
(1)

Application Log
Timestamp	Level	Category	Message
06:31:20.840485	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
06:31:20.840774	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
06:31:20.841151	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
06:31:20.841464	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
06:31:20.843993	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
06:31:20.845359	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
06:31:20.846435	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)
06:31:20.847503	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)
06:31:20.848032	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)
06:31:20.848172	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
06:31:20.848714	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
06:31:20.965807	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
06:31:20.965847	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)
06:31:20.966721	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)
06:31:20.968528	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)
06:31:20.969104	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)
06:31:20.969263	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)
06:31:20.969592	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
06:31:20.969609	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)
06:31:20.970110	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)
06:31:20.970215	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)
06:31:20.970432	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
06:31:20.970448	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)
06:31:20.970940	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)
06:31:20.971023	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)
06:31:20.971122	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
06:31:20.973972	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
06:31:20.974206	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
06:31:20.974288	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)
06:31:20.974638	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
06:31:20.974659	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)
06:31:20.975186	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)
06:31:20.975290	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)
06:31:20.975404	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
06:31:20.975419	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)
06:31:20.984220	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
06:31:20.984266	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)
06:31:20.984833	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)
06:31:20.984958	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)
06:31:20.985060	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
06:31:20.985085	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)
06:31:20.985728	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
06:31:20.985749	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)
06:31:20.986268	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)
06:31:20.986366	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)
06:31:21.015455	trace	system.CModule	Loading "widgetFactory" application component in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)
06:31:21.015906	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)
06:31:21.015945	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)
06:31:21.027581	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)
06:31:21.027610	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)
06:31:21.039089	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)
06:31:21.039120	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)
06:31:21.039768	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)
06:31:21.039925	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)
06:31:21.040081	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)
06:31:21.040206	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)
06:31:21.040513	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)
06:31:21.040532	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)
06:31:21.041032	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)
06:31:21.041291	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)
06:31:21.041795	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)
06:31:21.041930	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)
06:31:21.042951	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)
06:31:21.042973	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)
06:31:21.043210	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)
06:31:21.043231	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)
06:31:21.044071	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)
06:31:21.044342	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)
06:31:21.044851	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