OfficeCo

Pilot (14)
FriXion (11)
Expo (2)
Elmer's (1)
Jiffco (1)

Features

Ink Color

Quantity

Marketing Information

Write, Erase, Repeat! NEVER cross out again with Pilot's FriXion Point Clicker, a clever and stylish rollerball pen with amazing features!

Its elegant and slim design will charm those who prefer slender and modern writing instruments. This pen also includes a practical clip. Its high tech synergy tip has been engineered with a ball that rolls evenly due to multiple dimples preventing the scratchy sensation on your paper. The large ink capacity inside the tip allows a neat stroke from the very beginning. The 0.5mm fine tip lets you write with incredible precision when compared to other cone rollerballs. Aside from the incredible synergy tip, this pen has another fantastic feature, which is the incredible performance of Pilot's thermo-sensitive ink. Thanks to this, your writing disappears by friction and you can rewrite immediately with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic. When your pen runs out of ink, do not bin it...refill it! ItÂ´s easy, smart & sustainable. This Clicker version of Pilot's erasable and refillable FriXion Point pen has everything to become your next favourite writing instrument.
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- High tech synergy tip that allows a neat stroke from the very beginning.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- A fine retractable tip that pops out with a click: no more lost caps!
- Ink Colour : Blue
- Refillable : Yes
- Writing width : 0.25 mm
- Tip size : 0.50 mm
(2)
Frixion® lets you write, erase, re-write. Thermo-sensitive gel ink disappears with erasing friction coming from the rubber tip. Chisel tip. Vibrant fluorescent colours. (2)
Write, Erase, Repeat! NEVER cross out again with FriXion Ball Clicker, the RETRACTABLE erasable pen from Pilot!
Write smoothly with the medium-tip FriXion Ball Clicker, erase with the FriXion eraser and rewrite immediately. Pilot's best-selling rollerball allows you to cleanly write, erase the ink by friction and rewrite - all with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic! The unique gel ink responds to the heat generated by the rubbing out, and lets you write over your mistake immediately with the same pen.
Thanks to the patented thermo-sensitive ink, PILOT has - true to tradition - revolutionised writing with the erasable pen FriXion Ball Clicker. Available in a variety of shades, there's a FriXion Ball Clicker for everyone!
Save yourself money and be kind to the environment by refilling your FriXion Ball Clicker pen instead of buying a new one - it's never been easier to be green!
0.7mm tip gives a 0.35mm medium stroke width.
Because of the erasable ink, FriXion Ball Clicker must not to be used for signatures, legal documents, examination papers or other documents where writing needs to be of a permanent nature.
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- A medium retractable tip that pops out with a click: no more lost caps!
- Ink Colour : Black
- Refillable : Yes
- Writing width : 0.35 mm
- Tip size : 0.70 mm
(1)
Write, Erase, Repeat! NEVER cross out again with FriXion Ball Clicker, the RETRACTABLE erasable pen from Pilot!
Write smoothly with the medium-tip FriXion Ball Clicker, erase with the FriXion eraser and rewrite immediately. Pilot's best-selling rollerball allows you to cleanly write, erase the ink by friction and rewrite - all with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic! The unique gel ink responds to the heat generated by the rubbing out, and lets you write over your mistake immediately with the same pen.
Thanks to the patented thermo-sensitive ink, PILOT has - true to tradition - revolutionised writing with the erasable pen FriXion Ball Clicker. Available in a variety of shades, there's a FriXion Ball Clicker for everyone!
Save yourself money and be kind to the environment by refilling your FriXion Ball Clicker pen instead of buying a new one - it's never been easier to be green!
0.7mm tip gives a 0.35mm medium stroke width.
Because of the erasable ink, FriXion Ball Clicker must not to be used for signatures, legal documents, examination papers or other documents where writing needs to be of a permanent nature.
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- A medium retractable tip that pops out with a click: no more lost caps!
- Ink Colour : Blue
- Refillable : Yes
- Writing width : 0.35 mm
- Tip size : 0.70 mm
(1)
Write, Erase, Repeat! NEVER cross out again with FriXion Ball Clicker, the RETRACTABLE erasable pen from Pilot!

