Mustad

Mustad

Sortare după:

Jig Mustad F2 Nr.3/0, 12g, 25buc/pac

Jig Mustad F2 Nr.3/0, 12g, 25buc/pac

f2.m.bjh30.12.25

Livrare 24-48 ore

90,40Lei(-37%) 57,08Lei

Jig Mustad F2 Nr.6/0, 12g, 25buc/pac

Jig Mustad F2 Nr.6/0, 12g, 25buc/pac

f2.m.bjh60.12.25

Livrare 24-48 ore

107,85Lei(-37%) 67,71Lei

Jig Mustad F2 Nr.3/0, 7g, 5buc/pac

Jig Mustad F2 Nr.3/0, 7g, 5buc/pac

f2.m.bjh30.7.5

Livrare 24-48 ore

19,51Lei(-9%) 17,77Lei

Jig Lestat Mustad Ultra Drive, 10gr, Nr.1/0, 3buc/plic

Jig Lestat Mustad Ultra Drive, 10gr, Nr.1/0, 3buc/plic

f2.mudjh.bk.01.10.3

Livrare 24-48 ore

35,49Lei(-34%) 23,56Lei

Agrafa Rapida Mustad Power Lure Snap, 28kg, Nr.1, 10buc/plic

Agrafa Rapida Mustad Power Lure Snap, 28kg, Nr.1, 10buc/plic

a7.dlt10.1

Livrare 24-48 ore

17,58Lei

Pilker MUSTAD Mezashi Jig Slim, True Sardine Glow, 40g, 12.80cm

Pilker MUSTAD Mezashi Jig Slim, True Sardine Glow, 40g, 12.80cm

f.m.lmsj40002

Livrare 24-48 ore

51,32Lei

Carlige MUSTAD Alpha Wormer, Nr.1, 10buc/pac

Carlige MUSTAD Alpha Wormer, Nr.1, 10buc/pac

m.10301aptx.1

Livrare 24-48 ore

18,17Lei

Pilker MUSTAD Jig Mirotic Slow, Happy Squid, 8cm, 80g

Pilker MUSTAD Jig Mirotic Slow, Happy Squid, 8cm, 80g

f.m.msj80006

Livrare 24-48 ore

58,37Lei

Fir Monofilament MUSTAD Thor Super Soft, Clear, 100m, 0.80mm, 36.0kg

Fir Monofilament MUSTAD Thor Super Soft, Clear, 100m, 0.80mm, 36.0kg

m.hssmc100.080.cl

Livrare imediată!

49,61Lei

Pilker MUSTAD Baku Squid Jig Long Distance, Scandal Glow, 12g, 7.5cm

Pilker MUSTAD Baku Squid Jig Long Distance, Scandal Glow, 12g, 7.5cm

f.m.bdf025s.001

Livrare 24-48 ore

46,16Lei

Ancora Tripla MUSTAD Nichel Rotunda, Nr.4, 25buc/pac

Ancora Tripla MUSTAD Nichel Rotunda, Nr.4, 25buc/pac

m.71893bn.4

Livrare imediată!

34,93Lei

Carlige MUSTAD Ultrapoint Carp Power 10657BLN, Eyed Barbed, Nr.16, 10buc/pac

Carlige MUSTAD Ultrapoint Carp Power 10657BLN, Eyed Barbed, Nr.16, 10buc/pac

m.10657npbln.16

Livrare imediată!

8,77Lei

AGRAFA MUSTAD DUO LOCK NR.1/55KG/10BUC

AGRAFA MUSTAD DUO LOCK NR.1/55KG/10BUC

a7.ma028bn.1

Livrare imediată!

8,35Lei

VARTEJ MUSTAD CU RULMENT NR.0/11KG/4BUC

VARTEJ MUSTAD CU RULMENT NR.0/11KG/4BUC

a7.ma029bn.0

Livrare imediată!

11,01Lei

Carlige Mustad Demon Circle BN Nr.1/0 7buc

Carlige Mustad Demon Circle BN Nr.1/0 7buc

m.39951npbn.01

Livrare imediată!

16,86Lei

MANUSI MUSTAD LANDING MAR.XL

MANUSI MUSTAD LANDING MAR.XL

a8.gl001.xl

Livrare 24-48 ore

106,92Lei(-27%) 78,01Lei

Carlige pentru Musca Mustad Bronz Forjat, Nr.8

Carlige pentru Musca Mustad Bronz Forjat, Nr.8

m.r43.94831.8

Livrare imediată!

18,23Lei(-22%) 14,21Lei

Carlig Mustad Power Baitholder Forjat, 2 Spini, Bronz, 10buc/plic Nr.1

Carlig Mustad Power Baitholder Forjat, 2 Spini, Bronz, 10buc/plic Nr.1

m.5933br.1

Livrare 24-48 ore

10,82Lei

Carlig Mustad M1799D cu Tija Lunga si Protectie Anticoroziva Nr.4

Carlig Mustad M1799D cu Tija Lunga si Protectie Anticoroziva Nr.4

m.1799d.4

Livrare 24-48 ore

32,07Lei

Carlige Mustad Offset Lestate Power Lock Plus pentru Twister, Nr.3/0 3buc/plic

Carlige Mustad Offset Lestate Power Lock Plus pentru Twister, Nr.3/0 3buc/plic

m.91768ub18.03

Livrare 24-48 ore

40,60Lei

Afişare 741 - 760 din 1084 (55 pagini)

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

1 (0.080)

SELECT data
FROM `oc_session`
WHERE session_id = '20693b54530978315b46d04068'

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

2 (0.201)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.162)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.169)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '20' AND m2s.store_id = '3'

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

5 (34.130)

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

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

6 (45.616)

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 = '20' 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.131)

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