Mustad

Mustad

Sortare după:

Carlig Mustad Carp Power 10829 Nr.6, 10buc/pac

Carlig Mustad Carp Power 10829 Nr.6, 10buc/pac

m.10829blm.6

Livrare imediată!

14,87Lei

Carlige MUSTAD Ultrapoint Eyed Nickel 10019BLN, Nr.3/0, 10buc/pac

Carlige MUSTAD Ultrapoint Eyed Nickel 10019BLN, Nr.3/0, 10buc/pac

m.10019bln.03

Livrare 24-48 ore

10,82Lei

Ancora Mustad Tripla , Bronz, Nr.5/0 25buc/plic

Ancora Mustad Tripla , Bronz, Nr.5/0 25buc/plic

m.3551.05

Livrare 24-48 ore

94,73Lei

Carlig Mustad Feeder MU11, Nickel, 10buc/plic Nr.12

Carlig Mustad Feeder MU11, Nickel, 10buc/plic Nr.12

m.60332n.12

Livrare imediată!

7,55Lei

CARLIG MUSTAD BRONZ FORJAT CIOC PAPAGAL Nr.6

CARLIG MUSTAD BRONZ FORJAT CIOC PAPAGAL Nr.6

m.530.6

Livrare 24-48 ore

7,54Lei

MUSCA MUSTAD INT. ARTIF.PE CIRLIG NR.8

MUSCA MUSTAD INT. ARTIF.PE CIRLIG NR.8

f3.mus08

Livrare imediată!

9,63Lei

Carlig Mustad Negru Nichel M10829BLN Crap nr.1

Carlig Mustad Negru Nichel M10829BLN Crap nr.1

m.10829bln.1

Livrare 24-48 ore

17,00Lei

CARLIG MUSTAD PT.TWISTER 3/0 100buc.

CARLIG MUSTAD PT.TWISTER 3/0 100buc.

m.32631npbn.03

Livrare 24-48 ore

74,94Lei

TAPARINA MUSTAD MINI HOKKAI NR.4 6BUC/PLIC

TAPARINA MUSTAD MINI HOKKAI NR.4 6BUC/PLIC

m.cl.rig19.4

Livrare imediată!

10,67Lei(-18%) 8,75Lei

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

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

m.60552nptx.2

Livrare 24-48 ore

11,47Lei

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(-37%) 49,33Lei

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(-37%) 64,89Lei

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

37,26Lei

Jig Mustad Carlig Nr.6, 3g, 6buc/pac

Jig Mustad Carlig Nr.6, 3g, 6buc/pac

f2.m.bjh6.3.6

Livrare imediată!

17,47Lei(-13%) 15,21Lei

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

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

f1.m.fla2008

Livrare 24-48 ore

19,17Lei(-9%) 17,51Lei

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.16mm, 8.2kg, 150m

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.16mm, 8.2kg, 150m

m.ml98.dpb18.165c

Livrare 24-48 ore

110,36Lei(-27%) 80,74Lei

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

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

m.10851ap.ts.03

Livrare 24-48 ore

22,81Lei

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

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

m.10021ap.tx.1

Livrare imediată!

16,98Lei

Carlige MUSTAD Ultra Nor Jigging, Nr.4/0, 5buc/pac

Carlige MUSTAD Ultra Nor Jigging, Nr.4/0, 5buc/pac

m.10881unts.04

Livrare 24-48 ore

28,65Lei

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

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

m.itg77apts.2

Livrare imediată!

33,54Lei

Afişare 681 - 700 din 1085 (55 pagini)

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

1 (0.127)

SELECT data
FROM `oc_session`
WHERE session_id = '062227f2af752416e28d36c1b6'

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

2 (0.089)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.130)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Mustad'

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

4 (0.120)

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

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

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

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

7 (0.158)

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