Climax


FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.12mm 5.0kg

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.12mm 5.0kg

9920-00001-012
Livrare imediată!

24,28Lei

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.18mm 9.5kg Dark Grey

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.18mm 9.5kg Dark Grey

9920-00011-018
Livrare imediată!

14,73Lei

FIR INAINTAS PENTRU STRUNA Climax HARDMONO ORIGINAL 10m 4.5kg

FIR INAINTAS PENTRU STRUNA Climax HARDMONO ORIGINAL 10m 4.5kg

8610-10007-005
Livrare 48-72 ore

26,32Lei

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

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

9431-10135-012
Livrare 48-72 ore

107,67Lei

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

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

9432-10135-018
Livrare imediată!

107,67Lei

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

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

9431-10275-010
Livrare 48-72 ore

184,94Lei

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.06mm, 3.20kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.06mm, 3.20kg, 135m

9406-10135-006
Livrare imediată!

139,30Lei

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

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

9920-00012-016
Livrare imediată!

14,12Lei

Fir Textil Climax iBraid X8 Neo Fluo Chartreuse 135m, 0.16mm, 12.3kg

Fir Textil Climax iBraid X8 Neo Fluo Chartreuse 135m, 0.16mm, 12.3kg

9406-10135-016
Livrare imediată!

100,65Lei

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 5kg

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 5kg

8610-10006-005
Livrare 48-72 ore

30,40Lei

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

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

9431-10135-008
Livrare 48-72 ore

112,75Lei

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ă!

14,73Lei

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

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

9431-10275-012
Livrare 48-72 ore

184,94Lei

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.25mm, 20.50kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.25mm, 20.50kg, 135m

9406-10135-025
Livrare imediată!

100,65Lei

LEADCORE Climax CULT CRAP 10m 35lb Weed

LEADCORE Climax CULT CRAP 10m 35lb Weed

9900-10013-035
Livrare 48-72 ore

38,51Lei

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 imediată!

101,56Lei

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.06mm, 3.20kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.06mm, 3.20kg, 135m

9405-10135-006
Livrare imediată!

139,30Lei

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.15mm 7.5kg

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.15mm 7.5kg

9920-00001-015
Livrare imediată!

24,28Lei

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.21mm 10.6kg Dark Grey

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.21mm 10.6kg Dark Grey

9920-00011-021
Livrare 48-72 ore

15,65Lei

FIR INAINTAS PENTRU STRUNA Climax HARDMONO ORIGINAL 10m 9.1kg

FIR INAINTAS PENTRU STRUNA Climax HARDMONO ORIGINAL 10m 9.1kg

8610-10007-010
Livrare imediată!

26,32Lei

Afişare 1 - 20 din 485 (25 pagini)
Queries: 7, Total time: 73.429 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = 'a96e4f9137ef151a8a0c9826e0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.119)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Climax'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.118)
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 (39.398)
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 (33.442)
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.155)
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