Mustad

Mustad

Sortare după:

Carlig Mustad Power Allround, Cioc de Papagal, Nichel, 10buc/plic Nr.8

Carlig Mustad Power Allround, Cioc de Papagal, Nichel, 10buc/plic Nr.8

m.60151npbln.8

Livrare 24-48 ore

8,72Lei

Carlig Mustad 1251C cu Tija Lunga si Protectie Anticoroziva Nr.1/0

Carlig Mustad 1251C cu Tija Lunga si Protectie Anticoroziva Nr.1/0

m.1251c.01

Livrare 24-48 ore

34,05Lei

CARLIG MUSTAD NEGRU NI TIJA LUNGA CU SIGURANTA Nr. 1/0

CARLIG MUSTAD NEGRU NI TIJA LUNGA CU SIGURANTA Nr. 1/0

m.w3261bln.01

Livrare 24-48 ore

12,57Lei(-21%) 9,95Lei

MUSCA MUSTAD ARTIF. PE CARLIG NR.20

MUSCA MUSTAD ARTIF. PE CARLIG NR.20

f3.mus20

Livrare imediată!

8,72Lei

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

Naluca Mustad Aji Micro Bachi Clear Red Glitter 5cm 15+1buc

Naluca Mustad Aji Micro Bachi Clear Red Glitter 5cm 15+1buc

f1.m.bci2003

Livrare 24-48 ore

20,17Lei

CARLIGE MUSTAD CRAP XV2 WEED CU OCHET NICHEL NEGRU NR.1 10BUC/PL

CARLIGE MUSTAD CRAP XV2 WEED CU OCHET NICHEL NEGRU NR.1 10BUC/PL

m.60562nptx.1

Livrare imediată!

15,66Lei(-43%) 8,97Lei

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

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

f2.m.bjh20.17.25

Livrare 24-48 ore

101,99Lei(-48%) 52,85Lei

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

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

f2.m.bjh60.10.25

Livrare 24-48 ore

101,99Lei(-48%) 52,85Lei

Carlige Mustad Ultrapoint Ochet Offset Nr.4, 10buc/pac

Carlige Mustad Ultrapoint Ochet Offset Nr.4, 10buc/pac

m.37177npbn.4

Livrare 24-48 ore

15,69Lei

Jig Mustad F2 Nr.4, 3g, 6buc/pac

Jig Mustad F2 Nr.4, 3g, 6buc/pac

f2.m.bjh4.3.6

Livrare imediată!

16,76Lei(-13%) 14,64Lei

Jig Lestat Mustad Ultra Drive, 5gr, Nr.1/0, 4buc/plic

Jig Lestat Mustad Ultra Drive, 5gr, Nr.1/0, 4buc/plic

f2.mudjh.bk.01.5.4

Livrare 24-48 ore

35,49Lei(-46%) 19,05Lei

Pilker MUSTAD Mezashi Jig Slim, Sand Eel Glow, 40g, 12.80cm

Pilker MUSTAD Mezashi Jig Slim, Sand Eel Glow, 40g, 12.80cm

f.m.lmsj40003

Livrare 24-48 ore

49,59Lei

Carlige Offset MUSTAD Assault Finesse, Nr.2/0, 7buc/pac

Carlige Offset MUSTAD Assault Finesse, Nr.2/0, 7buc/pac

m.38140aptx.02

Livrare 24-48 ore

20,57Lei(-25%) 15,40Lei

Jig MUSTAD Alphapoint Ned Jig Head, Nr.1, 3.5g, 20buc/pac

Jig MUSTAD Alphapoint Ned Jig Head, Nr.1, 3.5g, 20buc/pac

f2.m.njh32880ap1.3.5

Livrare 24-48 ore

53,32Lei

Pilker MUSTAD Baku Squid Jig Long Distance, Energy Chartreuse, 18g, 9.0cm

Pilker MUSTAD Baku Squid Jig Long Distance, Energy Chartreuse, 18g, 9.0cm

f.m.bdf030s.007

Livrare 24-48 ore

48,69Lei

Carlige MUSTAD Alpha Point Pin, Nr.12, 10buc/pac

Carlige MUSTAD Alpha Point Pin, Nr.12, 10buc/pac

m.10304aptx.12

Livrare imediată!

17,00Lei

Carlig MUSTAD Ultrapoint M496, Forjat Revers Rotund, Bleu, Nr.3, 10buc/plic

Carlig MUSTAD Ultrapoint M496, Forjat Revers Rotund, Bleu, Nr.3, 10buc/plic

m.496.3

Livrare imediată!

5,30Lei

Carlige MUSTAD 92554NPNR Ultrapoint Beak Bait Heavy Big Red Nr.5/0, 7buc/pac

Carlige MUSTAD 92554NPNR Ultrapoint Beak Bait Heavy Big Red Nr.5/0, 7buc/pac

m.92554npnr.05

Livrare 24-48 ore

12,89Lei

Agrafa + Vartej Mustad Nr 10 31Kg 10Buc

Agrafa + Vartej Mustad Nr 10 31Kg 10Buc

a7.ma026bn.10

Livrare imediată!

9,93Lei

Afişare 601 - 620 din 1136 (57 pagini)

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

1 (0.098)

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

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

2 (0.083)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.131)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.092)

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

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

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

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

7 (0.141)

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