Varivas


Fir Textil Varivas FIR HIGH GRADE PE X4 MILKY PINK 150m 0.185mm 21lb

Fir Textil Varivas FIR HIGH GRADE PE X4 MILKY PINK 150m 0.185mm 21lb

v20815012
Livrare 48-72 ore

92,90Lei

Fir Textil Varivas AVANI EGING LS4 PE TIP RUN 200m 9lbs Marking Fluo Green

Fir Textil Varivas AVANI EGING LS4 PE TIP RUN 200m 9lbs Marking Fluo Green

v16720005
Livrare 48-72 ore

213,90Lei

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll NYLON 8X 50m 0.090mm 1.8lb

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll NYLON 8X 50m 0.090mm 1.8lb

v7508x
Livrare 48-72 ore

59,90Lei

Fir Textil Varivas Pe 8 Blue Edition 150m 0.165mm 20lb Fluo Ocean Blue

Fir Textil Varivas Pe 8 Blue Edition 150m 0.165mm 20lb Fluo Ocean Blue

v18415010
Livrare 48-72 ore

129,90Lei

Fir Textil Varivas Fune PE X8 Multicolor High Visibility, 150m, 0.128mm, 6kg

Fir Textil Varivas Fune PE X8 Multicolor High Visibility, 150m, 0.128mm, 6kg

v17015006
Livrare imediată!

115,00Lei

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

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

vc13sta08
Livrare 48-72 ore

25,89Lei

Fir Textil Varivas FIR MAX POWER PE X8 150m 24.1lb 0.185mm Lime Green Fluo

Fir Textil Varivas FIR MAX POWER PE X8 150m 24.1lb 0.185mm Lime Green Fluo

v30015012
Livrare imediată!

165,90Lei

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO 3X 30m 0.205mm 7.5lb

FIR MONOFILAMENT FLY VARIVAS SUPER TIPPET MASTER SPEC ll FLUORO 3X 30m 0.205mm 7.5lb

v7303x
Livrare 48-72 ore

79,90Lei

Fir Textil Varivas Pe 4 Blue Edition 150m 0.218mm 30lb Water Blue

Fir Textil Varivas Pe 4 Blue Edition 150m 0.218mm 30lb Water Blue

v18215020
Livrare 48-72 ore

77,90Lei

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

182,90Lei

Carlige Varivas Under Shot Twist Standard Hooks, Nr.4, 10buc/pac

Carlige Varivas Under Shot Twist Standard Hooks, Nr.4, 10buc/pac

v013088
Livrare imediată!

11,50Lei

Varivas CARLIGE OFFSET NOGALES SECOND BITE HEAVY CLASS NR 2/0 6buc/plic

Varivas CARLIGE OFFSET NOGALES SECOND BITE HEAVY CLASS NR 2/0 6buc/plic

vc95sbh2/0
Livrare 48-72 ore

15,90Lei

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

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

v29820006
Livrare 48-72 ore

270,90Lei

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

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

v5208003
Livrare 48-72 ore

42,90Lei

Fir Textil Varivas Bass PE X4 Flash Green, 150m, 0.218mm, 30lb -23%

Fir Textil Varivas Bass PE X4 Flash Green, 150m, 0.218mm, 30lb

v18515020
Livrare imediată!

108,00Lei(-23%) 82,90Lei

Fir Textil Varivas Super Trout Area PE X4, Neo Yellow, 0.30mm, 6.7lbs, 75m

Fir Textil Varivas Super Trout Area PE X4, Neo Yellow, 0.30mm, 6.7lbs, 75m

v47075030
Livrare 48-72 ore

138,90Lei

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

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

v030009
Livrare 48-72 ore

14,90Lei

Carlige Varivas Super Trout Area Tornament Canvas Multi Player Small, Nr.9, 15buc/pac

Carlige Varivas Super Trout Area Tornament Canvas Multi Player Small, Nr.9, 15buc/pac

v125972
Livrare 48-72 ore

25,89Lei

Fir Textil Varivas FIR AVANI JIGGING POWER BRAID PE X4 300m 56lb 10mx5 Culori

Fir Textil Varivas FIR AVANI JIGGING POWER BRAID PE X4 300m 56lb 10mx5 Culori

v29320040
Livrare 48-72 ore

274,90Lei

Fir Textil Varivas AVANI GT MAX POWER PLUS PE X8 200m 0.570mm 150lb / 68.04kg Orange

Fir Textil Varivas AVANI GT MAX POWER PLUS PE X8 200m 0.570mm 150lb / 68.04kg Orange

v62200120
Livrare 48-72 ore

384,91Lei

Afişare 1 - 20 din 483 (25 pagini)
Queries: 7, Total time: 66.527 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = 'ec02997b35a85c45bfbe59d9a7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.071)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.092)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Varivas'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.115)
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 (31.172)
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.826)
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.145)
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