Varivas


Varivas ANCORA DUBLA NOGALES ZERO FRICTION NR 6 5buc/plic

Varivas ANCORA DUBLA NOGALES ZERO FRICTION NR 6 5buc/plic

vca12zf06
Livrare 48-72 ore

31,90Lei

Fir Textil Varivas FIR AVANI JIGGING 10x10 MAX PE X8 200m 24.1lb 10mx10 Culori

Fir Textil Varivas FIR AVANI JIGGING 10x10 MAX PE X8 200m 24.1lb 10mx10 Culori

v29820012
Livrare 48-72 ore

240,90Lei

FIR TEXTIL VARIVAS AVANI SLJ SUPER LIGHT JIGGING MAX POWER PE X8 150m 16.7lb 10m x 5 culori

FIR TEXTIL VARIVAS AVANI SLJ SUPER LIGHT JIGGING MAX POWER PE X8 150m 16.7lb 10m x 5 culori

v6515008
Livrare 48-72 ore

179,90Lei

Fir Textil Varivas Avani Light Game Premium PE X4 Natural Blue, 100m, 0.085mm, 6.5lb

Fir Textil Varivas Avani Light Game Premium PE X4 Natural Blue, 100m, 0.085mm, 6.5lb

v2010003
Livrare 48-72 ore

159,90Lei

Fir Textil Varivas Super Trout Area PE X4 Tournament, Pink, 0.175mm, 5lbs, 75m

Fir Textil Varivas Super Trout Area PE X4 Tournament, Pink, 0.175mm, 5lbs, 75m

v48075017
Livrare 48-72 ore

186,90Lei

Carlige Varivas Death Lock Wide Hooks, Nr.1, 10buc/pac

Carlige Varivas Death Lock Wide Hooks, Nr.1, 10buc/pac

v029997
Livrare 48-72 ore

14,90Lei

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

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

v29620010
Livrare 48-72 ore

148,90Lei

Fir Textil Varivas SALTWATER FINESSE PE X8 150m 5.6lb 2.54kg

Fir Textil Varivas SALTWATER FINESSE PE X8 150m 5.6lb 2.54kg

v4615002
Livrare 48-72 ore

439,90Lei

FIR FLUOROCARBON FLY VARIVAS SHOCK LEADER 30m 8 0.480mm 30lb

FIR FLUOROCARBON FLY VARIVAS SHOCK LEADER 30m 8 0.480mm 30lb

v8009838
Livrare 48-72 ore

99,90Lei

Fir Textil Varivas PE 8 Marking Edition 150m 0.185mm 23lb Vivid 5 Color

Fir Textil Varivas PE 8 Marking Edition 150m 0.185mm 23lb Vivid 5 Color

v18315012
Livrare 48-72 ore

135,90Lei

Fir Textil Varivas Fune Pe X8 Multicolor High Visibility, 300m, 0.330mm, 28kg

Fir Textil Varivas Fune Pe X8 Multicolor High Visibility, 300m, 0.330mm, 28kg

v17030040
Livrare imediată!

225,01Lei

Fir Textil Varivas FIR HIGH GRADE PE X4 MILKY PINK 100m 0.205mm 25lb

Fir Textil Varivas FIR HIGH GRADE PE X4 MILKY PINK 100m 0.205mm 25lb

v20810015
Livrare 48-72 ore

64,90Lei

Fir Textil Varivas AVANI EGING PREMIUM PE X4 150m 18lbs Milky Pink

Fir Textil Varivas AVANI EGING PREMIUM PE X4 150m 18lbs Milky Pink

v16615010
Livrare 48-72 ore

122,90Lei

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll NYLON 7X 50m 0.104mm 2.5lb

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll NYLON 7X 50m 0.104mm 2.5lb

v7507x
Livrare 48-72 ore

59,90Lei

Fir Textil Varivas Pe 8 Blue Edition 150m 0.128mm 13lb Fluo Ocean Blue

Fir Textil Varivas Pe 8 Blue Edition 150m 0.128mm 13lb Fluo Ocean Blue

v18415006
Livrare 48-72 ore

129,90Lei

Sapca Varivas Breathable Mash Cap Purple

Sapca Varivas Breathable Mash Cap Purple

vac71pu
Livrare 48-72 ore

149,90Lei

Fir Varivas Trout Flash Orange, 100m, 0.205mm, 6lb

Fir Varivas Trout Flash Orange, 100m, 0.205mm, 6lb

v5610015
Livrare 48-72 ore

42,90Lei

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

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

vc13sta07
Livrare 48-72 ore

25,89Lei

Fir Textil Varivas FIR MAX POWER PE X8 150m 20.2lb 0.165mm Lime Green Fluo

Fir Textil Varivas FIR MAX POWER PE X8 150m 20.2lb 0.165mm Lime Green Fluo

v30015010
Livrare imediată!

165,90Lei

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO 1X 30m 0.260mm 11.7lb

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO 1X 30m 0.260mm 11.7lb

v7301x
Livrare 48-72 ore

79,90Lei

Afişare 1 - 20 din 483 (25 pagini)
Queries: 7, Total time: 74.323 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '11e8149fd552861562cbf3eed0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Varivas'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.096)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (38.828)
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 = '2' AND p.manufacturer_id = '50'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (34.998)
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 = '2' 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.103)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37