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
  • $10 to $15 (4)
  • $15 to $25 (4)
  • $25 to $30 (1)
Style
  • Round (5)
  • Flat (4)
Dimensions
  • #10 (2)
  • #12 (2)
  • #6 (2)
  • #8 (2)
  • #4 (1)
Pack Weight
  • 0.31 (2)
  • 0.43 (2)
  • 0.21 (1)
  • 0.7 (1)
  • 0.75 (1)
  • 0.96 (1)
  • 1.05 (1)
  1. Products
Narrowed By:
Material: Wood/Metal/hog bristle Price: $10.00 to $30.00
Showing 1 to 9 of 9
School Source 74106 Brushes Eterna China Poster #579 Long Handle Flat - #6
School Source 74106 Brushes Eterna China Poster #579 Long Handle Flat - #6
74-106

Sold by the dozen

$1.25 $5.91

Add to cart
School Source 74108 Brushes Eterna China Poster #579 Long Handle Flat - #8
School Source 74108 Brushes Eterna China Poster #579 Long Handle Flat - #8
74-108

Sold by the dozen

$1.25 $7.27

Add to cart
School Source 74110 Brushes Eterna China Poster #579 Long Handle Flat - #10
School Source 74110 Brushes Eterna China Poster #579 Long Handle Flat - #10
74-110

Sold by the dozen

$1.25 $10.62

Add to cart
School Source 74111 Brushes Eterna China Poster #579 Long Handle Flat - #12
School Source 74111 Brushes Eterna China Poster #579 Long Handle Flat - #12
74-111

Sold by the dozen

$1.25 $13.17

Add to cart
School Source 74115 Brushes Eterna China Poster #582 Long Handle Round - #4
School Source 74115 Brushes Eterna China Poster #582 Long Handle Round - #4
74-115

12/pack

$1.25 $4.18

Add to cart
School Source 74117 Brushes Eterna China Poster #582 Long Handle Round - #6
School Source 74117 Brushes Eterna China Poster #582 Long Handle Round - #6
74-117

12/pack

$1.25 $5.91

Add to cart
School Source 74119 Brushes Eterna China Poster #582 Long Handle Round - #8
74-119

Unit of measure: lbs., 12/pack

$1.25 $8.01

Add to cart
School Source 74120 Brushes Eterna China Poster #582 Long Handle Round - #10
School Source 74120 Brushes Eterna China Poster #582 Long Handle Round - #10
74-120

Unit of measure: lbs., 12/pack

$1.25 $15.93

Add to cart
School Source 74121 Brushes Eterna China Poster #582 Long Handle Round - #12
School Source 74121 Brushes Eterna China Poster #582 Long Handle Round - #12
74-121

Unit of measure: lbs., 12/pack

