Daiwa

Daiwa

Sortare după:

Varf Quiver Lanseta DAIWA Triforce Distance Feeder QT Red 3.60m/3.90m, 120g

Varf Quiver Lanseta DAIWA Triforce Distance Feeder QT Red 3.60m/3.90m, 120g

d.11770.360r

Livrare imediată!

36,99Lei

Varga DAIWA Tele Aqualite Alborella, 3.5m, 4seg

Varga DAIWA Tele Aqualite Alborella, 3.5m, 4seg

d.aqlalb35cf

Livrare imediată!

157,66Lei

LINGURITA DAIWA ROTATIVA 6G GOLD ORANGE

LINGURITA DAIWA ROTATIVA 6G GOLD ORANGE

d.07410897

Livrare 24-48 ore

23,52Lei

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS 2SEG

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS 2SEG

d.11584.360

Livrare 24-48 ore

265,78Lei(-18%) 217,20Lei

Mulineta Daiwa Crossfire LT 4000-C 4BS A

Mulineta Daiwa Crossfire LT 4000-C 4BS A

d.10186.400

Livrare 24-48 ore

314,33Lei(-18%) 259,25Lei

Lanseta Spinning Daiwa MF Travel Spin 2.25, 5-25, 4seg

Lanseta Spinning Daiwa MF Travel Spin 2.25, 5-25, 4seg

d.11253.225

Livrare 24-48 ore

242,01Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.30m, 20-60g, 3seg

Lanseta Universala Daiwa Black Widow XT Bait 3.30m, 20-60g, 3seg

d.11554.330

Livrare 24-48 ore

268,77Lei

Lanseta Daiwa N‘Zon Extension Feeder 3.65m, 80g, 2+2seg

Lanseta Daiwa N‘Zon Extension Feeder 3.65m, 80g, 2+2seg

d.11333.360

Livrare imediată!

467,89Lei(-20%) 374,07Lei

Lanseta Daiwa N Zon Super Slim Method Feeder 3.35m, 60g, 2+2seg

Lanseta Daiwa N Zon Super Slim Method Feeder 3.35m, 60g, 2+2seg

d.11160.330

Livrare imediată!

388,17Lei

Lanseta Daiwa Tournament Feeder 3.60m, 50g, 3+3seg

Lanseta Daiwa Tournament Feeder 3.60m, 50g, 3+3seg

d.tnsf12q.au

Livrare 24-48 ore

3.172,79Lei

Mulineta Daiwa MATCHMAN 4000, 0.33mm/250m, 5.3:1, 3rul

Mulineta Daiwa MATCHMAN 4000, 0.33mm/250m, 5.3:1, 3rul

d.10113.400

Livrare 24-48 ore

314,00Lei

Lanseta Daiwa Ninja X Feeder 3.60m, 120g, 3+3seg

Lanseta Daiwa Ninja X Feeder 3.60m, 120g, 3+3seg

d.11608.360

Livrare 24-48 ore

322,39Lei

Lanseta DAIWA Ninja X Stalker Feeder 11610, 3.60m, 80g, 3+3seg

Lanseta DAIWA Ninja X Stalker Feeder 11610, 3.60m, 80g, 3+3seg

d.11610.361

Livrare 24-48 ore

300,26Lei

Lanseta Daiwa Megaforce Boat 24MH ST 2.40m, 50-150g, 2seg

Lanseta Daiwa Megaforce Boat 24MH ST 2.40m, 50-150g, 2seg

d.mfb24mhcf

Livrare 24-48 ore

172,88Lei

Mulineta Daiwa 24 TDR 2508QD, 4.8:1, 0.23mm/150m, 8+1rul

Mulineta Daiwa 24 TDR 2508QD, 4.8:1, 0.23mm/150m, 8+1rul

d.10516.258

Livrare 24-48 ore

1.396,35Lei

Montura DAIWA PX Screw-In Shallow Rig Nr.3/0+2/0

Montura DAIWA PX Screw-In Shallow Rig Nr.3/0+2/0

a.15419.730

Livrare 24-48 ore

28,50Lei

Mulineta DAIWA Vertice35-5000C, 4.1:1, 0.35mm/300m, 5rul

Mulineta DAIWA Vertice35-5000C, 4.1:1, 0.35mm/300m, 5rul

d.10131.501

Livrare imediată!

646,29Lei(-10%) 582,66Lei

Costum DAIWA D-Vec Winter, Marime XXL

Costum DAIWA D-Vec Winter, Marime XXL

d.18868.040

Livrare 24-48 ore

1.063,74Lei

Shad DAIWA Prorex Belly, White Ghost, 11cm, 12g, 4buc/pac

Shad DAIWA Prorex Belly, White Ghost, 11cm, 12g, 4buc/pac

d.15320.307

Livrare 24-48 ore

31,36Lei

Lanseta Somn DAIWA Megaforce Catfish Spin, 180g, 2.70m, 2seg

Lanseta Somn DAIWA Megaforce Catfish Spin, 180g, 2.70m, 2seg

d.11255.275

Livrare 24-48 ore

201,15Lei

Afişare 721 - 740 din 1664 (84 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 7, Total time: 99.192 ms [By time] [By id] [By file]

1 (0.100)

SELECT data
FROM `oc_session`
WHERE session_id = '61e75d9cfab2a8b25647182b13'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.068)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.086)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.084)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '11' AND m2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (40.316)

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 = '11'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (58.388)

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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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 = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 720,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.150)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37