Write smoothly with the medium-tip FriXion Ball Clicker, erase with the FriXion eraser and rewrite immediately. Pilot's best-selling rollerball allows you to cleanly write, erase the ink by friction and rewrite - all with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic! The unique gel ink responds to the heat generated by the rubbing out, and lets you write over your mistake immediately with the same pen.
Thanks to the patented thermo-sensitive ink, PILOT has - true to tradition - revolutionised writing with the erasable pen FriXion Ball Clicker. Available in a variety of shades, there's a FriXion Ball Clicker for everyone!
Save yourself money and be kind to the environment by refilling your FriXion Ball Clicker pen instead of buying a new one - it's never been easier to be green!
0.7mm tip gives a 0.35mm medium stroke width.
Because of the erasable ink, FriXion Ball Clicker must not to be used for signatures, legal documents, examination papers or other documents where writing needs to be of a permanent nature.
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- A medium retractable tip that pops out with a click: no more lost caps!
(1)
Write, Erase, Repeat! NEVER cross out again with FriXion Ball, the ORIGINAL erasable pen from Pilot!
Now available in a brand new fine-tip version for those who enjoy a fine writing width or those who would like to write longer.
Write smoothly with FriXion Ball, erase by generating heat with the FriXion eraser that does not damage the paper and rewrite immediately. Pilot's best-selling rollerball allows you to cleanly write, erase the ink by friction and rewrite - all with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic! The unique gel ink responds to the heat generated by the rubbing out, and lets you write over your mistake immediately with the same pen.
Thanks to the patented thermo-sensitive ink, PILOT has - true to tradition - revolutionised writing with the erasable pen FriXion Ball.
It displays a youthful style with its streamlined body and its tattoo decoration. Available in a variety of shades, there's a FriXion Ball for everyone!
Save yourself money and be kind to the environment by refilling your FriXion Ball pen instead of buying a new one - it's never been easier to be green!
0.5mm tip gives a 0.25mm medium stroke width.
Because of the erasable ink, FriXion Ball must not to be used for signatures, legal documents, examination papers or other documents where writing needs to be of a permanent nature. Together, we can make a difference and help save our planet's resources. By producing a FriXion Ball gel ink pen, Pilot is reducing the carbon footprint of the pen compared to the same pen produced without recycled plastic. But it does not stop there, by refilling it at least 3 times, you would be offsetting the carbon dioxide emissions too. From the manufacturing through to the end of the product life, it is estimated that buying this pen and refilling it 3 times reduces the total environmental impact of the pen by -71% compared to buying an additional 3 new pens. A small gesture can make a significant difference in our fight against climate change!
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- Made of at least 50% of recycled plastic material (excluding refills and product packaging) in order to help save our planet's resources.
- Pen with cap.
- Ink Colour : Black
- Refillable : Yes
- Writing width : 0.25 mm
- Tip size : 0.50 mm
(1)
Write, Erase, Repeat! NEVER cross out again with FriXion Ball, the ORIGINAL erasable pen from Pilot!
Now available in a brand new fine-tip version for those who enjoy a fine writing width or those who would like to write longer.
Write smoothly with FriXion Ball, erase by generating heat with the FriXion eraser that does not damage the paper and rewrite immediately. Pilot's best-selling rollerball allows you to cleanly write, erase the ink by friction and rewrite - all with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic! The unique gel ink responds to the heat generated by the rubbing out, and lets you write over your mistake immediately with the same pen.
Thanks to the patented thermo-sensitive ink, PILOT has - true to tradition - revolutionised writing with the erasable pen FriXion Ball.
It displays a youthful style with its streamlined body and its tattoo decoration. Available in a variety of shades, there's a FriXion Ball for everyone!
Save yourself money and be kind to the environment by refilling your FriXion Ball pen instead of buying a new one - it's never been easier to be green!
0.5mm tip gives a 0.25mm medium stroke width.
Because of the erasable ink, FriXion Ball must not to be used for signatures, legal documents, examination papers or other documents where writing needs to be of a permanent nature. Together, we can make a difference and help save our planet's resources. By producing a FriXion Ball gel ink pen, Pilot is reducing the carbon footprint of the pen compared to the same pen produced without recycled plastic. But it does not stop there, by refilling it at least 3 times, you would be offsetting the carbon dioxide emissions too. From the manufacturing through to the end of the product life, it is estimated that buying this pen and refilling it 3 times reduces the total environmental impact of the pen by -71%** compared to buying an additional 3 new pens. A small gesture can make a significant difference in our fight against climate change!
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- Made of at least 50%* of recycled plastic material (excluding refills and product packaging) in order to help save our planet's resources.
- Pen with cap.
- Ink Colour : Blue
- Refillable : Yes
- Writing width : 0.25 mm
- Tip size : 0.50 mm
(1)
Write, Erase, Repeat! NEVER cross out again with FriXion Ball, the ORIGINAL erasable pen from Pilot!
Now available in a brand new fine-tip version for those who enjoy a fine writing width or those who would like to write longer.
Write smoothly with FriXion Ball, erase by generating heat with the FriXion eraser that does not damage the paper and rewrite immediately. Pilot's best-selling rollerball allows you to cleanly write, erase the ink by friction and rewrite - all with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic! The unique gel ink responds to the heat generated by the rubbing out, and lets you write over your mistake immediately with the same pen.
Thanks to the patented thermo-sensitive ink, PILOT has - true to tradition - revolutionised writing with the erasable pen FriXion Ball.
It displays a youthful style with its streamlined body and its tattoo decoration. Available in a variety of shades, there's a FriXion Ball for everyone!
Save yourself money and be kind to the environment by refilling your FriXion Ball pen instead of buying a new one - it's never been easier to be green!
0.5mm tip gives a 0.25mm medium stroke width.
Because of the erasable ink, FriXion Ball must not to be used for signatures, legal documents, examination papers or other documents where writing needs to be of a permanent nature. Together, we can make a difference and help save our planet's resources. By producing a FriXion Ball gel ink pen, Pilot is reducing the carbon footprint of the pen compared to the same pen produced without recycled plastic. But it does not stop there, by refilling it at least 3 times, you would be offsetting the carbon dioxide emissions too. From the manufacturing through to the end of the product life, it is estimated that buying this pen and refilling it 3 times reduces the total environmental impact of the pen by -71%** compared to buying an additional 3 new pens. A small gesture can make a significant difference in our fight against climate change!
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- Made of at least 50%* of recycled plastic material (excluding refills and product packaging) in order to help save our planet's resources.
- Pen with cap.
- Ink Colour : Red
- Refillable : Yes
- Writing width : 0.25 mm
- Tip size : 0.50 mm
(1)
Write, Erase, Repeat! NEVER cross out again with FriXion Ball, the ORIGINAL erasable pen from Pilot!
Write smoothly with the medium-tip FriXion Ball, erase by heating with the FriXion eraser without damaging the paper and rewrite immediately. Pilot's best-selling rollerball allows you to cleanly write, erase the ink by friction and rewrite - all with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic! The unique gel ink responds to the heat generated by the rubbing out, and lets you write over your mistake immediately with the same pen.
Thanks to the patented thermo-sensitive ink, PILOT has - true to tradition - revolutionised writing with the erasable pen FriXion Ball.
It displays a youthful style with its streamlined body and its tattoo decoration. Available in a variety of shades, there's a FriXion Ball for everyone!
Save yourself money and be kind to the environment by refilling your FriXion Ball pen instead of buying a new one - it's never been easier to be green!
0.7mm tip gives a 0.35mm medium stroke width.
Because of the erasable ink, FriXion Ball must not to be used for signatures, legal documents, examination papers or other documents where writing needs to be of a permanent nature. Together, we can make a difference and help save our planet's resources. By producing a FriXion Ball gel ink pen, Pilot is reducing the carbon footprint of the pen compared to the same pen produced without recycled plastic. But it does not stop there, by refilling it at least 3 times, you would be offsetting the carbon dioxide emissions too. From the manufacturing through to the end of the product life, it is estimated that buying this pen and refilling it 3 times reduces the total environmental impact of the pen by -71% compared to buying an additional 3 new pens. A small gesture can make a significant difference in our fight against climate change!
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- Made of at least 50% of recycled plastic material (excluding refills and product packaging) in order to help save our planet's resources.
- Pen with cap.
- Ink Colour : Black
- Refillable : Yes
- Writing width : 0.35 mm
- Tip size : 0.70 mm
(1)
Write, Erase, Repeat! NEVER cross out again with Pilot's FriXion Point Clicker, a clever and stylish rollerball pen with amazing features!

