Daiwa

Daiwa

Sortare după:

Maner Minciog Daiwa N-Zone Feeder PRO 4.00m, 3seg, Carbon

Maner Minciog Daiwa N-Zone Feeder PRO 4.00m, 3seg, Carbon

a2.13421.400

Livrare 24-48 ore

631,45Lei

Method Feeder Daiwa Nzon Weight Change S, 30g, 1buc/pac

Method Feeder Daiwa Nzon Weight Change S, 30g, 1buc/pac

a3.13345.730

Livrare 24-48 ore

19,20Lei

Lanseta DAIWA Ninja X Stalker Feeder 11610, 3.30m, 80g, 3+3seg

Lanseta DAIWA Ninja X Stalker Feeder 11610, 3.30m, 80g, 3+3seg

d.11610.331

Livrare imediată!

287,60Lei

Jacheta DAIWA D-Vec Wading Grey-Camo, Marime XXL

Jacheta DAIWA D-Vec Wading Grey-Camo, Marime XXL

d.18869.040

Livrare 24-48 ore

462,70Lei

Lanseta DAIWA Ninja X Carp, 3.00lbs, 3.60m, 2seg

Lanseta DAIWA Ninja X Carp, 3.00lbs, 3.60m, 2seg

d.11590.366

Livrare imediată!

346,96Lei

Varga DAIWA Ninja X Tele Pole, 5m, 6seg

Varga DAIWA Ninja X Tele Pole, 5m, 6seg

d.11629.500

Livrare imediată!

188,48Lei(-13%) 163,68Lei

Fir Monofilament Daiwa J-Threads, Pink, 10.10kg, 0.37mm, 600m

Fir Monofilament Daiwa J-Threads, Pink, 10.10kg, 0.37mm, 600m

d.12225.137

Livrare imediată!

62,41Lei

MULINETA DAIWA N ZON PLUS LT 5000S-CP

MULINETA DAIWA N ZON PLUS LT 5000S-CP

d.10311.500

Livrare 24-48 ore

987,44Lei(-21%) 783,17Lei

Bluza DAIWA D Old Shirt Long Sleeve 30, Dark Gray, Marime 2XL

Bluza DAIWA D Old Shirt Long Sleeve 30, Dark Gray, Marime 2XL

d.21lshirt30dg2xl

Livrare 24-48 ore

147,18Lei

Lanseta Spinning DAIWA Morethan Branzino Expert AGS 747 HM HFSCF 2.24m, 10-35g, 2seg

Lanseta Spinning DAIWA Morethan Branzino Expert AGS 747 HM HFSCF 2.24m, 10-35g, 2seg

d.mtbrexags742hmhfsc

Livrare 24-48 ore

3.849,82Lei

Mulineta DAIWA 25 RZ 2000 Spinning 3Rul, 0,10mm-250m, 5.1:1

Mulineta DAIWA 25 RZ 2000 Spinning 3Rul, 0,10mm-250m, 5.1:1

d.25rz2000

Livrare 24-48 ore

225,11Lei

Lanseta Daiwa Procyon Spin 2.05m 3-12g 2seg

Lanseta Daiwa Procyon Spin 2.05m 3-12g 2seg

d.11211.205

Livrare imediată!

505,09Lei

MULINETA DAIWA BG Monocoque 3000D-XH 6RUL

MULINETA DAIWA BG Monocoque 3000D-XH 6RUL

d.10465.300

Livrare 24-48 ore

1.093,66Lei(-11%) 973,14Lei

HUSA PROTECTIE DAIWA LANSETA 170X2.5CM

HUSA PROTECTIE DAIWA LANSETA 170X2.5CM

d.ch257893

Livrare imediată!

69,73Lei(-27%) 50,63Lei

Mulineta Daiwa Fuego LT 2500

Mulineta Daiwa Fuego LT 2500

d.10223.250

Livrare imediată!

497,29Lei(-12%) 436,12Lei

Dumbells Daiwa Advantage Semi Buoyant Hookbaits Orange 8-10mm 30g

Dumbells Daiwa Advantage Semi Buoyant Hookbaits Orange 8-10mm 30g

a0.13300.101

Livrare 24-48 ore

31,07Lei

CARLIGE DAIWA SAMURAI EEL Nr.6 10BUC/PLIC

CARLIGE DAIWA SAMURAI EEL Nr.6 10BUC/PLIC

a.14810.006

Livrare 24-48 ore

13,25Lei(-42%) 7,73Lei

JACHETA DAIWA ULTRA CARP S

JACHETA DAIWA ULTRA CARP S

d.18865.210

Livrare imediată!

437,10Lei

Lanseta Spinning Daiwa Airity Spin, 2.10m, 7-21g, 2seg

Lanseta Spinning Daiwa Airity Spin, 2.10m, 7-21g, 2seg

d.11926.210

Livrare 24-48 ore

947,48Lei

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.10mm, 135m, 6.7kg

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.10mm, 135m, 6.7kg

d.12760.010

Livrare imediată!

153,69Lei

Afişare 741 - 760 din 1553 (78 pagini)

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

1 (0.084)

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

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

2 (0.089)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.098)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.102)

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

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

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 740,20

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

7 (0.109)

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