OfficeCo

Label printing jobs come fast, accurate and hassle-free with the LabelWriter 550 Label Printer. With its unique Automatic Label Recognition, you always know which labels (by size, type and color) are loaded into the labelmaker at a glance. You'll also know how many labels are remaining so you'll never run out mid-job. Direct thermal printer replaces the need to buy costly ink or toner while the portable size helps it fit into any modern work space with ease. Print precise quantities instead of wrestling with sheet labels. Label printer prints up to 62 labels per minute. Dymo Connect for Desktop software lets you create more than 60 label types through USB connectivity with a Windows and Mac computer.
(3)
48-bit scanning. Optical resolution of 4800 x 4800 ppi. Z-lid for thick documents. One cable for both power and connection. 5 auto buttons: copy, auto scan, PDF, email and send to Cloud. With Auto Scan Mode, the scanner automatically adjusts settings by detecting what you are scanning. Upright scanning. Send to Cloud feature. Dust and scratch reduction. USB connectivity (cable included).

(1)
10 SECOND FAST SCANNING & SEND TO THE CLOUD

Scan documents quickly and easily with fast scanning up to 10 seconds. Even Scan and send your files right to Cloud services, with Send to Cloud feature. With Send to Cloud you can easily upload your photos and documents right to Cloud services like Microsoft OneDrive™ and Dropbox®.

2400 x 2400 dpi Resolution for High Quality Scanning

Digitize documents and images thanks to 2400 x 2400 dpi resolution, and with image enhancements, such as fade correction and dust reduction, your photos will continue to look great.

Enjoy ease of use with the 4 'EZ' buttons. With Auto Scan Mode, the scanner automatically adjusts settings by detecting what you are scanning, and the built-in PDF button, easily scan and save PDF's that are editable and searchable with OCR .
(1)
Explore the New Era of WiFi

AX1800 Dual-Band Wi-Fi 6 Router

Archer AX20

Faster Speeds. More Connected Devices. Powerful Processing.

Dual-Band Wi-Fi 6

Up to 1.8 Gbps Speeds

Connect More, Stay Fast

Quad-Core CPU

Reduced Power Consumption

Refined Password Security

The Wi-Fi 6 Experience

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

Dual-Band Wi-Fi 6 Up to 1.8 Gbps

Every application feels more fluid with drastically improved WiFi speeds. Both 2.4 GHz band and 5 GHz band get upgraded to the latest generation-perfect for 4K streaming, online gaming, and fast downloading.

Extensive WiFi Coverage with Advanced Technologies

Beamforming technology, independent Front-End Module, and four high-gain antennas combine to adapt WiFi coverage to perfectly fit your home and concentrate signal strength towards your devices.

Beamforming

Independent FEM

4Ã— Antennas

Connect More, Stay Fast

Easily handle dozens of devices streaming and gaming at the same time-OFDMA future-proofs your home networks by providing greater capacity to connect more devices.

OFDMA

OFDMA separates a single spectrum into multiple units and enables different devices to share one transmission stream, increasing efficiency and reducing latency.

1.5 GHz Quad-Core CPU (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)
Immersive Sound
Delivers loud and immersive stereo surround sound through two 45mm drivers. Bluetooth 5.0 allows a wireless connection range up to 30 feet. In addition, the TWS Function offers true stereo sound quality without needing cables and wires.
Long Battery Life
Enjoy your music anywhere you go. Supports up to 18 hours of audio with built-in 1800mAh rechargeable batteries.
Waterproof (IPX5)
Perfect for home and outdoor use. Water resistant to rain and splashes, enjoy your music in the living room or poolside.
(1)
Multiple Operating Modes (1)
Printing Made Simple

The PIXMA MG3620 is a Wireless1 Inkjet All-In-One printer that offers convenience and simplicity for all your printing needs. Print and scan from almost anywhere around the house with its wireless capability. Save time and money with great features such as Auto duplex printing and Mobile Device Printing.

The PIXMA MG3620 is amazingly convenient with many ways to print wirelessly. With the Canon PRINT app2 easily print and scan photos and documents directly from your mobile devices. Enjoy printing from your iPad®, iPhone® or iPod® touch with AirPrint3, and from Android devices with Mopria4 and Google Cloud Print.

Print amazingly crisp and clear photos and documents with this printer thanks to a maximum color resolution of 4800 x 1200 dpi6 and the capability to print borderless photos up to 8.5"" by 11."" Additionally, XL ink cartridges allow for more documents and photos to be printed while replacing those cartridges less often.
(1)
Stream Music Wirelessly from Your Smartphone/Tablet

The HA100 provides your stereo with Bluetooth connectivity, enabling you to stream music wirelessly from your smartphone or tablet. You can just sit back and relax as you listen to and control your favorite playlists away from your stereo.

Easy Pair

If your device has NFC functionality, you can simply 'tap' it with the HA100 Music Receiver or the NFC Tag to connect instantly. Alternatively, you can activate your device's Bluetooth and pair it with the HA100 manually. What's more, the receiver remembers up to 8 devices for automatic pairing.

Long Distance

Streams music from up to 20 meters (66 feet) away from the speaker, within direct line of sight.

Broad Compatibility

Bluetooth 4.1, compatible with all A2DP stereo Bluetooth devices. Works with any stereo supporting 3.5mm or RCA jacks.
(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)
The Next Wave of Home Connectivity

AX3000 Gigabit Wi-Fi 6 Router

Archer AX50

WI-FI 6 (1)
Travel Charger 132W GAN technology, Four port USB Type-A and -C, Power Delivery(PD) 3.0 Support

The Club 3D CAC-1906 Travel Charger 132W GAN technology, Four port USB Type-A and -C, Power Delivery(PD) 3.0 Support. This product is a high-performance, low weight travel charger with a maximum output power of 132W. Equipped with 3 USB Type-C ports and 1 Type-A port, the total output supports up to 132W, which can meet the needs of charging four devices at the same time. Compatible with multiple devices (support mobile phones,tablets and laptops). It is a convenient companion during travel and for business! Compact size & Superior Performance: GAN technology makes this charger 50% smaller than a 132W MacBook charger, small enough to carry anywhere.The 132W wall charger match a variety of PD devices from smart phones to laptops, one for all making charging simple. The Power Charger is light weight without compromising on Quality and safety. By adopting Power Delivery(PD) charging technology, this versatile Power Charger provides you with charging function through USB Type-C interface, you can charge any connected Mobilephone / Tablet / NoteBook.

