Mustad

Mustad

Sortare după:

Taparine MUSTAD Multi Colour Shrimps Sabiki Rig Nr.3, Carlige Nr.6, 4buc/pac

Taparine MUSTAD Multi Colour Shrimps Sabiki Rig Nr.3, Carlige Nr.6, 4buc/pac

m.cl.rig3.6

Livrare 24-48 ore

8,73Lei

VARTEJ TRIPLU MUSTAD NR.12/10KG/10BUC

VARTEJ TRIPLU MUSTAD NR.12/10KG/10BUC

a7.ma024bn.12

Livrare imediată!

8,94Lei

CARLIG MUSTAD BRONZ FORJAT PT. MUSCA MODEL94833 NR14

CARLIG MUSTAD BRONZ FORJAT PT. MUSCA MODEL94833 NR14

m.r30.94833.14

Livrare imediată!

15,41Lei

Carlige Offset Mustad Ultrapoint Black Nickel NR.5/0

Carlige Offset Mustad Ultrapoint Black Nickel NR.5/0

m.38104npbn.05

Livrare imediată!

14,68Lei

Ancora Mustad Tripla , Bronz, Nr.6 25buc/plic

Ancora Mustad Tripla , Bronz, Nr.6 25buc/plic

m.3551.6

Livrare imediată!

31,13Lei

Carlig Mustad Ultrapoint BLN, Nr.12, 10buc/pac

Carlig Mustad Ultrapoint BLN, Nr.12, 10buc/pac

m.10549npbn.1

Livrare 24-48 ore

7,64Lei

Carlig Mustad Forjat BLN Power Maggot, 10buc/plic Nr.14

Carlig Mustad Forjat BLN Power Maggot, 10buc/plic Nr.14

m.10515bln.14

Livrare imediată!

6,44Lei

Ancora Tripla Scurta Mustad TR58BLN, Nichel, Nr.2 6buc/plic

Ancora Tripla Scurta Mustad TR58BLN, Nichel, Nr.2 6buc/plic

m.tr58bln.2

Livrare 24-48 ore

21,23Lei

Carlige Mustad Micro Jig Dublu Spin 32891 nr.4 (100b)

Carlige Mustad Micro Jig Dublu Spin 32891 nr.4 (100b)

m.32891npbn.4

Livrare imediată!

50,49Lei

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

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

m.32756.03

Livrare imediată!

43,61Lei

TAPARINA MUSTAD RAINBOW FLASHER NR.6 5BUC/PLIC

TAPARINA MUSTAD RAINBOW FLASHER NR.6 5BUC/PLIC

m.cl.rig15.6

Livrare 24-48 ore

9,03Lei

TAPARINA MUSTAD PISCATOR NR.5 6BUC/PLIC

TAPARINA MUSTAD PISCATOR NR.5 6BUC/PLIC

m.cl.rig5.8

Livrare 24-48 ore

9,03Lei

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

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

f2.m.bjh1.10.25

Livrare 24-48 ore

77,71Lei(-40%) 46,62Lei

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

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

f2.m.bjh40.15.25

Livrare 24-48 ore

103,21Lei(-40%) 61,93Lei

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

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

m.jl73npts.2

Livrare imediată!

35,66Lei

Jig Mustad Carlig Nr.4, 5g, 6buc/pac

Jig Mustad Carlig Nr.4, 5g, 6buc/pac

f2.m.bjh4.5.6

Livrare imediată!

18,78Lei(-20%) 15,02Lei

Grub Mustad Aji Micro Fla, White Glow Glitter, 5cm, 15buc/pac

Grub Mustad Aji Micro Fla, White Glow Glitter, 5cm, 15buc/pac

f1.m.fla2007

Livrare 24-48 ore

19,17Lei(-20%) 15,34Lei

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.14mm, 6.8kg, 150m

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.14mm, 6.8kg, 150m

m.ml98.dpb15.165c

Livrare 24-48 ore

110,36Lei(-30%) 77,52Lei

Carlige Mustad Ruthless Momeala Vie, Nr.2/0, 6buc/plic

Carlige Mustad Ruthless Momeala Vie, Nr.2/0, 6buc/plic

m.10851ap.ts.02

Livrare 24-48 ore

20,55Lei

Carlige Mustad Chinu Light Ochi Titan Alpha Point Nr.2/0, 10buc/pac

Carlige Mustad Chinu Light Ochi Titan Alpha Point Nr.2/0, 10buc/pac

m.10021ap.tx.02

Livrare imediată!

15,72Lei

Afişare 441 - 460 din 1079 (54 pagini)

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

1 (0.118)

SELECT data
FROM `oc_session`
WHERE session_id = '7fbf339c747032689bba1d0641'

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

2 (0.090)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.115)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.114)

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 = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (45.965)

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 = '0' AND p.manufacturer_id = '20'

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

6 (54.335)

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 = '0' AND p.manufacturer_id = '20' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 440,20

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

7 (0.203)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37