Baracuda


Lingurita Oscilanta Baracuda SF04-49, 10cm, 10.5g

Lingurita Oscilanta Baracuda SF04-49, 10cm, 10.5g

sf 04-49
Livrare imediată!

7,50Lei

Coada Minciog Telescopica Baracuda L1 3m

Coada Minciog Telescopica Baracuda L1 3m

coadatelescopical1-3m
Livrare imediată!

59,04Lei

Geanta Baracuda B34 accesorii

Geanta Baracuda B34 accesorii

b34 geanta
Livrare imediată!

173,26Lei

Cutie Baracuda G011 momeala vie 133x133x50mm albastru alb

Cutie Baracuda G011 momeala vie 133x133x50mm albastru alb

cutie g011
Livrare imediată!

5,00Lei

Lanseta, Baracuda, Evolution, Feeder, 3903, 3.90M, 120g, 3seg, evolution feeder 3903, Lansete Feeder, Lansete Feeder Baracuda, Baracuda
Husa lansete Baracuda C2-T 4 compartimente 208cm

Husa lansete Baracuda C2-T 4 compartimente 208cm

c2 - t
Livrare imediată!

379,90Lei

Lanseta, spinning, Baracuda, Spark, GS, 1.95M, 1-5g, 2SEG, spark gs19502, Lansete Rapitori, Lansete Rapitori Baracuda, Baracuda
Lanseta, spinning, Baracuda, Vow, 1.80M, 2-7g, 2SEG, vow 1802, Lansete Rapitori, Lansete Rapitori Baracuda, Baracuda
SCAUN PAT BARACUDA HYB010C-AL verde reglabil

SCAUN PAT BARACUDA HYB010C-AL verde reglabil

scaun pat hyb010c-al
Livrare imediată!

714,90Lei

Juvelnic Baracuda N13 ECO 100X32-40cm

Juvelnic Baracuda N13 ECO 100X32-40cm

juvelnic n13
Livrare imediată!

89,15Lei

Mulineta Baracuda Black Monster 90 8R

Mulineta Baracuda Black Monster 90 8R

black monster 90
Livrare imediată!

233,06Lei

Mulineta Baracuda Scorpion J3 5000 FR -15%

Mulineta Baracuda Scorpion J3 5000 FR

scorpion j3-5000fr
Livrare imediată!

103,18Lei(-15%) 87,91Lei

Lingurita Oscilanta B11 Baracuda 10g 7cm Silver

Lingurita Oscilanta B11 Baracuda 10g 7cm Silver

b11
Livrare imediată!

6,90Lei

Geanta lansete Baracuda B18 3 compartimente 160cm

Geanta lansete Baracuda B18 3 compartimente 160cm

b18 - geanta lans.3 comp. l 1.6m verde
Livrare imediată!

131,90Lei

Husa lansete Baracuda B12 160Cm 3 compartimente

Husa lansete Baracuda B12 160Cm 3 compartimente

b12 - geanta
Livrare imediată!

93,90Lei

Mulineta Baracuda Bullet 40

Mulineta Baracuda Bullet 40

bullet 40
Livrare imediată!

69,00Lei

Cutie Baracuda A015 accesorii 440x250x180mm

Cutie Baracuda A015 accesorii 440x250x180mm

cutie a015
Livrare imediată!

183,90Lei

Mulineta Baracuda Darcy JX2000

Mulineta Baracuda Darcy JX2000

darcy jx2000
Livrare imediată!

81,65Lei

Lanseta, Baracuda, Green, Arrow, 1.96M, 2-8g, 2SEG, green arrow 19602, Lansete Rapitori, Lansete Rapitori Baracuda, Baracuda
Lanseta, feeder, Baracuda, Thunder, Feeder, 3.60m, 90g, 3seg, thunder 3603, Lansete Feeder, Lansete Feeder Baracuda, Baracuda
Afişare 41 - 60 din 495 (25 pagini)
Queries: 9, Total time: 62.247 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '3fcc570fca3dc46d131c774c44'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
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.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.134)
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.371)
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:1661
7 (34.086)
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:438
8 (0.111)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.094)
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