Climax


LEADCORE Climax CULT CRAP 10m 45lb Dark Silt

LEADCORE Climax CULT CRAP 10m 45lb Dark Silt

9900-10014-045
Livrare 48-72 ore

37,61Lei

FIR CLIMAX TEXTIL IBRAID DIVE FLUO YELLOW, 0.15mm, 275m 7.50 kg

FIR CLIMAX TEXTIL IBRAID DIVE FLUO YELLOW, 0.15mm, 275m 7.50 kg

9432-10275-015
Livrare 48-72 ore

184,94Lei

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.08mm, 4.90kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.08mm, 4.90kg, 135m

9406-10135-008
Livrare imediată!

123,02Lei

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

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

9920-00012-019
Livrare imediată!

14,12Lei

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.06mm 3.2kg

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.06mm 3.2kg

9302-10110-006
Livrare 48-72 ore

101,56Lei

Fir Textil Climax iBraid X8 Neo Fluo Chartreuse 135m, 0.18mm, 15.7kg

Fir Textil Climax iBraid X8 Neo Fluo Chartreuse 135m, 0.18mm, 15.7kg

9406-10135-018
Livrare imediată!

100,65Lei

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 10kg

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 10kg

8610-10006-010
Livrare 48-72 ore

30,40Lei

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

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

9431-10275-015
Livrare 48-72 ore

184,94Lei

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.09mm 4.1kg Dark Grey

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.09mm 4.1kg Dark Grey

9920-00011-009
Livrare imediată!

14,73Lei

FIR CLIMAX TEXTIL IBRAID DIVE FLUO YELLOW, 0.20mm, 275m 10.6 kg

FIR CLIMAX TEXTIL IBRAID DIVE FLUO YELLOW, 0.20mm, 275m 10.6 kg

9432-10275-020
Livrare 48-72 ore

204,26Lei

LEADCORE Climax CULT CRAP 10m 25lb Weed

LEADCORE Climax CULT CRAP 10m 25lb Weed

9900-10013-025
Livrare 48-72 ore

38,51Lei

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.21mm 10.6kg

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.21mm 10.6kg

9302-10110-021
Livrare 48-72 ore

101,56Lei

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.08mm, 4.90kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.08mm, 4.90kg, 135m

9405-10135-008
Livrare imediată!

123,02Lei

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.18mm 9.5kg

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.18mm 9.5kg

9920-00001-018
Livrare 48-72 ore

24,28Lei

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

15,65Lei

FIR INAINTAS PENTRU STRUNA Climax HARDMONO ORIGINAL 10m 13.6kg

FIR INAINTAS PENTRU STRUNA Climax HARDMONO ORIGINAL 10m 13.6kg

8610-10007-014
Livrare imediată!

26,32Lei

FIR CLIMAX TEXTIL IBRAID DIVE FLUO YELLOW, 0.22mm, 275m 11.80kg

FIR CLIMAX TEXTIL IBRAID DIVE FLUO YELLOW, 0.22mm, 275m 11.80kg

9432-10275-022
Livrare 48-72 ore

204,26Lei

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.10mm, 4.1kg

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.10mm, 4.1kg

9432-10135-010
Livrare imediată!

106,75Lei

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.08mm, 275m

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.08mm, 275m

9431-10275-008
Livrare 48-72 ore

204,26Lei

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.14mm, 10.10kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.14mm, 10.10kg, 135m

9406-10135-014
Livrare imediată!

100,65Lei

Afişare 1 - 20 din 478 (24 pagini)
Queries: 7, Total time: 113.729 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = '117f5436b03ba30cdc586773cb'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.133)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Climax'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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
5 (51.866)
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:1699
6 (61.193)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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:440
7 (0.136)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37