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: CooperVision

Biomedics 1 Day 30pk
BioMedics 1 Day contact lenses are designed as a high...
From $29.53
thumb
Biomedics 1 Day 90pk
BioMedics 1 Day contact lenses are designed as a high...
From $73.49
thumb
Biomedics 1 Day Toric 30pk
BioMedics 1 Day Toric is designed for patients with...
From $49.95
thumb
Biomedics 1 Day Toric 90pk
BioMedics 1 Day Toric is designed for patients with...
From $109.95
thumb
Proclear 1 Day 30pk
Proclear 1 Day contact lenses provide an exceptional...
From $36.78
thumb
Proclear 1 Day 90pk
Proclear 1 Day contact lenses provide an exceptional...
From $93.20
thumb
Avaira
Avaira contact lenses are made from a unique material...
From $46.76
thumb
Frequency 58UV
CooperVision's Frequency 58 UV contact lenses are designed...
From $53.60
thumb
Biofinity
Biofinity is made from the breakthrough Aquaform material...
From $99.95
thumb
Biofinity Toric
If you have astigmatism, Biofinity Toric contact lenses...
From $114.95
thumb
Biomedics 55 Evolution
Biomedics 55 Evolution contact lenses give improved...
From $40.26
thumb
Biomedics Toric
Biomedics Toric contact lenses are the benchmark contacts...
From $93.03
thumb
Frequency 55 Aspheric
The Frequency family of contact lenses offer a wide...
From $43.74
thumb
Frequency Xcel Toric
Frequency Xcel Toric soft contact lenses use a unique...
From $54.77
thumb
Frequency Xcel XR Toric
Frequency Xcel Toric soft contact lenses use a unique...
From $144.95
thumb
Proclear
Proclear contact lenses are uniquely engineered to...
From $79.95
thumb
Proclear XR
Proclear contact lenses are uniquely engineered to...
From $99.95
thumb
Proclear Toric
If you have astigmatism, Proclear Toric contact lenses...
From $104.95
thumb
Proclear XR Toric
The eagerly awaited Proclear XR Toric is now available....
From $144.95
thumb
Proclear EP
Proclear EP (Early Presbyope) is a contact lens designed...
From $59.95
thumb
Proclear Multifocal
Proclear Multifocal contact lenses offer a new level...
From $109.95
thumb
Rythmic UV
Rythmic UV Multifocal contact lenses, also known as...
From $64.25
thumb
Crazy Lenses
Looking for contact lenses that are a bit more...unusual?...
From $81.95
thumb
Expressions Accents
Expressions accents soft contact lenses let you enhance...
From $54.95
thumb
Experssions Colours
Expressions let you change your eye colour with lenses...
From $29.95
thumb
Biomedics XC
Biomedics XC contact lenses from CooperVision are a...
From $43.74
thumb
Avaira Toric
Avaira contact lenses are made from a unique material...
From $58.24
thumb

 
Sitevision Web Design

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

  URI STRING  
/shop/brand/4/
  CLASS/METHOD  
shop/brand
  MEMORY USAGE  
3,411,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0106
Controller Execution Time ( Shop / Brand )  0.1416
Total Execution Time  0.1522
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  contacts_lens   QUERIES: 313   
0.0008   INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('3ac0bad66a03bd20450b26340b541955', '38.107.191.104', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1280482028) 
0.0002   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '4' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '4' 
0.0007   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_deleted` = 0
AND `shop_catalog_active` = 1
AND `shop_catalog_manufacturer_id` = '4' 
0.0002   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '24' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '24' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '25' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '25' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '26' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '26' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '27' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '27' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '35' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '35' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '36' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '36' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '46' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '46' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '47' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '47' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '54' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '54' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '55' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '55' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '56' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '56' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '57' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '57' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '58' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '58' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '59' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '59' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '60' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '60' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '64' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '64' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '65' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '65' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '66' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '66' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '67' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '67' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '68' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '68' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '69' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '69' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '73' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '73' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '77' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '77' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '78' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '78' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '79' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '79' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '93' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '93' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '94' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '94' 
0.0002   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '24'
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` = '24'
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` = '31' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '31' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '24' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '38' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '38' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '236' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '236' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '25'
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` = '25'
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` = '34' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '34' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '25' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '39' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '39' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '239' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '239' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '26'
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` = '26'
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` = '37' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '37' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '26' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '40' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '40' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '238' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '238' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '27'
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` = '27'
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` = '40' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '40' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '27' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '41' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '41' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '240' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '240' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '35'
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` = '35'
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` = '64' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '64' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '35' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '173' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '173' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '227' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '227' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '36'
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` = '36'
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` = '67' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '67' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '36' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '50' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '50' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '228' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '228' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '46'
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` = '46'
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` = '97' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '97' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '46' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '126' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '126' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '127' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '127' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '47'
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` = '47'
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` = '100' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '100' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '47' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '61' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '61' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '231' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '231' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '54'
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` = '54'
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` = '121' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '121' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '54' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '68' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '68' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '158' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '158' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '55'
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` = '55'
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` = '124' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '124' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '55' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '69' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '69' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '194' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '194' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '56'
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` = '56'
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` = '127' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '127' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '56' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '70' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '70' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '223' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '223' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '57'
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` = '57'
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` = '130' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '130' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '57' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '172' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '172' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '195' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '195' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '58'
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` = '58'
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` = '133' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '133' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '58' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '170' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '170' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '196' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '196' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '59'
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` = '59'
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` = '136' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '136' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '59' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '169' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '169' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '224' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '224' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '60'
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` = '60'
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` = '219' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '219' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '60' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '74' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '74' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '214' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '214' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '64'
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` = '64'
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` = '150' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '150' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '64' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '78' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '78' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '157' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '157' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '65'
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` = '65'
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` = '153' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '153' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '65' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '79' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '79' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '213' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '213' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '66'
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` = '66'
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` = '156' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '156' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '66' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '168' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '168' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '197' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '197' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '67'
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` = '67'
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` = '159' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '159' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '67' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '81' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '81' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '215' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '215' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '68'
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` = '68'
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` = '162' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '162' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '68' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '82' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '82' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '217' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '217' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '69'
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` = '69'
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` = '165' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '165' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '69' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '167' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '167' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '198' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '198' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '73'
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` = '73'
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` = '177' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '177' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '73' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '87' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '87' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '216' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '216' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '77'
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` = '77'
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` = '189' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '189' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '77' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '92' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '92' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '107' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '107' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '78'
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` = '78'
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` = '192' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '192' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '78' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '93' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '93' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '108' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '108' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '79'
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` = '79'
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` = '195' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '195' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '79' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '154' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '154' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '156' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '156' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '93'
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` = '93'
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` = '225' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '225' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '93' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '218' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '218' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '219' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '219' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '94'
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` = '94'
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` = '228' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '228' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '94' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '221' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '221' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '230' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '230' 
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'