Charging:

By adopting PD 3.0 Charging technology and charging function through USBType-C interface the Club 3D Power Charger offers versatile and unique functionality. It will charge your devices up to 132Watts. Built-in safeguards protect your devices against excessive current, overcharging and overheating.
(1)
Charge your USB-C™ powered devices and a USB™ mobile device simultaneously with this USB-C™ Super Charger. With the Power Delivery 3.0/2.0 technology, it can supply power of 5V/3A, 9V/3A, 12V/3A, 15V/3A, and 20V/4.5A to your USB-C™ devices. Perfect for Apple® MacBook®, iPhone® X/8/8 PLUS, Nintendo Switch™, Nexus™ 5X, Nexus™ 6P and more.

The JUP2290 is equipped with an attached USB-C™ cable and a USB™ Type-A port. You can now charge your mobile device without powering up your laptop/tablet.

The charger works perfectly with the JCD543 USB-C™ Triple Display Docking Station.

Features

Up to 100W fast-charging power for 2 devices

USB-C™ Power Delivery 3.0

USB™ Type-A fast-charging port (max 2.4A)

Built-in intelligent IC to automatically identify the connected devices

Automatically balances output when charging 2 devices at once

Provides up to 87W via the USB-C™ cable and up to 12W for the USB™ Type-A port when charging 2 devices at once.

Surge, overcharging, overcurrent and overheating protection to ensure safe charging

Power Delivery (PD) charging is a fast-charging protocol that is compliant with the safety standards of USB™ charging. PD also offers smart power management across multiple peripherals so each device will only draw the power it requires.

(1)
Digital speaker system offers a 2.0 USB connection for power and advanced digital-quality audio. System requires no other cables. A single, 4' USB cable supplies both audio and power. Compact size delivers high-quality audio without using much space. Satellite-base design offers greater stability on your desktop. Built-in controls allow you to easily adjust volume and include a digital-power indicator. Speakers offer a 90 Hz-20 kHz frequency response and 2"" dynamic drivers. Speaker system includes two speakers with integrated cables.
(1)
Engineered to provide simple, fast and secure Windows log-on and a seamless two-factor authentication experience, the VeriMark Fingerprint Key protects against unauthorized access on compromised devices while also offering unprecedented cyber security for today's cloud-based world. Advanced Fingerprint Technology combines superior biometric performance and 360-degree readability with anti-spoofing protection while exceeding industry standards for False Rejection Rate and False Acceptance Rate. Universal Integration provides scalable, out-of-the-box access for Windows computers and platforms, including biometric log-in for Windows Hello. It is also FIDO U2F Certified to ensure seamless interoperability and meet second-factor security key log-on requirements for cloud-based service and software providers, including Google, Dropbox, GitHub and Facebook. Compact design easily attaches to a standard key ring for convenient portability.
(1)
Play in comfort with the Verbatim Wired Controller. Designed for use with the Nintendo Switch™, this controller easily connects to your console, with the included USB-A to USB-C adapter, and includes a 6 ft. cable to let you sit back and enjoy gaming. This controller also features a vibration function for more realistic game play. Relax and play for longer with the Verbatim Wired Controller. The Verbatim Wired Controller for use with Nintendo Switch™ is backed by a 1-Year Limited Warranty.
(1)
Play in comfort with the Verbatim Wireless Controller. Designed for use with the Nintendo Switch™, this controller connects wirelessly to your console and features a 2.4Ghz connection for lag-free performance. This controller also features a vibration function for more realistic game play. Easily charge the controller with the included microUSB cable, keeping it charged even on-the-go. Relax and play for longer with the Verbatim Wireless Controller. The Verbatim Wireless Controller for use with Nintendo Switch™ is backed by a 1-Year Limited Warranty.
(1)
Put PC gaming in the palm of your hand with The Authentic C.A.T. 7 Wired Game Controller.

This controller features 25 buttons, including all of your familiar controls as well as unique, multifunctional buttons. Customize button functions directly from the controller using the 2 configurations buttons and OLED display. Ergonomic grips mean the C.A.T. 7 sits comfortably in your hands and won't strain your grip, even after hours of gameplay.

Plug in this controller and get to your game with the included USB-A to microUSB cable. Compatible with Windows Direct/X-inputs and the PS3™, this controller is ready when you are.
(1)
The TI-84 Plus calculator offers a built-in USB port, an improved display and preloaded applications designed to maximize student performance in numerous subjects including geometry, statistics, algebra, physics, chemistry, biology and others. Preloaded calculator software applications include topics in Algebra 1 and Vernier EasyData and many others. Offers 480K of FLASH memory, 24K of available RAM memory, internal clock with date and time display, 14 interactive zoom features, and 8-line by 16-character display. Also includes TI Connectivity Cable. Built-in USB port and external cable allow easy, fast data transfers between linked calculations and computers, as well as unit-to-unit file sharing capabilities. Calculator graphs 10 rectangular functions, six parametric expressions, six polar expressions, and three recursively defined sequences. Powered by four AAA batteries with a Silver Oxide battery backup to protect RAM memory during main battery change.
(1)
The dashport r1240 mini, although miniature in size, packs enough power-12W (5V, 2.4A)-to rapidly charge a tablet or smartphone.
(1)
This USB C Power Delivery charger provides next-generation technology that can fast charge your USB Type-C phone, tablet, or laptop that requires up to 60W.

Wide Compatibility

This USB-C wall charger is compatible with a vast array of USB Type-C devices such as the MacBook Pro 13-inch, XPS 13, Surface Book 2 and Lenovo ThinkPad X1 Carbon. A 3-foot (1 meter) USB-C to USB-C cable is included but the USB-C AC adapter is also compatible with other cable lengths.

While the USB Type-C power adapter is compatible with any USB-C Power Delivery device, it is recommended to use it with devices that require 60W or less for optimal charging performance.

Safe Charging

The USB-C portable charger comes with multiple forms of protection for your devices such as over-temperature protection, over-current protection, over-voltage protection and short-circuit protection.

The Choice of IT Pros Since 1985

StarTech.com conducts thorough compatibility and performance testing on all our products to ensure we are meeting or exceeding industry standards and providing high-quality products to IT Professionals. Our local StarTech.com Technical Advisors have broad product expertise and work directly with our StarTech.com Engineers to provide support for our customers both pre and post-sales.

WCH1C is backed by a StarTech.com 2-year warranty and free lifetime technical support.

