Loading "log" application component
in /home/rose/dev/index.php (12)

Loading "db" application component
in /home/rose/dev/index.php (12)

Opening DB connection
in /home/rose/dev/index.php (12)

Loading "request" application component
in /home/rose/dev/index.php (12)

Portal.findByAttributes()
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)

Loading "cache" application component
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `portals`
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `portals`
in /home/rose/dev/protected/components/BeginRequest.php (15)
in /home/rose/dev/index.php (12)

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)

Loading "user" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)

Loading "session" application component
in /home/rose/dev/protected/components/BeginRequest.php (18)
in /home/rose/dev/index.php (12)

User.findByPk()
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `users`
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `users`
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `accounts`
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `accounts`
in /home/rose/dev/protected/components/BeginRequest.php (48)
in /home/rose/dev/index.php (12)

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)

HiddenProduct.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (63)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `hidden_products`
in /home/rose/dev/protected/components/BeginRequest.php (63)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `hidden_products`
in /home/rose/dev/protected/components/BeginRequest.php (63)
in /home/rose/dev/index.php (12)

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)

CustomCategory.findAll()
in /home/rose/dev/protected/components/BeginRequest.php (74)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `cust_categories`
in /home/rose/dev/protected/components/BeginRequest.php (74)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `cust_categories`
in /home/rose/dev/protected/components/BeginRequest.php (74)
in /home/rose/dev/index.php (12)

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)

Loading "urlManager" application component
in /home/rose/dev/index.php (12)

Running filter ProductController.filteraccessControl()
in /home/rose/dev/index.php (12)

User.findByPk()
in /home/rose/dev/protected/controllers/ProductController.php (293)
in /home/rose/dev/index.php (12)

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)

PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (319)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `price_exceptions`
in /home/rose/dev/protected/controllers/ProductController.php (319)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `price_exceptions`
in /home/rose/dev/protected/controllers/ProductController.php (319)
in /home/rose/dev/index.php (12)

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)

PriceException.count()
in /home/rose/dev/protected/controllers/ProductController.php (322)
in /home/rose/dev/index.php (12)

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)

Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)

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=35557 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `products`
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `products`
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)

Product.findBySql()
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)

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=48389 GROUP BY
IFNULL(x.product_id,products.id)
in /home/rose/dev/protected/controllers/ProductController.php (478)
in /home/rose/dev/index.php (12)

Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `categories`
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `categories`
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)

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)

Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)

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)

Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)

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)

Category.findByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (499)
in /home/rose/dev/index.php (12)

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)

CartItem.findAllByAttributes()
in /home/rose/dev/protected/controllers/ProductController.php (588)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW FULL COLUMNS FROM `cart_items`
in /home/rose/dev/protected/controllers/ProductController.php (588)
in /home/rose/dev/index.php (12)

Querying SQL: SHOW CREATE TABLE `cart_items`
in /home/rose/dev/protected/controllers/ProductController.php (588)
in /home/rose/dev/index.php (12)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=35557
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)

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)

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)

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)

Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=35557 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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

Loading "clientScript" application component
in /home/rose/dev/protected/controllers/ProductController.php (621)
in /home/rose/dev/index.php (12)