Daiwa

Daiwa

Sortare după:

BRIDE DUBLE DAIWA PREMIUM 1.3MM/30BUC/PL

BRIDE DUBLE DAIWA PREMIUM 1.3MM/30BUC/PL

d.15408.301

Livrare imediată!

12,00Lei

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,65Lei(-4%) 92,50Lei

CARLIGE LEGATE DAIWA TOURNAMENT PT.CRAP NR.6/10BUC

CARLIGE LEGATE DAIWA TOURNAMENT PT.CRAP NR.6/10BUC

a.14450.006

Livrare 24-48 ore

22,74Lei

Bac Daiwa de Nada EVA, 36x22cm

Bac Daiwa de Nada EVA, 36x22cm

a8.15809.115

Livrare imediată!

108,25Lei

Geanta DAIWA Matchman Carryall, 56x47x22cm

Geanta DAIWA Matchman Carryall, 56x47x22cm

a8.dmmc1

Livrare 24-48 ore

312,95Lei

MULINETA DAIWA RX LT 2500 2RUL/230M/0,16MM/5,3:1

MULINETA DAIWA RX LT 2500 2RUL/230M/0,16MM/5,3:1

d.10423.251

Livrare 24-48 ore

219,91Lei

Fir Textil Daiwa Morethan 12 Braid EX+SI 135m 0.14mm 12.2kg

Fir Textil Daiwa Morethan 12 Braid EX+SI 135m 0.14mm 12.2kg

d.12695.014

Livrare 24-48 ore

216,47Lei

Lanseta Daiwa Fuego Jiggerspin 2.40m 7-28g 2seg

Lanseta Daiwa Fuego Jiggerspin 2.40m 7-28g 2seg

d.11122.240

Livrare imediată!

383,07Lei

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

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.08mm, 4.9kg

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.08mm, 4.9kg

d.12761.008

Livrare imediată!

170,51Lei

Lanseta DAIWA EXCELER 662MHFB 1,98M/7-28G 2BUC

Lanseta DAIWA EXCELER 662MHFB 1,98M/7-28G 2BUC

d.ex662mhfbdf

Livrare 24-48 ore

474,30Lei(-39%) 290,38Lei

FIR MONOFILAMENT DAIWA NZON S BRW 020MM 3.1KG 300M

FIR MONOFILAMENT DAIWA NZON S BRW 020MM 3.1KG 300M

d.12405.020

Livrare imediată!

33,35Lei

Lanseta Feeder Daiwa Black Widow, 3.60m, 120g, 3+2seg

Lanseta Feeder Daiwa Black Widow, 3.60m, 120g, 3+2seg

d.11789.361

Livrare imediată!

320,29Lei(-8%) 294,11Lei

Costum de Iarna Daiwa Winter Carp Olive Green, Marime M

Costum de Iarna Daiwa Winter Carp Olive Green, Marime M

d.18865.320

Livrare 24-48 ore

983,51Lei

Varga Daiwa Sweepfire Telescopica 5.00m

Varga Daiwa Sweepfire Telescopica 5.00m

d.11521.500

Livrare imediată!

91,48Lei

Broasca Artificiala Daiwa Steez CFROG 3.8cm, Splatter Chartreuse, 6.2g

Broasca Artificiala Daiwa Steez CFROG 3.8cm, Splatter Chartreuse, 6.2g

f.d.17512.501

Livrare 24-48 ore

41,38Lei(-18%) 34,10Lei

Vobler Daiwa Steez Crank, Clear Monster Chart, 5.4cm, 10.6g

Vobler Daiwa Steez Crank, Clear Monster Chart, 5.4cm, 10.6g

f3.d17510.202

Livrare 24-48 ore

72,12Lei

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 imediată!

101,70Lei

Shad Daiwa D.Fin Goby, 7.50cm, 10buc/pac

Shad Daiwa D.Fin Goby, 7.50cm, 10buc/pac

d.16504.308

Livrare 24-48 ore

30,60Lei

Shad Daiwa Prorex Slim Shady, Color Mix 2, 7.5cm, 3.3g, 5buc/pac

Shad Daiwa Prorex Slim Shady, Color Mix 2, 7.5cm, 3.3g, 5buc/pac

d.15100.601

Livrare imediată!

42,45Lei

Afişare 1181 - 1200 din 1583 (80 pagini)

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

1 (0.082)

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

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

2 (0.095)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.102)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.105)

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 = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (45.316)

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 = '0' AND p.manufacturer_id = '11'

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

6 (70.439)

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

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

7 (0.191)

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

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