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: Ciba Vision

Focus Dailies Aqua Comfort 30pk
A fresh new pair of lenses everyday with DAILIES...
From $36.78
thumb
Focus Dailies Aqua Comfort 90pk
A fresh new pair of lenses everyday with DAILIES AquaComfort...
From $93.20
thumb
Focus Dailies All Day Comfort 30pk
Millions of people rely on Focus Dailies daily disposable...
From $39.68
thumb
Focus Dailies All Day Comfort 90pk
Millions of people rely on Focus Dailies daily disposable...
From $89.15
thumb
Focus Dailies Toric 30pk
The world's first daily disposable lens for astigmatism,...
From $44.90
thumb
Focus Dailies Toric 90pk
The world's first daily disposable lens for astigmatism,...
From $114.09
thumb
Focus Dailies Progressive
A daily disposable soft contact lens that provides...
From $53.61
thumb
Air Optix
Air Optix are breathable contact lenses have up to...
From $45.48
thumb
Air Optix for Astigmatism
Air Optix for Astigmatism is a breathable contact lens...
From $57.08
thumb
Air Optix Multifocal
Air Optix Aqua Multifocal contact lenses from Ciba...
From $57.08
thumb
Night & Day 6pk
Ciba Night & Day are the contact lenses you can...
From $116.24
thumb
Precision UV
Ultra-violet rays infiltrating the Earth's surface...
From $59.40
thumb
Freshlook 1 Day Colorblends
Want to change, enhance or illuminate your eye colour?...
From $26.61
thumb
Freshlook Colorblends
Want to change, enhance or illuminate your eye colour?...
From $39.95
thumb
Freshlook Colors
Want to change, enhance or illuminate your eye colour?...
From $39.95
thumb
Freshlook Dimensions
Want to change, enhance or illuminate your eye colour?...
From $91.95
thumb

 
Sitevision Web Design

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

  URI STRING  
/shop/brand/2/
  CLASS/METHOD  
shop/brand
  MEMORY USAGE  
3,268,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0104
Controller Execution Time ( Shop / Brand )  0.1035
Total Execution Time  0.1140
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  contacts_lens   QUERIES: 188   
0.0010   INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('e73b25fb053983b36d0dde11885dd928', '38.107.191.103', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1283698614) 
0.0002   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '2' 
0.0001   SELECT *
FROM (`shop_manufacturer`)
WHERE `shop_manufacturer_id` = '2' 
0.0005   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_deleted` = 0
AND `shop_catalog_active` = 1
AND `shop_catalog_manufacturer_id` = '2' 
0.0002   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '28' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '28' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '29' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '29' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '30' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '30' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '31' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '31' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '32' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '32' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '33' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '33' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '34' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '34' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '51' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '51' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '52' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '52' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '53' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '53' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '61' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '61' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '63' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '63' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '80' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '80' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '81' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '81' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '82' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '82' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '83' 
0.0001   SELECT *
FROM (`shop_catalog`)
WHERE `shop_catalog_id` = '83' 
0.0003   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '28'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0003   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '28'
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` = '43' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '43' 
0.0002   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '28' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '124' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '124' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '125' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '125' 
0.0002   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '29'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '29'
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` = '46' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '46' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '29' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '43' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '43' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '181' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '181' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '30'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '30'
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` = '49' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '49' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '30' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '146' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '146' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '182' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '182' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '31'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '31'
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` = '52' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '52' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '31' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '45' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '45' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '183' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '183' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '32'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '32'
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` = '55' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '55' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '32' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '149' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '149' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '184' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '184' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '33'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '33'
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` = '58' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '58' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '33' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '147' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '147' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '185' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '185' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '34'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '34'
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` = '61' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '61' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '34' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '48' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '48' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '229' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '229' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '51'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '51'
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` = '112' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '112' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '51' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '152' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '152' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '177' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '177' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '52'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '52'
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` = '115' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '115' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '52' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '119' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '119' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '178' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '178' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '53'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '53'
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` = '118' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '118' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '53' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '67' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '67' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '179' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '179' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '61'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '61'
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` = '141' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '141' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '61' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '75' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '75' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '180' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '180' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '63'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '63'
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` = '147' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '147' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '63' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '77' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '77' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '186' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '186' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '80'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '80'
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` = '198' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '198' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '80' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '95' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '95' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '241' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '241' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '81'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '81'
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` = '201' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '201' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '81' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '96' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '96' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '176' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '176' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '82'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '82'
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` = '204' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '204' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '82' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '97' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '97' 
0.0001   SELECT *
FROM (`shop_special`)
WHERE `shop_special_belongto_catalog_id` = '83'
AND `shop_special_deleted` = 0
AND `shop_special_status` = 'active'
AND (shop_special_expiry >= '2010-09-06'
OR `shop_special_expiry` = '0000-00-00'
AND 1 =1) 
0.0002   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_belongto_catalog_id` = '83'
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` = '207' 
0.0001   SELECT *
FROM (`shop_quantity_price`)
WHERE `shop_quantity_price_id` = '207' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_belongto_catalog_id` = '83' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '98' 
0.0001   SELECT *
FROM (`shop_image`)
WHERE `shop_image_id` = '98' 
0.0003   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'