(1)
This USB C Power Delivery charger provides next-generation technology that can fast charge your USB Type-C phone, tablet, or laptop that requires up to 60W.
Wide Compatibility
This USB-C desktop charger is compatible with a vast array of USB Type-C devices such as the MacBook Pro 13-inch, XPS 13, Surface Book 2 and Lenovo ThinkPad X1 Carbon.

While the USB Type-C power adapter is compatible with any USB-C Power Delivery device, it is recommended to use it with devices that require 60W or less for optimal charging performance.
Safe Charging
The USB-C portable charger comes with multiple forms of protection for your devices such as over-temperature protection, over-current protection, over-voltage protection and short-circuit protection. The USB C wall charger is designed with durability in mind. Our extensive durability testing ensures that the USB PD charger can withstand the rigors of travel.
USB A Charging
3 built in USB-A ports allow you to charge other devices at the same time as your USB-C device. Replace multiple chargers with a single charger that works will all your battery-powered devices.
The Choice of IT Pros Since 1985
StarTech.com conducts thorough compatibility and performance testing on all our products to ensure we are meeting or exceeding industry standards and providing high-quality products to IT Professionals. Our local StarTech.com Technical Advisors have broad product expertise and work directly with our StarTech.com Engineers to provide support for our customers both pre and post-sales.

DCH1C3A is backed by a StarTech.com 2-year warranty and free technical support.

(1)
Upgrade your handheld experience with the Verbatim Pro Controller with Console Grip.

Designed for use with the Nintendo Switch™, this plug-and-play controller features 12 buttons for a wide range of functionality along with 6-axis motion controls for even more ways to play. The dual-vibration motors give you more realistic game play while the textured, anti-slip feel keeps your hands comfortable.

This plug-and-play controller charges quickly and easily using a USB-C™cable and is backed by a 1-Year Limited Warranty.

(1)
Business Expert Connected Label Maker features high-resolution printing for sharper bar codes, logos and more. Create labels using your computer or mobile phone via Bluetooth with P-touch Editor Software1 and Brother iPrint app. Advanced connectivity allows multiple users with their own device to work with the same labelmaker. Increase efficiency on high-volume labeling jobs with faster printing and built-in, automatic label cutter. Its maximum printing speed is 20mm per second. Enjoy sharp, vivid 180 dpi resolution. Easily type using quick, one-touch formatting keys and large 20-character, two-line screen preview. Choose between 16 fonts, 15 font styles, 140 frames, 800 symbols and 40 pre-set label templates. High memory capacity saves up to 70 used labels. Labelmaker uses 3/4"" thick tape and Brother Genuine TZe Label Tapes for indoor and outdoor label versatility. Power with AC adapter (included) or six AAA batteries (not included). (1)
Business Professional Connected Label Maker features high-resolution printing for sharper bar codes and more with full-color LCD screen. Create labels using your computer or mobile phone via Bluetooth with P-touch Editor Software1 and Brother iPrint app. Advanced connectivity allows multiple users with their own device to work with the same label maker. Increase efficiency on high-volume labeling jobs with faster printing and built-in automatic label cutter. Its maximum printing speed is 30mm per second. Enjoy sharp, vivid 180 x 360 dpi resolution. Easily type using the QWERTY keyboard, one-touch formatting keys and large 20-character, two-line screen preview. Choose between 17 fonts, 17 font styles, 160 frames, 900 symbols and 175 pre-set label templates. Increased memory capacity saves up to 90 used labels. It prints up to 99 copies. Labelmaker uses 1"" tape and is compatible with Brother Genuine TZe Label Tapes for indoor and outdoor label versatility. (1)
Compact, wireless charging pad for MagSafe blends in around the office. This sleek, charging pad is easy to attach and remove and refuels iPhone fast while keeping it at hand for ultimate productivity. 15W Qi-compatible wireless charger delivers optimal 7.5W charging speeds. (1)
Get your game on and turn up the sound of victory with the Verbatim® Stereo RGB Desktop Gaming Speakers!

These speakers deliver rich bass and clear treble, with 10W output power, to bring you high quality sound as you play your favorite game. Choose from five, 16.8 M RGB lighting modes to personalize your gaming experience with different colors. Use the one-touch switching feature to connect your computer, tablet, or smartphone via Bluetooth 5.0 or 3.5mm AUX-In connection.

