CATEGORII
Boxe High-End 2 cai, 225W - SPECIAL EDITION

TANNOY

Kensington GR EX DEMO

Boxe High-End 2 cai, 225W - SPECIAL EDITION

Unic distribuitor Premiera absoluta
Made in England BEST BUY DIAPASON 2016 HIFI WORLD 5 STARS AWARD 5 STARS WHAT HIFI - SOUND AND VISION
109,999.00 RON
49,999.00 RON (TVA inclus) Compara
Cantitate:
Stoc:DISPONIBIL
TANNOY, legendarul brand din TOP 5 mondial al tuturor timpurilor, cu o vechime de 85 de ani,
este prezent si in Romania, EXCLUSIV in parteneriat cu STEREO PLANET, incepand din 2008.
Este un inovator technologic apreciat in toata lumea, atat de iubitorii de muzica cat si de cei
de filme, sistemele sale de Boxe Home Cinema (dedicate sau alcatuite separat) fiind renumite
pentru acuratetea, claritatea si expansivitatea imaginii sunetului lor.

TANNOY este numele boxelor ce folosesc drept instalatie de sonorizare in multe locuri celebre din lume.
Exemplele cele mai importante includ Sydney Opera House, Hong Kong Convention Centre,
London Palladium Theatre, London Finnish National Theatre, Coca Cola (sediul central din
Atlanta), Hard Rock Hotel and Casino din Las Vegas, Dolce & Gabbana (sediul central din Milano)
si Yankee Stadium din New York.

The new Gold standard
The original Tannoy Monitor Gold Dual Concentric™ driver was launched in 1967 as a major upgrade
to the well-received Monitor Red series.
The ‘Golds’ found immediate favour with recording studios and audiophiles for their pin-point acoustic
accuracy, high efficiency and easy to drive impedance characteristics.
Fitted into world renowned Tannoy loudspeakers such as the Lancaster, Autograph and GRF (named after
the company’s founder Guy R. Fountain), the Monitor Gold was also the driver of choice for customers
wanting to build their own loudspeaker cabinets.
The Monitor Gold Dual Concentric has become one of the most famous Tannoy drivers in the company’s
85+ year history.
Tannoy’s senior engineers have been working on upgrades to the Prestige SE series since 2010, deploying
much of the cutting edge technology developed for the flagship Kingdom Royal.
Some of the advancements are universal across the Prestige GR series while individual technologies and
engineering improvements have also been developed specifically for each driver and cabinet.

Tannoy’s senior engineers have been working on upgrades to the Prestige SE series since 2010, deploying
much of the cutting edge technology developed for the flagship Kingdom Royal.
Some of the advancements are universal across the Prestige GR series while individual technologies and
engineering improvements have also been developed specifically for each driver and cabinet configuration.
The time-honoured method of construction of the famous Prestige cabinets remains unchanged, although the
intricate wood-working detail and metal trim pieces have been enhanced with the GR upgrade.
These bespoke pieces of fine acoustic furniture have been hand crafted from birch ply wood by Tannoy’s
finest artisans for many decades.
They remain the world’s finest traditional loudspeaker cabinets.

New cone material
At the top of Tannoy’s new Prestige GR range, both the Canterbury GR and Westminster Royal GR are
fitted with a newly developed cone material.
To increase rigidity across the larger surface area of these 15 inch Dual Concentric™ drivers, the fibrous mix
within the cone material has been revised to realise further improvements in the cone’s mechanical characteristics.
Modern imaging technology affords incredibly detailed analysis of cone mechanics under load and many
versions of the cone pulp mix were evaluated prior to the final selection of this vital component.
Several pulp mix formulas offered improved damping and exceptional mechanical performance over the
previous SE series cone.
As with all revisions to Tannoy’s important Prestige series models, the final selection of material was the result
of critical auditioning with a wide range of music.
Canterbury GR and Westminster Royal GR models now offer an even more dynamic presentation than their
predecessors, with reduced colouration and an incredibly natural mid band response.

