Mustad

Mustad

Sortare după:

Agrafa Mustad cu Vartej Power Screw, Nr.8, 19kg, 8buc/plic

Agrafa Mustad cu Vartej Power Screw, Nr.8, 19kg, 8buc/plic

a7.dlt07.8

Livrare 24-48 ore

21,57Lei(-20%) 17,27Lei

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

51,32Lei

Carlige MUSTAD Alpha Wormer, Nr.1, 10buc/pac

Carlige MUSTAD Alpha Wormer, Nr.1, 10buc/pac

m.10301aptx.1

Livrare 24-48 ore

18,17Lei

Pilker MUSTAD Jig Mirotic Slow, Happy Squid, 8cm, 80g

Pilker MUSTAD Jig Mirotic Slow, Happy Squid, 8cm, 80g

f.m.msj80006

Livrare 24-48 ore

58,37Lei

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

49,61Lei

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

46,16Lei

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

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

m.71893bn.4

Livrare imediată!

34,93Lei

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

AGRAFA MUSTAD DUO LOCK NR.1/55KG/10BUC

AGRAFA MUSTAD DUO LOCK NR.1/55KG/10BUC

a7.ma028bn.1

Livrare imediată!

8,35Lei

VARTEJ MUSTAD CU RULMENT NR.0/11KG/4BUC

VARTEJ MUSTAD CU RULMENT NR.0/11KG/4BUC

a7.ma029bn.0

Livrare imediată!

11,01Lei

Carlige Mustad Demon Circle BN Nr.1/0 7buc

Carlige Mustad Demon Circle BN Nr.1/0 7buc

m.39951npbn.01

Livrare imediată!

16,86Lei

MANUSI MUSTAD LANDING MAR.XL

MANUSI MUSTAD LANDING MAR.XL

a8.gl001.xl

Livrare 24-48 ore

106,92Lei(-27%) 78,01Lei

Carlige pentru Musca Mustad Bronz Forjat, Nr.8

Carlige pentru Musca Mustad Bronz Forjat, Nr.8

m.r43.94831.8

Livrare imediată!

18,23Lei(-22%) 14,21Lei

MUSCA MUSTAD INT. ARTIF.PE CIRLIG NR.12

MUSCA MUSTAD INT. ARTIF.PE CIRLIG NR.12

f3.mus12

Livrare imediată!

8,72Lei

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

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

m.31380.2

Livrare 24-48 ore

8,63Lei

CARLIG MUSTAD PT.TWISTER 5/0 100buc.

CARLIG MUSTAD PT.TWISTER 5/0 100buc.

m.32631npbn.05

Livrare 24-48 ore

94,36Lei

TAPARINA MUSTAD LUMINOUS SHRIMP NR.6 4BUC/PLIC

TAPARINA MUSTAD LUMINOUS SHRIMP NR.6 4BUC/PLIC

m.cl.rig4.6

Livrare imediată!

11,10Lei

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

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

f2.m.bjh1.5.25

Livrare 24-48 ore

63,25Lei(-36%) 40,50Lei

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

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

f2.m.bjh40.20.25

Livrare 24-48 ore

118,33Lei(-37%) 74,11Lei

Ancora Tripla Mustad Titan Steel 3X, Nr.6, 6buc/pac

Ancora Tripla Mustad Titan Steel 3X, Nr.6, 6buc/pac

m.jl73npts.6

Livrare imediată!

37,26Lei

Afişare 801 - 820 din 1084 (55 pagini)

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

1 (0.089)

SELECT data
FROM `oc_session`
WHERE session_id = '1a2f14f792ea87dec91bb13150'

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

2 (0.094)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.108)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.085)

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

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

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

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

7 (0.147)

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