OfficeCo

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

Products

Education
Pre School

Balls/Parachutes/Bean Bags Chairs/Tables/Mats Building Sets Wooden Furniture Sand & Water Accessories Special Interest Toy Cooking Sets Puzzles

Kidney 4962 Table #48KID72 - 48 x 72 -

96-116

4000 Series Activity Table, 72" Kidney-Shaped Top with Standard Legs Versatile 4000 Series tables ar...

Your Price: $766.50 $1.25

Add to cart

Rectangle Table #483060 - 30" x 60" -

96-114

4000 Series Activity Table, 30" x 60" Top with Standard Legs Versatile 4000 Series tables are great ...

Your Price: $503.78 $1.25

Add to cart

Table, Metal Frames, Adjustable Rect. #4812 - 2x4 -

96-112

4000 Series Activity Table, 24" x 48" Top with Standard Legs Versatile 4000 Series tables are great ...

Your Price: $374.40 $1.25

Add to cart

Rectangle Table Adjustable Legs #483048 - 30" x 4 -

96-113

4000 Series Activity Table, 30" x 48" Top with Standard Legs Versatile 4000 Series tables are great ...

Your Price: $445.12 $1.25

Add to cart

Horseshoe (4872) Table #48HORSE60 - 60 x 66 -

96-117

4000 Series Activity Table, 60" Horseshoe-Shaped Top with Standard Legs Versatile 4000 Series tables...

Your Price: $766.50 $1.25

Add to cart

Circle Table #4842R - 42" -

96-115

This circlular 42" table has a sturdy 1 1/8" think table top. Table edges are cushioned with prote...

Your Price: $402.61 $1.25

Add to cart