The Verbatim® Stereo RGB Desktop Gaming Speakers are backed by a 1-year limited warranty. (1)
High-speed label printer helps you quickly tackle labeling tasks in your busy office without requiring any ink or toner. The super-fast print speed of up to 93 standard address labels per minute helps you save time on big projects. High-resolution printing (up to 300 x 600 dpi) delivers crisp text and graphics for impressive results. Whether you print one label or multiple labels at a time, the convenient automatic cutter keeps you working efficiently. Plug-and-Label software is built-in to quickly type and print labels without installing software. Or, install the included P-touch Editor software to create more elaborate labels. Printer is perfect for creating cost-effective labels for packages, envelopes, file folders, name badges, postage and more. Label printer is compatible with Microsoft Word, Excel and Outlook (sold separately).
(1)
Home/Office Advanced Label Maker is a versatile, easy-to-use way to organize your home or office. Connect it to a PC or Mac with included USB cable and create labels using P-touch Editor Software1. Simply use the QWERTY keyboard and quick, one-touch formatting keys to quickly print your labels. Organize the contents of your desk and more using up to 3/4"" thick labels. It is also compatible with 12mm, 9mm, 6mm, 3.5mm and 18mm tapes. Use Genuine Brother TZe Label Tapes for indoor and outdoor versatility. Select between 15 fonts, 13 font styles, 120 frames, 700 symbols and 30 pre-set label templates for professional, unique labels. Preview labels to avoid errors before printing with the 15-character, two-line display screen. Labels print with sharp, 180 dpi print resolution. Print labels up to 20mm per second. Memory bank saves up to 50 frequently used labels. Power this desktop labelmaker using AC adapter (included) or six AAA batteries (not included). (1)
Label maker offers flexible connectivity with built-in 802.11b/g/n to share with others on your wireless network, or USB interface to connect locally to a single user. Print customized labels up to 24mm wide - for indoor or outdoor use - with fonts and graphics from your PC or Mac. Print labels from your mobile device using Brother iPrint&Label app download. NFC connectivity lets you ""touch to connect"" to establish contact with most NFC-capable mobile devices. High print resolution supports crisp graphic, bar-code and logo printing. Do more in less time with super-fast print speeds and automatic half or full cutting support efficient multi-label printing. A vast assortment of templates can be downloaded from the Brother Cloud to help save time in creating labels. Power with the included AC adapter. The PT-P750W includes 0.94"" (24mm) x 13.1' (4m) TZe starter tape and a USB cable.
(1)
LabelManager 280P delivers labels faster with time-saving features. Customize labels with any fonts and graphics on your computer through PC or Mac connection. Type text quickly on the computer-style (QWERTY) keyboard with country-specific layout. Avoid the cost and waste of disposable batteries with the included rechargeable battery pack. Edit text easily with one-touch fast-formatting keys. Label printer prints fast and uses Dymo D1 labels in 1/4"" , 3/8"" and 1/2"" widths. Display size is 14 characters x 2 lines. Maximum print height is 22.7 point. LabelManager 280P also features a manual tape cutter, three fronts, six type sizes, seven styles, 221 symbols, repeat printing, auto numbering, and mirror/vertical printing. Label printer includes a charging cable, and black/white starter D1 cassette.
(1)
Labelmaker provides an economic labeling solution to meet a variety of home, home office and small office applications. Choose from pre-sized paper labels and continuous tapes that are perfect for everyday uses. Built-in automatic cutter provides a clean, accurate edge that allows you to create custom labels quickly and easily. Labelmaker connects to both PC and Mac computers with the included USB cable and can print up to 44 labels per minute so you get the labels you need, when you need them. It prints crisp, high-resolution labels at up to 300 x 600 dpi so it's great for creating professional labels including mailing and shipping labels, small signage, banners, filing tags and more. Print one, a few or hundreds of labels at a time along with banners up to 3' long without ever needing to worry about ink or toner. (1)
Mobile document scanner combines convenient portability with fast scan speeds and image optimization features for easy use on the road or in your home or small office. Fast scan speeds allow you to scan color and black/white documents at up to 16 pages per minute. Micro USB 3.0 cable connects to your laptop or PC to scan from virtually anywhere. Included software suite allows you to scan to multiple destinations to keep your business moving. Document scanner allows you to scan a variety of documents including invoices and receipts up to 72"" long and on paper up to 72 lb. bond weight. Easily scan business cards and plastic ID cards through the same location as other documents.
(1)
Professional Presenter R800 gives you powerful control for high-impact presentations. Green laser pointer is easy to see, even on flat panel displays, projection screens, and in brightly lit rooms. 2.4 GHz wireless technology offers a range of up to 100' (30m). LCD screen with a timer lets you manage your time with silent, vibrating alerts and has controls that are easy to set and adjust. LCD screen also indicates battery power and reception level. Presenter includes a storable plug-and-play wireless receiver, intuitive controls, two AAA batteries and a carrying case. Presenter requires a USB port and Windows XP, Windows Vista, or Windows 7.
(1)
The P-touch CUBE Plus label maker features Bluetooth® wireless technology that allows you to wirelessly print labels up to 24mm (~1 inch) wide from your smartphone, tablet or laptop. The USB cable provided also lets you print from a desktop. The P-touch CUBE Plus works with P-touch Editor software, allowing you to quickly create labels from your PC. P-touch CUBE Plus also works with the FREE Brother iPrint&Label app (Wireless connection required) and P-touch Design&Print2 app (Wireless connection required) from your mobile devices so you can print labels your way. P-touch Design&Print2 (Wireless connection required) app Share Label template lets you quickly and easily create custom QR codes for unique, personalized messaging on your labels. Select from a wide assortment of pre-designed home and home office templates along with new templates created for retail store and crafting businesses to help make your products stand out. Its sleek, stylish design makes it an attractive addition to your retail store, crafting business, home or office.
(1)
The affordable Brother MFC-J1010DW is an ideal color inkjet all-in-one printer for your home, home office or small office. It includes robust features and business-centric functionality not normally found in similarly priced inkjet printers plus print speeds up to 17 ppm for black and white and 9.5 ppm for color.⁵ The MFC-J1010DW is easy to connect and operate along with being compact and economical, perfect for small spaces and budgets. This wireless printer has multiple flexible connection options, including a built-in wireless interface for sharing with multiple users on your network, Wi-Fi Direct® or connect locally to a single computer via a USB interface. Delivering high quality, reliable printing, copying, scanning and faxing and enabling wireless printing from your desktop, laptop, smartphone or tabletÂ¹. Use the 1.8"" color display to easily navigate on screen menus. This printer features the Brother Mobile Connect App, a user-friendly interface that gives you the freedom to print and manage your printer from virtually anywhere. The MFC-J1010DW also features the unique Brother Page GaugeÂ³ which estimates remaining page levels, so you always know how much ink you have left. Use the 20-page capacity automatic document feeder or the 150-sheet capacity adjustable paper tray for generous output without constant monitoring. Two-sided printing helps save paper, while mobile device printingÂ¹ and Cloud connectivity let you print-from and scan-to popular Cloud services directly from the device. Comes with a 1-year limited warranty and free online, live chat or phone support for the life of the printer. Works with Alexa.

Disclaimers:
1. Requires connection to a wireless network.
2. Requires connection to a wireless network. Brother Mobile Connect free app download is not available in all countries.
3. Page Gauge is an estimate for informational purposes only. For actual cartridge yield information refer to www.brother.com/pageyield.
4. Requires an Internet connection and an account with desired service.
5. Based on ISO/IEC 24734 (after first set of ISO test pages). For inkjet print speed methodology, please visit www.brother-usa.com/printspeed. (1)
This Lenovo 65W Standard AC Adapter (USB Type-C) Power Adapter offers fast, efficient charging at home, in the office, or on the go. This power adapter is compatible with ThinkPad USB-C enabled Notebook and Tablet.Smart Voltage: Its PD technology automatically detects and delivers 5V/2A,9V/2A ,15V/3A or 20V/3.25A Tested and reliable: tested, reliable and backed by a one year limited warranty (1)
Three-Year Warranty
AOC stands behind the quality of each and every monitor with a generous three-year warranty starting from the original date of purchase. Within the warranty period, any AOC displays with manufacturing defects or faulty components will be repaired or replaced at no additional charge. Read the complete AOC warranty statementfor more information.

USB monitor

