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

Login

Request Account

Quick Order

Cart
OfficeCo
  • Why Us?
  • Paper
    Brochures & Specialty Paper (48)Printer Paper (72)Cards & Stationery (76)Copy & Multi-use Paper (172)Notebooks, Pads & Filler Paper (716)Computer & Fax Paper (31)Register & Calculator Rolls (26)Colored Paper (2)SPR-Tagboard (15)
    Copy Paper
    Copy Paper
    $40.90
    Shop Now
  • Office
    Desk Organizers (643)Labels & Labeling Systems (426)General Supplies (1970)Filing Supplies (1973)Binders & Accessories (1563)Envelopes & Forms (516)Teaching & Art (869)Calendars & Planners (466)Mailing & Shipping (500)Writing & Correction (2437)Boards & Easels (678)Cash Handling (82)Storage & Organizers (179)Business/Travel Bags & Accessories (116)School Supplies & Art (36)
  • Furniture
    Furniture Accessories (188)Office Decor & Lighting (280)Filing, Storage & Accessories (598)Chairs, Chair Mats & Accessories (677)Carts & Stands (77)Furniture Collections, Desks & Tables (861)Armoires & Bookcases (52)Panel Systems & Accessories (71)Sofa & Accessories (23)
  • Breakroom
    Tools & Equipment (94)Climate Control (112)Cleaning & Janitorial Supplies (1481)Breakroom Supplies (800)Safety & Security (266)Cleaning & Janitorial Appliances (35)Healthcare Supplies (149)Facility Supplies (60)Cleaning Supplies (9)Cleaning Equipment (0)
  • Technology
    Printers, Multifunction, & Printing Supplies (2831)Computer Accessories (568)Drives & Media (156)Power & Backup (194)Office Machines & Electronics (704)Telephone & Communication (145)Peripherals & Memory (375)Shredders & Accessories (91)Audio & Video Players (3)Networking & Cables (81)Displays & Digital Projectors (43)Cameras & Scanners (20)Multimedia Players (99)Computers (2)
  • Education
    Art (349)Craft (345)Classroom & Teacher (1002)Pre School (111)Library (46)Physed (14)Glue (75)Paint (462)Construction Paper (165)Rolls (123)Clips (21)Binders (108)Tag Board (19)
  • Paper & Pads
Price
  1. Products
Narrowed By:
Marketing Information:

Whether you're a professional printer, buying for the whole office, making 500 copies, laser printing at work, or using a desktop printer in your home office, you can always expect better results with Vitality paper. ColorLok technology delivers bolder blacks and vivid colors with inkjet printing for results that are sure to impress. Its smooth, high-quality design is 99.99 percent jam-free on high-speed digital printing equipment. Printer paper is designed to run in all types of printers and copiers, and is perfect for high-volume printing.

Environmental Certification: FSC Sheet Size: 8 1/2"" x 11"" Print Technology: Inkjet
Showing 1 to 1 of 1
Xerox High-Speed Copy Paper
XER3R2047RM

Letter - 8 1/2" x 11" - 20 lb Basis Weight - 0% Recycled Content - Smooth - 92 Brightness - White

$1.25 $11.05

Add to cart
Contact Us
  • 4911 - 68 Avenue, Edmonton
  • sales@officeco.ca
  • 1 (866) 600-3644
  • (780) 463-8170
Customer Service
  • Home
  • Our Policies
  • Terms and Conditions
  • Contact Us
My Account
  • Login
  • Request Account
Copyright © 2019 - 2025 by OfficeCo. All prices are in Canadian Dollars ($).
OfficeCo is not responsible for typographical errors. Prices, policies, and availability are subject to change without notice.

Are you sure

X

Are you sure you want to delete the selected item(s)?

