Asso


Fir ASSO Evergreen PE 8X Verde 0.24mm 130m

Fir ASSO Evergreen PE 8X Verde 0.24mm 130m

608080005
Livrare imediată!

97,79Lei

Fir, Asso, Trout, Area, Fluorocarbon, White, 0.128, 100m, 111108304, Fire Monofilament Rapitori, Fire Monofilament Rapitori Asso, Fire Asso, Monofilament Asso, Rapitori Asso, Asso
Fir, Fluorocarbon, Asso, Premium, Cuori, 0.16mm, 50m, 1.90kg, 111008160, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Fir Textil ASSO 8xPE Lure Braid 0.08mm 150m

Fir Textil ASSO 8xPE Lure Braid 0.08mm 150m

611080002
Livrare 48-72 ore

114,05Lei

Fir, ASSO, Hard, Skin, Siliconed, Green, 0.20mm, 300m, 607080020, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 150m

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 150m

604080027
Livrare 48-72 ore

24,95Lei

Fir ASSO Ultra Low Stretch Smoke 0.24mm 150m

Fir ASSO Ultra Low Stretch Smoke 0.24mm 150m

607080016
Livrare imediată!

34,12Lei

Fir ASSO Ultra Carp Brown 0.39 mm 1000 m

Fir ASSO Ultra Carp Brown 0.39 mm 1000 m

607080068
Livrare 48-72 ore

94,57Lei

Fir, Asso, Ultra, Cast, Orange, 0.28mm, 1000m, 110108100028, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, ASSO, Trout, Area, Nylon, Soft, Green, 0.128mm, 100m, 111108102, Fire Monofilament Rapitori, Fire Monofilament Rapitori Asso, Fire Asso, Monofilament Asso, Rapitori Asso, Asso -27%
Fir Asso Super Ajing PE 4X Orange 0.074mm 150m 1.36kg -28%

Fir Asso Super Ajing PE 4X Orange 0.074mm 150m 1.36kg

111108501
Livrare imediată!

157,14Lei(-28%) 113,89Lei

Fir ASSO Ultra Cast Galben Fluo 0.16mm 150m

Fir ASSO Ultra Cast Galben Fluo 0.16mm 150m

603080012
Livrare 48-72 ore

19,19Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 300m

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 300m

602080012
Livrare 48-72 ore

41,72Lei

Fir ASSO Ultra Cast Verde Fluo 0.22mm 150m

Fir ASSO Ultra Cast Verde Fluo 0.22mm 150m

603080006
Livrare 48-72 ore

16,86Lei

Fir ASSO Ultra Low Stretch Smoke 0.14mm 50m

Fir ASSO Ultra Low Stretch Smoke 0.14mm 50m

604080043
Livrare imediată!

12,63Lei

Fir Asso Invisilk Pink 0.20 mm 150 m

Fir Asso Invisilk Pink 0.20 mm 150 m

603080034
Livrare 48-72 ore

16,56Lei

Fir, Asso, Ultra, Cast, Orange, 0.24mm, 300m, 11010830024, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, Asso, Super, Ester, White-Fluo, 0.082mm, 200m, 111108402, Fire Monofilament Rapitori, Fire Monofilament Rapitori Asso, Fire Asso, Monofilament Asso, Rapitori Asso, Asso -26%
Fir, Asso, Chod, Stiff, Rigs, 20m, 0.35mm, 9.1kg, Clear, 110708fpasdi25abm0020000350, Fire Monofilament Inaintas, Fire Monofilament Inaintas Asso, Asso
FIR, MONOFILAMENT, ASSO, SINKING, 3X, FEEDER, -, Brown, 0.176mm, 150m, 2.6Kg, 604080033, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder Asso, Asso
Afişare 141 - 160 din 294 (15 pagini)
Queries: 7, Total time: 56.895 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = '1bdb80d2ce696251e7b798aaa6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.139)
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 (26.358)
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 (30.018)
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 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.104)
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