Discover the freedom and flexibility of AOC's myConnect USB monitors. A single USB cable connects your laptop to the directly to the display, completely eliminating the need for extra media cables and a power supply. The USB cable transfers data to the screen, plus acts as an energy-efficient power source. For work or play, these monitors offer optimal portability. Besides ultra-easy connectivity, the innovative stand offers you a variety of viewing options.
(1)
Turn any home office workspace into a conference room. The easy-to-use, all-in-one Poly Sync 10 USB speakerphone delivers high-quality audio for both professional and personal use. Perfect for both voice and music, its two-microphone steerable array reduces surrounding noise. And with clear, understandable touch controls and LED indicators, expect foolproof conference calls. Simply plug-and-play-your choice of USB-A and USB-C connection powers it. Resistant to water and dust, it's even certified for seamless use with Zoom and Microsoft Teams. If you're still using the speakers and mic on your laptop, you're seriously missing out.

Enterprise-grade hi-fi audio and power amplifier.

USB-A cable with an USB-C adapter included.

Powered by USB connection.

IP64 dust-and water-resistant.

Slim, space-saving design.

(1)

Package Contents

AX3000 Dual Band Gigabit Wi-Fi 6 Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(2)

1 Port USB-C Desktop Charger with 60W Power Delivery - 3 USB Ports

1 x Power Cord (NA)

1 x Quick Start Guide

(1)

1 Port USB-C Wall Charger with 60W of Power Delivery

1 x USB-C Cable

(1)

1 x Pro Controller

2 x Additional Thumbsticks

1 x User Manual

(1)

100W PD USB-C Super Charger

3.3 ft/100 cm Detachable US/EU/UK Power Cord

(1)

300Mbps Wireless N Nano Router

Power Adapter

USB Cable

RJ45 Ethernet Cable

Quick Installation Guide

Resource CD

(1)

AC Adapter

1 x RED (Power ONLY) USB Type-C Cable(1 m / 3.28 ft)

1 x Powercord

(1)

AC Adapter

Warranty Poster

AC Power Cord

(1)

AC750 Wireless Travel Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

AX1800 Dual-Band Wi-Fi 6 Router

Power Adapter

RJ45 Ethernet Cable

Quick Installation Guide

(1)

Bluetooth Music Receiver

Power Adapter

3.5mm-to-3.5mm AUX cable

3.5mm-to-RCA cable

NFC Tag

Quick Installation Guide

(1)

CanoScan LiDE 400 Scanner

USB Cable

(1)

Compact Mobile Document Scanner

Micro USB 3.0 Cable

Quick Setup Guide

Product Safety Guide

Calibration Sheet

Warranty Sheet

Registration Card

Warranty International Sheet

BR-Receipts Insertion

(1)

E1659FWU 16-Inch Class USB-Powered Monitor

Base

Carry case

USB 3.0 Cable

Quick Start Guide

(1)

P-touch PTP710BT Direct Thermal Printer

USB Cable

UGs

(1)

PIXMA MG3620 Wireless Inkjet All-In-One Printer

Manuals and other documents

Setup CD-ROM

FINE Cartridges (Black and Color)

Power Cord

(1)

PTD410 Label Maker

1 x Black on White Laminated TZe Sample Label Tape 0.70"" (18mm) x 13.1' (4m)

AC Power Adapter

USB Cable (Micro, 1m, Black)

Documentation

(1)

PTD460BT Label Maker

1 x Black on White Laminated TZe Sample Label Tape 0.70"" (18mm) x 13.1' (4m)

AC Power Adapter

USB Cable (Micro, 1m, Black)

Documentation

(1)

PTD610BT Label Maker

1 x Black on White Laminated TZe Sample Label Tape 0.94"" (24mm) x 13.1' (4m)

AC Power Adapter

USB Cable (Micro, 1m, Black)

Documentation

(1)

Professional Presenter R800

Wireless mini-receiver

2 AAA batteries

Carrying case

Quick-start guide

(1)

QL-600 Label Printer

DK-2205 Tape Cassette

AC Power Code

PSG

QSG

Warranty Card

USB Cable

(1)

RGB Gaming Stereo Desktop Speakers - Graphite

1 x USB-C to USB-A Cable

1 x 3.5mm AUX Cable

1 x User Manual

Wall Adapter

(1)

Sync 10 Speakerphone

USB-C Adapter

(1)

The Authentic C.A.T. 7 Wired Game Controller - Black

1 x Braided USB-A to microUSB Cable

Quick Start Guide

Technical Support and Warranty Information

1 x Logo Sticker

(1)

Wired Controller for use with Nintendo Switch - Black

1 x USB-A to USB-C Adapter

(1)

Wireless Controller for Use With Nintendo Switch - Black

MicroUSB cable

(1)
Portable Wireless Speaker
USB Charging Cable
(1)
Compact Label Maker with Wireless Enabled Printing
USB Cable
Software CD
AC Cable
AC Power Adapter
User's Guide
Black on White Standard Laminated TZe Starter Tape 0.94"" (24mm) x 13.1' (4m)
(1)
LabelManager 280 Label Maker
Rechargeable Battery Pack
USB Cable
D1 Starter Label Cassette Black on White 1/2"" x 10'
Quick Start and Reference Guides
Charging Adapter
(1)
S-150 USB Digital Speaker System with 2 speakers
Installation Guide
(1)
TI-84 PLUS Graphic Calculator
TI Connectivity Cable
(1)

Depth

5.30"" (134.62 mm) (3)
7.36"" (187 mm) (3)
0.22"" (5.59 mm) (1)
0.90"" (22.86 mm) (1)
1.20"" (30.48 mm) (1)
1.26"" (32 mm) (1)
1.29"" (32.77 mm) (1)
11.90"" (302.26 mm) (1)
2.20"" (55.88 mm) (1)
2.37"" (60.20 mm) (1)
2.38"" (60.50 mm) (1)
2.50"" (63.50 mm) (1)
2.64"" (67 mm) (1)
2.64"" (67.06 mm) (1)
2.70"" (68.58 mm) (1)
3.90"" (99.06 mm) (1)
4.02"" (102 mm) (1)
4.25"" (108 mm) (1)
6.30"" (160.02 mm) (1)
7"" (177.80 mm) (1)
7.17"" (182 mm) (1)
7.5"" (1)
7.70"" (195.58 mm) (1)
8.40"" (213.36 mm) (1)
8.70"" (221 mm) (1)

Height

