OfficeCo

3.3 (36)
1 (25)
1.1 (20)
1.2 (19)
1.3 (19)
1.5 (16)
0.85 (14)
0.15 (13)
1.8 (11)
6.6 (11)
0.06 (10)
0.02 (9)
0.25 (8)
0.45 (6)
0.6 (5)
0.3 (3)
0.35 (3)
0.7 (3)
0.08 (2)
0.12 (2)
0.22 (2)
0.31 (2)
0.65 (2)
0.82 (2)
0.9 (2)
1.65 (2)
1.85 (2)
8 (2)
0.05 (1)
0.2 (1)
0.23 (1)
0.24 (1)
0.26 (1)
0.28 (1)
0.29 (1)
0.32 (1)
0.4 (1)
0.44 (1)
0.47 (1)
0.5 (1)
0.55 (1)
0.58 (1)
0.62 (1)
0.72 (1)
0.74 (1)
0.75 (1)
0.77 (1)
0.83 (1)
0.95 (1)
1.23 (1)
1.28 (1)
1.35 (1)
1.7 (1)
2.25 (1)
6.7 (1)
9.24 (1)

Dimensions

16oz (32)
8 oz (27)
2" (20)
1" (19)
1.5" (19)
3" (15)
16 oz (13)
2 1/4" x 50' (12)
1m x 1m (11)
32oz (11)
4.8cm x 152m (10)
1" x 1.7" (9)
4oz (8)
4" (6)
5lb (4)
6½" x 9" (3)
19mm x 32.9m (1)
1L (2)
9" X 12" (2)
950mL (2)
1" X 9 Yards (1)
1-7/8in (48mm)W (1)
1.5" x 13.7m (1)
1/2" (1)
1/4" (1)
10" (1)
11" x 17" (1)
12" X 18" (1)
12" x 12" (1)
12" x 18" (1)
13 3/8" (1)
15cm X 9.5 cm (1)
16"X20" (1)
16.5" x 21" (1)
1m X 2.9cm X 0.6cm (1)
2 hole (1)
2" x 13.7m (1)
2" x 55m (1)
2.27kg (1)
21" x23" (1)
24" (1)
25" x 9" (1)
26" tall (1)
28" tall (1)
3" x 13.7m (1)
3.8L (1)
30' (1)
4.5m (1)
48" (1)
48" X 36" (1)
4L (1)
5" (1)
50 wipes (1)
6" X 9" (1)
6.5" (1)
600ml (1)
7" and 15" (1)
8 1/2" X 11" (1)
8.5" X 11" (1)
8.5" x 11" (1)
9" x 12 (1)
9" x 12" (1)
9.75" X 7.5" (1)
Legal (1)
Up to 1¾ x 2" (1)

Black (24)
Blue (9)
Pink (3)
Red (3)
White (3)
Black
Gray
(2)
Gray (2)
Satin Silver (2)
Silver (2)
Clear
Transparent
(1)
Green
Transparent
(1)
Silver
Black
(1)
Clear (1)
Gold (1)
Graphite (1)
Ivory (1)
Lime Green (1)
Matte Black (1)
Matte Blue (1)
Matte Red (1)
Matte White (1)
Ocean Blue (1)
Purple (1)

Country of Origin

China (39)
Taiwan (8)
Japan (6)
United States (2)
Malaysia (1)

Limited Warranty

1 Year (23)
Lifetime (21)
2 Year (4)
5 Year (3)
25 Year (1)
3 Year (1)
90 Day (1)

Weight (Approximate)

10 g (4)
226.8 g (3)
453.59 mg (3)
1 g (2)
4.5 g (2)
50 g (2)
59 g (2)
90.7 g (2)
99.8 g (2)
104.9 g (1)
13.6 g (1)
14.2 g (1)
147.4 g (1)
158.8 g (1)
160 g (1)
180 g (1)
19.8 g (1)
190.5 g (1)
2 g (1)
200 g (1)
340.2 g (1)
39.7 g (1)
4.6 g (1)
73.9 g (1)
76.5 g (1)
82.2 g (1)
85 g (1)
89.9 g (1)
9.1 g (1)

