Daiwa


LANSETA SPINNING DAIWA 2SEG CALDIA LURE SPIN 2.10M 10-40G

LANSETA SPINNING DAIWA 2SEG CALDIA LURE SPIN 2.10M 10-40G

d.11480.211
Livrare imediată!

426,34Lei

MULTIPLICATOR DAIWA TATULA 100HL 8RUL/135MX032/6,3:

MULTIPLICATOR DAIWA TATULA 100HL 8RUL/135MX032/6,3:

d.tate19100hl
Livrare 24-48 ore

1.401,59Lei

Cosulet DAIWA FEEDER N ZON OPEN END L 40G

Cosulet DAIWA FEEDER N ZON OPEN END L 40G

a.13352.040
Livrare imediată!

15,71Lei

Mulineta, Daiwa, Revros, LT, 4000, d.10221.401, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Feeder, Mulinete Feeder Daiwa, Daiwa
BLUZA, DAIWA, D-VEC, LS, WHITE, MARIME, XXL, d.18206.150, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa

BLUZA, DAIWA, D-VEC, LS, WHITE, MARIME, XXL, d.18206.150, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa

d.18206.150
Livrare 24-48 ore

190,69Lei

Hanorac Daiwa Carp XL

Hanorac Daiwa Carp XL

d.18865.140
Livrare imediată!

276,75Lei

Mulineta Daiwa Emcast BR LT 5000-C -17%

Mulineta Daiwa Emcast BR LT 5000-C

d.10148.500
Livrare imediată!

582,64Lei(-17%) 484,03Lei

Vobler Daiwa TN Mega Scounter Pearl Ghost Perch, 6.8cm, 14g

Vobler Daiwa TN Mega Scounter Pearl Ghost Perch, 6.8cm, 14g

f3.d16710.005
Livrare 24-48 ore

85,35Lei

Lanseta, Spinning, Daiwa, Tele, Sweepfire, 2.10m,, 10-30g,, 6seg, d.11421.211, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Lanseta, Daiwa, Tatula, XT, Spin, 2.03m,, 1.8-11g,, 2seg, d.11508.201, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Mulineta Daiwa Fuego LT3000-C, 0.23mm/150m, 5.3:1, 6rul

Mulineta Daiwa Fuego LT3000-C, 0.23mm/150m, 5.3:1, 6rul

d.10333.300
Livrare imediată!

602,98Lei

Mulineta, Daiwa, Certate, FC, LT, 3000D-C, 0.33mm/150m,, 5.2:1,, 10rul, d.10424.300, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Lanseta Daiwa Hyper Spod 2500 3.60m, 5.0lbs, 2seg

Lanseta Daiwa Hyper Spod 2500 3.60m, 5.0lbs, 2seg

d.dhspd2500ax
Livrare imediată!

389,12Lei

Lanseta, Spinning, Daiwa, Exceler, Spin, ST, 2.10m,, 2-10g,, 2seg, d.11664.211, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Mulineta Daiwa 23 Super Spod 45 SCW QD-OT

Mulineta Daiwa 23 Super Spod 45 SCW QD-OT

d.10158.505
Livrare imediată!

1.014,68Lei

MULINETA DAIWA CERTATE G LT 2500-XH -10%

MULINETA DAIWA CERTATE G LT 2500-XH

d.10407.826
Livrare 24-48 ore

2.821,43Lei(-10%) 2.539,29Lei

Fir Daiwa Tournament SF Green 0.30mm 300m 7.9kg

Fir Daiwa Tournament SF Green 0.30mm 300m 7.9kg

d.12200.330
Livrare imediată!

38,68Lei

GEANTA DAIWA INFINITY PENTRU ACCESORII 25X20X10

GEANTA DAIWA INFINITY PENTRU ACCESORII 25X20X10

d.18850.050
Livrare imediată!

76,36Lei

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

Afişare 161 - 180 din 1480 (74 pagini)
Queries: 7, Total time: 149.956 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = '6fb70ea98d2941a9dcecf90a2b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.119)
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 (70.545)
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:1667
6 (78.722)
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 = '2' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.218)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38