Baracuda


Juvelnic Baracuda 3810 diametru 38cm

Juvelnic Baracuda 3810 diametru 38cm

juvelnic sarma circular 38cm
Livrare imediată!

36,34Lei

Mulineta Baracuda Black Widow 80

Mulineta Baracuda Black Widow 80

black widow 80
Livrare imediată!

190,90Lei

SUPORT UMBRELA BARACUDA

SUPORT UMBRELA BARACUDA

suport metalic pentru umbrela shelter
Livrare imediată!

43,90Lei

Lingurita, Oscilanta, B26, Baracuda, 21g, 6.1cm, , , b26, Linguri Oscilante, Linguri Oscilante Baracuda, Baracuda
Mulineta Baracuda YUMOSHI BK7000

Mulineta Baracuda YUMOSHI BK7000

yumoshi bk7000
Livrare imediată!

71,90Lei

Taparine Sabiki 02

Taparine Sabiki 02

sabiki taparine2
Livrare imediată!

6,90Lei

Cutie, Baracuda, HS008, accesorii, 132x62x25mm, cutie hs008, Cutii, Cutii Baracuda, Baracuda

Cutie, Baracuda, HS008, accesorii, 132x62x25mm, cutie hs008, Cutii, Cutii Baracuda, Baracuda

cutie hs008
Livrare imediată!

6,00Lei

Lanseta, Baracuda, Expert, Spin, 2102, 2.10m, 5-20g, 2seg, expert spin 2102, Lansete Rapitori, Lansete Rapitori Baracuda, Baracuda
HUSA IMPERMEABILA BARACUDA HYA 036 PENTRU PAT PLIANT

HUSA IMPERMEABILA BARACUDA HYA 036 PENTRU PAT PLIANT

husa impermeabila pentru pat pliant hya036
Livrare imediată!

73,90Lei

Lanseta, telescopica, Baracuda, Storm, 3.90m,, 150-250g,, 5seg, storm 3905, Lansete Universale, Lansete Universale Baracuda, Baracuda
Mulineta Baracuda YUMOSHI MF6000 3R

Mulineta Baracuda YUMOSHI MF6000 3R

yumoshi mf6000
Livrare imediată!

77,90Lei

Pat pliant Baracuda HYB018 ECO 203x81cm

Pat pliant Baracuda HYB018 ECO 203x81cm

pat pliant hyb018-eco
Livrare imediată!

1.051,90Lei

Minciog Baracuda 2.00M KW003

Minciog Baracuda 2.00M KW003

minciog kw003
Livrare imediată!

65,90Lei

Cleste Baracuda Albastru 12.5cm

Cleste Baracuda Albastru 12.5cm

patent pescar
Livrare imediată!

24,89Lei

Lingurita, Oscilanta, B13, Baracuda, 15g, 7.2cm, Silver, b13, Linguri Oscilante, Linguri Oscilante Baracuda, Baracuda
Lanseta, Baracuda, Passion, Power, 2.70M, 100-180g, 2SEG, passion power 2702-180g, Lansete Universale, Lansete Universale Baracuda, Lansete Rapitori, Lansete Rapitori Baracuda, Baracuda
Umbrela Baracuda Sheleter U5 250cm

Umbrela Baracuda Sheleter U5 250cm

shelteru5
Livrare imediată!

385,91Lei

Rucsac Baracuda B17 50 Litri

Rucsac Baracuda B17 50 Litri

b17-rucsac 50l
Livrare imediată!

72,69Lei

Caciula Baracuda DM641-B

Caciula Baracuda DM641-B

caciula dm641-b
Livrare imediată!

30,96Lei

Cutie, Baracuda, Carp, Box, 006, verde, 340x160x60mm, cutie carp box 006, Penare / Portofele, Penare / Portofele Baracuda, Baracuda
Afişare 41 - 60 din 495 (25 pagini)
Queries: 9, Total time: 62.708 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '78024238bc9240f5fc2a47a073'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.124)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '280' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (27.121)
SELECT COUNT(1) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '280'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1650
7 (34.774)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_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 oc_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, p.viewed, p.price
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '280' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38