Width

0.94"" (24 mm) (6)
0.43"" (10.92 mm) (3)
9"" (228.60 mm) (3)
0.79"" (20 mm) (2)
1.25"" (31.75 mm) (2)
10"" (254 mm) (2)
2.28"" (57.91 mm) (2)
2.40"" (60.96 mm) (2)
3.89"" (98.81 mm) (2)
0.5"" (1)
0.70"" (17.78 mm) (1)
0.8"" (1)
1.44"" (36.60 mm) (1)
2.44"" (61.98 mm) (1)
2.7"" (1)
3.10"" (78.74 mm) (1)
3.30"" (83.82 mm) (1)
4.10"" (104.14 mm) (1)
5.20"" (132.08 mm) (1)
5.67"" (144 mm) (1)
6.25"" (158.75 mm) (1)
7"" (177.80 mm) (1)
8"" (203.20 mm) (1)
8.30"" (210.82 mm) (1)

Recycled

No (32)
Yes (3)

Number of Pieces

50 (9)
72 (6)
10000 (1)
12 (1)
131 (1)
16 (1)
26 (1)
31 (1)
33 (1)
34 (1)
3504 (1)
36 (1)
55 (1)
7 (1)

Product Line

MegaTank (5)
Commuter (4)
Premium (4)
Precise (2)
Silent (2)
Bass13 (1)
Command (1)
EZ Correct (1)
EZRefill (1)
InSight (1)
Jelleez (1)
Mini (1)
MobileLite Plus (1)
Pro (1)
Trusted Glass (1)

Package Contents

HAF-17M Earset

Remote

(4)

Mirco SD card

Adapter

(2)

1 x Charging Controller Grip

1 x USB-C to USB-A Cable

(1)

5-Port 10/100Mbps Desktop Switch

Power Adapter

Installation Guide

(1)

Bass 13 Metallic Wireless Earbuds

USB Charging Cable

Manual

(1)

Command 17017CLR-C Cord Clip

4 x Clips

5 x Strips

(1)

Controller Grips for use with Nintendo Switch Joy-Con Controllers - Black

SL and SR Buttons

(1)

PF-6722 16GB microSDHC Card

SD Adapter

(1)

PF-6723 32GB microSDHC Card

SD Adapter

(1)

Pro 600X microSDHC Memory Card

SD Adapter

(1)

Silent Wireless Blue LED Mouse - Blue

Wireless Receiver

(1)

Silent Wireless Blue LED Mouse - Graphite

Wireless Receiver

(1)

Stereo Headset H111

User Documentation

(1)

Wireless Notebook Optical Mouse, Commuter Series - Matte Black

Nano Receiver

(1)

Wireless Notebook Optical Mouse, Commuter Series - Matte Blue

Nano Receiver

(1)

Wireless Notebook Optical Mouse, Commuter Series - Matte Red

Nano Receiver

(1)

Wireless Notebook Optical Mouse, Commuter Series - Matte White

Nano Receiver

(1)
DCB-302 Compact Camera Case
Shoulder Strap
(1)
M100 Mouse
User documentation
(1)
Wireless Multi-Trac Blue LED Optical Mouse - Black
Nano Receiver
1 x AA Battery
(1)
Wireless Multi-Trac Blue LED Optical Mouse - Blue
Nano Receiver
1 x AA Battery
(1)
Wireless Multi-Trac Blue LED Optical Mouse - Red
Nano Receiver
1 x AA Battery
(1)

Device Supported