Its elegant and slim design will charm those who prefer slender and modern writing instruments. This pen also includes a practical clip. Its high tech synergy tip has been engineered with a ball that rolls evenly due to multiple dimples preventing the scratchy sensation on your paper. The large ink capacity inside the tip allows a neat stroke from the very beginning. The 0.5mm fine tip lets you write with incredible precision when compared to other cone rollerballs. Aside from the incredible synergy tip, this pen has another fantastic feature, which is the incredible performance of Pilot's thermo-sensitive ink. Thanks to this, your writing disappears by friction and you can rewrite immediately with the same pen. Simply rub out your mistakes with the eraser stud and watch the ink disappear as if by magic. When your pen runs out of ink, do not bin it...refill it! ItÂ´s easy, smart & sustainable. This Clicker version of Pilot's erasable and refillable FriXion Point pen has everything to become your next favourite writing instrument.
- Thanks to the erasable thermo-sensitive ink: Write, Erase and Repeat!
- Effectiveness and writing comfort thanks to the unique fluidity and ultra-softness of the Pilot gel ink.
- High tech synergy tip that allows a neat stroke from the very beginning.
- Ergonomic, with a grip to ensure a perfect hold control.
- Refillable product more economical and respectful of the environment.
- A fine retractable tip that pops out with a click: no more lost caps!
- Ink Colour : Black
- Refillable : Yes
- Writing width : 0.25 mm
- Tip size : 0.50 mm
(1)
Board Mate Chalk Markers work just like a marker but deliver a chalk-like ink that easily wipes off most nonporous surfaces with a damp cloth. Markers work on Elmer's Chalk Foam Board, glass, car windows, mirrors, metal, plastic and ceramic. Set includes nontoxic markers in white, orange, pink and blue.
(1)
Dry-erase markers contain specially formulated low-odor, dry-erase ink. They are perfect for classrooms, small offices and homes. They can be used on most whiteboards, glass and nonporous surfaces. Dry-erase markers with chisel point deliver consistent color quality for bold colors and great erasability. They are certified AP nontoxic and conform to ASTM D-4236.
(1)
Frixion® lets you write, erase, re-write. Thermo-sensitive gel ink disappears with erasing friction coming from the rubber tip. Chisel tip. Vibrant fluorescent colours.
(1)
Whiteboard marker features a large nib to ensure your writing is clearly visible from a distance. High-performance ink creates a bold color with consistent ink flow. Erasable ink removes completely from dry-erase surfaces with either a whiteboard eraser or dry cloth. Marker is perfect for presentations, brainstorming ideas, creating lists and more.
(1)
Write-Remove-Rewrite without damaging documents. Thermo-sensitive gel ink formula disappears with erasing friction Features click style clip. 0.5 mm. Refillable. Black.
(1)
Write-Remove-Rewrite without damaging documents. Thermo-sensitive gel ink formula disappears with erasing friction Features click style clip. 0.5 mm. Refillable. Blue Black.

