Daiwa


Mulineta Daiwa Freams LT 2000D 0.20mm/150m, 5.3:1, 5rul -10%

Mulineta Daiwa Freams LT 2000D 0.20mm/150m, 5.3:1, 5rul

d.10229.201
Livrare 24-48 ore

782,06Lei(-10%) 705,80Lei

Lanseta Daiwa Tele Black Widow Carp 3.00m, 3lbs, 6seg

Lanseta Daiwa Tele Black Widow Carp 3.00m, 3lbs, 6seg

d.11582.300
Livrare imediată!

265,94Lei

RETRACTOR CU UNGHIERA DAIWA -30%

RETRACTOR CU UNGHIERA DAIWA

a.dzcci
Livrare 24-48 ore

101,58Lei(-30%) 71,15Lei

Lingurita Oscilanta Daiwa Steez 7cm, 14g, Nr.4, Ayu

Lingurita Oscilanta Daiwa Steez 7cm, 14g, Nr.4, Ayu

f.d.17516.214
Livrare 24-48 ore

58,00Lei

MULINETA, DAIWA, SWEEPFIRE, E, 2000C, 125M/025MM/5,3:1, d.10118.200, Mulinete Rapitori, Mulinete Rapitori Daiwa, Daiwa
Vobler Daiwa Steez Crank, Monster Chart, 5.4cm, 10.6g

Vobler Daiwa Steez Crank, Monster Chart, 5.4cm, 10.6g

f3.d17510.201
Livrare 24-48 ore

74,08Lei

MULINETA DAIWA BLACK WIDOW 25A

MULINETA DAIWA BLACK WIDOW 25A

d.10133.225
Livrare imediată!

426,97Lei

AGRAFA, CU, VARTEJ, DAIWA, PROREX, M, 10BUC, PLIC, a7.15408.101, Agrafe Rapitor, Agrafe Rapitor Daiwa, Agrafe Daiwa, Rapitor Daiwa, Daiwa
Mulineta Daiwa N Zon LT 6000SS-P 4.9:1, 0.28mm/150m, 4rul -4%

Mulineta Daiwa N Zon LT 6000SS-P 4.9:1, 0.28mm/150m, 4rul

d.10312.600
Livrare imediată!

415,46Lei(-4%) 399,90Lei

FIR, DAIWA, PROREX, FC, LEADER, 0.50MM/14.6KG/21M, d.12995.050, Fire Monofilament Rapitori, Fire Monofilament Rapitori Daiwa, Fire Daiwa, Monofilament Daiwa, Rapitori Daiwa, Daiwa
VOBLER, DAIWA, PROREX, PENCIL, FLOATING,, GOLD, PERCH,, 6.5CM,, 5.8G, f3.d15209.001, Voblere Floating, Voblere Floating Daiwa, Daiwa
Cutie pentru Momeala Daiwa D-Box SS Smoke, 21.7x16.4x4.8cm

Cutie pentru Momeala Daiwa D-Box SS Smoke, 21.7x16.4x4.8cm

d.14310.005
Livrare 24-48 ore

36,12Lei

SHAD DAIWA DUCKFIN 12.5CM/PEARL/5BUC/PL

SHAD DAIWA DUCKFIN 12.5CM/PEARL/5BUC/PL

d.16500.412
Livrare 24-48 ore

45,24Lei

MULINETA, DAIWA, NINJA, LT, 2500-XH, d.10219.256, Mulinete Rapitori, Mulinete Rapitori Daiwa, Daiwa -8%

MULINETA, DAIWA, NINJA, LT, 2500-XH, d.10219.256, Mulinete Rapitori, Mulinete Rapitori Daiwa, Daiwa

d.10219.256
Livrare imediată!

308,56Lei(-8%) 284,81Lei

LANSETA DAIWA SPINNING 2BUC. PROREX S SPIN 2,40M/10-30G

LANSETA DAIWA SPINNING 2BUC. PROREX S SPIN 2,40M/10-30G

d.11296.241
Livrare imediată!

260,25Lei

LANSETA DAIWA LEGALIS JIGGER 2.40M 7-28G 2BUC

LANSETA DAIWA LEGALIS JIGGER 2.40M 7-28G 2BUC

d.11768.248
Livrare 24-48 ore

286,12Lei

STRUNA DAIWA PROREX TITANIUM 30CM/12KG

STRUNA DAIWA PROREX TITANIUM 30CM/12KG

a7.17925.812
Livrare imediată!

20,69Lei

Lanseta, Daiwa, Sweepfire, Spin, 2.10M, 10-40g, 2SEG, d.11435.212, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Lanseta Daiwa SEAHUNTER X PILK 2.70M/40-120G

Lanseta Daiwa SEAHUNTER X PILK 2.70M/40-120G

d.11532.275
Livrare imediată!

260,22Lei

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 6/8mm Ciocolata Portocaliu 30g/borcan -5%

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 6/8mm Ciocolata Portocaliu 30g/borcan

a0.13300.100
Livrare imediată!

36,99Lei(-5%) 35,09Lei

Afişare 741 - 760 din 1485 (75 pagini)
Queries: 9, Total time: 93.832 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = '7883c6a2d4e8c16caa52aa401b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.127)
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
6 (37.269)
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:1650
7 (55.794)
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 740,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.115)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.106)
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