Mustad

Mustad

Sortare după:

Carlige Mustad M32629 BLN pentru Jig/Twister, Nr.5/0 100buc/plic

Carlige Mustad M32629 BLN pentru Jig/Twister, Nr.5/0 100buc/plic

m.32629bln.05

Livrare 24-48 ore

100,05Lei

Carlige Mustad TitanX Wacky Neko Streamer nr.2 10buc

Carlige Mustad TitanX Wacky Neko Streamer nr.2 10buc

m.60403nptx.2

Livrare 24-48 ore

15,69Lei

PILKER METALIC MUSTAD NALUCA RED GOLD MEZASHI JIG CASTING 15G

PILKER METALIC MUSTAD NALUCA RED GOLD MEZASHI JIG CASTING 15G

f1.m.rdg.15

Livrare 24-48 ore

43,00Lei(-47%) 22,86Lei

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

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

f2.m.bjh30.17.25

Livrare 24-48 ore

104,31Lei(-48%) 54,03Lei

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

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

f2.m.bjh60.20.25

Livrare 24-48 ore

131,03Lei(-48%) 67,61Lei

Carlige Mustad Ultrapoint BLN, Nr.2/0, 7buc/pac

Carlige Mustad Ultrapoint BLN, Nr.2/0, 7buc/pac

m.3254npbn.02

Livrare imediată!

12,10Lei

Hanorac Mustad Olive Green, Marime XL

Hanorac Mustad Olive Green, Marime XL

a8.mctee.mh02.xl

Livrare 24-48 ore

244,61Lei(-49%) 125,36Lei

Agrafa Mustad Tak-Clip, Marime M, 18kg, 10buc/pac

Agrafa Mustad Tak-Clip, Marime M, 18kg, 10buc/pac

a7.dlt11.m

Livrare 24-48 ore

17,25Lei(-43%) 9,76Lei

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(-46%) 19,05Lei

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

16,41Lei

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

49,59Lei

Carlige MUSTAD Alpha Wormer, Nr.2, 12buc/pac

Carlige MUSTAD Alpha Wormer, Nr.2, 12buc/pac

m.10301aptx.2

Livrare 24-48 ore

17,00Lei

Geanta MUSTAD Daybreak Dry Waterproof, 28ltr

Geanta MUSTAD Daybreak Dry Waterproof, 28ltr

m.mdbdbb28l

Livrare 24-48 ore

350,75Lei(-21%) 278,38Lei

Pilker MUSTAD Jig Mirotic Slow, Pink Glow, 8cm, 80g

Pilker MUSTAD Jig Mirotic Slow, Pink Glow, 8cm, 80g

f.m.msj80003

Livrare 24-48 ore

56,52Lei

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

47,92Lei

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

44,52Lei

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

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

m.71893bn.4

Livrare imediată!

34,36Lei

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,64Lei

AGRAFA MUSTAD DUO LOCK+VARTEJ NR.10/20KG/10BUC

AGRAFA MUSTAD DUO LOCK+VARTEJ NR.10/20KG/10BUC

a7.ma034bn.10

Livrare imediată!

9,93Lei

PRINDERE RAPIDA MUSTAD PENTRU NALUCI MICI 25BUC/PL

PRINDERE RAPIDA MUSTAD PENTRU NALUCI MICI 25BUC/PL

a7.77145.2

Livrare imediată!

15,21Lei

Afişare 981 - 1000 din 1119 (56 pagini)

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

1 (0.190)

SELECT data
FROM `oc_session`
WHERE session_id = '9523aa8da111468032bac222a3'

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

2 (0.098)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.110)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.126)

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

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

5 (38.622)

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 = '2' AND p.manufacturer_id = '20'

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

6 (51.731)

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 = '2' AND p.manufacturer_id = '20' 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.143)

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

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