Asso


Fir, ASSO, Ultra, Cast, Galben, Fluo, 0.22mm, 150m, 603080015, Fire Monofilament Rapitori, Fire Monofilament Rapitori Asso, Asso
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

49,61Lei

Fir ASSO Sinking 3X Feeder Brown 0.134mm

Fir ASSO Sinking 3X Feeder Brown 0.134mm

604080030
Livrare 48-72 ore

35,41Lei

Fir ASSO Ultra Low Stretch Smoke 0.12mm 150m

Fir ASSO Ultra Low Stretch Smoke 0.12mm 150m

607080010
Livrare 48-72 ore

30,68Lei

Fir ASSO Ultra Carp Brown 0.20 mm 1000 m

Fir ASSO Ultra Carp Brown 0.20 mm 1000 m

607080060
Livrare imediată!

47,16Lei

Fir, Asso, Ultra, Cast, Orange, 0.30mm, 300m, 11010830030, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, ASSO, Ultra, Cast, Galben, Fluo, 0.36mm, 1000m, 607080037, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
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

37,98Lei

Fir, ASSO, Ultra, Cast, Galben, Fluo, 0.26mm, 1000m, 607080033, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, ASSO, Evergreen, PE, 8X, Verde, 0.50mm, 130m, 608080011, Fire Textile Inaintas, Fire Textile Inaintas Asso, Asso
Fir, ASSO, Ultra, Transparent, 0.16mm, 100m, 604080005, Fire Varga Bolo, Fire Varga Bolo Asso, Asso

Fir, ASSO, Ultra, Transparent, 0.16mm, 100m, 604080005, Fire Varga Bolo, Fire Varga Bolo Asso, Asso

604080005
Livrare imediată!

22,51Lei

Fir, Asso, Invisilk, Pink, 0.22, mm, 300, m, 602080041, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, Asso, Invisilk, Yellow, 0.14mm, 150m, 603080081, Fire Monofilament Rapitori, Fire Monofilament Rapitori Asso, Asso
Fir Asso New Micron 3 Clear 0.133mm 100m 1.65kg

Fir Asso New Micron 3 Clear 0.133mm 100m 1.65kg

111108212
Livrare 48-72 ore

39,14Lei

Fir Fluorocarbon Asso Premium Cuori 0.13mm 50m 1.60kg -28%

Fir Fluorocarbon Asso Premium Cuori 0.13mm 50m 1.60kg

111008130
Livrare imediată!

30,33Lei(-28%) 21,90Lei

FIR MONOFILAMENT ASSO ULTRA MOLECULAR SHIELD - Dark Green 0.18mm 150m 5.1Kg

FIR MONOFILAMENT ASSO ULTRA MOLECULAR SHIELD - Dark Green 0.18mm 150m 5.1Kg

604080022
Livrare 48-72 ore

19,79Lei

Fir, ASSO, Ultra, Cast, Galben, Fluo, 0.22mm, 602080007, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
ASSO HARD SKIN Solid Red 0.26mm 9 Lb 1900m

ASSO HARD SKIN Solid Red 0.26mm 9 Lb 1900m

607080052
Livrare imediată!

81,15Lei

Fir ASSO Ultra Transparent 2.50kg 0.12mm 25m

Fir ASSO Ultra Transparent 2.50kg 0.12mm 25m

604080062
Livrare 48-72 ore

12,04Lei

Fir, ASSO, Fluorocarbon, Invisible, Clear, 0.25mm, 50m, 605080007, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Afişare 81 - 100 din 294 (15 pagini)
Queries: 7, Total time: 55.697 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '8fcd8531da0854e871586864e9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.110)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.107)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (25.283)
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 = '129'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (29.879)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '129' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.125)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38