1.50"" (38.10 mm) (4)
5.35"" (136 mm) (3)
2.80"" (71.12 mm) (2)
0.40"" (10.16 mm) (1)
0.70"" (17.78 mm) (1)
0.73"" (18.50 mm) (1)
0.87"" (22.10 mm) (1)
0.9"" (1)
1.10"" (27.94 mm) (1)
1.12"" (28.50 mm) (1)
1.28"" (32.50 mm) (1)
2.20"" (55.88 mm) (1)
2.32"" (58.93 mm) (1)
2.36"" (60 mm) (1)
2.70"" (68.58 mm) (1)
3.40"" (86.36 mm) (1)
4.29"" (109 mm) (1)
5.04"" (128 mm) (1)
5.60"" (142.24 mm) (1)
6.02"" (153 mm) (1)
6.20"" (157.48 mm) (1)
8"" (203.20 mm) (1)
9.21"" (233.93 mm) (1)

Width

5"" (127 mm) (4)
10.20"" (259.08 mm) (3)
2.20"" (55.88 mm) (2)
2.70"" (68.58 mm) (2)
5.04"" (128 mm) (2)
0.60"" (15.24 mm) (1)
1"" (25.40 mm) (1)
1.81"" (46 mm) (1)
14.80"" (375.92 mm) (1)
2"" (50.80 mm) (1)
2.60"" (66.04 mm) (1)
2.62"" (66.50 mm) (1)
2.91"" (73.91 mm) (1)
3.3"" (1)
3.39"" (86 mm) (1)
3.51"" (89.20 mm) (1)
4.50"" (114.30 mm) (1)
4.90"" (124.46 mm) (1)
7.40"" (187.96 mm) (1)
8"" (203.20 mm) (1)
8.90"" (226.06 mm) (1)

Country of Origin

China (23)
Philippines (5)
Taiwan (1)

Quantity

1 Each (17)
1 (11)

Limited Warranty

2 Year (14)
1 Year (11)
3 Year (1)
5 Year (1)

Product Model

550 (3)
280 (1)
AX20 (1)
AX50 (1)
AX55 (1)
DS-640 (1)
E1659FWU (1)
HA100 (1)
JUP2290 (1)
LIDE 300 (1)
MFC-J1010DW (1)
MG3620 (1)
PT-D460BT (1)
PT-D461BT (1)
PT-P750w (1)
PTD410 (1)
PTP710BT (1)
QL-600 (1)
QL800 (1)
R800 (1)
S-150 (1)
SP-SX3BT (1)
TI-84 Plus (1)
TL-WR802N (1)
TL-WR902AC (1)

Weight (Approximate)

640 g (3)
1.09 kg (1)
1.12 kg (1)
1.15 kg (1)
222.3 g (1)
224 g (1)
280 g (1)
302.5 g (1)
311.8 g (1)
395 g (1)
425 g (1)
466.7 g (1)
487 g (1)
56.7 g (1)
61 g (1)
670 g (1)
7.44 kg (1)
757.5 g (1)
766.6 g (1)
997.9 g (1)

Product Color

Black (16)
White (2)
Black
Silver
(1)
Silver
Black
(1)
Graphite (1)
Gray (1)

Product Line

P-touch (5)
Archer (3)
LabelWriter (3)
CanoScan (2)
DSMobile (1)
LabelManager (1)
PIXMA (1)
Pro Controller (1)
Sync 10 (1)
VeriMark (1)

Power Source

Battery (4)
Battery
Power Adapter
(3)
AC Supply (3)
Power Adapter (3)
USB (2)
Power Adapter
Battery
(1)
USB
Power Adapter
(1)
DC Power (1)

Platform Supported

PC
Mac
(9)
Nintendo Switch (3)
Mac
PC
(2)
PC
Android
Mac
iOS
(1)
PC
Handheld
Mac
(1)
PlayStation 3
PC
(1)

Media Type

Label (4)
Tape
Label
(2)
Tape (2)
Label
Adhesive Tape
Laminated Tape
Flexible Tape
Fabric Tape
Tamper Evident Tape
Super Narrow Non-laminated Tape
(1)
Label
Continuous Paper
Die-cut Label
(1)
Label
Name Badge Label
CD/DVD
Film
Removable Label
Non-adhesive Tag
(1)
Letter
Photo
Plain Paper
Book
Magazine
(1)
Plain Paper
Inkjet Paper
Coated Paper
Glossy Paper
Recycled Paper
(1)
Plain Paper
Receipt
Business Card
Plastic Card
Laminated Card
Embossed Card
ID Card
(1)
Plain Paper
Super High Gloss Paper
Photo Paper Pro Platinum
Glossy Photo Paper
Photo Paper Plus Glossy II
Semi-gloss Photo Paper
Pro Luster Photo Paper
Matte Photo Paper
Envelope
(1)

Maximum Print Resolution (dpi)

180 (4)
300 (3)
300 x 600 (2)
180 x 360 (1)
4800 x 1200 (1)
6000 x 1200 (1)

Input Voltage

120 V AC
230 V AC
(9)
12 V DC (1)
5 V DC (1)
5 V DC
9 V DC
12 V DC
(1)

Features

QWERTY
Manual Cutter
Label Length Setting
Auto Numbering
Horizontal Alignment
Vertical Printing
Mirror Printing
Built-in Designs Template
Auto Power Off
Barcode Printing
(2)
Answer Call
Mute
Volume Control
Microsoft Teams Button
Echo Cancellation
(1)
Auto-cutter
Icon-graphics
Vertical Printing
Mirror Printing
Near Field Communication (NFC) Compatible
Wi-Fi Direct
(1)
Magnetic
Durable
(1)
QWERTY
Auto-cutter
Label Length Setting
Horizontal Alignment
Vertical Printing
Mirror Printing
Built-in Designs Template
Auto Power Off
Barcode Printing
(1)
QWERTY
Underline
Auto Power Off
(1)
True Wireless Stereo (TWS)
USB Charging Port
(1)
Two-factor Authentication (2FA)
Anti Spoofing
(1)
LED Indicator (1)
RGB Lighting (1)
Ultra Slim (1)

Form Factor

Desktop (9)
Handheld (1)
Portable (1)

Maximum Output Power

12 W (2)
20 W (2)
60 W (2)
100 W (1)
111 W (1)
132 W (1)
45 W (1)
65 W (1)

Connectivity Technology

Wireless (5)
Wired (3)
Cable (2)
Cable
Wireless
(1)

Device Supported

