OfficeCo

1 (466)
12 (181)
100 (106)
50 (76)
24 (37)
6 (34)
10 (30)
25 (29)
1 Each (28)
96 (25)
500g (14)
8 (11)
36 (10)
4 (8)
40 (8)
50g (8)
500 (7)
1 Dozen (5)
1/4lb (5)
1lb (5)
30 (4)
300 (4)
48 (4)
480 (4)
60 (4)
100 / Box (3)
12 / Pack (3)
16 (3)
1/2lb (2)
1000 (2)
11 (2)
1500 (2)
20 (2)
200 / Pack (2)
24 / Box (2)
250 (2)
2lb (2)
454g (2)
5000 (2)
960 (2)
1 / Each (1)
10 / Box (1)
100 sheets (1)
12 / Box (1)
130 (1)
1400 (1)
144 (1)
150 (1)
1Kg (1)
2 / Pack (1)
2.5lb (1)
200 (1)
24 / Pack (1)
2500 / Box (1)
28 (1)
3 (1)
3 / Pack (1)
30 / Pack (1)
3000 (1)
30g (1)
310g (1)
32 (1)
4 / Pack (1)
44 (1)
450 (1)
5 (1)
50 / Box (1)
500 / Box (1)
500 / Ream (1)
6 / Set (1)
600 / Pack (1)
64 (1)
738 (1)
900 (1)

1 (77)
3.3 (70)
0.25 (53)
0.2 (42)
1.1 (39)
2.9 (39)
0.06 (37)
0.01 (35)
0.02 (30)
0.1 (30)
0.5 (30)
3.5 (28)
0.15 (23)
1.2 (21)
0.19 (20)
1.3 (20)
1.4 (19)
1.5 (18)
4 (18)
0.22 (17)
0.3 (17)
2.3 (17)
0.85 (15)
0.11 (14)
0.45 (14)
0.04 (13)
0.05 (12)
0.55 (11)
0.6 (11)
1.8 (11)
6.6 (11)
9.5 (11)
16.1 (10)
5.1 (10)
0.35 (9)
5 (9)
0.13 (8)
0.24 (8)
0.4 (8)
0.8 (8)
0.9 (8)
0.09 (7)
0.12 (7)
0.16 (7)
0.17 (7)
0.65 (7)
2.42 (7)
0.18 (6)
0.32 (6)
0.7 (6)
0.03 (5)
0.07 (5)
0.27 (5)
0.31 (5)
0.75 (5)
2.2 (5)
0.08 (4)
3.1 (4)
4.2 (4)
0.21 (3)
0.26 (3)
0.29 (3)
0.34 (3)
0.78 (3)
5.4 (3)
8 (3)
0.28 (2)
0.36 (2)
0.38 (2)
0.41 (2)
0.43 (2)
0.44 (2)
0.51 (2)
0.53 (2)
0.68 (2)
0.77 (2)
0.82 (2)
1.15 (2)
1.65 (2)
1.7 (2)
1.85 (2)
1.9 (2)
3.6 (2)
6.1 (2)
7.7 (2)
0.23 (1)
0.37 (1)
0.39 (1)
0.42 (1)
0.46 (1)
0.47 (1)
0.52 (1)
0.58 (1)
0.62 (1)
0.63 (1)
0.74 (1)
0.81 (1)
0.83 (1)
0.86 (1)
0.95 (1)
0.96 (1)
1.03 (1)
1.05 (1)
1.14 (1)
1.23 (1)
1.26 (1)
1.28 (1)
1.35 (1)
1.51 (1)
1.55 (1)
1.6 (1)
10.22 (1)
10.7 (1)
12.1 (1)
13.2 (1)
2.05 (1)
2.1 (1)
2.17 (1)
2.25 (1)
2.4 (1)
2.5 (1)
2.6 (1)
2.71 (1)
2.95 (1)
3.7 (1)
5.11 (1)
5.5 (1)
5.73 (1)
6.2 (1)
6.7 (1)
7.2 (1)
7.9 (1)
8.5 (1)
8.9 (1)
9.24 (1)

No (45)
Yes (12)

100 (8)
72 (5)
144 (2)
30 (2)
40 (2)
80 (2)
160 (1)
20 (1)
200 (1)
32 (1)
48 (1)
60 (1)
70 (1)

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

100% (4)
50% (4)
30% (1)
7% (1)

0% (3)
30% (3)
100% (1)
50% (1)

Yes (5)
No (2)

Red (4)
Blue (3)

Yes (6)
No (1)

A796 (1)
D1 (1)
M (1)
TZ (1)
TZe (1)

AP (3)
AP
(1)
- AP
(1)

10 (2)
110 (1)
20 (1)
70 (1)

2S (1)
Ring (1)

2 (1)
3 (1)

192 (1)
200 (1)

Application Log
Timestamp	Level	Category	Message
14:10:32.322483	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
14:10:32.322835	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
14:10:32.323195	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
14:10:32.323510	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
14:10:32.326154	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:10:32.327632	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:10:32.328736	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)
14:10:32.329474	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)
14:10:32.330065	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)
14:10:32.330229	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
14:10:32.330833	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
14:10:32.418472	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:10:32.418503	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)
14:10:32.419051	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)
14:10:32.421061	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)
14:10:32.421545	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)
14:10:32.421729	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)
14:10:32.422101	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:10:32.422133	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)
14:10:32.422640	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)
14:10:32.422796	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)
14:10:32.423053	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:10:32.423072	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)
14:10:32.423449	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)
14:10:32.423599	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)
14:10:32.423752	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
14:10:32.427016	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
14:10:32.427298	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
14:10:32.427407	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)
14:10:32.427773	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:10:32.427795	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)
14:10:32.428189	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)
14:10:32.428324	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)
14:10:32.428469	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
14:10:32.428488	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)
14:10:32.446882	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:10:32.446924	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)
14:10:32.447613	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)
14:10:32.447802	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)

Products

Are you sure