CATEGORII
Amplificator Mono High-End, 1x850W (4 Ohms) sau 1x450W (8 Ohms), THX® Ultra2™ Certified

PARASOUND

JC1+

Amplificator Mono High-End, 1x850W (4 Ohms) sau 1x450W (8 Ohms), THX® Ultra2™ Certified

Unic distribuitor Premiera absoluta
USA Flag BEST BUY STEREOPHILE RECOMMENDED COMPONENT EDITORS CHOICE AWARD 2020 THE ABSOLUTE SOUND
89,999.00 RON (TVA inclus) Compara
Cantitate:
Stoc:INTREABA / SUNA
Unul dintre cele mai asteptate brand-uri, PARASOUND, a sosit in sfarsit in Romania incepand din
1 Ianuarie 2011, in parteneriat EXCLUSIV cu STEREO PLANET.
Renumiti pentru raportul fabulos pret - calitate pe care-l au produsele lor, americanii de la PARASOUND
ofera nu numai o gama inedita de produse ci si semnatura unuia dintre cei mai celebri designeri de
amplificatoare din lume, John Curl.
Devenit faimos dupa colaborarea cu branduri precum Mark Levinson, John Curl este cel ce a
"inventat" seria Halo de la PARASOUND, care a uimit lumea intreaga a audiophililor cu excelentul
triunghi castigator: sunet - constructie - pret.

Fabulosul sunet al produselor PARASOUND este certificat si de prezenta lor in studiourile de inregistrari
ale gigantilor Lucasfilm, Sony Pictures, Warner Brothers, Pixar, 20th Century Fox, Universal Pictures
sau in posesia unor nume celebre precum Kanye West sau Oliver Stone.
Deloc mai putin important, produsele PARASOUND sunt mentionate si in / la realizarea seriei de
senzatie Star Wars.

General
Circuitry designed by legendary John Curl
Ultra-high bias Class A/AB operation
25 watts of pure Class A power
Stable with speaker impedance dips below 1Ω
Bybee Music Rails™ - active high frequency filters for input stage
New John Curl driver stage employs a cascode circuit for greater open loop bandwidth & superior linearity
Gain switch to select 29 dB or 23 dB gain for optimum compatibility with high gain preamps or extremely efficient speakers
R-core transformer for input stage suppresses noise on power line
6 massive 33,000 uF Nichicon Gold Tune filter capacitors for output stage
22,400 uF input stage power supply filter capacitors, independent of the main power supply
Dual CHK Infinium, custom 5-way speaker binding posts for easy bi-wiring
Neutrik locking XLR balanced input & loop output jacks
Vampire 24k gold-plated RCA input & loop output jacks
Direct-coupled signal path, no capacitors or inductors in the audio path
JFET input stage, MOSFET driver stage
24 beta-matched 15 ampere, 230V, 60 MHz bipolar output transistors
2.1 kVA shielded toroid power transformer with premium H18 grade core
Independent power supplies for input stage, driver stage & output stage
Full power is rated all the way down to 2Hz for unrestricted low-end bass
Harris hyper-fast soft-recovery bridge diode rectifiers
REL & Nichicon Muse capacitors
DC servo & relay protection circuits
AC turn-on inrush surge protection with relay bypass
Automatic turn-on by 12 V trigger or audio sensing
4 rack space chassis with rear carry handles
Rack mount hardware is included

NOTA: Pretul este per pereche.

REVIEWS

"A bargain, and highly recommended."
Michael Fremer / Stereophile

"...incredibly effortless and natural.
This amplifier certainly held me captivated and entertained, drawing me into the music.
If you want to lose yourself in the music, there are precious few components as good as the JC 1."
David Allcock / Hi-Fi News

"Before you blow $10k-$20k or more on some amps that were recommended by a reviewer who
didn't buy them, give a listen to the Parasounds, which this reviewer did purchase.
Don't buy an amp without hearing these, even if you can't afford them."
Sam Tellig - Product Of The Year / Stereophile