Tablet PC
Smartphone
(2)
Smartphone (2)
Mobile Device
iPhone
MacBook
Gaming Console
Notebook
Tablet PC
USB Type C Device
USB Type A Device
MP3 Player
Camera
(1)
Mobile Phone
Tablet
Smartphone
Notebook
USB Type A Device
USB Type C Device
(1)
Notebook
Tablet PC
(1)
Smartphone
Tablet PC
(1)
USB Type C Device
Tablet PC
Smartphone
Notebook
MacBook Pro
(1)
USB Type C Device
Tablet PC
Smartphone
Notebook
MacBook
iPhone
(1)

Maximum Mono Print Speed

1 lps (3)
30 mm/s (3)
20 mm/s (2)
1.6 lps (1)
71 mm/s (1)

Environmental Certification

RoHS (3)
RoHS
WEEE
(2)
RoHS
WEEE
REACH
(2)
ENERGY STAR 6.0
RoHS
(1)
RoHS
REACH
WEEE
(1)
EPEAT Silver (1)

Recommended Use

Label Print (7)
Photo Print (1)
Plain Paper Print (1)

Print Color Capability

Monochrome (6)
Color (3)

Media Size

2"" (50.80 mm) (1)
0.24"" (6 mm) x TZe Tape
0.35"" (9 mm) x TZe Tape
0.47"" (12 mm) x TZe Tape
0.71"" (18 mm) x TZe Tape
0.94"" (24 mm) x TZe Tape
0.14"" (3.50 mm) x TZe Tape
(1)
1.14"" (29 mm) x 3.54"" (90 mm)
2.44"" (62 mm) x 3.94"" (100 mm)
0.67"" (17 mm) x 3.43"" (87 mm)
0.67"" (17 mm) x 2.13"" (54 mm)
2.28"" (58 mm) x CD/DVD
1.50"" (38 mm) x 3.54"" (90 mm)
2.44"" (62 mm) x 1.14"" (29 mm)
0.94"" (24 mm)
0.47"" (12 mm)
0.91"" (23 mm)
2.36"" (60 mm) x 3.39"" (86 mm)
2.44"" (62 mm)
1.14"" (29 mm)
1.97"" (50 mm)
1.50"" (38 mm)
2.13"" (54 mm)
0.91"" (23 mm) x 0.91"" (23 mm)
(1)
A4 - 8.27"" (210 mm) x 11.69"" (297 mm)
Custom Size - 8.50"" (215.90 mm) x 11.70"" (297.18 mm)
(1)
Envelope No. 10 - 4.80"" (121.92 mm) x 9.50"" (241.30 mm)
Photo - 4"" (101.60 mm) x 6"" (152.40 mm)
5"" (127 mm) x 7"" (177.80 mm)
Legal - 8.50"" (215.90 mm) x 14"" (355.60 mm)
Letter - 8.50"" (215.90 mm) x 11"" (279.40 mm)
(1)
Letter - 8.50"" (215.90 mm) x 11"" (279.40 mm)
Legal - 8.50"" (215.90 mm) x 14"" (355.60 mm)
Executive - 7.25"" (184.15 mm) x 10.50"" (266.70 mm)
A5 - 5.80"" (147.32 mm) x 8.30"" (210.82 mm)
A6 - 4.10"" (104.14 mm) x 5.80"" (147.32 mm)
C5 Envelope - 3.37"" (85.60 mm) x 9"" (228.60 mm)
Com10 Envelope - 4.80"" (121.92 mm) x 9.50"" (241.30 mm)
DL Envelope - 4.30"" (109.22 mm) x 8.60"" (218.44 mm)
Monarch Envelope
Photo - 4"" (101.60 mm) x 6"" (152.40 mm)
Photo-2L - 5"" (127 mm) x 7"" (177.80 mm)
Index Card - 5"" (127 mm) x 8"" (203.20 mm)
(1)
Plastic Card - 3.40"" (86.36 mm) x 3.40"" (86.36 mm)
Custom Size - 72"" (1828.80 mm) x 72"" (1828.80 mm)
(1)
Roll - 2.44"" (61.98 mm) (1)

Maximum Output Current

3 A (4)
2.40 A (1)
3.25 A (1)
4.50 A (1)
5 A (1)

Application/Usage

Desktop (2)
Healthcare
Warehouse
Small Business
Educational Institution
Logistics
Hospitality
(1)
Home
Office
(1)
Home
Office
Small Office
Healthcare
Warehouse
(1)
Music
Pool
Outdoor
(1)
Small Office
Healthcare
Warehouse
Educational Institution
Logistics
Hospitality
(1)

Product Series

PT (3)
QL (2)
MFC (1)
MG (1)

Compatibility

Compatible Products:

Apple MacBook 15""/16""

Apple iPhone X/8/8 PLUS

Nintendo Switch

Google Nexus 5X

Google Nexus 6P

(1)
iPhone
(1)

Apple MacBook Pro 13-inch

Dell XPS 13 Notebook

Microsoft Surface Book 2 Notebook

Lenovo ThinkPad X1 Carbon Notebook

(1)

Apple iPhone with MagSafe

Otter MagSafe Cases:

Defender Series XT

Defender Series XT Pro

Symmetry Series+

Aneu Series

Figura Series

(1)

Computer

Tablet

Smartphone

(1)

Lenovo ThinkPad X1 Carbon Notebook

MacBookPro 13-inch

Dell XPS 13

Microsoft Surface Pro

Apple iPhone 12 Pro

Apple MacBook Air

Dell Pro 13

(1)
Notebook (1)

Wireless LAN Standard

IEEE 802.11ax (3)
IEEE 802.11ac (1)
IEEE 802.11b/g/n (1)
IEEE 802.11n (1)

Maximum Print Width

2.20"" (3)
0.71"" (1)
0.94"" (1)
2.40"" (1)

Output Voltage

5 V DC
9 V DC
12 V DC
15 V DC
20 V DC
(3)
5 V DC (1)
5 V DC
9 V DC
15 V DC
20 V DC
(1)
5 V DC
9 V DC
15 V DC
20 V DC
12 V DC
(1)

Total Number of Antennas

4 (3)
2 (2)

Wi-Fi Generation

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

Encryption Standard

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

Optical Resolution (dpi)

1200 (2)
2400 (1)
4800 (1)
600 (1)

Total Wireless Transmission Speed

375 MB/s (2)
230.40 MB/s (1)
37.50 MB/s (1)
93.75 MB/s (1)

Certifications & Standards

GS
(1)
Energy Star
(1)
FIDO U2F Certified
(1)
cCSAus
cTUVus
CE
FCC
cTUVus
(1)
Wi-Fi (1)

Additional Warranty Information