$1.25 $19.37

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
17:42:18.625492 trace system.CModule
Loading "log" application component
in /home/rose/dev/index.php (12)
17:42:18.625771 trace system.CModule
Loading "db" application component
in /home/rose/dev/index.php (12)
17:42:18.626128 trace system.db.CDbConnection
Opening DB connection
in /home/rose/dev/index.php (12)
17:42:18.626590 trace system.CModule
Loading "request" application component
in /home/rose/dev/index.php (12)
17:42:18.629462 trace system.db.ar.CActiveRecord
Portal.findByAttributes()
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)
17:42:18.631127 trace system.CModule
Loading "cache" application component
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)
17:42:18.632265 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)
17:42:18.633522 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)
17:42:18.634071 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)
17:42:18.634219 trace system.CModule
Loading "user" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)
17:42:18.634787 trace system.CModule
Loading "session" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)
17:42:18.635277 trace system.db.ar.CActiveRecord
User.findByPk()
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)
17:42:18.635296 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)
17:42:18.635929 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)
17:42:18.637692 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)
17:42:18.638271 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)
17:42:18.638422 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)
17:42:18.638748 trace system.db.ar.CActiveRecord
HiddenProduct.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (63)
in /home/rose/dev/index.php (12)
17:42:18.638767 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)
17:42:18.639283 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)
17:42:18.639372 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)
17:42:18.639589 trace system.db.ar.CActiveRecord
CustomCategory.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (74)
in /home/rose/dev/index.php (12)
17:42:18.639605 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)
17:42:18.640126 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)
17:42:18.640207 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)
17:42:18.640302 trace system.CModule
Loading "urlManager" application component
in /home/rose/dev/index.php (12)
17:42:18.643101 trace system.web.filters.CFilterChain
Running filter ProductController.filteraccessControl()
in /home/rose/dev/index.php (12)
17:42:18.643362 trace system.db.ar.CActiveRecord
User.findByPk()
in /home/rose/dev/protected/controllers/ProductController.php (293)
in /home/rose/dev/index.php (12)
17:42:18.643449 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)
17:42:18.643829 trace system.db.ar.CActiveRecord
PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (319)
in /home/rose/dev/index.php (12)
17:42:18.643850 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)
17:42:18.644390 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)
17:42:18.644485 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)
17:42:18.644596 trace system.db.ar.CActiveRecord
PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (322)
in /home/rose/dev/index.php (12)
17:42:18.644610 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)
17:42:18.655410 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.655428 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=6166 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.655972 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)
17:42:18.656789 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)
17:42:18.656914 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.656925 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=6168 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.657228 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.657238 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=6170 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.657529 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.657537 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=6171 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.657813 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.657821 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=6175 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.658097 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.658106 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=6177 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.658463 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.658473 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=6179 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.658749 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.658757 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=6181 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.659033 trace system.db.ar.CActiveRecord
Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.659043 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=6182 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)
17:42:18.659442 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.659461 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)
17:42:18.660049 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)
17:42:18.660161 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)
17:42:18.660280 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.660305 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)
17:42:18.660392 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.660418 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)
17:42:18.660501 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.660522 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)
17:42:18.660595 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.660617 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)
17:42:18.660687 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.660707 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)
17:42:18.660778 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.660799 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)
17:42:18.660897 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.660917 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)
17:42:18.660989 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.661009 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)
17:42:18.661077 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.661097 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)
17:42:18.661170 trace system.db.ar.CActiveRecord
Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)
17:42:18.661191 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)
17:42:18.661436 trace system.db.ar.CActiveRecord
CartItem.findAllByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (588)
in /home/rose/dev/index.php (12)
17:42:18.661454 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)
17:42:18.661998 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)
17:42:18.662096 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)
17:42:18.696918 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)
17:42:18.697043 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)
17:42:18.697392 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)
17:42:18.697418 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)
17:42:18.698021 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)
17:42:18.698251 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)
17:42:18.698762 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)
17:42:18.698873 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)
17:42:18.700395 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)
17:42:18.700416 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6166
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)
17:42:18.700638 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)
17:42:18.700658 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)
17:42:18.701216 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)
17:42:18.701332 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6166 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)
17:42:18.701776 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)
17:42:18.701869 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)
17:42:18.702081 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)
17:42:18.702163 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)
17:42:18.703161 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)
17:42:18.703181 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6168
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)
17:42:18.703319 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)
17:42:18.703340 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6168 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)
17:42:18.703728 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)
17:42:18.703816 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)
17:42:18.704010 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)
17:42:18.704082 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)
17:42:18.705076 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)
17:42:18.705099 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6170
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)
17:42:18.705214 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)
17:42:18.705234 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6170 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)
17:42:18.705589 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)
17:42:18.705681 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)
17:42:18.706017 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)
17:42:18.706089 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)
17:42:18.707081 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)
17:42:18.707102 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6171
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)
17:42:18.707214 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)
17:42:18.707233 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6171 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)
17:42:18.707592 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)
17:42:18.707683 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)
17:42:18.707870 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)
17:42:18.707942 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)
17:42:18.709296 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)
17:42:18.709320 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6175
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)
17:42:18.709460 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)
17:42:18.709481 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6175 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)
17:42:18.709861 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)
17:42:18.709971 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)
17:42:18.710180 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)
17:42:18.710253 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)
17:42:18.711257 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)
17:42:18.711278 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6177
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)
17:42:18.711395 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)
17:42:18.711417 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6177 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)
17:42:18.711904 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)
17:42:18.711991 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)
17:42:18.712181 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)
17:42:18.712254 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)
17:42:18.713237 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)
17:42:18.713258 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6179
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)
17:42:18.713386 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)
17:42:18.713406 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6179 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)
17:42:18.713738 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)
17:42:18.713824 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)
17:42:18.714010 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)
17:42:18.714082 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)
17:42:18.715064 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)
17:42:18.715085 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6181
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)
17:42:18.715195 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)
17:42:18.715214 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6181 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)
17:42:18.715568 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)
17:42:18.715652 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)
17:42:18.715842 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)
17:42:18.715913 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)
17:42:18.716907 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)
17:42:18.716928 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=6182
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)
17:42:18.717041 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)
17:42:18.717061 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=6182 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)
17:42:18.717264 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)
17:42:18.718302 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)
17:42:18.719860 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)
17:42:18.719909 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)
17:42:18.731683 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)
17:42:18.731718 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)
17:42:18.743871 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)
17:42:18.743942 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)
17:42:18.744153 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)
17:42:18.744301 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)
17:42:18.744524 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)
17:42:18.744616 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)
17:42:18.745592 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)
17:42:18.745613 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)
17:42:18.745743 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)
17:42:18.745765 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)
17:42:18.748924 trace system.CModule
Loading "clientScript" application component
in /home/rose/dev/protected/controllers/ProductController.php (621)
in /home/rose/dev/index.php (12)