Mustad

Mustad

Sortare după:

JIG MUSTAD CARLIG BLN NR2/0,14G

JIG MUSTAD CARLIG BLN NR2/0,14G

f2.jig02bln.14

Livrare 24-48 ore

26,86Lei

Carlige Mustad Cristal Auriu 224, 10buc/plic Nr.12

Carlige Mustad Cristal Auriu 224, 10buc/plic Nr.12

m.224.12

Livrare imediată!

7,02Lei

CARLIG MUSTAD NICHEL FORJAT REVERS ROTUND 10 BUC NR.2

CARLIG MUSTAD NICHEL FORJAT REVERS ROTUND 10 BUC NR.2

m.10001bln.2

Livrare imediată!

8,77Lei

Carlige Mustad M32756 Bronz pentru Jig/Twister, Nr.1/0 100buc/plic

Carlige Mustad M32756 Bronz pentru Jig/Twister, Nr.1/0 100buc/plic

m.32756.01

Livrare 24-48 ore

41,13Lei

Carlig Mustad M31380, Forjat cu Tija Scurta, Auriu, 10buc/plic Nr.10

Carlig Mustad M31380, Forjat cu Tija Scurta, Auriu, 10buc/plic Nr.10

m.31380.10

Livrare 24-48 ore

8,63Lei

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

16,86Lei

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(-24%) 32,52Lei

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(-37%) 65,56Lei

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

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

f2.m.bjh60.17.25

Livrare 24-48 ore

122,98Lei(-37%) 76,96Lei

Carlige Mustad Ultrapoint BLN, Nr.4/0, 5buc/pac

Carlige Mustad Ultrapoint BLN, Nr.4/0, 5buc/pac

m.3254npbn.04

Livrare imediată!

12,10Lei

Hanorac Mustad Olive Green, Marime 2XL

Hanorac Mustad Olive Green, Marime 2XL

a8.mctee.mh02.2xl

Livrare 24-48 ore

244,61Lei(-28%) 176,02Lei

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

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

f2.mudjh.bk.1.7.3

Livrare 24-48 ore

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

Agrafa Rapida Mustad Power Lure Snap, 32kg, Nr.2, 10buc/plic

Agrafa Rapida Mustad Power Lure Snap, 32kg, Nr.2, 10buc/plic

a7.dlt10.2

Livrare 24-48 ore

17,58Lei

Pilker MUSTAD Mezashi Jig Slim, True Sardine Glow, 80g, 16.00cm

Pilker MUSTAD Mezashi Jig Slim, True Sardine Glow, 80g, 16.00cm

f.m.lmsj80002

Livrare 24-48 ore

58,91Lei

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

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

m.10301aptx.4

Livrare 24-48 ore

18,17Lei

Geanta MUSTAD Daybreak Dry Waterproof, 50ltr

Geanta MUSTAD Daybreak Dry Waterproof, 50ltr

m.mdbddb50l

Livrare 24-48 ore

381,98Lei

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

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

f.m.msj80002

Livrare 24-48 ore

58,37Lei

Ancora Dubla MUSTAD Frog Trailer Double Hook Strong, Nr.4/0, 2buc/pac

Ancora Dubla MUSTAD Frog Trailer Double Hook Strong, Nr.4/0, 2buc/pac

m.78124apbn.04

Livrare 24-48 ore

37,29Lei

Pilker MUSTAD Baku Squid Jig Long Distance, Scandal Glow, 20g, 10.5cm

Pilker MUSTAD Baku Squid Jig Long Distance, Scandal Glow, 20g, 10.5cm

f.m.bdf035s.001

Livrare 24-48 ore

52,94Lei

Ancora Tripla MUSTAD Nichel Scurta, Nr.6, 6buc/pac

Ancora Tripla MUSTAD Nichel Scurta, Nr.6, 6buc/pac

m.tr78bln.6

Livrare imediată!

22,59Lei

Afişare 781 - 800 din 1084 (55 pagini)

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

1 (0.088)

SELECT data
FROM `oc_session`
WHERE session_id = '9a2278062ac82b6a0ace1084a1'

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

2 (0.106)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.134)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.129)

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.834)

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

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

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

7 (0.138)

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