Daiwa


Lanseta Spinning Daiwa Triforce Target Spoon 1.95m, 1-8g, 2seg

Lanseta Spinning Daiwa Triforce Target Spoon 1.95m, 1-8g, 2seg

d.11400.190
Livrare 24-48 ore

152,36Lei

Spin Momeala Preston Bayonets, 20buc/plic

Spin Momeala Preston Bayonets, 20buc/plic

p0030029
Livrare 7-14 zile

12,19Lei

Lanseta Spinning Daiwa Exceler Spin ST 2.10m, 2-10g, 2seg

Lanseta Spinning Daiwa Exceler Spin ST 2.10m, 2-10g, 2seg

d.11664.211
Livrare 24-48 ore

271,28Lei

Mulineta DAIWA 23 Revros LT 4000-C, 0.28mm/150m, 5.2:1, 4rul

Mulineta DAIWA 23 Revros LT 4000-C, 0.28mm/150m, 5.2:1, 4rul

d.10221.402
Livrare imediată!

360,97Lei

Cosulet Daiwa Nzon Window Feeder S, 40g, 1buc/pac

Cosulet Daiwa Nzon Window Feeder S, 40g, 1buc/pac

a3.13355.040
Livrare 24-48 ore

16,51Lei

Lanseta DAIWA Triforce Feeder 3.90m, 150g, 3+2seg -11%

Lanseta DAIWA Triforce Feeder 3.90m, 150g, 3+2seg

d.11770.395
Livrare imediată!

223,51Lei(-11%) 199,99Lei

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Yummi, 4.1cm, 6.5g, 1buc/pac

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Yummi, 4.1cm, 6.5g, 1buc/pac

f3.d15263.406
Livrare 24-48 ore

45,34Lei

Varga DAIWA Ninja X Tele Pole, 4m, 5seg -17%

Varga DAIWA Ninja X Tele Pole, 4m, 5seg

d.11629.400
Livrare 24-48 ore

132,05Lei(-17%) 109,99Lei

Fir Monofilament Daiwa J-Threads, Pink, 12.50kg, 0.405mm, 600m

Fir Monofilament Daiwa J-Threads, Pink, 12.50kg, 0.405mm, 600m

d.12225.141
Livrare imediată!

65,91Lei

Maner Minciog DAIWA Prorex Stalker Multi Adjust Tele Handle, 2.50m, 5seg

Maner Minciog DAIWA Prorex Stalker Multi Adjust Tele Handle, 2.50m, 5seg

a2.15810.250
Livrare imediată!

260,96Lei

Cosulet Daiwa Feeder N Zon Square Medium 50g

Cosulet Daiwa Feeder N Zon Square Medium 50g

a.13340.050
Livrare imediată!

15,45Lei

Mulineta DAIWA 20 Gekkabijin X LT 2000SP, 4.8:1, 0.14mm/150m, 5rul

Mulineta DAIWA 20 Gekkabijin X LT 2000SP, 4.8:1, 0.14mm/150m, 5rul

d.20gekxlt2000sp
Livrare 24-48 ore

701,58Lei

Bluza DAIWA D Old Shirt Long Sleeve 30, Light Blue, Marime 3XL

Bluza DAIWA D Old Shirt Long Sleeve 30, Light Blue, Marime 3XL

d.21lshirt30lb3xl
Livrare 24-48 ore

139,58Lei

Lanseta Spinning DAIWA Tournament AGS 802 HFS 2.44m, 14-42g, 2seg

Lanseta Spinning DAIWA Tournament AGS 802 HFS 2.44m, 14-42g, 2seg

d.tnags802hfscf
Livrare 24-48 ore

1.532,02Lei

VARF DAIWA PENTRU NINJA X FEEDER GREEN

VARF DAIWA PENTRU NINJA X FEEDER GREEN

d.11605.001g
Livrare imediată!

39,16Lei

Suport feeder Daiwa N Zon EVA Feeder 50cm

Suport feeder Daiwa N Zon EVA Feeder 50cm

a6.13309.305
Livrare imediată!

94,85Lei

LINGURITA DAIWA ROTATIVA 6G GOLD ORANGE

LINGURITA DAIWA ROTATIVA 6G GOLD ORANGE

d.07410897
Livrare 24-48 ore

22,51Lei

METHOD FEEDER DAIWA NZON METHOD 50G MAR. L

METHOD FEEDER DAIWA NZON METHOD 50G MAR. L

a3.13345.250
Livrare imediată!

23,57Lei

Lanseta Spinning Daiwa Silver Creek UL Spin 2.35m, 3-14g, 2seg

Lanseta Spinning Daiwa Silver Creek UL Spin 2.35m, 3-14g, 2seg

d.11441.235
Livrare imediată!

343,64Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.30m, 30-90g, 3seg

Lanseta Universala Daiwa Black Widow XT Bait 3.30m, 30-90g, 3seg

d.11554.331
Livrare 24-48 ore

271,28Lei

Afişare 681 - 700 din 1623 (82 pagini)
Queries: 7, Total time: 104.913 ms [By time] [By id] [By file]
1 (0.076)
SELECT data
FROM `oc_session`
WHERE session_id = '7c1a3484c3594ae0a38d5e3665'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.061)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.085)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.081)
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 (41.916)
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 (62.597)
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 680,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.097)
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