Computer (5)
Notebook
Desktop Computer
(4)
Mobile Device
Smartphone
(2)
Notebook
Desktop Computer
Ultrabook
(2)
Phone (2)
Blu-ray Player
HDTV
DVD Player
Stereo Receiver
Projector
Audio/Video Device
TV
Gaming Console
Digital Video Recorder
(1)
Blu-ray Player
HDTV
DVD Player
Stereo Receiver
Projector
Audio/Video Device
TV
Gaming Console
Digital Video Recorder
Audio Amplifier
(1)
Flash Drive
Notebook
Desktop Computer
(1)
Hard Drive
Tablet
Notebook
Mobile Device
Computer
(1)
MAC
Notebook
(1)
Peripheral Device
Printer
Scanner
Add-on Card
External Hard Drive
(1)
USB Hub
Peripheral Device
Computer
(1)
iPhone 13 Pro
iPhone 13
iPhone 14 Plus
(1)
Air Purifier (1)
Portable Gaming Console (1)
Smartphone (1)

Height

0.23"" (5.94 mm) (2)
1.37"" (34.80 mm) (2)
1.40"" (35.56 mm) (2)
1.52"" (38.61 mm) (2)
8"" (203.20 mm) (2)
0.30"" (7.50 mm) (1)
0.30"" (7.62 mm) (1)
0.40"" (10.16 mm) (1)
0.90"" (22.86 mm) (1)
1"" (25.40 mm) (1)
1.3"" (1)
1.30"" (33.02 mm) (1)
4.45"" (113.03 mm) (1)
4.90"" (124.46 mm) (1)
5.6"" (1)
6.38"" (162 mm) (1)
60 mil (1.52 mm) (1)
7"" (177.80 mm) (1)
8.10"" (205.74 mm) (1)

Compatibility

Canon PIXMA Printers:

G1200

G4200

G2200

G3200

(5)
iPhone (4)
One Plus

Apple iPad Pro

Samsung:

Galaxy S8

Galaxy S9

Galaxy S10

Galaxy S20

Galaxy S20+

Google:

Pixel 3a

Pixel 3

Pixel 4 series

(2)
Adapter (RS232 modular adapters for dumb-terminal hook-ups; Parallel or Serial extension equipment and adapters )
(2)
Nintendo - Switch (2)
Headsets and Earsets:
H51, H51N, H61, H61N, H91, H91N, H101, H101N, SP04, SP05, PLX400, PLX500
(1)
Cable Cord
(1)
Nintendo - Switch
(1)
Nintendo Switch Portable Gaming Console
(1)
Samsung - Galaxy A13 5G
(1)

Apple iPhone

Apple iPad

Apple iPod

Andriod Devices

(1)
Apple - iPhone 13, iPhone 13 Pro, iPhone 14 Plus (1)
Optical mouse also features a USB 2.0 interface and is compatible with Windows 8, 7, XP, 2000, Vista, Mac OS 10.4.X and higher. The single AA battery is included.
More from the Manufacturer (1)
TruSens Z1000 Air Purifier (1)

Product Model

GI-290 (5)
HAF-17M (4)
17017CLR-C (1)
90924C (1)
97709 (1)
DCB-302 (1)
H111 (1)
HP-200 (1)
IP-955 (1)
M100 (1)
PF-6722 (1)
PF-6723 (1)
PF-6933 (1)
PF-6936 (1)
PF-6939 (1)
TL-SF1005D (1)

Thickness

82.68 mil (2.10 mm) (6)
30 mil (0.76 mm) (3)
20lb (2)
50lb (2)
55.12 mil (1.40 mm) (2)
80lb (2)
90 mil (2.29 mm) (2)
Medium (1)

Depth

0.13"" (3.30 mm) (2)
2.45"" (62.23 mm) (2)
2.80"" (71.12 mm) (2)
3.74"" (95 mm) (2)
3.90"" (99.06 mm) (2)
8.75"" (222.25 mm) (2)
0"" (1)
0.79"" (20 mm) (1)
1.50"" (38.10 mm) (1)
1.81"" (46 mm) (1)
13.50"" (342.90 mm) (1)
2.40"" (60.96 mm) (1)
60 mil (1.52 mm) (1)
8.20"" (208.28 mm) (1)

