Search:

Members Login here

Email

Password
 

Forgot your Password?
Register now for Free!

Shop by Type

Shop by Brand

Accessories

Shopping Cart

0 Items

View by Brand: Johnson & Johnson

Acuvue 1 Day Moist 30pk
1-Day Acuvue Moist allows you the freedom of wearing...
From $32.94
thumb
Acuvue 1 Day Moist 90pk
1-Day Acuvue Moist allows you the freedom of wearing...
From $83.40
thumb
Acuvue 1 Day Astigmatism 30pk
Now people with Astigmatism can experience the freedom...
From $52.95
thumb
Acuvue 1 Day Astigmatism 90pk
Now people with Astigmatism can experience the freedom...
From $129.95
thumb
Acuvue Oasys
Acuvue Oasys contact lenses are the next generation...
From $41.63
thumb
Acuvue Oasys for Astigmatism
For people who demand more, these revolutionary astigmatic...
From $58.24
thumb
Acuvue Advance
Affordable contact lenses that you can wear comfortably,...
From $40.67
thumb
Acuvue Advance for Astigmatism
Having Astigmatism is no longer a barrier to wearing...
From $58.24
thumb
Acuvue 2
Proven and trusted with Contour Intelligent Design,...
From $40.67
thumb
Acuvue Bifocal
Acuvue Bifocal Contact Lenses are scientifically designed...
From $76.68
thumb
Acuvue 1 Day Define
Enhance your natural beauty with 1 Day Acuvue Define...
From $47.95
thumb
Acuvue TruEye 30pk
Acuvue TruEye is the latest innovation from Johnson...
From $49.95
thumb
Acuvue TruEye 90pk
Acuvue TruEye is the latest innovation from Johnson...
From $114.95
thumb

 
Sitevision Web Design

Copyright 2009 Contactsonline.co.nz
Website design by Sitevision, Hosting by Juiced

  URI STRING  
/shop/brand/1/
  CLASS/METHOD  
shop/brand
  MEMORY USAGE  
3,231,052 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0104
Controller Execution Time ( Shop / Brand )  0.0936
Total Execution Time  0.1041
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  contacts_lens   QUERIES: 159   
0.0008   INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('55984ea9754df0717c2ce75ed340fc27', '38.107.191.102', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1280482454) 
0.0002   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '1' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '1' 
0.0005   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_deleted` = 0
AND `shop_catalog_active` = 1
AND `shop_catalog_manufacturer_id` = '1' 
0.0002   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '20' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '20' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '21' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '21' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '22' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '22' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '23' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '23' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '40' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '40' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '41' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '41' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '42' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '42' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '43' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '43' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '44' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '44' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '45' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '45' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '76' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '76' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '90' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '90' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '91' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '91' 
0.0002   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '20'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '20'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '19' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '19' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '20' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '114' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '114' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '128' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '128' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '21'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '21'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '22' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '22' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '21' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '35' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '35' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '129' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '129' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '22'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '22'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '25' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '25' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '22' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '36' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '36' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '141' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '141' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '23'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '23'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '28' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '28' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '23' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '37' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '37' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '144' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '144' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '40'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '40'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '79' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '79' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '40' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '54' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '54' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '123' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '123' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '41'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '41'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '82' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '82' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '41' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '55' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '55' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '130' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '130' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '42'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '42'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '85' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '85' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '42' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '56' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '56' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '140' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '140' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '43'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '43'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '88' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '88' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '43' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '138' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '138' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '139' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '139' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '44'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '44'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '91' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '91' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '44' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '58' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '58' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '137' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '137' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '45'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '45'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '94' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '94' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '45' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '134' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '134' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '135' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '135' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '76'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '76'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '186' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '186' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '76' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '90' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '90' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '136' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '136' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '90'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '90'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '210' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '210' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '90' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '211' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '211' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '226' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '226' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '91'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-07-30'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '91'
AND `shop_quantity_price_deleted` = 0
ORDER BY `shop_quantity_price_price_per_item` asc
LIMIT 1 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '213' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '213' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '91' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '212' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '212' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '225' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '225' 
0.0001   SELECT *
FROM (`banner`)
ORDER BY `id` desc 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_deleted` = 0 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '1' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '1' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '2' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '2' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '3' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '3' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '4' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '4' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '5' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '5'