Daiwa


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ă!

415,91Lei

Mulineta Daiwa 20 Luvias FC LT 2000S, 5.1:1, 0.14mm/150m, 9rul

Mulineta Daiwa 20 Luvias FC LT 2000S, 5.1:1, 0.14mm/150m, 9rul

d.10211.201
Livrare 24-48 ore

2.520,55Lei

Mulineta Daiwa QC 750, 0.16mm/100m, 5.1:1, 1rul

Mulineta Daiwa QC 750, 0.16mm/100m, 5.1:1, 1rul

d.10431.175
Livrare imediată!

163,55Lei

Penar pentru Oscilante Daiwa Presso Black, 17x23x4cm

Penar pentru Oscilante Daiwa Presso Black, 17x23x4cm

d.15900.002
Livrare 24-48 ore

208,42Lei

Lanseta Spinning Daiwa Crossfire 210M 2.10m, 5-21g, 2seg

Lanseta Spinning Daiwa Crossfire 210M 2.10m, 5-21g, 2seg

d.cf210maf
Livrare 24-48 ore

176,32Lei

Mulineta Daiwa Caldia SW 4000D-CXH, 6.2:1, 0.37mm/150m, 6rul

Mulineta Daiwa Caldia SW 4000D-CXH, 6.2:1, 0.37mm/150m, 6rul

d.10320.405
Livrare 24-48 ore

1.479,09Lei

LANSETA, CASTING, DAIWA, 2SEG, TATULA, BAITCAST, 2.15M, 8-35G, d.11460.210, Lansete Casting, Lansete Casting Daiwa, Lansete Daiwa, Casting Daiwa, Daiwa
Lanseta Feeder Daiwa N Zon Z Power Feeder 3.60m 150g

Lanseta Feeder Daiwa N Zon Z Power Feeder 3.60m 150g

d.11138.366
Livrare 24-48 ore

1.268,84Lei

Fir Daiwa Tournament SF Green 0.16mm 300m 2.3kg

Fir Daiwa Tournament SF Green 0.16mm 300m 2.3kg

d.12200.316
Livrare imediată!

32,34Lei

TAMBUR DAIWA MULINETA NINJA LT 6000

TAMBUR DAIWA MULINETA NINJA LT 6000

d.19219.600
Livrare imediată!

121,37Lei

Set borsete Daiwa IS EVA Small Accessory Pouch Set - Small

Set borsete Daiwa IS EVA Small Accessory Pouch Set - Small

d.18850.010
Livrare imediată!

190,55Lei

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G LIME CHART

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G LIME CHART

f3.d16711.203
Livrare 24-48 ore

73,34Lei

LINGURITA, DAIWA, ROTATIVA, 6G, GOLD, METAL, d.07411557, Lingurite Rotative, Lingurite Rotative Daiwa, Daiwa
LANSETA DAIWA VERTICE CARP 3,60M 3,5LBS 2seg -20%

LANSETA DAIWA VERTICE CARP 3,60M 3,5LBS 2seg

d.11598.365
Livrare 24-48 ore

462,41Lei(-20%) 369,94Lei

BLUZA, DAIWA, D-VEC, LS, BLACK, MARIME, M, d.18206.220, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa -20%

BLUZA, DAIWA, D-VEC, LS, BLACK, MARIME, M, d.18206.220, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa

d.18206.220
Livrare 24-48 ore

200,79Lei(-20%) 160,63Lei

METHOD, FEEDER, DAIWA, , NZON, METHOD, 20G, MAR., S, , a3.13345.020, Momitoare Method Feeder, Momitoare Method Feeder Daiwa, Momitoare Daiwa, Method Daiwa, Feeder Daiwa, Daiwa
MINCIOG DAIWA INFINITY LNH 1.80M 105X105CM 2seg -20%

MINCIOG DAIWA INFINITY LNH 1.80M 105X105CM 2seg

a2.m11990.185
Livrare imediată!

676,85Lei(-20%) 544,56Lei

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.90m, 0.5-5g, 2seg

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.90m, 0.5-5g, 2seg

d.11440.190
Livrare 24-48 ore

237,00Lei

Lanseta Spinning Daiwa Tele Sweepfire 3.00m, 40-90g, 6seg

Lanseta Spinning Daiwa Tele Sweepfire 3.00m, 40-90g, 6seg

d.11421.302
Livrare imediată!

273,35Lei

Lanseta Daiwa Procaster Allround 3.00m, 40-110g, 3seg

Lanseta Daiwa Procaster Allround 3.00m, 40-110g, 3seg

d.11643.300
Livrare imediată!

259,37Lei

Afişare 41 - 60 din 1473 (74 pagini)
Queries: 7, Total time: 95.318 ms [By time] [By id] [By file]
1 (0.243)
SELECT data
FROM `oc_session`
WHERE session_id = '5e2673161a7fe79695023846f0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.133)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.125)
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 (37.547)
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:1667
6 (57.032)
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 = '11' 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
7 (0.135)
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