Narrowed By:
Quantity: 100 Price: $10.00 to $55.00
No products match that criteria.
Contact Us
  • 4911 - 68 Avenue, Edmonton
  • sales@officeco.ca
  • 1 (866) 600-3644
  • (780) 463-8170
Customer Service
My Account
Copyright © 2019 - 2025 by OfficeCo. All prices are in Canadian Dollars ($).
OfficeCo is not responsible for typographical errors. Prices, policies, and availability are subject to change without notice.
Application Log
Timestamp Level Category Message
23:02:13.990922 trace system.CModule 
Loading "log" application component
in /home/rose/dev/index.php (12)
23:02:13.991269 trace system.CModule 
Loading "db" application component
in /home/rose/dev/index.php (12)
23:02:13.991632 trace system.db.CDbConnection 
Opening DB connection
in /home/rose/dev/index.php (12)
23:02:13.991930 trace system.CModule 
Loading "request" application component
in /home/rose/dev/index.php (12)
23:02:13.994441 trace system.db.ar.CActiveRecord 
Portal.findByAttributes()
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)
23:02:13.995790 trace system.CModule 
Loading "cache" application component
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)
23:02:13.996824 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)
23:02:13.997544 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)
23:02:13.998091 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)
23:02:13.998231 trace system.CModule 
Loading "user" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)
23:02:13.998779 trace system.CModule 
Loading "session" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)
23:02:14.916711 trace system.db.ar.CActiveRecord 
User.findByPk()
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)
23:02:14.916754 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)
23:02:14.917519 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)
23:02:14.919388 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)
23:02:14.919960 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)
23:02:14.920159 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)
23:02:14.920525 trace system.db.ar.CActiveRecord 
HiddenProduct.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (63)
in /home/rose/dev/index.php (12)
23:02:14.920545 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)
23:02:14.920916 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)
23:02:14.921040 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)
23:02:14.921293 trace system.db.ar.CActiveRecord 
CustomCategory.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (74)
in /home/rose/dev/index.php (12)
23:02:14.921312 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)
23:02:14.921694 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)
23:02:14.922193 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)
23:02:14.922336 trace system.CModule 
Loading "urlManager" application component
in /home/rose/dev/index.php (12)
23:02:14.925121 trace system.web.filters.CFilterChain 
Running filter ProductController.filteraccessControl()
in /home/rose/dev/index.php (12)
23:02:14.925353 trace system.db.ar.CActiveRecord 
User.findByPk()
in /home/rose/dev/protected/controllers/ProductController.php (293)
in /home/rose/dev/index.php (12)
23:02:14.925435 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)
23:02:14.925776 trace system.db.ar.CActiveRecord 
PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (319)
in /home/rose/dev/index.php (12)
23:02:14.925798 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)
23:02:14.926139 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)
23:02:14.926256 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)
23:02:14.926392 trace system.db.ar.CActiveRecord 
PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (322)
in /home/rose/dev/index.php (12)
23:02:14.926409 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)
23:02:14.941813 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.941863 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)
23:02:14.942526 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)
23:02:14.942697 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)
23:02:14.942887 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.942918 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)
23:02:14.943044 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.943073 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)
23:02:14.943197 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.943227 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)
23:02:14.943362 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.943392 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)
23:02:14.943504 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.943532 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)
23:02:14.943645 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.943675 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)
23:02:14.943782 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.943809 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)
23:02:14.943914 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.943944 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)
23:02:14.944056 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.944084 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)
23:02:14.944215 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.944243 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)
23:02:14.944355 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.944384 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)
23:02:14.944506 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.944535 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)
23:02:14.944643 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.944672 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)
23:02:14.944781 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.944809 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)
23:02:14.944931 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.944958 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)
23:02:14.945066 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.945096 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)
23:02:14.945204 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.945233 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)
23:02:14.945341 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.945369 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)
23:02:14.945492 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.945521 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)
23:02:14.945645 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.945672 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)
23:02:14.945781 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.945811 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)
23:02:14.945919 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.945949 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)
23:02:14.946059 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.946089 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)
23:02:14.946197 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.946225 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)
23:02:14.946332 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.946362 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)
23:02:14.946470 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.946499 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)
23:02:14.946609 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.946638 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)
23:02:14.946746 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.946774 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)
23:02:14.946880 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.946908 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)
23:02:14.947032 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.947061 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)
23:02:14.947169 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.947197 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)
23:02:14.947308 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.947336 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)
23:02:14.947444 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.947474 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)
23:02:14.947602 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.947632 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)
23:02:14.947740 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.947768 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)
23:02:14.947874 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.947902 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)
23:02:14.948014 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.948043 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)
23:02:14.948153 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.948182 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)
23:02:14.948293 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.948323 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)
23:02:14.948446 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.948473 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)
23:02:14.948600 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.948626 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)
23:02:14.948735 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.948765 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)
23:02:14.948887 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.948914 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)
23:02:14.949039 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.949068 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)
23:02:14.949178 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.949208 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)
23:02:14.949321 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.949351 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)
23:02:14.949464 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.949492 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)
23:02:14.949606 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.949635 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)
23:02:14.949743 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.949771 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)
23:02:14.949882 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.949911 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)
23:02:14.950021 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.950050 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)
23:02:14.950158 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.950186 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)
23:02:14.950303 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.950331 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)
23:02:14.950444 trace system.db.ar.CActiveRecord 
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
23:02:14.950474 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)
23:02:14.950849 trace system.db.ar.CActiveRecord 
CartItem.findAllByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (588)
in /home/rose/dev/index.php (12)
23:02:14.950870 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)
23:02:14.951251 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)
23:02:14.951383 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)
23:02:14.980321 trace system.CModule 
Loading "widgetFactory" application component
in /home/rose/dev/protected/views/layouts/office.php (81)
in /home/rose/dev/protected/controllers/ProductController.php (621)
in /home/rose/dev/index.php (12)
23:02:14.980761 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)
23:02:14.980807 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)
23:02:14.993518 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)
23:02:14.993551 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)
23:02:15.005433 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)
23:02:15.005465 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)
23:02:15.005965 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)
23:02:15.006134 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)
23:02:15.006319 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)
23:02:15.006428 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)
23:02:15.006761 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)
23:02:15.006781 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)
23:02:15.007113 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)
23:02:15.007513 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)
23:02:15.007859 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)
23:02:15.007996 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)
23:02:15.009099 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)
23:02:15.009121 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)
23:02:15.009386 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)
23:02:15.009407 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)
23:02:15.009763 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)
23:02:15.010059 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)
23:02:15.010350 trace system.CModule 
Loading "clientScript" application component
in /home/rose/dev/protected/controllers/ProductController.php (621)
in /home/rose/dev/index.php (12)