Asso


FIR ASSO HARD SKIN Solid White 0.22mm 7 Lb 2400m -25%

FIR ASSO HARD SKIN Solid White 0.22mm 7 Lb 2400m

607080040
Livrare imediată!

83,87Lei(-25%) 62,92Lei

Fir ASSO Ultra Transparent 3.10kg 0.14mm 25m

Fir ASSO Ultra Transparent 3.10kg 0.14mm 25m

604080063
Livrare imediată!

13,24Lei

Fir Asso Invisilk Pink 0.30 mm 300 m

Fir Asso Invisilk Pink 0.30 mm 300 m

602080045
Livrare imediată!

38,18Lei

Fir Asso Ultra Cast Orange 0.24mm 1000m

Fir Asso Ultra Cast Orange 0.24mm 1000m

110108100024
Livrare 48-72 ore

59,17Lei

Fir ASSO Trout Area Nylon Soft Green 0.165mm 100m

Fir ASSO Trout Area Nylon Soft Green 0.165mm 100m

111108104
Livrare 48-72 ore

56,19Lei

Fir Asso Super Ajing PE 4X Orange 0.104mm 150m 2.72kg -26%

Fir Asso Super Ajing PE 4X Orange 0.104mm 150m 2.72kg

111108503
Livrare imediată!

157,14Lei(-26%) 116,81Lei

FIR MONOFILAMENT ASSO HARD SKIN WHITE 0.35MM / 16LB / 1050MT

FIR MONOFILAMENT ASSO HARD SKIN WHITE 0.35MM / 16LB / 1050MT

607080046
Livrare 48-72 ore

55,82Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.37mm 300m

Fir ASSO Ultra Molecular Shield Dark Green 0.37mm 300m

602080015
Livrare 48-72 ore

51,44Lei

Fir ASSO Ultra Soft Copper 0.24mm

Fir ASSO Ultra Soft Copper 0.24mm

604080014
Livrare 48-72 ore

23,01Lei

Fir ASSO Fluorocarbon Invisible Clear 0.13mm 50m

Fir ASSO Fluorocarbon Invisible Clear 0.13mm 50m

605080001
Livrare 48-72 ore

30,60Lei

Fir Asso Ultra Cast Orange 0.20mm 300m

Fir Asso Ultra Cast Orange 0.20mm 300m

11010830020
Livrare imediată!

30,73Lei

FIR MONOFILAMENT ASSO ULTRA MOLECULAR SHIELD - Dark Green 0.16mm 150m 3.9Kg

FIR MONOFILAMENT ASSO ULTRA MOLECULAR SHIELD - Dark Green 0.16mm 150m 3.9Kg

604080021
Livrare 48-72 ore

20,10Lei

Fir ASSO Ultra Cast Galben Fluo 0.26mm 1000m

Fir ASSO Ultra Cast Galben Fluo 0.26mm 1000m

607080033
Livrare imediată!

67,03Lei

Fir ASSO Evergreen PE 8X Verde 0.58mm 130m 81.80 kg

Fir ASSO Evergreen PE 8X Verde 0.58mm 130m 81.80 kg

608080012
Livrare imediată!

100,43Lei

Fir ASSO Ultra Low Stretch Smoke 0.16mm 50m

Fir ASSO Ultra Low Stretch Smoke 0.16mm 50m

604080044
Livrare imediată!

13,98Lei

Fir Asso Invisilk Pink 0.26mm 300m

Fir Asso Invisilk Pink 0.26mm 300m

602080043
Livrare 48-72 ore

36,13Lei

Fir Asso New Micron 3 Clear 0.185mm 100m 3.07kg -24%

Fir Asso New Micron 3 Clear 0.185mm 100m 3.07kg

111108215
Livrare imediată!

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

Fir Asso Fluorocarbon Hooklink 20m 0.389mm 11.3kg Clear

Fir Asso Fluorocarbon Hooklink 20m 0.389mm 11.3kg Clear

110108ffasdi138bm0020000389
Livrare 48-72 ore

33,71Lei

Fir ASSO Ultra Cast Galben Fluo 0.22mm

Fir ASSO Ultra Cast Galben Fluo 0.22mm

602080007
Livrare 48-72 ore

31,91Lei

ASSO HARD SKIN Solid Red 0.28mm 10 Lb 1640m

ASSO HARD SKIN Solid Red 0.28mm 10 Lb 1640m

607080053
Livrare imediată!

77,97Lei

Afişare 181 - 200 din 291 (15 pagini)
Queries: 7, Total time: 60.658 ms [By time] [By id] [By file]
1 (0.070)
SELECT data
FROM `oc_session`
WHERE session_id = 'e707905ea12ce627e35089bc62'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.068)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.089)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.084)
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 (30.648)
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.600)
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 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.099)
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