Length

1.26"" (32 mm) (6)
0.55"" (13.97 mm) (3)
0.85"" (21.50 mm) (2)
0.94"" (23.88 mm) (2)
0.5"" (1)
10.50"" (266.70 mm) (1)
6"" (152.40 mm) (1)
8"" (1)
8.50"" (215.90 mm) (1)
9"" (228.60 mm) (1)

Product Material

Foam (4)
Plastic (4)
Rubber (2)
Silicone (2)
Aluminosilicate
Tempered Glass
(1)
Aramid Fiber
PVC
(1)
Aramid Fiber
Polyvinyl Chloride (PVC)
(1)
Ethylene Vinyl Acetate (EVA) (1)
Metal (1)
Polyester (1)
Tempered Glass (1)

Form Factor

In-ear (6)
SDHC (3)
External (2)
microSDHC (2)
120mm (1)
Desktop
Wall Mountable
(1)
Open (1)
Supra-aural (1)

Additional Warranty Information

1-Year Limited Warranty
(5)
Limited Lifetime Warranty
(5)
One Year Limited Warranty
(3)
1 year limited
(1)
Lifetime Limited Warranty.
(1)
Limited One-Year Warranty
(1)
Manufacturer's Limited Lifetime Warranty
(1)

Cable Length

3.3 ft (6)
3 ft (2)
50 ft (2)
6.6 ft (2)
4 ft (1)
6 ft (1)
6"" (1)
7.7 ft (1)

Storage Capacity

16 GB (6)
32 GB (6)
8 GB (2)
4.70 GB (1)

Speed Class Rating

Class 10 (5)
Class 10/UHS-I (U1) (4)
Class 10/UHS-I (3)
Class 10/UHS-I (U3) (1)

Pointing Device Connectivity Technology

Wireless (9)
Cable (4)

Movement Detection

Optical (8)
Blue Optical (3)
Blue LED/Optical (2)

Pointing Device Host Interface

USB Type A (9)
USB 2.0 (3)
USB (1)

Environmental Certification

RoHS
REACH
WEEE
(4)
WEEE
RoHS
(3)
RoHS (3)
RoHS
WEEE
(1)
FSC (1)

Connector Type on First End

USB 2.0 Type A - Male (4)
HDMI Digital Audio/Video - Male (2)
RJ-11 - Male (2)
USB 3.0 Type A - Male (2)
Mini-DIN (PS/2) (1)
USB 3.2 (Gen 1) Type C - Male (1)

Connector Type on Second End

HDMI Digital Audio/Video - Male (2)
RJ-11 - Male (2)
USB 2.0 Type C - Male (2)
USB 3.0 Type A - Female (2)
USB (1)
USB 2.0 Type A - Male (1)
USB 2.0 Type B - Male (1)
USB 3.0 Type C - Male (1)

Connector on Second End Details

1 x 19-pin HDMI Digital Audio/Video - Male (2)
1 x 24-pin USB 2.0 Type C - Male (2)
1 x RJ-11 - Male (2)
1 x USB 3.0 Type A - Female (1)
1 x 24-pin USB 3.0 Type C - Male (1)
1 x 4-pin USB 2.0 Type A - Male (1)
1 x 4-pin USB 2.0 Type B - Male (1)
1 x 9-pin USB 3.0 Type A - Female (1)
1 x USB (1)

Connector Plating

Nickel (5)
Nickel Plated (5)
Gold (2)

Connector on First End Details

1 x 4-pin USB 2.0 Type A - Male (4)
1 x 19-pin HDMI Digital Audio/Video - Male (2)
1 x 9-pin USB 3.0 Type A - Male (2)
1 x RJ-11 - Male (2)
1 x 24 pin USB 3.2 (Gen 1) Type C - Male (1)
1 x Mini-DIN (PS/2) (1)

