CATEGORII
Boxe High-End 2 cai

hORNS

ARIA III MK2

Boxe High-End 2 cai

MADE IN POLAND BEST BUY
24,999.00 RON (TVA inclus) Compara
Cantitate:
Stoc:DISPONIBIL
hORNS - Gaseste sunetul sufletului tau.

Un motto elocvent al spectaculosului producator de boxe cu un sunet unic
si un design atipic, inconfundabil.

O imbinare extrem de reusita intre sunet, design si finish boxele hORNS vor
iesi in evidenta ca nicio alta boxa, in sistemul de acasa.

Un sunet rafinat, aproape de naturaletea instrumentelor si vocilor umane reproduse live,
completat de o adevarata opera de arta desavarsita prin folosirea unor materiale de o
extraordinara calitate prelucrate manual cu atentie.

Din 1 Martie 2022, parte din familia STEREO PLANET.

Specifications
Ways: 2
Woofer / Midwoofer: 1 x 8” coated paper
High range: 1 x 1” annular diaphragm Alu

Box: 47 litre, bassreflex

Crossover: 12dB per octave, extracted, high quality

Sensitivity: 86 dB
Frequency range: 35 - 23.000 Hz
Impedance: 8 Ohm

Terminal: Single wire, WBT

Dimensions (with horns): 300 x 1200 x 360 mm
Weight: 38 kg

Colors: Black / Dark White (Horn), Natural Veneer, RAL Colors (Special Order)
Producator: Produs:
Imagine
Boxe High-End 2 cai
Produs hORNS
Boxe High-End 2 cai
ARIA III MK2
Descriere hORNS - Gaseste sunetul sufletului tau.

Un motto elocvent al spectaculosului producator de boxe cu un sunet unic
si un design atipic, inconfundabil.
Specificatii Specifications
Ways: 2 Woofer / Midwoofer: 1 x 8” coated paper High range: 1 x 1” annular diaphragm Alu

Box: 47 litre, bassreflex
Crossover: 12dB per octave, extracted, high quality
Sensitivity: 86 dB Frequency range: 35 - 23.000 Hz Impedance: 8 Ohm

Terminal: Single wire, WBT

Dimensions (with horns): 300 x 1200 x 360 mm Weight: 38 kg

Colors: Black / Dark White (Horn), Natural Veneer, RAL Colors (Special Order)
Premii
STEREO
Preţ: 24,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: 72, Total time: 27.244 ms [By time] [By id] [By file]
1 (0.245)
SELECT *
FROM store
WHERE store_id = 0
/home/stereoplanet/public_html/index.php:112
2 (1.012)
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.104)
SELECT *
FROM language
WHERE status = '1'
/home/stereoplanet/public_html/index.php:203
4 (0.102)
SELECT *
FROM currency
/home/stereoplanet/public_html/system/library/currency.php:13
5 (0.155)
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.139)
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.196)
SELECT *
FROM url_alias
WHERE keyword = 'horns_aria_iii_mk2'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
8 (1.507)
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 = '14903' 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.144)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=14903'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
10 (0.135)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=14903'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
11 (0.154)
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 = '14903' 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.127)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=386'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
13 (3.986)
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 = '14903' 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 (3.837)
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 = '14903' 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 (1.444)
SELECT *
FROM product_image
WHERE product_id = '14903'
ORDER BY sort_order ASC
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2077
16 (0.130)
SELECT *
FROM product_discount
WHERE product_id = '14903' 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
17 (0.233)
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 = '14903' AND od.language_id = '2'
ORDER BY o.sort_order
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2018
18 (0.249)
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 = '14903' 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
19 (0.212)
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 = '14903' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2085
20 (0.124)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '14903'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:4
21 (0.137)
SELECT *
FROM `product_to_category`
WHERE `product_id` = 14903 limit 1
/home/stereoplanet/public_html/catalog/model/catalog/product.php:70
22 (0.192)
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
23 (0.177)
Select *
from url_alias
where `query` in ('category_id=67')
/home/stereoplanet/public_html/catalog/model/catalog/product.php:88
24 (0.124)
SELECT *
FROM product_to_layout
WHERE product_id = '14903' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
25 (0.165)
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
26 (0.160)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
27 (0.492)
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
28 (0.296)
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
29 (0.136)
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
30 (0.085)
SELECT *
FROM product_to_layout
WHERE product_id = '14903' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
31 (0.115)
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
32 (0.110)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
33 (0.097)
SELECT *
FROM product_to_layout
WHERE product_id = '14903' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
34 (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
35 (0.112)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
36 (0.080)
SELECT *
FROM product_to_layout
WHERE product_id = '14903' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
37 (0.111)
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
38 (0.123)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
39 (0.109)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
40 (4.038)
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
41 (0.661)
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
42 (0.160)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
43 (0.151)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
44 (0.157)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
45 (0.161)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
46 (0.153)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
47 (0.156)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
48 (0.440)
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
49 (0.115)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
50 (0.545)
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
51 (0.163)
SELECT *
from url_alias
where query='information_id=23' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
52 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
53 (0.156)
SELECT *
from url_alias
where query='information_id=12' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
54 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=12'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
55 (0.159)
SELECT *
from url_alias
where query='information_id=5' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
56 (0.149)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
57 (0.153)
SELECT *
from url_alias
where query='information_id=4' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
58 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
59 (0.153)
SELECT *
from url_alias
where query='information_id=25' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
60 (0.156)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
61 (0.163)
SELECT *
from url_alias
where query='information_id=6' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
62 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
63 (0.168)
SELECT *
from url_alias
where query='information_id=3' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
64 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
65 (0.150)
SELECT *
from url_alias
where query='information_id=7' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
66 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
67 (0.163)
SELECT *
from url_alias
where query='information_id=24' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
68 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=24'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
69 (0.142)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=14903'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
70 (0.140)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=14903'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
71 (0.108)
SELECT *
FROM extension
WHERE `type` = 'total'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
72 (0.126)
SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'
/home/stereoplanet/public_html/system/library/customer.php:201