Climax


FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.15mm, 135m

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.15mm, 135m

9431-10135-015
Livrare 48-72 ore

103,99Lei

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.24mm 11.8kg Dark Grey

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.24mm 11.8kg Dark Grey

9920-00011-024
Livrare 48-72 ore

13,49Lei

FIR, CLIMAX, TEXTIL, IBRAID, DIVE, FLUO, YELLOW,, 0.18mm,, 275m, 9.50, kg, 9432-10275-018, Fire Textile Inaintas, Fire Textile Inaintas Climax, Climax
Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.18mm, 9.5kg -20%

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.18mm, 9.5kg

9432-10135-018
Livrare imediată!

103,99Lei(-20%) 83,20Lei

FIR TEXTIL CLIMAX CULT FEEDER GRAVILINK 10M CAMOU BROWN 0.25mm 10kg

FIR TEXTIL CLIMAX CULT FEEDER GRAVILINK 10M CAMOU BROWN 0.25mm 10kg

9920-00012-025
Livrare imediată!

12,00Lei

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.10mm, 6.70kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.10mm, 6.70kg, 135m

9405-10135-010
Livrare imediată!

112,00Lei

FIR, INAINTAS, PENTRU, STRUNA, Climax, HARDMONO, ORIGINAL, 10m, 13.6kg, 8610-10007-014, Fire Pentru Strune, Fire Pentru Strune Climax, Climax
Fir, Leadcore, Fox, Naturals,, 7m,, 50lb/22.7kg, cac821, Fire Monturi Crap, Fire Monturi Crap Climax, Climax
LEADCORE Climax CULT CRAP 10m 35lb Dark Silt

LEADCORE Climax CULT CRAP 10m 35lb Dark Silt

9900-10014-035
Livrare imediată!

36,00Lei

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.22mm, 135m

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.22mm, 135m

9431-10135-022
Livrare 48-72 ore

109,00Lei

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.06mm 3.2kg Dark Grey

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.06mm 3.2kg Dark Grey

9920-00011-006
Livrare imediată!

13,49Lei

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.09mm 4.1kg

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.09mm 4.1kg

9920-00001-009
Livrare 48-72 ore

22,00Lei

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.20mm, 17.90kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.20mm, 17.90kg, 135m

9406-10135-020
Livrare imediată!

98,00Lei

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 20kg

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 20kg

8610-10006-020
Livrare imediată!

34,00Lei

FIR, TEXTIL, CLIMAX, CULT, FAST, SINKING, FEEDER, DROPLINK, 10M, DARK, GREY, 0.21mm, 10.6kg, 9920-00001-021, Fire Monturi Feeder, Fire Monturi Feeder Climax, Climax
FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.18mm 9.5kg

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.18mm 9.5kg

9302-10110-018
Livrare 48-72 ore

98,00Lei

Elastic Delphin POWA GUM Absorber Maro, 1mm, 8kg, 7m

Elastic Delphin POWA GUM Absorber Maro, 1mm, 8kg, 7m

101001558
Livrare imediată!

17,01Lei

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.06mm 3.2kg

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.06mm 3.2kg

9920-00001-006
Livrare 48-72 ore

22,00Lei

Fir, Textil, Climax, iBraid, X8, Neo, Fluo, Chartreuse, 135m,, 0.10mm,, 6.7kg, 9406-10135-010, Fire Textile Rapitori, Fire Textile Rapitori Climax, Climax
FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.20mm, 135m

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.20mm, 135m

9431-10135-020
Livrare 48-72 ore

109,00Lei

Afişare 1 - 20 din 475 (24 pagini)
Queries: 9, Total time: 91.081 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = 'c4bfebe567c034d634b2f114f7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.123)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Climax'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.119)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '128' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (47.823)
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 = '128'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1650
7 (42.535)
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 = '3' AND p.manufacturer_id = '128' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.107)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.083)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38