Climax

Climax

Sortare după:

Fir textil Climax CULT CRAP SNAKEBRAID LEADER 10m 40lb Dark Silt

Fir textil Climax CULT CRAP SNAKEBRAID LEADER 10m 40lb Dark Silt

9900-10023-040

Livrare 48-72 ore

62,92Lei

FIR TEXTIL Climax CULT CATFISH STRONG WHITE 250m 0.75mm 75kg

FIR TEXTIL Climax CULT CATFISH STRONG WHITE 250m 0.75mm 75kg

9151-00250-075

Livrare 48-72 ore

147,00Lei(-23%) 113,76Lei

MONTURA Climax CULT CATFISH BRAIDED LEADER 80cm 0.50mm 50kg

MONTURA Climax CULT CATFISH BRAIDED LEADER 80cm 0.50mm 50kg

9910-00011-050

Livrare imediată!

40,55Lei

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 30cm 20kg

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 30cm 20kg

8610-20002-020

Livrare 48-72 ore

12,08Lei

FIR STRUNA Climax TITANIUM 1x7 3m 14kg

FIR STRUNA Climax TITANIUM 1x7 3m 14kg

8610-10004-014

Livrare 48-72 ore

195,11Lei

Clips momeala Black Cat Baitclip, Large

Clips momeala Black Cat Baitclip, Large

4581002

Livrare imediată!

14,22Lei

Fir monofilament Climax FIR HYPER SPINNING FLUO ICE 150m 0.30mm

Fir monofilament Climax FIR HYPER SPINNING FLUO ICE 150m 0.30mm

8562-10150-030

Livrare 48-72 ore

27,00Lei(-16%) 22,55Lei

Fir monofilament Climax FIR MAX MONO OLIV 100m 0.30mm

Fir monofilament Climax FIR MAX MONO OLIV 100m 0.30mm

8723-10100-030

Livrare 48-72 ore

26,00Lei(-16%) 21,74Lei

Fir fluorocarbon Climax FIR CLIMAX FLUOROCARBON 50m 0.33mm 7.2kg

Fir fluorocarbon Climax FIR CLIMAX FLUOROCARBON 50m 0.33mm 7.2kg

8100-10050-033

Livrare 48-72 ore

39,54Lei

Fir textil Climax FIR BLADE LINE DARK YELLOW 100m 0.28mm 22kg

Fir textil Climax FIR BLADE LINE DARK YELLOW 100m 0.28mm 22kg

9422-00100-028

Livrare 48-72 ore

53,77Lei

Fir textil Climax iBRAID FLUO RED 135m 0.28mm 26.8kg

Fir textil Climax iBRAID FLUO RED 135m 0.28mm 26.8kg

9401-10135-028

Livrare 48-72 ore

89,36Lei

Fir textil Climax MIG8 OLIVE GREEN 135m 0.12mm 9.5kg

Fir textil Climax MIG8 OLIVE GREEN 135m 0.12mm 9.5kg

9351-10135-012

Livrare 48-72 ore

91,39Lei

Fir monofilament Climax CULT CRAP BLACK 1000m 0.28mm 6.10kg

Fir monofilament Climax CULT CRAP BLACK 1000m 0.28mm 6.10kg

8451-11000-028

Livrare 48-72 ore

92,41Lei

Fir textil Climax CULT HUNTERSBRAID SINKING HOOKLINK 20m 30lb Gravel

Fir textil Climax CULT HUNTERSBRAID SINKING HOOKLINK 20m 30lb Gravel

9900-10030-030

Livrare 48-72 ore

37,50Lei

Fir Monofilament Climax CULT CATFISH X-TREME MONO 500m 0.70mm 60lb

Fir Monofilament Climax CULT CATFISH X-TREME MONO 500m 0.70mm 60lb

8791-00500-070

Livrare 48-72 ore

110,72Lei

MONTURA Climax CULT CATFISH JIG FIREBALL 90gr Ancora 2/0 Red

MONTURA Climax CULT CATFISH JIG FIREBALL 90gr Ancora 2/0 Red

9910-00022-090

Livrare 48-72 ore

58,85Lei

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 7x7 30cm 15kg

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 7x7 30cm 15kg

8610-20001-015

Livrare 48-72 ore

14,12Lei

Climax FIR STRUNA DYNAWIRE CU BRIDE 16X 5m 0.44mm 18.5kg

Climax FIR STRUNA DYNAWIRE CU BRIDE 16X 5m 0.44mm 18.5kg

8610-10008-019

Livrare 48-72 ore

52,76Lei

FIR MONOFILAMENT CLIMAX CULT FEEDER DISTANCE 200M GOLDEN BROWN 0.31mm 7.9kg

FIR MONOFILAMENT CLIMAX CULT FEEDER DISTANCE 200M GOLDEN BROWN 0.31mm 7.9kg

8831-10200-031

Livrare 48-72 ore

32,42Lei

Fir monofilament Climax FIR HYPER MATCH SINKING 200m 0.08mm Light Grey

Fir monofilament Climax FIR HYPER MATCH SINKING 200m 0.08mm Light Grey

8592-10200-008

Livrare 48-72 ore

33,44Lei

Afişare 341 - 360 din 478 (24 pagini)

Queries: 7, Total time: 68.071 ms [By time] [By id] [By file]

1 (0.139)

SELECT data
FROM `oc_session`
WHERE session_id = 'e67a200352b9a1bf7fec9160ef'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.073)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.106)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Climax'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.114)

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 (28.758)

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 (38.637)

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 340,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.244)

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