Daiwa


Cosulet, DAIWA, FEEDER, N, ZON, OPEN, END, L, 50G, a.13352.050, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa
TRICOU DAIWA POLO TOURNAMENT NEGRU ROSU MARIME M -20%

TRICOU DAIWA POLO TOURNAMENT NEGRU ROSU MARIME M

d.tnpbr.m
Livrare 24-48 ore

200,21Lei(-20%) 160,17Lei

METHOD FEEDER DAIWA NZON METHOD 50G MAR. L

METHOD FEEDER DAIWA NZON METHOD 50G MAR. L

a3.13345.250
Livrare imediată!

22,79Lei

Lanseta Spinning Daiwa Crossfire Spin 2.10m, 10-40g, 2seg

Lanseta Spinning Daiwa Crossfire Spin 2.10m, 10-40g, 2seg

d.11438.211
Livrare imediată!

196,02Lei

Lanseta Spinning Daiwa MF Travel Spin 2.40m, 30-70g, 4seg

Lanseta Spinning Daiwa MF Travel Spin 2.40m, 30-70g, 4seg

d.11253.241
Livrare 24-48 ore

340,36Lei

Mulineta Daiwa Crosscast 45SCW 5000LD QD OT -23%

Mulineta Daiwa Crosscast 45SCW 5000LD QD OT

d.10250.605
Livrare imediată!

906,33Lei(-23%) 697,90Lei

Multiplicator Daiwa Tatula Elite P/F 103HSL 7.1:1, 0.37mm-65m, 7rul

Multiplicator Daiwa Tatula Elite P/F 103HSL 7.1:1, 0.37mm-65m, 7rul

d.10721.100
Livrare 24-48 ore

1.587,81Lei

Fir Fluorocarbon Daiwa Saltiga FC Leader X Link 0.70mm, 60lbs, 30m

Fir Fluorocarbon Daiwa Saltiga FC Leader X Link 0.70mm, 60lbs, 30m

d.12956.570
Livrare imediată!

119,65Lei

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

Mulineta Daiwa Exceler LT3000-CXH, 0.23mm/150m, 6.2:1, 5rul

d.10336.301
Livrare 24-48 ore

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

Lanseta, Spinning, Daiwa, Ninja, EXT, Spin, 2.45m,, 15-50g,, 3seg, d.11206.246, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
LANSETA DAIWA 2SEG EMCAST CARP 3.90M, 3.5LBS

LANSETA DAIWA 2SEG EMCAST CARP 3.90M, 3.5LBS

d.11581.390
Livrare imediată!

692,70Lei

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

d.18850.200
Livrare imediată!

410,72Lei

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 4G GOLD METAL -20%

LINGURITA DAIWA ROTATIVA 4G GOLD METAL

d.07411554
Livrare 24-48 ore

23,65Lei(-20%) 18,92Lei

Galeata Daiwa +Capac Advantage 18 L -20%

Galeata Daiwa +Capac Advantage 18 L

a.13305.300
Livrare imediată!

119,65Lei(-20%) 95,74Lei

BLUZA DAIWA D-VEC LS WHITE MARIME L

BLUZA DAIWA D-VEC LS WHITE MARIME L

d.18206.130
Livrare 24-48 ore

190,69Lei

Hanorac, Daiwa, Carp, L, d.18865.130, Hanorace, Hanorace Daiwa, Daiwa

Hanorac, Daiwa, Carp, L, d.18865.130, Hanorace, Hanorace Daiwa, Daiwa

d.18865.130
Livrare imediată!

276,75Lei

Mulineta Daiwa Crossfire LT 4000-C 4BS A -17%

Mulineta Daiwa Crossfire LT 4000-C 4BS A

d.10186.400
Livrare imediată!

305,35Lei(-17%) 253,67Lei

Vobler Daiwa TN Mega Scounter Lazer Red, 6.8cm, 14g

Vobler Daiwa TN Mega Scounter Lazer Red, 6.8cm, 14g

f3.d16710.008
Livrare 24-48 ore

86,58Lei

Mulineta, Daiwa, Emblem, BR, 10000, 25A, 0.32mm/320m,, 5.3:1,, 6rul, d.10158.100, Mulinete Crap, Mulinete Crap Daiwa, Mulinete Daiwa, Crap Daiwa, Daiwa -26%
Afişare 1 - 20 din 1485 (75 pagini)
Queries: 9, Total time: 136.044 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = '4c83db78e56d07927b2855ad19'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.119)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.137)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (52.587)
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 = '3' AND p.manufacturer_id = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (82.587)
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 = '3' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.155)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.133)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38