No products match that criteria.
Contact Us
  • 4911 - 68 Avenue, Edmonton
  • sales@officeco.ca
  • 1 (866) 600-3644
  • (780) 463-8170
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
21:20:02.698591 trace system.CModule
Loading "log" application component
in /home/rose/dev/index.php (12)
21:20:02.698900 trace system.CModule
Loading "db" application component
in /home/rose/dev/index.php (12)
21:20:02.699346 trace system.db.CDbConnection
Opening DB connection
in /home/rose/dev/index.php (12)
21:20:02.699688 trace system.CModule
Loading "request" application component
in /home/rose/dev/index.php (12)
21:20:02.702541 trace system.db.ar.CActiveRecord
Portal.findByAttributes()
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)
21:20:02.704063 trace system.CModule
Loading "cache" application component
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)
21:20:02.705183 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)
21:20:02.705976 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)
21:20:02.706561 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)
21:20:02.706712 trace system.CModule
Loading "user" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)
21:20:02.707293 trace system.CModule
Loading "session" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)
21:20:02.933216 trace system.db.ar.CActiveRecord
User.findByPk()
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)
21:20:02.933260 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)
21:20:02.933984 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)
21:20:02.936652 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)
21:20:02.937096 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)
21:20:02.937293 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)
21:20:02.937696 trace system.db.ar.CActiveRecord
HiddenProduct.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (63)
in /home/rose/dev/index.php (12)
21:20:02.937721 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)
21:20:02.938098 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)
21:20:02.938235 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)
21:20:02.938524 trace system.db.ar.CActiveRecord
CustomCategory.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (74)
in /home/rose/dev/index.php (12)
21:20:02.938549 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)
21:20:02.938914 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)
21:20:02.939090 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)
21:20:02.939265 trace system.CModule
Loading "urlManager" application component
in /home/rose/dev/index.php (12)
21:20:02.943103 trace system.web.filters.CFilterChain
Running filter ProductController.filteraccessControl()
in /home/rose/dev/index.php (12)
21:20:02.943454 trace system.db.ar.CActiveRecord
User.findByPk()
in /home/rose/dev/protected/controllers/ProductController.php (293)
in /home/rose/dev/index.php (12)
21:20:02.943562 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)
21:20:02.943970 trace system.db.ar.CActiveRecord
PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (319)
in /home/rose/dev/index.php (12)
21:20:02.944000 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)
21:20:02.944392 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)
21:20:02.944530 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)
21:20:02.944679 trace system.db.ar.CActiveRecord
PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (322)
in /home/rose/dev/index.php (12)
21:20:02.944703 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)
21:20:02.960589 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.960639 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)
21:20:02.961455 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)
21:20:02.961642 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)
21:20:02.961921 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.961966 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)
21:20:02.962141 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.962187 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)
21:20:02.962359 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.962403 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)
21:20:02.962621 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.962663 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)
21:20:02.962806 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.962852 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)
21:20:02.963033 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.963077 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)
21:20:02.963265 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.963304 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)
21:20:02.963439 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.963478 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)
21:20:02.963686 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.963725 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)
21:20:02.963861 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.964001 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)
21:20:02.964150 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.964189 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)
21:20:02.964329 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.964368 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)
21:20:02.964503 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.964541 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)
21:20:02.964680 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.964719 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)
21:20:02.964850 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.964889 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)
21:20:02.965023 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.965064 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)
21:20:02.965195 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.965234 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)
21:20:02.965368 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.965406 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)
21:20:02.965540 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.965579 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)
21:20:02.965749 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.965787 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)
21:20:02.965925 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.965965 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)
21:20:02.966095 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.966134 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)
21:20:02.966269 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.966306 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)
21:20:02.966437 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.966475 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)
21:20:02.966609 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.966645 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)
21:20:02.966778 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.966815 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)
21:20:02.966948 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.966985 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)
21:20:02.967128 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.967166 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)
21:20:02.967298 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.967336 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)
21:20:02.967472 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.967509 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)
21:20:02.967642 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.967679 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)
21:20:02.967816 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.967854 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)
21:20:02.967988 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.968025 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)
21:20:02.968161 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.968199 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)
21:20:02.968336 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.968374 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)
21:20:02.968507 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.968545 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)
21:20:02.968679 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.968718 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)
21:20:02.968847 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.968885 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)
21:20:02.969044 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.969083 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)
21:20:02.969219 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.969259 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)
21:20:02.969391 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.969429 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)
21:20:02.969564 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.969604 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)
21:20:02.969736 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.969774 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)
21:20:02.969912 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.969969 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)
21:20:02.970128 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.970163 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)
21:20:02.970302 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.970344 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)
21:20:02.970477 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.970515 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)
21:20:02.970644 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.970681 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)
21:20:02.970817 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.970864 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)
21:20:02.970993 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.971029 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)
21:20:02.971152 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.971189 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)
21:20:02.971309 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.971348 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)
21:20:02.971554 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.971591 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)
21:20:02.971731 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.971769 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)
21:20:02.971918 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.971956 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)
21:20:02.972091 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.972130 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)
21:20:02.972250 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.972289 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)
21:20:02.972474 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.972511 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)
21:20:02.972630 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.972667 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)
21:20:02.972788 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.972825 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)
21:20:02.972949 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.972986 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)
21:20:02.973141 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.973258 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)
21:20:02.973404 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.973443 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)
21:20:02.973587 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.973627 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)
21:20:02.973767 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.973805 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)
21:20:02.973944 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.973984 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)
21:20:02.974119 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.974158 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)
21:20:02.974292 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.974330 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)
21:20:02.974463 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.974502 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)
21:20:02.974634 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.974673 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)
21:20:02.974803 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.974841 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)
21:20:02.974976 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.975017 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)
21:20:02.975150 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.975188 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)
21:20:02.975317 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.975356 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)
21:20:02.975488 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.975527 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)
21:20:02.975768 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.975805 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)
21:20:02.975943 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.975981 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)
21:20:02.976114 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
21:20:02.976150 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)
21:20:02.977686 trace system.db.ar.CActiveRecord
CartItem.findAllByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (588)
in /home/rose/dev/index.php (12)
21:20:02.977729 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)
21:20:02.978245 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)
21:20:02.978403 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)
21:20:03.026359 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)
21:20:03.026794 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)
21:20:03.026855 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)
21:20:03.045059 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)
21:20:03.045109 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)
21:20:03.057779 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)
21:20:03.057827 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)
21:20:03.058459 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)
21:20:03.058650 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)
21:20:03.058857 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)
21:20:03.059050 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)
21:20:03.059420 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)
21:20:03.059446 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)
21:20:03.059807 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)
21:20:03.060056 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)
21:20:03.060436 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)
21:20:03.060619 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)
21:20:03.061827 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)
21:20:03.061866 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)
21:20:03.062203 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)
21:20:03.062233 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)
21:20:03.062731 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)
21:20:03.062871 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)
21:20:03.063350 trace system.CModule
Loading "clientScript" application component
in /home/rose/dev/protected/controllers/ProductController.php (621)
in /home/rose/dev/index.php (12)