Varivas


Varivas CARLIGE SUPER TROUT AREA TOURNAMENT CANVAS NR 6 15buc/plic

Varivas CARLIGE SUPER TROUT AREA TOURNAMENT CANVAS NR 6 15buc/plic

vc13sta06
Livrare imediată!

25,89Lei

Fir Textil Varivas FIR MAX POWER PE X8 150m 16.7lb 0.148mm Lime Green Fluo

Fir Textil Varivas FIR MAX POWER PE X8 150m 16.7lb 0.148mm Lime Green Fluo

v30015008
Livrare imediată!

165,90Lei

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO -0X 25m 0.285mm 14.5lb

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO -0X 25m 0.285mm 14.5lb

v7250x
Livrare 48-72 ore

79,90Lei

CARLIGE VARIVAS SUPER TROUT AREA TOURNAMENT CANVAS NR. 8.5

CARLIGE VARIVAS SUPER TROUT AREA TOURNAMENT CANVAS NR. 8.5

vc13sta086
Livrare 48-72 ore

25,89Lei

Fir Textil Varivas Pe 4 Blue Edition 150m 0.148mm 15lb Water Blue

Fir Textil Varivas Pe 4 Blue Edition 150m 0.148mm 15lb Water Blue

v18215008
Livrare 48-72 ore

77,90Lei

Fir Textil Varivas Absolute Premium PE X4 Marking Green, 150m, 0.128mm, 10lb

Fir Textil Varivas Absolute Premium PE X4 Marking Green, 150m, 0.128mm, 10lb

v23415006
Livrare 48-72 ore

142,90Lei

Carlige Varivas Under Shot Fine Wire Hooks, Nr.2, 10buc/pac

Carlige Varivas Under Shot Fine Wire Hooks, Nr.2, 10buc/pac

v001863
Livrare imediată!

11,50Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION MONSTER CLASS NR 6/0 4buc/plic -20%

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION MONSTER CLASS NR 6/0 4buc/plic

vc97hmm6/0
Livrare imediată!

20,00Lei(-20%) 16,01Lei

Fir Textil Varivas FIR AVANI JIGGING 10x10 PREMIUM PE X4 200m 43lb 10mx10 Culori

Fir Textil Varivas FIR AVANI JIGGING 10x10 PREMIUM PE X4 200m 43lb 10mx10 Culori

v29620030
Livrare 48-72 ore

160,90Lei

MONOFILAMENT VARIVAS SUPER TROUT AREA ES2 ESTER NATURAL 80m 0.091m 1.75lb

MONOFILAMENT VARIVAS SUPER TROUT AREA ES2 ESTER NATURAL 80m 0.091m 1.75lb

v5108003
Livrare 48-72 ore

42,90Lei

Fir Textil Varivas PE 8 Marking Edition 300m 0.330mm 61lb Vivid 5 Color

Fir Textil Varivas PE 8 Marking Edition 300m 0.330mm 61lb Vivid 5 Color

v18330040
Livrare 48-72 ore

260,90Lei

Fir Textil Varivas Bass PE X4 Flash Green, 150m, 0.148mm, 15lb

Fir Textil Varivas Bass PE X4 Flash Green, 150m, 0.148mm, 15lb

v18515008
Livrare 48-72 ore

99,90Lei

Fir Textil Varivas Super Trout Area PE X4, Neo Yellow, 0.15mm, 4lbs, 75m

Fir Textil Varivas Super Trout Area PE X4, Neo Yellow, 0.15mm, 4lbs, 75m

v47075015
Livrare 48-72 ore

221,90Lei

Fir Textil Varivas FIR HIGH GRADE PE X4 MARKING TYPE2 150m 0.165mm 18lb

Fir Textil Varivas FIR HIGH GRADE PE X4 MARKING TYPE2 150m 0.165mm 18lb

v20915010
Livrare imediată!

98,90Lei

Fir Textil Varivas AVANI LIGHT GAME PE X4 150m 0.085mm 6.5lb Natural Blue

Fir Textil Varivas AVANI LIGHT GAME PE X4 150m 0.085mm 6.5lb Natural Blue

v1915003
Livrare 48-72 ore

245,90Lei

FIR FLUOROCARBON FLY VARIVAS SHOCK LEADER 30m 18 0.700mm 60lb

FIR FLUOROCARBON FLY VARIVAS SHOCK LEADER 30m 18 0.700mm 60lb

v8009890
Livrare 48-72 ore

159,90Lei

Fir Textil Varivas Pe 8 Blue Edition 150m 0.205mm 31lb Fluo Ocean Blue

Fir Textil Varivas Pe 8 Blue Edition 150m 0.205mm 31lb Fluo Ocean Blue

v18415015
Livrare 48-72 ore

129,90Lei

Fir Textil Varivas Fune Pe X8 Multicolor High Visibility, 150m, 0.165mm, 9kg

Fir Textil Varivas Fune Pe X8 Multicolor High Visibility, 150m, 0.165mm, 9kg

v17015010
Livrare imediată!

115,00Lei

Fir Textil Varivas FIR AVANI EGING TIP RUN PREMIUM PE 150m 0.104mm 8.0lb Tricolore

Fir Textil Varivas FIR AVANI EGING TIP RUN PREMIUM PE 150m 0.104mm 8.0lb Tricolore

v30115004
Livrare 48-72 ore

218,90Lei

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO -2X 25m 0.330mm 19.5lb

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO -2X 25m 0.330mm 19.5lb

v725-2x
Livrare 48-72 ore

79,90Lei

Afişare 1 - 20 din 483 (25 pagini)
Queries: 7, Total time: 77.056 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'e499965893c757c9c28b0f9f36'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.118)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Varivas'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.111)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '50' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (38.895)
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 = '50'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (37.507)
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 = '50' 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.214)
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