High Frequency
A new HF compression driver diaphragm has been developed for all Prestige GR models featuring
Tannoy’s Alnico powered motors and Pepperpot Waveguide™.
Fitted to the Kensington GR, Canterbury GR and Westminster Royal GR, this technology was developed
for Tannoy’s flagship residential loudspeaker, the Kingdom Royal, and has been adapted for use in the new GR series.
Many months of R&D were spent testing and auditioning numerous alloys and heat treatment
configurations before final selection of a heat-tempered aluminium alloy.
The production diaphragms are individually tested and, along with the mated copper-clad aluminium
voice coil, are fully deep cryogenically treated.
This state-of-the-art process, involving freezing to minus 190 degrees Celsius and slowly returning to
room temperature over a controlled period, relieves residual stresses in the microstructure of the
diaphragm and reduces crystal boundary imperfections in the voice coil.
Extensive auditioning showed this extreme process to offer greater naturalness and emotional
communication of the music.
The use of Mylar™ surrounds on the HF diaphragm is also a result of the Kingdom Royal development
and now features on these three Prestige GR models.
This innovative material affords better energy termination at the diaphragm boundary, delivering a smooth
HF response up to higher frequencies.
The signature Pepperpot Waveguide™ remains on the GR series as it further enhances the point source
symmetrical dispersion properties of the driver.
An even sweeter and more natural response has been attained through the radical overhaul of the HF section,
allowing the GR series to build on Tannoy’s acknowledged attributes of musical communication and articulation.

Crossover
The major GR revisions in the Dual Concentric™ drivers and findings from the Kingdom Royal development
project have resulted in crossover improvements across the new Prestige GR series.
Components renowned for their precise audiophile characteristics and with a tighter and more exacting tolerance
have been developed since the SE series was originally launched.
Component-by-component auditioning has led to significant revisions on every GR series crossover.
ICW ClarityCap™ MR capacitors are still used in the Westminster Royal, Canterbury and Kensington GR series
models, but unique to Tannoy, the leadout wires are PTFE insulated 99.99% single strand silver, extruded to our specification.
The result of ICW’s own ground breaking two-year research program, these devices use a high-specification
metallised polypropylene film encapsulated in an epoxy resin offering excellent self-damping characteristics and
class-leading performance, both measured and auditioned.
Revised low loss laminated core inductors and thick film resistors are used throughout the Prestige GR series
crossovers, chosen for their ability to resolve micro dynamic detailing.
One of the most significant performance advances achieved during Kingdom Royal development was in the
widespread use of deep cryogenic treatment (DCT) on the crossover and cabling components.
This process will be an integral part of all Prestige GR models from Kensington GR upwards.
Rather than treating the components individually, each fully assembled Prestige GR crossover is treated as a single unit.
Not only does this improve the audio characteristics at component and cabling level but also every solder joint
is treated to ensure end-to-end improvements in the metallic crystal structure throughout the signal path.
While this process is complex and expensive, the improvements in musical cohesion and smoothness made it
an essential part of the Prestige GR upgrade.
Around the back of each Prestige GR loudspeaker, Tannoy has adopted its unique fifth speaker terminal.
This terminal can be linked to the amplifier and electrically grounds the driver chassis, dramatically reducing
radio frequency interference circulating in most hi-fi audio systems.
Eliminating this RF ‘noise’ further enhances midrange clarity and opens up the soundstage throughout the presence
region for truly expressive music presentation.
Westminster Royal GR, Canterbury GR and Kensington GR use the very latest loudspeaker terminals from WBT,
the NextGen™ WBT-0703.
These high-end loudspeaker terminals ensure perfect signal transfer from your amplifier to the Prestige GR loudspeaker.

Celebration in Style
To celebrate the launch of Prestige Gold Reference and the latest evolution of the world famous
Monitor Gold Dual Concentric driver, the Prestige GR cabinets will benefit from a range of external styling
enhancements to reflect the quality and craftsmanship within.
Light reworking of the cabinet finish will include milled and machined detailing in the timber, new veneer inlays
within the front baffle of certain models, and precision machined metalwork, hard-anodised with a gold finish.
Tannoy continues to evolve the Dual Concentric™ driver and deliver a range of traditional loudspeakers that
set the standard for musical reproduction regardless of price.
The Prestige Gold Reference series stands as another benchmark in Tannoy’s rich history and is to be marked
with the return of the famous Tannoy ‘lightning strike’ logo.
Embossed into the gold metal trim on every GR series model, the logo serves to remind owners of the rich
heritage and decades of technical development that have gone into every Prestige Gold Reference loudspeaker.