"Beautiful Brutes.
The JC 1s rank with the best amplifiers I have heard in recreating a multideminsional sound field.
They pump out seemingly effortless power no matter how insanely loud I push them, with never
any sense of strain such as you hear when an amplifier is running out of gas.
The JC 1s are also capable of wondrous delicacy, and the kind of transparency that makes you feel
that you're hearing every instrument, every voice, but never at the expense of the musical whole.
To be able to buy these robust, delicate, emotionally involving, brilliantly conceived and executed
music recreators for $6,000 each piece seems to me little short of a miracle."
Wayne Donnelly / EnjoytheMusic.com

"Parasound's Halo JC 1 amplifier, is among the most precisely nuanced amplifiers I know,
able to draw the slightest and most delicate of musical expressions, to make the subtlest distinctions.
It can also rock you, like your back ain't got no bone, 'cuz it's a brute.
It is the amp for all seasons.
It has the ability to produce a believable facsimile of spaciousness, that 3-D sound-staging that
makes the illusion of space between the instruments nearly tangible; the ability to produce
timbral, harmonic, and dynamic accuracy that results in what we call 'inner detail';
the ability to produce delicate refined purity of tone one moment, and then bowl you over with
A BIG WALL OF SOUND the next.
...these amps are truly outstanding, among the best I've ever heard, and the best I've had in my system."
Max Dudious / Positive Feedback

"I was impressed with the remarkable speed, clarity, transparency, and focus of these amps straight out of the box.
The high frequencies were to-die-for silky smooth, crystal clear, and abundantly detailed.
The kind you could listen to all day long without fatigue.
There wasn't anything that didn't sound great on the JC 1.
I was left with an ear-to-ear grin on my face that lasted the rest of the week.
Sue Kraft / The Absolute Sound

"...ultra-wide bandwidth, high-current capability, low, low noise, a high S/N ratio, and a fast slew rate,
among many other indicators of outstanding amplifier performance.
There was an honesty to the overall tonal and harmonic presentation that transcended
technological stereotypes.
The Halo JC 1 is not only the best amplifier to come from Parasound, it ranks up there with the
best high-end heavyweights.
Rocks for sure."
Class A Recommended Component / Stereophile

"It took but a few seconds for me to absolutely fall in love with the Halo JC 1.
Powerful, refined, smooth, organized, dynamic, transparent, and rhythmically supple, the JC 1
offered a combination of attributes that added up to many weeks of listening pleasure.
I'd be happy to have it go on indefinitely - as, no doubt, will many of you."
Michael Fremer / Stereophile
Tehcnical Specifications
Continuous power output, 20Hz - 20 kHz:
450 watts RMS x 1, 8 Ω
850 watts RMS x 1, 4 Ω
1300 watts RMS x 1, 2 Ω

Class A power output, 20Hz - 20 kHz:
25 watts, bias set to high, 8 Ω
10 watts, bias set to low, 8 Ω

Current capacity: 135 amperes peak
Power bandwidth: 2 Hz - 120 kHz, +0/-3 dB at 1 watt
Total harmonic distortion: < 0.15 % at full power
IM distortion: balanced 16 V rms < 0.03 %
Slew rate: > 130 V/µsecond
Dynamic headroom: > 1.8 dB
Input sensitivity: 1 V for 28.28 V, THX Reference Level
Input impedance: 100 k Ω
S/N ratio:
>120 dB, IHF A-weighted, bias set to high
>122 dB, IHF A-weighted, bias set to low
Damping factor: > 1200 at 20 Hz

Power Requirement: 250 watts idle 1280 watts full power into 4 Ω
DC trigger output capacity: +12 Vdc, 150 mA

Dimensions (W x H x D): 44 x 20 x 51 cm
Weight: 38 kg

Colors: black, silver

NOTA: Pretul este per pereche.


REVIEWS

"A bargain, and highly recommended."
Michael Fremer / Stereophile

"...incredibly effortless and natural.
This amplifier certainly held me captivated and entertained, drawing me into the music.
If you want to lose yourself in the music, there are precious few components as good as the JC 1."
David Allcock / Hi-Fi News

