Asso


Fir ASSO Evergreen PE 8X Verde 0.15mm 130m

Fir ASSO Evergreen PE 8X Verde 0.15mm 130m

608080002
Livrare 48-72 ore

97,79Lei

Fir Asso Trout Area Fluorocarbon White 0.117mm 100m

Fir Asso Trout Area Fluorocarbon White 0.117mm 100m

111108303
Livrare 48-72 ore

60,79Lei

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 Textil ASSO 8xPE Lure Braid 0.06mm 150m

Fir Textil ASSO 8xPE Lure Braid 0.06mm 150m

611080001
Livrare imediată!

114,05Lei

Fir, ASSO, Ultra, Molecular, Shield, Dark, Green, 0.40mm, 1200m, 602080026, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir ASSO Ultra Soft Copper 0.24mm

Fir ASSO Ultra Soft Copper 0.24mm

604080014
Livrare 48-72 ore

21,65Lei

Fir ASSO Ultra Low Stretch Smoke 0.22mm 150m

Fir ASSO Ultra Low Stretch Smoke 0.22mm 150m

607080015
Livrare imediată!

33,55Lei

Fir, ASSO, Ultra, Carp, Brown, 0.36, mm, 1000, m, 607080067, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, Asso, Ultra, Cast, Orange, 0.26mm, 1000m, 110108100026, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir ASSO Trout Area Nylon Soft Green 0.104mm 100m -41%

Fir ASSO Trout Area Nylon Soft Green 0.104mm 100m

111108101
Livrare imediată!

54,48Lei(-41%) 31,90Lei

Fir Asso Super Ajing Shock Alb 0.148mm 30m 1.81kg -28%

Fir Asso Super Ajing Shock Alb 0.148mm 30m 1.81kg

111108605
Livrare imediată!

44,02Lei(-28%) 31,90Lei

Fir ASSO Ultra Cast Galben Fluo 0.14mm 150m

Fir ASSO Ultra Cast Galben Fluo 0.14mm 150m

603080011
Livrare 48-72 ore

14,41Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.26mm 300m

Fir ASSO Ultra Molecular Shield Dark Green 0.26mm 300m

602080011
Livrare 48-72 ore

39,87Lei

Fir ASSO Ultra Cast Verde Fluo 0.20mm 150m

Fir ASSO Ultra Cast Verde Fluo 0.20mm 150m

603080005
Livrare imediată!

16,40Lei

Fir, ASSO, Ultra, Low, Stretch, Smoke, 0.12mm, 50m, 604080042, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Fir, Asso, Invisilk, Pink, 0.24, mm, 150, m, 603080036, Fire Monofilament Rapitori, Fire Monofilament Rapitori Asso, Asso
Fir, Asso, Ultra, Cast, Orange, 0.22mm, 300m, 11010830022, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, Asso, Super, Ester, White-Fluo, 0.074mm, 200m, 0.454kg, 111108401, Fire Monofilament Rapitori, Fire Monofilament Rapitori Asso, Asso
Fir Asso Chod Stiff Rigs 20m 0.30mm 6.8kg Clear

Fir Asso Chod Stiff Rigs 20m 0.30mm 6.8kg Clear

110708fpasdi25abm0020000300
Livrare 48-72 ore

18,58Lei

FIR, MONOFILAMENT, ASSO, SINKING, 3X, FEEDER, -, Brown, 0.166mm, 150m, 2.1Kg, 604080032, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder Asso, Asso
Afişare 161 - 180 din 294 (15 pagini)
Queries: 7, Total time: 57.618 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '2a3f11b7ecc5ae463d46e52e66'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.091)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.086)
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.100)
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 (32.035)
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 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.121)
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