Daiwa


Carlige Legate Daiwa Tournament Feeder Nr.12, 10buc/pac

Carlige Legate Daiwa Tournament Feeder Nr.12, 10buc/pac

a.14455.012
Livrare 24-48 ore

23,44Lei

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.80m, 1-6g, 2seg

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.80m, 1-6g, 2seg

d.11440.180
Livrare imediată!

328,08Lei

Lanseta Daiwa N Zon Super Slim Power Feeder 3.96m, 150g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Feeder 3.96m, 150g, 3+2seg

d.11161.390
Livrare imediată!

598,65Lei

Mulineta Daiwa Legalis LT2500(U), 0.20mm/150m, 5.3:1, 5rul

Mulineta Daiwa Legalis LT2500(U), 0.20mm/150m, 5.3:1, 5rul

d.10435.251
Livrare imediată!

536,12Lei

Fir Textil DAIWA N'Zone 8X Braid Steel Gray, 0.08mm, 5.00kg, 150m

Fir Textil DAIWA N'Zone 8X Braid Steel Gray, 0.08mm, 5.00kg, 150m

d.12410.108
Livrare 24-48 ore

72,23Lei

MULINETA DAIWA EMBLEM SURF35 SCW QD -16%

MULINETA DAIWA EMBLEM SURF35 SCW QD

d.10158.650
Livrare imediată!

843,12Lei(-16%) 710,20Lei

LANSETA DAIWA NINJA X SPINNING SF 2.45M/8-35G 2SEG

LANSETA DAIWA NINJA X SPINNING SF 2.45M/8-35G 2SEG

d.11207.241
Livrare imediată!

297,19Lei

Cosulet Daiwa Feeder N Zon Distance Medium 50g

Cosulet Daiwa Feeder N Zon Distance Medium 50g

a.13331.050
Livrare imediată!

15,71Lei

Husa Daiwa Prorez Rod Bag 127x8cm

Husa Daiwa Prorez Rod Bag 127x8cm

d.15810.240
Livrare imediată!

98,25Lei

Momitor, Feeder, Daiwa, Feeder, N, Zon, M, 20g, a.13321.020, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

Momitor, Feeder, Daiwa, Feeder, N, Zon, M, 20g, a.13321.020, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

a.13321.020
Livrare imediată!

13,10Lei

DEGORJOR DAIWA NZON -30%

DEGORJOR DAIWA NZON

a.13319.000
Livrare imediată!

4,26Lei(-30%) 2,98Lei

Nada Daiwa Advantage Allround Black 1kg

Nada Daiwa Advantage Allround Black 1kg

a0.13300.006
Livrare 24-48 ore

36,99Lei

LANSETA SPINNING DAIWA TOURNAMENT AGS JIGGER 2.40M 7-28G 2SEG

LANSETA SPINNING DAIWA TOURNAMENT AGS JIGGER 2.40M 7-28G 2SEG

d.11117.240
Livrare 24-48 ore

2.284,48Lei

Tambur de Rezerva Universal Daiwa Mulineta LT 6000D -23%

Tambur de Rezerva Universal Daiwa Mulineta LT 6000D

d.19115.600
Livrare imediată!

138,61Lei(-23%) 106,90Lei

Lanseta Daiwa N Zon Extension Feeder 3.96m, 120g, 2+2seg -23%

Lanseta Daiwa N Zon Extension Feeder 3.96m, 120g, 2+2seg

d.11333.390
Livrare imediată!

557,21Lei(-23%) 428,90Lei

Lanseta Daiwa BG Offshore Pilk 2.10m, 40-125g, 2seg

Lanseta Daiwa BG Offshore Pilk 2.10m, 40-125g, 2seg

d.11928.210
Livrare 24-48 ore

400,13Lei

Multiplicator Daiwa Tatula SV TW 70MHL 8.1:1, 0.26mm-80m, 7rul

Multiplicator Daiwa Tatula SV TW 70MHL 8.1:1, 0.26mm-80m, 7rul

d.10714.071
Livrare 24-48 ore

1.321,07Lei

Fir Fluorocarbon Daiwa Saltiga FC Leader X Link 0.33mm, 16lbs, 30m

Fir Fluorocarbon Daiwa Saltiga FC Leader X Link 0.33mm, 16lbs, 30m

d.12956.533
Livrare imediată!

89,62Lei

Mulineta Daiwa Exceler LT3000-C, 0.23mm/150m, 5.3:1, 5rul -17%

Mulineta Daiwa Exceler LT3000-C, 0.23mm/150m, 5.3:1, 5rul

d.10336.300
Livrare 24-48 ore

601,12Lei(-17%) 499,40Lei

Mulineta, Daiwa, Emblem, Surf, 45, SCW, QD, Type, R, 0.18mm/300m,, 4.9:1,, 6+1rul, d.ems2345scwqdr, Mulinete Crap, Mulinete Crap Daiwa, Mulinete Daiwa, Crap Daiwa, Daiwa
Afişare 21 - 40 din 1480 (74 pagini)
Queries: 7, Total time: 158.242 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '7c002c231d2ea1a532b2f96b35'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.122)
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 (72.447)
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:1667
6 (85.209)
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 = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 20,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.086)
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