Climax


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

24,89Lei

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

104,90Lei

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.15mm, 7.5kg

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.15mm, 7.5kg

9432-10135-015
Livrare 48-72 ore

104,90Lei

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

180,90Lei

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.12mm, 8.50kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.12mm, 8.50kg, 135m

9405-10135-012
Livrare imediată!

98,00Lei

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.24mm 11.8kg

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.24mm 11.8kg

9920-00001-024
Livrare imediată!

22,90Lei

Fir Textil Climax iBraid X8 Neo Fluo Chartreuse 135m, 0.12mm, 8.5kg

Fir Textil Climax iBraid X8 Neo Fluo Chartreuse 135m, 0.12mm, 8.5kg

9406-10135-012
Livrare imediată!

98,00Lei

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 5kg

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 5kg

8610-10006-005
Livrare 48-72 ore

28,91Lei

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

109,90Lei

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.22mm, 11.8kg

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.22mm, 11.8kg

9432-10135-022
Livrare 48-72 ore

109,90Lei

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

180,90Lei

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.22mm, 19.10kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.22mm, 19.10kg, 135m

9406-10135-022
Livrare imediată!

98,00Lei

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.15mm 7.5kg

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.15mm 7.5kg

9302-10110-015
Livrare 48-72 ore

98,90Lei

LEADCORE Climax CULT CRAP 10m 35lb Weed

LEADCORE Climax CULT CRAP 10m 35lb Weed

9900-10013-035
Livrare 48-72 ore

36,90Lei

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

22,90Lei

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

13,49Lei

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

24,89Lei

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

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

9431-10135-018
Livrare 48-72 ore

104,90Lei

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

104,90Lei

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

180,90Lei

Afişare 1 - 20 din 487 (25 pagini)
Queries: 7, Total time: 60.214 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '299248f29bd19862a576ca326d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.110)
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.121)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (27.244)
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 = '128'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (32.387)
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 = '0' 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.140)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37