Daiwa


Mulineta DAIWA 24 Regal LT 2500D-XH, 6.2:1, 0.28mm/150m, 6rul

Mulineta DAIWA 24 Regal LT 2500D-XH, 6.2:1, 0.28mm/150m, 6rul

d.10116.257
Livrare imediată!

480,95Lei

Costum DAIWA D-Vec Winter, Marime M

Costum DAIWA D-Vec Winter, Marime M

d.18868.010
Livrare 24-48 ore

1.063,74Lei

Shad DAIWA Prorex Belly, Natural Green Roach, 8.5cm, 4g, 4buc/pac

Shad DAIWA Prorex Belly, Natural Green Roach, 8.5cm, 4g, 4buc/pac

d.15320.219
Livrare 24-48 ore

33,77Lei

Vobler DAIWA Prorex Swift Crank Floating, Black Gold, 7cm, 12.9g, 1buc/pac

Vobler DAIWA Prorex Swift Crank Floating, Black Gold, 7cm, 12.9g, 1buc/pac

f3.d15264.707
Livrare 24-48 ore

53,03Lei

Shad DAIWA Prorex V-Marley Pelagic Live, Firetiger, 80g, 21cm, 1buc/pac

Shad DAIWA Prorex V-Marley Pelagic Live, Firetiger, 80g, 21cm, 1buc/pac

d.15227.001
Livrare 24-48 ore

56,81Lei

Fir DAIWA Tournament SF, Grey, 300m, 0.16mm, 2.3kg

Fir DAIWA Tournament SF, Grey, 300m, 0.16mm, 2.3kg

d.12205.316
Livrare imediată!

33,89Lei

MULINETA DAIWA RX LT 1000

MULINETA DAIWA RX LT 1000

d.10423.101
Livrare imediată!

219,92Lei

Bluza DAIWA D Old Shirt Long Sleeve 30, Dark Gray, Marime L

Bluza DAIWA D Old Shirt Long Sleeve 30, Dark Gray, Marime L

d.21lshirt30dgl
Livrare 24-48 ore

147,18Lei

Lanseta Spinning DAIWA Morethan Branzino Expert AGS 802 HFS 2.24m, 14-42g, 2seg

Lanseta Spinning DAIWA Morethan Branzino Expert AGS 802 HFS 2.24m, 14-42g, 2seg

d.mtbrexags802hfscf
Livrare 24-48 ore

4.142,62Lei

Varf Quiver Lanseta DAIWA Triforce Distance Feeder QT Red 3.00m, 60g

Varf Quiver Lanseta DAIWA Triforce Distance Feeder QT Red 3.00m, 60g

d.11770.300r
Livrare 24-48 ore

37,36Lei

Fir Monofilament DAIWA Tournament SF, Grey, 300m, 0.20mm, 3.5kg

Fir Monofilament DAIWA Tournament SF, Grey, 300m, 0.20mm, 3.5kg

d.12205.320
Livrare 24-48 ore

30,60Lei

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.36mm 11.10kg

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.36mm 11.10kg

d.12200.336
Livrare 24-48 ore

38,45Lei

LINGURITA DAIWA ROTATIVA 3G GOLD RED BLACK

LINGURITA DAIWA ROTATIVA 3G GOLD RED BLACK

d.07410882
Livrare 24-48 ore

20,24Lei

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

Tambur de Rezerva Universal Daiwa Mulineta LT 6000D

d.19115.600
Livrare imediată!

141,18Lei(-28%) 101,49Lei

Lanseta Spinning Daiwa Seepfire UL Spin 2.10m, 5-10g, 2seg

Lanseta Spinning Daiwa Seepfire UL Spin 2.10m, 5-10g, 2seg

d.11445.210
Livrare 24-48 ore

160,78Lei

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.66m, 180g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.66m, 180g, 3+2seg

d.11164.360
Livrare imediată!

523,11Lei

Pantaloni Daiwa Joggers Camo, Marime XL

Pantaloni Daiwa Joggers Camo, Marime XL

d.18865.540
Livrare imediată!

253,59Lei

Mulineta Daiwa Exceler LT2000D, 0.23mm/150m, 5.2:1, 5rul -8%

Mulineta Daiwa Exceler LT2000D, 0.23mm/150m, 5.2:1, 5rul

d.10336.200
Livrare 24-48 ore

554,62Lei(-8%) 508,54Lei

Lanseta Spinning Daiwa Wilderness ST 2.00m, 5-12g, 2seg

Lanseta Spinning Daiwa Wilderness ST 2.00m, 5-12g, 2seg

d.11873.205
Livrare imediată!

489,26Lei

Lanseta Daiwa N'Zon Distance Special Power Feeder 3.96m, 150g, 3+3seg

Lanseta Daiwa N'Zon Distance Special Power Feeder 3.96m, 150g, 3+3seg

d.11172.390
Livrare imediată!

1.301,02Lei

Afişare 121 - 140 din 1583 (80 pagini)
Queries: 7, Total time: 128.507 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = 'e60b8783522983f313540aaeaa'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.115)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (62.902)
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 = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (65.018)
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 = '0' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.163)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37