Daiwa

Daiwa

Sortare după:

Fir Elastic Daiwa N Zon Power Gum 0.8mm 6kg 10m

Fir Elastic Daiwa N Zon Power Gum 0.8mm 6kg 10m

d.13306.008

Livrare imediată!

17,50Lei

LANSETA DAIWA 3+2BUC N.ZON FEEDER 3,66M/100G

LANSETA DAIWA 3+2BUC N.ZON FEEDER 3,66M/100G

d.11331.365

Livrare imediată!

428,13Lei(-8%) 392,81Lei

FIR MONOFILAMENT DAIWA NZON S BRW 018MM 2.4KG 300M

FIR MONOFILAMENT DAIWA NZON S BRW 018MM 2.4KG 300M

d.12405.018

Livrare imediată!

31,64Lei

Costum de Iarna Daiwa Winter Carp Olive Green, Marime S

Costum de Iarna Daiwa Winter Carp Olive Green, Marime S

d.18865.310

Livrare imediată!

1.020,83Lei(-22%) 800,11Lei

Varga Daiwa Sweepfire Telescopica 4.00m

Varga Daiwa Sweepfire Telescopica 4.00m

d.11521.400

Livrare imediată!

68,37Lei

Broasca Artificiala Daiwa Steez CFROG 3.8cm, Green Toad, 6.2g

Broasca Artificiala Daiwa Steez CFROG 3.8cm, Green Toad, 6.2g

f.d.17512.500

Livrare 24-48 ore

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

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

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

f3.d17510.201

Livrare 24-48 ore

72,12Lei

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.18mm, 15.8kg

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.18mm, 15.8kg

d.12761.018

Livrare imediată!

106,52Lei(-5%) 101,70Lei

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

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

d.16504.310

Livrare 24-48 ore

31,38Lei

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

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

d.15100.600

Livrare 24-48 ore

30,07Lei

SHAD DAIWA DUCKFIN 10CM RAINBOW/7BUC

SHAD DAIWA DUCKFIN 10CM RAINBOW/7BUC

d.16501.410

Livrare imediată!

31,38Lei

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.28mm, 6.30kg, 1540m

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.28mm, 6.30kg, 1540m

d.12765.128

Livrare imediată!

100,47Lei

BROASCA ARTIFICIALA DAIWA SOFT D-FROG 6CM MARO

BROASCA ARTIFICIALA DAIWA SOFT D-FROG 6CM MARO

d.15605.006

Livrare imediată!

43,78Lei(-19%) 35,25Lei

Mulineta Daiwa Windcast Spod'N Mark 5000, 5.5:1, 0.35mm/370m, 4rul

Mulineta Daiwa Windcast Spod'N Mark 5000, 5.5:1, 0.35mm/370m, 4rul

d.10159.605

Livrare imediată!

895,63Lei

Husa DAIWA D-Vec pentru 1 Lanseta cu Mulineta, Grey, 130cm

Husa DAIWA D-Vec pentru 1 Lanseta cu Mulineta, Grey, 130cm

a8.15843.130

Livrare 24-48 ore

151,78Lei

Mulineta Daiwa Joinus 2500

Mulineta Daiwa Joinus 2500

d.jn162500

Livrare 24-48 ore

109,21Lei

UMBRELA DAIWA D-VEC D=2,5M

UMBRELA DAIWA D-VEC D=2,5M

d.18801.250

Livrare imediată!

390,49Lei

MULINETA DAIWA PROREX LT 2000D

MULINETA DAIWA PROREX LT 2000D

d.10604.206

Livrare 24-48 ore

1.376,65Lei(-29%) 980,86Lei

Fir Textil DAIWA Tournament Sinking Feeder Braid 8+1X, 0.08m, 135m

Fir Textil DAIWA Tournament Sinking Feeder Braid 8+1X, 0.08m, 135m

d.12785.008

Livrare 24-48 ore

133,54Lei

Shad Daiwa D.Fin, Hot Tomato, 7.5cm, 10buc/plic

Shad Daiwa D.Fin, Hot Tomato, 7.5cm, 10buc/plic

d.16502.608

Livrare 24-48 ore

30,60Lei

Afişare 981 - 1000 din 1583 (80 pagini)

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

1 (0.107)

SELECT data
FROM `oc_session`
WHERE session_id = '947052d6acf652f8dee6c1817f'

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

2 (0.113)

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.137)

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

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

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

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

7 (0.170)

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