Cancel Delete
Application Log
Timestamp Level Category Message
07:06:21.136949 trace system.CModule
Loading "log" application component
in /home/rose/dev/index.php (12)
07:06:21.137321 trace system.CModule
Loading "db" application component
in /home/rose/dev/index.php (12)
07:06:21.137814 trace system.db.CDbConnection
Opening DB connection
in /home/rose/dev/index.php (12)
07:06:21.138225 trace system.CModule
Loading "request" application component
in /home/rose/dev/index.php (12)
07:06:21.141695 trace system.db.ar.CActiveRecord
Portal.findByAttributes()
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)
07:06:21.143512 trace system.CModule
Loading "cache" application component
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)
07:06:21.145001 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)
07:06:21.146013 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)
07:06:21.146728 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)
07:06:21.146913 trace system.CModule
Loading "user" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)
07:06:21.147654 trace system.CModule
Loading "session" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)
07:06:21.148555 trace system.db.ar.CActiveRecord
User.find()
in /home/rose/dev/protected/components/UserIdentity.php (19)
in /home/rose/dev/protected/components/BeginRequest.php (21)
in /home/rose/dev/index.php (12)
07:06:21.150412 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `users`
in /home/rose/dev/protected/components/UserIdentity.php (19)
in /home/rose/dev/protected/components/BeginRequest.php (21)
in /home/rose/dev/index.php (12)
07:06:21.150953 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `users`
in /home/rose/dev/protected/components/UserIdentity.php (19)
in /home/rose/dev/protected/components/BeginRequest.php (21)
in /home/rose/dev/index.php (12)
07:06:21.151235 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `accounts`
in /home/rose/dev/protected/components/UserIdentity.php (19)
in /home/rose/dev/protected/components/BeginRequest.php (21)
in /home/rose/dev/index.php (12)
07:06:21.151685 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `accounts`
in /home/rose/dev/protected/components/UserIdentity.php (19)
in /home/rose/dev/protected/components/BeginRequest.php (21)
in /home/rose/dev/index.php (12)
07:06:21.151875 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`,
`t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`,
`t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`,
`t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`,
`t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`,
`t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`,
`t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`,
`account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`,
`account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`,
`account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`,
`account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`,
`account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`,
`account`.`markup` AS `t1_c11` FROM `users` `t`  LEFT OUTER JOIN `accounts`
`account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE
(LOWER(username)=?)
in /home/rose/dev/protected/components/UserIdentity.php (19)
in /home/rose/dev/protected/components/BeginRequest.php (21)
in /home/rose/dev/index.php (12)
07:06:21.154633 trace system.db.ar.CActiveRecord
User.findByPk()
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)
07:06:21.154748 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)
07:06:21.155065 trace system.db.ar.CActiveRecord
HiddenProduct.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (63)
in /home/rose/dev/index.php (12)
07:06:21.155087 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)
07:06:21.155468 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)
07:06:21.155580 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)
07:06:21.155821 trace system.db.ar.CActiveRecord
CustomCategory.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (74)
in /home/rose/dev/index.php (12)
07:06:21.155839 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)
07:06:21.156198 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)
07:06:21.156290 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)
07:06:21.156393 trace system.CModule
Loading "urlManager" application component
in /home/rose/dev/index.php (12)
07:06:21.159252 trace system.web.filters.CFilterChain
Running filter ProductController.filteraccessControl()
in /home/rose/dev/index.php (12)
07:06:21.159492 trace system.db.ar.CActiveRecord
User.findByPk()
in /home/rose/dev/protected/controllers/ProductController.php (293)
in /home/rose/dev/index.php (12)
07:06:21.159590 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)
07:06:21.159976 trace system.db.ar.CActiveRecord
PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (319)
in /home/rose/dev/index.php (12)
07:06:21.160006 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)
07:06:21.160379 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)
07:06:21.160559 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)
07:06:21.160705 trace system.db.ar.CActiveRecord
PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (322)
in /home/rose/dev/index.php (12)
07:06:21.160721 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)
07:06:21.168087 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
07:06:21.168116 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=14179 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
07:06:21.168713 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)
07:06:21.169173 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)
07:06:21.169469 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
07:06:21.169491 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)
07:06:21.169848 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)
07:06:21.169991 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)
07:06:21.170104 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
07:06:21.170126 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)
07:06:21.170212 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
07:06:21.170233 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)
07:06:21.170535 trace system.db.ar.CActiveRecord
CartItem.findAllByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (588)
in /home/rose/dev/index.php (12)
07:06:21.170555 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)
07:06:21.171047 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)
07:06:21.171159 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)
07:06:21.203526 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)
07:06:21.203670 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)
07:06:21.204054 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)
07:06:21.204080 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)
07:06:21.204499 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)
07:06:21.204740 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)
07:06:21.205132 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)
07:06:21.205252 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)
07:06:21.206636 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)
07:06:21.206661 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=14179
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)
07:06:21.206892 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)
07:06:21.206913 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)
07:06:21.207238 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)
07:06:21.207330 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=14179 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)
07:06:21.207532 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)
07:06:21.208242 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)
07:06:21.209024 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)
07:06:21.209062 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)
07:06:21.227384 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)
07:06:21.227436 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)
07:06:21.239733 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)
07:06:21.239777 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)
07:06:21.239972 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)
07:06:21.240082 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)
07:06:21.240288 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)
07:06:21.240360 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)
07:06:21.241419 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)
07:06:21.241441 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)
07:06:21.241581 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)
07:06:21.241600 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)
07:06:21.241873 trace system.CModule
Loading "clientScript" application component
in /home/rose/dev/protected/controllers/ProductController.php (621)
in /home/rose/dev/index.php (12)