Varivas


Fir Textil Varivas Absolute Premium PE X8 Marking Green, 150m, 0.235mm, 37lb

Fir Textil Varivas Absolute Premium PE X8 Marking Green, 150m, 0.235mm, 37lb

v23515020
Livrare 48-72 ore

206,00Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 1/0 8buc/plic

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 1/0 8buc/plic

vc97hmh1/0
Livrare 48-72 ore

17,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,00Lei

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

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

v16615006
Livrare 48-72 ore

150,00Lei

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO 6X 30m 0.128mm 3.5lb -30%

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO 6X 30m 0.128mm 3.5lb

v7306x
Livrare imediată!

79,00Lei(-30%) 55,00Lei

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

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

v6515010
Livrare 48-72 ore

199,00Lei

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

177,00Lei

Fir Textil Varivas Super Trout Area PE X4 Tournament, Pink, 0.15mm, 4lbs, 75m

Fir Textil Varivas Super Trout Area PE X4 Tournament, Pink, 0.15mm, 4lbs, 75m

v48075015
Livrare 48-72 ore

220,99Lei

Fir Textil Varivas FIR MAX POWER PE X8 150m 14.5lb 0.128mm Lime Green Fluo -20%

Fir Textil Varivas FIR MAX POWER PE X8 150m 14.5lb 0.128mm Lime Green Fluo

v30015006
Livrare 48-72 ore

183,00Lei(-20%) 146,41Lei

SAPCA VARIVAS PU LEATHER MESH BLACK

SAPCA VARIVAS PU LEATHER MESH BLACK

vac68bl
Livrare 48-72 ore

177,00Lei

Fir Textil Varivas PE 8 Marking Edition 150m 0.165mm 20lb Vivid 5 Color

Fir Textil Varivas PE 8 Marking Edition 150m 0.165mm 20lb Vivid 5 Color

v18315010
Livrare 48-72 ore

159,00Lei

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

249,00Lei

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

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

vca12zf12
Livrare 48-72 ore

31,00Lei

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

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

v29620015
Livrare 48-72 ore

148,00Lei

Fir Textil Varivas SALTWATER FINESSE PE X8 150m 9.2lb 4.17kg

Fir Textil Varivas SALTWATER FINESSE PE X8 150m 9.2lb 4.17kg

v4615004
Livrare 48-72 ore

404,01Lei

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

165,01Lei

Fir Textil Varivas PE 4 Marking Edition 150m 0.218mm 30lb Vivid 5 Color

Fir Textil Varivas PE 4 Marking Edition 150m 0.218mm 30lb Vivid 5 Color

v18115020
Livrare 48-72 ore

99,00Lei

Sapca Varivas Breathable Mash Cap Black

Sapca Varivas Breathable Mash Cap Black

vac71bl
Livrare 48-72 ore

179,00Lei

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

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

v5610015
Livrare 48-72 ore

42,00Lei

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

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

vc97hmm6/0
Livrare imediată!

20,00Lei

Afişare 41 - 60 din 507 (26 pagini)
Queries: 9, Total time: 63.859 ms [By time] [By id] [By file]
1 (0.142)
SELECT data
FROM `oc_session`
WHERE session_id = '42ffddc7d1062c106616642664'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.136)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Varivas'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.131)
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
6 (28.413)
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:1650
7 (34.665)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.085)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.073)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38