Asso


Fir ASSO Ultra Cast Galben Fluo 0.24mm 1000m

Fir ASSO Ultra Cast Galben Fluo 0.24mm 1000m

607080032
Livrare imediată!

59,17Lei

Fir ASSO Evergreen PE 8X Verde 0.50mm 130m

Fir ASSO Evergreen PE 8X Verde 0.50mm 130m

608080011
Livrare imediată!

100,43Lei

Fir ASSO Ultra Low Stretch Smoke 0.14mm 50m

Fir ASSO Ultra Low Stretch Smoke 0.14mm 50m

604080043
Livrare imediată!

13,83Lei

Fir Asso Invisilk Yellow 0.24mm 300m

Fir Asso Invisilk Yellow 0.24mm 300m

602080092
Livrare imediată!

34,24Lei

Fir Asso New Micron 3 Clear 0.173mm 100m 2.8kg -24%

Fir Asso New Micron 3 Clear 0.173mm 100m 2.8kg

111108214
Livrare imediată!

38,57Lei(-24%) 29,37Lei

Fir ASSO Ultra Cast Galben Fluo 0.20mm

Fir ASSO Ultra Cast Galben Fluo 0.20mm

602080006
Livrare imediată!

30,73Lei

ASSO HARD SKIN Solid Red 0.26mm 9 Lb 1900m

ASSO HARD SKIN Solid Red 0.26mm 9 Lb 1900m

607080052
Livrare imediată!

83,51Lei

Fir ASSO Ultra Transparent 0.08mm 100m

Fir ASSO Ultra Transparent 0.08mm 100m

604080001
Livrare 48-72 ore

21,56Lei

Fir Asso Invisilk Pink 0.24 mm 150 m

Fir Asso Invisilk Pink 0.24 mm 150 m

603080036
Livrare imediată!

18,89Lei

Fir Asso Trout Area Fluorocarbon White 0.104mm 100m -40%

Fir Asso Trout Area Fluorocarbon White 0.104mm 100m

111108302
Livrare imediată!

56,64Lei(-40%) 34,27Lei

Fir Asso Fluorocarbon Hooklink 20m 0.326mm 9.1kg Clear

Fir Asso Fluorocarbon Hooklink 20m 0.326mm 9.1kg Clear

110108ffasdi138bm0020000326
Livrare 48-72 ore

33,71Lei

Fir ASSO Ultra Cast Galben Fluo 0.18mm 150m

Fir ASSO Ultra Cast Galben Fluo 0.18mm 150m

603080013
Livrare 48-72 ore

21,11Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.30mm 1200m

Fir ASSO Ultra Molecular Shield Dark Green 0.30mm 1200m

602080024
Livrare imediată!

109,18Lei

Fir ASSO Ultra Molecular Shield White 0.24mm 150m

Fir ASSO Ultra Molecular Shield White 0.24mm 150m

604080052
Livrare 48-72 ore

24,47Lei

Fir ASSO Fluorocarbon Invisible Clear 0.30mm 50m

Fir ASSO Fluorocarbon Invisible Clear 0.30mm 50m

605080009
Livrare imediată!

46,78Lei

Fir Asso Ultra Cast Orange 0.28mm 300m

Fir Asso Ultra Cast Orange 0.28mm 300m

11010830028
Livrare imediată!

36,13Lei

FIR MONOFILAMENT ASSO ULTRA MOLECULAR SHIELD - Dark Green 0.24mm 150m 8.1Kg

FIR MONOFILAMENT ASSO ULTRA MOLECULAR SHIELD - Dark Green 0.24mm 150m 8.1Kg

604080025
Livrare imediată!

24,47Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.24mm 300m

Fir ASSO Ultra Molecular Shield Dark Green 0.24mm 300m

602080010
Livrare imediată!

39,49Lei

Fir ASSO Sinking 3X Feeder Brown 0.134mm

Fir ASSO Sinking 3X Feeder Brown 0.134mm

604080030
Livrare 48-72 ore

37,01Lei

Fir ASSO Ultra Low Stretch Smoke 0.16mm 150m

Fir ASSO Ultra Low Stretch Smoke 0.16mm 150m

607080012
Livrare imediată!

33,07Lei

Afişare 141 - 160 din 291 (15 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 66.841 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = '4b38a67ff15b028a76ddc2dfd3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/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 = '129' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.529)
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 = '129'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (30.648)
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 = '129' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.190)
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