Daiwa

Daiwa

Sortare după:

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.37mm, 10.10kg, 790m

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.37mm, 10.10kg, 790m

d.12765.137

Livrare imediată!

99,47Lei

VOBLER DAIWA PROREX HYBRID 18CM 50G GOLDEN SHINER

VOBLER DAIWA PROREX HYBRID 18CM 50G GOLDEN SHINER

f3.d15418.002

Livrare imediată!

82,00Lei

GEANTA DAIWA BLACK WIDOW CARRYALL 60X32X40CM

GEANTA DAIWA BLACK WIDOW CARRYALL 60X32X40CM

d.18705.070

Livrare imediată!

315,56Lei

VARGA DAIWA HARRIER 60TE CARBON 5.89M

VARGA DAIWA HARRIER 60TE CARBON 5.89M

d.hr60tebf

Livrare 24-48 ore

748,12Lei

LANSETA DAIWA SPINNING 2BUC. LEGALIS SPIN 2,10M/5-20G

LANSETA DAIWA SPINNING 2BUC. LEGALIS SPIN 2,10M/5-20G

d.11768.211

Livrare 24-48 ore

248,42Lei

Fir Daiwa Textil J-Braid X8, Dark Green, 013MM/8KG/300M

Fir Daiwa Textil J-Braid X8, Dark Green, 013MM/8KG/300M

d.12751.113

Livrare 24-48 ore

159,31Lei(-26%) 118,32Lei

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

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

f2.15412.108

Livrare 24-48 ore

42,94Lei(-40%) 25,76Lei

MULINETA DAIWA EMCAST BR LT 3RUL 4000 0.28mm/150m

MULINETA DAIWA EMCAST BR LT 3RUL 4000 0.28mm/150m

d.10148.400

Livrare imediată!

522,99Lei(-8%) 482,76Lei

Vobler Daiwa Prorex Mini Popper Live Brown Trout 5.5cm 5.7g

Vobler Daiwa Prorex Mini Popper Live Brown Trout 5.5cm 5.7g

f3.d15208.009

Livrare 24-48 ore

44,84Lei

Lanseta Daiwa Fuego Camo 2.10m 10-40g 2seg

Lanseta Daiwa Fuego Camo 2.10m 10-40g 2seg

d.11121.211

Livrare imediată!

354,33Lei

SHAD DAIWA TOURNAMENT D.FIN 7.5CM UV REAL MOTOR OIL 10BUC/PLIC

SHAD DAIWA TOURNAMENT D.FIN 7.5CM UV REAL MOTOR OIL 10BUC/PLIC

d.16502.708

Livrare imediată!

31,62Lei(-21%) 24,89Lei

MINCIOG DAIWA CROSSCAST 1.80M 100X100CM 1SEG

MINCIOG DAIWA CROSSCAST 1.80M 100X100CM 1SEG

a2.m11561.175

Livrare 48-72 ore

362,53Lei(-12%) 318,90Lei

Mulineta Daiwa BG Monocoque 10000-H 6RUL

Mulineta Daiwa BG Monocoque 10000-H 6RUL

d.10465.100

Livrare 24-48 ore

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

KIT MONTURA DAIWA N'ZON HELI MARIME S 5BUC/PLIC

KIT MONTURA DAIWA N'ZON HELI MARIME S 5BUC/PLIC

a.13308.000

Livrare 24-48 ore

15,18Lei

Lanseta Daiwa Steez AGS 671MHFS 2.13m 7-28g

Lanseta Daiwa Steez AGS 671MHFS 2.13m 7-28g

d.stzags671mhfscf

Livrare 24-48 ore

1.656,42Lei

GEANTA DAIWA TOURNAMENT PRO CARRYALL COOLBAG 46X32X32CM

GEANTA DAIWA TOURNAMENT PRO CARRYALL COOLBAG 46X32X32CM

d.tnpccb2

Livrare 24-48 ore

608,51Lei

Lanseta Feeder Daiwa 3+2seg N'Zon, 3,96m, 80g

Lanseta Feeder Daiwa 3+2seg N'Zon, 3,96m, 80g

d.11330.394

Livrare 24-48 ore

486,08Lei(-20%) 388,86Lei

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

73,71Lei

Vobler Daiwa Steez Crank, White Chart, 5.4cm, 10.1g

Vobler Daiwa Steez Crank, White Chart, 5.4cm, 10.1g

f3.d17510.103

Livrare 24-48 ore

71,11Lei

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

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

d.16504.508

Livrare 24-48 ore

29,60Lei

Afişare 841 - 860 din 1624 (82 pagini)

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

1 (0.070)

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

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

2 (0.109)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.125)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.119)

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

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

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

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

7 (0.129)

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