CATEGORII
Portable Wireless Music System

KLIPSCH

Groove

Portable Wireless Music System

Unic distribuitor Premiera absoluta
1,499.00 RON (TVA inclus) Compara
Cantitate:
Stoc:DISPONIBIL
The Klipsch Groove portable Bluetooth® speaker is designed to bring big sound wherever the road takes you.
Leveraging 70 years of audio technology, this little speaker sounds bigger than any of its rivals.
Specifications
System Type: Bass-reflex via Dual Opposing Bass Radiators
Drive Components: 1 x 3” aluminum full-range high excursion
Passive Bass Radiator: 2 x side-firing
Frequency Response (Hz, +/-3dB): 65Hz - 22kHz / useable bass to 56Hz
Maximum Acoustic Output: 97dB (0.5m near field)
Power Handling (Long/Short Term): 10 W RMS

Battery Life (Default Volume): 8 hours (Internal Lithium Ion rechargable battery)

Inputs:
Bluetooth
3.5mm Analog-In
Charge-Only USB Port

Dimensions (H x W x D): 116 x 140 x 65 mm
Weight: 0.77 kg

Color: Black
Producator: Produs:
Imagine
Portable Wireless Music System
Produs KLIPSCH
Portable Wireless Music System
Groove
Descriere The Klipsch Groove portable Bluetooth® speaker is designed to bring big sound wherever the road takes you.
Leveraging 70 years of audio technology, this little speaker sounds bigger than any of its rivals.
Specificatii Specifications
System Type: Bass-reflex via Dual Opposing Bass Radiators
Drive Components: 1 x 3” aluminum full-range high excursion
Passive Bass Radiator: 2 x side-firing
Frequency Response (Hz, +/-3dB): 65Hz - 22kHz / useable bass to 56Hz
Maximum Acoustic Output: 97dB (0.5m near field)
Power Handling (Long/Short Term): 10 W RMS

Battery Life (Default Volume): 8 hours (Internal Lithium Ion rechargable battery)

Inputs:
Bluetooth
3.5mm Analog-In
Charge-Only USB Port

Dimensions (H x W x D): 116 x 140 x 65 mm
Weight: 0.77 kg

Color: Black
Premii
Preţ: 1,499.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: 74, Total time: 27.164 ms [By time] [By id] [By file]
1 (0.229)
SELECT *
FROM store
WHERE store_id = 0
/home/stereoplanet/public_html/index.php:112
2 (1.028)
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.103)
SELECT *
FROM language
WHERE status = '1'
/home/stereoplanet/public_html/index.php:203
4 (0.096)
SELECT *
FROM currency
/home/stereoplanet/public_html/system/library/currency.php:13
5 (0.145)
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.110)
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.152)
SELECT *
FROM url_alias
WHERE keyword = 'raft'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
8 (0.116)
SELECT *
FROM url_alias
WHERE keyword = 'klipsch_groove'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
9 (0.184)
SELECT DISTINCT *
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.category_id = '317' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:4
10 (0.133)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=317'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
11 (1.514)
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 = '11838' 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.149)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=317'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
13 (0.104)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11838'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
14 (0.099)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11838'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
15 (0.155)
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 = '11838' 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.160)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=283'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
17 (4.256)
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 = '11838' 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.050)
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 = '11838' 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.146)
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.584)
SELECT *
FROM product_image
WHERE product_id = '11838'
ORDER BY sort_order ASC
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2077
21 (0.112)
SELECT *
FROM product_discount
WHERE product_id = '11838' 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.117)
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 = '11838' AND od.language_id = '2'
ORDER BY o.sort_order
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2018
23 (0.212)
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 = '11838' 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.204)
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 = '11838' 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 (0.109)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '11838'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:4
26 (0.112)
SELECT *
FROM product_to_layout
WHERE product_id = '11838' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
27 (0.108)
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
28 (0.127)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
29 (0.574)
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
30 (0.260)
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
31 (0.129)
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
32 (0.079)
SELECT *
FROM product_to_layout
WHERE product_id = '11838' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
33 (0.096)
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
34 (0.115)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
35 (0.074)
SELECT *
FROM product_to_layout
WHERE product_id = '11838' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
36 (0.087)
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
37 (0.112)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
38 (0.074)
SELECT *
FROM product_to_layout
WHERE product_id = '11838' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
39 (0.086)
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
40 (0.103)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
41 (0.101)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
42 (4.314)
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
43 (0.712)
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
44 (0.174)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
45 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
46 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
47 (0.130)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
48 (0.135)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
49 (0.128)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
50 (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
51 (0.127)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
52 (0.557)
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
53 (0.171)
SELECT *
from url_alias
where query='information_id=23' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
54 (0.130)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
55 (0.124)
SELECT *
from url_alias
where query='information_id=5' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
56 (0.119)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
57 (0.133)
SELECT *
from url_alias
where query='information_id=4' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
58 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
59 (0.126)
SELECT *
from url_alias
where query='information_id=25' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
60 (0.126)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
61 (0.125)
SELECT *
from url_alias
where query='information_id=6' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
62 (0.126)
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' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
64 (0.128)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
65 (0.130)
SELECT *
from url_alias
where query='information_id=7' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
66 (0.122)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
67 (0.122)
SELECT *
from url_alias
where query='information_id=24' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
68 (0.124)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=24'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
69 (0.121)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=317'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
70 (0.094)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11838'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
71 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=317'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
72 (0.094)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11838'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
73 (0.096)
SELECT *
FROM extension
WHERE `type` = 'total'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
74 (0.091)
SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'
/home/stereoplanet/public_html/system/library/customer.php:201