"Before you blow $10k-$20k or more on some amps that were recommended by a reviewer who
didn't buy them, give a listen to the Parasounds, which this reviewer did purchase.
Don't buy an amp without hearing these, even if you can't afford them."
Sam Tellig - Product Of The Year / Stereophile

"Beautiful Brutes.
The JC 1s rank with the best amplifiers I have heard in recreating a multideminsional sound field.
They pump out seemingly effortless power no matter how insanely loud I push them, with never
any sense of strain such as you hear when an amplifier is running out of gas.
The JC 1s are also capable of wondrous delicacy, and the kind of transparency that makes you feel
that you're hearing every instrument, every voice, but never at the expense of the musical whole.
To be able to buy these robust, delicate, emotionally involving, brilliantly conceived and executed
music recreators for $6,000 each piece seems to me little short of a miracle."
Wayne Donnelly / EnjoytheMusic.com

"Parasound's Halo JC 1 amplifier, is among the most precisely nuanced amplifiers I know,
able to draw the slightest and most delicate of musical expressions, to make the subtlest distinctions.
It can also rock you, like your back ain't got no bone, 'cuz it's a brute.
It is the amp for all seasons.
It has the ability to produce a believable facsimile of spaciousness, that 3-D sound-staging that
makes the illusion of space between the instruments nearly tangible; the ability to produce
timbral, harmonic, and dynamic accuracy that results in what we call 'inner detail';
the ability to produce delicate refined purity of tone one moment, and then bowl you over with
A BIG WALL OF SOUND the next.
...these amps are truly outstanding, among the best I've ever heard, and the best I've had in my system."
Max Dudious / Positive Feedback

"I was impressed with the remarkable speed, clarity, transparency, and focus of these amps straight out of the box.
The high frequencies were to-die-for silky smooth, crystal clear, and abundantly detailed.
The kind you could listen to all day long without fatigue.
There wasn't anything that didn't sound great on the JC 1.
I was left with an ear-to-ear grin on my face that lasted the rest of the week.
Sue Kraft / The Absolute Sound

"...ultra-wide bandwidth, high-current capability, low, low noise, a high S/N ratio, and a fast slew rate,
among many other indicators of outstanding amplifier performance.
There was an honesty to the overall tonal and harmonic presentation that transcended
technological stereotypes.
The Halo JC 1 is not only the best amplifier to come from Parasound, it ranks up there with the
best high-end heavyweights.
Rocks for sure."
Class A Recommended Component / Stereophile

"It took but a few seconds for me to absolutely fall in love with the Halo JC 1.
Powerful, refined, smooth, organized, dynamic, transparent, and rhythmically supple, the JC 1
offered a combination of attributes that added up to many weeks of listening pleasure.
I'd be happy to have it go on indefinitely - as, no doubt, will many of you."
Michael Fremer / Stereophile
Producator: Produs:
Imagine
Amplificator Mono High-End, 1x850W (4 Ohms) sau 1x450W (8 Ohms), THX® Ultra2™ Certified
Produs PARASOUND
Amplificator Mono High-End, 1x850W (4 Ohms) sau 1x450W (8 Ohms), THX® Ultra2™ Certified
JC1+
Descriere Unul dintre cele mai asteptate brand-uri, PARASOUND, a sosit in sfarsit in Romania incepand din
1 Ianuarie 2011, in parteneriat EXCLUSIV cu STEREO PLANET.
Renumiti pentru raportul fabulos pret - calitate pe care-l au produsele lor, americanii de la PARASOUND
ofera nu numai o gama inedita de produse ci si semnatura unuia dintre cei mai celebri designeri de
amplificatoare din lume, John Curl.
Specificatii Tehcnical Specifications
Continuous power output, 20Hz - 20 kHz:
450 watts RMS x 1, 8 Ω
850 watts RMS x 1, 4 Ω
1300 watts RMS x 1, 2 Ω

