OfficeCo

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

Products

Office
General Supplies
Badges & Holders
Name Badge Holders

Avery® Heavy Duty Secure Top Badge Holders

$1.25 $19.99

SKU: AVE74472

Details: 3.88" (98.43 mm) x 2.63" (66.68 mm) x 0.50" (12.70 mm) - Vinyl - 25 / Pack - Clear

Description: Heavy-duty, clear badge holders are ideal for permanent or temporary identification. Use to protect access control cards or create name badges. Vertical-style holder is pre-punched with slot and chain holes for lanyards, reel clips and more so users can enjoy hands-free convenience. Badge holders are made of flexible vinyl that is strong enough to use every day. Load from the top and use with Avery Name Badge Inserts.
Inventory: Edmonton: Out Of Stock

Application Log
Timestamp	Level	Category	Message
00:55:36.368539	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
00:55:36.368844	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
00:55:36.369236	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
00:55:36.369661	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
00:55:36.372870	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
00:55:36.374377	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
00:55:36.375621	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
00:55:36.376754	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
00:55:36.377295	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `portals` `t` WHERE `t`.`domain`=:yp0 LIMIT 1 in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
00:55:36.377429	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
00:55:36.378006	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
00:55:36.449888	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
00:55:36.449939	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
00:55:36.450942	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
00:55:36.452874	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
00:55:36.453439	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
00:55:36.453613	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
00:55:36.453953	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
00:55:36.453970	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
00:55:36.454783	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
00:55:36.454899	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `hidden_products` `t` WHERE (customer_id = 3259 OR group_id=5) AND category_id <> 0 in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
00:55:36.455147	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
00:55:36.455164	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
00:55:36.456157	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
00:55:36.456271	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cust_categories` `t` WHERE group_id=5 in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
00:55:36.456391	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
00:55:36.459208	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
00:55:36.459454	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (724) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:55:36.459552	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/controllers/ProductController.php (724) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:55:36.460108	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:55:36.460124	trace	system.db.CDbCommand	Querying SQL: SELECT products.*, sale_prices.price AS saleprice FROM products LEFT OUTER JOIN sale_prices ON products.id=sale_prices.product_id AND (customer_id=5) AND (NOW() BETWEEN startdate AND enddate) WHERE products.active=1 AND products.id = 23977 ORDER BY sale_prices.price DESC LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:55:36.460422	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:55:36.461344	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` in /home/rose/dev/protected/controllers/ProductController.php (728) in /home/rose/dev/protected/controllers/ProductController.php (134) in /home/rose/dev/index.php (12)
00:55:36.461493	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (135) in /home/rose/dev/index.php (12)
00:55:36.461568	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/controllers/ProductController.php (135) in /home/rose/dev/index.php (12)
00:55:36.461900	trace	system.db.ar.CActiveRecord	Favourite.findAll() in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
00:55:36.461921	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `favourites` in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
00:55:36.462457	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `favourites` in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
00:55:36.462558	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `favourites` `t` WHERE customer_id=1826 AND product_id=23977 in /home/rose/dev/protected/controllers/ProductController.php (139) in /home/rose/dev/index.php (12)
00:55:36.462703	trace	system.db.ar.CActiveRecord	lazy loading Product.categories in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:55:36.462888	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:55:36.463443	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:55:36.463587	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:55:36.464061	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_categories` in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:55:36.464178	trace	system.db.CDbCommand	Querying SQL: SELECT `categories`.`id` AS `t1_c0`, `categories`.`parent_id` AS `t1_c1`, `categories`.`name` AS `t1_c2`, `categories`.`image` AS `t1_c3`, `categories`.`fprose` AS `t1_c4`, `categories`.`fpoffice` AS `t1_c5`, `categories`.`spr` AS `t1_c6`, `categories`.`Column 8` AS `t1_c7` FROM `categories` `categories` INNER JOIN `product_categories` `categories_categories` ON (`categories_categories`.`product_id`=:ypl0) AND (`categories`.`id`=`categories_categories`.`category_id`) WHERE (spr=1) in /home/rose/dev/protected/controllers/ProductController.php (168) in /home/rose/dev/index.php (12)
00:55:36.464366	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (170) in /home/rose/dev/index.php (12)
00:55:36.464389	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=333 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (170) in /home/rose/dev/index.php (12)
00:55:36.466396	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (170)
00:55:36.466418	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=332 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (170)
00:55:36.466564	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
00:55:36.466583	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=331 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
00:55:36.466697	trace	system.db.ar.CActiveRecord	Category.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
00:55:36.466716	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `categories` `t` WHERE `t`.`id`=1403 LIMIT 1 in /home/rose/dev/protected/controllers/ProductController.php (707) in /home/rose/dev/protected/controllers/ProductController.php (712) in /home/rose/dev/protected/controllers/ProductController.php (712)
00:55:36.466833	trace	system.db.ar.CActiveRecord	Product.findAllBySql() in /home/rose/dev/protected/controllers/ProductController.php (180) in /home/rose/dev/index.php (12)
00:55:36.466845	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) INNER JOIN product_categories ON category_id=333 AND product_categories.product_id=products.id GROUP BY products.id ORDER BY RAND() LIMIT 4 in /home/rose/dev/protected/controllers/ProductController.php (180) in /home/rose/dev/index.php (12)
00:55:36.468313	trace	system.db.ar.CActiveRecord	AttributeValue.findAll() in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:55:36.468338	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attribute_values` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:55:36.468880	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attribute_values` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:55:36.469129	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attribute_categories` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:55:36.469626	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attribute_categories` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:55:36.469830	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `product_attributes` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:55:36.470319	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `product_attributes` in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:55:36.470458	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`product_id` AS `t0_c0`, `t`.`category_id` AS `t0_c1`, `t`.`attribute_id` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`uploaded` AS `t0_c4`, `category`.`id` AS `t1_c0`, `category`.`name` AS `t1_c1`, `category`.`uploaded` AS `t1_c2`, `attribute`.`id` AS `t2_c0`, `attribute`.`name` AS `t2_c1`, `attribute`.`uploaded` AS `t2_c2` FROM `product_attribute_values` `t` LEFT OUTER JOIN `product_attribute_categories` `category` ON (`t`.`category_id`=`category`.`id`) LEFT OUTER JOIN `product_attributes` `attribute` ON (`t`.`attribute_id`=`attribute`.`id`) WHERE (product_id = 23977) ORDER BY category_id ASC in /home/rose/dev/protected/controllers/ProductController.php (184) in /home/rose/dev/index.php (12)
00:55:36.527067	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
00:55:36.527122	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
00:55:36.528100	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cart_items` in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
00:55:36.528269	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cart_items` `t` WHERE `t`.`session_id`=:yp0 in /home/rose/dev/protected/controllers/ProductController.php (192) in /home/rose/dev/index.php (12)
00:55:36.552608	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.552726	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.553086	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.553107	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_list_details` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.553879	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_list_details` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.554117	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_lists` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.554627	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_lists` in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.554766	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.555881	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.555913	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_exceptions` in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.556427	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_exceptions` in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.556529	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=23977 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.556772	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.556793	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `sale_prices` in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.557312	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `sale_prices` in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.557414	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=23977 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/show.php (7) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.557841	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.557919	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.558129	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.558193	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.559196	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.559217	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=22870 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.559351	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.559369	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=22870 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.559729	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.559806	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.560005	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.560067	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.561026	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.561045	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=28060 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.561224	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.561242	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=28060 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.561573	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.561647	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.561857	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.561919	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.562906	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.562925	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=16632 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.563050	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.563065	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=16632 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.563400	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.563473	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (128) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.563676	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.563736	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (150) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.564692	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.564711	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=22566 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (161) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.564834	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.564853	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=22566 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (181) in /home/rose/dev/protected/views/product/_product.php (2) in /home/rose/dev/protected/views/product/show.php (123)
00:55:36.565206	trace	system.CModule	Loading "widgetFactory" application component in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (199) in /home/rose/dev/index.php (12)
00:55:36.565675	trace	system.db.ar.CActiveRecord	CartItem.count() in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.565713	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `cart_items` `t` WHERE session_id = :sid in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (81) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.576869	trace	system.db.ar.CActiveRecord	CartItem.count() in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (118) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.576898	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `cart_items` `t` WHERE session_id = :sid in /home/rose/dev/protected/components/CartButton.php (15) in /home/rose/dev/protected/views/layouts/office.php (118) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.588043	trace	system.db.ar.CActiveRecord	Product.findByPk() in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.588073	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `products` `t` WHERE `t`.`id`=13228 LIMIT 1 in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143) in /home/rose/dev/protected/controllers/ProductController.php (199)
00:55:36.588263	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/models/Product.php (61) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
00:55:36.588340	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/models/Product.php (61) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
00:55:36.588550	trace	system.db.ar.CActiveRecord	PriceListDetail.findByAttributes() in /home/rose/dev/protected/models/Product.php (83) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
00:55:36.588612	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`product_id` AS `t0_c1`, `t`.`price` AS `t0_c2`, `t`.`price_list_id` AS `t0_c3`, `pricelist`.`id` AS `t1_c0`, `pricelist`.`name` AS `t1_c1`, `pricelist`.`highlight` AS `t1_c2`, `pricelist`.`forced` AS `t1_c3` FROM `price_list_details` `t` LEFT OUTER JOIN `price_lists` `pricelist` ON (`t`.`price_list_id`=`pricelist`.`id`) WHERE (`t`.`product_id`=:yp0 AND `t`.`price_list_id`=:yp1) in /home/rose/dev/protected/models/Product.php (83) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
00:55:36.589608	trace	system.db.ar.CActiveRecord	PriceException.findAll() in /home/rose/dev/protected/models/Product.php (91) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
00:55:36.589627	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `price_exceptions` `t` WHERE product_id=13228 AND customer_id=3259 in /home/rose/dev/protected/models/Product.php (91) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
00:55:36.589761	trace	system.db.ar.CActiveRecord	SalePrice.findAll() in /home/rose/dev/protected/models/Product.php (109) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
00:55:36.589777	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `sale_prices` `t` WHERE product_id=13228 AND (customer_id=3259 OR customer_id=1538) AND NOW() BETWEEN startdate AND enddate in /home/rose/dev/protected/models/Product.php (109) in /home/rose/dev/protected/views/site/_categorylinks.php (10) in /home/rose/dev/protected/views/layouts/office.php (143)
00:55:36.590018	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (199) in /home/rose/dev/index.php (12)

Products

Office
General Supplies
Badges & Holders
Name Badge Holders

Avery® Heavy Duty Secure Top Badge Holders

$1.25 $19.99

You May Also Like

Avery Portrait Badge Holder Clip

AVE02920

Gemex Color Coded Badge Holder with Adjustable String

GMXCO300B

Swingline GBC Retractable Badge Holder

GBC50573

Baumgartens Waterproof ID Case

BAU55180

General Information

Product Information

Physical Characteristics

Miscellaneous

Products OfficeGeneral SuppliesBadges & HoldersName Badge Holders

Avery® Heavy Duty Secure Top Badge Holders

$1.25 $19.99

You May Also Like

Avery Portrait Badge Holder Clip

AVE02920

Gemex Color Coded Badge Holder with Adjustable String

GMXCO300B

Swingline GBC Retractable Badge Holder

GBC50573

Baumgartens Waterproof ID Case

BAU55180

General Information

Product Information

Physical Characteristics

Miscellaneous

Are you sure

Products

Office
General Supplies
Badges & Holders
Name Badge Holders