Baracuda


Lanseta Telescopica Baracuda Zippy 3.00m, 80-120g

Lanseta Telescopica Baracuda Zippy 3.00m, 80-120g

zippy 300
Livrare imediată!

151,90Lei

Juvelnic Baracuda N03-ECO 70x45cm -19%

Juvelnic Baracuda N03-ECO 70x45cm

juvelnic n03 eco
Livrare imediată!

20,90Lei(-19%) 16,90Lei

Minciog Baracuda LTR 210X70CM

Minciog Baracuda LTR 210X70CM

minciog ltr
Livrare imediată!

73,60Lei

Penar monturi Baracuda TW 30x14cm

Penar monturi Baracuda TW 30x14cm

penar tw pt. monturi crap
Livrare imediată!

67,90Lei

Lingurita, Oscilanta, B19, Baracuda, 16g, 8.8cm, Silver, b19, Linguri Oscilante, Linguri Oscilante Baracuda, Baracuda
Lanseta Telescopica Baracuda Seabig 2.7m A80 g 4seg

Lanseta Telescopica Baracuda Seabig 2.7m A80 g 4seg

lansete mix carbon 2.7m
Livrare imediată!

78,90Lei

Lingurita, Oscilanta, Baracuda, SF04-167,, 21g,, 7.2cm, sf04-167, Linguri Oscilante, Linguri Oscilante Baracuda, Linguri Baracuda, Oscilante Baracuda, Baracuda
Husa lansete Baracuda B10 125Cm 3 compartimente

Husa lansete Baracuda B10 125Cm 3 compartimente

b10 - geanta
Livrare imediată!

78,06Lei

HUSA, LANSETE, Baracuda, B9, NC, 90CM, 3, compartimente, camuflaj, b9 - geanta, Huse Lansete cu Mulinete, Huse Lansete cu Mulinete Baracuda, Baracuda
Crasnic Baracuda KX 017 din plasa deasa 100 x 100cm

Crasnic Baracuda KX 017 din plasa deasa 100 x 100cm

crasnic kx017
Livrare imediată!

24,20Lei

Lanseta Baracuda Danube Spin model.2702 2.70m 100-200g 2seg

Lanseta Baracuda Danube Spin model.2702 2.70m 100-200g 2seg

danube 2702
Livrare imediată!

174,13Lei

Set Swinger Baracuda YL-06-4 4buc/set

Set Swinger Baracuda YL-06-4 4buc/set

set 4 swinger yl-06
Livrare imediată!

196,29Lei

Swinger Baracuda SW20 multicolor

Swinger Baracuda SW20 multicolor

swinger sw20
Livrare imediată!

71,19Lei

Mulineta Baracuda YUMOSHI BY1000 5R

Mulineta Baracuda YUMOSHI BY1000 5R

yumoshi by-1000
Livrare imediată!

85,89Lei

Lanseta, spinning, Baracuda, Predator, XP, 2102, 12-40g, 2seg, predator xp 2102, Lansete Rapitori, Lansete Rapitori Baracuda, Baracuda
Minciog crap Baracuda 2.15m AJX-KO60213

Minciog crap Baracuda 2.15m AJX-KO60213

minciog ajx-ko60213
Livrare imediată!

134,90Lei

Lanseta Telescopica Baracuda Ozzy 3.60m 3.5lb

Lanseta Telescopica Baracuda Ozzy 3.60m 3.5lb

ozzy tele carp 360.
Livrare imediată!

187,90Lei

Lingurita, Oscilanta, B07, Baracuda, 6g, 4.9cm, Silver, b07, Linguri Oscilante, Linguri Oscilante Baracuda, Baracuda
Lingurita, Oscilanta, B39, Baracuda, 13g, 6.2cm, , b39, Linguri Oscilante, Linguri Oscilante Baracuda, Baracuda
Set Agrafe Maxi Baracuda pentru Pastrarea Pestelui Viu 5buc

Set Agrafe Maxi Baracuda pentru Pastrarea Pestelui Viu 5buc

set agrafe maxi pentru pastrarea pestelui viu
Livrare imediată!

22,90Lei

Afişare 141 - 160 din 494 (25 pagini)
Queries: 7, Total time: 62.267 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '379c74f000cf74c492b56b1864'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.129)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.120)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (28.074)
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 = '2' AND p.manufacturer_id = '280'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (33.623)
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 = '2' AND p.manufacturer_id = '280' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.121)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38