OfficeCo

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

Products

Narrowed By:

Pack Weight: 8

Showing 1 to 3 of 3

Elmers 60385Q Glue All - 950mL

42-112

Unit of measure: lbs.

1603 090 White Cartridge Paper 90m - 24" x 36"

7-103

Unit of measure: lbs., 96/pack

Elmers 6155060331 School Glue - 950mL

42-112a

Unit of measure: lbs.

Application Log
Timestamp	Level	Category	Message
14:24:54.331130	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
14:24:54.331418	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
14:24:54.331806	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
14:24:54.332206	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
14:24:54.335199	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:24:54.336643	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:24:54.337747	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:24:54.338562	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:24:54.339133	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `portals` `t` WHERE `t`.`domain`=:yp0 LIMIT 1 in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:24:54.339289	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
14:24:54.339860	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
14:24:54.425764	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:24:54.425802	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:24:54.426479	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:24:54.428252	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:24:54.428827	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:24:54.428982	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:24:54.429287	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:24:54.429306	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:24:54.429809	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:24:54.429908	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `hidden_products` `t` WHERE (customer_id = 3259 OR group_id=5) AND category_id <> 0 in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:24:54.430152	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:24:54.430170	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:24:54.430664	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:24:54.430753	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cust_categories` `t` WHERE group_id=5 in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:24:54.430866	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
14:24:54.433614	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
14:24:54.433845	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
14:24:54.433926	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
14:24:54.434266	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:24:54.434288	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_exceptions` in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:24:54.434803	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_exceptions` in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:24:54.434910	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `price_exceptions` `t` WHERE customer_id=3259 in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:24:54.435019	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
14:24:54.435034	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `price_exceptions` `t` WHERE customer_id=0 in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
14:24:54.442701	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:24:54.442735	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=5217 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:24:54.443195	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:24:54.443845	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:24:54.443985	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:24:54.443996	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=5813 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:24:54.444295	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:24:54.444305	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=9984 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:24:54.444786	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.444808	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `categories` in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.445346	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `categories` in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.445487	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)
14:24:54.445607	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.445632	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)
14:24:54.445748	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.445770	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)
14:24:54.445904	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.445935	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)
14:24:54.446026	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.446048	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)
14:24:54.446130	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.446150	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)
14:24:54.446259	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.446290	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)
14:24:54.446386	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.446408	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)
14:24:54.446487	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.446510	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)
14:24:54.446588	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
14:24:54.446610	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)
14:24:54.447043	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
14:24:54.447065	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)
14:24:54.447973	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)
14:24:54.448107	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)
14:24:54.476751	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.476922	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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.477336	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.477363	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/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.478168	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/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.478409	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/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.478912	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/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.479054	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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.480155	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.480187	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=5217 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.480674	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.480704	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/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.481792	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/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.481936	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=5217 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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.482429	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.482556	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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.482836	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.482924	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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.483995	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.484023	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=5813 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.484174	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.484199	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=5813 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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.484631	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.484735	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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.484971	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.485059	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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.486109	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.486135	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=9984 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.486289	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.486308	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=9984 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_list.php (2) in /home/rose/dev/protected/views/product/list.php (231)
14:24:54.486701	trace	system.CModule	Loading "widgetFactory" application component in /home/rose/dev/protected/views/product/list.php (238) in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)
14:24:54.487514	trace	system.CModule	Loading "coreMessages" application component in /home/rose/dev/protected/views/product/list.php (238) in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)
14:24:54.488436	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)
14:24:54.488487	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)
14:24:54.501086	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)
14:24:54.501116	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)
14:24:54.513582	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)
14:24:54.513622	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)
14:24:54.513806	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)
14:24:54.513921	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)
14:24:54.514146	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)
14:24:54.514228	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)
14:24:54.515244	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)
14:24:54.515264	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)
14:24:54.515407	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)
14:24:54.515428	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)
14:24:54.515691	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)

Price

Category

Manufacturer

Color

Dimensions

Quantity

Products

Elmers 60385Q Glue All - 950mL

42-112

1603 090 White Cartridge Paper 90m - 24" x 36"

7-103

Elmers 6155060331 School Glue - 950mL

42-112a

Products

Elmers 60385Q Glue All - 950mL

42-112

1603 090 White Cartridge Paper 90m - 24" x 36"

7-103

Elmers 6155060331 School Glue - 950mL

42-112a

Are you sure