Daiwa

Daiwa

Sortare după:

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.20mm, 18.0kg

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.20mm, 18.0kg

d.12761.020

Livrare 24-48 ore

100,70Lei

Shad Daiwa D.Fin Pepper Ghost, 10.00cm, 7buc/pac

Shad Daiwa D.Fin Pepper Ghost, 10.00cm, 7buc/pac

d.16504.510

Livrare 24-48 ore

30,38Lei

Varga Daiwa Tele Aqualite WHIP 50TEAF Carbon, 5m, 5seg

Varga Daiwa Tele Aqualite WHIP 50TEAF Carbon, 5m, 5seg

d.aqlw50teaf

Livrare 24-48 ore

272,33Lei

MULINETA DAIWA MUSCA WILDERNESS 200 CLS.4.6

MULINETA DAIWA MUSCA WILDERNESS 200 CLS.4.6

d.wd200

Livrare 24-48 ore

215,77Lei

Shad Daiwa Prorex Slim Shady, Ghost Firetiger, 7.5cm, 3.3g, 4buc/pac

Shad Daiwa Prorex Slim Shady, Ghost Firetiger, 7.5cm, 3.3g, 4buc/pac

d.15100.114

Livrare 24-48 ore

30,05Lei

FIR TEXTIL DAIWA J-BRAID X8 CHARTREUSE 010MM/6,0KG/150M

FIR TEXTIL DAIWA J-BRAID X8 CHARTREUSE 010MM/6,0KG/150M

d.12750.010

Livrare imediată!

65,41Lei

FIR TEXTIL DAIWA J-BRAID X4 0.15MM 6.9KG 135MT GALBEN

FIR TEXTIL DAIWA J-BRAID X4 0.15MM 6.9KG 135MT GALBEN

d.12740.015

Livrare imediată!

34,53Lei

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.34mm, 9.20kg, 840m

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.34mm, 9.20kg, 840m

d.12765.134

Livrare imediată!

99,47Lei

Lanseta feeder Daiwa Ninja Feeder 2 seg 2varfuri 11Q 3.30m 40g

Lanseta feeder Daiwa Ninja Feeder 2 seg 2varfuri 11Q 3.30m 40g

d.njf11q.au

Livrare imediată!

371,18Lei

CUTIE MOMEALA DAIWA 1.5 L

CUTIE MOMEALA DAIWA 1.5 L

d.dwbb1.5

Livrare imediată!

35,06Lei

VARGA DAIWA AQUALITE ALBORELLA 50 CARBON 5.00M

VARGA DAIWA AQUALITE ALBORELLA 50 CARBON 5.00M

d.aqlalb50bf

Livrare imediată!

333,66Lei(-20%) 266,94Lei

Fir Textil Daiwa Prorex UL Finesse Braid Chartreuse 135m 1.80kg

Fir Textil Daiwa Prorex UL Finesse Braid Chartreuse 135m 1.80kg

d.12996.002

Livrare imediată!

96,66Lei(-7%) 89,99Lei

Fir Daiwa Textil J-Braid X8, Dark Green, 010MM/6KG/300M

Fir Daiwa Textil J-Braid X8, Dark Green, 010MM/6KG/300M

d.12751.110

Livrare 24-48 ore

118,32Lei

CAP JIG DAIWA PROREX FLEXI JIG-SYSTEM TG HEAD CUPRU 6G 3BUC/PLIC

CAP JIG DAIWA PROREX FLEXI JIG-SYSTEM TG HEAD CUPRU 6G 3BUC/PLIC

f2.15412.106

Livrare 24-48 ore

35,33Lei(-40%) 21,21Lei

MULINETA DAIWA CALDIA LT 6RUL 1000S-P 0.12mm/100m

MULINETA DAIWA CALDIA LT 6RUL 1000S-P 0.12mm/100m

d.10412.105

Livrare 24-48 ore

1.222,75Lei(-30%) 855,93Lei

CARLIG DAIWA OFFSET BASSERS WORM NR.02/6BUC

CARLIG DAIWA OFFSET BASSERS WORM NR.02/6BUC

a.16509.020

Livrare 24-48 ore

19,99Lei

MULINETA DAIWA WHISKER 25QDA 7RUL

MULINETA DAIWA WHISKER 25QDA 7RUL

d.10930.025

Livrare imediată!

2.330,16Lei(-30%) 1.635,44Lei

Mulineta Daiwa BG Monocoque 8000-H 6RUL

Mulineta Daiwa BG Monocoque 8000-H 6RUL

d.10465.080

Livrare imediată!

1.385,42Lei(-10%) 1.246,88Lei

Lanseta Daiwa Steez AGS 6101 MLXS 2.09m 5-14g

Lanseta Daiwa Steez AGS 6101 MLXS 2.09m 5-14g

d.stzags6101mlxscf

Livrare 24-48 ore

1.565,85Lei

COMBO DAIWA LEGALIS SEABASS 2.40M 10-35G+MUL.REGAL 2SEG

COMBO DAIWA LEGALIS SEABASS 2.40M 10-35G+MUL.REGAL 2SEG

d.packtsuki19

Livrare imediată!

620,09Lei(-30%) 434,06Lei

Afişare 761 - 780 din 1624 (82 pagini)

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

1 (0.117)

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

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

2 (0.115)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.140)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.094)

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

5 (40.797)

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

6 (60.027)

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

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

7 (0.156)

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

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