Durability

Sweat Resistant
Water Proof
(4)
Scratch Resistant
Dust Resistant
(1)
Scratch Resistant
Fingerprint Resistant
Smudge Resistant
Impact Resistant
(1)
Scratch Resistant
Shatter Resistant
Smudge Resistant
Drop Resistant
Scrape Resistant
Fingerprint Resistant
Break Resistant
(1)
Tear Resistant
Wear Resistant
Skid Proof
(1)
Wear Resistant
Tear Resistant
Skid Proof
(1)

Earpiece Design

Earbud (6)
Over-the-head (2)
Earbud
Behind-the-neck
(1)

Jacket Material

Polyvinyl Chloride (PVC) (7)
Thermoplastic Elastomer (TPE) (2)

Connector Gender on Second End

Male (7)
Female (2)

Connectivity Technology

Wired (7)
Docking (1)
Wireless (1)

Cable Type

USB/USB-C (3)
HDMI (2)
USB (2)
USB/USB-B (1)

American Wire Gauge

24/28 AWG (3)
22/32 AWG (2)
28 AWG (2)
24/32 AWG (1)

Number of Pages

144 (1)
150 (1)
160 (1)
200 (1)
30 (1)
40 (1)
60 (1)
70 (1)

Color Family

Black (4)
Blue (1)
Gray (1)
Silver (1)

Host Interface

Mini-phone (3.5mm) (3)
Proprietary Interface (1)
USB 2.0 (1)
USB 3.0 (1)
USB 3.2 (Gen 1) Type A (1)

Application/Usage

Gaming Accessories
Portable Gaming Console
Gaming Controller
(1)
Gaming Console
Accessories
Gaming Controller
Power Adapter
Cable
(1)
Remove Dust
Remove Gases
Remove Odor
Remove Pet Hair
(1)
Camera (1)
Gaming Console (1)
Home (1)
Music (1)

Additional Information

Features:
CSMA/CD
TCP/IP
Supports IEEE802.3x flow control for Full Duplex mode and back pressure for Half Duplex mode
Supports MAC address auto-learning and auto-aging
LED indicators for monitoring power, link, activity
(1)

Available in assorted colours--black, blue, burgundy and green

Ruled

(1)

Firm grip copy clip holds up to 50 multi-size pages

Compact and collapsible to maximize workspace

Adjustable design can accommodate landscape or portrait formats in paper or books

Fits nicely between the keyboard and monitor for comfortable, ergonomic viewing

Sturdy enough to support a large book

(1)

General purpose template, 9-1/2"" X 5-1/2""

Built in ink risers

Made of Green butyrate, dimensionally stable plastic

42 assorted shapes including circles, squares, triangles, hexagons and 180 Degree protractor.

Matte surface to prevent glare and transparent for full visibility

(1)
Compatible with USB 1.1 devices
Connect a USB printer or any USB peripheral device to a PC at high-performance data transfer speed
(1)
Dynamic sound reproduction from all sources
Magnet: Anisotropic Ferrite
Film: 0.012mm
Coil: 13.6mm
Channel Balance: < 3 dB
Rated Input: 40 mW
Maximum Input: 100 mW
(1)
Long-lasting polyester surface stands up against everyday wear and tear.
Skid-free natural rubber keeps mouse pad in place.
(1)

Minimum Frequency Response

8 Hz (4)
20 Hz (2)

Data Transfer Rate

480 Mbit/s (4)
5 Gbit/s (2)

Maximum Read Speed

45 MB/s (3)
20 MB/s (2)
90 MB/s (1)

Recommended Age

10 Year (2)
4 Year (2)
6 Year (2)

Impedance

46 Ohm (4)
32 Ohm (2)

Movement Resolution (dpi)

1200 (4)
1000 (1)

