OfficeCo

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

Products

Education
Classroom & Teacher
Wax Crayons

Staedtler 223M12 Water Crayons - Metal Box

$1.25 $12.50

SKU: 67-121

Details: Unit of measure: lbs., 12/pack

Description: Apply on a variety of paper colours. Use dry or with water for colour washes, shading and blending. Special effects can be achieved by layering and scratching. Create dramatic watercolor paintings, or use with rubber stamping and scrapbooking
Inventory: Edmonton: 22

Application Log
Timestamp	Level	Category	Message
00:19:58.767061	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
00:19:58.767368	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
00:19:58.767851	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
00:19:58.768234	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
00:19:58.771284	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
00:19:58.772811	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
00:19:58.774002	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)
00:19:58.775161	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)
00:19:58.775810	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)
00:19:58.776027	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
00:19:58.776622	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
00:19:58.937539	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
00:19:58.937593	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)
00:19:58.938617	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)
00:19:58.940766	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)
00:19:58.941390	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)
00:19:58.941575	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)
00:19:58.941886	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
00:19:58.941905	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)
00:19:58.942446	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)
00:19:58.942565	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)
00:19:58.942797	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
00:19:58.942816	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)
00:19:58.943330	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)
00:19:58.943444	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)
00:19:58.943563	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
00:19:58.946356	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
00:19:58.946630	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (724) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:19:58.946732	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/controllers/ProductController.php (724) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:19:58.947295	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:19:58.947310	trace	system.db.CDbCommand	Querying SQL: SELECT products.*, sale_prices.price AS saleprice FROM products LEFT OUTER JOIN sale_prices ON products.id=sale_prices.product_id AND (customer_id=5) AND (NOW() BETWEEN startdate AND enddate) WHERE products.active=1 AND products.id = 5781 ORDER BY sale_prices.price DESC LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:19:58.947613	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:19:58.948221	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:19:58.948364	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (135) in /home/rose/dev/index.php (12)
00:19:58.948441	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/controllers/ProductController.php (135) in /home/rose/dev/index.php (12)
00:19:58.948753	trace	system.db.ar.CActiveRecord	Favourite.findAll() in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
00:19:58.948772	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `favourites` in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
00:19:58.949290	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `favourites` in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
00:19:58.949393	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `favourites` `t` WHERE customer_id=1826 AND product_id=5781 in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
00:19:58.949541	trace	system.db.ar.CActiveRecord	lazy loading Product.categories in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:19:58.949723	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:19:58.950252	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:19:58.950388	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:19:58.950886	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:19:58.951008	trace	system.db.CDbCommand	Querying SQL: SELECT `categories`.`id` AS `t1_c0`, `categories`.`parent_id` AS `t1_c1`, `categories`.`name` AS `t1_c2`, `categories`.`image` AS `t1_c3`, `categories`.`fprose` AS `t1_c4`, `categories`.`fpoffice` AS `t1_c5`, `categories`.`spr` AS `t1_c6`, `categories`.`Column 8` AS `t1_c7` FROM `categories` `categories` INNER JOIN `product_categories` `categories_categories` ON (`categories_categories`.`product_id`=:ypl0) AND (`categories`.`id`=`categories_categories`.`category_id`) WHERE (spr=1) in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:19:58.951209	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (170) in /home/rose/dev/index.php (12)
00:19:58.951231	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=1450 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (170) in /home/rose/dev/index.php (12)
00:19:58.952928	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (170)
00:19:58.952950	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=1413 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (170)
00:19:58.953104	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
00:19:58.953125	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=1410 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
00:19:58.953244	trace	system.db.ar.CActiveRecord	Product.findAllBySql() in /home/rose/dev/protected/controllers/ProductController.php (180) in /home/rose/dev/index.php (12)
00:19:58.953257	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) INNER JOIN product_categories ON category_id=1450 AND product_categories.product_id=products.id GROUP BY products.id ORDER BY RAND() LIMIT 4 in /home/rose/dev/protected/controllers/ProductController.php (180) in /home/rose/dev/index.php (12)
00:19:58.954184	trace	system.db.ar.CActiveRecord	AttributeValue.findAll() in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:19:58.954209	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attribute_values` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:19:58.954727	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attribute_values` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:19:58.954941	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attribute_categories` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:19:58.955425	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attribute_categories` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:19:58.955723	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attributes` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:19:58.956221	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attributes` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:19:58.956346	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`product_id` AS `t0_c0`, `t`.`category_id` AS `t0_c1`, `t`.`attribute_id` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`uploaded` AS `t0_c4`, `category`.`id` AS `t1_c0`, `category`.`name` AS `t1_c1`, `category`.`uploaded` AS `t1_c2`, `attribute`.`id` AS `t2_c0`, `attribute`.`name` AS `t2_c1`, `attribute`.`uploaded` AS `t2_c2` FROM `product_attribute_values` `t` LEFT OUTER JOIN `product_attribute_categories` `category` ON (`t`.`category_id`=`category`.`id`) LEFT OUTER JOIN `product_attributes` `attribute` ON (`t`.`attribute_id`=`attribute`.`id`) WHERE (product_id = 5781) ORDER BY category_id ASC in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:19:59.012063	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
00:19:59.012109	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
00:19:59.013138	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
00:19:59.013386	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cart_items` `t` WHERE `t`.`session_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
00:19:59.038646	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.038826	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.039305	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.039336	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_list_details` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.040203	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_list_details` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.040472	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_lists` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.041045	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_lists` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.041203	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.042649	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.042716	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_exceptions` in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.044382	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_exceptions` in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.044521	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=5781 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.045120	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.045197	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `sale_prices` in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.046286	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `sale_prices` in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.046437	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=5781 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.047055	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.047229	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.047466	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.047559	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.048712	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.048763	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=5784 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.049057	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.049091	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=5784 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.049583	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.049673	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.049927	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.049998	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.051093	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.051115	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=7891 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.051249	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.051266	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=7891 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.051651	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.051734	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.051947	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.052015	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.053044	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.053061	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=8856 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.053191	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.053208	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=8856 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.053599	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.053678	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.053884	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.053950	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.054972	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.054991	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=9447 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.055124	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.055140	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=9447 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:19:59.055572	trace	system.CModule	Loading "widgetFactory" application component in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (199) in /home/rose/dev/index.php (12)
00:19:59.056139	trace	system.db.ar.CActiveRecord	CartItem.count() in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.056196	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `cart_items` `t` WHERE session_id = :sid in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.067629	trace	system.db.ar.CActiveRecord	CartItem.count() in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (118) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.067661	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `cart_items` `t` WHERE session_id = :sid in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (118) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.079504	trace	system.db.ar.CActiveRecord	Product.findByPk() in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.079612	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `products` `t` WHERE `t`.`id`=13228 LIMIT 1 in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:19:59.079948	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)
00:19:59.080180	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)
00:19:59.080480	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)
00:19:59.080584	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)
00:19:59.081685	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)
00:19:59.081708	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)
00:19:59.081898	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)
00:19:59.081931	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)
00:19:59.082284	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (199) in /home/rose/dev/index.php (12)

Products

Education
Classroom & Teacher
Wax Crayons

Staedtler 223M12 Water Crayons - Metal Box

$1.25 $12.50

You May Also Like

Crayola 529703 Window Crayons

67-125

Crayola 524512 Twistable Crayons

67-103B

Crayola 520016 Crayons - 16/pack

67-130

Crayola 988658 Dry Erase Crayons (for Whiteboard)

67-135

General Information

Product Information

Physical Characteristics

Products Education Classroom & TeacherWax Crayons

Staedtler 223M12 Water Crayons - Metal Box

$1.25 $12.50

You May Also Like

Crayola 529703 Window Crayons

67-125

Crayola 524512 Twistable Crayons

67-103B

Crayola 520016 Crayons - 16/pack

67-130

Crayola 988658 Dry Erase Crayons (for Whiteboard)

67-135

General Information

Product Information

Physical Characteristics

Are you sure

Products

Education
Classroom & Teacher
Wax Crayons