Mustad

Mustad

Sortare după:

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

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

f2.m.bjh30.7.25

Livrare 24-48 ore

75,40Lei(-36%) 47,92Lei

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

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

f2.m.bjh60.5.25

Livrare 24-48 ore

84,66Lei(-37%) 53,57Lei

Creatura Mustad Mezashi Rock Lobster, Clear Magic, 7.5cm, 6g, 6buc/pac

Creatura Mustad Mezashi Rock Lobster, Clear Magic, 7.5cm, 6g, 6buc/pac

f1.m.mrl.clm.3.6

Livrare 24-48 ore

28,97Lei(-22%) 22,54Lei

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

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

m.60554nptx.8

Livrare imediată!

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

Jig Head Mustad Finesse Nr.6, 0.8g, 5buc/pac

Jig Head Mustad Finesse Nr.6, 0.8g, 5buc/pac

f2.m.jgr.0.8

Livrare imediată!

23,12Lei

Fir Textil Mustad Qlink Braid, Charteuse, 0.16mm, 8.2kg, 150m

Fir Textil Mustad Qlink Braid, Charteuse, 0.16mm, 8.2kg, 150m

m.ml95.qb18.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

Agrafa + Vartej Mustad Nr 10 31Kg 10Buc

Agrafa + Vartej Mustad Nr 10 31Kg 10Buc

a7.ma026bn.10

Livrare imediată!

11,01Lei

CARLIGE MUSTAD CARP XV2 CHODDA NR 6 10BUC

CARLIGE MUSTAD CARP XV2 CHODDA NR 6 10BUC

m.60554nptx.6

Livrare imediată!

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

ANCORA MUSTAD TRIPLA NICHEL SCURTA 1/0 5BUC/PL

ANCORA MUSTAD TRIPLA NICHEL SCURTA 1/0 5BUC/PL

m.tr78bln.01

Livrare 24-48 ore

25,86Lei

JIG CARLIG MUSTAD NR 2/0 12G

JIG CARLIG MUSTAD NR 2/0 12G

f2.jig02.12

Livrare 24-48 ore

25,01Lei

JIG MUSTAD CARLIG BLN NR4/0,17G

JIG MUSTAD CARLIG BLN NR4/0,17G

f2.jig04bln.17

Livrare 24-48 ore

36,77Lei

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

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

m.496.6

Livrare imediată!

8,77Lei

CARLIG MUSTAD BR FORJAT TIJA LUNGA CURBA PT. MUSCA nr.12

CARLIG MUSTAD BR FORJAT TIJA LUNGA CURBA PT. MUSCA nr.12

m.c53s.12

Livrare imediată!

19,55Lei

CARLIG MUSTAD BRONZ FORJAT CIOC PAPAGAL Nr.5/0

CARLIG MUSTAD BRONZ FORJAT CIOC PAPAGAL Nr.5/0

m.530.05

Livrare 24-48 ore

24,62Lei

JIG MUSTAD CARLIG BLN NR 4/0 9G 10Buc/plic

JIG MUSTAD CARLIG BLN NR 4/0 9G 10Buc/plic

f2.jig04bln.9

Livrare imediată!

34,33Lei

Afişare 721 - 740 din 1085 (55 pagini)

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

1 (0.168)

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

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

2 (0.155)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.251)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.202)

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

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

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

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

7 (0.106)

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