Class A power output, 20Hz - 20 kHz:
25 watts, bias set to high, 8 Ω
10 watts, bias set to low, 8 Ω

Current capacity: 135 amperes peak
Power bandwidth: 2 Hz - 120 kHz, +0/-3 dB at 1 watt
Total harmonic distortion: < 0.15 % at full power
IM distortion: balanced 16 V rms < 0.03 %
Slew rate: > 130 V/µsecond
Dynamic headroom: > 1.8 dB
Input sensitivity: 1 V for 28.28 V, THX Reference Level
Input impedance: 100 k Ω
S/N ratio:
>120 dB, IHF A-weighted, bias set to high
>122 dB, IHF A-weighted, bias set to low
Damping factor: > 1200 at 20 Hz

Power Requirement: 250 watts idle 1280 watts full power into 4 Ω
DC trigger output capacity: +12 Vdc, 150 mA

Dimensions (W x H x D): 44 x 20 x 51 cm
Weight: 38 kg

Colors: black, silver

NOTA: Pretul este per pereche.


REVIEWS

"A bargain, and highly recommended."
Michael Fremer / Stereophile

"...incredibly effortless and natural.
This amplifier certainly held me captivated and entertained, drawing me into the music.
If you want to lose yourself in the music, there are precious few components as good as the JC 1."
David Allcock / Hi-Fi News

"Before you blow $10k-$20k or more on some amps that were recommended by a reviewer who
didn't buy them, give a listen to the Parasounds, which this reviewer did purchase.
Don't buy an amp without hearing these, even if you can't afford them."
Sam Tellig - Product Of The Year / Stereophile

"Beautiful Brutes.
The JC 1s rank with the best amplifiers I have heard in recreating a multideminsional sound field.
They pump out seemingly effortless power no matter how insanely loud I push them, with never
any sense of strain such as you hear when an amplifier is running out of gas.
The JC 1s are also capable of wondrous delicacy, and the kind of transparency that makes you feel
that you're hearing every instrument, every voice, but never at the expense of the musical whole.
To be able to buy these robust, delicate, emotionally involving, brilliantly conceived and executed
music recreators for $6,000 each piece seems to me little short of a miracle."
Wayne Donnelly / EnjoytheMusic.com

"Parasound's Halo JC 1 amplifier, is among the most precisely nuanced amplifiers I know,
able to draw the slightest and most delicate of musical expressions, to make the subtlest distinctions.
It can also rock you, like your back ain't got no bone, 'cuz it's a brute.
It is the amp for all seasons.
It has the ability to produce a believable facsimile of spaciousness, that 3-D sound-staging that
makes the illusion of space between the instruments nearly tangible; the ability to produce
timbral, harmonic, and dynamic accuracy that results in what we call 'inner detail';
the ability to produce delicate refined purity of tone one moment, and then bowl you over with
A BIG WALL OF SOUND the next.
...these amps are truly outstanding, among the best I've ever heard, and the best I've had in my system."
Max Dudious / Positive Feedback

"I was impressed with the remarkable speed, clarity, transparency, and focus of these amps straight out of the box.
The high frequencies were to-die-for silky smooth, crystal clear, and abundantly detailed.
The kind you could listen to all day long without fatigue.
There wasn't anything that didn't sound great on the JC 1.
I was left with an ear-to-ear grin on my face that lasted the rest of the week.
Sue Kraft / The Absolute Sound

"...ultra-wide bandwidth, high-current capability, low, low noise, a high S/N ratio, and a fast slew rate,
among many other indicators of outstanding amplifier performance.
There was an honesty to the overall tonal and harmonic presentation that transcended
technological stereotypes.
The Halo JC 1 is not only the best amplifier to come from Parasound, it ranks up there with the
best high-end heavyweights.
Rocks for sure."
Class A Recommended Component / Stereophile

