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: Bausch & Lomb

Soflens Daily 30pk
SofLens daily disposable contact lenses combine outstanding...
From $30.52
thumb
Soflens Daily 90pk
SofLens daily disposable contact lenses combine outstanding...
From $78.59
thumb
Soflens Daily for Astigmatism
SofLens Daily Disposable for Astigmatism contact lenses...
From $41.94
thumb
Soflens Comfort/59
Bausch & Lomb SofLens Comfort contact lenses deliver...
From $39.45
thumb
Soflens 66
Uniquely designed with performance in mind. The high...
From $59.69
thumb
Soflens Toric
Bausch & Lomb SofLens Toric is a two-week replacement...
From $57.50
thumb
PureVision
PureVision contact lenses are the first lenses made...
From $47.43
thumb
PureVision Toric
Bausch & Lomb PureVision Toric lenses are uniquely...
From $65.78
thumb
PureVision Multifocal
Bausch & Lomb PureVision Multi-Focal contact lenses...
From $121.33
thumb
Soflens 38/Medalist
SofLens 38 contact lenses combine a high-performance,...
From $76.53
thumb
Soflens Multifocal
If you thought presbyopia - the need for reading glasses...
From $114.95
thumb

 
Sitevision Web Design

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

  URI STRING  
/shop/brand/3/
  CLASS/METHOD  
shop/brand
  MEMORY USAGE  
3,206,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0105
Controller Execution Time ( Shop / Brand )  0.0868
Total Execution Time  0.0973
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  contacts_lens   QUERIES: 137   
0.0009   INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('29300ba4f92d7cee885f080338074fa3', '38.107.191.100', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1280482032) 
0.0002   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '3' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '3' 
0.0004   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_deleted` = 0
AND `shop_catalog_active` = 1
AND `shop_catalog_manufacturer_id` = '3' 
0.0002   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '37' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '37' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '38' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '38' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '39' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '39' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '48' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '48' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '49' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '49' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '50' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '50' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '70' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '70' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '71' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '71' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '72' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '72' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '74' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '74' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '75' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '75' 
0.0002   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '37'
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` = '37'
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` = '70' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '70' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '37' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '160' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '160' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '192' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '192' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '38'
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` = '38'
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` = '73' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '73' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '38' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '52' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '52' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '193' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '193' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '39'
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` = '39'
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` = '76' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '76' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '39' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '53' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '53' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '235' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '235' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '48'
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` = '48'
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` = '103' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '103' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '48' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '162' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '162' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '232' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '232' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '49'
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` = '49'
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` = '106' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '106' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '49' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '63' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '63' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '233' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '233' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '50'
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` = '50'
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` = '109' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '109' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '50' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '64' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '64' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '234' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '234' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '70'
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` = '70'
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` = '168' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '168' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '70' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '164' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '164' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '187' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '187' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '71'
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` = '71'
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` = '171' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '171' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '71' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '165' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '165' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '188' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '188' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '72'
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` = '72'
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` = '174' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '174' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '72' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '166' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '166' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '210' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '210' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '74'
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` = '74'
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` = '180' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '180' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '74' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '88' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '88' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '189' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '189' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '75'
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` = '75'
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` = '183' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '183' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '75' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '89' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '89' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '190' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '190' 
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'