Asso


FIR MONOFILAMENT ASSO ULTRA MOLECULAR SHIELD - Dark Green 0.20mm 150m 6.2Kg

FIR MONOFILAMENT ASSO ULTRA MOLECULAR SHIELD - Dark Green 0.20mm 150m 6.2Kg

604080023
Livrare 48-72 ore

22,00Lei

Fir ASSO Ultra Cast Galben Fluo 0.30mm 1000m

Fir ASSO Ultra Cast Galben Fluo 0.30mm 1000m

607080035
Livrare imediată!

73,89Lei

Fir ASSO Ultra Cast Verde Fluo 0.24mm 150m

Fir ASSO Ultra Cast Verde Fluo 0.24mm 150m

603080007
Livrare imediată!

18,73Lei

Fir ASSO Ultra Low Stretch Smoke 0.12mm 150m

Fir ASSO Ultra Low Stretch Smoke 0.12mm 150m

607080010
Livrare 48-72 ore

32,20Lei

Fir ASSO Evergreen PE 8X Verde 0.24mm 130m

Fir ASSO Evergreen PE 8X Verde 0.24mm 130m

608080005
Livrare imediată!

100,43Lei

Fir Asso Super Ester White-Fluo 0.090mm 200m 0.68kg

Fir Asso Super Ester White-Fluo 0.090mm 200m 0.68kg

111108403
Livrare 48-72 ore

37,59Lei

Fir ASSO Ultra Cast Galben Fluo 0.26mm

Fir ASSO Ultra Cast Galben Fluo 0.26mm

602080002
Livrare 48-72 ore

34,38Lei

ASSO HARD SKIN Solid Red 0.32mm 14 Lb 1205m

ASSO HARD SKIN Solid Red 0.32mm 14 Lb 1205m

607080055
Livrare imediată!

56,20Lei

Fir ASSO Ultra Transparent 0.14mm 100m

Fir ASSO Ultra Transparent 0.14mm 100m

604080004
Livrare 48-72 ore

22,58Lei

Fir Asso Invisilk Pink 0.18 mm 150 m

Fir Asso Invisilk Pink 0.18 mm 150 m

603080033
Livrare 48-72 ore

17,58Lei

Fir Asso Trout Area Fluorocarbon White 0.148mm 100m

Fir Asso Trout Area Fluorocarbon White 0.148mm 100m

111108305
Livrare 48-72 ore

82,06Lei

Fir ASSO Ultra Low Stretch Smoke 0.50mm 50m

Fir ASSO Ultra Low Stretch Smoke 0.50mm 50m

603080020
Livrare imediată!

21,26Lei

Fir ASSO Hard Skin Siliconed Green 0.20mm 300m

Fir ASSO Hard Skin Siliconed Green 0.20mm 300m

607080020
Livrare 48-72 ore

38,57Lei

Fir ASSO Ultra Transparent 2.00kg 0.10mm 25m

Fir ASSO Ultra Transparent 2.00kg 0.10mm 25m

604080061
Livrare 48-72 ore

13,24Lei

Fir ASSO Fluorocarbon Invisible Clear 0.50mm 50m

Fir ASSO Fluorocarbon Invisible Clear 0.50mm 50m

605080012
Livrare 48-72 ore

87,60Lei

Fir Asso Ultra Cast Orange 0.20mm 1000m

Fir Asso Ultra Cast Orange 0.20mm 1000m

110108100020
Livrare 48-72 ore

54,50Lei

Fir ASSO Trout Area Nylon Soft Green 0.128mm 100m -39%

Fir ASSO Trout Area Nylon Soft Green 0.128mm 100m

111108102
Livrare imediată!

53,48Lei(-39%) 32,46Lei

Fir Asso HARD SKIN - Siliconed Green 0.22mm 300m 3,175 Kg

Fir Asso HARD SKIN - Siliconed Green 0.22mm 300m 3,175 Kg

607080021
Livrare 48-72 ore

39,62Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.31mm 300m

Fir ASSO Ultra Molecular Shield Dark Green 0.31mm 300m

602080013
Livrare 48-72 ore

46,04Lei

Fir ASSO Ultra Soft Copper 0.20mm

Fir ASSO Ultra Soft Copper 0.20mm

604080012
Livrare 48-72 ore

21,84Lei

Afişare 241 - 260 din 291 (15 pagini)
Queries: 7, Total time: 72.547 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = 'ca10569d86efe236e3a131fbbe'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.095)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (42.291)
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 = '3' AND p.manufacturer_id = '129'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (29.784)
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 = '3' AND p.manufacturer_id = '129' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.133)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37