"It took but a few seconds for me to absolutely fall in love with the Halo JC 1.
Powerful, refined, smooth, organized, dynamic, transparent, and rhythmically supple, the JC 1
offered a combination of attributes that added up to many weeks of listening pleasure.
I'd be happy to have it go on indefinitely - as, no doubt, will many of you."
Michael Fremer / Stereophile
Premii
DVDPLANET STEREO PLANET
Preţ: 89,999.00 RON (TVA inclus)
Disponibilitate Intreaba / Suna
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: 76, Total time: 29.238 ms [By time] [By id] [By file]
1 (0.232)
SELECT *
FROM store
WHERE store_id = 0
/home/stereoplanet/public_html/index.php:112
2 (0.980)
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.102)
SELECT *
FROM language
WHERE status = '1'
/home/stereoplanet/public_html/index.php:203
4 (0.104)
SELECT *
FROM currency
/home/stereoplanet/public_html/system/library/currency.php:13
5 (0.159)
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.131)
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.155)
SELECT *
FROM url_alias
WHERE keyword = 'parasound'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
8 (0.128)
SELECT *
FROM url_alias
WHERE keyword = 'parasound_jc1_'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
9 (0.178)
SELECT m.*,m2s.store_id
FROM manufacturer m
LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '197' AND m2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/manufacturer.php:11
10 (0.166)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=197'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
11 (1.516)
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 = '12648' 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
12 (0.162)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=197'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
13 (0.146)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=12648'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
14 (0.143)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=12648'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
15 (0.168)
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 = '12648' 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
16 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=197'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
17 (4.658)
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 = '12648' 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
18 (4.569)
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 = '12648' 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
19 (0.163)
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
20 (1.578)
SELECT *
FROM product_image
WHERE product_id = '12648'
ORDER BY sort_order ASC
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2077
21 (0.381)
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
22 (0.195)
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
23 (0.117)
SELECT *
FROM product_discount
WHERE product_id = '12648' 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
24 (0.142)
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 = '12648' AND od.language_id = '2'
ORDER BY o.sort_order
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2018
25 (0.126)
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 = '12648' 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
26 (0.189)
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 = '12648' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2085
27 (0.112)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '12648'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:4
28 (0.091)
SELECT *
FROM product_to_layout
WHERE product_id = '12648' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
29 (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
30 (0.124)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
31 (0.487)
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
32 (0.236)
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
33 (0.114)
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
34 (0.091)
SELECT *
FROM product_to_layout
WHERE product_id = '12648' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
35 (0.118)
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
36 (0.112)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
37 (0.085)
SELECT *
FROM product_to_layout
WHERE product_id = '12648' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
38 (0.118)
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
39 (0.116)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
40 (0.085)
SELECT *
FROM product_to_layout
WHERE product_id = '12648' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
41 (0.117)
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.116)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
43 (0.116)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
44 (4.250)
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
45 (0.592)
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
46 (0.162)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
47 (0.149)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
48 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
49 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
50 (0.166)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
51 (0.176)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
52 (0.426)
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
53 (0.127)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
54 (0.510)
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
55 (0.160)
SELECT *
from url_alias
where query='information_id=23' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
56 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
57 (0.158)
SELECT *
from url_alias
where query='information_id=5' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
58 (0.145)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
59 (0.154)
SELECT *
from url_alias
where query='information_id=4' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
60 (0.151)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
61 (0.153)
SELECT *
from url_alias
where query='information_id=25' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
62 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
63 (0.166)
SELECT *
from url_alias
where query='information_id=6' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
64 (0.153)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
65 (0.150)
SELECT *
from url_alias
where query='information_id=3' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
66 (0.150)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
67 (0.147)
SELECT *
from url_alias
where query='information_id=7' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
68 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
69 (0.150)
SELECT *
from url_alias
where query='information_id=24' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
70 (0.151)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=24'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
71 (0.165)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=197'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
72 (0.146)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=12648'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
73 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=197'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
74 (0.142)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=12648'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
75 (0.106)
SELECT *
FROM extension
WHERE `type` = 'total'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
76 (0.089)
SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'
/home/stereoplanet/public_html/system/library/customer.php:201