1 Year Limited
(1)
2 Year Limited Warranty & Replacement Service
(1)
2 years
(1)
2-Year Limited
(1)
3 Years
(1)

Battery Size Supported

AA (4)
AAA (1)

Network Band

Dual Band (4)
Single Band (1)

Firewall Type

SPI (4)
SPI
NAT
(1)

Ethernet Technology

Gigabit Ethernet (3)
Fast Ethernet (2)

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.
(3)
Light, compact design for portability
Satellite base design
Driver Size: 2""
(1)

Scan Color

Color (2)
Color
Grayscale
(1)
Color
Monochrome
Grayscale
(1)

Battery Included

No (3)
Yes (1)

Number of Display Lines

2 (3)
8 (1)

Wireless LAN

Yes (3)
No (1)

Cables Included

USB (2)
USB
AC
(1)

Wireless Print Technology

Apple AirPrint
Mopria
Google Cloud Print
Wireless PictBridge
Canon Mobile Printing
(1)
Wi-Fi Direct
Brother Mobile Connect
Apple AirPrint
Mopria
(1)
Brother iPrint&Label (1)

Buttons & Controls

1 x X Button
1 x A Button
1 x B Button
1 x Y Button
1 x + Button
1 x - Button
1 x Home Button
1 x D-pad
2 x Thumb Stick
(1)
1 x X Button
1 x Y Button
1 x A Button
1 x B Button
1 x + Button
1 x - Button
1 x 4 Button Control Panel
2 x Thumb Stick
(1)
2 x 8-way Thumb Stick
X Button
B Button
Z Button
A Button
4-way D-pad
Start Button
Back Button
Home Button
L Button
R Button
Left Trigger
Right Trigger
2 x Configuration Button
K1 Button
K2 Button
K3 Button
K4 Button
K5 Button
K6 Button
X-D Switch
Backlit Switch
(1)

Tape Width Supported

0.14"" (3.50 mm)
0.24"" (6 mm)
0.35"" (9 mm)
0.47"" (12 mm)
0.71"" (18 mm)
(2)
0.14"" (3.50 mm)
0.24"" (6 mm)
0.47"" (12 mm)
0.71"" (18 mm)
0.94"" (24 mm)
(1)

RMS Output Power

1.2 W (1)
10 W (1)
20 W (1)

Number of Display Characters

20 (2)
15 (1)

Number of Fonts

15 (1)
16 (1)
17 (1)

Color

Black (2)
Glossy Piano Black (1)

Color Depth

48-bit (2)
24-bit (1)

Grayscale Depth

16-bit (1)
8-bit (1)

Package Type

OEM (1)
Retail (1)

Number of Batteries

2 (1)
4 (1)

Standard Input Media Capacity

100 sheets (1)
150 sheets (1)

Multifunction Devices

Copier/Fax/Printer/Scanner (1)
Copier/Printer/Scanner (1)

Minimum Frequency Response

100 Hz (1)
90 Hz (1)

Maximum Label Length

19.68"" (499.90 mm) (1)
39.37"" (1000 mm) (1)

Maximum Label Width

0.94"" (24 mm) (1)
2.44"" (62 mm) (1)

Media Handling

1 x Input Tray - 100 Sheet Capacity (1)
1 x Input Tray 150 Sheets
1 x Automatic Document Feeder 20 Sheets
(1)

Application Log
Timestamp	Level	Category	Message
18:49:42.492254	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
18:49:42.492522	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
18:49:42.492881	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
18:49:42.493247	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
18:49:42.495800	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
18:49:42.497371	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
18:49:42.498420	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)
18:49:42.499806	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)
18:49:42.500351	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)
18:49:42.500538	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
18:49:42.501102	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
18:49:42.830780	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
18:49:42.830811	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)
18:49:42.831504	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)
18:49:42.833270	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)
18:49:42.833846	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)
18:49:42.834019	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)
18:49:42.834408	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
18:49:42.834427	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)
18:49:42.834937	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)
18:49:42.835042	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)
18:49:42.835264	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
18:49:42.835283	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)
18:49:42.835721	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)
18:49:42.835838	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)
18:49:42.835937	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
18:49:42.838653	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
18:49:42.838881	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
18:49:42.838968	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)
18:49:42.839328	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
18:49:42.839349	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)
18:49:42.839771	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)
18:49:42.839859	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)
18:49:42.839962	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
18:49:42.839978	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)
18:49:42.864032	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.864058	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=52909 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.864384	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.864398	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=52957 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.864589	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.864602	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=52958 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.864790	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.864803	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=53935 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865006	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865019	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=53970 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865199	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865211	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=53992 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865390	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865401	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=53994 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865581	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865592	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=53995 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865781	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865792	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=54087 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865971	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.865983	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=54089 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866164	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866177	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=53693 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866358	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866369	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=53720 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866549	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866560	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=54232 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866739	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866751	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=54810 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866931	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.866944	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=54319 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867120	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867131	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=55696 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867305	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867316	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=55718 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867487	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867500	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=55755 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867681	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867692	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=55346 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867866	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.867877	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=55106 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
18:49:42.868253	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.868283	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)
18:49:42.868911	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)
18:49:42.869034	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)
18:49:42.869139	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.869168	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)
18:49:42.869255	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.869281	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)
18:49:42.869365	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.869391	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)
18:49:42.869486	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.869510	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)
18:49:42.869597	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.869623	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)
18:49:42.869704	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.869730	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)
18:49:42.869820	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.869846	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)
18:49:42.869930	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.869956	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)
18:49:42.870043	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.870069	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)
18:49:42.870158	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
18:49:42.870183	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)
18:49:42.871031	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
18:49:42.871052	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)
18:49:42.871733	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)
18:49:42.871838	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)
18:49:42.913984	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)
18:49:42.914709	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)
18:49:42.923432	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)
18:49:42.923490	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)
18:49:42.945756	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)
18:49:42.945807	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)
18:49:42.958704	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)
18:49:42.958745	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)
18:49:42.959753	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)
18:49:42.959903	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)
18:49:42.960073	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)
18:49:42.960180	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)
18:49:42.960494	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)
18:49:42.960515	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)
18:49:42.961183	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)
18:49:42.961396	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)
18:49:42.961916	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)
18:49:42.962028	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)
18:49:42.962990	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)
18:49:42.963015	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)
18:49:42.963258	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)
18:49:42.963279	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)
18:49:42.963773	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)
18:49:42.963860	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)
18:49:42.966808	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