Daiwa

Daiwa

Sortare după:

Varga Daiwa Sweepfire Telescopica 5.00m

Varga Daiwa Sweepfire Telescopica 5.00m

d.11521.500

Livrare imediată!

91,48Lei

Vobler Daiwa Steez Prop 85F 8.5cm, Clear Lime, 12.7g

Vobler Daiwa Steez Prop 85F 8.5cm, Clear Lime, 12.7g

f.d.17511.002

Livrare 24-48 ore

74,71Lei

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

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

f3.d17510.200

Livrare 24-48 ore

72,12Lei

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.16mm, 12.2kg

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.16mm, 12.2kg

d.12761.016

Livrare 24-48 ore

114,45Lei

Fir Monofilament Daiwa Tournament Galben Fluo 0.35mm/1040m/6.4kg

Fir Monofilament Daiwa Tournament Galben Fluo 0.35mm/1040m/6.4kg

d.tfym035

Livrare 24-48 ore

92,27Lei

BROASCA ARTIFICIALA DAIWA SOFT D-FROG 6CM GALBENA

BROASCA ARTIFICIALA DAIWA SOFT D-FROG 6CM GALBENA

d.15605.206

Livrare 24-48 ore

45,52Lei

MULINETA DAIWA BLACK WIDOW 25A

MULINETA DAIWA BLACK WIDOW 25A

d.10133.225

Livrare imediată!

457,40Lei

BORSETA DAIWA 25X10X17CM

BORSETA DAIWA 25X10X17CM

d.df1202

Livrare 24-48 ore

282,50Lei

SHAD DAIWA DUCKFIN 10CM PEARL 7 BUCACTI/PLIC

SHAD DAIWA DUCKFIN 10CM PEARL 7 BUCACTI/PLIC

d.16500.410

Livrare imediată!

31,38Lei

NALUCA DAIWA PROREX MICRO SPINNER 5G GOLD PERCH

NALUCA DAIWA PROREX MICRO SPINNER 5G GOLD PERCH

f.d.15426.014

Livrare 24-48 ore

37,70Lei(-16%) 31,67Lei

Mulineta Daiwa TD Feeder 4012QD

Mulineta Daiwa TD Feeder 4012QD

d.10419.412

Livrare imediată!

729,05Lei(-8%) 668,17Lei

MULINETA DAIWA FREAMS LT 1000S

MULINETA DAIWA FREAMS LT 1000S

d.10224.100

Livrare imediată!

695,39Lei

NALUCA DAIWA PROREX BOTH CRAW IBERIAN RED 7.5CM

NALUCA DAIWA PROREX BOTH CRAW IBERIAN RED 7.5CM

f.d.15429.800

Livrare 24-48 ore

55,45Lei(-17%) 46,11Lei

Lanseta Pastrav DAIWA Presso Imprimi 602UL, 1.80m, 0.5-5g, 2seg

Lanseta Pastrav DAIWA Presso Imprimi 602UL, 1.80m, 0.5-5g, 2seg

d.pso602ulcf

Livrare 24-48 ore

312,95Lei

Muste DAIWA Fly Pack River Nymphs, 10buc/pac

Muste DAIWA Fly Pack River Nymphs, 10buc/pac

f3.dfc4

Livrare 24-48 ore

73,63Lei

VARTEJ DAIWA N ZON NR.10

VARTEJ DAIWA N ZON NR.10

a7.13312.010

Livrare 24-48 ore

11,62Lei

Agrafa cu Vartej DAIWA Emerillons a Agrafe Snap Swivel Nr.14, 4kg, 20buc/pac

Agrafa cu Vartej DAIWA Emerillons a Agrafe Snap Swivel Nr.14, 4kg, 20buc/pac

a7.em258111

Livrare 24-48 ore

14,10Lei

Geanta Daiwa Tournament Pro Carry All M + 3 Cutii

Geanta Daiwa Tournament Pro Carry All M + 3 Cutii

d.tnp3bfc.m

Livrare 24-48 ore

440,04Lei

LANSETA SPINNING DAIWA PROCYON SPIN 2.10M 15-50G 2seg

LANSETA SPINNING DAIWA PROCYON SPIN 2.10M 15-50G 2seg

d.11210.212

Livrare imediată!

531,30Lei(-19%) 427,96Lei

SHAD DAIWA TOURNAMENT D.FIN 7.5CM OS 10BUC/PLIC

SHAD DAIWA TOURNAMENT D.FIN 7.5CM OS 10BUC/PLIC

d.16502.908

Livrare 24-48 ore

30,60Lei

Afişare 941 - 960 din 1664 (84 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 7, Total time: 101.758 ms [By time] [By id] [By file]

1 (0.096)

SELECT data
FROM `oc_session`
WHERE session_id = 'bf2f700c8cf1e60be97d5a610d'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.076)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.100)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.095)

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 (40.034)

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:1699

6 (61.243)

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 = '2' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 940,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.114)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37