REVIEWS

"The Kensington SE might be too much of a good thing.
It's Technicolor rich, contrastier and flat out more delicious sounding than any box or panel speaker I've heard in ages.
If I've made you curious, here's my advice: Listen to your favorite music first on other speakers,
and then audition the Kensington SE.
I'm betting you won't want to go back."
Steve Guttenberg / Home Entertainment, April 2010
PERFORMANCE
Recommended amplifier power: 50 - 225W
Continuous power handling: 135W RMS
Frequency response: 29Hz - 25kHz -6dB
Sensitivity: 94dB (2.83 Volts @1 metre)
Nominal impedance: 8 Ohms

DRIVE UNITS
Dual Concentric™ high frequency: 51 mm (2.00") with aluminium alloy dome,
Alnico magnet system with Pepperpot Waveguide™
Dual Concentric™ low frequency: 250 mm (10.00") treated paper pulp cone
with HE twin roll fabric surround. 52 mm (2.00") round wire wound voice coil
Dispersion: 90 degrees conical

CROSSOVER
Frequency: 1.1kHz
Type: Bi-wired, hard wired passive, low loss time compensated 2nd order LF, 2nd order compensated HF.
Adjustment: +/- 3dB over 1kHz to 22kHz shelving, +2dB to -6dB per octave over 5kHz to 22kHz slope

CONSTRUCTION
Enclosure type: Distributed port
Volume: 105 litres

Dimensions (H x W x D): 1100 x 406 x 338 mm
Weight: 37 kg

Color: black

REVIEWS

"The Kensington SE might be too much of a good thing.
It's Technicolor rich, contrastier and flat out more delicious sounding than any box or panel speaker I've heard in ages.
If I've made you curious, here's my advice: Listen to your favorite music first on other speakers,
and then audition the Kensington SE.
I'm betting you won't want to go back."
Steve Guttenberg / Home Entertainment, April 2010
Producator: Produs:
Imagine
Boxe High-End 2 cai, 225W - SPECIAL EDITION
Produs TANNOY
Boxe High-End 2 cai, 225W - SPECIAL EDITION
Kensington GR EX DEMO
Descriere TANNOY, legendarul brand din TOP 5 mondial al tuturor timpurilor, cu o vechime de 85 de ani,
este prezent si in Romania, EXCLUSIV in parteneriat cu STEREO PLANET, incepand din 2008.
Este un inovator technologic apreciat in toata lumea, atat de iubitorii de muzica cat si de cei
de filme, sistemele sale de Boxe Home Cinema (dedicate sau alcatuite separat) fiind renumite
pentru acuratetea, claritatea si expansivitatea imaginii sunetului lor.
Specificatii PERFORMANCE
Recommended amplifier power: 50 - 225W
Continuous power handling: 135W RMS
Frequency response: 29Hz - 25kHz -6dB
Sensitivity: 94dB (2.83 Volts @1 metre)
Nominal impedance: 8 Ohms

DRIVE UNITS
Dual Concentric™ high frequency: 51 mm (2.00") with aluminium alloy dome,
Alnico magnet system with Pepperpot Waveguide™
Dual Concentric™ low frequency: 250 mm (10.00") treated paper pulp cone
with HE twin roll fabric surround. 52 mm (2.00") round wire wound voice coil
Dispersion: 90 degrees conical

CROSSOVER
Frequency: 1.1kHz
Type: Bi-wired, hard wired passive, low loss time compensated 2nd order LF, 2nd order compensated HF.
Adjustment: +/- 3dB over 1kHz to 22kHz shelving, +2dB to -6dB per octave over 5kHz to 22kHz slope

CONSTRUCTION
Enclosure type: Distributed port
Volume: 105 litres

Dimensions (H x W x D): 1100 x 406 x 338 mm
Weight: 37 kg

Color: black

REVIEWS

"The Kensington SE might be too much of a good thing.
It's Technicolor rich, contrastier and flat out more delicious sounding than any box or panel speaker I've heard in ages.
If I've made you curious, here's my advice: Listen to your favorite music first on other speakers,
and then audition the Kensington SE.
I'm betting you won't want to go back."
Steve Guttenberg / Home Entertainment, April 2010
Premii
STEREO PLANET DVDPLANET DVDPLANET
Preţ: 109,999.00 RON
49,999.00 RON (TVA inclus)
Disponibilitate Disponibil
REVIEWS CLIENTI
Adauga review
Ascunde review

Spune-ţi opinia

Numele tău:


Numarul de telefon:


Email-ul:


Opinia ta: Notă: Codul HTML este citit ca şi text!

Nota: Rău           Bun

Introduceţi codul din imagine:



Queries: 86, Total time: 47.124 ms [By time] [By id] [By file]
1 (0.215)
SELECT *
FROM store
WHERE store_id = 0
/home/stereoplanet/public_html/index.php:112
2 (0.967)
SELECT *
FROM setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/stereoplanet/public_html/index.php:122
3 (0.113)
SELECT *
FROM language
WHERE status = '1'
/home/stereoplanet/public_html/index.php:203
4 (0.094)
SELECT *
FROM currency
/home/stereoplanet/public_html/system/library/currency.php:13
5 (0.138)
SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/stereoplanet/public_html/system/library/weight.php:9
6 (0.106)
SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/stereoplanet/public_html/system/library/length.php:9
7 (0.168)
SELECT *
FROM url_alias
WHERE keyword = 'tannoy_kensington_gr_ex_demo'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
8 (1.454)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start <= NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14746' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
9 (0.116)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=14746'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
10 (0.090)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=14746'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
11 (0.137)
SELECT COUNT(*) AS total
FROM review r
LEFT JOIN product p ON (r.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '14746' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review.php:50
12 (0.143)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=151'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
13 (4.214)
SELECT r.review_id, r.author, r.name as rname, r.rating, pra.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.image AS review_img, pra.file
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '14746' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY pra.sort_order ASC, pra.data_added DESC LIMIT 0,20
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:36
14 (4.282)
SELECT r.review_id, r.author, r.name as rname, r.rating, pra.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.image AS review_img, pra.file
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '14746' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2' AND r.show_bottom = 1
ORDER BY pra.sort_order ASC, pra.data_added DESC LIMIT 0,20
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:36
15 (0.132)
SELECT *
FROM `review_awards`
WHERE `review_id` = 27 or `review_id` = 28 or `review_id` = 74;
/home/stereoplanet/public_html/catalog/model/catalog/product.php:117
16 (1.517)
SELECT *
FROM product_image
WHERE product_id = '14746'
ORDER BY sort_order ASC
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2077
17 (0.401)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:91
18 (0.191)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:119
19 (0.224)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:91
20 (0.264)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:119
21 (0.149)
SELECT *
FROM product_discount
WHERE product_id = '14746' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2071
22 (0.175)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
LEFT JOIN option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '14746' AND od.language_id = '2'
ORDER BY o.sort_order
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2018
23 (0.172)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14746' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/stereoplanet/public_html/catalog/model/catalog/product.php:1990
24 (0.314)
SELECT *
FROM product_related pr
LEFT JOIN product p ON (pr.related_id = p.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '14746' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2085
25 (1.422)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start <= NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7467' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
26 (1.396)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start <= NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '13662' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
27 (1.398)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start <= NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '13663' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
28 (0.331)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:91
29 (0.242)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:119
30 (4.867)
SELECT r.review_id, r.author, r.name as rname, r.rating, pra.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.image AS review_img, pra.file
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '7467' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY pra.sort_order ASC, pra.data_added DESC LIMIT 0,20
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:36
31 (0.256)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=7467'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
32 (4.877)
SELECT r.review_id, r.author, r.name as rname, r.rating, pra.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.image AS review_img, pra.file
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '13662' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY pra.sort_order ASC, pra.data_added DESC LIMIT 0,20
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:36
33 (0.174)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=13662'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
34 (4.232)
SELECT r.review_id, r.author, r.name as rname, r.rating, pra.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.image AS review_img, pra.file
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '13663' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY pra.sort_order ASC, pra.data_added DESC LIMIT 0,20
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:36
35 (0.161)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=13663'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
36 (0.143)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '14746'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:4
37 (0.174)
SELECT *
FROM `product_to_category`
WHERE `product_id` = 14746 limit 1
/home/stereoplanet/public_html/catalog/model/catalog/product.php:70
38 (0.140)
SELECT *
FROM `category` c
left join category_description cd on (cd.category_id = c.category_id)
WHERE c.`category_id` = 67 limit 1
/home/stereoplanet/public_html/catalog/model/catalog/product.php:81
39 (0.158)
Select *
from url_alias
where `query` in ('category_id=67')
/home/stereoplanet/public_html/catalog/model/catalog/product.php:88
40 (0.116)
SELECT *
FROM product_to_layout
WHERE product_id = '14746' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
41 (0.129)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
42 (0.148)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
43 (0.510)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/stereoplanet/public_html/catalog/model/catalog/category.php:10
44 (0.266)
SELECT *
FROM banner_image bi
LEFT JOIN banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '6' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC, bid.title ASC
/home/stereoplanet/public_html/catalog/model/design/banner.php:5
45 (0.135)
CREATE TABLE IF NOT EXISTS subscribe ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email_id` varchar(225) NOT NULL, `name` varchar(225) NOT NULL, `option1` varchar(225) NOT NULL, `option2` varchar(225) NOT NULL, `option3` varchar(225) NOT NULL, `option4` varchar(225) NOT NULL, `option5` varchar(225) NOT NULL, `option6` varchar(225) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `Index_2` (`email_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/home/stereoplanet/public_html/catalog/model/account/newslettersubscribe.php:46
46 (0.109)
SELECT *
FROM product_to_layout
WHERE product_id = '14746' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
47 (0.113)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
48 (0.129)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
49 (0.099)
SELECT *
FROM product_to_layout
WHERE product_id = '14746' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
50 (0.106)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
51 (0.125)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
52 (0.103)
SELECT *
FROM product_to_layout
WHERE product_id = '14746' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
53 (0.105)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
54 (0.129)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
55 (0.091)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
56 (4.294)
SELECT *
FROM banner_image bi
LEFT JOIN banner_image_description bid ON ( bi.banner_image_id = bid.banner_image_id )
LEFT JOIN ( SELECT `manufacturer_id` , CONCAT( 'index.php?route=product/manufacturer/info&manufacturer_id=', manufacturer.manufacturer_id ) AS manlink, CONCAT( 'manufacturer_id=', manufacturer.manufacturer_id ) AS manquery
FROM `manufacturer` ) AS tmpman ON ( tmpman.manlink = bi.link )
LEFT JOIN url_alias ua ON ( tmpman.manquery = ua.query )
WHERE bi.banner_id = '8' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC , bid.title ASC
/home/stereoplanet/public_html/catalog/model/design/banner.php:22
57 (0.515)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY CAST(i.sort_order AS CHAR), LCASE(id.title) ASC
/home/stereoplanet/public_html/catalog/model/catalog/information.php:31
58 (0.148)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
59 (0.123)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
60 (0.118)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
61 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
62 (0.122)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
63 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
64 (0.371)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/stereoplanet/public_html/catalog/model/catalog/category.php:10
65 (0.114)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
66 (0.429)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY CAST(i.sort_order AS CHAR), LCASE(id.title) ASC
/home/stereoplanet/public_html/catalog/model/catalog/information.php:31
67 (0.186)
SELECT *
from url_alias
where query='information_id=23' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
68 (0.138)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
69 (0.123)
SELECT *
from url_alias
where query='information_id=5' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
70 (0.121)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
71 (0.123)
SELECT *
from url_alias
where query='information_id=4' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
72 (0.121)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
73 (0.139)
SELECT *
from url_alias
where query='information_id=25' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
74 (0.122)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
75 (0.124)
SELECT *
from url_alias
where query='information_id=6' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
76 (0.120)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
77 (0.119)
SELECT *
from url_alias
where query='information_id=3' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
78 (0.123)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
79 (0.117)
SELECT *
from url_alias
where query='information_id=7' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
80 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
81 (0.153)
SELECT *
from url_alias
where query='information_id=24' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
82 (0.126)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=24'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
83 (0.104)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=14746'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
84 (0.098)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=14746'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
85 (0.096)
SELECT *
FROM extension
WHERE `type` = 'total'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
86 (0.088)
SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'
/home/stereoplanet/public_html/system/library/customer.php:201