Mustad

Mustad

Sortare după:

Carlig Mustad Ultrapoint BLN, Nr.1/0, 10buc/pac

Carlig Mustad Ultrapoint BLN, Nr.1/0, 10buc/pac

m.10549npbn.01

Livrare imediată!

8,77Lei

Carlige MUSTAD Round Bend Match MU09, Black Nickel, Nr.10, 10buc/pac

Carlige MUSTAD Round Bend Match MU09, Black Nickel, Nr.10, 10buc/pac

m.60200npbn.10

Livrare imediată!

7,55Lei

PILKER METALIC MUSTAD NALUCA SHIRASU MEZASHI JIG CASTING 15G

PILKER METALIC MUSTAD NALUCA SHIRASU MEZASHI JIG CASTING 15G

f1.m.srs.15

Livrare 24-48 ore

43,00Lei(-24%) 32,52Lei

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

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

f2.m.bjh30.5.25

Livrare 24-48 ore

69,54Lei(-36%) 44,33Lei

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

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

f2.m.bjh60.30.25

Livrare 24-48 ore

161,16Lei(-38%) 100,24Lei

Carlige Mustad Crap XV2 Chodda Ochet Black Nikel, Nr.10, 10buc/pac

Carlige Mustad Crap XV2 Chodda Ochet Black Nikel, Nr.10, 10buc/pac

m.60554nptx.10

Livrare imediată!

15,66Lei(-33%) 10,56Lei

Carlige Mustad Ultrapoint BLN, Nr.6, 10buc/pac

Carlige Mustad Ultrapoint BLN, Nr.6, 10buc/pac

m.3254npbn.6

Livrare 24-48 ore

13,02Lei

Fir Textil Mustad Qlink Braid, Charteuse, 0.14mm, 6.8kg, 150m

Fir Textil Mustad Qlink Braid, Charteuse, 0.14mm, 6.8kg, 150m

m.ml95.qb15.165c

Livrare 24-48 ore

74,78Lei(-26%) 55,14Lei

Carlige MUSTAD Alpha Specimen, Nr.10, 12buc/pac

Carlige MUSTAD Alpha Specimen, Nr.10, 12buc/pac

m.10303aptx.10

Livrare imediată!

17,27Lei

Ancora Tripla MUSTAD Grip Treble Steel ITG58, Nr.6, 6buc/pac

Ancora Tripla MUSTAD Grip Treble Steel ITG58, Nr.6, 6buc/pac

m.itg58apts.6

Livrare 24-48 ore

34,45Lei

Jig MUSTAD F2 Nr.5/0, 5g, 6buc/pac

Jig MUSTAD F2 Nr.5/0, 5g, 6buc/pac

f2.m.bjh50.5.6

Livrare imediată!

23,30Lei(-10%) 20,87Lei

Carlige MUSTAD Chebu Squared Ochi Titan, Nr.2, 10buc/pac

Carlige MUSTAD Chebu Squared Ochi Titan, Nr.2, 10buc/pac

m.3256ap.tx.2

Livrare imediată!

14,96Lei

Carlige MUSTAD Ultrapoint Iseama Twist 10902SPBN, Nr.4, 10buc/pac

Carlige MUSTAD Ultrapoint Iseama Twist 10902SPBN, Nr.4, 10buc/pac

m.10902spbn.4

Livrare imediată!

8,77Lei

Vartej Mustad Nr 10 31 KG 10Buc

Vartej Mustad Nr 10 31 KG 10Buc

a7.ma025bn.14

Livrare imediată!

8,00Lei

Carlige Mustad Crap XV2 Chodda Ochet Black Nikel, Nr.4, 10buc/pac

Carlige Mustad Crap XV2 Chodda Ochet Black Nikel, Nr.4, 10buc/pac

m.60554nptx.4

Livrare imediată!

15,66Lei(-33%) 10,56Lei

VARTEJ CU INELE SI RULMENT MUSTAD NR.2/20KG/4BUC

VARTEJ CU INELE SI RULMENT MUSTAD NR.2/20KG/4BUC

a7.ma029bn.2

Livrare 24-48 ore

11,01Lei

ANCORE MUSTAD BLACK NICKEL NR.2

ANCORE MUSTAD BLACK NICKEL NR.2

m.35647bln.2

Livrare imediată!

21,65Lei

MANUSI MUSTAD SUN MAR.XL

MANUSI MUSTAD SUN MAR.XL

a8.gl003.xl

Livrare 24-48 ore

90,28Lei

Carlige Mustad Cristal Nichel, Revers 221C, 10buc/plic Nr.10

Carlige Mustad Cristal Nichel, Revers 221C, 10buc/plic Nr.10

m.221c.10

Livrare 24-48 ore

8,31Lei

CARLIG MUSTAD BRONZ FORJAT PT. MUSCA NR.20

CARLIG MUSTAD BRONZ FORJAT PT. MUSCA NR.20

m.r50.94840.20

Livrare 24-48 ore

22,66Lei(-31%) 15,74Lei

Afişare 841 - 860 din 1084 (55 pagini)

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

1 (0.074)

SELECT data
FROM `oc_session`
WHERE session_id = '26e7ee29293a9aaf1145655bbe'

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

2 (0.116)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.137)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.131)

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

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

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

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

7 (0.131)

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