Application Log
Timestamp	Level	Category	Message
11:22:15.089129	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
11:22:15.089399	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
11:22:15.089770	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
11:22:15.090147	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
11:22:15.092814	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
11:22:15.094199	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
11:22:15.095267	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)
11:22:15.096322	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)
11:22:15.097543	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)
11:22:15.097735	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
11:22:15.098509	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
11:22:15.099378	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)
11:22:15.101227	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)
11:22:15.101785	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)
11:22:15.102056	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)
11:22:15.102425	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)
11:22:15.102577	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)
11:22:15.105324	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
11:22:15.105411	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)
11:22:15.105690	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
11:22:15.105710	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)
11:22:15.106040	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)
11:22:15.106131	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)
11:22:15.106362	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
11:22:15.106380	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)
11:22:15.106689	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)
11:22:15.106764	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)
11:22:15.106861	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
11:22:15.110229	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
11:22:15.110507	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
11:22:15.110589	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)
11:22:15.111011	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
11:22:15.111037	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)
11:22:15.111391	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)
11:22:15.111488	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)
11:22:15.111593	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
11:22:15.111608	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)
11:22:15.111829	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (375) in /home/rose/dev/index.php (12)
11:22:15.111849	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `categories` in /home/rose/dev/protected/controllers/ProductController.php (375) in /home/rose/dev/index.php (12)
11:22:15.112329	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `categories` in /home/rose/dev/protected/controllers/ProductController.php (375) in /home/rose/dev/index.php (12)
11:22:15.112523	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=1414 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (375) in /home/rose/dev/index.php (12)
11:22:15.112674	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (379) in /home/rose/dev/index.php (12)
11:22:15.112699	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=1410 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (379) in /home/rose/dev/index.php (12)
11:22:15.114751	trace	system.db.ar.CActiveRecord	Category.findAllBySql() in /home/rose/dev/protected/controllers/ProductController.php (739) in /home/rose/dev/protected/controllers/ProductController.php (381) in /home/rose/dev/index.php (12)
11:22:15.114770	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM categories WHERE id IN (SELECT parent_id FROM categories WHERE id=1414) in /home/rose/dev/protected/controllers/ProductController.php (739) in /home/rose/dev/protected/controllers/ProductController.php (381) in /home/rose/dev/index.php (12)
11:22:15.115036	trace	system.db.ar.CActiveRecord	Category.findAllBySql() in /home/rose/dev/protected/controllers/ProductController.php (739) in /home/rose/dev/protected/controllers/ProductController.php (742) in /home/rose/dev/protected/controllers/ProductController.php (381)
11:22:15.115063	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM categories WHERE id IN (SELECT parent_id FROM categories WHERE id=1410) in /home/rose/dev/protected/controllers/ProductController.php (739) in /home/rose/dev/protected/controllers/ProductController.php (742) in /home/rose/dev/protected/controllers/ProductController.php (381)
11:22:15.130331	trace	system.db.ar.CActiveRecord	Category.findAll() in /home/rose/dev/protected/controllers/ProductController.php (458) in /home/rose/dev/index.php (12)
11:22:15.130409	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE parent_id=:parent AND spr=1 in /home/rose/dev/protected/controllers/ProductController.php (458) in /home/rose/dev/index.php (12)
11:22:15.131653	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (466) in /home/rose/dev/index.php (12)
11:22:15.131690	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (466) in /home/rose/dev/index.php (12)
11:22:15.132385	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.132407	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.133069	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.133091	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.133933	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.134038	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.134738	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.134766	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.135766	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.135787	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.136480	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.136502	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.137176	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.137196	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.137912	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.137934	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.138591	trace	system.db.ar.CActiveRecord	Category.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.138612	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`parent_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (697) in /home/rose/dev/protected/controllers/ProductController.php (701) in /home/rose/dev/protected/controllers/ProductController.php (466)
11:22:15.139266	trace	system.db.ar.CActiveRecord	Product.findAllBySql() in /home/rose/dev/protected/controllers/ProductController.php (467) in /home/rose/dev/index.php (12)
11:22:15.139287	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 product_categories.product_id=products.id AND (category_id=1414 OR category_id=1453 OR category_id=1454 OR category_id=1455 OR category_id=1456 OR category_id=1457 OR category_id=1458 OR category_id=1459 OR category_id=1460 OR category_id=1546) WHERE active=1 and is_office=1 and cost <> 0 and price <> 0 ORDER BY RAND()((price-cost)/cost) DESC LIMIT 6 in /home/rose/dev/protected/controllers/ProductController.php (467) in /home/rose/dev/index.php (12)
11:22:15.141747	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` in /home/rose/dev/protected/controllers/ProductController.php (467) in /home/rose/dev/index.php (12)
11:22:15.142498	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` in /home/rose/dev/protected/controllers/ProductController.php (467) in /home/rose/dev/index.php (12)
11:22:15.142723	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
11:22:15.142760	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)
11:22:15.142878	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
11:22:15.142901	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)
11:22:15.143033	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
11:22:15.143057	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)
11:22:15.143183	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
11:22:15.143212	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)
11:22:15.143291	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
11:22:15.143321	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)
11:22:15.143824	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
11:22:15.143847	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)
11:22:15.144227	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)
11:22:15.144331	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)
11:22:15.171605	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/list.php (140)
11:22:15.171761	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/list.php (140)
11:22:15.172149	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/list.php (140)
11:22:15.172178	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.php (2) in /home/rose/dev/protected/views/product/list.php (140)
11:22:15.172763	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.php (2) in /home/rose/dev/protected/views/product/list.php (140)
11:22:15.172979	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.php (2) in /home/rose/dev/protected/views/product/list.php (140)
11:22:15.173352	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.php (2) in /home/rose/dev/protected/views/product/list.php (140)
11:22:15.173470	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/list.php (140)
11:22:15.174535	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/list.php (140)
11:22:15.174565	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6556 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/list.php (140)
11:22:15.174854	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/list.php (140)
11:22:15.174880	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.php (2) in /home/rose/dev/protected/views/product/list.php (140)
11:22:15.175214	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.php (2) in /home/rose/dev/protected/views/product/list.php (140)
11:22:15.175302	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6556 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/list.php (140)
11:22:15.175703	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/list.php (140)
11:22:15.175784	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/list.php (140)
11:22:15.175976	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/list.php (140)
11:22:15.176043	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/list.php (140)
11:22:15.177063	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/list.php (140)
11:22:15.177083	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6554 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/list.php (140)
11:22:15.177191	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/list.php (140)
11:22:15.177207	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6554 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/list.php (140)
11:22:15.177540	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/list.php (140)
11:22:15.177618	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/list.php (140)
11:22:15.177817	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/list.php (140)
11:22:15.177881	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/list.php (140)
11:22:15.178874	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/list.php (140)
11:22:15.178890	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6552 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/list.php (140)
11:22:15.178997	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/list.php (140)
11:22:15.179013	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6552 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/list.php (140)
11:22:15.179374	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/list.php (140)
11:22:15.179450	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/list.php (140)
11:22:15.179635	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/list.php (140)
11:22:15.179702	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/list.php (140)
11:22:15.180670	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/list.php (140)
11:22:15.180689	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6553 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/list.php (140)
11:22:15.180784	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/list.php (140)
11:22:15.180799	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6553 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/list.php (140)
11:22:15.181189	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/list.php (140)
11:22:15.181267	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/list.php (140)
11:22:15.181649	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/list.php (140)
11:22:15.181730	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/list.php (140)
11:22:15.182904	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/list.php (140)
11:22:15.182923	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6557 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/list.php (140)
11:22:15.183024	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/list.php (140)
11:22:15.183039	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6557 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/list.php (140)
11:22:15.183367	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/list.php (140)
11:22:15.183442	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/list.php (140)
11:22:15.183625	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/list.php (140)
11:22:15.183690	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/list.php (140)
11:22:15.184680	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/list.php (140)
11:22:15.184699	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6555 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/list.php (140)
11:22:15.184932	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/list.php (140)
11:22:15.185003	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6555 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/list.php (140)
11:22:15.185432	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)
11:22:15.185940	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)
11:22:15.185985	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)
11:22:15.197916	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)
11:22:15.197962	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)
11:22:15.209832	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)
11:22:15.209887	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)
11:22:15.210133	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)
11:22:15.210288	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)
11:22:15.210752	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)
11:22:15.210850	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)
11:22:15.212248	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)
11:22:15.212274	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)
11:22:15.212413	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)
11:22:15.212434	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)
11:22:15.212763	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)

Price

Manufacturer

Quantity

Material

Color

Pack Weight

Dimensions

Features

Style

Products

Education
Pre School

Kidney 4962 Table #48KID72 - 48 x 72 -

96-116

Rectangle Table #483060 - 30" x 60" -

96-114

Table, Metal Frames, Adjustable Rect. #4812 - 2x4 -

96-112

Rectangle Table Adjustable Legs #483048 - 30" x 4 -

96-113

Horseshoe (4872) Table #48HORSE60 - 60 x 66 -

96-117

Circle Table #4842R - 42" -

96-115

Products Education Pre School

Kidney 4962 Table #48KID72 - 48 x 72 -

96-116

Rectangle Table #483060 - 30" x 60" -

96-114

Table, Metal Frames, Adjustable Rect. #4812 - 2x4 -

96-112

Rectangle Table Adjustable Legs #483048 - 30" x 4 -

96-113

Horseshoe (4872) Table #48HORSE60 - 60 x 66 -

96-117

Circle Table #4842R - 42" -

96-115

Are you sure

Products

Education
Pre School