Asso


Fir ASSO Fluorocarbon Invisible Clear 0.15mm 50m

Fir ASSO Fluorocarbon Invisible Clear 0.15mm 50m

605080002
Livrare 48-72 ore

30,54Lei

Fir, Asso, Invisilk, Yellow, 0.26mm, 300m, 602080093, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir ASSO Trout Area Nylon Hard Grey 0.104mm 100m

Fir ASSO Trout Area Nylon Hard Grey 0.104mm 100m

111108105
Livrare 48-72 ore

45,45Lei

Fir Asso Super Ajing PE 4X Orange 0.117mm 150m 3.62kg -28%

Fir Asso Super Ajing PE 4X Orange 0.117mm 150m 3.62kg

111108504
Livrare imediată!

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

Fir ASSO Ultra Cast Galben Fluo 0.22mm 150m

Fir ASSO Ultra Cast Galben Fluo 0.22mm 150m

603080015
Livrare 48-72 ore

21,07Lei

Fir, ASSO, Ultra, Molecular, Shield, Dark, Green, 0.37mm, 300m, 602080015, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, ASSO, Sinking, 3X, Feeder, Brown, 0.134mm, 604080030, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder Asso, Asso
Fir, ASSO, Ultra, Low, Stretch, Smoke, 0.12mm, 150m, 607080010, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
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, Super, Ester, White-Fluo, 0.117mm, 200m, 1.134kg, 111108405, Fire Monofilament Rapitori, Fire Monofilament Rapitori Asso, Fire Asso, Monofilament Asso, Rapitori Asso, Asso
Fir Asso Fluorocarbon Hooklink 20m 0.306mm 6.8kg Clear

Fir Asso Fluorocarbon Hooklink 20m 0.306mm 6.8kg Clear

110108ffasdi138bm0020000306
Livrare 48-72 ore

32,17Lei

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

Fir ASSO Evergreen PE 8X Verde 0.50mm 130m

608080011
Livrare imediată!

97,79Lei

Fir ASSO Ultra Transparent 0.16mm 100m

Fir ASSO Ultra Transparent 0.16mm 100m

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, 111108212, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Fir, ASSO, Ultra, Cast, Galben, Fluo, 0.36mm, 1000m, 607080037, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Afişare 61 - 80 din 294 (15 pagini)
Queries: 7, Total time: 55.169 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '4bc3cc21551c4f5bb97bf88cdd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Asso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.103)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (25.160)
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 = '0' AND p.manufacturer_id = '129'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (29.419)
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 = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.130)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38