Print Color

Cyan (2)
Yellow (2)
Magenta (1)

Brand Compatibility

Nintendo (3)
Apple (1)
Samsung (1)

Driver Size

0.42"" (10.70 mm) (4)
1.18"" (30 mm) (1)

System Requirements

Operating Systems:
Windows 8
Windows 7
Windows XP
Windows 2000
Windows Vista
Mac OS 10.4.X and Higher
(3)
Operating Systems:
Microsoft Windows 8/7/Vista/XP
MAC OS X
NetWare
UNIX
Linux
(1)
Operating Systems:
Windows XP
Windows Vista
Windows 7
Mac OS X 10.4 or later
Linux kernel 2.6 or later
(1)

Maximum Write Speed

16x (1)
20 MB/s (1)
45 MB/s (1)
9 MB/s (1)

Platform Supported

PC
Mac
(3)
Mac
PC
(1)

Capacity

0.5L (1)
100 sheets (1)
24 sheets (1)

Stylus Point Size

0.31"" (8 mm) (1)
27.56 mil (0.70 mm) (1)
39.37 mil (1 mm) (1)

Printed Design/Pattern/Texture

Textured (2)
Gray Bitmap (1)

Post-consumer-waste%

0% (2)
50% (1)

Memory Speed

400x (2)
600x (1)

Pointing Device Features

Comfort Grip
Ergonomic
Receiver Storage
Contour
(1)
Comfort Grip
Receiver Storage
Contour
Ergonomic
(1)
Ergonomic
Contour
Comfort Grip
Receiver Storage
(1)

Tape Length

25.9 ft (1)
3.3 ft (1)
45 ft (1)

Exterior Material

Ethylene Vinyl Acetate (EVA)
Fabric
(1)
Fabric (1)

Dispenser Type

Ergonomic (1)
Mini (1)

Dispenser Color

Purple (1)
Translucent (1)

Microphone Design

Boom (1)
On-cable (1)

Memory Card Supported

SD
Memory Stick
MultiMediaCard (MMC)
(1)
microSD
microSDXC
microSD (TransFlash)
microSDHC
(1)

Carrying Options

Handle (1)
Shoulder Strap (1)

Adapter Type

(PS/2)/USB (1)
USB/USB-C (1)

Cable Manager Type

Cable Tie (1)
Cord Clip (1)

Application Log
Timestamp	Level	Category	Message
10:28:59.505733	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
10:28:59.506025	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
10:28:59.506381	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
10:28:59.506818	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
10:28:59.509650	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
10:28:59.511310	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
10:28:59.512382	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)
10:28:59.513252	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)
10:28:59.513782	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)
10:28:59.513916	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
10:28:59.514456	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
10:28:59.515156	trace	system.db.ar.CActiveRecord	User.find() in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
10:28:59.516599	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `users` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
10:28:59.517236	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `users` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
10:28:59.517522	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `accounts` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
10:28:59.518109	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `accounts` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
10:28:59.518284	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 (LOWER(username)=?) in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
10:28:59.520994	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
10:28:59.521073	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)
10:28:59.521374	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
10:28:59.521393	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)
10:28:59.521902	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)
10:28:59.522336	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)
10:28:59.522567	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
10:28:59.522583	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)
10:28:59.523068	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)
10:28:59.523159	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)
10:28:59.523261	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
10:28:59.525903	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
10:28:59.526128	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
10:28:59.526211	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)
10:28:59.526587	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
10:28:59.526608	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)
10:28:59.527129	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)
10:28:59.527231	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)
10:28:59.527343	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
10:28:59.527358	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)
10:28:59.555413	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
10:28:59.555449	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=5850 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)

71-105

71-1051

71-106

71-107

71-108

73-185

73-186

73-187

73-188

73-189

73-190

73-191

73-192

73-193

73-223

73-224

73-225

73-226

73-227

73-228

Are you sure