OfficeCo

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

Products

Narrowed By:

Quantity: 1 Material: Paper Price: $0.00 to $200.00

Showing 1 to 20 of 119

Dennecrepe 02215 Orange Crepe Paper Streamer - 4.8cm x 152m

17-133

Unit of measure: lbs.

Dennecrepe 02218 Pink Crepe Paper Streamer - 4.8cm x 152m

17-134

Unit of measure: lbs.

Dennecrepe 02226 Red Crepe Paper Streamer - 4.8cm x 152m

17-135

Unit of measure: lbs.

Dennecrepe 02238 Violet Crepe Paper Streamer - 4.8cm x 152m

17-136

Unit of measure: lbs.

Dennecrepe 02200 White Crepe Paper Streamer - 4.8cm x 152m

17-137

Unit of measure: lbs.

Dennecrepe 02203 Primrose Yellow (Light) Crepe Paper Streamer - 4.8cm x 152

17-141

Unit of measure: lbs.

Roylco 15313 Building Design Paper - 8.5" x 11"

18-131

Unit of measure: lbs., 40/pack

Hilroy 43322 Top Coil Memo Books (48sh/pad) - 3" x 5"

20-106

Unit of measure: lbs.

Hilroy 26421 Manila Coil Scrapbook (30sh/book) - 10" x 12"

20-107

Unit of measure: lbs.

Hilroy 26411 Manila Coil Scrapbook (20sh/book) - 11" x 14"

20-108

Unit of measure: lbs.

Hilroy 415111 Sketch Book Top Coil (30pgs) - 9" x 12"

20-120

Unit of measure: lbs.

Hilroy 12150 Exercise Books 1/2 Ruled (72pgs) - 7" x 9"

20-122

Unit of measure: lbs.

Hilroy 12152 Exercise Books Interlined (72pgs) - 7" x 9"

20-123

Unit of measure: lbs.

Hilroy 12154 Exercise Books Plain (72pgs) - 7" x 9"

20-124

Unit of measure: lbs.

Hilroy 12155 Exercise Books 1/2 Interlined (72pgs) - 7" x 9"

20-125

Unit of measure: lbs.

Hilroy 12901 Exercise Books Wide Ruled (72pgs) - 7" x 9"

20-126

Unit of measure: lbs.

Hilroy 11185 Exercise Books 3 Hole Punch (80pgs) - 8.5" x 11"

20-127

Unit of measure: lbs.

Hilroy 9924 Composition Book Marble (200pgs) - 9.75" x 7.5"

20-133

Unit of measure: lbs.

Pacon 4794 Side Coil Sketch Book 50lb True Rite (70pgs) - 8.5" x 11"

20-135

Unit of measure: lbs.

Pacon 4790 Side Coil Sketch Book 50lb True Rite (160pgs) - 6" x 9"

20-1351

Unit of measure: lbs.

Showing 1 to 20 of 119

