OfficeCo

No deliveries Dec. 20, 2023 until Jan 2,2024. Click for more info.

Products

Office
Storage & Organizers
Key Control
Key Boxes & Cabinets

Sparco All-Steel Hook Design Key Cabinet

$1.25 $50.83

SKU: SPR15600

Details: 10" x 3" x 12" - Security Lock - Gray - Steel

Description: Rack-style key cabinet features a hook design for organizing keys and durable, all-steel construction. Secure up to 28 keys with a combination lock. Key cabinet includes white plastic key tags and hardware for mounting on a wall.
Inventory: Edmonton: Out Of Stock

Application Log
Timestamp	Level	Category	Message
21:02:16.915545	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
21:02:16.919802	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
21:02:16.920470	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
21:02:16.920675	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
21:02:16.926012	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
21:02:16.928170	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
21:02:16.936327	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:02:16.937911	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:02:16.939642	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:02:16.941132	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
21:02:16.941970	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
21:02:16.943815	trace	system.db.ar.CActiveRecord	User.find() in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
21:02:16.954344	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `users` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
21:02:16.955012	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `users` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
21:02:16.956720	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `accounts` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
21:02:16.957372	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `accounts` in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
21:02:16.957839	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (LOWER(username)=?) in /home/rose/dev/protected/components/UserIdentity.php (19) in /home/rose/dev/protected/components/BeginRequest.php (21) in /home/rose/dev/index.php (12)
21:02:16.972285	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
21:02:16.972457	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:02:16.972843	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
21:02:16.972873	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:02:16.975744	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:02:16.975862	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:02:16.976140	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
21:02:16.976176	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:02:16.976897	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:02:16.982472	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:02:16.982635	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
21:02:16.989919	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
21:02:16.990287	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (724) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
21:02:16.990436	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 (724) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
21:02:16.996212	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
21:02:16.996237	trace	system.db.CDbCommand	Querying SQL: SELECT products.*, sale_prices.price AS saleprice FROM products LEFT OUTER JOIN sale_prices ON products.id=sale_prices.product_id AND (customer_id=5) AND (NOW() BETWEEN startdate AND enddate) WHERE products.active=1 AND products.id = 22404 ORDER BY sale_prices.price DESC LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
21:02:16.996546	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
21:02:16.997126	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
21:02:16.997287	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (135) in /home/rose/dev/index.php (12)
21:02:16.997406	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 (135) in /home/rose/dev/index.php (12)
21:02:16.997771	trace	system.db.ar.CActiveRecord	Favourite.findAll() in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
21:02:16.997797	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `favourites` in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
21:02:16.998172	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `favourites` in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
21:02:16.998272	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `favourites` `t` WHERE customer_id=1826 AND product_id=22404 in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
21:02:16.998416	trace	system.db.ar.CActiveRecord	lazy loading Product.categories in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
21:02:16.998640	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
21:02:16.999087	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
21:02:16.999279	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
21:02:16.999634	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
21:02:16.999763	trace	system.db.CDbCommand	Querying SQL: SELECT `categories`.`id` AS `t1_c0`, `categories`.`parent_id` AS `t1_c1`, `categories`.`name` AS `t1_c2`, `categories`.`image` AS `t1_c3`, `categories`.`fprose` AS `t1_c4`, `categories`.`fpoffice` AS `t1_c5`, `categories`.`spr` AS `t1_c6`, `categories`.`Column 8` AS `t1_c7` FROM `categories` `categories` INNER JOIN `product_categories` `categories_categories` ON (`categories_categories`.`product_id`=:ypl0) AND (`categories`.`id`=`categories_categories`.`category_id`) WHERE (spr=1) in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
21:02:17.000030	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (170) in /home/rose/dev/index.php (12)
21:02:17.000061	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=654 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (170) in /home/rose/dev/index.php (12)
21:02:17.002746	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (170)
21:02:17.002779	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=652 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (170)
21:02:17.005733	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
21:02:17.005762	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=651 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
21:02:17.005914	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
21:02:17.005942	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=1403 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
21:02:17.006086	trace	system.db.ar.CActiveRecord	Product.findAllBySql() in /home/rose/dev/protected/controllers/ProductController.php (180) in /home/rose/dev/index.php (12)
21:02:17.006104	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) INNER JOIN product_categories ON category_id=654 AND product_categories.product_id=products.id GROUP BY products.id ORDER BY RAND() LIMIT 4 in /home/rose/dev/protected/controllers/ProductController.php (180) in /home/rose/dev/index.php (12)
21:02:17.007884	trace	system.db.ar.CActiveRecord	AttributeValue.findAll() in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
21:02:17.007917	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attribute_values` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
21:02:17.015759	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attribute_values` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
21:02:17.016063	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attribute_categories` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
21:02:17.016458	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attribute_categories` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
21:02:17.016684	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attributes` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
21:02:17.017075	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attributes` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
21:02:17.017219	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`product_id` AS `t0_c0`, `t`.`category_id` AS `t0_c1`, `t`.`attribute_id` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`uploaded` AS `t0_c4`, `category`.`id` AS `t1_c0`, `category`.`name` AS `t1_c1`, `category`.`uploaded` AS `t1_c2`, `attribute`.`id` AS `t2_c0`, `attribute`.`name` AS `t2_c1`, `attribute`.`uploaded` AS `t2_c2` FROM `product_attribute_values` `t` LEFT OUTER JOIN `product_attribute_categories` `category` ON (`t`.`category_id`=`category`.`id`) LEFT OUTER JOIN `product_attributes` `attribute` ON (`t`.`attribute_id`=`attribute`.`id`) WHERE (product_id = 22404) ORDER BY category_id ASC in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
21:02:17.171646	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
21:02:17.171683	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
21:02:17.172266	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
21:02:17.172419	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cart_items` `t` WHERE `t`.`session_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
21:02:17.197427	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.197536	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 (128) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.197848	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.197869	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_list_details` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.198204	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_list_details` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.198405	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_lists` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.198721	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_lists` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.198831	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 (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.199929	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.199950	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_exceptions` in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.200282	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_exceptions` in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.200366	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=22404 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.200592	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.200613	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `sale_prices` in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.200937	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `sale_prices` in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.201030	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=22404 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
21:02:17.201452	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.201530	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 (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.201725	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.201791	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 (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.202826	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.202847	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=14975 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.202953	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.202970	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=14975 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.203308	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.203385	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 (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.203567	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.203633	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 (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.204585	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.204603	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=26119 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.204719	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.204736	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=26119 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.205055	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.205133	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 (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.205322	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.205387	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 (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.206403	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.206423	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=22398 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.206537	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.206556	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=22398 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.206868	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.206943	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 (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.207142	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.207206	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 (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.208163	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.208183	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=22395 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.208312	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.208329	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=22395 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
21:02:17.208673	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 (199) in /home/rose/dev/index.php (12)
21:02:17.209134	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 (199)
21:02:17.209175	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 (199)
21:02:17.221602	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 (199)
21:02:17.221632	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 (199)
21:02:17.233521	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 (199)
21:02:17.233550	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 (199)
21:02:17.233712	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:02:17.233788	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:02:17.233992	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:02:17.234052	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:02:17.235064	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:02:17.235083	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:02:17.235212	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:02:17.235225	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:02:17.238068	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (199) in /home/rose/dev/index.php (12)

Products

Office
Storage & Organizers
Key Control
Key Boxes & Cabinets

Sparco All-Steel Hook Design Key Cabinet

$1.25 $50.83

You May Also Like

Steelmaster Key Cabinet - 160-Key Capacity

MMF201916003

Steelmaster Security Key Cabinet

MMF2017290G2

Sparco All-Steel Slot-Style 60-Key Cabinet

SPR15602

Sparco All-Steel Slot-Style 110-Key Cabinet

SPR15604

General Information

Product Information

Physical Characteristics

Miscellaneous

Products OfficeStorage & OrganizersKey ControlKey Boxes & Cabinets

Sparco All-Steel Hook Design Key Cabinet

$1.25 $50.83

You May Also Like

Steelmaster Key Cabinet - 160-Key Capacity

MMF201916003

Steelmaster Security Key Cabinet

MMF2017290G2

Sparco All-Steel Slot-Style 60-Key Cabinet

SPR15602

Sparco All-Steel Slot-Style 110-Key Cabinet

SPR15604

General Information

Product Information

Physical Characteristics

Miscellaneous

Are you sure

Products

Office
Storage & Organizers
Key Control
Key Boxes & Cabinets