(1)
Write-Remove-Rewrite without damaging documents. Thermo-sensitive gel ink formula disappears with erasing friction Features click style clip. 0.5 mm. Refillable. Blue.

(1)
Write-Remove-Rewrite without damaging documents. Thermo-sensitive gel ink formula disappears with erasing friction Features click style clip. 0.5 mm. Refillable. Green. 12/box.

(1)
Write-Remove-Rewrite without damaging documents. Thermo-sensitive gel ink formula disappears with erasing friction Features click style clip. 0.5 mm. Refillable. Pink. 12/box.

(1)
Write-Remove-Rewrite without damaging documents. Thermo-sensitive gel ink formula disappears with erasing friction Features click style clip. 0.5 mm. Refillable. Purple. 12/box.
(1)
Write-Remove-Rewrite without damaging documents. Thermo-sensitive gel ink formula disappears with erasing friction Features click style clip. 0.5 mm. Refillable. Red. 12/box.
(1)
Write-Remove-Rewrite without damaging documents. Thermo-sensitive gel ink formula disappears with erasing friction Features click style clip. 0.5 mm. Refillable. Turquoise. 12/box.
(1)
Dry-erase marker contains specially formulated low-odor, dry-erase ink. They are perfect for classrooms, small offices and homes. Can be used on most whiteboards, glass and nonporous surfaces. Consistent color quality delivers bold colors and great erasability. Bullet point. Certified AP nontoxic and conforms to ASTM D-4236.
(1)
Frixion® lets you write, erase, re-write. Thermo-sensitive gel ink disappears with erasing friction coming from the rubber tip. Side click retractable & refillable. Not recommended for legal or official documents. (1)