Application Log
Timestamp	Level	Category	Message
23:06:28.545685	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
23:06:28.546066	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
23:06:28.546499	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
23:06:28.546823	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
23:06:28.549933	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
23:06:28.551723	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
23:06:28.553611	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
23:06:28.554833	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
23:06:28.555510	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `portals` `t` WHERE `t`.`domain`=:yp0 LIMIT 1 in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
23:06:28.555677	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
23:06:28.556349	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
23:06:28.611119	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
23:06:28.611175	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
23:06:28.611920	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
23:06:28.613966	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
23:06:28.614547	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
23:06:28.614716	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
23:06:28.615032	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
23:06:28.615051	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
23:06:28.615590	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
23:06:28.615710	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `hidden_products` `t` WHERE (customer_id = 3259 OR group_id=5) AND category_id <> 0 in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
23:06:28.615940	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
23:06:28.615957	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
23:06:28.616458	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
23:06:28.616550	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cust_categories` `t` WHERE group_id=5 in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
23:06:28.616671	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
23:06:28.619492	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
23:06:28.619729	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
23:06:28.619810	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
23:06:28.620150	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
23:06:28.620172	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_exceptions` in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
23:06:28.620678	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_exceptions` in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
23:06:28.620790	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `price_exceptions` `t` WHERE customer_id=3259 in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
23:06:28.620907	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
23:06:28.620920	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `price_exceptions` `t` WHERE customer_id=0 in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
23:06:28.637949	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.637969	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=4217 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.638530	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)
23:06:28.639260	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)
23:06:28.639405	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.639415	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=4218 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.639703	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.639713	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=4219 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.639988	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.639998	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=4220 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.640258	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.640266	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=4221 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.640522	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.640532	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=4225 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.640789	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.640798	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=4258 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.641096	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.641104	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=4335 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.641364	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.641372	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=4336 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.641777	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.641788	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=4337 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.642041	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.642051	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=4348 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.642549	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.642594	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=4350 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.642900	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.642914	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=4351 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.643168	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.643181	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=4352 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.643438	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.643449	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=4353 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.643697	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.643708	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=4354 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.643959	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.643971	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=4360 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.644224	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.644237	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=4366 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.644501	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.644515	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=4368 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.644754	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.644813	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=4369 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
23:06:28.645390	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.645457	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `categories` in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646049	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `categories` in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646203	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646308	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646333	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646415	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646439	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646507	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646528	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646590	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646611	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646697	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646719	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646784	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646805	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646879	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646902	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646969	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.646991	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647053	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647073	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647149	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647171	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647233	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647254	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647327	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647350	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647413	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647434	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647505	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647526	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647600	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647623	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647689	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647710	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647794	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647816	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647890	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647912	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647977	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.647998	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648068	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648091	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648155	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648176	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648236	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648257	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648315	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648336	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648397	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648427	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648509	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648530	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648597	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648617	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648679	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648699	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648773	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648796	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648864	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648885	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648947	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.648968	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649033	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649054	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649127	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649147	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649221	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649244	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649307	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649328	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649391	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649411	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649471	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649492	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649564	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649585	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649651	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649671	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649734	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649754	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649815	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649836	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649899	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649919	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.649981	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650002	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650063	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650083	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650141	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650161	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650234	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650255	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650319	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650340	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650401	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650422	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650494	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650515	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650588	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650609	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650686	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650707	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650772	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650793	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650856	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650876	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650938	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.650959	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.651021	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.651042	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.651103	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.651124	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=:yp0 AND `t`.`spr`=:yp1 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:06:28.651712	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
23:06:28.651737	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
23:06:28.652293	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
23:06:28.652391	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cart_items` `t` WHERE `t`.`session_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
23:06:28.680366	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)
23:06:28.680517	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)
23:06:28.680887	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)
23:06:28.680913	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)
23:06:28.681575	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)
23:06:28.681798	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)
23:06:28.682312	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)
23:06:28.682470	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)
23:06:28.683489	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)
23:06:28.683517	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4217 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)
23:06:28.683748	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)
23:06:28.683769	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)
23:06:28.684257	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)
23:06:28.684340	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4217 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)
23:06:28.684698	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)
23:06:28.684778	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)
23:06:28.684966	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)
23:06:28.685029	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)
23:06:28.686021	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)
23:06:28.686038	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4218 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)
23:06:28.686146	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)
23:06:28.686162	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4218 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)
23:06:28.686485	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)
23:06:28.686559	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)
23:06:28.686737	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)
23:06:28.686798	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)
23:06:28.687751	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)
23:06:28.687767	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4219 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)
23:06:28.687869	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)
23:06:28.687885	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4219 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)
23:06:28.688246	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)
23:06:28.688328	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)
23:06:28.688512	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)
23:06:28.688575	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)
23:06:28.689552	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)
23:06:28.689569	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4220 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)
23:06:28.689672	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)
23:06:28.689687	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4220 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)
23:06:28.690032	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)
23:06:28.690104	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)
23:06:28.690280	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)
23:06:28.690340	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)
23:06:28.691330	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)
23:06:28.691348	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4221 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)
23:06:28.691492	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)
23:06:28.691508	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4221 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)
23:06:28.691849	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)
23:06:28.691924	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)
23:06:28.692110	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)
23:06:28.692172	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)
23:06:28.693152	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)
23:06:28.693170	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4225 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)
23:06:28.693273	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)
23:06:28.693289	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4225 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)
23:06:28.693597	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)
23:06:28.693670	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)
23:06:28.693842	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)
23:06:28.693902	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)
23:06:28.694853	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)
23:06:28.694869	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4258 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)
23:06:28.694971	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)
23:06:28.694987	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4258 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)
23:06:28.695295	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)
23:06:28.695368	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)
23:06:28.695576	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)
23:06:28.695636	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)
23:06:28.696614	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)
23:06:28.696630	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4335 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)
23:06:28.696736	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)
23:06:28.696751	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4335 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)
23:06:28.697069	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)
23:06:28.697148	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)
23:06:28.697320	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)
23:06:28.697381	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)
23:06:28.698348	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)
23:06:28.698365	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4336 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)
23:06:28.698467	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)
23:06:28.698482	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4336 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)
23:06:28.698812	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)
23:06:28.698887	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)
23:06:28.699064	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)
23:06:28.699125	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)
23:06:28.700104	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)
23:06:28.700123	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4337 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)
23:06:28.700228	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)
23:06:28.700244	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4337 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)
23:06:28.700547	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)
23:06:28.700629	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)
23:06:28.700813	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)
23:06:28.700875	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)
23:06:28.701853	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)
23:06:28.701872	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4348 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)
23:06:28.701976	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)
23:06:28.701991	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4348 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)
23:06:28.702318	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)
23:06:28.702393	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)
23:06:28.702568	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)
23:06:28.702627	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)
23:06:28.703586	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)
23:06:28.703603	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4350 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)
23:06:28.703705	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)
23:06:28.703720	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4350 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)
23:06:28.704636	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)
23:06:28.704890	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)
23:06:28.705176	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)
23:06:28.705262	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)
23:06:28.706437	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)
23:06:28.706491	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4351 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)
23:06:28.706659	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)
23:06:28.706684	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4351 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)
23:06:28.707501	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)
23:06:28.707668	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)
23:06:28.707925	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)
23:06:28.708022	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)
23:06:28.709208	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)
23:06:28.709238	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4352 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)
23:06:28.709489	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)
23:06:28.709516	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4352 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)
23:06:28.710016	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)
23:06:28.710125	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)
23:06:28.710396	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)
23:06:28.710484	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)
23:06:28.711523	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)
23:06:28.711548	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4353 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)
23:06:28.711684	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)
23:06:28.711703	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4353 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)
23:06:28.712085	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)
23:06:28.712207	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)
23:06:28.712462	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)
23:06:28.712547	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)
23:06:28.713602	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)
23:06:28.713622	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4354 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)
23:06:28.713759	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)
23:06:28.713776	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4354 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)
23:06:28.714129	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)
23:06:28.714205	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)
23:06:28.714417	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)
23:06:28.714482	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)
23:06:28.715606	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)
23:06:28.715626	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4360 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)
23:06:28.715760	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)
23:06:28.715778	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4360 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)
23:06:28.716155	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)
23:06:28.716232	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)
23:06:28.716434	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)
23:06:28.716497	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)
23:06:28.717490	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)
23:06:28.717514	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4366 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)
23:06:28.717665	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)
23:06:28.717690	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4366 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)
23:06:28.718111	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)
23:06:28.718202	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)
23:06:28.718409	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)
23:06:28.718476	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)
23:06:28.719477	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)
23:06:28.719496	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4368 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)
23:06:28.719635	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)
23:06:28.719659	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4368 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)
23:06:28.720086	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)
23:06:28.720171	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)
23:06:28.720382	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)
23:06:28.720448	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)
23:06:28.721472	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)
23:06:28.721493	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=4369 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)
23:06:28.721641	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)
23:06:28.721658	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=4369 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)
23:06:28.721896	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)
23:06:28.722990	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)
23:06:28.724371	trace	system.db.ar.CActiveRecord	CartItem.count() in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (621)
23:06:28.724425	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `cart_items` `t` WHERE session_id = :sid in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (621)
23:06:28.735989	trace	system.db.ar.CActiveRecord	CartItem.count() in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (118) in /home/rose/dev/protected/controllers/ProductController.php (621)
23:06:28.736026	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `cart_items` `t` WHERE session_id = :sid in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (118) in /home/rose/dev/protected/controllers/ProductController.php (621)
23:06:28.747227	trace	system.db.ar.CActiveRecord	Product.findByPk() in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143) in /home/rose/dev/protected/controllers/ProductController.php (621)
23:06:28.747266	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `products` `t` WHERE `t`.`id`=13228 LIMIT 1 in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143) in /home/rose/dev/protected/controllers/ProductController.php (621)
23:06:28.747462	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (61) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
23:06:28.747569	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (61) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
23:06:28.747783	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (83) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
23:06:28.747850	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (83) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
23:06:28.748857	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (91) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
23:06:28.748877	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=13228 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (91) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
23:06:28.749016	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (109) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
23:06:28.749032	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=13228 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (109) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
23:06:28.749612	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)

17-133

17-134

17-135

17-136

17-137

17-141

18-131

20-106

20-107

20-108

20-120

20-122

20-123

20-124

20-125

20-126

20-127

20-133

20-135

20-1351

Are you sure