Ink Type

Recycled

No (5)
Yes (4)

Marker Point Style

Chisel (5)
Bullet (2)

Tip Material

Rubber (5)
Acrylic Fiber (1)

Country of Origin

United States (2)
China (1)

Application Log
Timestamp	Level	Category	Message
23:45:41.130172	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
23:45:41.130537	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
23:45:41.131022	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
23:45:41.131436	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
23:45:41.134458	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
23:45:41.136008	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
23:45:41.137295	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)
23:45:41.138359	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)
23:45:41.139238	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)
23:45:41.139388	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
23:45:41.140120	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
23:45:41.143515	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
23:45:41.143549	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)
23:45:41.144162	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)
23:45:41.146496	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)
23:45:41.147094	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)
23:45:41.147269	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)
23:45:41.147619	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
23:45:41.147639	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)
23:45:41.148195	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)
23:45:41.148318	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)
23:45:41.148577	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
23:45:41.148597	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)
23:45:41.149127	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)
23:45:41.149251	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)
23:45:41.149389	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
23:45:41.152498	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
23:45:41.152748	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
23:45:41.152842	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)
23:45:41.153215	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
23:45:41.153240	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)
23:45:41.153764	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)
23:45:41.153882	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)
23:45:41.154016	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
23:45:41.154035	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)
23:45:41.161465	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:45:41.161488	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)
23:45:41.162075	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)
23:45:41.162228	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)
23:45:41.162367	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:45:41.162396	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)
23:45:41.162523	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:45:41.162554	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)
23:45:41.162673	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:45:41.162708	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)
23:45:41.162826	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:45:41.162858	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)
23:45:41.162965	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:45:41.162997	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)
23:45:41.163105	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:45:41.163137	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)
23:45:41.163245	trace	system.db.ar.CActiveRecord	Category.findByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (499) in /home/rose/dev/index.php (12)
23:45:41.163278	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)
23:45:41.163671	trace	system.db.ar.CActiveRecord	CartItem.findAllByAttributes() in /home/rose/dev/protected/controllers/ProductController.php (588) in /home/rose/dev/index.php (12)
23:45:41.163692	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)
23:45:41.164252	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)
23:45:41.164381	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)
23:45:41.192279	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 (621) in /home/rose/dev/index.php (12)
23:45:41.192728	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)
23:45:41.192773	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)
23:45:41.204121	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)
23:45:41.204152	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)
23:45:41.215766	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)
23:45:41.215800	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` 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)
23:45:41.216664	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` 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)
23:45:41.216840	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)
23:45:41.217041	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)
23:45:41.217197	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)
23:45:41.217550	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)
23:45:41.217571	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_list_details` 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)
23:45:41.218116	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_list_details` 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)
23:45:41.218358	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_lists` 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)
23:45:41.218913	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_lists` 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)
23:45:41.219053	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)
23:45:41.220088	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)
23:45:41.220118	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)
23:45:41.220392	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)
23:45:41.220415	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `sale_prices` 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)
23:45:41.220961	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `sale_prices` 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)
23:45:41.221071	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)
23:45:41.221425	trace	system.CModule	Loading "clientScript" application component in /home/rose/dev/protected/controllers/ProductController.php (621) in /home/rose/dev/index.php (12)

Price

Product Type

Manufacturer

Brand Name

Features

Ink Color

Quantity

Marketing Information

Ink Type

Pen Point Size

Product Line

Pen Point

Recycled

Marker Point Style

Tip Material

Country of Origin

Products

Products

Are you sure